| EMPLOYID |
char(15)
''
|
Employee I...(more) Join Now
|
APR_BSS00100.EMPLOYID
|
|
join ... more text available
|
| PAfileemplreim |
tinyint
0
|
Set to 1 t...(more) Join Now
|
|
|
|
| PANOTA1099VENDOR |
tinyint
0
|
Set to 1 t...(more) Join Now
|
|
|
|
| PApmcb |
tinyint
0
|
|
|
|
|
| PAbmcb |
tinyint
0
|
|
|
|
|
| PAEmployee_Type |
smallint
0
|
0 = Full T...(more) Join Now
|
|
|
|
| PA_Employed_By |
smallint
0
|
1=Companyb...(more) Join Now
|
|
|
|
| PAPayCode |
char(7)
''
|
|
|
|
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
MC40200.CURNCYID
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
|
join ... more text available
|
| RATETPID |
char(15)
''
|
|
|
|
|
| EXGTBLID |
char(15)
''
|
Exchange T...(more) Join Now
|
MC00100.EXGTBLID
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
MC00100.XCHGRATE
|
|
|
| EXCHDATE |
datetime
'1/1/1900'
|
Exchange D...(more) Join Now
|
|
|
|
| TIME1 |
datetime
'1/1/1900'
|
Time Time...(more) Join Now
|
WO010213.TIME1
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
MC40300.RTCLCMTD
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
CM20200.MCTRXSTT
|
|
|
| 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
|
|
|
| PA_Orig_Profit_AmtTM |
numeric(19,5)
0.00
|
|
|
|
|
| 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
|
|
|
|
| PAUD1 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PAUD2 |
char(21)
''
|
PA User De...(more) Join Now
|
|
|
|
| PA_Allow_Vendor_For_PO |
tinyint
0
|
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|