PA Timesheet Detail File (PA10001)

azurecurveProductsProject Accounting (258)ProjectPA Timesheet Detail File (PA10001)

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

Product: Project Accounting (258)
Series:

Display Name: PA Timesheet Detail File
Physical Name: PA10001
Technical Name: PA_Timesheet_WORK_LINE

Group Display Name: PA Timesheet Transactions
Group Technical Name: PA Timesheet Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PATSTYP SearchPA Timesheet TRX TypeIntegerPA_DDL_TS_Trx_Typ0
2PATSNO SearchPA Timesheet No.StringSTR17_LBAU17
3PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
4EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
5PADT SearchPA DateDatePA_Date8
6PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
7PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
8PATB SearchPA Time BeginTimeTM66
9PATE SearchPA Time EndTimeTM66
10PAQtyQ SearchPA QuantityCurrencyPA_DLR15_RBS0_STR15
11PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
12PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
13UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Timesheet Detail File'].UOMSCHDL AS 'PA Timesheet Detail File-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA10001 AS ['PA Timesheet Detail File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Timesheet Detail File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
14PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
15PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
16ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
17PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
18PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
19PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
20OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
21PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
22PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
23PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
24PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
25PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
26PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
27PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
28PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
29PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
30PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
31PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
32PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
33PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
34PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
35PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
36PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
37PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
38PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
39PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
40LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
41PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
42PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
43PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
44PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
45PAPayCode SearchPA Pay CodeStringSTR6_Payroll_Code6
46PASalary_Posting_Type SearchPA Salary Posting TypeIntegerGB0
47PAJob_Title SearchPA Job TitleStringSTR6_Payroll_Code6
48PADepartment SearchPA DepartmentStringSTR6_Payroll_Code6
49PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
50PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
51PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
52PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
53PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
54PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
55STATECD SearchState CodeStringSTR2_State_Code2
56LOCLCODE SearchLocal CodeStringSTR6_Payroll_Code6
57SUTASTAT SearchSuta StateStringSTR2_State_Code2
58WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
59PAexptdate SearchPA Export DateDatePA_Date8
60PATS_Line_Errors SearchPA TS Line ErrorsLong IntegerPA_ML_TS_Line_Errors_10
61PATSLINEERR2 SearchPA TS Line Errors 2Long IntegerPA_ML_TS_Line_Errors_20
62PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
63PAAPPROVBILLRATE SearchPA Approved Billing RateCurrencyDLR17_RBS0_UTR$17
64PAAPPROVMKUPPCT SearchPA Approved Markup PercentageCurrencyDLR5_%28
65PAApproved_Billing_Amou SearchPA Approved Billing AmountCurrencyDLR17_RBSO_STR$17
66PABilledProfitPercentage SearchPA Billed Profit Percentage AverageCurrencyDLR5_%28
67PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageCurrencyDLR17_RBS0_UTR$17
68PABilled_Amount SearchPA Billed AmountCurrencyDLR17_RBS0_UTR$17
69PABilledTax SearchPA Billed TaxCurrencyDLR17_RBS0_STR$17
70PABilled_Misc SearchPA Billed MiscCurrencyDLR17_RBS0_UTR$17
71PABilled_Freight SearchPA Billed FreightCurrencyDLR17_RBS0_UTR$17
72PABilled_Discount SearchPA Billed DiscountCurrencyDLR17_RBS0_UTR$17
73PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
74PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentageLong IntegerPA_LI5_%2S5
75PAApprover_ID SearchPA Approver IDStringSTR1515
76PABilled_QtyN SearchPA Billed QtyCurrencyPA_DLR15_RBS0_STR15
77PAApprover_Type SearchPA Approver TypeIntegerDDL_Approver_Type0
78PAPartial_Bill SearchPA Partial BillBooleanCB0
79PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
80PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
81PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLong IntegerLI_1414
82PACogs_Idx SearchPA COGS IDXLong IntegerLI_1414
83PAContra_Account_IDX SearchPA Contra Account IDXLong IntegerLI_1414
84PAOverhead_IDX SearchPA Overhead IDXLong IntegerLI_1414
85PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLong IntegerLI_1414
86RNDDIFF SearchRounding DifferenceLong IntegerLI_1414
87PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
88PACBADDFRMFLY SearchPA CB From Add On The FlyBooleanCB0
89PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
90PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
91PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
92PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
93CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

SELECT
       ['PA Timesheet Detail File'].CURRNIDX AS 'PA Timesheet Detail File-Currency Index'
       ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
       PA10001 AS ['PA Timesheet Detail File']
INNER JOIN
       DYNAMICS..MC40200 AS ['Currency Setup']
              ON
                     ['PA Timesheet Detail File'].CURRNIDX = ['Currency Setup'].CURRNIDX
94RATETPID SearchRate Type IDStringSTR15_Rate_Type_ID15
Key to the Multicurrency Rate Type Setup (MC40100).

Click to show/hide

SELECT
       ['PA Timesheet Detail File'].RATETPID AS 'PA Timesheet Detail File-Rate Type ID'
       ,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
       PA10001 AS ['PA Timesheet Detail File']
INNER JOIN
       MC40100 AS ['Multicurrency Rate Type Setup']
              ON
                     ['PA Timesheet Detail File'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID
95EXGTBLID SearchExchange Table IDStringSTR15_Exchange_Table_ID15
Key to the Multicurrency Exchange Rate Maintenance (MC00100).

Click to show/hide

SELECT
       ['PA Timesheet Detail File'].EXGTBLID AS 'PA Timesheet Detail File-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PA10001 AS ['PA Timesheet Detail File']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PA Timesheet Detail File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
96XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
97EXCHDATE SearchExchange DateDateDT_Date6
98TIME1 SearchTimeTimeTM66
99RATECALC SearchRate Calc MethodIntegerINT0
100DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
101MCTRXSTT SearchMC Transaction StateIntegerINT11
102Correcting_Trx_Type SearchCorrecting Trx TypeIntegerINT0
103PAORIGINLDOCNUM SearchPA Original Document NumberStringSTR17_LBAU17
104PAORIGLINEIMSEQ SearchPA Original Line Item SequenceLong IntegerLI_Sequence_Number10
azurecurveProductsProject Accounting (258)ProjectPA Timesheet Detail File (PA10001)

Leave a Reply

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