PTE Timesheet Template Line (PTE00301)

azurecurveProductsProject Accounting (258)ProjectPTE Timesheet Template Line (PTE00301)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE00301

Product: Project Accounting (258)
Series:

Display Name: PTE Timesheet Template Line
Physical Name: PTE00301
Technical Name: PTE_Timesheet_Template_LINE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2PADT SearchPA DateDatePA_Date8
3PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
4PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
5PATB SearchPA Time BeginTimeTM66
6PATE SearchPA Time EndTimeTM66
7PTE_Quantity SearchPTE QuantityCurrencyPA_DLR15_RBS0_STR15
8PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
9PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
10UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PTE Timesheet Template Line'].UOMSCHDL AS 'PTE Timesheet Template Line-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PTE00301 AS ['PTE Timesheet Template Line']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PTE Timesheet Template Line'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
11PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
12PAOrigUnitCost SearchPA Originating Unit CostCurrencyDLR17_RBS0_STR$17
13PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
14PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
15PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
16PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
17PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
18PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
19PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
20PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
21PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
22PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
23PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
24PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
25PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
26PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
27PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
28PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
29PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
30PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
31PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
32PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
33PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
34LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
35PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
36PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
37PAPayCode SearchPA Pay CodeStringSTR6_Payroll_Code6
38PASalary_Posting_Type SearchPA Salary Posting TypeIntegerGB0
39PAJob_Title SearchPA Job TitleStringSTR6_Payroll_Code6
40PADepartment SearchPA DepartmentStringSTR6_Payroll_Code6
41STATECD SearchState CodeStringSTR2_State_Code2
42LOCLCODE SearchLocal CodeStringSTR6_Payroll_Code6
43SUTASTAT SearchSuta StateStringSTR2_State_Code2
44WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
45PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
46PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
47PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
48PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
49PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
50PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
51PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
52PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
53PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
54PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
55PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
56PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
57CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE Timesheet Template Line'].CURRNIDX AS 'PTE Timesheet Template Line-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PTE00301 AS ['PTE Timesheet Template Line']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE Timesheet Template Line'].CURRNIDX = ['Currency Setup'].CURRNIDX
58RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PTE Timesheet Template Line'].RATETPID AS 'PTE Timesheet Template Line-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PTE00301 AS ['PTE Timesheet Template Line']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PTE Timesheet Template Line'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
59EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PTE Timesheet Template Line'].EXGTBLID AS 'PTE Timesheet Template Line-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PTE00301 AS ['PTE Timesheet Template Line']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PTE Timesheet Template Line'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
60XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
61EXCHDATE SearchExchange DateDateDT_Date6
62TIME1 SearchTimeTimeTM66
63RTCLCMTD SearchRate Calculation MethodIntegerGB0
64DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
65MCTRXSTT SearchMC Transaction StateIntegerINT11
azurecurveProductsProject Accounting (258)ProjectPTE Timesheet Template Line (PTE00301)

Leave a Reply

Your email address will not be published. Required fields are marked *