Module List > Module AA tables AAG00314
You are currently viewing the COMPANY database.
Change

COMPANY..AAG00314 Table Definition

(COMPANY..aaMLQueryDet)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
aaMLQueryID int
0

aaColumn smallint
0

aaUseTree tinyint
0

aaUseCodes tinyint
0

aaTreeID int
0

aaTreeLevel int
0

aaInclEmptyCodes tinyint
0

aaSelectOption smallint
0

aaFromStr char(31)
''

aaToStr char(31)
''

aaFromNum numeric(19,5)
0.00

aaToNum numeric(19,5)
0.00

aaFromBool tinyint
0

aaToBool tinyint
0

aaFromDate datetime
'1/1/1900'

aaToDate datetime
'1/1/1900'

From_Account_Number_1 char(9)
''

From_Account_Number_2 char(9)
''

From_Account_Number_3 char(9)
''

From_Account_Number_4 char(9)
''

From_Account_Number_5 char(9)
''

To_Account_Number_1 char(9)
''

To_Account_Number_2 char(9)
''

To_Account_Number_3 char(9)
''

To_Account_Number_4 char(9)
''

To_Account_Number_5 char(9)
''

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