CREATE COLUMN TABLE "SBODEMODE"."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', "Descriptio" NVARCHAR(200), "DataVers" INTEGER CS_INT DEFAULT 1, PRIMARY KEY ("ItemCode", "CardCode", "Substitute")) UNLOAD PRIORITY 0  AUTO MERGE ;
ALTER TABLE "SBODEMODE"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$Substitute$','CardCode','Substitute'));
ALTER TABLE "SBODEMODE"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$ItemCode$','CardCode','ItemCode'));
ALTER TABLE "SBODEMODE"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$ItemCode$CardCode$','ItemCode','CardCode'));
ALTER TABLE "SBODEMODE"."OSCN" WITH PARAMETERS ('CONCAT_ATTRIBUTE'=('$CardCode$ItemCode$IsDefault$','CardCode','ItemCode','IsDefault'));
CREATE INDEX "OSCN_CARD_SCN" ON "SBODEMODE"."OSCN" ( "CardCode" ASC, "Substitute" ASC );
CREATE INDEX "OSCN_CARD" ON "SBODEMODE"."OSCN" ( "CardCode" ASC, "ItemCode" ASC );
CREATE INDEX "OSCN_ITEM" ON "SBODEMODE"."OSCN" ( "ItemCode" ASC, "CardCode" ASC );
CREATE INDEX "OSCN_SUBSTITUTE" ON "SBODEMODE"."OSCN" ( "Substitute" ASC );
CREATE INDEX "OSCN_DEFAULT" ON "SBODEMODE"."OSCN" ( "CardCode" ASC, "ItemCode" ASC, "IsDefault" ASC )