Module List > Module MX tables MXLS0020
You are currently viewing the COMPANY database.
Change

COMPANY..MXLS0020 Table Definition

(COMPANY..mxUserFavorites)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
DB char(31)
''

SQLName char(129)
''

FavoriteName char(51)
''

SelectType smallint
0

MaxRecords int
0

SearchType smallint
0

FieldName2_1 char(65)
''

FieldName2_2 char(65)
''

FieldName2_3 char(65)
''

FieldName2_4 char(65)
''

FieldOp_1 smallint
0

FieldOp_2 smallint
0

FieldOp_3 smallint
0

FieldOp_4 smallint
0

FieldTargetA_1 char(65)
''

FieldTargetA_2 char(65)
''

FieldTargetA_3 char(65)
''

FieldTargetA_4 char(65)
''

FieldTargetB_1 char(65)
''

FieldTargetB_2 char(65)
''

FieldTargetB_3 char(65)
''

FieldTargetB_4 char(65)
''

FieldCompare_1 tinyint
0

FieldCompare_2 tinyint
0

FieldCompare_3 tinyint
0

FieldCompare_4 tinyint
0

MatchCase_1 tinyint
0

MatchCase_2 tinyint
0

MatchCase_3 tinyint
0

MatchCase_4 tinyint
0

Datatype_1 char(21)
''

Datatype_2 char(21)
''

Datatype_3 char(21)
''

Datatype_4 char(21)
''

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