Module List > Module Extender tables EXT20200
You are currently viewing the COMPANY database.
Change

COMPANY..EXT20200 Table Definition

(COMPANY..EXT_Extender_Forms )

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Extender_Form_ID char


Extender_Form_Name char


Extender_Form_ID_Prompt char


Use_Existing_Lookup tinyint


Lookup_Number int


Autoincrement tinyint


Extender_Description_Pro char


Description_Field_Req tinyint

Set to 1 i...(more) Join Now
Use_Secondary_Key tinyint


Extender_Second_Prompt char


Extender_Field_IDs_1 int

Array of 1...(more) Join Now
Extender_Field_IDs_2 int

Array of 1...(more) Join Now
Extender_Field_IDs_3 int

Array of 1...(more) Join Now
Extender_Field_IDs_4 int

Array of 1...(more) Join Now
Extender_Field_IDs_5 int

Array of 1...(more) Join Now
Extender_Field_IDs_6 int

Array of 1...(more) Join Now
Extender_Field_IDs_7 int

Array of 1...(more) Join Now
Extender_Field_IDs_8 int

Array of 1...(more) Join Now
Extender_Field_IDs_9 int

Array of 1...(more) Join Now
Extender_Field_IDs_10 int

Array of 1...(more) Join Now
Extender_Field_IDs_11 int

Array of 1...(more) Join Now
Extender_Field_IDs_12 int

Array of 1...(more) Join Now
Extender_Field_IDs_13 int

Array of 1...(more) Join Now
Extender_Field_IDs_14 int

Array of 1...(more) Join Now
Extender_Field_IDs_15 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_1 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_2 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_3 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_4 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_5 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_6 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_7 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_8 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_9 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_10 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_11 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_12 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_13 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_14 int

Array of 1...(more) Join Now
Extender_Field_IDs_2_15 int

Array of 1...(more) Join Now
Detail_Field_IDs_1 int

Array of 5...(more) Join Now
Detail_Field_IDs_2 int

Array of 5...(more) Join Now
Detail_Field_IDs_3 int

Array of 5...(more) Join Now
Detail_Field_IDs_4 int

Array of 5...(more) Join Now
Detail_Field_IDs_5 int

Array of 5...(more) Join Now
Detail_Field_IDs_6 int


Detail_Field_IDs_7 int


Detail_Field_IDs_8 int


Detail_Field_IDs_9 int


Detail_Field_IDs_10 int


Detail_Field_IDs_2_1 int

Array of 5...(more) Join Now
Detail_Field_IDs_2_2 int

Array of 5...(more) Join Now
Detail_Field_IDs_2_3 int

Array of 5...(more) Join Now
Detail_Field_IDs_2_4 int

Array of 5...(more) Join Now
Detail_Field_IDs_2_5 int

Array of 5...(more) Join Now
Detail_Field_IDs_2_6 int


Detail_Field_IDs_2_7 int


Detail_Field_IDs_2_8 int


Detail_Field_IDs_2_9 int


Detail_Field_IDs_2_10 int


Read_Only_CB tinyint


Add_Extender_Form_Detail tinyint

Set to 1 i...(more) Join Now
Show_Total_CB tinyint


Total_Field_ID int

Field ID o...(more) Join Now
Multicurrency_CB tinyint


Currency_Field_ID int

The ID of ...(more) Join Now
RATETPID char

The rate t...(more) Join Now
Currency_Default_FieldID int

The ID of ...(more) Join Now
Currency_Default_Method smallint


Default_From_Field_ID int

Not curren...(more) Join Now
Extender_Template_ID int

Identifier...(more) Join Now
Template_SelectionMethod smallint


CREATDDT datetime

The date t...(more) Join Now
CRUSRID char

The userna...(more) Join Now
MODIFDT datetime

The last d...(more) Join Now
MDFUSRID char

The userna...(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