PA23401 - PA Change Order Detail OPEN | Prospr

PA23401 - PA Change Order Detail OPEN

Query Builder

Select * from PA23401

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
PACONTNUMBER	PA Contract Number	String	12	View
PACHGORDNO	PA Change Order Number	String	18	View
PACOTRKCHGBY	PA CO Track Changes By	Integer	2	View
LNITMSEQ	Line Item Sequence	Long Integer	4	View
PAPROJNUMBER	PA Project Number	String	16	View
PATU	PA Transaction Usage 1 = Timesheet 2 = Equipment Log 3 = Miscellaneous Log 4 = Purchases/Material 5 = Employee Expense	Integer	2	View
PACOSTCATID	PA Cost Category ID	String	16	View
PALineItemSeq	PA Line Item Sequence	Long Integer	4	View
PAUnit_of_Measure	PA Unit of Measure	String	10	View
UOMSCHDL	U Of M Schedule	String	12	View
PAPREVBEGINDT	PA Prev Begin Date	Date	4	View
PAbegindate	PA Begin Date	Date	4	View
PAPREVENDDT	PA Prev End Date	Date	4	View
PAEnDate	PA End Date	Date	4	View
PAPREVPYCDESLY	PA Prev Pay Code Salary	String	8	View
PAPay_Code_Salary	PA Pay Code Salary	String	8	View
PAPREVPYCODEHOURLY	PA Prev Pay Code Hourly	String	8	View
PAPay_Code_Hourly	PA Pay Code Hourly	String	8	View
PAProfitType	PA Profit Type 1 = Billing Rate 2 = Markup 3 = Profit/Unit Fixed 4 = Profit/Unit Variable 5 = Total Profit 6 = % of Baseline 7 = % of Actual 8 = None 9 = Price Level	Integer	2	View
PAbllngtype	PA Billing Type	Integer	2	View
PAPREVPURCHTXOPT	PA Prev Purchase Tax Options	Integer	2	View
PAPurchase_Tax_Options	PA Purchase Tax Options	Integer	2	View
PAPREVCOSTXSCHED	PA Prev Cost Tax Schedule ID	String	16	View
PAPURCHTAXSCHED	PA Purchase Tax Schedule ID	String	16	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
PAPREVSALESTXOPT	PA Prev Sales Tax Options	Integer	2	View
PASales_Tax_Options	PA Sales Tax Options	Integer	2	View
PAPREVBILLTXSCHED	PA Prev Billing Tax Schedule ID	String	16	View
PAbilltaxscheduleid	PA Billing Tax Schedule ID	String	16	View
PAVarianceQty	PA Variance Qty	Currency	10	View
PAQtyQ	PA Quantity	Currency	10	View
PAVarianceCosts	PA Variance Costs	Currency	10	View
PAUNITCOST	PA Unit Cost	Currency	10	View
PAVARTOTCOST	PA Variance Total Cost	Currency	10	View
PAVAROVERHDAMT	PA Variance Total Overhead Amount	Currency	10	View
PATOTALOVERH	PA Total Overhead	Currency	10	View
PAVAROVERHDPRCNT	PA Variance Overhead Percent	Currency	10	View
PAOverheaPercentage	PA Overhead Percentage	Currency	10	View
PAVAROVRHDUNIT	PA Variance Overhead Per Unit	Currency	10	View
PAOvhdAmtPerUnit	PA Overhead Amount Per Unit	Currency	10	View
PATOTCST	PA Total Cost	Currency	10	View
PAVARMUPRCNT	PA Variance Markup Percentage	Currency	10	View
PAProfitPercent	PA Profit Percent	Currency	10	View
PAVARPROFAMT	PA Variance Profit Amount	Currency	10	View
PAProfitAmount	PA Profit Amount	Currency	10	View
PAVARTOTLPROF	PA Variance Total Profit	Currency	10	View
PATotalProfit	PA Total Profit	Currency	10	View
PAVARTOTBILLINGS	PA Variance Total Billings	Currency	10	View
PAtotbillings	PA Total Billings	Currency	10	View
PAORIGBUDGTAMT	PA Original Budget Amount	Currency	10	View
PAROGPROJAMT	PA Original Project Amount	Currency	10	View
PAVARPROJAMT	PA Variance Project Amount	Currency	10	View
PAProject_Amount	PA Project Amount	Currency	10	View
PAPREVPROJAMT	PA Prev Project Amount	Currency	10	View
PAPREVBASEQTY	PA Prev Base Qty	Currency	10	View
PABase_Qty	PA Base Qty	Currency	10	View
PAPREVBSEUNTCST	PA Prev Base Unit Cost	Currency	10	View
PABase_Unit_Cost	PA Base Unit Cost	Currency	10	View
PAPREVBSOVERHDCST	PA Prev Base Overhead Cost	Currency	10	View
PABaseOvhdCost	PA Base Overhead Cost	Currency	10	View
PAPREVBSPROFAMT	PA Prev Base Profit Amount	Currency	10	View
PABaseProfitAmount	PA Base Profit Amount	Currency	10	View
PAPROPQUOTEAMT	PA Propose Quote Amount	Currency	10	View
PAFINQUOTEAMT	PA Final Quote Amount	Currency	10	View
PAQUOTEPREPBY	PA Quote Prepared By	String	22	View
PAQUOTEAPPRVBY	PA Quote Approved By	String	22	View
PAREVBUDGTAMT	PA Revise Budget Amount	Currency	10	View
PAREVPROJAMT	PA Revise Project Amount	Currency	10	View
PAsequencenumber	PA Sequence Number 1	Integer	2	View
APPRVLDT	Approval Date	Date	4	View
PAClose_CB	PA Close CB	Boolean	2	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
PAPostRecogRevN	PA Actual Recognized Revenue	Currency	10	View
PAPOSBIEEAMOUNT	PA Actual BIEE Amount	Currency	10	View
PAPOSEIEBAMOUNT	PA Actual EIEB Amount	Currency	10	View
PApostbillamt	PA Actual Billed Amount	Currency	10	View
PA_Actual_Receipts_Amoun	PA Actual Receipts 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
ActualWriteOffAmount	Actual Write Off Amount	Currency	10	View
ActualDiscTakenAmount	Actual Discount Taken Amount	Currency	10	View
PAPostedTaxPaidN	PA Actual Tax Paid	Currency	10	View
PAPOSTRETAMT	PA Actual Retention Amount	Currency	10	View
PAActualWOTaxAmt	PA Actual Write Off Tax Amount	Currency	10	View
PAActualTermsTakenTax	PA Actual Terms Taken Tax Amt	Currency	10	View

PA23401 - PA Change Order Detail OPEN

Query Builder

Customer Service

Information

My Account

Contact Us