PA01101 - PA Contract Master File | Prospr - Dynamics GP Table Reference

PA01101 - PA Contract Master File

Query Builder

Select * from PA01101

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
PAcontid	PA Contract ID	String	16	View
PALONGID_1	PA Long Contract ID:PA Long Contract Segment1	String	10	View
PALONGID_2	PA Long Contract ID:PA Long Contract Segment2	String	10	View
PALONGID_3	PA Long Contract ID:PA Long Contract Segment3	String	10	View
PALONGID_4	PA Long Contract ID:PA Long Contract Segment4	String	10	View
PALONGID_5	PA Long Contract ID:PA Long Contract Segment5	String	10	View
PAcontname	PA Contract Name	String	32	View
PACONTNUMBER	PA Contract Number	String	12	View
PAcontclassid	PA Contract Class ID	String	16	View
PAProjectType	PA Project Type	Integer	2	View
PAAcctgMethod	PA Accounting Method	Integer	2	View
PASTAT	PA Status 1 = Open 2 = On Hold 3 = Closed 4 = Estimate 5 = Completed	Integer	2	View
CURRNIDX	Currency Index	Integer	2	View
PApurordnum	PA Purchase Order No.	String	18	View
PABBeginDate	PA Baseline Begin Date	Date	4	View
PABEndDate	PA Baseline End Date	Date	4	View
PAFBeginDate	PA Forecast Begin Date	Date	4	View
PAFEndDate	PA Forecast End Date	Date	4	View
PAACTUALBEGDATE	PA Actual Begin Date	Date	4	View
PA_Actual_End_Date	PA Actual End Date	Date	4	View
PAcloseProjcosts	PA Close to Project Costs	Boolean	2	View
PAclosetobillings	PA Close to Billings	Boolean	2	View
PAContMgrID	PA Contract Manager ID	String	16	View
PABusMgrID	PA Business Manager ID	String	16	View
LOCATNID	Location ID	String	16	View
SLPRSNID	Salesperson ID	String	16	View
SALSTERR	Sales Territory	String	16	View
COMPRCNT	Commission Percent	Integer	2	View
COMAPPTO	Commission Applied To	Integer	2	View
PABILLFORMAT	PA Bill Format	String	16	View
ADRSCODE	Address Code	String	16	View
CNTCPRSN	Contact Person	String	62	View
PRBTADCD	Primary Billto Address Code	String	16	View
PAUD1_Cont	PA User Defined 1 - Contract	String	52	View
PAUD2_Cont	PA User Defined 2 - Contract	String	52	View
PASegmentCB	PA Segment CB	Boolean	2	View
PAbillnoteidx	PA Billing Note Index	Currency	10	View
PAbillnoteidxts	PA Billing Note Index - TS	Currency	10	View
PAELbillniteidx	PA Billing Note Index - EL	Currency	10	View
PAbillnoteidxML	PA Billing Note Index - ML	Currency	10	View
PAbillnoteidxvi	PA Billing Note Index - VI	Currency	10	View
PAbillnoteidxee	PA Billing Note Index - EE	Currency	10	View
PAbillnoteidxinv	PA Billing Note Index - INV	Currency	10	View
PAbillnoteidxfee	PA Billing Note Index - FEE	Currency	10	View
PABQuantity	PA Baseline Quantity	Currency	10	View
PABTotalCost	PA Baseline Total Cost	Currency	10	View
PABBillings	PA Baseline Billings	Currency	10	View
PABProfit	PA Baseline Profit	Currency	10	View
PABTaxPaidAmt	PA Baseline Tax Paid Amount	Currency	10	View
PABTaxChargedAmt	PA Baseline Tax Charged Amount	Currency	10	View
PABaselineOvhdCost	PA Baseline Overhead Cost	Currency	10	View
PAFQuantity	PA Forecast Quantity	Currency	10	View
PAFTotalCost	PA Forecast Total Cost	Currency	10	View
PAFBillings	PA Forecast Billings	Currency	10	View
PAFProfit	PA Forecast Profit	Currency	10	View
PAFTaxPaidAmt	PA Forecast Tax Paid Amount	Currency	10	View
PAFTaxChargedAmt	PA Forecast Tax Charged Amount	Currency	10	View
PAForecastOvhdCost	PA Forecast Overhead Cost	Currency	10	View
PAProject_Amount	PA Project Amount	Currency	10	View
PAUnpostedQty	PA Unposted Qty	Currency	10	View
PAUnpostedTotalCostN	PA Unposted Total Cost	Currency	10	View
PAUnposted_Overhead	PA Unposted Overhead	Currency	10	View
PAUnpostedProfitN	PA Unposted Profit	Currency	10	View
PAUnposted_Tax_Amount	PA Unposted Tax Amount	Currency	10	View
PAUnpostAccrRevN	PA Unposted Accrued Revenues	Currency	10	View
PAUnpostedCommitedQty	PA Unposted Commited Qty	Currency	10	View
PAUnpostedCommitedCost	PA Unposted Commited Cost	Currency	10	View
PAUnpostedCommitedTaxAmt	PA Unposted Commited Tax Amount	Currency	10	View
PAUnpostedRecogRevN	PA Unposted Recognized Revenue	Currency	10	View
PAUnposted_Project_Fee	PA Unposted Project Fee Amount	Currency	10	View
PAUnposted_Retainer_Fee	PA Unposted Retainer Fee Amount	Currency	10	View
PAUnposted_Service_Fee	PA Unposted Service Fee Amount	Currency	10	View
PAUNPOSTRETAMT	PA Unposted Retention Amount	Currency	10	View
PAUNPOSTBIEEAMOUNT	PA Unposted BIEE Amount	Currency	10	View
PAUNPEIEBAMOUNT	PA Unposted EIEB Amount	Currency	10	View
PA_Unposted_Billed_Reten	PA Unposted Billed Retention	Currency	10	View
PAPostedQty	PA Actual Qty	Currency	10	View
PAPostedTotalCostN	PA Actual Total Cost	Currency	10	View
PAPosted_Overhead	PA Actual Overhead	Currency	10	View
PAPostedProfitN	PA Actual Profit	Currency	10	View
PAPosted_Tax_Amount	PA Actual Tax Amount	Currency	10	View
PAPosted_Accr_RevN	PA Actual Accrued Revenues	Currency	10	View
PAPostedCommitedQty	PA Actual Commited Qty	Currency	10	View
PAPostedCommitedCost	PA Actual Commited Cost	Currency	10	View
PAPostedCommitedTaxAmt	PA Actual Commited Tax Amount	Currency	10	View
PAPostRecogRevN	PA Actual Recognized Revenue	Currency	10	View
PAPosted_Project_Fee	PA Actual Project Fee Amount	Currency	10	View
PAPosted_Retainer_Fee	PA Actual Retainer Fee Amount	Currency	10	View
PAPosted_Service_Fee	PA Actual Service Fee Amount	Currency	10	View
PAPOSTRETAMT	PA Actual Retention Amount	Currency	10	View
PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	10	View
PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	10	View
PA_Actual_Billed_Retenti	PA Actual Billed Retention	Currency	10	View
PAWrite_UpDown_Amount	PA Write Up/Down Amount	Currency	10	View
PABilled_QtyN	PA Billed Qty	Currency	10	View
PABilled_Cost	PA Billed Cost	Currency	10	View
PABilled_Accrued_Revenu	PA Billed Accrued Revenues	Currency	10	View
PACostPcntCompleted	PA Cost Percent Completed	Currency	10	View
PAQuantityPcntCompleted	PA Quantity Percent Completed	Currency	10	View
PA_Receipts_Amount	PA Receipts Amount	Currency	10	View
PA_Actual_Receipts_Amoun	PA Actual Receipts Amount	Currency	10	View
PA_Earnings	PA Earnings	Currency	10	View
PA_Cost_of_Earnings	PA Cost of Earnings	Currency	10	View
PAUnpostBillN	PA Unposted Billings	Currency	10	View
PAUnpostDiscDolAmtN	PA Unposted Discount Dollar Amount	Currency	10	View
PAUnposted_Sales_Tax_Am	PA Unposted Sales Tax Amount	Currency	10	View
PAPostedBillingsN	PA Actual Billings	Currency	10	View
PAPostedDiscDolAmtN	PA Actual Discount Dollar Amount	Currency	10	View
PAPosted_Sales_Tax_Amou	PA Actual Sales Tax Amount	Currency	10	View
PAService_Fee_Amount	PA Service Fee Amount	Currency	10	View
PARetainer_Fee_Amount	PA Retainer Fee Amount	Currency	10	View
PAProject_Fee_Amount	PA Project Fee Amount	Currency	10	View
PARetentionFeeAmount	PA Retention Fee Amount	Currency	10	View
DSCPCTAM	Discount Percent Amount	Integer	2	View
PABCWPAMT	PA BCWP Amount	Currency	10	View
PABCWSAMT	PA BCWS Amount	Currency	10	View
PAACWPAMT	PA ACWP Amount	Currency	10	View
NOTEINDX	Note Index	Currency	10	View
PAApproved_Accrued_Reve	PA Approved Accrued Revenues	Currency	10	View
PAApproved_Cost	PA Approved Cost	Currency	10	View
PAApproved_Quantity	PA Approved Quantity	Currency	10	View
WROFAMNT	Write Off Amount	Currency	10	View
ActualWriteOffAmount	Actual Write Off Amount	Currency	10	View
DISTKNAM	Discount Taken Amount	Currency	10	View
ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	10	View
PACommitted_Costs	PA Committed Costs	Currency	10	View
PACommitted_Qty	PA Committed Qty	Currency	10	View
PAPOCost	PA PO Cost	Currency	10	View
PAPOQty	PA PO Qty	Currency	10	View
PAPOPostedCost	PA PO Actual Cost	Currency	10	View
PAPOPostedQty	PA PO Actual Qty	Currency	10	View
PAtaxpaidamt	PA Tax Paid Amount	Currency	10	View
PAPostedTaxPaidN	PA Actual Tax Paid	Currency	10	View
PApretainage	PA Actual Retainage	Currency	10	View
PAunpretainage	PA Unposted Retainage	Currency	10	View
PA_Write_Off_Tax_Amount	PA Write Off Tax Amount	Currency	10	View
PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	10	View
PA_Terms_Taken_Tax_Amt	PA Terms Taken Tax Amt	Currency	10	View
PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	10	View
PA_RestrictCustomerList	PA Restrict Customer List	Boolean	2	View
PAPosted_Earnings	PA Actual Earnings	Currency	10	View
PAActualCostofEarnings	PA Actual Cost of Earnings	Currency	10	View
PAUnpostedLossAmount	PA Unposted Loss Amount	Currency	10	View
PAActualLossAmount	PA Actual Loss Amount	Currency	10	View
PAFQLaborOnly	PA Forecast Quantity - Labor Only	Currency	10	View
PAAQLaborOnly	PA Actual Qty - Labor Only	Currency	10	View
PAMCCURNCYID	PA MC Currency ID	String	16	View
PAMCProjectAmount	PA MC Project Amount	Currency	10	View
PAMCUnpostBillN	PA MC Unposted Billings	Currency	10	View
PAMCUnpostedSalesTax	PA MC Unposted Sales Tax Amt	Currency	10	View
PAMCUnpostedDiscount	PA MC Unposted Discount Amt	Currency	10	View
PAMCActualBillings	PA MC Actual Billings	Currency	10	View
PAMCActualSalesTaxAmt	PA MC Actual Sales Tax Amt	Currency	10	View
PAMCActualDiscountAmt	PA MC Actual Discount Amt	Currency	10	View
PAMCBBillings	PA MC Baseline Billings	Currency	10	View
PAMCFBillings	PA MC Forecast Billings	Currency	10	View
PA_MC_Project_Fee_Amount	PA MC Project Fee Amount	Currency	10	View
PA_MC_Retainer_Fee_Amt	PA MC Retainer Fee Amount	Currency	10	View
PA_MC_Service_Fee_Amount	PA MC Service Fee Amount	Currency	10	View
PA_MC_UnpostedProjectFee	PA MC Unposted Project Fee Amount	Currency	10	View
PA_MC_Unposted_Retainer	PA MC Unposted Retainer Fee Amount	Currency	10	View
PA_MC_UnpostedServiceFee	PA MC Unposted Service Fee Amount	Currency	10	View
PA_MC_Actual_Project_Fee	PA MC Actual Project Fee Amount	Currency	10	View
PA_MC_Actual_RetainerFee	PA MC Actual Retainer Fee Amount	Currency	10	View
PA_MC_Actual_Service_Fee	PA MC Actual Service Fee Amount	Currency	10	View

PA01101 - PA Contract Master File

Query Builder

Customer Service

Information

My Account

Contact Us