PA Change Order Detail WORK (PA12001)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Detail WORK (PA12001)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Detail WORK
Physical Name: PA12001
Technical Name: PA_Change_Order_DTL_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString10
2PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString17
3PACOTRKCHGBY SearchPA CO Track Changes ByPA_DDL_CO_Track_ChangesInteger0
4LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer10
5PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString15
6PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger0
7PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString15
8PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer10
9PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString8
10UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString10
Key to the Inventory U of M Schedule Setup (IV40201).

Click to show/hide

SELECT
       ['PA Change Order Detail WORK'].UOMSCHDL AS 'PA Change Order Detail WORK-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA12001 AS ['PA Change Order Detail WORK']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Change Order Detail WORK'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL
11PAPREVBEGINDT SearchPA Prev Begin DatePA_DateDate8
12PAbegindate SearchPA Begin DatePA_DateDate8
13PAPREVENDDT SearchPA Prev End DatePA_DateDate8
14PAEnDate SearchPA End DateDTDate8
15PAPREVPYCDESLY SearchPA Prev Pay Code SalarySTR6_Payroll_CodeString6
16PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString6
17PAPREVPYCODEHOURLY SearchPA Prev Pay Code HourlySTR6_Payroll_CodeString6
18PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString6
19PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger0
20PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger0
21PAPREVPURCHTXOPT SearchPA Prev Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
22PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger0
23PAPREVCOSTXSCHED SearchPA Prev Cost Tax Schedule IDSTR15_Tax_Schedule_IDString15
24PAPURCHTAXSCHED SearchPA Purchase Tax Schedule IDSTR15_Tax_Schedule_IDString15
25DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger0
26DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger0
27PAPREVSALESTXOPT SearchPA Prev Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
28PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger0
29PAPREVBILLTXSCHED SearchPA Prev Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
30PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString15
31PAVarianceQty SearchPA Variance QtyDLR15_RBS2Currency15
32PAQtyQ SearchPA QuantityPA_DLR15_RBS0_STRCurrency15
33PAPREVQTY SearchPA Prev QuantityPA_DLR15_RBS0_STRCurrency15
34PAVarianceCosts SearchPA Variance CostsDLR17_RBSO_STR$Currency17
35PAUNITCOST SearchPA Unit CostPA_DLR17_RBS0_UTR$Currency17
36PAPREVUNITCOST SearchPA Prev Unit CostPA_DLR17_RBS0_UTR$Currency17
37PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency17
38PAVAROVERHDAMT SearchPA Variance Total Overhead AmountDLR17_RBS0_STR$Currency17
39PATOTALOVERH SearchPA Total OverheadDLR17_RBS0_UTR$Currency17
40PAVAROVERHDPRCNT SearchPA Variance Overhead PercentDLR5_%2Currency8
41PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency8
42PAPREVOVRHDPRCNT SearchPA Prev Overhead PercentageDLR5_%2Currency8
43PAPREVTOTOVEHD SearchPA Prev Total OverheadDLR17_RBS0_UTR$Currency17
44PAVAROVRHDUNIT SearchPA Variance Overhead Per UnitDLR17_RBS0_STR$Currency17
45PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitDLR17_RBS0_UTR$Currency17
46PAPREVOVEHDUNIT SearchPA Prev Overhead Amount Per UnitDLR17_RBS0_UTR$Currency17
47PATOTCST SearchPA Total CostPA_DLR17_RBS0_STR$Currency17
48PAPREVTOTCOST SearchPA Prev Total CostDLR17_RBS0_UTR$Currency17
49PAVARMUPRCNT SearchPA Variance Markup PercentageDLR5_%2Currency8
50PAProfitPercent SearchPA Profit PercentDLR5_%2Currency8
51PAPREVPROFPRCNT SearchPA Prev Profit PercentDLR5_%2Currency8
52PAVARPROFAMT SearchPA Variance Profit AmountDLR17_RBS0_STR$Currency17
53PAProfitAmount SearchPA Profit AmountDLR17_RBS0_UTR$Currency17
54PAPRVPROFITAMT SearchPA Prev Profit AmountDLR17_RBS0_UTR$Currency17
55PAVARTOTLPROF SearchPA Variance Total ProfitDLR17_RBS0_STR$Currency17
56PATotalProfit SearchPA Total ProfitDLR17_RBS0_UTR$Currency17
57PAPREVTOTPROF SearchPA Prev Total ProfitDLR17_RBS0_UTR$Currency17
58PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency17
59PAtotbillings SearchPA Total BillingsDLR17_RBS0_UTR$Currency17
60PAPREVTOTBILL SearchPA Prev Total BillingsDLR17_RBS0_UTR$Currency17
61PAORIGBUDGTAMT SearchPA Original Budget AmountDLR17_RBS0_UTR$Currency17
62PAROGPROJAMT SearchPA Original Project AmountDLR17_RBS0_UTR$Currency17
63PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency17
64PAPREVPROJAMT SearchPA Prev Project AmountDLR17_RBS0_UTR$Currency17
65PAVARPROJAMT SearchPA Variance Project AmountDLR17_RBS0_STR$Currency17
66PAPREVBASEQTY SearchPA Prev Base QtyPA_DLR15_RBS0_STRCurrency15
67PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency15
68PAPREVBSEUNTCST SearchPA Prev Base Unit CostDLR17_RBS0_UTR$Currency17
69PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency17
70PAPREVBSOVERHDCST SearchPA Prev Base Overhead CostDLR17_RBS0_UTR$Currency17
71PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency17
72PAPREVBSPROFAMT SearchPA Prev Base Profit AmountDLR17_RBS0_UTR$Currency17
73PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency17
74PAPROPQUOTEAMT SearchPA Propose Quote AmountDLR17_RBS0_UTR$Currency17
75PAFINQUOTEAMT SearchPA Final Quote AmountDLR17_RBS0_UTR$Currency17
76PAQUOTEPREPBY SearchPA Quote Prepared BySTR20_LBString20
77PAQUOTEAPPRVBY SearchPA Quote Approved BySTR20_LBString20
78PAREVBUDGTAMT SearchPA Revise Budget AmountDLR17_RBS0_UTR$Currency17
79PAREVPROJAMT SearchPA Revise Project AmountDLR17_RBS0_UTR$Currency17
80PAsequencenumber SearchPA Sequence Number 1INT5Integer4
81APPRVLDT SearchApproval DateDATEDate6
82PAClose_CB SearchPA Close CBCB_CloseBoolean0
83PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency15
84PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency17
85PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency17
86PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency17
87PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency17
88PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency17
89PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency17
90PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency17
91PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency17
92PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency17
93PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency17
94PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency17
95PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency17
96PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency17
97ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency17
98ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency17
99PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency17
100PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency17
101PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency17
102PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency17
103DEX_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 Change Order Detail WORK (PA12001)

Leave a Reply

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