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 > EXT40300
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..EXT40300 Table Definition

(COMPANY..Extender Forms)

4Penny.net

Field Definitions:

What is the 'source' column?

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

Extender_Form_Name char(65)
''

Extender_Form_ID_Prompt char(51)
''

Extender_Description_Pro char(51)
''

User_Defined_Prompts_1 char(31)
''

User_Defined_Prompts_2 char(31)
''

User_Defined_Prompts_3 char(31)
''

User_Defined_Prompts_4 char(31)
''

User_Defined_Prompts_5 char(31)
''

User_Defined_Prompts_6 char(31)
''

User_Defined_Prompts_7 char(31)
''

User_Defined_Prompts_8 char(31)
''

User_Defined_Prompts_9 char(31)
''

User_Defined_Prompts_10 char(31)
''

User_Defined_Prompts_11 char(31)
''

User_Defined_Prompts_12 char(31)
''

User_Defined_Prompts_13 char(31)
''

User_Defined_Prompts_14 char(31)
''

User_Defined_Prompts_15 char(31)
''

User_Defined_Prompts_16 char(31)
''

User_Defined_Prompts_17 char(31)
''

User_Defined_Prompts_18 char(31)
''

User_Defined_Prompts_19 char(31)
''

User_Defined_Prompts_20 char(31)
''

User_Defined_Prompts_2_1 char(31)
''

User_Defined_Prompts_2_2 char(31)
''

User_Defined_Prompts_2_3 char(31)
''

User_Defined_Prompts_2_4 char(31)
''

User_Defined_Prompts_2_5 char(31)
''

User_Defined_Prompts_2_6 char(31)
''

User_Defined_Prompts_2_7 char(31)
''

User_Defined_Prompts_2_8 char(31)
''

User_Defined_Prompts_2_9 char(31)
''

User_Defined_Prompts_2_10 char(31)
''

User_Defined_Prompts_2_11 char(31)
''

User_Defined_Prompts_2_12 char(31)
''

User_Defined_Prompts_2_13 char(31)
''

User_Defined_Prompts_2_14 char(31)
''

User_Defined_Prompts_2_15 char(31)
''

User_Defined_Prompts_2_16 char(31)
''

User_Defined_Prompts_2_17 char(31)
''

User_Defined_Prompts_2_18 char(31)
''

User_Defined_Prompts_2_19 char(31)
''

User_Defined_Prompts_2_20 char(31)
''

User_Defined_Field_Type_1 smallint
0

User_Defined_Field_Type_2 smallint
0

User_Defined_Field_Type_3 smallint
0

User_Defined_Field_Type_4 smallint
0

User_Defined_Field_Type_5 smallint
0

User_Defined_Field_Type_6 smallint
0

User_Defined_Field_Type_7 smallint
0

User_Defined_Field_Type_8 smallint
0

User_Defined_Field_Type_9 smallint
0

User_Defined_Field_Type_10 smallint
0

User_Defined_Field_Type_11 smallint
0

User_Defined_Field_Type_12 smallint
0

User_Defined_Field_Type_13 smallint
0

User_Defined_Field_Type_14 smallint
0

User_Defined_Field_Type_15 smallint
0

User_Defined_Field_Type_16 smallint
0

User_Defined_Field_Type_17 smallint
0

User_Defined_Field_Type_18 smallint
0

User_Defined_Field_Type_19 smallint
0

User_Defined_Field_Type_20 smallint
0

User_Defined_Field_Types_1 smallint
0

User_Defined_Field_Types_2 smallint
0

User_Defined_Field_Types_3 smallint
0

User_Defined_Field_Types_4 smallint
0

User_Defined_Field_Types_5 smallint
0

User_Defined_Field_Types_6 smallint
0

User_Defined_Field_Types_7 smallint
0

User_Defined_Field_Types_8 smallint
0

User_Defined_Field_Types_9 smallint
0

User_Defined_Field_Types_10 smallint
0

User_Defined_Field_Types_11 smallint
0

User_Defined_Field_Types_12 smallint
0

User_Defined_Field_Types_13 smallint
0

User_Defined_Field_Types_14 smallint
0

User_Defined_Field_Types_15 smallint
0

User_Defined_Field_Types_16 smallint
0

User_Defined_Field_Types_17 smallint
0

User_Defined_Field_Types_18 smallint
0

User_Defined_Field_Types_19 smallint
0

User_Defined_Field_Types_20 smallint
0

Tab_Order smallint
0

Insert_Gap_CB tinyint
0

Gap smallint
0

Add_To_Explorer tinyint
0

Add_To_Lookup_List tinyint
0

Extender_Lookup_Name char(65)
''

Extender_Explorer_Desc char(65)
''

Extender_Explorer_Series_1 int
0

Extender_Explorer_Series_2 int
0

Required_CB_1 tinyint
0

Required_CB_2 tinyint
0

Required_CB_3 tinyint
0

Required_CB_4 tinyint
0

Required_CB_5 tinyint
0

Required_CB_6 tinyint
0

Required_CB_7 tinyint
0

Required_CB_8 tinyint
0

Required_CB_9 tinyint
0

Required_CB_10 tinyint
0

Required_CB_11 tinyint
0

Required_CB_12 tinyint
0

Required_CB_13 tinyint
0

Required_CB_14 tinyint
0

Required_CB_15 tinyint
0

Required_CB_16 tinyint
0

