Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE00300
Product: Project Accounting (258)
Series:
Display Name: PTE Timesheet Template Header
Physical Name: PTE00300
Technical Name: PTE_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 PAREPD PA Reporting Period Integer INT3 3 3 PAREPDT PA Reporting Date Date PA_Date 8 4 PACOMM PA Comment String STR50 50 5 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE Timesheet Template Header'].CURNCYID AS 'PTE Timesheet Template Header-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PTE00300 AS ['PTE Timesheet Template Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE Timesheet Template Header'].CURNCYID = ['Currency Setup'].CURNCYID6 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE Timesheet Template Header'].CURRNIDX AS 'PTE Timesheet Template Header-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PTE00300 AS ['PTE Timesheet Template Header']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE Timesheet Template Header'].CURRNIDX = ['Currency Setup'].CURRNIDX7 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['PTE Timesheet Template Header'].RATETPID AS 'PTE Timesheet Template Header-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PTE00300 AS ['PTE Timesheet Template Header']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PTE Timesheet Template Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID8 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['PTE Timesheet Template Header'].EXGTBLID AS 'PTE Timesheet Template Header-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PTE00300 AS ['PTE Timesheet Template Header']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PTE Timesheet Template Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID9 RTCLCMTD Rate Calculation Method Integer GB 0