GP Tables

PA00501 - PA Customer MSTR

Dynamics GP table PA00501 (PA Customer MSTR) contains 124 columns including CUSTNMBR, PAcustalias, PAcloseProjcosts....

SQL Query Builder

124 Columns

Column Description Type Length
CUSTNMBR Customer Number String 16
PAcustalias PA Customer Alias String 6
PAcloseProjcosts PA Close to Project Costs Boolean 2
PAclosetobillings PA Close to Billings Boolean 2
PABILLFORMAT PA Bill Format String 16
PAUD1 PA User Defined 1 String 22
PAUD2 PA User Defined 2 String 22
PABQuantity PA Baseline Quantity Currency 10
PABTotalCost PA Baseline Total Cost Currency 10
PABBillings PA Baseline Billings Currency 10
PABProfit PA Baseline Profit Currency 10
PABTaxPaidAmt PA Baseline Tax Paid Amount Currency 10
PABTaxChargedAmt PA Baseline Tax Charged Amount Currency 10
PABaselineOvhdCost PA Baseline Overhead Cost Currency 10
PAFQuantity PA Forecast Quantity Currency 10
PAFTotalCost PA Forecast Total Cost Currency 10
PAFBillings PA Forecast Billings Currency 10
PAFProfit PA Forecast Profit Currency 10
PAFTaxPaidAmt PA Forecast Tax Paid Amount Currency 10
PAFTaxChargedAmt PA Forecast Tax Charged Amount Currency 10
PAForecastOvhdCost PA Forecast Overhead Cost Currency 10
PAProject_Amount PA Project Amount Currency 10
PAUnpostedQty PA Unposted Qty Currency 10
PAUnpostedTotalCostN PA Unposted Total Cost Currency 10
PAUnposted_Overhead PA Unposted Overhead Currency 10
PAUnpostedProfitN PA Unposted Profit Currency 10
PAUnposted_Tax_Amount PA Unposted Tax Amount Currency 10
PAUnpostAccrRevN PA Unposted Accrued Revenues Currency 10
PAUnpostedCommitedQty PA Unposted Commited Qty Currency 10
PAUnpostedCommitedCost PA Unposted Commited Cost Currency 10
PAUnpostedCommitedTaxAmt PA Unposted Commited Tax Amount Currency 10
PAUnpostedRecogRevN PA Unposted Recognized Revenue Currency 10
PAUnposted_Project_Fee PA Unposted Project Fee Amount Currency 10
PAUnposted_Retainer_Fee PA Unposted Retainer Fee Amount Currency 10
PAUnposted_Service_Fee PA Unposted Service Fee Amount Currency 10
PAUNPOSTRETAMT PA Unposted Retention Amount Currency 10
PA_Unposted_Billed_Reten PA Unposted Billed Retention Currency 10
PAUNPOSTBIEEAMOUNT PA Unposted BIEE Amount Currency 10
PAUNPEIEBAMOUNT PA Unposted EIEB Amount 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
PAPosted_Accr_RevN PA Actual Accrued Revenues Currency 10
PA_Actual_Billed_Retenti PA Actual Billed Retention Currency 10
PAPostedCommitedQty PA Actual Commited Qty Currency 10
PAPostedCommitedCost PA Actual Commited Cost Currency 10
PAPostedCommitedTaxAmt PA Actual Commited Tax Amount Currency 10
PAPostRecogRevN PA Actual Recognized Revenue 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
PAPOSTRETAMT PA Actual Retention Amount Currency 10
PAPOSBIEEAMOUNT PA Actual BIEE Amount Currency 10
PAPOSEIEBAMOUNT PA Actual EIEB Amount Currency 10
PAWrite_UpDown_Amount PA Write Up/Down Amount Currency 10
PABilled_QtyN PA Billed Qty Currency 10
PABilled_Cost PA Billed Cost Currency 10
PABilled_Accrued_Revenu PA Billed Accrued Revenues Currency 10
PACostPcntCompleted PA Cost Percent Completed Currency 10
PAQuantityPcntCompleted PA Quantity Percent Completed Currency 10
PA_Receipts_Amount PA Receipts Amount Currency 10
PA_Actual_Receipts_Amoun PA Actual Receipts Amount Currency 10
PA_Earnings PA Earnings Currency 10
PA_Cost_of_Earnings PA Cost of Earnings Currency 10
PAUnpostBillN PA Unposted Billings Currency 10
PAUnpostDiscDolAmtN PA Unposted Discount Dollar Amount Currency 10
PAUnposted_Sales_Tax_Am PA Unposted Sales Tax 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
PAService_Fee_Amount PA Service Fee Amount Currency 10
PARetainer_Fee_Amount PA Retainer Fee Amount Currency 10
PAProject_Fee_Amount PA Project Fee Amount Currency 10
PARetentionFeeAmount PA Retention Fee Amount Currency 10
PABCWPAMT PA BCWP Amount Currency 10
PABCWSAMT PA BCWS Amount Currency 10
PAACWPAMT PA ACWP Amount Currency 10
PAApproved_Accrued_Reve PA Approved Accrued Revenues Currency 10
PAApproved_Cost PA Approved Cost Currency 10
PAApproved_Quantity PA Approved Quantity Currency 10
WROFAMNT Write Off Amount Currency 10
ActualWriteOffAmount Actual Write Off Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
ActualDiscTakenAmount Actual Discount Taken Amount Currency 10
PACommitted_Costs PA Committed Costs Currency 10
PACommitted_Qty PA Committed Qty Currency 10
PAPOCost PA PO Cost Currency 10
PAPOQty PA PO Qty Currency 10
PAPOPostedCost PA PO Actual Cost Currency 10
PAPOPostedQty PA PO Actual Qty Currency 10
PAtaxpaidamt PA Tax Paid Amount Currency 10
PAPostedTaxPaidN PA Actual Tax Paid Currency 10
PApretainage PA Actual Retainage Currency 10
PAunpretainage PA Unposted Retainage Currency 10
PA_Actual_Freight_Amount PA Actual Freight Amount Currency 10
PA_Unposted_Freight_Amou PA Unposted Freight Amount Currency 10
PA_Actual_Misc_Amount PA Actual Misc Amount Currency 10
PA_Unposted_Misc_Amount PA Unposted Misc Amount Currency 10
PA_Write_Off_Tax_Amount PA Write Off Tax Amount Currency 10
PAActualWOTaxAmt PA Actual Write Off Tax Amount Currency 10
PA_Terms_Taken_Tax_Amt PA Terms Taken Tax Amt Currency 10
PAActualTermsTakenTax PA Actual Terms Taken Tax Amt 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
PACOBSLNFEEPROJAMT PA CO Baseline Fee Project Amount Currency 10
PAUNPRRTOTPROJAMT PA Unapproved Total 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
PATOTCHGORDAMT PA Total Change Order Amount Currency 10
PAPosted_Earnings PA Actual Earnings Currency 10
PAActualCostofEarnings PA Actual Cost of Earnings Currency 10
PAUnpostedLossAmount PA Unposted Loss Amount Currency 10
PAActualLossAmount PA Actual Loss Amount Currency 10
PAFQLaborOnly PA Forecast Quantity - Labor Only Currency 10
PAAQLaborOnly PA Actual Qty - Labor Only Currency 10

Related Tables

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

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

WROFAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA00402 PA00511 PA01101 PA01121

PAUD1

PA00401 PA00601 PA00701 PA00801 PA00901 PA01001 PA02101 PA10000

PAUD2

PA00401 PA00601 PA00701 PA00801 PA00901 PA01001 PA02101 PA10000

PAApproved_Quantity

PA00511 PA01101 PA01121 PA01201 PA01221 PA01301 PA01304 PA10001

PAWrite_UpDown_Amount

PA00511 PA01101 PA01121 PA01201 PA01221 PA01301 PA01304 PA10001

PAPostedBillingsN

PA00402 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221 PA01241

PAPostRecogRevN

PA00402 PA00511 PA01101 PA01121 PA01141 PA01201 PA01221 PA01241

PABilled_QtyN

PA00511 PA01101 PA01121 PA01201 PA01221 PA01301 PA01304 PA10001