PA Contract Change Order Master (PA01141)

azurecurveProductsProject Accounting (258)ProjectPA Contract Change Order Master (PA01141)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Contract Change Order Master
Physical Name: PA01141
Technical Name: PA_Contract_Change_Order_MSTR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1PACONTNUMBER SearchPA Contract NumberSTR10_LBAUString1210
2PAchangeorderdocounter SearchPA Change Order Doc CounterSTR17_LBAUString1817
3PATRKCHGORDS SearchPA Track Change OrdersPA_CB_Track_Change_OrdersBoolean20
4PATRKCOBDGADDFLY SearchPA Track CO for Budgets Add on flyPA_CB_Track_CO_Budget_on_FlyBoolean20
5PACOTRKBASELINE SearchPA CO Create BaselinePA_CB_CO_Create_BaselineBoolean20
6PATOTCHGORDAMT SearchPA Total Change Order AmountDLR17_RBS0_UTR$Currency1017
7PANOPENDCO SearchPA Number of Pending COINT5_RU0Integer25
8PANUMCO SearchPA Number of Change OrderINT5_RU0Integer25
9PACOBASEPROJAMT SearchPA CO Baseline Project AmountPA_DLR17_RBS0_STR$Currency1017
10PACOBSLNFEEPROJAMT SearchPA CO Baseline Fee Project AmountPA_DLR17_RBS0_STR$Currency1017
11PAUNPRRTOTPROJAMT SearchPA Unapproved Total Project AmountPA_DLR17_RBS0_STR$Currency1017
12PAUNABSTOTBILL SearchPA Unapproved Baseline Total BillingsPA_DLR17_RBS0_STR$Currency1017
13PAUNPBSTOTCST SearchPA Unapproved Baseline Total CostPA_DLR17_RBS0_STR$Currency1017
14PAUNPBSLTOTPROF SearchPA Unapproved Baseline Total ProfitPA_DLR17_RBS0_STR$Currency1017
15PAUNPBSTOTQTY SearchPA Unapproved Baseline Total QtyPA_DLR15_RBS0_STRCurrency1015
16PAUNAPFRTOTBILL SearchPA Unapproved Forecast Total BillingsPA_DLR17_RBS0_STR$Currency1017
17PAUNAPPFRTOTCST SearchPA Unapproved Forecast Total CostPA_DLR17_RBS0_STR$Currency1017
18PAUNFRCTOTPROF SearchPA Unapproved Forecast Total ProfitPA_DLR17_RBS0_STR$Currency1017
19PAUNPFRTOTQTY SearchPA Unapproved Forecast Total QtyPA_DLR15_RBS0_STRCurrency1015
20PAPostedQty SearchPA Actual QtyPA_DLR15_RBS0_STRCurrency1015
21PAPostedTotalCostN SearchPA Actual Total CostPA_DLR17_RBS0_STR$Currency1017
22PAPosted_Overhead SearchPA Actual OverheadPA_DLR17_RBS0_STR$Currency1017
23PAPostedProfitN SearchPA Actual ProfitPA_DLR17_RBS0_STR$Currency1017
24PAPosted_Tax_Amount SearchPA Actual Tax AmountPA_DLR17_RBS0_STR$Currency1017
25PAPosted_Accr_RevN SearchPA Actual Accrued RevenuesPA_DLR17_RBS0_STR$Currency1017
26PAPostRecogRevN SearchPA Actual Recognized RevenuePA_DLR17_RBS0_STR$Currency1017
27PAPOSBIEEAMOUNT SearchPA Actual BIEE AmountDLR17_RBS0_UTR$Currency1017
28PAPOSEIEBAMOUNT SearchPA Actual EIEB AmountDLR17_RBS0_UTR$Currency1017
29PApostbillamt SearchPA Actual Billed AmountDLR17_RBS0_UTR$Currency1017
30PA_Actual_Receipts_Amoun SearchPA Actual Receipts AmountPA_DLR17_RBS0_STR$Currency1017
31PAPostedBillingsN SearchPA Actual BillingsPA_DLR17_RBS0_STR$Currency1017
32PAPostedDiscDolAmtN SearchPA Actual Discount Dollar AmountPA_DLR17_RBS0_STR$Currency1017
33PAPosted_Sales_Tax_Amou SearchPA Actual Sales Tax AmountPA_DLR17_RBS0_STR$Currency1017
34ActualWriteOffAmount SearchActual Write Off AmountDLR17_RBS0_UTR$Currency1017
35ActualDiscTakenAmount SearchActual Discount Taken AmountDLR17_RBS0_UTR$Currency1017
36PAPostedTaxPaidN SearchPA Actual Tax PaidPA_DLR17_RBS0_STR$Currency1017
37PAPOSTRETAMT SearchPA Actual Retention AmountPA_DLR17_RBS0_STR$Currency1017
38PAActualWOTaxAmt SearchPA Actual Write Off Tax AmountPA_DLR17_RBS0_STR$Currency1017
39PAActualTermsTakenTax SearchPA Actual Terms Taken Tax AmtPA_DLR17_RBS0_STR$Currency1017
40PAPosted_Project_Fee SearchPA Actual Project Fee AmountPA_DLR17_RBS0_STR$Currency1017
41PAPosted_Retainer_Fee SearchPA Actual Retainer Fee AmountPA_DLR17_RBS0_STR$Currency1017
42PAPosted_Service_Fee SearchPA Actual Service Fee AmountPA_DLR17_RBS0_STR$Currency1017
43PAGBTRKCHG SearchPA GB Track ChangesGBInteger20
44DEX_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 Contract Change Order Master (PA01141)

Leave a Reply

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