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 SV tables SV00197
You are currently viewing the COMPANY database.
Change

COMPANY..SV00197 Table Definition

(COMPANY..SV_Setup_Custom_Options)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
Record smallint
Last_User_ID char(15)
New_User_Flag tinyint
Table_Version char(11)
TRX_Log_Count smallint
Task_Code char(11)
WS_Counter_1 int
WS_Counter_2 int
WS_Counter_3 int
WS_Counter_4 int
WS_Counter_5 int
DATE1 datetime

 Field Type...(more) Join Now
WS_Time_1 datetime
Timeup smallint
Postal_Group smallint
Meter_Group smallint
Meter_Checkbox tinyint
Wennbox1 tinyint
Wennbox2 tinyint
Wenngroup1 smallint
Wenngroup2 smallint
Wennsoft_Affiliate char(15)
Wennsoft_Branch char(15)
Wennsoft_Region char(15)
Service_Option_Box_1 tinyint
Service_Option_Box_10 tinyint
Service_Option_Box_11 tinyint
Service_Option_Box_12 tinyint
Service_Option_Box_13 tinyint
Service_Option_Box_14 tinyint
Service_Option_Box_15 tinyint
Service_Option_Box_16 tinyint
Service_Option_Box_17 tinyint
Service_Option_Box_18 tinyint
Service_Option_Box_19 tinyint
Service_Option_Box_2 tinyint
Service_Option_Box_20 tinyint
Service_Option_Box_21 tinyint
Service_Option_Box_22 tinyint
Service_Option_Box_23 tinyint
Service_Option_Box_24 tinyint
Service_Option_Box_25 tinyint
Service_Option_Box_26 tinyint
Service_Option_Box_27 tinyint
Service_Option_Box_28 tinyint
Service_Option_Box_29 tinyint
Service_Option_Box_3 tinyint
Service_Option_Box_30 tinyint
Service_Option_Box_31 tinyint
Service_Option_Box_32 tinyint
Service_Option_Box_33 tinyint
Service_Option_Box_34 tinyint
Service_Option_Box_35 tinyint
Service_Option_Box_36 tinyint
Service_Option_Box_37 tinyint
Service_Option_Box_38 tinyint
Service_Option_Box_39 tinyint
Service_Option_Box_4 tinyint
Service_Option_Box_40 tinyint
Service_Option_Box_41 tinyint
Service_Option_Box_42 tinyint
Service_Option_Box_43 tinyint
Service_Option_Box_44 tinyint
Service_Option_Box_45 tinyint
Service_Option_Box_46 tinyint
Service_Option_Box_47 tinyint
Service_Option_Box_48 tinyint
Service_Option_Box_49 tinyint
Service_Option_Box_5 tinyint
Service_Option_Box_50 tinyint
Service_Option_Box_6 tinyint
Service_Option_Box_7 tinyint
Service_Option_Box_8 tinyint
Service_Option_Box_9 tinyint
Service_Option_Group_51 smallint
Service_Option_Group_52 smallint
Service_Option_Group_53 smallint
Service_Option_Group_54 smallint
Service_Option_Group_55 smallint
Service_Option_Group_56 smallint
Service_Option_Group_57 smallint
Service_Option_Group_58 smallint
Service_Option_Group_59 smallint
Service_Option_Group_60 smallint
Service_Option_Group_61 smallint
Service_Option_Group_62 smallint
Service_Option_Group_63 smallint
Service_Option_Group_64 smallint
Service_Option_Group_65 smallint
Service_Option_Group_66 smallint
Service_Option_Group_67 smallint
Service_Option_Group_68 smallint
Service_Option_Group_69 smallint
Service_Option_Group_70 smallint
Service_User_Define_1 char(21)
Service_User_Define_2 char(21)
Service_User_Define_3 char(31)
Service_User_Define_4 char(31)
Service_User_Define_5 int
Service_User_Define_6 int
Service_User_Define_7 int
Service_User_Define_8 int
Service_User_Define_9 datetime
Service_User_Define_10 datetime
Service_User_Define_11 datetime
Service_User_Define_12 datetime
Service_User_Define_18 tinyint
Service_User_Define_19 tinyint
Service_User_Define_20 tinyint
Service_User_Define_21 tinyint
Service_User_Define_22 numeric(19,5)
Service_User_Define_23 numeric(19,5)
Service_User_Define_24 numeric(19,5)
Service_User_Define_25 numeric(19,5)
MODIFDT datetime

 Date the r...(more) Join Now
Modified_Time datetime
MDFUSRID char(15)

 User that ...(more) Join Now
join ... more text available
Time_Zone char(3)
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
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3