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 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.
Physical Name: PA01141
Technical Name: PA_Contract_Change_Order_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type SQL DB Length Keyable Length 1 PACONTNUMBER PA Contract Number STR10_LBAU String 12 10 2 PAchangeorderdocounter PA Change Order Doc Counter STR17_LBAU String 18 17 3 PATRKCHGORDS PA Track Change Orders PA_CB_Track_Change_Orders Boolean 2 0 4 PATRKCOBDGADDFLY PA Track CO for Budgets Add on fly PA_CB_Track_CO_Budget_on_Fly Boolean 2 0 5 PACOTRKBASELINE PA CO Create Baseline PA_CB_CO_Create_Baseline Boolean 2 0 6 PATOTCHGORDAMT PA Total Change Order Amount DLR17_RBS0_UTR$ Currency 10 17 7 PANOPENDCO PA Number of Pending CO INT5_RU0 Integer 2 5 8 PANUMCO PA Number of Change Order INT5_RU0 Integer 2 5 9 PACOBASEPROJAMT PA CO Baseline Project Amount PA_DLR17_RBS0_STR$ Currency 10 17 10 PACOBSLNFEEPROJAMT PA CO Baseline Fee Project Amount PA_DLR17_RBS0_STR$ Currency 10 17 11 PAUNPRRTOTPROJAMT PA Unapproved Total Project Amount PA_DLR17_RBS0_STR$ Currency 10 17 12 PAUNABSTOTBILL PA Unapproved Baseline Total Billings PA_DLR17_RBS0_STR$ Currency 10 17 13 PAUNPBSTOTCST PA Unapproved Baseline Total Cost PA_DLR17_RBS0_STR$ Currency 10 17 14 PAUNPBSLTOTPROF PA Unapproved Baseline Total Profit PA_DLR17_RBS0_STR$ Currency 10 17 15 PAUNPBSTOTQTY PA Unapproved Baseline Total Qty PA_DLR15_RBS0_STR Currency 10 15 16 PAUNAPFRTOTBILL PA Unapproved Forecast Total Billings PA_DLR17_RBS0_STR$ Currency 10 17 17 PAUNAPPFRTOTCST PA Unapproved Forecast Total Cost PA_DLR17_RBS0_STR$ Currency 10 17 18 PAUNFRCTOTPROF PA Unapproved Forecast Total Profit PA_DLR17_RBS0_STR$ Currency 10 17 19 PAUNPFRTOTQTY PA Unapproved Forecast Total Qty PA_DLR15_RBS0_STR Currency 10 15 20 PAPostedQty PA Actual Qty PA_DLR15_RBS0_STR Currency 10 15 21 PAPostedTotalCostN PA Actual Total Cost PA_DLR17_RBS0_STR$ Currency 10 17 22 PAPosted_Overhead PA Actual Overhead PA_DLR17_RBS0_STR$ Currency 10 17 23 PAPostedProfitN PA Actual Profit PA_DLR17_RBS0_STR$ Currency 10 17 24 PAPosted_Tax_Amount PA Actual Tax Amount PA_DLR17_RBS0_STR$ Currency 10 17 25 PAPosted_Accr_RevN PA Actual Accrued Revenues PA_DLR17_RBS0_STR$ Currency 10 17 26 PAPostRecogRevN PA Actual Recognized Revenue PA_DLR17_RBS0_STR$ Currency 10 17 27 PAPOSBIEEAMOUNT PA Actual BIEE Amount DLR17_RBS0_UTR$ Currency 10 17 28 PAPOSEIEBAMOUNT PA Actual EIEB Amount DLR17_RBS0_UTR$ Currency 10 17 29 PApostbillamt PA Actual Billed Amount DLR17_RBS0_UTR$ Currency 10 17 30 PA_Actual_Receipts_Amoun PA Actual Receipts Amount PA_DLR17_RBS0_STR$ Currency 10 17 31 PAPostedBillingsN PA Actual Billings PA_DLR17_RBS0_STR$ Currency 10 17 32 PAPostedDiscDolAmtN PA Actual Discount Dollar Amount PA_DLR17_RBS0_STR$ Currency 10 17 33 PAPosted_Sales_Tax_Amou PA Actual Sales Tax Amount PA_DLR17_RBS0_STR$ Currency 10 17 34 ActualWriteOffAmount Actual Write Off Amount DLR17_RBS0_UTR$ Currency 10 17 35 ActualDiscTakenAmount Actual Discount Taken Amount DLR17_RBS0_UTR$ Currency 10 17 36 PAPostedTaxPaidN PA Actual Tax Paid PA_DLR17_RBS0_STR$ Currency 10 17 37 PAPOSTRETAMT PA Actual Retention Amount PA_DLR17_RBS0_STR$ Currency 10 17 38 PAActualWOTaxAmt PA Actual Write Off Tax Amount PA_DLR17_RBS0_STR$ Currency 10 17 39 PAActualTermsTakenTax PA Actual Terms Taken Tax Amt PA_DLR17_RBS0_STR$ Currency 10 17 40 PAPosted_Project_Fee PA Actual Project Fee Amount PA_DLR17_RBS0_STR$ Currency 10 17 41 PAPosted_Retainer_Fee PA Actual Retainer Fee Amount PA_DLR17_RBS0_STR$ Currency 10 17 42 PAPosted_Service_Fee PA Actual Service Fee Amount PA_DLR17_RBS0_STR$ Currency 10 17 43 PAGBTRKCHG PA GB Track Changes GB Integer 2 0 44 DEX_ROW_ID int int 10 10