Module List > Module ME tables ME142807
You are currently viewing the COMPANY database.
Change

COMPANY..ME142807 Table Definition

(COMPANY..ME Download Transactions)
This table contains information specific to the transactions of the output format layouts for different banks, which can be altered if a financial institution’s requirements change
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
MEARDLID char(21)
''
This field...(more) Join Now
SEQNUMBR int
0
This field...(more) Join Now
ARNUM char(21)
''
This field...(more) Join Now
ME_Transaction_Code char(41)
''
This field...(more) Join Now
METRXSTATCODE char(21)
''
This field...(more) Join Now
ME_Updated_CMTrx_Table tinyint
0
This boole...(more) Join Now
ME_Updated_Date datetime
'1/1/1900'
This field...(more) Join Now
ME_Download_Date datetime
'1/1/1900'
This field...(more) Join Now
ME_Download_Time datetime
'1/1/1900'
This field...(more) Join Now
ME_Updated_User_ID char(15)
''
This field...(more) Join Now
CHEKBKID char(15)
''
This field...(more) Join Now
join ... more text available
ME_Account_Holder char(41)
''
This field...(more) Join Now
TRXDATE datetime
'1/1/1900'
This field...(more) Join Now
CMTrxNum char(21)
''
This field...(more) Join Now
ME_Is_a_Clear tinyint
0
This boole...(more) Join Now
CMTrxType smallint
0
This field...(more) Join Now
paidtorcvdfrom char(65)
''
This field...(more) Join Now
DSCRIPTN char(31)
''
This field...(more) Join Now
TRX_CODE_DESC char
''

DSTINDX int
0
This field...(more) Join Now
ACTNUMBR_1 char(5)
''
This field...(more) Join Now
ACTNUMBR_2 char(5)
''
This field...(more) Join Now
ACTNUMBR_3 char(5)
''
This field...(more) Join Now
ACTNUMBR_4 char(5)
''
This field...(more) Join Now
ACTNUMBR_5 char(5)
''
This field...(more) Join Now
DOCTYPE smallint
0
This field...(more) Join Now
DistRef char(31)
''
This field...(more) Join Now
ME_Transaction_Type smallint
0

CURNCYID char
''
Currency I...(more) Join Now RM20102.CURNCYID
join ... more text available
TRXAMNT numeric(19,5)
0.00

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
USERDATE datetime
'1/1/1900'
This field...(more) Join Now
ME_Dummy_File_Convert_De tinyint
0
This boole...(more) Join Now
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