Module List >
Module MC tables
MC020105
You are currently viewing the COMPANY
database. Change
|
COMPANY..MC020105 Table Definition
(COMPANY..Multicurrency PM Revaluation Activity)
Field Definitions:
What is the 'source' column?
| VCHRNMBR |
char(21)
''
|
Voucher Nu...(more) Join Now
|
POP30300.VCHRNMBR
|
|
| DOCTYPE |
smallint
0
|
Document T...(more) Join Now
|
PM10000.DOCTYPE
|
|
| VENDORID |
char(15)
''
|
Vendor ID:...(more) Join Now
|
PM10000.VENDORID
|
join ... more text available
|
| CURNCYID |
char(15)
''
|
Currency I...(more) Join Now
|
|
join ... more text available
|
| CURRNIDX |
smallint
0
|
Currency I...(more) Join Now
|
|
join ... more text available
|
| SEQNUMBR |
int
0
|
Sequence N...(more) Join Now
|
DTA10200.SEQNUMBR
|
|
| DOCDATE |
datetime
'1/1/1900'
|
The date a...(more) Join Now
|
|
|
| RVLUDATE |
datetime
'1/1/1900'
|
|
|
|
| RevalPostDate |
datetime
'1/1/1900'
|
|
|
|
| RATETPID |
char(15)
''
|
A valid Ra...(more) Join Now
|
|
|
| RTCLCMTD |
smallint
0
|
Rate calcu...(more) Join Now
|
|
|
| XCHGRATE |
numeric(19,7)
0.00
|
Exchange R...(more) Join Now
|
|
|
| AUDITTRAIL |
char(13)
''
|
Audit Trai...(more) Join Now
|
CM20100.AUDITTRAIL
|
|
| DOCNUMBR |
char(21)
''
|
Document N...(more) Join Now
|
PM10000.DOCNUMBR
|
|
| GAINLOSS |
smallint
0
|
|
|
|
| GLCURTRX |
numeric(19,5)
0.00
|
|
|
|
| GLDSCAVL |
numeric(19,5)
0.00
|
|
|
|
| ORCTRXAM |
numeric(19,5)
0.00
|
|
|
|
| ORDAVAMT |
numeric(19,5)
0.00
|
Orig Disco...(more) Join Now
|
POP30300.ORDAVAMT
|
|
| CURTRXAR |
numeric(19,5)
0.00
|
|
|
|
| DSCAVAAR |
numeric(19,5)
0.00
|
|
|
|
| UnsettledCurrentGainLoss |
numeric(19,5)
0.00
|
|
|
|
| UnsettledAvailGainLoss |
numeric(19,5)
0.00
|
|
|
|
| Total_Gain_or_Loss_on_Cu |
numeric(19,5)
0.00
|
|
|
|
| Total_Gain_or_Loss_on_Di |
numeric(19,5)
0.00
|
|
|
|
| CURTRXAI |
int
0
|
|
|
|
| DSCAVAAI |
int
0
|
|
|
|
| RVLUEIDX |
int
0
|
|
|
|
| DENXRATE |
numeric(19,7)
0.00
|
Denominati...(more) Join Now
|
CM20200.DENXRATE
|
|
| MCTRXSTT |
smallint
0
|
MC Transac...(more) Join Now
|
CM20200.MCTRXSTT
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
| SettledGainLossCurTrxAmt |
numeric
0.00
|
|
|
|
| SettledGainLossDiscAvlAm |
numeric
0.00
|
|
|
|
|