PDK Timesheet Template LINE (PDK00301)

azurecurveProductsProject Accounting (258)ProjectPDK Timesheet Template LINE (PDK00301)

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

Product: Project Accounting (258)
Series:

Display Name: PDK Timesheet Template LINE
Physical Name: PDK00301
Technical Name: PDK_Timesheet_Template_LINE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
2LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
3PADT SearchPA DateDatePA_Date8
4PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
5PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
6PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
7PATB SearchPA Time BeginTimeTM66
8PATE SearchPA Time EndTimeTM66
9PDK_Quantity SearchPDK QuantityCurrencyPA_DLR19_RBS2_U19
10PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
11PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
12UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['PDK Timesheet Template LINE'].EXGTBLID AS 'PDK Timesheet Template LINE-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PDK00301 AS ['PDK Timesheet Template LINE']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PDK Timesheet Template LINE'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
62XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
63EXCHDATE SearchExchange DateDateDT_Date6
64TIME1 SearchTimeTimeTM66
65RATECALC SearchRate Calc MethodIntegerINT0
66DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
67MCTRXSTT SearchMC Transaction StateIntegerINT11
azurecurveProductsProject Accounting (258)ProjectPDK Timesheet Template LINE (PDK00301)

Leave a Reply

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