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