GP Tables

PA01241 - PA Project Change Order Master

Dynamics GP table PA01241 (PA Project Change Order Master) contains 40 columns including PAPROJNUMBER, PATRKCHGORDS, PATRKCOBDGADDFLY....

SQL Query Builder

40 Columns

Column Description Type Length
PAPROJNUMBER PA Project Number String 16
PATRKCHGORDS PA Track Change Orders Boolean 2
PATRKCOBDGADDFLY PA Track CO for Budgets Add on fly Boolean 2
PATOTCHGORDAMT PA Total Change Order Amount Currency 10
PANOPENDCO PA Number of Pending CO Integer 2
PANUMCO PA Number of Change Order Integer 2
PACOBASEPROJAMT PA CO Baseline Project Amount Currency 10
PAUNPRRTOTPROJAMT PA Unapproved Total Project Amount Currency 10
PACOBSLNFEEPROJAMT PA CO Baseline Fee Project Amount Currency 10
PAUNABSTOTBILL PA Unapproved Baseline Total Billings Currency 10
PAUNPBSTOTCST PA Unapproved Baseline Total Cost Currency 10
PAUNPBSLTOTPROF PA Unapproved Baseline Total Profit Currency 10
PAUNPBSTOTQTY PA Unapproved Baseline Total Qty Currency 10
PAUNAPFRTOTBILL PA Unapproved Forecast Total Billings Currency 10
PAUNAPPFRTOTCST PA Unapproved Forecast Total Cost Currency 10
PAUNFRCTOTPROF PA Unapproved Forecast Total Profit Currency 10
PAUNPFRTOTQTY PA Unapproved Forecast Total Qty Currency 10
PAPostedQty PA Actual Qty Currency 10
PAPostedTotalCostN PA Actual Total Cost Currency 10
PAPosted_Overhead PA Actual Overhead Currency 10
PAPostedProfitN PA Actual Profit Currency 10
PAPosted_Tax_Amount PA Actual Tax Amount Currency 10
PAACREV PA Accrued Revenues Currency 10
PAPostRecogRevN PA Actual Recognized Revenue Currency 10
PAPOSBIEEAMOUNT PA Actual BIEE Amount Currency 10
PAPOSEIEBAMOUNT PA Actual EIEB Amount Currency 10
PApostbillamt PA Actual Billed Amount Currency 10
PA_Actual_Receipts_Amoun PA Actual Receipts Amount Currency 10
PAPostedBillingsN PA Actual Billings Currency 10
PAPostedDiscDolAmtN PA Actual Discount Dollar Amount Currency 10
PAPosted_Sales_Tax_Amou PA Actual Sales Tax Amount Currency 10
ActualWriteOffAmount Actual Write Off Amount Currency 10
ActualDiscTakenAmount Actual Discount Taken Amount Currency 10
PAactjtaxpd PA Actual Taxes Paid Currency 10
PAPOSTRETAMT PA Actual Retention Amount Currency 10
PAActualWOTaxAmt PA Actual Write Off Tax Amount Currency 10
PAActualTermsTakenTax PA Actual Terms Taken Tax Amt Currency 10
PAPosted_Project_Fee PA Actual Project Fee Amount Currency 10
PAPosted_Retainer_Fee PA Actual Retainer Fee Amount Currency 10
PAPosted_Service_Fee PA Actual Service Fee Amount Currency 10

Related Tables

Tables that share columns with PA01241. Click "Join" to add to your query.

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01251 PA01301 PA01303

PAACREV

PA00531 PA01161 PA01251 PA01341 PA10001 PA10101 PA10201 PA10501

PAPostedBillingsN

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

PAPostRecogRevN

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

PAPOSBIEEAMOUNT

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

PAPOSEIEBAMOUNT

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

ActualWriteOffAmount

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

ActualDiscTakenAmount

PA00402 PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221

PAPOSTRETAMT

PA00402 PA00501 PA00502 PA00503 PA00511 PA01101 PA01121 PA01141

PAPostedQty

PA00501 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221 PA01301