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

COMPANY..PA00701 Table Definition

(COMPANY..PA Equipment Master File)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
PAEQUIPTID char(15)
''

PAEQNME char(31)
''

PAEQUIPTCLSID char(15)
''

PAinactive tinyint
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
PAUD1 char(21)
''
PA User De...(more) Join Now
PAUD2 char(21)
''
PA User De...(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