GP Tables

PA89422 - PA Budget Template File Lookup

Dynamics GP table PA89422 (PA Budget Template File Lookup) contains 82 columns including PACTID, PAPTID, PATU....

SQL Query Builder

82 Columns

Column Description Type Length
PACTID PA Contract Template ID String 16
PAPTID PA Project Template ID String 16
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PACOSTCATID PA Cost Category ID String 16
PAIV_Item_Checkbox PA IV Item Checkbox Boolean 2
PASTAT PA Status1 = Open2 = On Hold3 = Closed4 = Estimate5 = Completed Integer 2
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
PABase_Qty PA Base Qty Currency 10
PABase_Unit_Cost PA Base Unit Cost Currency 10
PABaseProfitAmount PA Base Profit Amount Currency 10
PABaseOvhdCost PA Base Overhead Cost Currency 10
PAForecastBaseOvrhdAmt PA Forecast Base Overhead Amount Currency 10
PABBeginDate PA Baseline Begin Date Date 4
PABEndDate PA Baseline End Date Date 4
PABQuantity PA Baseline Quantity Currency 10
PABUnitCost PA Baseline Unit Cost Currency 10
PABTotalCost PA Baseline Total Cost Currency 10
PABBillings PA Baseline Billings Currency 10
PABProfit PA Baseline Profit Currency 10
PABProfitAmt PA Baseline Profit Amount Currency 10
PABProfitPcnt PA Baseline Profit Percent 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
PAForecastBaseQty PA Forecast Base Qty Currency 10
PAForecastBaseUnitCost PA Forecast Base Unit Cost Currency 10
PAFBeginDate PA Forecast Begin Date Date 4
PAFEndDate PA Forecast End Date Date 4
PAFQuantity PA Forecast Quantity Currency 10
PAFUnitCost PA Forecast Unit Cost Currency 10
PAFTotalCost PA Forecast Total Cost Currency 10
PAFBillings PA Forecast Billings Currency 10
PAFProfit PA Forecast Profit Currency 10
PAFProfitAmt PA Forecast Profit Amount Currency 10
PAFProfitPcnt PA Forecast Profit Percent 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
PAUnit_of_Measure PA Unit of Measure String 10
UOMSCHDL U Of M Schedule String 12
PAUOfMMult PA UOfM Multiplier Currency 10
DECPLQTY Decimal Places QTYS Integer 2
PAPay_Code_Hourly PA Pay Code Hourly String 8
PAPay_Code_Salary PA Pay Code Salary String 8
DECPLCUR Decimal Places Currency Integer 2
PALabor_Rate_Table_ID PA Labor Rate Table ID String 32
PALabor_RateTable_Type PA Labor Rate Table Type Integer 2
PALabor_Rate_Table_Acc PA Labor Rate Table Accept Boolean 2
PAEquip_Rate_Table_ID PA Equip Rate Table ID String 32
PAEquip_Rate_Table_Acc PA Equip Rate Table Accept Boolean 2
TM_WIP_SRC TM WIP SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_COGS_SRC TM COGS SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_Cost_Contra_SRC TM Cost Contra SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_Unbilled_AR_SRC TM Unbilled AR SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_Unbilled_Rev_SRC TM Unbilled Rev SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_AR_SRC TM AR SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_Prj_Rev_SRC TM Prj Rev SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
TM_OVHD_SRC TM OVHD SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category6 –Trx Owner7 – Specific Integer 2
FF_WIP_SRC FF WIP SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_Cost_Contra_SRC FF Cost Contra SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_AR_SRC FF AR SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_Prj_Billings_SRC FF Prj Billings SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_Prj_Expense_SRC FF Prj Expense SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_Prj_Revenue_SRC FF Prj Revenue SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_Prj_Loss_SRC FF Prj Loss SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_BIEE_SRC FF BIEE SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_EIEB_SRC FF EIEB SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
FF_OVHD_SRC FF OVHD SRC1 – None2 – Customer3 – Contract4 – Project5 – Cost Category Integer 2
PAcostaxscheduleid PA Cost Tax Schedule ID String 16
PAPurchase_Tax_Options PA Purchase Tax Options Integer 2
PAbilltaxscheduleid PA Billing Tax Schedule ID String 16
PASales_Tax_Options PA Sales Tax Options Integer 2
PAProject_Amount PA Project Amount Currency 10
PAOverheadRateMethod PA Overhead Rate Method Integer 2
PABaselineOvhdAmtPerUnit PA Baseline Overhead Amount Per Unit Currency 10
PABaselineOvrhdPct PA Baseline Overhead Percentage Currency 10
PAForecastOvrhdAmtPerUnt PA Forecast Overhead Amount Per Unit Currency 10
PAForecastOvrhdPct PA Forecast Overhead Percentage Currency 10
LNITMSEQ Line Item Sequence Long Integer 4
PALineItemSeq PA Line Item Sequence Long Integer 4
PAbillnoteidx PA Billing Note Index Currency 10

Related Tables

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

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21

PACOSTCATID

PA01001 PA01301 PA01303 PA01304 PA01341 PA01342 PA10001 PA10101

DECPLCUR

AAG2001T ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP22 ASIEXP23

PAUnit_of_Measure

PA00601 PA00701 PA00801 PA00901 PA01001 PA01301 PA01403 PA01405

PAbillnoteidx

PA01001 PA01101 PA01201 PA01301 PA01303 PA02101 PA10001 PA10101

PAProfitType

PA01301 PA01403 PA01404 PA01405 PA01406 PA01407 PA10001 PA10101

DECPLQTY

AAG00400 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

PAbllngtype

PA01201 PA01301 PA01303 PA10001 PA10101 PA10201 PA10501 PA10702

PATU

PA000002 PA01001 PA01301 PA01304 PA01341 PA01342 PA10601 PA10702