Module List >
Module PA tables
PA40601
You are currently viewing the COMPANY
database.
Change
|
COMPANY..PA40601 Table Definition
(COMPANY..PA Employee Class Setup)
Field Definitions:
What is the 'source' column?
| EMPLCLAS |
char(15)
''
|
Employee C...(more) Join Now
|
UPR00100.EMPLCLAS
|
|
join ... more text available
|
| PAEmployee_Type |
smallint
0
|
0 = Full T...(more) Join Now
|
|
|
|
| PA_Employed_By |
smallint
0
|
1=Companyb...(more) Join Now
|
|
|
|
| PAPayCode |
char(7)
''
|
|
|
|
|
| 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
|
|
|
| VENDORID |
char(15)
''
|
Vendor ID ...(more) Join Now
|
WC010931.VENDORID
|
|
join ... more text available
|
| 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
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|
|