PA Combined History Detail File (PA11801)

azurecurveProductsProject Accounting (258)ProjectPA Combined History Detail File (PA11801)

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

Product: Project Accounting (258)
Series:

Display Name: PA Combined History Detail File
Physical Name: PA11801
Technical Name: PA_Combined_History_WORK_LINE

Group Display Name: PA Combined History
Group Technical Name: PA Combined History

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PATU SearchPA Transaction UsageIntegerPA_DDL_Transaction_Usage0
2PADocnumber20 SearchPA Document No.StringSTR17_LBAU17
3PAREFNO SearchPA Reference Document No.StringSTR17_LBAU17
4PADT SearchPA DateDatePA_Date8
5PApurordnum SearchPA Purchase Order No.StringSTR17_LBAU17
6PACONTNUMBER SearchPA Contract NumberStringSTR10_LBAU10
7PAPROJNUMBER SearchPA Project NumberStringSTR15_LBAU15
8PACOSTCATID SearchPA Cost Category IDStringSTR15_Cost_Category_ID15
9PAContMgrID SearchPA Contract Manager IDStringSTR15_Employee_ID15
10PAitemnumber SearchPA Item NumberStringSTR3030
11EMPLOYID SearchEmployee IDStringSTR15_Employee_ID15
12PACOSTOWNER SearchPA Cost OwnerStringSTR30_Item_Number30
13CUSTNMBR SearchCustomer NumberStringSTR15_RM_Customer_Number15
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].CUSTNMBR AS 'PA Combined History Detail File-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['PA Combined History Detail File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
14PAprojmngrid SearchPA Project Manager IDStringSTR15_Employee_ID15
15PAProjectType SearchPA Project TypeIntegerPA_DDL_Project_Type0
16SLPRSNID SearchSalesperson IDStringSTR15_Salesperson_ID15
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].SLPRSNID AS 'PA Combined History Detail File-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['PA Combined History Detail File'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
17PATB SearchPA Time BeginTimeTM66
18PATE SearchPA Time EndTimeTM66
19PAconvtmints SearchPA Converted MinutesIntegerINT5_RU05
20PAbillnoteidx SearchPA Billing Note IndexCurrencyDLR1414
21PAQtyQ SearchPA QuantityCurrencyPA_DLR15_RBS0_STR15
22PABase_Qty SearchPA Base QtyCurrencyPA_DLR15_RBS0_STR15
23PAUnit_of_Measure SearchPA Unit of MeasureStringU_Of_M8
24UOMSCHDL SearchU Of M ScheduleStringSTR10_Schedule10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].UOMSCHDL AS 'PA Combined History 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
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Combined History Detail File'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
25PAUNITCOST SearchPA Unit CostCurrencyPA_DLR17_RBS0_UTR$17
26ORUNTCST SearchOriginating Unit CostCurrencyDLR17_RBS0_UTR$17
27PABase_Unit_Cost SearchPA Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
28PAORGBSUNITCST SearchPA Originating Base Unit CostCurrencyPA_DLR17_RBS0_STR$17
29PAOverhead_Amount SearchPA Overhead AmountCurrencyDLR15_RBU$215
30PAORIGOVHDAMT SearchPA Originating Overhead AmountCurrencyDLR15_RBU$215
31PAOverheaPercentage SearchPA Overhead PercentageCurrencyDLR5_%28
32PATOTALOVERH SearchPA Total OverheadCurrencyDLR17_RBS0_UTR$17
33PAORIGTOTOVRHD SearchPA Originating Total OverheadCurrencyDLR17_RBS0_UTR$17
34PATOTCST SearchPA Total CostCurrencyPA_DLR17_RBS0_STR$17
35PAORIGTOTCOST SearchPA Originating Total CostCurrencyPA_DLR17_RBS0_STR$17
36PAbllngtype SearchPA Billing TypeIntegerPA_DDL_Billing_Type0
37BKTPURAM SearchBackout Purchases AmountCurrencyDLR19_RBS0_UTR$19
38PABILRATE SearchPA Billing RateCurrencyDLR17_RBS0_UTR$17
39PAORIGBILLRATE SearchPA Originating Billing RateCurrencyDLR17_RBS0_UTR$17
40PA_Base_Billing_Rate SearchPA Base Billing RateCurrencyDLR17_RBS0_UTR$17
41PAORIGBSBILLRTE SearchPA Originating Base Billing RateCurrencyDLR17_RBS0_UTR$17
42PAMARKPERCENT SearchPA Markup PercentageCurrencyDLR5_%28
43PAACREV SearchPA Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
44PAORIACCRREV SearchPA Originating Accrued RevenuesCurrencyDLR17_RBS0_UTR$17
45PASTD_Qty SearchPA STD QtyCurrencyPA_DLR15_RBS0_STR15
46PANC_Qty SearchPA NC QtyCurrencyPA_DLR15_RBS0_STR15
47PASplit_NC SearchPA Split NC QtyCurrencyDLR15_RBU215
48PANB_Qty SearchPA NB QtyCurrencyPA_DLR15_RBS0_STR15
49PAPurchase_Tax_Options SearchPA Purchase Tax OptionsIntegerPA_DDL_Tax_Options_Purchase0
50ITMTSHID SearchItem Tax Schedule IDStringSTR15_LBAU15
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].ITMTSHID AS 'PA Combined History Detail File-Item Tax Schedule ID'
       ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
              ON
                     ['PA Combined History Detail File'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
51TRDISAMT SearchTrade Discount AmountCurrencyDLR17_RBS0_UTR$17
52FRTAMNT SearchFreight AmountCurrencyDLR17_RBS0_UTR$17
53MSCCHAMT SearchMisc Charges AmountCurrencyDLR17_RBS0_UTR$17
54TAXAMNT SearchTax AmountCurrencyDLR17_RBS0_UTR$17
55LNITMSEQ SearchLine Item SequenceLong IntegerLI_Sequence_Number10
56PAReference_Line_Seq_N SearchPA Reference Line Seq NoLong IntegerLI_Sequence_Number10
57PAexptdate SearchPA Export DateDatePA_Date8
58PABilling_StatusN SearchPA Billing StatusIntegerDDL_Billing_Status0
59PAUD1 SearchPA User Defined 1StringSTR2020
60PAUD2 SearchPA User Defined 2StringSTR2020
61PAprjclsid SearchPA Project Class IDStringSTR15_Project_Class_ID15
62CUSTCLAS SearchCustomer ClassStringSTR15_Customer_Class15
63PAcontclassid SearchPA Contract Class IDStringSTR15_Contract_Class_ID15
64PACOSTCATCLASID SearchPA Cost Category Class IDStringSTR15_Cost_Category_Class_ID15
65PAPayCode SearchPA Pay CodeStringSTR6_Payroll_Code6
66STATECD SearchState CodeStringSTR2_State_Code2
67LOCLCODE SearchLocal CodeStringSTR6_Payroll_Code6
68SUTASTAT SearchSuta StateStringSTR2_State_Code2
69WRKRCOMP SearchWorkers CompStringSTR6_Payroll_Code6
70PASalary_Posting_Type SearchPA Salary Posting TypeIntegerGB0
71PAJob_Title SearchPA Job TitleStringSTR6_Payroll_Code6
72PADepartment SearchPA DepartmentStringSTR6_Payroll_Code6
73PABilled_QtyN SearchPA Billed QtyCurrencyPA_DLR15_RBS0_STR15
74PABilledTax SearchPA Billed TaxCurrencyDLR17_RBS0_STR$17
75PABilled_Misc SearchPA Billed MiscCurrencyDLR17_RBS0_UTR$17
76PAProfitType SearchPA Profit TypeIntegerPA_DDL_Profit_Type0
77PAProfitAmount SearchPA Profit AmountCurrencyDLR17_RBS0_UTR$17
78PAORIGPROFAMT SearchPA Originating Profit AmountCurrencyDLR17_RBS0_UTR$17
79PAProfitPercent SearchPA Profit PercentCurrencyDLR5_%28
80PATotalProfit SearchPA Total ProfitCurrencyDLR17_RBS0_UTR$17
81PAORIGTOTPROF SearchPA Originating Total ProfitCurrencyDLR17_RBS0_UTR$17
82PAApproved_Quantity SearchPA Approved QuantityCurrencyPA_DLR15_RBS0_STR15
83PAAPPROVBILLRATE SearchPA Approved Billing RateCurrencyDLR17_RBS0_UTR$17
84PAAPPROVMKUPPCT SearchPA Approved Markup PercentageCurrencyDLR5_%28
85PAApproved_Billing_Amou SearchPA Approved Billing AmountCurrencyDLR17_RBSO_STR$17
86PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageCurrencyDLR17_RBS0_UTR$17
87PABilledProfitPercentage SearchPA Billed Profit Percentage AverageCurrencyDLR5_%28
88PABilled_Amount SearchPA Billed AmountCurrencyDLR17_RBS0_UTR$17
89PABilled_Freight SearchPA Billed FreightCurrencyDLR17_RBS0_UTR$17
90PABilled_Discount SearchPA Billed DiscountCurrencyDLR17_RBS0_UTR$17
91PAWrite_UpDown_Amount SearchPA Write Up/Down AmountCurrencyPA_DLR17_RBS0_STR$17
92PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentageLong IntegerPA_LI5_%2S5
93PAApprover_ID SearchPA Approver IDStringSTR1515
94PAApprover_Type SearchPA Approver TypeIntegerDDL_Approver_Type0
95PAPartial_Bill SearchPA Partial BillBooleanCB0
96PACGBWIPIDX SearchPA WIP IDXLong IntegerLI_1414
97PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLong IntegerLI_1414
98PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLong IntegerLI_1414
99PAOverhead_IDX SearchPA Overhead IDXLong IntegerLI_1414
100PAContra_Account_IDX SearchPA Contra Account IDXLong IntegerLI_1414
101PACogs_Idx SearchPA COGS IDXLong IntegerLI_1414
102PAPaymentMethod SearchPA Payment MethodIntegerPA_DDL_Payment_Method0
103PAExpenseType SearchPA Expense TypeIntegerPA_DDL_Expense_Type0
104LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].LOCNCODE AS 'PA Combined History Detail File-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['PA Combined History Detail File'].LOCNCODE = ['Site Setup'].LOCNCODE
105PRICELVL SearchPrice LevelStringSTR15_LBAU15
106IVIVINDX SearchIV IV IndexLong IntegerLI_1414
Key to the Account Index Master (GL00105).

