GP Tables

PA41001 - PA Cost Category Class Setup File

Dynamics GP table PA41001 (PA Cost Category Class Setup File) contains 30 columns including PACOSTCATCLASID, PACOSTCATCLASNME, PADC....

SQL Query Builder

30 Columns

Column Description Type Length
PACOSTCATCLASID PA Cost Category Class ID String 16
PACOSTCATCLASNME PA Cost Category Class Name String 32
PADC PA Default Class Boolean 2
PATU PA Transaction Usage1 = Timesheet2 = Equipment Log3 = Miscellaneous Log4 = Purchases/Material5 = Employee Expense Integer 2
PAIV_Item_Checkbox PA IV Item Checkbox Boolean 2
PAUnit_of_Measure PA Unit of Measure String 10
UOMSCHDL U Of M Schedule String 12
DECPLQTY Decimal Places QTYS Integer 2
PAUNITCOST PA Unit Cost Currency 10
PAPay_Code_Hourly PA Pay Code Hourly String 8
PAPay_Code_Salary PA Pay Code Salary String 8
PATMProfitType PA Profit Type - TM1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level Integer 2
PATMProfitAmount PA Profit Amount - TM Currency 10
PATMProfitPercent PA Profit Percent - TM Currency 10
PAProfit_Type__CP PA Profit Type - CP1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level Integer 2
PAProfitAmountCP PA Profit Amount - CP Currency 10
PAProfitPercentCP PA Profit Percent - CP Currency 10
PAFFProfitType PA Profit Type - FF1 - Billing Rate2 - Markup %3 - Profit/Unit-Fixed4 - Profit/Unit-Variable5 - Total Profit6 - % of Baseline7 - % of Actual8 - None9 - Price Level Integer 2
PAFFProfitAmount PA Profit Amount - FF Currency 10
PAFFProfitPercent PA Profit Percent - FF Currency 10
DECPLCUR Decimal Places Currency 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
PAOverheadRateMethod PA Overhead Rate Method Integer 2
PAOvhdAmtPerUnit PA Overhead Amount Per Unit Currency 10
PAOverheaPercentage PA Overhead Percentage Currency 10
PAbillnoteidx PA Billing Note Index Currency 10
PANOTEINDEX PA Note Index Currency 10

Related Tables

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

UOMSCHDL

AAG00400 ADItemP2 ADItemPr ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21

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

PAbillnoteidx

PA01001 PA01101 PA01201 PA01301 PA01303 PA02101 PA10001 PA10101

DECPLQTY

AAG00400 ASIEXP04 ASIEXP11 ASIEXP19 ASIEXP20 ASIEXP21 ASIEXP23 ASIEXP24

PATU

PA000002 PA01001 PA01301 PA01304 PA01341 PA01342 PA10601 PA10702

PAOverheaPercentage

PA00601 PA01001 PA01403 PA10001 PA10101 PA10201 PA10501 PA10702

PAbilltaxscheduleid

PA00401 PA01001 PA02101 PA12001 PA12102 PA13201 PA13202 PA13203

PAPurchase_Tax_Options

PA01001 PA10501 PA10601 PA10702 PA10901 PA11801 PA12001 PA23401