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

COMPANY..SVA0301 Table Definition

(COMPANY..SV_Service_Appointments_MSTR_Archive)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Service_Call_ID char(17)


Appointment char(25)


Appointment_Type smallint


Technician char(11)


WS_Cost_Code int


WS_Job_Number char(17)


Cost_Code_Alias char(27)


Appointment_Group_ID char(25)


Appointment_Description char(51)


UPRTRXCD char(7)


Skill_Level char(15)


Task_Date datetime


STRTTIME datetime

Field Type...(more) Join Now
ENDTIME datetime

Field Type...(more) Join Now
Estimate_Hours int


Actual_Hours int


Technician_Status char(17)


Appointment_Status char(11)


Completion_Date datetime

Completion...(more) Join Now BM10200.Completion_Date
Time_Entered_CB tinyint


Cancelled_Reason char(25)


CREATDDT datetime

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


MODIFDT datetime

Date the r...(more) Join Now
MDFUSRID char(15)

User that ...(more) Join Now
join ... more text available
Modified_Time datetime


USERDEF1 char(21)

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

Field Type...(more) Join Now
UDCB1 tinyint


UDCB2 tinyint


USRDAT01 datetime


USRDAT02 datetime


UserDD1 numeric(19,5)


UserDD2 numeric(19,5)


Service_User_Define_1 char(21)


Service_User_Define_2 char(21)


Service_User_Define_3 char(31)


Service_User_Define_4 char(31)


Service_User_Define_5 int


Service_User_Define_6 int


Service_User_Define_7 int


Service_User_Define_8 int


Service_User_Define_9 datetime


Service_User_Define_10 datetime


Service_User_Define_11 datetime


Service_User_Define_12 datetime


Service_User_Define_18 tinyint


Service_User_Define_19 tinyint


Service_User_Define_20 tinyint


Service_User_Define_21 tinyint


SV_Tool_ID 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