PA Project Change Order Master (PA01241)

azurecurveProductsProject Accounting (258)ProjectPA Project Change Order Master (PA01241)

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

Product: Project Accounting (258)
Series: Project

Display Name: PA Project Change Order Master
Physical Name: PA01241
Technical Name: PA_Project_Change_Order_MSTR

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

Leave a Reply

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