GP Tables

SV00197 - SV_Setup_Custom_Options

SQL Query Builder

119 Columns

Column Description Type Length
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
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
Modified_Time datetime
MDFUSRID char(15)
Time_Zone char(3)
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SV00197. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Region

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Wennsoft_Branch

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701

Time_Zone

CN00500 CN100100 JC00102 JC00103 JC00106 JC00201 JC00301 JC00401

Service_User_Define_5

SV00012 SV00015 SV00021 SV00030 SV00032 SV00033 SV00040 SV00077

Service_User_Define_6

SV00012 SV00015 SV00021 SV00030 SV00032 SV00033 SV00040 SV00077