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 TypeSQL DB LengthKeyable Length
1PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
2PADocnumber20 SearchPA Document No.STR17_LBAUString1817
3PAREFNO SearchPA Reference Document No.STR17_LBAUString1817
4PADT SearchPA DatePA_DateDate48
5PApurordnum SearchPA Purchase Order No.STR17_LBAUString1817
6PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
7PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
8PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
9PAContMgrID SearchPA Contract Manager IDSTR15_Employee_IDString1615
10PAitemnumber SearchPA Item NumberSTR30String3230
11EMPLOYID SearchEmployee IDSTR15_Employee_IDString1615
12PACOSTOWNER SearchPA Cost OwnerSTR30_Item_NumberString3230
13CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
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_IDString1615
15PAProjectType SearchPA Project TypePA_DDL_Project_TypeInteger20
16SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
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 BeginTM6Time46
18PATE SearchPA Time EndTM6Time46
19PAconvtmints SearchPA Converted MinutesINT5_RU0Integer25
20PAbillnoteidx SearchPA Billing Note IndexDLR14Currency1014
21PAQtyQ SearchPA QuantityPA_DLR15_RBS0_STRCurrency1015
22PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
23PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString108
24UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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$Currency1017
26ORUNTCST SearchOriginating Unit CostDLR17_RBS0_UTR$Currency1017
27PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
28PAORGBSUNITCST SearchPA Originating Base Unit CostPA_DLR17_RBS0_STR$Currency1017
29PAOverhead_Amount SearchPA Overhead AmountDLR15_RBU$2Currency1015
30PAORIGOVHDAMT SearchPA Originating Overhead AmountDLR15_RBU$2Currency1015
31PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency108
32PATOTALOVERH SearchPA Total OverheadDLR17_RBS0_UTR$Currency1017
33PAORIGTOTOVRHD SearchPA Originating Total OverheadDLR17_RBS0_UTR$Currency1017
34PATOTCST SearchPA Total CostPA_DLR17_RBS0_STR$Currency1017
35PAORIGTOTCOST SearchPA Originating Total CostPA_DLR17_RBS0_STR$Currency1017
36PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger20
37BKTPURAM SearchBackout Purchases AmountDLR19_RBS0_UTR$Currency1019
38PABILRATE SearchPA Billing RateDLR17_RBS0_UTR$Currency1017
39PAORIGBILLRATE SearchPA Originating Billing RateDLR17_RBS0_UTR$Currency1017
40PA_Base_Billing_Rate SearchPA Base Billing RateDLR17_RBS0_UTR$Currency1017
41PAORIGBSBILLRTE SearchPA Originating Base Billing RateDLR17_RBS0_UTR$Currency1017
42PAMARKPERCENT SearchPA Markup PercentageDLR5_%2Currency108
43PAACREV SearchPA Accrued RevenuesDLR17_RBS0_UTR$Currency1017
44PAORIACCRREV SearchPA Originating Accrued RevenuesDLR17_RBS0_UTR$Currency1017
45PASTD_Qty SearchPA STD QtyPA_DLR15_RBS0_STRCurrency1015
46PANC_Qty SearchPA NC QtyPA_DLR15_RBS0_STRCurrency1015
47PASplit_NC SearchPA Split NC QtyDLR15_RBU2Currency1015
48PANB_Qty SearchPA NB QtyPA_DLR15_RBS0_STRCurrency1015
49PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
50ITMTSHID SearchItem Tax Schedule IDSTR15_LBAUString1615
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$Currency1017
52FRTAMNT SearchFreight AmountDLR17_RBS0_UTR$Currency1017
53MSCCHAMT SearchMisc Charges AmountDLR17_RBS0_UTR$Currency1017
54TAXAMNT SearchTax AmountDLR17_RBS0_UTR$Currency1017
55LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
56PAReference_Line_Seq_N SearchPA Reference Line Seq NoLI_Sequence_NumberLong Integer410
57PAexptdate SearchPA Export DatePA_DateDate48
58PABilling_StatusN SearchPA Billing StatusDDL_Billing_StatusInteger20
59PAUD1 SearchPA User Defined 1STR20String2220
60PAUD2 SearchPA User Defined 2STR20String2220
61PAprjclsid SearchPA Project Class IDSTR15_Project_Class_IDString1615
62CUSTCLAS SearchCustomer ClassSTR15_Customer_ClassString1615
63PAcontclassid SearchPA Contract Class IDSTR15_Contract_Class_IDString1615
64PACOSTCATCLASID SearchPA Cost Category Class IDSTR15_Cost_Category_Class_IDString1615
65PAPayCode SearchPA Pay CodeSTR6_Payroll_CodeString86
66STATECD SearchState CodeSTR2_State_CodeString42
67LOCLCODE SearchLocal CodeSTR6_Payroll_CodeString86
68SUTASTAT SearchSuta StateSTR2_State_CodeString42
69WRKRCOMP SearchWorkers CompSTR6_Payroll_CodeString86
70PASalary_Posting_Type SearchPA Salary Posting TypeGBInteger20
71PAJob_Title SearchPA Job TitleSTR6_Payroll_CodeString86
72PADepartment SearchPA DepartmentSTR6_Payroll_CodeString86
73PABilled_QtyN SearchPA Billed QtyPA_DLR15_RBS0_STRCurrency1015
74PABilledTax SearchPA Billed TaxDLR17_RBS0_STR$Currency1017
75PABilled_Misc SearchPA Billed MiscDLR17_RBS0_UTR$Currency1017
76PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger20
77PAProfitAmount SearchPA Profit AmountDLR17_RBS0_UTR$Currency1017
78PAORIGPROFAMT SearchPA Originating Profit AmountDLR17_RBS0_UTR$Currency1017
79PAProfitPercent SearchPA Profit PercentDLR5_%2Currency108
80PATotalProfit SearchPA Total ProfitDLR17_RBS0_UTR$Currency1017
81PAORIGTOTPROF SearchPA Originating Total ProfitDLR17_RBS0_UTR$Currency1017
82PAApproved_Quantity SearchPA Approved QuantityPA_DLR15_RBS0_STRCurrency1015
83PAAPPROVBILLRATE SearchPA Approved Billing RateDLR17_RBS0_UTR$Currency1017
84PAAPPROVMKUPPCT SearchPA Approved Markup PercentageDLR5_%2Currency108
85PAApproved_Billing_Amou SearchPA Approved Billing AmountDLR17_RBSO_STR$Currency1017
86PA_Billed_Profit_Amount_ SearchPA Billed Profit Amount AverageDLR17_RBS0_UTR$Currency1017
87PABilledProfitPercentage SearchPA Billed Profit Percentage AverageDLR5_%2Currency108
88PABilled_Amount SearchPA Billed AmountDLR17_RBS0_UTR$Currency1017
89PABilled_Freight SearchPA Billed FreightDLR17_RBS0_UTR$Currency1017
90PABilled_Discount SearchPA Billed DiscountDLR17_RBS0_UTR$Currency1017
91PAWrite_UpDown_Amount SearchPA Write Up/Down AmountPA_DLR17_RBS0_STR$Currency1017
92PAWrite_UpDown_Percenta SearchPA Write Up/Down PercentagePA_LI5_%2SLong Integer45
93PAApprover_ID SearchPA Approver IDSTR15String1615
94PAApprover_Type SearchPA Approver TypeDDL_Approver_TypeInteger20
95PAPartial_Bill SearchPA Partial BillCBBoolean20
96PACGBWIPIDX SearchPA WIP IDXLI_14Long Integer414
97PAUnbilled_AR_Idx SearchPA Unbilled AR IDXLI_14Long Integer414
98PAUnbilled_Proj_Rev_Idx SearchPA Unbilled Proj Rev IDXLI_14Long Integer414
99PAOverhead_IDX SearchPA Overhead IDXLI_14Long Integer414
100PAContra_Account_IDX SearchPA Contra Account IDXLI_14Long Integer414
101PACogs_Idx SearchPA COGS IDXLI_14Long Integer414
102PAPaymentMethod SearchPA Payment MethodPA_DDL_Payment_MethodInteger20
103PAExpenseType SearchPA Expense TypePA_DDL_Expense_TypeInteger20
104LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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_LBAUString1615
106IVIVINDX SearchIV IV IndexLI_14Long Integer414
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 8080
108IVIVOFAC_1 SearchIV IV Offset Account:Account_Segment_Pool1Account_Segment_Pool1String86
109IVIVOFAC_2 SearchIV IV Offset Account:Account_Segment_Pool2Account_Segment_Pool2String86
110IVIVOFAC_3 SearchIV IV Offset Account:Account_Segment_Pool3Account_Segment_Pool3String86
111IVIVOFAC_4 SearchIV IV Offset Account:Account_Segment_Pool4Account_Segment_Pool4String86
112IVIVOFAC_5 SearchIV IV Offset Account:Account_Segment_Pool5Account_Segment_Pool5String86
113IVIVOFAC_6 SearchIV IV Offset Account:Account_Segment_Pool6Account_Segment_Pool6String86
114IVIVOFAC_7 SearchIV IV Offset Account:Account_Segment_Pool7Account_Segment_Pool7String86
115IVIVOFAC_8 SearchIV IV Offset Account:Account_Segment_Pool8Account_Segment_Pool8String86
116IVIVOFAC_9 SearchIV IV Offset Account:Account_Segment_Pool9Account_Segment_Pool9String86
117IVIVOFAC_10 SearchIV IV Offset Account:Account_Segment_Pool10Account_Segment_Pool10String86
118DEX_ROW_ID Searchintint1010

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 *