GP Tables

PA33702 - PA Change Order Detail HIST

Dynamics GP table PA33702 (PA Change Order Detail HIST) contains 92 columns including PACONTNUMBER, PACHGORDNO, PACOTRKCHGBY....

SQL Query Builder

92 Columns

Column Description Type Length
PACONTNUMBER PA Contract Number String 12
PACHGORDNO PA Change Order Number String 18
PACOTRKCHGBY PA CO Track Changes By Integer 2
LNITMSEQ Line Item Sequence Long Integer 4
PAPROJNUMBER PA Project Number String 16
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PACOSTCATID PA Cost Category ID String 16
PALineItemSeq PA Line Item Sequence Long Integer 4
PAUnit_of_Measure PA Unit of Measure String 10
UOMSCHDL U Of M Schedule String 12
PAPREVBEGINDT PA Prev Begin Date Date 4
PAbegindate PA Begin Date Date 4
PAPREVENDDT PA Prev End Date Date 4
PAEnDate PA End Date Date 4
PAPREVPYCDESLY PA Prev Pay Code Salary String 8
PAPay_Code_Salary PA Pay Code Salary String 8
PAPREVPYCODEHOURLY PA Prev Pay Code Hourly String 8
PAPay_Code_Hourly PA Pay Code Hourly String 8
PAProfitType PA Profit Type1 = Billing Rate2 = Markup3 = Profit/Unit Fixed4 = Profit/Unit Variable5 = Total Profit6 = % of Baseline7 = % of Actual8 = None9 = Price Level Integer 2
PAbllngtype PA Billing Type Integer 2
PAPREVPURCHTXOPT PA Prev Purchase Tax Options Integer 2
PAPurchase_Tax_Options PA Purchase Tax Options Integer 2
PAPREVCOSTXSCHED PA Prev Cost Tax Schedule ID String 16
PAPURCHTAXSCHED PA Purchase Tax Schedule ID String 16
DECPLQTY Decimal Places QTYS Integer 2
DECPLCUR Decimal Places Currency Integer 2
PAPREVSALESTXOPT PA Prev Sales Tax Options Integer 2
PASales_Tax_Options PA Sales Tax Options Integer 2
PAPREVBILLTXSCHED PA Prev Billing Tax Schedule ID String 16
PAbilltaxscheduleid PA Billing Tax Schedule ID String 16
PAVarianceQty PA Variance Qty Currency 10
PAQtyQ PA Quantity Currency 10
PAVarianceCosts PA Variance Costs Currency 10
PAUNITCOST PA Unit Cost Currency 10
PAVARTOTCOST PA Variance Total Cost Currency 10
PAVAROVERHDAMT PA Variance Total Overhead Amount Currency 10
PATOTALOVERH PA Total Overhead Currency 10
PAVAROVERHDPRCNT PA Variance Overhead Percent Currency 10
PAOverheaPercentage PA Overhead Percentage Currency 10
PAVAROVRHDUNIT PA Variance Overhead Per Unit Currency 10
PAOvhdAmtPerUnit PA Overhead Amount Per Unit Currency 10
PATOTCST PA Total Cost Currency 10
PAVARMUPRCNT PA Variance Markup Percentage Currency 10
PAProfitPercent PA Profit Percent Currency 10
PAVARPROFAMT PA Variance Profit Amount Currency 10
PAProfitAmount PA Profit Amount Currency 10
PAVARTOTLPROF PA Variance Total Profit Currency 10
PATotalProfit PA Total Profit Currency 10
PAVARTOTBILLINGS PA Variance Total Billings Currency 10
PAtotbillings PA Total Billings Currency 10
PAORIGBUDGTAMT PA Original Budget Amount Currency 10
PAROGPROJAMT PA Original Project Amount Currency 10
PAVARPROJAMT PA Variance Project Amount Currency 10
PAProject_Amount PA Project Amount Currency 10
PAPREVPROJAMT PA Prev Project Amount Currency 10
PAPREVBASEQTY PA Prev Base Qty Currency 10
PABase_Qty PA Base Qty Currency 10
PAPREVBSEUNTCST PA Prev Base Unit Cost Currency 10
PABase_Unit_Cost PA Base Unit Cost Currency 10
PAPREVBSOVERHDCST PA Prev Base Overhead Cost Currency 10
PABaseOvhdCost PA Base Overhead Cost Currency 10
PAPREVBSPROFAMT PA Prev Base Profit Amount Currency 10
PABaseProfitAmount PA Base Profit Amount Currency 10
PAPROPQUOTEAMT PA Propose Quote Amount Currency 10
PAFINQUOTEAMT PA Final Quote Amount Currency 10
PAQUOTEPREPBY PA Quote Prepared By String 22
PAQUOTEAPPRVBY PA Quote Approved By String 22
PAREVBUDGTAMT PA Revise Budget Amount Currency 10
PAREVPROJAMT PA Revise Project Amount Currency 10
PAsequencenumber PA Sequence Number 1 Integer 2
APPRVLDT Approval Date Date 4
PAClose_CB PA Close CB Boolean 2
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
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
PAPostedTaxPaidN PA Actual Tax 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

Related Tables

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

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

PAPROJNUMBER

PA00402 PA00502 PA00503 PA01201 PA01221 PA01241 PA01251 PA01301

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21

PACONTNUMBER

PA01101 PA01121 PA01141 PA01161 PA01201 PA10001 PA10101 PA10201

PACOSTCATID

PA01001 PA01301 PA01303 PA01304 PA01341 PA01342 PA10001 PA10101

PACHGORDNO

PA01301 PA01303 PA02101 PA05200 PA10001 PA10101 PA10201 PA10501

DECPLCUR

AAG2001T ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23

PAUnit_of_Measure

PA00601 PA00701 PA00801 PA00901 PA01001 PA01301 PA01403 PA01405

PAUNITCOST

PA00601 PA00701 PA00801 PA00901 PA01001 PA01403 PA01405 PA01407

PAProfitType

PA01301 PA01403 PA01404 PA01405 PA01406 PA01407 PA10001 PA10101