I'm using these this fields...
vesselc nvarchar(20)
workScope_id bigint,
asset_id bigint,
proj_id bigint,
workScope_date datetime,
workScope_no nvarchar(50),
workScope_activityNo nvarchar(20),
workScope_plannedStart_date datetime,
workScope_actualStart_date datetime,
workScope_plannedFinish_date datetime,
workScope_actualFinish_date datetime,
workScope_Location nvarchar(100),
workScope_ActivityTitle nvarchar(MAX),
workScope_Completion nvarchar(100),
workScope_status nvarchar(50),
workScope_createdby nvarchar(30),
workScope_createddate datetime,
workScope_updatedby nvarchar(20),
workScope_updateddate datetime,
workScope_deleted bit,
workScope_transfer nvarchar(1),
dpr_no nvarchar(10),
dpr_date datetime,