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 TypeSQL DB LengthKeyable Length
1PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
2PACHGORDNO SearchPA Change Order NumberSTR17_LBAUString1817
3PACOTRKCHGBY SearchPA CO Track Changes ByPA_DDL_CO_Track_ChangesInteger20
4LNITMSEQ SearchLine Item SequenceLI_Sequence_NumberLong Integer410
5PAPROJNUMBER SearchPA Project NumberSTR15_LBAUString1615
6PATU SearchPA Transaction UsagePA_DDL_Transaction_UsageInteger20
7PACOSTCATID SearchPA Cost Category IDSTR15_Cost_Category_IDString1615
8PALineItemSeq SearchPA Line Item SequenceLI_Sequence_NumberLong Integer410
9PAUnit_of_Measure SearchPA Unit of MeasureU_Of_MString108
10UOMSCHDL SearchU Of M ScheduleSTR10_ScheduleString1210
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_DateDate48
12PAbegindate SearchPA Begin DatePA_DateDate48
13PAPREVENDDT SearchPA Prev End DatePA_DateDate48
14PAEnDate SearchPA End DateDTDate48
15PAPREVPYCDESLY SearchPA Prev Pay Code SalarySTR6_Payroll_CodeString86
16PAPay_Code_Salary SearchPA Pay Code SalarySTR6_Payroll_CodeString86
17PAPREVPYCODEHOURLY SearchPA Prev Pay Code HourlySTR6_Payroll_CodeString86
18PAPay_Code_Hourly SearchPA Pay Code HourlySTR6_Payroll_CodeString86
19PAProfitType SearchPA Profit TypePA_DDL_Profit_TypeInteger20
20PAbllngtype SearchPA Billing TypePA_DDL_Billing_TypeInteger20
21PAPREVPURCHTXOPT SearchPA Prev Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
22PAPurchase_Tax_Options SearchPA Purchase Tax OptionsPA_DDL_Tax_Options_PurchaseInteger20
23PAPREVCOSTXSCHED SearchPA Prev Cost Tax Schedule IDSTR15_Tax_Schedule_IDString1615
24PAPURCHTAXSCHED SearchPA Purchase Tax Schedule IDSTR15_Tax_Schedule_IDString1615
25DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
26DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
27PAPREVSALESTXOPT SearchPA Prev Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
28PASales_Tax_Options SearchPA Sales Tax OptionsPA_DDL_Tax_Options_SalesInteger20
29PAPREVBILLTXSCHED SearchPA Prev Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
30PAbilltaxscheduleid SearchPA Billing Tax Schedule IDSTR15_Tax_Schedule_IDString1615
31PAVarianceQty SearchPA Variance QtyDLR15_RBS2Currency1015
32PAQtyQ SearchPA QuantityPA_DLR15_RBS0_STRCurrency1015
33PAPREVQTY SearchPA Prev QuantityPA_DLR15_RBS0_STRCurrency1015
34PAVarianceCosts SearchPA Variance CostsDLR17_RBSO_STR$Currency1017
35PAUNITCOST SearchPA Unit CostPA_DLR17_RBS0_UTR$Currency1017
36PAPREVUNITCOST SearchPA Prev Unit CostPA_DLR17_RBS0_UTR$Currency1017
37PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency1017
38PAVAROVERHDAMT SearchPA Variance Total Overhead AmountDLR17_RBS0_STR$Currency1017
39PATOTALOVERH SearchPA Total OverheadDLR17_RBS0_UTR$Currency1017
40PAVAROVERHDPRCNT SearchPA Variance Overhead PercentDLR5_%2Currency108
41PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency108
42PAPREVOVRHDPRCNT SearchPA Prev Overhead PercentageDLR5_%2Currency108
43PAPREVTOTOVEHD SearchPA Prev Total OverheadDLR17_RBS0_UTR$Currency1017
44PAVAROVRHDUNIT SearchPA Variance Overhead Per UnitDLR17_RBS0_STR$Currency1017
45PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
46PAPREVOVEHDUNIT SearchPA Prev Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
47PATOTCST SearchPA Total CostPA_DLR17_RBS0_STR$Currency1017
48PAPREVTOTCOST SearchPA Prev Total CostDLR17_RBS0_UTR$Currency1017
49PAVARMUPRCNT SearchPA Variance Markup PercentageDLR5_%2Currency108
50PAProfitPercent SearchPA Profit PercentDLR5_%2Currency108
51PAPREVPROFPRCNT SearchPA Prev Profit PercentDLR5_%2Currency108
52PAVARPROFAMT SearchPA Variance Profit AmountDLR17_RBS0_STR$Currency1017
53PAProfitAmount SearchPA Profit AmountDLR17_RBS0_UTR$Currency1017
54PAPRVPROFITAMT SearchPA Prev Profit AmountDLR17_RBS0_UTR$Currency1017
55PAVARTOTLPROF SearchPA Variance Total ProfitDLR17_RBS0_STR$Currency1017
56PATotalProfit SearchPA Total ProfitDLR17_RBS0_UTR$Currency1017
57PAPREVTOTPROF SearchPA Prev Total ProfitDLR17_RBS0_UTR$Currency1017
58PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency1017
59PAtotbillings SearchPA Total BillingsDLR17_RBS0_UTR$Currency1017
60PAPREVTOTBILL SearchPA Prev Total BillingsDLR17_RBS0_UTR$Currency1017
61PAORIGBUDGTAMT SearchPA Original Budget AmountDLR17_RBS0_UTR$Currency1017
62PAROGPROJAMT SearchPA Original Project AmountDLR17_RBS0_UTR$Currency1017
63PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
64PAPREVPROJAMT SearchPA Prev Project AmountDLR17_RBS0_UTR$Currency1017
65PAVARPROJAMT SearchPA Variance Project AmountDLR17_RBS0_STR$Currency1017
66PAPREVBASEQTY SearchPA Prev Base QtyPA_DLR15_RBS0_STRCurrency1015
67PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
68PAPREVBSEUNTCST SearchPA Prev Base Unit CostDLR17_RBS0_UTR$Currency1017
69PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
70PAPREVBSOVERHDCST SearchPA Prev Base Overhead CostDLR17_RBS0_UTR$Currency1017
71PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency1017
72PAPREVBSPROFAMT SearchPA Prev Base Profit AmountDLR17_RBS0_UTR$Currency1017
73PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency1017
74PAPROPQUOTEAMT SearchPA Propose Quote AmountDLR17_RBS0_UTR$Currency1017
75PAFINQUOTEAMT SearchPA Final Quote AmountDLR17_RBS0_UTR$Currency1017
76PAQUOTEPREPBY SearchPA Quote Prepared BySTR20_LBString2220
77PAQUOTEAPPRVBY SearchPA Quote Approved BySTR20_LBString2220
78PAREVBUDGTAMT SearchPA Revise Budget AmountDLR17_RBS0_UTR$Currency1017
79PAREVPROJAMT SearchPA Revise Project AmountDLR17_RBS0_UTR$Currency1017
80PAsequencenumber SearchPA Sequence Number 1INT5Integer24
81APPRVLDT SearchApproval DateDATEDate46
82PAClose_CB SearchPA Close CBCB_CloseBoolean20
83PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
84PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
85PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
86PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
87PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
88PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
89PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
90PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
91PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
92PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency1017
93PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
94PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
95PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
96PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
97ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
98ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
99PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
100PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
101PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
102PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
103DEX_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 Change Order Detail WORK (PA12001)

Leave a Reply

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