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 |
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 |
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 |