Module List > Module MC tables MC020105
You are currently viewing the COMPANY database.
Change

COMPANY..MC020105 Table Definition

(COMPANY..Multicurrency PM Revaluation Activity)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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

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