Module List > Module PA tables PA41001
You are currently viewing the COMPANY database.
Change

COMPANY..PA41001 Table Definition

(COMPANY..PA Cost Category Class Setup File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PACOSTCATCLASID char(15)
''
PA Cost Ca...(more) Join Now
PACOSTCATCLASNME char(31)
''

PADC tinyint
0

PATU smallint
0
PA Transac...(more) Join Now
PAIV_Item_Checkbox tinyint
0

PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
UOMSCHDL char(11)
''
U Of M Sch...(more) Join Now
join ... more text available
DECPLQTY smallint
0
Decimal Pl...(more) Join Now
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
PAPay_Code_Hourly char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Hourly
PAPay_Code_Salary char(7)
''
PA Pay Cod...(more) Join Now PA01001.PAPay_Code_Salary
PATMProfitType smallint
0
PA Profit ...(more) Join Now PA01001.PATMProfitType
PATMProfitAmount numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PATMProfitAmount
PATMProfitPercent numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PATMProfitPercent
PAProfit_Type__CP smallint
0
PA Profit ...(more) Join Now PA01001.PAProfit_Type__CP
PAProfitAmountCP numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAProfitAmountCP
PAProfitPercentCP numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAProfitPercentCP
PAFFProfitType smallint
0
PA Profit ...(more) Join Now PA01001.PAFFProfitType
PAFFProfitAmount numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAFFProfitAmount
PAFFProfitPercent numeric(19,5)
0.00
PA Profit ...(more) Join Now PA01001.PAFFProfitPercent
DECPLCUR smallint
0
Number of ...(more) Join Now
PAcostaxscheduleid char(15)
''
PA Cost Ta...(more) Join Now PA01001.PAcostaxscheduleid
PAPurchase_Tax_Options smallint
0
PA Purchas...(more) Join Now
PAbilltaxscheduleid char(15)
''
PA Billing...(more) Join Now
PASales_Tax_Options smallint
0
PA Sales T...(more) Join Now
PAOverheadRateMethod smallint
0
PA Overhea...(more) Join Now PA01001.PAOverheadRateMethod
PAOvhdAmtPerUnit numeric(19,5)
0.00
PA Overhea...(more) Join Now PA01001.PAOvhdAmtPerUnit
PAOverheaPercentage numeric(19,5)
0.00
PA Overhea...(more) Join Now
PAbillnoteidx numeric(19,5)
0.00
PA Billing...(more) Join Now
PANOTEINDEX numeric(19,5)
0.00
PA Note In...(more) Join Now PA01001.PANOTEINDEX
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3