CREATE COLUMN TABLE "SBODEMOPT"."OSCN" ("ItemCode" NVARCHAR(50) NOT NULL , "CardCode" NVARCHAR(15) NOT NULL , "Substitute" NVARCHAR(50) NOT NULL , "Transfered" NVARCHAR(1) DEFAULT 'N', "DataSource" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "UserSign2" SMALLINT CS_INT, "ShowSCN" NVARCHAR(1) DEFAULT 'N', "IsDefault" NVARCHAR(1) DEFAULT 'N', PRIMARY KEY ("ItemCode", "CardCode", "Substitute")) UNLOAD PRIORITY 0  AUTO MERGE ;
ALTER TABLE "SBODEMOPT"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$Substitute$','CardCode','Substitute'));
ALTER TABLE "SBODEMOPT"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$ItemCode$','CardCode','ItemCode'));
ALTER TABLE "SBODEMOPT"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$ItemCode$CardCode$','ItemCode','CardCode'));
ALTER TABLE "SBODEMOPT"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$ItemCode$IsDefault$','CardCode','ItemCode','IsDefault'));
CREATE INDEX "OSCN_CARD_SCN" ON "SBODEMOPT"."OSCN" ( "CardCode" ASC, "Substitute" ASC );
CREATE INDEX "OSCN_CARD" ON "SBODEMOPT"."OSCN" ( "CardCode" ASC, "ItemCode" ASC );
CREATE INDEX "OSCN_ITEM" ON "SBODEMOPT"."OSCN" ( "ItemCode" ASC, "CardCode" ASC );
CREATE INDEX "OSCN_SUBSTITUTE" ON "SBODEMOPT"."OSCN" ( "Substitute" ASC );
CREATE INDEX "OSCN_DEFAULT" ON "SBODEMOPT"."OSCN" ( "CardCode" ASC, "ItemCode" ASC, "IsDefault" ASC )