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: Project

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 UsagePA_DDL_Transaction_UsageInteger0
2PADocnumber20 SearchPA Document No.STR17_LBAUString17
3PAREFNO SearchPA Reference Document No.STR17_LBAUString17
4PADT SearchPA DatePA_DateDate8
5PApurordnum SearchPA Purchase Order No.STR17_LBAUString17
6PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
7PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
8PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
9PAContMgrID SearchPA Contract Manager IDSTR15_Employee_IDString15
10PAitemnumber SearchPA Item NumberSTR30String30
11EMPLOYID SearchEmployee IDSTR15_Employee_IDString15
12PACOSTOWNER SearchPA Cost OwnerSTR30_Item_NumberString30
13CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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 IDSTR15_Employee_IDString15
15PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger0
16SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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 BeginTM6Time6
18PATE SearchPA Time EndTM6Time6
19PAconvtmints SearchPA Converted MinutesINT5_RU0Integer5
20PAbillnoteidx SearchPA Billing Note IndexDLR14Currency14
21PAQtyQ SearchPA QuantityPA_DLR15_RBS0_STRCurrency15
22PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency15
23PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString8
24UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
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 CostPA_DLR17_RBS0_UTR$Currency17
26ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency17
27PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency17
28PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency17
29PAOverhead_Amount SearchPA Overhead AmountDLR15_RBU$2Currency15
30PAORIGOVHDAMT SearchPA Originating Overhead AmountDLR15_RBU$2Currency15
31PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency8
32PATOTALOVERH SearchPA Total OverheadDLR17_RBS0_UTR$Currency17
33PAORIGTOTOVRHD SearchPA Originating Total OverheadDLR17_RBS0_UTR$Currency17
34PATOTCST SearchPA Total CostPA_DLR17_RBS0_STR$Currency17
35PAORIGTOTCOST SearchPA Originating Total CostPA_DLR17_RBS0_STR$Currency17
36PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger0
37BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency19
38PABILRATE SearchPA Billing RateDLR17_RBS0_UTR$Currency17
39PAORIGBILLRATE SearchPA Originating Billing RateDLR17_RBS0_UTR$Currency17
40PA_Base_Billing_Rate SearchPA Base Billing RateDLR17_RBS0_UTR$Currency17
41PAORIGBSBILLRTE SearchPA Originating Base Billing RateDLR17_RBS0_UTR$Currency17
42PAMARKPERCENT SearchPA Markup PercentageDLR5_%2Currency8
43PAACREV SearchPA Accrued RevenuesDLR17_RBS0_UTR$Currency17
44PAORIACCRREV SearchPA Originating Accrued RevenuesDLR17_RBS0_UTR$Currency17
45PASTD_Qty SearchPA STD QtyPA_DLR15_RBS0_STRCurrency15
46PANC_Qty SearchPA NC QtyPA_DLR15_RBS0_STRCurrency15
47PASplit_NC SearchPA Split NC QtyDLR15_RBU2Currency15
48PANB_Qty SearchPA NB QtyPA_DLR15_RBS0_STRCurrency15
49PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
50ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString15
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 AmountDLR17_RBS0_UTR$Currency17
52FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency17
53MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency17
54TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency17
55LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
56PAReference_Line_Seq_N SearchPA Reference Line Seq NoLI_Sequence_NumberLong Integer10
57PAexptdate SearchPA Export DatePA_DateDate8
58PABilling_StatusN SearchPA Billing StatusDDL_Billing_StatusInteger0
59PAUD1 SearchPA User Defined 1STR20String20
60PAUD2 SearchPA User Defined 2STR20String20
61PAprjclsid SearchPA Project Class IDSTR15_Project_Class_IDString15
62CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString15
63PAcontclassid SearchPA Contract Class IDSTR15_Contract_Class_IDString15
64PACOSTCATCLASID SearchPA Cost Category Class IDSTR15_Cost_Category_Class_IDString15
65PAPayCode SearchPA Pay CodeSTR6_Payroll_CodeString6
66STATECD SearchState CodeSTR2_State_CodeString2
67LOCLCODE SearchLocal CodeSTR6_Payroll_CodeString6
68SUTASTAT SearchSuta StateSTR2_State_CodeString2
69WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString6
70PASalary_Posting_Type SearchPA Salary Posting TypeGBInteger0
71PAJob_Title SearchPA Job TitleSTR6_Payroll_CodeString6
72PADepartment SearchPA DepartmentSTR6_Payroll_CodeString6
73PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency15
74PABilledTax SearchPA Billed TaxDLR17_RBS0_STR$Currency17
75PABilled_Misc SearchPA Billed MiscDLR17_RBS0_UTR$Currency17
76PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger0
77PAProfitAmount SearchPA Profit AmountDLR17_RBS0_UTR$Currency17
78PAORIGPROFAMT SearchPA Originating Profit AmountDLR17_RBS0_UTR$Currency17
79PAProfitPercent SearchPA Profit PercentDLR5_%2Currency8
80PATotalProfit SearchPA Total ProfitDLR17_RBS0_UTR$Currency17
81PAORIGTOTPROF SearchPA Originating Total ProfitDLR17_RBS0_UTR$Currency17
82PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency15
83PAAPPROVBILLRATE SearchPA Approved Billing RateDLR17_RBS0_UTR$Currency17
84PAAPPROVMKUPPCT SearchPA Approved Markup PercentageDLR5_%2Currency8
85PAApproved_Billing_Amou SearchPA Approved Billing AmountDLR17_RBSO_STR$Currency17
86PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageDLR17_RBS0_UTR$Currency17
87PABilledProfitPercentage SearchPA Billed Profit Percentage AverageDLR5_%2Currency8
88PABilled_Amount SearchPA Billed AmountDLR17_RBS0_UTR$Currency17
89PABilled_Freight SearchPA Billed FreightDLR17_RBS0_UTR$Currency17
90PABilled_Discount SearchPA Billed DiscountDLR17_RBS0_UTR$Currency17
91PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency17
92PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentagePA_LI5_%2SLong Integer5
93PAApprover_ID SearchPA Approver IDSTR15String15
94PAApprover_Type SearchPA Approver TypeDDL_Approver_TypeInteger0
95PAPartial_Bill SearchPA Partial BillCBBoolean0
96PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer14
97PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLI_14Long Integer14
98PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLI_14Long Integer14
99PAOverhead_IDX SearchPA Overhead IDXLI_14Long Integer14
100PAContra_Account_IDX SearchPA Contra Account IDXLI_14Long Integer14
101PACogs_Idx SearchPA COGS IDXLI_14Long Integer14
102PAPaymentMethod SearchPA Payment MethodPA_DDL_Payment_MethodInteger0
103PAExpenseType SearchPA Expense TypePA_DDL_Expense_TypeInteger0
104LOCNCODE SearchLocation CodeSTR10_Location_CodeString10
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 LevelSTR15_LBAUString15
106IVIVINDX SearchIV IV IndexLI_14Long Integer14
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 SearchIV IV Offset AccountAccount_NumberComposite 80
108IVIVOFAC_1 SearchIV IV Offset Account:Account_Segment_Pool1Account_Segment_Pool1String6
109IVIVOFAC_2 SearchIV IV Offset Account:Account_Segment_Pool2Account_Segment_Pool2String6
110IVIVOFAC_3 SearchIV IV Offset Account:Account_Segment_Pool3Account_Segment_Pool3String6
111IVIVOFAC_4 SearchIV IV Offset Account:Account_Segment_Pool4Account_Segment_Pool4String6
112IVIVOFAC_5 SearchIV IV Offset Account:Account_Segment_Pool5Account_Segment_Pool5String6
113IVIVOFAC_6 SearchIV IV Offset Account:Account_Segment_Pool6Account_Segment_Pool6String6
114IVIVOFAC_7 SearchIV IV Offset Account:Account_Segment_Pool7Account_Segment_Pool7String6
115IVIVOFAC_8 SearchIV IV Offset Account:Account_Segment_Pool8Account_Segment_Pool8String6
116IVIVOFAC_9 SearchIV IV Offset Account:Account_Segment_Pool9Account_Segment_Pool9String6
117IVIVOFAC_10 SearchIV IV Offset Account:Account_Segment_Pool10Account_Segment_Pool10String6
118DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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