PTE Timesheet Header (PTE10000)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PTE10000

Product: Project Accounting (258)
Series:

Display Name: PTE Timesheet Header
Physical Name: PTE10000
Technical Name: PTE_Timesheet_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PTE_Timesheet_Number SearchPTE Timesheet NumberStringSTR30_Item_Number30
2PADOCDT SearchPA Document DateDatePA_Date8
3PAYR SearchPA YearIntegerINT44
4EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
5PAREPD SearchPA Reporting PeriodIntegerINT33
6PAREPDT SearchPA Reporting DateDatePA_Date8
7PAPeriodEndDate SearchPA Period End DateDateDATE6
8PACOMM SearchPA CommentStringSTR5050
9PTE_Total_Quantity SearchPTE Total QuantityCurrencyDLR17_QTY_RBS0_UTR17
10PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
11PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
12PATACRV SearchPA Total Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
13PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
14NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].NOTEINDX AS 'PTE Timesheet Header-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['PTE Timesheet Header'].NOTEINDX = ['Record Notes Master'].NOTEINDX
15CURNCYID SearchCurrency IDStringSTR15_Currency_ID15
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].CURNCYID AS 'PTE Timesheet Header-Currency ID'
       ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE Timesheet Header'].CURNCYID = ['Currency Setup'].CURNCYID
16CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].CURRNIDX AS 'PTE Timesheet Header-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE Timesheet Header'].CURRNIDX = ['Currency Setup'].CURRNIDX
17RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].RATETPID AS 'PTE Timesheet Header-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PTE Timesheet Header'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
18EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].EXGTBLID AS 'PTE Timesheet Header-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PTE Timesheet Header'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
19XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
20EXCHDATE SearchExchange DateDateDT_Date6
21TIME1 SearchTimeTimeTM66
22RTCLCMTD SearchRate Calculation MethodIntegerGB0
23DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
24MCTRXSTT SearchMC Transaction StateIntegerINT11
25PATSNO SearchPA Timesheet No.StringSTR17_LBAU17
26USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PTE Timesheet Header'].USERID AS 'PTE Timesheet Header-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       PTE10000 AS ['PTE Timesheet Header']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PTE Timesheet Header'].USERID = ['Users Master'].USERID
27Workflow_Status SearchWorkflow StatusIntegerWorkflow Status0
28SupervisorADLogin SearchSupervisor ADLoginStringSTR8585
29wfShowOverBudgetWarning SearchwfShowOverBudgetWarningLong IntegerwfShowOverBudgetWarning0

Leave a Reply

Your email address will not be published. Required fields are marked *