Module List > Module AF tables AF50300
You are currently viewing the COMPANY database.
Change

COMPANY..AF50300 Table Definition

(COMPANY..Report Column Temporary)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
USERID char(15)
''
The user t...(more) Join Now
join ... more text available
REPORTID smallint
0

RPTGRIND smallint
0

RTPACHIN smallint
0

RTGRSBIN numeric(19,5)
0.00

COLNUM smallint
0

CLTKNCNT smallint
0

COLTYPE smallint
0

COLSIZE smallint
0

COLOFMRK_1 smallint
0

COLOFMRK_2 smallint
0

COLOFMRK_3 smallint
0

COLOFMRK_4 smallint
0

COLOMCNT smallint
0

HIDEFLAG smallint
0

TEXTVALU char(51)
''

STPERIOD smallint
0

ENDPEROD smallint
0

SEGFROM_1 char(5)
''

SEGFROM_2 char(5)
''

SEGFROM_3 char(5)
''

SEGFROM_4 char(5)
''

SEGFROM_5 char(5)
''

SEGFROM_6 char
''

SEGTO_1 char(5)
''

SEGFROM_7 char
''

SEGTO_2 char(5)
''

SEGTO_3 char(5)
''

SEGFROM_8 char
''

SEGFROM_9 char
''

SEGTO_4 char(5)
''

SEGTO_5 char(5)
''

SEGFROM_10 char
''

AMNTFROM smallint
0

HISTYEAR smallint
0

BUDID char(15)
''

PRTSIGN smallint
0

PRTCOMMA smallint
0

PRTPCENT smallint
0

SEGTO_6 char
''

SEGTO_7 char
''

PRTTEXT smallint
0

ROUNDOPT smallint
0

SEGTO_8 char
''

SEGTO_9 char
''

HEADALIN smallint
0

SEGTO_10 char
''

HDFTFMLY smallint
0

HDFTSIZE smallint
0

HEDSTYLE_1 smallint
0

HEDSTYLE_2 smallint
0

HEDSTYLE_3 smallint
0

HEDSTYLE_4 smallint
0

HEDSTYLE_5 smallint
0

HEDSTYLE_6 smallint
0

HEADTYPE_1 smallint
0

HEADTYPE_2 smallint
0

HEADTYPE_3 smallint
0

HEADTYPE_4 smallint
0

HEADTYPE_5 smallint
0

HEADTYPE_6 smallint
0

HEDFRMAT_1 smallint
0

HEDFRMAT_2 smallint
0

HEDFRMAT_3 smallint
0

HEDFRMAT_4 smallint
0

HEDFRMAT_5 smallint
0

HEDFRMAT_6 smallint
0

HEADOPT_1 smallint
0

HEADOPT_2 smallint
0

HEADOPT_3 smallint
0

HEADOPT_4 smallint
0

HEADOPT_5 smallint
0

HEADOPT_6 smallint
0

HEADOPT2_1 smallint
0

HEADOPT2_2 smallint
0

HEADOPT2_3 smallint
0

HEADOPT2_4 smallint
0

HEADOPT2_5 smallint
0

HEADOPT2_6 smallint
0

COLHDNG_1 char(51)
''

COLHDNG_2 char(51)
''

COLHDNG_3 char(51)
''

COLHDNG_4 char(51)
''

COLHDNG_5 char(51)
''

COLHDNG_6 char(51)
''

COLHDNG2_1 char(51)
''

COLHDNG2_2 char(51)
''

COLHDNG2_3 char(51)
''

COLHDNG2_4 char(51)
''

COLHDNG2_5 char(51)
''

COLHDNG2_6 char(51)
''

ALGNOFST smallint
0

COLEXPER tinyint
0

NOTEINDX numeric(19,5)
0.00
Note Index...(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