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

COMPANY..AF40103 Table Definition

(COMPANY..Financials Column Setup)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
REPORTID smallint
0

COLNUM smallint
0

CLTKNCNT smallint
0

COLTYPE smallint
0

COLSIZE smallint
0

COLOMCNT smallint
0

COLOFMRK_1 smallint
0

COLOFMRK_2 smallint
0

COLOFMRK_3 smallint
0

COLOFMRK_4 smallint
0

HIDEFLAG smallint
0

TEXTVALU char(51)
''

STPERIOD smallint
0

ENDPEROD smallint
0

AMNTFROM smallint
0

HISTYEAR smallint
0

BUDID char(15)
''

PRTSIGN smallint
0

PRTCOMMA smallint
0

PRTPCENT smallint
0

PRTTEXT smallint
0

ROUNDOPT smallint
0

HEADALIN smallint
0

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
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
''

DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
SEGTO_6 char
''

SEGTO_7 char
''

SEGTO_8 char
''

SEGTO_9 char
''

SEGTO_10 char
''

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