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_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID 
Employee ID String STR15_Employee_ID 15 2 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 3 PADT PA Date Date PA_Date 8 4 PACONTNUMBER PA Contract Number String STR10_LBAU 10 5 PAPROJNUMBER PA Project Number String STR15_LBAU 15 6 PACOSTCATID PA Cost Category ID String STR15_Cost_Category_ID 15 7 PATB PA Time Begin Time TM6 6 8 PATE PA Time End Time TM6 6 9 PDK_Quantity PDK Quantity Currency PA_DLR19_RBS2_U 19 10 PABase_Qty PA Base Qty Currency PA_DLR15_RBS0_STR 15 11 PAUnit_of_Measure PA Unit of Measure String U_Of_M 8 12 UOMSCHDL U Of M Schedule String STR10_Schedule 10 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'].UOMSCHDL13 PAUNITCOST PA Unit Cost Currency PA_DLR17_RBS0_UTR$ 17 14 ORUNTCST Originating Unit Cost Currency DLR17_RBS0_UTR$ 17 15 PABase_Unit_Cost PA Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 16 PAORGBSUNITCST PA Originating Base Unit Cost Currency PA_DLR17_RBS0_STR$ 17 17 PATOTCST PA Total Cost Currency PA_DLR17_RBS0_STR$ 17 18 PAORIGTOTCOST PA Originating Total Cost Currency PA_DLR17_RBS0_STR$ 17 19 PAOverhead_Amount PA Overhead Amount Currency DLR15_RBU$2 15 20 PAORIGOVHDAMT PA Originating Overhead Amount Currency DLR15_RBU$2 15 21 PABaseOvhdCost PA Base Overhead Cost Currency DLR17_RBS0_UTR$ 17 22 PAORIGBASEOVRHCST PA Originating Base Overhead Cost Currency DLR15_RBU$2 15 23 PAOverheaPercentage PA Overhead Percentage Currency DLR5_%2 8 24 PATOTALOVERH PA Total Overhead Currency DLR17_RBS0_UTR$ 17 25 PAORIGTOTOVRHD PA Originating Total Overhead Currency DLR17_RBS0_UTR$ 17 26 PA_Base_Billing_Rate PA Base Billing Rate Currency DLR17_RBS0_UTR$ 17 27 PAORIGBSBILLRTE PA Originating Base Billing Rate Currency DLR17_RBS0_UTR$ 17 28 PABILRATE PA Billing Rate Currency DLR17_RBS0_UTR$ 17 29 PAORIGBILLRATE PA Originating Billing Rate Currency DLR17_RBS0_UTR$ 17 30 PAMARKPERCENT PA Markup Percentage Currency DLR5_%2 8 31 PAACREV PA Accrued Revenues Currency DLR17_RBS0_UTR$ 17 32 PAORIACCRREV PA Originating Accrued Revenues Currency DLR17_RBS0_UTR$ 17 33 PASTD_Qty PA STD Qty Currency PA_DLR15_RBS0_STR 15 34 PANC_Qty PA NC Qty Currency PA_DLR15_RBS0_STR 15 35 PANB_Qty PA NB Qty Currency PA_DLR15_RBS0_STR 15 36 PAREFNO PA Reference Document No. String STR17_LBAU 17 37 PAReference_Line_Seq_N PA Reference Line Seq No Long Integer LI_Sequence_Number 10 38 PAbllngtype PA Billing Type Integer PA_DDL_Billing_Type 0 39 PAPayCode PA Pay Code String STR6_Payroll_Code 6 40 PASalary_Posting_Type PA Salary Posting Type Integer GB 0 41 PAJob_Title PA Job Title String STR6_Payroll_Code 6 42 PADepartment PA Department String STR6_Payroll_Code 6 43 STATECD State Code String STR2_State_Code 2 44 LOCLCODE Local Code String STR6_Payroll_Code 6 45 SUTASTAT Suta State String STR2_State_Code 2 46 WRKRCOMP Workers Comp String STR6_Payroll_Code 6 47 PAProfitAmount PA Profit Amount Currency DLR17_RBS0_UTR$ 17 48 PAORIGPROFAMT PA Originating Profit Amount Currency DLR17_RBS0_UTR$ 17 49 PAProfitPercent PA Profit Percent Currency DLR5_%2 8 50 PATotalProfit PA Total Profit Currency DLR17_RBS0_UTR$ 17 51 PAORIGTOTPROF PA Originating Total Profit Currency DLR17_RBS0_UTR$ 17 52 PAProfitType PA Profit Type Integer PA_DDL_Profit_Type 0 53 PABilling_StatusN PA Billing Status Integer DDL_Billing_Status 0 54 PDK_Billing_Note_ID PDK Billing Note ID String STR40 40 55 PAMCCURNCYID PA MC Currency ID String STR15_Currency_ID 15 56 PA_MC_Billing_Rate PA MC Billing Rate Currency PA_DLR17_RBS0_UTR$ 17 57 PA_MC_Base_Billing_Rate PA MC Base Billing Rate Currency PA_DLR17_RBS0_UTR$ 17 58 PA_MC_Accrued_Revenue PA MC Accrued Revenue Currency PA_DLR17_RBS0_UTR$ 17 59 CURRNIDX Currency Index Integer INT3 3 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'].CURRNIDX60 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 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'].RATETPID61 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 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'].EXGTBLID62 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 63 EXCHDATE Exchange Date Date DT_Date 6 64 TIME1 Time Time TM6 6 65 RATECALC Rate Calc Method Integer INT 0 66 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 67 MCTRXSTT MC Transaction State Integer INT1 1