PA Change Order Detail OPEN (PA23401)

azurecurveProductsProject Accounting (258)ProjectPA Change Order Detail OPEN (PA23401)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Change Order Detail OPEN
Physical Name: PA23401
Technical Name: PA_Change_Order_DTL_OPEN

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

Leave a Reply

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