GP Tables

SV00900 - SV_User_Defined_MSTR

SQL Query Builder

62 Columns

Column Description Type Length
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
Record smallint
User_Define_1 char(31)
User_Define_2 char(31)
User_Define_3 char(31)
User_Define_4 char(31)
User_Define_5 char(31)
User_Define_6 char(31)
User_Define_7 char(31)
User_Define_8 char(31)
User_Define_9 char(31)
User_Define_10 char(31)
User_Define_11 char(31)
User_Define_12 char(31)
User_Define_13 char(31)
User_Define_14 char(31)
User_Define_15 char(31)
User_Define_16 char(31)
User_Define_17 char(31)
User_Define_18 char(31)
User_Define_19 char(31)
User_Define_20 char(31)
User_Define_21 char(31)
User_Define_22 char(31)
User_Define_23 char(31)
User_Define_24 char(31)
User_Define_25 char(31)
User_Define_26 char(31)
User_Define_27 char(31)
User_Define_28 char(31)
User_Define_29 char(31)
User_Define_30 char(31)
User_Define_31 char(31)
User_Define_32 char(31)
User_Define_33 char(31)
User_Define_34 char(31)
User_Define_35 char(31)
User_Define_36 char(31)
User_Define_37 char(31)
User_Define_38 char(31)
User_Define_39 char(31)
User_Define_40 char(31)
User_Define_41 char(31)
User_Define_42 char(31)
User_Define_43 char(31)
User_Define_44 char(31)
User_Define_45 char(31)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
Time_Zone char(3)
SV_Language_ID smallint
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
WSReserved_STR1 char(11)
WSReserved_STR2 char(11)
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SV00900. 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

WSReserved_CB1

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB2

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB3

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB5

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

WSReserved_CB4

JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00203 JC00301

Wennsoft_Affiliate

JC00102 JC00103 JC00106 JC00201 JC00401 JC00501 JC00601 JC00701