Module List > Module SV tables SV00054
You are currently viewing the COMPANY database.
Change

COMPANY..SV00054 Table Definition

(COMPANY..SV_Customer_Quicksearch)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Wennsoft_Affiliate char(15)


Wennsoft_Region char(15)


Wennsoft_Branch char(15)


CUSTNMBR char(15)

Field Type...(more) Join Now
join ... more text available
CUSTNAME char(65)

Field Type...(more) Join Now
ADRSCODE char(15)

Field Type...(more) Join Now
LOCATNNM char(31)


ADDRESS1 char(61)

Field Type...(more) Join Now
PHONE1 char(21)

Field Type...(more) Join Now
PHONE2 char(21)

Field Type...(more) Join Now
FAX char(21)

Fax: Same...(more) Join Now RM00101.FAX
ZIP char(11)

Field Type...(more) Join Now
User_Define_1a char(31)


MODIFDT datetime

Date the r...(more) Join Now
Modified_Time datetime


MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
Time_Zone char(3)


WS_Primary tinyint


Global_Customer tinyint


CITY char(35)

Field Type...(more) Join Now
DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3