DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3