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
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
Module List > Module Extender tables > EXT40602
DynDeveloper Table Reference is in Wiki format! Registered users have the ability to improve the table reference, add comments, and generally make the world a better place.
You are currently viewing the COMPANY database.
Change

COMPANY..EXT40602 Table Definition

(COMPANY..Extender Dialog Restrictions)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Warning_ID char(15)
''

LNITMSEQ int
0
The unique...(more) Join Now
PRODID smallint
0

TABLTECH char(79)
''

FIELDNAM char(31)
''

Restriction_Type smallint
0

User_Defined_Currency_1 numeric(19,5)
0.00

User_Defined_Currency_2 numeric(19,5)
0.00

User_Defined_Currency_3 numeric(19,5)
0.00

User_Defined_Currency_4 numeric(19,5)
0.00

User_Defined_Currency_5 numeric(19,5)
0.00

User_Defined_Currency_6 numeric(19,5)
0.00

User_Defined_Currency_7 numeric(19,5)
0.00

User_Defined_Currency_8 numeric(19,5)
0.00

User_Defined_Currency_9 numeric(19,5)
0.00

User_Defined_Currency_10 numeric(19,5)
0.00

User_Defined_Currency_11 numeric(19,5)
0.00

User_Defined_Currency_12 numeric(19,5)
0.00

User_Defined_Currency_13 numeric(19,5)
0.00

User_Defined_Currency_14 numeric(19,5)
0.00

User_Defined_Currency_15 numeric(19,5)
0.00

User_Defined_Currency_16 numeric(19,5)
0.00

User_Defined_Currency_17 numeric(19,5)
0.00

User_Defined_Currency_18 numeric(19,5)
0.00

User_Defined_Currency_19 numeric(19,5)
0.00

User_Defined_Currency_20 numeric(19,5)
0.00

User_Defined_Currency_21 numeric(19,5)
0.00

User_Defined_Currency_22 numeric(19,5)
0.00

User_Defined_Currency_23 numeric(19,5)
0.00

User_Defined_Currency_24 numeric(19,5)
0.00

User_Defined_Currency_25 numeric(19,5)
0.00

User_Defined_Currency_26 numeric(19,5)
0.00

User_Defined_Currency_27 numeric(19,5)
0.00

User_Defined_Currency_28 numeric(19,5)
0.00

User_Defined_Currency_29 numeric(19,5)
0.00

User_Defined_Currency_30 numeric(19,5)
0.00

User_Defined_Dates_1 datetime
'1/1/1900'

User_Defined_Dates_2 datetime
'1/1/1900'

User_Defined_Dates_3 datetime
'1/1/1900'

User_Defined_Dates_4 datetime
'1/1/1900'

User_Defined_Dates_5 datetime
'1/1/1900'

User_Defined_Dates_6 datetime
'1/1/1900'

User_Defined_Dates_7 datetime
'1/1/1900'

User_Defined_Dates_8 datetime
'1/1/1900'

User_Defined_Dates_9 datetime
'1/1/1900'

User_Defined_Dates_10 datetime
'1/1/1900'

User_Defined_Dates_11 datetime
'1/1/1900'

User_Defined_Dates_12 datetime
'1/1/1900'

User_Defined_Dates_13 datetime
'1/1/1900'

User_Defined_Dates_14 datetime
'1/1/1900'

User_Defined_Dates_15 datetime
'1/1/1900'

User_Defined_Dates_16 datetime
'1/1/1900'

User_Defined_Dates_17 datetime
'1/1/1900'

User_Defined_Dates_18 datetime
'1/1/1900'

User_Defined_Dates_19 datetime
'1/1/1900'

User_Defined_Dates_20 datetime
'1/1/1900'

User_Defined_Dates_21 datetime
'1/1/1900'

User_Defined_Dates_22 datetime
'1/1/1900'

User_Defined_Dates_23 datetime
'1/1/1900'

User_Defined_Dates_24 datetime
'1/1/1900'

User_Defined_Dates_25 datetime
'1/1/1900'

User_Defined_Dates_26 datetime
'1/1/1900'

User_Defined_Dates_27 datetime
'1/1/1900'

User_Defined_Dates_28 datetime
'1/1/1900'

User_Defined_Dates_29 datetime
'1/1/1900'

User_Defined_Dates_30 datetime
'1/1/1900'

User_Defined_Integer_1 int
0

User_Defined_Integer_2 int
0

User_Defined_Integer_3 int
0

User_Defined_Integer_4 int
0

User_Defined_Integer_5 int
0

User_Defined_Integer_6 int
0

User_Defined_Integer_7 int
0

User_Defined_Integer_8 int
0

User_Defined_Integer_9 int
0

User_Defined_Integer_10 int
0

User_Defined_Integer_11 int
0

User_Defined_Integer_12 int
0

User_Defined_Integer_13 int
0

User_Defined_Integer_14 int
0

User_Defined_Integer_15 int
0

User_Defined_Integer_16 int
0

User_Defined_Integer_17 int
0

User_Defined_Integer_18 int
0

User_Defined_Integer_19 int
0

User_Defined_Integer_20 int
0

User_Defined_Integer_21 int
0

User_Defined_Integer_22 int
0

User_Defined_Integer_23 int
0

User_Defined_Integer_24 int
0

User_Defined_Integer_25 int
0

User_Defined_Integer_26 int
0

User_Defined_Integer_27 int
0

User_Defined_Integer_28 int
0

User_Defined_Integer_29 int
0

User_Defined_Integer_30 int
0

UD_Short_String_1 char(31)
''

UD_Short_String_2 char(31)
''

UD_Short_String_3 char(31)
''

UD_Short_String_4 char(31)
''

UD_Short_String_5 char(31)
''

UD_Short_String_6 char(31)
''

UD_Short_String_7 char(31)
''

UD_Short_String_8 char(31)
''

UD_Short_String_9 char(31)
''

UD_Short_String_10 char(31)
''

UD_Short_String_11 char(31)
''

UD_Short_String_12 char(31)
''

UD_Short_String_13 char(31)
''

UD_Short_String_14 char(31)
''

UD_Short_String_15 char(31)
''

UD_Short_String_16 char(31)
''

UD_Short_String_17 char(31)
''

UD_Short_String_18 char(31)
''

UD_Short_String_19 char(31)
''

UD_Short_String_20 char(31)
''

UD_Short_String_21 char(31)
''

UD_Short_String_22 char(31)
''

UD_Short_String_23 char(31)
''

UD_Short_String_24 char(31)
''

UD_Short_String_25 char(31)
''

UD_Short_String_26 char(31)
''

UD_Short_String_27 char(31)
''

UD_Short_String_28 char(31)
''

UD_Short_String_29 char(31)
''

UD_Short_String_30 char(31)
''

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