CREATE COLUMN TABLE "SBODEMOPT"."ADTP" ("Code" NVARCHAR(15) NOT NULL , "Descr" NVARCHAR(100), "DprMeth" NVARCHAR(2) DEFAULT 'NO', "DprTo" DECIMAL(21,6) CS_FIXED, "Rounding" NVARCHAR(1) DEFAULT 'Y', "InclSalv" NVARCHAR(1) DEFAULT 'N', "SalvPerc" DECIMAL(21,6) CS_FIXED, "PerAcq" NVARCHAR(2) DEFAULT 'PR', "PerSubAcq" NVARCHAR(2) DEFAULT 'PR', "PerRet" NVARCHAR(2) DEFAULT 'PR', "AcqPRTyp" NVARCHAR(3) DEFAULT 'EDB', "SubPRTyp" NVARCHAR(3) DEFAULT 'EDB', "RetPRTyp" NVARCHAR(3) DEFAULT 'EDB', "PerDpRev" DECIMAL(21,6) CS_FIXED, "ValidFrom" LONGDATE CS_LONGDATE DEFAULT '19000101', "ValidTo" LONGDATE CS_LONGDATE DEFAULT '20991231', "sCalcMeth" NVARCHAR(3) DEFAULT 'APC', "sPercent" DECIMAL(21,6) CS_FIXED, "dBase" NVARCHAR(3) DEFAULT 'NBV', "dPercent" DECIMAL(21,6) CS_FIXED, "dFactor" DECIMAL(21,6) CS_FIXED DEFAULT 1, "dAltDprTyp" NVARCHAR(15), "maDecBase" NVARCHAR(1) DEFAULT 'Y', "spMeth" NVARCHAR(1) DEFAULT 'D', "spConcPer" INTEGER CS_INT, "spMaxPerc" DECIMAL(21,6) CS_FIXED, "spAdDpr" NVARCHAR(15), "spAlDpr" NVARCHAR(15), "PoolID" NVARCHAR(2), "DataSource" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "CreateDate" LONGDATE CS_LONGDATE, "UserSign2" SMALLINT CS_INT, "UpdateDate" LONGDATE CS_LONGDATE, "DprPer" NVARCHAR(1) DEFAULT 'S', "PerFactor" DECIMAL(21,6) CS_FIXED DEFAULT 1, "spMaxAmnt" DECIMAL(21,6) CS_FIXED, "spMaxFlag" NVARCHAR(1) DEFAULT 'P', "CalcBase" NVARCHAR(1) DEFAULT 'Y', "DeprEndLFY" NVARCHAR(1) DEFAULT 'N', "AccuPriorP" NVARCHAR(1) DEFAULT 'N', "DeltaCoeff" INTEGER CS_INT DEFAULT 0, "MaxDepr" DECIMAL(21,6) CS_FIXED, "FactorFFY" NVARCHAR(1) DEFAULT 'N', "SnapshotId" INTEGER CS_INT DEFAULT 0, "PerTranSou" NVARCHAR(2) DEFAULT 'PR', "PerTranTar" NVARCHAR(2) DEFAULT 'PR', "TranSPRTyp" NVARCHAR(3) DEFAULT 'EDB', "TranTPRTyp" NVARCHAR(3) DEFAULT 'EDB', PRIMARY KEY ("Code", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 