Required_CB_17 tinyint
0

Required_CB_18 tinyint
0

Required_CB_19 tinyint
0

Required_CB_20 tinyint
0

Required_2_CB_1 tinyint
0

Required_2_CB_2 tinyint
0

Required_2_CB_3 tinyint
0

Required_2_CB_4 tinyint
0

Required_2_CB_5 tinyint
0

Required_2_CB_6 tinyint
0

Required_2_CB_7 tinyint
0

Required_2_CB_8 tinyint
0

Required_2_CB_9 tinyint
0

Required_2_CB_10 tinyint
0

Required_2_CB_11 tinyint
0

Required_2_CB_12 tinyint
0

Required_2_CB_13 tinyint
0

Required_2_CB_14 tinyint
0

Required_2_CB_15 tinyint
0

Required_2_CB_16 tinyint
0

Required_2_CB_17 tinyint
0

Required_2_CB_18 tinyint
0

Required_2_CB_19 tinyint
0

Required_2_CB_20 tinyint
0

PRODID smallint
0

FORMNAME char(79)
''

Autoincrement tinyint
0

NOTEINDX numeric(19,5)
0.00
ID of the ...(more) Join Now
join ... more text available
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now POP10100.CREATDDT
CRUSRID char(15)
''

MODIFDT datetime
'1/1/1900'
The last d...(more) Join Now
MDFUSRID char(15)
''
The userna...(more) Join Now
join ... more text available
LookupsDDL_1 smallint
0

LookupsDDL_2 smallint
0

LookupsDDL_3 smallint
0

LookupsDDL_4 smallint
0

LookupsDDL_5 smallint
0

LookupsDDL_6 smallint
0

LookupsDDL_7 smallint
0

LookupsDDL_8 smallint
0

LookupsDDL_9 smallint
0

LookupsDDL_10 smallint
0

LookupsDDL_11 smallint
0

LookupsDDL_12 smallint
0

LookupsDDL_13 smallint
0

LookupsDDL_14 smallint
0

LookupsDDL_15 smallint
0

LookupsDDL_16 smallint
0

LookupsDDL_17 smallint
0

LookupsDDL_18 smallint
0

LookupsDDL_19 smallint
0

LookupsDDL_20 smallint
0

Lookups_DDL_2_1 smallint
0

Lookups_DDL_2_2 smallint
0

Lookups_DDL_2_3 smallint
0

Lookups_DDL_2_4 smallint
0

Lookups_DDL_2_5 smallint
0

Lookups_DDL_2_6 smallint
0

Lookups_DDL_2_7 smallint
0

Lookups_DDL_2_8 smallint
0

Lookups_DDL_2_9 smallint
0

Lookups_DDL_2_10 smallint
0

Lookups_DDL_2_11 smallint
0

Lookups_DDL_2_12 smallint
0

Lookups_DDL_2_13 smallint
0

Lookups_DDL_2_14 smallint
0

Lookups_DDL_2_15 smallint
0

Lookups_DDL_2_16 smallint
0

Lookups_DDL_2_17 smallint
0

Lookups_DDL_2_18 smallint
0

Lookups_DDL_2_19 smallint
0

Lookups_DDL_2_20 smallint
0

PT_Decimal_Places_1 smallint
0

PT_Decimal_Places_2 smallint
0

PT_Decimal_Places_3 smallint
0

PT_Decimal_Places_4 smallint
0

PT_Decimal_Places_5 smallint
0

PT_Decimal_Places_6 smallint
0

PT_Decimal_Places_7 smallint
0

PT_Decimal_Places_8 smallint
0

PT_Decimal_Places_9 smallint
0

PT_Decimal_Places_10 smallint
0

PT_Decimal_Places_11 smallint
0

PT_Decimal_Places_12 smallint
0

PT_Decimal_Places_13 smallint
0

PT_Decimal_Places_14 smallint
0

PT_Decimal_Places_15 smallint
0

PT_Decimal_Places_16 smallint
0

PT_Decimal_Places_17 smallint
0

PT_Decimal_Places_18 smallint
0

PT_Decimal_Places_19 smallint
0

PT_Decimal_Places_20 smallint
0

PT_Decimal_Places_2_1 smallint
0

PT_Decimal_Places_2_2 smallint
0

PT_Decimal_Places_2_3 smallint
0

PT_Decimal_Places_2_4 smallint
0

PT_Decimal_Places_2_5 smallint
0

PT_Decimal_Places_2_6 smallint
0

PT_Decimal_Places_2_7 smallint
0

PT_Decimal_Places_2_8 smallint
0

PT_Decimal_Places_2_9 smallint
0

PT_Decimal_Places_2_10 smallint
0

PT_Decimal_Places_2_11 smallint
0

PT_Decimal_Places_2_12 smallint
0

PT_Decimal_Places_2_13 smallint
0

PT_Decimal_Places_2_14 smallint
0

PT_Decimal_Places_2_15 smallint
0

PT_Decimal_Places_2_16 smallint
0

PT_Decimal_Places_2_17 smallint
0

PT_Decimal_Places_2_18 smallint
0

PT_Decimal_Places_2_19 smallint
0

PT_Decimal_Places_2_20 smallint
0

Use_Secondary_Key tinyint
0

Extender_Second_Prompt char(51)
''

Use_Existing_Lookup tinyint
0

Lookup_Number int
0

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