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

COMPANY..PA40901 Table Definition

(COMPANY..PA Vendor Class Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
VNDCLSID char(11)
''

PAddlDefpoformatouse smallint
0

PAUnit_of_Measure char(9)
''
PA Unit of...(more) Join Now
PAUNITCOST numeric(19,5)
0.00
PA Unit Co...(more) Join Now
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
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