Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK10000
Product: Project Accounting (258)
Series:
Display Name: PDK Timesheet HDR
Physical Name: PDK10000
Technical Name: PDK_Timesheet_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PDK_Timesheet_TRX_Type 
PDK Timesheet TRX Type Integer PDK_DDL_Trx_Type 0 2 PDK_TS_No PDK TS No. String PDK_Document_Number 30 3 PDK_Ref_Doc_No PDK Reference Document No. String PDK_Document_Number 30 4 PDK_Document_Status PDK Document Status Integer PDK_DDL_Document_Status 0 5 PDK_Trx_Source PDK Trx Source Integer INT1 1 6 PDK_Remote_Change PDK Remote Change Boolean Boolean 0 7 PADOCDT PA Document Date Date PA_Date 8 8 PAYR PA Year Integer INT4 4 9 EMPLOYID Employee ID String STR15_Employee_ID 15 10 PAREPD PA Reporting Period Integer INT3 3 11 PA_Employed_By PA Employed By Integer PA_DDL_Employed_By 0 12 PAREPDT PA Reporting Date Date PA_Date 8 13 PAPeriodEndDate PA Period End Date Date DATE 6 14 PACOMM PA Comment String STR50 50 15 PAUD1 PA User Defined 1 String STR20 20 16 PAUD2 PA User Defined 2 String STR20 20 17 PDK_Total_Quantity PDK Total Quantity Currency PDK_DLR19_RBS0 19 18 PAtotcosts PA Total Costs Currency PA_DLR17_RBS0_STR$ 17 19 PATACRV PA Total Accrued Revenues Currency DLR17_RBS0_UTR$ 17 20 NOTEID Note ID String STR30 30 21 PDK_Reporting_Suffix PDK Reporting Suffix String PA_STR5 5 22 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 23 MANAGER Manager String STR15_Employee_ID 15 24 Manager_Approval_Status Manager Approval Status Integer PDK_Document_Approval_Status 0 25 SUPERVISOR Supervisor String STR30 30 26 Sup_Approval_Status Supervisor Approval Status Integer PDK_Document_Approval_Status 0 27 Administrator Administrator String STR15_Employee_ID 15 28 Admin_Approval_Status Admin Approval Status Integer PDK_Document_Approval_Status 0 29 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PDK Timesheet HDR'].CURNCYID AS 'PDK Timesheet HDR-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PDK10000 AS ['PDK Timesheet HDR']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PDK Timesheet HDR'].CURNCYID = ['Currency Setup'].CURNCYID30 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PDK Timesheet HDR'].CURRNIDX AS 'PDK Timesheet HDR-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PDK10000 AS ['PDK Timesheet HDR']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PDK Timesheet HDR'].CURRNIDX = ['Currency Setup'].CURRNIDX31 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 HDR'].RATETPID AS 'PDK Timesheet HDR-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PDK10000 AS ['PDK Timesheet HDR']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PDK Timesheet HDR'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID32 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 HDR'].EXGTBLID AS 'PDK Timesheet HDR-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PDK10000 AS ['PDK Timesheet HDR']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PDK Timesheet HDR'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID33 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 34 EXCHDATE Exchange Date Date DT_Date 6 35 TIME1 Time Time TM6 6 36 RTCLCMTD Rate Calculation Method Integer GB 0 37 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 38 MCTRXSTT MC Transaction State Integer INT1 1 39 PAORIGTOTCOSTS PA Originating Total Costs Currency DLR17_RBS0_UTR$ 17 40 PAORIACCRREV PA Originating Accrued Revenues Currency DLR17_RBS0_UTR$ 17 41 PATSNO PA Timesheet No. String STR17_LBAU 17 42 PAREFNO PA Reference Document No. String STR17_LBAU 17 43 PDK_Proxy_ID PDK Proxy ID String STR15_Employee_ID 15 44 PDK_TS_App_Update PDK TS App Update Integer PDK_DDL_TS_App_Update 0 45 MODIFDT Modified Date Date DT 8 46 Modified_Time Modified Time Time TM6 6 47 APRVLUSERID Approval User ID String STR15_User_ID 15 48 APPRVLDT Approval Date Date DATE 6