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

COMPANY..SV00581 Table Definition

(COMPANY..SV_Contract_Task_List_MSTR)

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
ADRSCODE char(15)

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


WSCONTSQ int


Equipment_ID char(31)


Contract_Task_List_ID char(11)


Original_Task_List_ID char(11)


Modified_List tinyint


Task_List_Type char(15)


Task_List_Description char(61)


Schedule_at_List tinyint


Frequency char(15)


Schedule smallint


Run_Units numeric(19,5)


Current_Run_Units numeric(19,5)


Last_Run_Units numeric(19,5)


Skill_Level char(15)


System char(15)


Major char(15)


Sub_1 char(15)


Sub_2 char(15)


Sub_3 char(15)


Sub_4 char(15)


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)


SV_Language_ID smallint


WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


USERID char(15)

The user t...(more) Join Now
join ... more text available
Technician_ID char(15)


Technician_Team char(15)


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
WS_Transaction_Note text


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