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

COMPANY..ME142802 Table Definition

(COMPANY..ME AutoRec Download MSTR)
This table contains master information specific to downloads 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
ARNUM char(21)
''
This field...(more) Join Now
MEBANKID char(21)
''

Output_Format char(21)
''
This field...(more) Join Now
BANKID char(15)
''
This field...(more) Join Now
BANKNAME char(31)
''
This field...(more) Join Now
BNKBRNCH char(21)
''
This field...(more) Join Now
PHONE1 char(21)
''
This field...(more) Join Now
PHONE2 char(21)
''
This field...(more) Join Now
HYPELINK tinyint
0
This check...(more) Join Now
ARDLFILAPTH char(81)
''
This field...(more) Join Now
ME_CommLink_Path char(81)
''
This field...(more) Join Now
MEARDLID char(21)
''
This field...(more) Join Now
MKLSSTDD datetime
'1/1/1900'
This field...(more) Join Now
MELDTDT datetime
'1/1/1900'
This field...(more) Join Now
Last_Reconciled_Date datetime
'1/1/1900'
This field...(more) Join Now
Last_Reconciled_Balance numeric(19,5)
0.00
This field...(more) Join Now
ME_Number_of_Checks smallint
0
This field...(more) Join Now
ME_Number_of_deps smallint
0
This field...(more) Join Now
ME_Debits_Total numeric(19,5)
0.00
This field...(more) Join Now
ME_Credits_Total numeric(19,5)
0.00
This field...(more) Join Now
USERDATE datetime
'1/1/1900'
This field...(more) Join Now
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
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