CREATE COLUMN TABLE "SBODEMOPT"."OSCL" ("callID" INTEGER CS_INT NOT NULL , "subject" NVARCHAR(254), "customer" NVARCHAR(15), "custmrName" NVARCHAR(100), "contctCode" INTEGER CS_INT, "manufSN" NVARCHAR(36), "internalSN" NVARCHAR(36), "contractID" INTEGER CS_INT, "cntrctDate" LONGDATE CS_LONGDATE, "resolDate" LONGDATE CS_LONGDATE, "resolTime" SMALLINT CS_INT, "free_1" NVARCHAR(1) DEFAULT 'N', "free_2" LONGDATE CS_LONGDATE, "origin" SMALLINT CS_INT, "itemCode" NVARCHAR(50), "itemName" NVARCHAR(200), "itemGroup" SMALLINT CS_INT, "status" SMALLINT CS_INT DEFAULT -3, "priority" NVARCHAR(1) DEFAULT 'L', "callType" SMALLINT CS_INT, "problemTyp" SMALLINT CS_INT, "assignee" SMALLINT CS_INT, "descrption" NCLOB MEMORY THRESHOLD 1000, "objType" NVARCHAR(20) DEFAULT '191', "logInstanc" INTEGER CS_INT, "userSign" SMALLINT CS_INT, "createDate" LONGDATE CS_LONGDATE, "createTime" SMALLINT CS_INT, "closeDate" LONGDATE CS_LONGDATE, "closeTime" SMALLINT CS_INT, "userSign2" SMALLINT CS_INT, "updateDate" LONGDATE CS_LONGDATE, "SCL1Count" INTEGER CS_INT DEFAULT 0, "SCL2Count" INTEGER CS_INT DEFAULT 0, "isEntitled" NVARCHAR(1) DEFAULT 'N', "insID" INTEGER CS_INT, "technician" INTEGER CS_INT, "resolution" NCLOB MEMORY THRESHOLD 1000, "Scl1NxtLn" INTEGER CS_INT, "Scl2NxtLn" INTEGER CS_INT, "Scl3NxtLn" INTEGER CS_INT, "Scl4NxtLn" INTEGER CS_INT, "Scl5NxtLn" INTEGER CS_INT, "isQueue" NVARCHAR(1) DEFAULT 'N', "Queue" NVARCHAR(20), "resolOnDat" LONGDATE CS_LONGDATE, "resolOnTim" SMALLINT CS_INT, "respByDate" LONGDATE CS_LONGDATE, "respByTime" SMALLINT CS_INT, "respOnDate" LONGDATE CS_LONGDATE, "respOnTime" SMALLINT CS_INT, "respAssign" SMALLINT CS_INT, "AssignDate" LONGDATE CS_LONGDATE, "AssignTime" SMALLINT CS_INT, "UpdateTime" SMALLINT CS_INT, "responder" SMALLINT CS_INT, "Transfered" NVARCHAR(1) DEFAULT 'N', "Instance" SMALLINT CS_INT DEFAULT 0 NOT NULL , "DocNum" INTEGER CS_INT NOT NULL , "Series" INTEGER CS_INT, "Handwrtten" NVARCHAR(1) DEFAULT 'N', "PIndicator" NVARCHAR(10) DEFAULT ' ' NOT NULL , "StartDate" LONGDATE CS_LONGDATE, "StartTime" INTEGER CS_INT, "EndDate" LONGDATE CS_LONGDATE, "EndTime" INTEGER CS_INT, "Duration" DECIMAL(21,6) CS_FIXED, "DurType" NVARCHAR(1) DEFAULT 'M', "Reminder" NVARCHAR(1) DEFAULT 'N', "RemQty" DECIMAL(21,6) CS_FIXED, "RemType" NVARCHAR(1) DEFAULT 'M', "RemDate" LONGDATE CS_LONGDATE, "RemSent" NVARCHAR(1) DEFAULT 'N', "RemTime" SMALLINT CS_INT, "Location" SMALLINT CS_INT DEFAULT -1, "AddrName" NVARCHAR(50), "AddrType" NVARCHAR(1) DEFAULT 'S', "Street" NVARCHAR(100), "City" NVARCHAR(100), "Room" NVARCHAR(50), "State" NVARCHAR(3), "Country" NVARCHAR(3), "DisplInCal" NVARCHAR(1) DEFAULT 'N', "SupplCode" NVARCHAR(254), "Attachment" NCLOB MEMORY THRESHOLD 1000, "AtcEntry" INTEGER CS_INT, "NumAtCard" NVARCHAR(100), "ProSubType" SMALLINT CS_INT, "BPType" NVARCHAR(1) DEFAULT 'R', "Telephone" NVARCHAR(50), "BPPhone1" NVARCHAR(20), "BPPhone2" NVARCHAR(20), "BPCellular" NVARCHAR(50), "BPFax" NVARCHAR(20), "BPShipCode" NVARCHAR(50), "BPShipAddr" NVARCHAR(254), "BPBillCode" NVARCHAR(50), "BPBillAddr" NVARCHAR(254), "BPTerrit" INTEGER CS_INT, "BPE_Mail" NVARCHAR(100), "BPProjCode" NVARCHAR(20), "BPContact" NVARCHAR(245), "OwnerCode" INTEGER CS_INT, "DPPStatus" NVARCHAR(1) DEFAULT 'N', "EncryptIV" NVARCHAR(100), "Printed" NVARCHAR(1) DEFAULT 'N', PRIMARY KEY ("callID")) UNLOAD PRIORITY 0  AUTO MERGE ;
CREATE UNIQUE INDEX "OSCL_NUM" ON "SBODEMOPT"."OSCL" ( "DocNum" ASC, "Instance" ASC, "PIndicator" ASC );
CREATE INDEX "OSCL_SERIES" ON "SBODEMOPT"."OSCL" ( "Series" ASC );
CREATE INDEX "OSCL_REMDATE" ON "SBODEMOPT"."OSCL" ( "RemDate" ASC );
CREATE INDEX "OSCL_REMTIME" ON "SBODEMOPT"."OSCL" ( "RemTime" ASC )