Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE30100
Product: Project Accounting (258)
Series: Project
Display Name: PTE_Timesheet_HDR_HIST DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: PTE30100
Technical Name: PTE_Timesheet_HDR_HISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 PTE_Timesheet_Number 
PTE Timesheet Number STR30_Item_Number String 32 30 2 PADOCDT PA Document Date PA_Date Date 4 8 3 PAYR PA Year INT4 Integer 2 4 4 EMPLOYID Employee ID STR15_Employee_ID String 16 15 5 PAREPD PA Reporting Period INT3 Integer 2 3 6 PAREPDT PA Reporting Date PA_Date Date 4 8 7 PAPeriodEndDate PA Period End Date DATE Date 4 6 8 PACOMM PA Comment STR50 String 52 50 9 PTE_Total_Quantity PTE Total Quantity DLR17_QTY_RBS0_UTR Currency 10 17 10 PAtotcosts PA Total Costs PA_DLR17_RBS0_STR$ Currency 10 17 11 PAORIGTOTCOSTS PA Originating Total Costs DLR17_RBS0_UTR$ Currency 10 17 12 PATACRV PA Total Accrued Revenues DLR17_RBS0_UTR$ Currency 10 17 13 PAORIACCRREV PA Originating Accrued Revenues DLR17_RBS0_UTR$ Currency 10 17 14 NOTEINDX Note Index DLR14 Currency 10 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].NOTEINDX AS 'PTE_Timesheet_HDR_HIST-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PTE_Timesheet_HDR_HIST'].NOTEINDX = ['Record Notes Master'].NOTEINDX15 CURNCYID Currency ID STR15_Currency_ID String 16 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].CURNCYID AS 'PTE_Timesheet_HDR_HIST-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE_Timesheet_HDR_HIST'].CURNCYID = ['Currency Setup'].CURNCYID16 CURRNIDX Currency Index INT3 Integer 2 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].CURRNIDX AS 'PTE_Timesheet_HDR_HIST-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['PTE_Timesheet_HDR_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX17 RATETPID Rate Type ID STR15_Rate_Type_ID String 16 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].RATETPID AS 'PTE_Timesheet_HDR_HIST-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['PTE_Timesheet_HDR_HIST'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID18 EXGTBLID Exchange Table ID STR15_Exchange_Table_ID String 16 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].EXGTBLID AS 'PTE_Timesheet_HDR_HIST-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['PTE_Timesheet_HDR_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID19 XCHGRATE Exchange Rate DLR14_Exchange_Rate Currency (Variable) 10 14 20 EXCHDATE Exchange Date DT_Date Date 4 6 21 TIME1 Time TM6 Time 4 6 22 RTCLCMTD Rate Calculation Method GB Integer 2 0 23 DENXRATE Denomination Exchange Rate DLR14_Exchange_Rate Currency (Variable) 10 14 24 MCTRXSTT MC Transaction State INT1 Integer 2 1 25 PATSNO PA Timesheet No. STR17_LBAU String 18 17 26 USERID User ID STR15_User_ID String 16 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['PTE_Timesheet_HDR_HIST'].USERID AS 'PTE_Timesheet_HDR_HIST-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
PTE30100 AS ['PTE_Timesheet_HDR_HIST']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['PTE_Timesheet_HDR_HIST'].USERID = ['Users Master'].USERID27 Workflow_Status Workflow Status Workflow Status Integer 2 0 28 DEX_ROW_ID int int 10 10