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

COMPANY..sv00531 Table Definition

(COMPANY..SV_Contract_Task_Comment)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
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


Contract_Task_List_ID char(11)


Task_Code char(11)


Equipment_ID char(31)


Schedule_Date datetime


Week_of_Month smallint


DYOFWEEK char(21)


Scheduled_Time int


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)


WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_STR1 char(11)


WSReserved_STR2 char(11)


DEX_ROW_ID int
auto number (1,1)
Unique ide...(more) Join Now
Task_Comment 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