GP Tables

SV00054 - SV_Customer_Quicksearch

SQL Query Builder

21 Columns

Column Description Type Length
Wennsoft_Affiliate char(15)
Wennsoft_Region char(15)
Wennsoft_Branch char(15)
CUSTNMBR char(15)
CUSTNAME char(65)
ADRSCODE char(15)
LOCATNNM char(31)
ADDRESS1 char(61)
PHONE1 char(21)
PHONE2 char(21)
FAX char(21)
ZIP char(11)
User_Define_1a char(31)
MODIFDT datetime
Modified_Time datetime
MDFUSRID char(15)
Time_Zone char(3)
WS_Primary tinyint
Global_Customer tinyint
CITY char(35)
DEX_ROW_ID int auto number (1,1)

Related Tables

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

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

ADRSCODE

ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18