PTE_Timesheet_LINE_HIST (PTE30101)

azurecurveProductsProject Accounting (258)ProjectPTE_Timesheet_LINE_HIST (PTE30101)

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

Product: Project Accounting (258)
Series:

Display Name: PTE_Timesheet_LINE_HIST
Physical Name: PTE30101
Technical Name: PTE_Timesheet_LINE_HIST

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PTE_Timesheet_Number SearchPTE Timesheet NumberStringSTR30_Item_Number30
2EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
3PADT SearchPA DateDatePA_Date8
4PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
5PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
6PATB SearchPA Time BeginTimeTM66
7PATE SearchPA Time EndTimeTM66
8PTE_Quantity SearchPTE QuantityCurrencyPA_DLR15_RBS0_STR15
9PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
10PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
11UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PTE_Timesheet_LINE_HIST'].UOMSCHDL AS 'PTE_Timesheet_LINE_HIST-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PTE30101 AS ['PTE_Timesheet_LINE_HIST']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PTE_Timesheet_LINE_HIST'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
12PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
13PAOrigUnitCost SearchPA Originating Unit CostCurrencyDLR17_RBS0_STR$17
14PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
15PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
16PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
17OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
18PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
19PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
20PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
21PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
22PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
23PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
24PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
25PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
26PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
27PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
28PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
29PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
30PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
31PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
32PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
33PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
34PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
35PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
36PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
37LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
38PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
39PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
40PAPayCode SearchPA Pay CodeStringSTR6_Payroll_Code6
41PASalary_Posting_Type SearchPA Salary Posting TypeIntegerGB0
42PAJob_Title SearchPA Job TitleStringSTR6_Payroll_Code6
43PADepartment SearchPA DepartmentStringSTR6_Payroll_Code6
44STATECD SearchState CodeStringSTR2_State_Code2
45LOCLCODE SearchLocal CodeStringSTR6_Payroll_Code6
46SUTASTAT SearchSuta StateStringSTR2_State_Code2
47WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
48PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
49PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
50PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
51PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
52PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
53PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
54PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
55PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
56PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
57PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
58PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
59PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
60PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
61CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PTE_Timesheet_LINE_HIST'].CURRNIDX AS 'PTE_Timesheet_LINE_HIST-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PTE30101 AS ['PTE_Timesheet_LINE_HIST']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PTE_Timesheet_LINE_HIST'].CURRNIDX = ['Currency Setup'].CURRNIDX
62RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

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

Click to show/hide

SELECT
       ['PTE_Timesheet_LINE_HIST'].EXGTBLID AS 'PTE_Timesheet_LINE_HIST-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PTE30101 AS ['PTE_Timesheet_LINE_HIST']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PTE_Timesheet_LINE_HIST'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
64XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
65EXCHDATE SearchExchange DateDateDT_Date6
66TIME1 SearchTimeTimeTM66
67RTCLCMTD SearchRate Calculation MethodIntegerGB0
68DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
69MCTRXSTT SearchMC Transaction StateIntegerINT11
azurecurveProductsProject Accounting (258)ProjectPTE_Timesheet_LINE_HIST (PTE30101)

Leave a Reply

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