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

COMPANY..MC00500 Table Definition

(COMPANY..Multicurrency Posting Definitions Master)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
BCHSOURC char(15)
''
Batch Sour...(more) Join Now
BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
SERIES smallint
0
Series: I...(more) Join Now SY00500.SERIES
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
CURRNIDX smallint
0
Currency I...(more) Join Now
join ... more text available
ORIGCNTRLTOT numeric(19,5)
0.00

ORIGBTCHTOT numeric(19,5)
0.00

EXGTBLID char(15)
''
Exchange T...(more) Join Now
XCHGRATE numeric(19,7)
0.00
Exchange R...(more) Join Now
RATETPID char(15)
''
A valid Ra...(more) Join Now
RTCLCMTD smallint
0
Rate calcu...(more) Join Now
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
EXCHDATE datetime
'1/1/1900'
Exchange D...(more) Join Now
CHEKDATE datetime
'1/1/1900'
Check Date...(more) Join Now PM10000.CHEKDATE
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
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