CREATE COLUMN TABLE "IMCYC"."OWHS" ("WhsCode" NVARCHAR(8) NOT NULL , "WhsName" NVARCHAR(100), "IntrnalKey" INTEGER CS_INT, "Grp_Code" NVARCHAR(4), "BalInvntAc" NVARCHAR(15), "SaleCostAc" NVARCHAR(15), "TransferAc" NVARCHAR(15), "Locked" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DataSource" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UserSign" SMALLINT CS_INT, "RevenuesAc" NVARCHAR(15), "VarianceAc" NVARCHAR(15), "DecreasAc" NVARCHAR(15), "IncreasAc" NVARCHAR(15), "ReturnAc" NVARCHAR(15), "ExpensesAc" NVARCHAR(15), "EURevenuAc" NVARCHAR(15), "EUExpensAc" NVARCHAR(15), "FrRevenuAc" NVARCHAR(15), "FrExpensAc" NVARCHAR(15), "VatGroup" NVARCHAR(8), "Street" NVARCHAR(100), "Block" NVARCHAR(100), "ZipCode" NVARCHAR(20), "City" NVARCHAR(100), "County" NVARCHAR(100), "Country" NVARCHAR(3), "State" NVARCHAR(3), "Location" INTEGER CS_INT, "DropShip" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ExmptIncom" NVARCHAR(15), "UseTax" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PriceDifAc" NVARCHAR(15), "ExchangeAc" NVARCHAR(15), "BalanceAcc" NVARCHAR(15), "PurchaseAc" NVARCHAR(15), "PAReturnAc" NVARCHAR(15), "PurchOfsAc" NVARCHAR(15), "FedTaxID" NVARCHAR(32), "Building" NCLOB MEMORY THRESHOLD 1000, "ShpdGdsAct" NVARCHAR(15), "VatRevAct" NVARCHAR(15), "DecresGlAc" NVARCHAR(15), "IncresGlAc" NVARCHAR(15), "Nettable" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "StokRvlAct" NVARCHAR(15), "StkOffsAct" NVARCHAR(15), "WipAcct" NVARCHAR(15), "WipVarAcct" NVARCHAR(15), "CostRvlAct" NVARCHAR(15), "CstOffsAct" NVARCHAR(15), "ExpClrAct" NVARCHAR(15), "ExpOfstAct" NVARCHAR(15), "objType" NVARCHAR(20) DEFAULT '64', "logInstanc" INTEGER CS_INT, "createDate" LONGDATE CS_LONGDATE, "userSign2" SMALLINT CS_INT, "updateDate" LONGDATE CS_LONGDATE, "ARCMAct" NVARCHAR(15), "ARCMFrnAct" NVARCHAR(15), "ARCMEUAct" NVARCHAR(15), "ARCMExpAct" NVARCHAR(15), "APCMAct" NVARCHAR(15), "APCMFrnAct" NVARCHAR(15), "APCMEUAct" NVARCHAR(15), "RevRetAct" NVARCHAR(15), "BPLid" INTEGER CS_INT, "OwnerCode" CHAR(1) CS_FIXEDSTRING DEFAULT '1', "NegStckAct" NVARCHAR(15), "StkInTnAct" NVARCHAR(15), "AddrType" NVARCHAR(100), "StreetNo" NVARCHAR(100), "PurBalAct" NVARCHAR(15), "Excisable" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "WhICenAct" NVARCHAR(15), "WhOCenAct" NVARCHAR(15), "WhShipTo" NVARCHAR(100), "WipOffset" NVARCHAR(15), "StockOffst" NVARCHAR(15), "StorKeeper" INTEGER CS_INT, "Shipper" NVARCHAR(15), "BinActivat" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BinSeptor" NVARCHAR(5) DEFAULT '-', "DftBinAbs" INTEGER CS_INT, "DftBinEnfd" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AutoIssMtd" SMALLINT CS_INT DEFAULT 0, "ManageSnB" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RecItemsBy" SMALLINT CS_INT DEFAULT 0, "RecBinEnab" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "GlblLocNum" NVARCHAR(50), "RecvEmpBin" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "Inactive" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RecvMaxQty" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "AutoRecvMd" SMALLINT CS_INT DEFAULT 0, "RecvMaxWT" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RecvUpTo" NVARCHAR(6) DEFAULT '0', "FreeChrgSA" NVARCHAR(15), "FreeChrgPU" NVARCHAR(15), "TaxOffice" NVARCHAR(50), "Address2" NVARCHAR(50), "Address3" NVARCHAR(50), "External" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', PRIMARY KEY ("WhsCode")) UNLOAD PRIORITY 0  AUTO MERGE ;
CREATE INDEX "OWHS_DFT_BIN" ON "IMCYC"."OWHS" ( "DftBinAbs" ASC )