CREATE COLUMN TABLE "SBODEMODE"."SOI3" ("WizardId" INTEGER CS_INT NOT NULL , "SOINum" INTEGER CS_INT NOT NULL , "AgrNum" INTEGER CS_INT, "AgrNo" INTEGER CS_INT, "CardCode" NVARCHAR(15), "CardName" NVARCHAR(200), "PayToCtry" NVARCHAR(3), "PmntNum" INTEGER CS_INT, "PmntEntry" INTEGER CS_INT, "PmntType" INTEGER CS_INT, "PmntDate" LONGDATE CS_LONGDATE, "ExcBasSum" DECIMAL(21,6) CS_FIXED, "ExciseSum" DECIMAL(21,6) CS_FIXED, "VatBaseSum" DECIMAL(21,6) CS_FIXED, "VatSum" DECIMAL(21,6) CS_FIXED, "RegNo" NVARCHAR(18), "RegDate" LONGDATE CS_LONGDATE, "ExecStat" NVARCHAR(1) DEFAULT 'S', "BPLId" INTEGER CS_INT, PRIMARY KEY ("WizardId", "SOINum")) UNLOAD PRIORITY 5  AUTO MERGE 