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

COMPANY..SV333333 Table Definition

(COMPANY..SV_Broadcast_Warehouse_MSTR)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Service_Call_ID char(17)


CUSTNMBR char(15)

Field Type...(more) Join Now
join ... more text available
ADRSCODE char(15)

Field Type...(more) Join Now
ADDRESS1 char(61)

Field Type...(more) Join Now
ADDRESS2 char(61)

Field Type...(more) Join Now
CITY char(35)

Field Type...(more) Join Now
STATE char(5)

Field Type...(more) Join Now
ZIP char(11)

Field Type...(more) Join Now
COUNTRY char(61)

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


Type_of_Problem char(31)


Date_of_Service_Call datetime


Type_Call_Short char(3)


Priority_of_Call char(1)


User_Define_1a char(31)


User_Define_2a char(31)


User_Define_3a char(31)


User_Define_4a char(31)


Status_of_Call char(11)


Completion_Date datetime

Completion...(more) Join Now BM10200.Completion_Date
Technician char(11)


Scheduled_Time int


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