Module List > Module JC tables JC30301
You are currently viewing the COMPANY database.
Change

COMPANY..JC30301 Table Definition

(COMPANY..JC_Notes_HIST)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
WS_Job_Number char(17)


Project_Number char(17)


Cost_Code_Number_1 char(7)


Cost_Code_Number_2 char(7)


Cost_Code_Number_3 char(7)


Cost_Code_Number_4 char(7)


Note_Transaction_Number char(21)


Reference_ID char(31)


WS_Note_Type char(1)


Note_Service_Index char(25)


Note_Author char(21)


USERNAME char(31)


WS_Manager_ID char(15)


EMPLNAME char(41)


Reminder tinyint


Reminder_Date datetime


Printable_Group smallint


Urgent_Checkbox tinyint


DATE1 datetime

Date: Date...(more) Join Now SY03900.DATE1
TIME1 datetime

Time see ...(more) Join Now CM20200.TIME1
USERID char(15)

The user t...(more) Join Now
join ... more text available
User_Define_1 char(31)


User_Define_2 char(31)


USERDEF1 char(21)

UserDefine...(more) Join Now
USERDEF2 char(21)

UserDefine...(more) Join Now
User_Def_Integer_1 int


User_Def_Integer_2 int


User_Defined_Integer_3 int


User_Defined_Integer_4 int


User_Defined_Dollar_1 numeric(19,5)


User_Defined_Dollar_2 numeric(19,5)


User_Defined_Dollar_3 numeric(19,5)


User_Defined_Dollar_4 numeric(19,5)


USRDAT01 datetime


USRDAT02 datetime


User_Defined_Date_3 datetime


User_Defined_Date_4 datetime


User_Defined_CB_1 tinyint


User_Defined_CB_2 tinyint


User_Defined_CB_3 tinyint


User_Defined_CB_4 tinyint


Wennsoft_Affiliate char(15)


Wennsoft_Branch char(15)


Wennsoft_Region 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
SV_Language_ID smallint


Time_Zone char(3)


WSReserved_CB1 tinyint


WSReserved_CB2 tinyint


WSReserved_CB3 tinyint


WSReserved_CB4 tinyint


WSReserved_CB5 tinyint


WSReserved_CB6 tinyint


WSReserved_CB7 tinyint


WSReserved_CB8 tinyint


WSReserved_CB9 tinyint


WSReserved_CB10 tinyint


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