GP Tables

WS40300 - WS_ADP_SETP

SQL Query Builder

50 Columns

Column Description Type Length
WS_ADP_Company_Code char(3)
LNSEQNBR numeric(19,5) 0
WS_Column_Name char(31)
WS_ADP_Field char(41)
WS_TT_Field char(31)
WS_Stored_Proc char(255)
WS_Checkbox1 tinyint
WS_Checkbox_2 tinyint
WS_Checkbox_3 tinyint
WS_Checkbox_4 tinyint
WS_Checkbox_5 tinyint
WS_Checkbox_6 tinyint
WS_Checkbox_7 tinyint
WS_Checkbox_8 tinyint
WS_Checkbox_9 tinyint
WS_Checkbox_10 tinyint
User_Define_1 char(31)
User_Define_2 char(31)
USERDEF1 char(21)
USERDEF2 char(21)
User_Def_Integer_1 int
User_Def_Integer_2 int
User_Defined_Integer_3 int
User_Defined_Integer_4 int
User_Defined_Dollar_1 numeric(19,5)
User_Defined_Dollar_2 numeric(19,5)
User_Defined_Dollar_3 numeric(19,5)
User_Defined_Dollar_4 numeric(19,5)
USRDAT01 datetime
USRDAT02 datetime
User_Defined_Date_3 datetime
User_Defined_Date_4 datetime
User_Defined_CB_1 tinyint
User_Defined_CB_2 tinyint
User_Defined_CB_3 tinyint
User_Defined_CB_4 tinyint
USRDEFS1 char(31)
USRDEFS2 char(31)
WSReserved_CB1 tinyint
WSReserved_CB2 tinyint
WSReserved_CB3 tinyint
WSReserved_CB4 tinyint
WSReserved_CB5 tinyint
WSReserved_CB6 tinyint
WSReserved_CB7 tinyint
WSReserved_CB8 tinyint
WSReserved_CB9 tinyint
WSReserved_CB10 tinyint
WSReserved_DDL1 smallint
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

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

WSReserved_CB6

JC00102 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701

WSReserved_CB7

JC00102 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701

WSReserved_CB10

JC00102 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701

WSReserved_CB8

JC00102 JC00106 JC00107 JC00201 JC00401 JC00501 JC00601 JC00701