Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PDK00300
Product: Project Accounting (258)
Series:
Display Name: PDK Timesheet Template Header
Physical Name: PDK00300
Technical Name: PDK_Timesheet_Template_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 EMPLOYID Employee ID String STR15_Employee_ID 15 2 PAREPDT PA Reporting Date Date PA_Date 8 3 PAREPD PA Reporting Period Integer INT3 3 4 PACOMM PA Comment String STR50 50 5 PAUD1 PA User Defined 1 String STR20 20 6 PAUD2 PA User Defined 2 String STR20 20 7 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PDK Timesheet Template Header'].CURNCYID AS 'PDK Timesheet Template Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PDK00300 AS ['PDK Timesheet Template Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PDK Timesheet Template Header'].CURNCYID = ['Currency Setup'].CURNCYID
8 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PDK Timesheet Template Header'].CURRNIDX AS 'PDK Timesheet Template Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PDK00300 AS ['PDK Timesheet Template Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PDK Timesheet Template Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
9 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 Header'].RATETPID AS 'PDK Timesheet Template Header-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PDK00300 AS ['PDK Timesheet Template Header']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PDK Timesheet Template Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
10 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 Header'].EXGTBLID AS 'PDK Timesheet Template Header-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PDK00300 AS ['PDK Timesheet Template Header']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PDK Timesheet Template Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
11 RTCLCMTD Rate Calculation Method Integer GB 0