PA Change Order Detail HIST (PA33702)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Detail HIST (PA33702)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Detail HIST
Physical Name: PA33702
Technical Name: PA_Change_Order_DTL_HIST

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 HIST'].UOMSCHDL AS 'PA Change Order Detail HIST-U Of M Schedule'
       ,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
       PA33702 AS ['PA Change Order Detail HIST']
INNER JOIN
       IV40201 AS ['Inventory U of M Schedule Setup']
              ON
                     ['PA Change Order Detail HIST'].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
33PAVarianceCosts SearchPA Variance CostsDLR17_RBSO_STR$Currency1017
34PAUNITCOST SearchPA Unit CostPA_DLR17_RBS0_UTR$Currency1017
35PAVARTOTCOST SearchPA Variance Total CostDLR17_RBS0_STR$Currency1017
36PAVAROVERHDAMT SearchPA Variance Total Overhead AmountDLR17_RBS0_STR$Currency1017
37PATOTALOVERH SearchPA Total OverheadDLR17_RBS0_UTR$Currency1017
38PAVAROVERHDPRCNT SearchPA Variance Overhead PercentDLR5_%2Currency108
39PAOverheaPercentage SearchPA Overhead PercentageDLR5_%2Currency108
40PAVAROVRHDUNIT SearchPA Variance Overhead Per UnitDLR17_RBS0_STR$Currency1017
41PAOvhdAmtPerUnit SearchPA Overhead Amount Per UnitDLR17_RBS0_UTR$Currency1017
42PATOTCST SearchPA Total CostPA_DLR17_RBS0_STR$Currency1017
43PAVARMUPRCNT SearchPA Variance Markup PercentageDLR5_%2Currency108
44PAProfitPercent SearchPA Profit PercentDLR5_%2Currency108
45PAVARPROFAMT SearchPA Variance Profit AmountDLR17_RBS0_STR$Currency1017
46PAProfitAmount SearchPA Profit AmountDLR17_RBS0_UTR$Currency1017
47PAVARTOTLPROF SearchPA Variance Total ProfitDLR17_RBS0_STR$Currency1017
48PATotalProfit SearchPA Total ProfitDLR17_RBS0_UTR$Currency1017
49PAVARTOTBILLINGS SearchPA Variance Total BillingsDLR17_RBS0_STR$Currency1017
50PAtotbillings SearchPA Total BillingsDLR17_RBS0_UTR$Currency1017
51PAORIGBUDGTAMT SearchPA Original Budget AmountDLR17_RBS0_UTR$Currency1017
52PAROGPROJAMT SearchPA Original Project AmountDLR17_RBS0_UTR$Currency1017
53PAVARPROJAMT SearchPA Variance Project AmountDLR17_RBS0_STR$Currency1017
54PAProject_Amount SearchPA Project AmountDLR17_RBS0_UTR$Currency1017
55PAPREVPROJAMT SearchPA Prev Project AmountDLR17_RBS0_UTR$Currency1017
56PAPREVBASEQTY SearchPA Prev Base QtyPA_DLR15_RBS0_STRCurrency1015
57PABase_Qty SearchPA Base QtyPA_DLR15_RBS0_STRCurrency1015
58PAPREVBSEUNTCST SearchPA Prev Base Unit CostDLR17_RBS0_UTR$Currency1017
59PABase_Unit_Cost SearchPA Base Unit CostPA_DLR17_RBS0_STR$Currency1017
60PAPREVBSOVERHDCST SearchPA Prev Base Overhead CostDLR17_RBS0_UTR$Currency1017
61PABaseOvhdCost SearchPA Base Overhead CostDLR17_RBS0_UTR$Currency1017
62PAPREVBSPROFAMT SearchPA Prev Base Profit AmountDLR17_RBS0_UTR$Currency1017
63PABaseProfitAmount SearchPA Base Profit AmountDLR17_RBS0_UTR$Currency1017
64PAPROPQUOTEAMT SearchPA Propose Quote AmountDLR17_RBS0_UTR$Currency1017
65PAFINQUOTEAMT SearchPA Final Quote AmountDLR17_RBS0_UTR$Currency1017
66PAQUOTEPREPBY SearchPA Quote Prepared BySTR20_LBString2220
67PAQUOTEAPPRVBY SearchPA Quote Approved BySTR20_LBString2220
68PAREVBUDGTAMT SearchPA Revise Budget AmountDLR17_RBS0_UTR$Currency1017
69PAREVPROJAMT SearchPA Revise Project AmountDLR17_RBS0_UTR$Currency1017
70PAsequencenumber SearchPA Sequence Number 1INT5Integer24
71APPRVLDT SearchApproval DateDATEDate46
72PAClose_CB SearchPA Close CBCB_CloseBoolean20
73PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
74PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
75PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
76PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
77PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
78PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
79PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
80PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
81PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
82PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency1017
83PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
84PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
85PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
86PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
87ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
88ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
89PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
90PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
91PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
92PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
93DEX_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 HIST (PA33702)

Leave a Reply

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