PA Miscellaneous Log Detail File (PA10201)

azurecurveProductsProject Accounting (258)ProjectPA Miscellaneous Log Detail File (PA10201)

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

Product: Project Accounting (258)
Series:

Display Name: PA Miscellaneous Log Detail File
Physical Name: PA10201
Technical Name: PA_Miscellaneous_Log_WORK_LINE

Group Display Name: PA Miscellaneous Transactions
Group Technical Name: PA Miscellaneous Transactions

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PSMISCLTRXTYPE SearchPA Miscellaneous Log TRX TypeIntegerPA_DDL_ML_Trx_Typ0
2PAMISCLDOCNO SearchPA Miscellaneous Log No.StringSTR17_LBAU17
3PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
4PSMISCID SearchPA Miscellaneous IDStringSTR15_Equipment_ID15
5PADT SearchPA DateDatePA_Date8
6PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
7PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
8PAQtyQ SearchPA 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
       ['PA Miscellaneous Log Detail File'].UOMSCHDL AS 'PA Miscellaneous Log 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
       PA10201 AS ['PA Miscellaneous Log Detail File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Miscellaneous Log Detail File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
12PAROUNDAMT SearchPA Round AmountCurrencyPA_DLR17_RBS0_STR$17
13PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
14ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
15PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
16PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
17PAEXTCOST SearchPA Extended CostCurrencyPA_DLR17_RBS0_STR$17
18OREXTCST SearchOriginating Extended CostCurrencyDLR17_RBS0_UTR$17
19PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
20PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
21PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
22PABaseOvhdCost SearchPA Base Overhead CostCurrencyDLR17_RBS0_UTR$17
23PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
24PAORIGBASEOVRHCST SearchPA Originating Base Overhead CostCurrencyDLR15_RBU$215
25PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
26PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
27PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
28PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
29PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
30PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
31PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
32PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
33PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
34PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
35PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
36PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
37PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
38LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
39PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
40PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
41PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
42PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
43PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
44PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
45PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
46PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
47PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
48PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
49PAexptdate SearchPA Export DateDatePA_Date8
50PAML_Line_Errors SearchPA ML Line ErrorsLong IntegerPA_ML_ML_Line_Errors_10
51PAMLLINEERR2 SearchPA ML Line Errors 2Long IntegerPA_ML_ML_Line_Errors_20
52PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
53PAAPPROVBILLRATE SearchPA Approved Billing RateCurrencyDLR17_RBS0_UTR$17
54PAAPPROVMKUPPCT SearchPA Approved Markup PercentageCurrencyDLR5_%28
55PAApproved_Billing_Amou SearchPA Approved Billing AmountCurrencyDLR17_RBSO_STR$17
56PABilledProfitPercentage SearchPA Billed Profit Percentage AverageCurrencyDLR5_%28
57PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageCurrencyDLR17_RBS0_UTR$17
58PABilled_Amount SearchPA Billed AmountCurrencyDLR17_RBS0_UTR$17
59PABilledTax SearchPA Billed TaxCurrencyDLR17_RBS0_STR$17
60PABilled_Misc SearchPA Billed MiscCurrencyDLR17_RBS0_UTR$17
61PABilled_Freight SearchPA Billed FreightCurrencyDLR17_RBS0_UTR$17
62PABilled_Discount SearchPA Billed DiscountCurrencyDLR17_RBS0_UTR$17
63PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
64PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentageLong IntegerPA_LI5_%2S5
65PAApprover_ID SearchPA Approver IDStringSTR1515
66PABilled_QtyN SearchPA Billed QtyCurrencyPA_DLR15_RBS0_STR15
67PAApprover_Type SearchPA Approver TypeIntegerDDL_Approver_Type0
68PAPartial_Bill SearchPA Partial BillBooleanCB0
69PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
70PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
71PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLong IntegerLI_1414
72PACogs_Idx SearchPA COGS IDXLong IntegerLI_1414
73PAContra_Account_IDX SearchPA Contra Account IDXLong IntegerLI_1414
74PAOverhead_IDX SearchPA Overhead IDXLong IntegerLI_1414
75PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLong IntegerLI_1414
76RNDDIFF SearchRounding DifferenceLong IntegerLI_1414
77PACHGORDNO SearchPA Change Order NumberStringSTR17_LBAU17
78PACBADDFRMFLY SearchPA CB From Add On The FlyBooleanCB0
79PAMCCURNCYID SearchPA MC Currency IDStringSTR15_Currency_ID15
80PA_MC_Billing_Rate SearchPA MC Billing RateCurrencyPA_DLR17_RBS0_UTR$17
81PA_MC_Base_Billing_Rate SearchPA MC Base Billing RateCurrencyPA_DLR17_RBS0_UTR$17
82PA_MC_Accrued_Revenue SearchPA MC Accrued RevenueCurrencyPA_DLR17_RBS0_UTR$17
83CURRNIDX SearchCurrency IndexIntegerINT33
Key to the Currency Setup (MC40200).

Click to show/hide

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

Click to show/hide

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

Click to show/hide

SELECT
       ['PA Miscellaneous Log Detail File'].EXGTBLID AS 'PA Miscellaneous Log Detail File-Exchange Table ID'
       ,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
       PA10201 AS ['PA Miscellaneous Log Detail File']
INNER JOIN
       DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
              ON
                     ['PA Miscellaneous Log Detail File'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID
86XCHGRATE SearchExchange RateCurrency (Variable)DLR14_Exchange_Rate14
87EXCHDATE SearchExchange DateDateDT_Date6
88TIME1 SearchTimeTimeTM66
89RATECALC SearchRate Calc MethodIntegerINT0
90DENXRATE SearchDenomination Exchange RateCurrency (Variable)DLR14_Exchange_Rate14
91MCTRXSTT SearchMC Transaction StateIntegerINT11
92Correcting_Trx_Type SearchCorrecting Trx TypeIntegerINT0
93PAORIGINLDOCNUM SearchPA Original Document NumberStringSTR17_LBAU17
94PAORIGLINEIMSEQ SearchPA Original Line Item SequenceLong IntegerLI_Sequence_Number10
azurecurveProductsProject Accounting (258)ProjectPA Miscellaneous Log Detail File (PA10201)

Leave a Reply

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