GP Tables

JC40901 - JC_Tax_Schedule_SETP

SQL Query Builder

34 Columns

Column Description Type Length
TAXSCHID char(15)
TXDTLTYP smallint
Wennsoft_Tax_Sched_ID_1 char(15)
Wennsoft_Tax_Sched_ID_2 char(15)
Wennsoft_Tax_Sched_ID_3 char(15)
Wennsoft_Tax_Sched_ID_4 char(15)
Wennsoft_Tax_Sched_ID_5 char(15)
Wennsoft_Tax_Sched_ID_6 char(15)
Wennsoft_Tax_Sched_ID_7 char(15)
Wennsoft_Tax_Sched_ID_8 char(15)
Wennsoft_Tax_Sched_ID_9 char(15)
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
WS_String_1 char(21)
WS_String_2 char(21)
WS_String_3 char(21)
WS_String_4 char(21)
WS_String_5 char(21)
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
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 JC40901. 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

WS_Checkbox1