Click to show/hide

SELECT
       ['PA Combined History Detail File'].IVIVINDX AS 'PA Combined History Detail File-IV IV Index'
       ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
       PA11801 AS ['PA Combined History Detail File']
INNER JOIN
       GL00105 AS ['Account Index Master']
              ON
                     ['PA Combined History Detail File'].IVIVINDX = ['Account Index Master'].ACTINDX
107IVIVOFAC_1 SearchIV IV Offset Account:Account_Segment_Pool1StringAccount_Segment_Pool16
108IVIVOFAC SearchIV IV Offset AccountAccount_NumberComposite 80
109IVIVOFAC_2 SearchIV IV Offset Account:Account_Segment_Pool2StringAccount_Segment_Pool26
110IVIVOFAC_3 SearchIV IV Offset Account:Account_Segment_Pool3StringAccount_Segment_Pool36
111IVIVOFAC_4 SearchIV IV Offset Account:Account_Segment_Pool4StringAccount_Segment_Pool46
112IVIVOFAC_5 SearchIV IV Offset Account:Account_Segment_Pool5StringAccount_Segment_Pool56
113IVIVOFAC_6 SearchIV IV Offset Account:Account_Segment_Pool6StringAccount_Segment_Pool66
114IVIVOFAC_7 SearchIV IV Offset Account:Account_Segment_Pool7StringAccount_Segment_Pool76
115IVIVOFAC_8 SearchIV IV Offset Account:Account_Segment_Pool8StringAccount_Segment_Pool86
116IVIVOFAC_9 SearchIV IV Offset Account:Account_Segment_Pool9StringAccount_Segment_Pool96
117IVIVOFAC_10 SearchIV IV Offset Account:Account_Segment_Pool10StringAccount_Segment_Pool106
azurecurveProductsProject Accounting (258)ProjectPA Combined History Detail File (PA11801)

Leave a Reply

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