PA Employee Expense Detail File (PA10501)

azurecurveProductsProject Accounting (258)ProjectPA Employee Expense Detail File (PA10501)

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

Product: Project Accounting (258)
Series:

Display Name: PA Employee Expense Detail File
Physical Name: PA10501
Technical Name: PA_Employee_Expense_WORK_LINE

Group Display Name: PA Employee Expense Transactions
Group Technical Name: PA Employee Expense Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PAertrxtype SearchPA Empl Expense TRX TypeIntegerPA_DDL_EE_Trx_Typ0
2PAerdocnumber SearchPA Empl Expense Document No.StringSTR30_LBAU30
3PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
4EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
5PADT SearchPA DateDatePA_Date8
6PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
7PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
8PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
9PAitemnumber SearchPA Item NumberStringSTR3030
10PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
11PAQtyQ SearchPA QuantityCurrencyPA_DLR15_RBS0_STR15
12PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
13PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
14UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Employee Expense Detail File'].UOMSCHDL AS 'PA Employee Expense 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
       PA10501 AS ['PA Employee Expense Detail File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Employee Expense Detail File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
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
21PAtotcosts SearchPA Total CostsCurrencyPA_DLR17_RBS0_STR$17
22PAORIGTOTCOSTS SearchPA Originating Total CostsCurrencyDLR17_RBS0_UTR$17
23PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
24PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
25PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
26PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
27PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
28PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
29PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
30PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
31PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
32PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
33PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
34PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
35PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
36PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
37PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
38PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
39PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
40PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
41PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
42PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
43PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
44PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
45PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
46PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
47ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Employee Expense Detail File'].ITMTSHID AS 'PA Employee Expense Detail File-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA10501 AS ['PA Employee Expense Detail File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Employee Expense Detail File'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
48TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
49ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
50BCKTXAMT SearchBackout Tax AmountCurrencyDLR17_RBS0_UTR$17
51OBTAXAMT SearchOriginating Backout Tax AmountCurrencyDLR17_RBS0_UTR$17
52PAPaymentMethod SearchPA Payment MethodIntegerPA_DDL_Payment_Method0
53PAExpenseType SearchPA Expense TypeIntegerPA_DDL_Expense_Type0
54PAReimbursableAmount SearchPA Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
55PAOrigReimbursableAmt SearchPA Originating Reimbursable AmountCurrencyPA_DLR17_RBS0_STR$17
56PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
57PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLong IntegerLI_1414
58PACogs_Idx SearchPA COGS IDXLong IntegerLI_1414
59PAContra_Account_IDX SearchPA Contra Account IDXLong IntegerLI_1414
60PAOverhead_IDX SearchPA Overhead IDXLong IntegerLI_1414
61PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLong IntegerLI_1414
62LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
63PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
64PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
65PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
66PAexptdate SearchPA Export DateDatePA_Date8
67PA_EE_Line_Errors SearchPA EE Line ErrorsLong IntegerML_EE_Line_Errors0
68PA_EE_Line_Errors_2 SearchPA EE Line Errors 2Long IntegerPA_ML_EE_Line_Errors_20
69PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
70PAAPPROVBILLRATE SearchPA Approved Billing RateCurrencyDLR17_RBS0_UTR$17
71PAAPPROVMKUPPCT SearchPA Approved Markup PercentageCurrencyDLR5_%28
72PAApproved_Billing_Amou SearchPA Approved Billing AmountCurrencyDLR17_RBSO_STR$17
73PARemaining_Quantity SearchPA Remaining QuantityCurrencyPA_DLR15_RBS0_STR15
74PARemaining_Total_Cost SearchPA Remaining Total CostCurrencyDLR17_RBS0_UTR$17
75PARemaining_Accrued_Rev SearchPA Remaining Accrued RevenuesCurrencyPA_DLR17_RBS0_STR$17
76PABILLQTY SearchPA Billed Qty-OLDCurrencyDLR15_RBU215
77PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageCurrencyDLR17_RBS0_UTR$17
78PABilledProfitPercentage SearchPA Billed Profit Percentage AverageCurrencyDLR5_%28
79PABilled_Amount SearchPA Billed AmountCurrencyDLR17_RBS0_UTR$17
80PABilledTax SearchPA Billed TaxCurrencyDLR17_RBS0_STR$17
81PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
82PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentageLong IntegerPA_LI5_%2S5
83PAApprover_ID SearchPA Approver IDStringSTR1515
84PAApprover_Type SearchPA Approver TypeIntegerDDL_Approver_Type0
85PAPartial_Bill SearchPA Partial BillBooleanCB0
86PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
87RNDDIFF SearchRounding DifferenceLong IntegerLI_1414
88PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
89PACBADDFRMFLY SearchPA CB From Add On The FlyBooleanCB0
90PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
91PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
92PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
93PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
94CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

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

Leave a Reply

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