CREATE COLUMN TABLE "SBODEMODE"."ADP1" ("PrintId" NVARCHAR(4) NOT NULL , "ObjType" NVARCHAR(11) DEFAULT '13' NOT NULL , "Copies" SMALLINT CS_INT DEFAULT 1, "PrintOnAdd" NVARCHAR(1) DEFAULT 'N', "ExprtOnAdd" NVARCHAR(1) DEFAULT 'N', "RoundSums" NVARCHAR(1) DEFAULT 'N', "Remark" NCLOB MEMORY THRESHOLD 1000, "PrintSums" NVARCHAR(1) DEFAULT 'Y', "VndrNum" NVARCHAR(1) DEFAULT 'N', "PrnDscnt" NVARCHAR(1) DEFAULT 'Y', "SplitTran1" NVARCHAR(1) DEFAULT 'N', "SplitTran2" NVARCHAR(1) DEFAULT 'Y', "SplitTran3" NVARCHAR(1) DEFAULT 'Y', "ShowBothNu" NVARCHAR(1) DEFAULT 'N', "BaseRmrk" NVARCHAR(1) DEFAULT 'Y', "HandCopies" SMALLINT CS_INT DEFAULT 1, "EngKBItem" NVARCHAR(1) DEFAULT 'N', "EngKBCard" NVARCHAR(1) DEFAULT 'N', "OrdrPicDef" NVARCHAR(1) DEFAULT 'N', "SpltTrBOE1" NVARCHAR(1) DEFAULT 'N', "LineNumPPg" SMALLINT CS_INT DEFAULT 5, "JENumPPg" SMALLINT CS_INT DEFAULT 2, "CashPay" NCLOB MEMORY THRESHOLD 1000, "NonCashPay" NCLOB MEMORY THRESHOLD 1000, "MaxUOPay" DECIMAL(21,6) CS_FIXED, "CkeckPaper" NVARCHAR(1) DEFAULT 'S', "AllowFuPos" NVARCHAR(1) DEFAULT 'N', "ErdOutMode" NVARCHAR(1) DEFAULT 'N', "ErdIncMode" NVARCHAR(1) DEFAULT 'N', "ChkDupRef" NVARCHAR(1) DEFAULT 'N', "CpyCVRef" NVARCHAR(1) DEFAULT 'N', "BatchSerPr" NVARCHAR(1) DEFAULT 'A', "YearTrans" NVARCHAR(1) DEFAULT 'N', "ReconJeSer" SMALLINT CS_INT DEFAULT 0, "ReopOrder" NVARCHAR(1) DEFAULT 'N', "ForceReOrd" NVARCHAR(1) DEFAULT 'N', "PrintRows" NVARCHAR(1) DEFAULT 'A', "orderblock" NVARCHAR(1) DEFAULT 'N', "RecomPkg" NVARCHAR(1) DEFAULT 'N', "Enitemcost" NVARCHAR(1) DEFAULT 'N', "ClosePQ" NVARCHAR(1) DEFAULT 'Y', "CpyPRPrice" NVARCHAR(1) DEFAULT 'N', "EnSetCost" NVARCHAR(1) DEFAULT 'N', "DftPLChk" NVARCHAR(1) DEFAULT 'N', "DfltPLSel" SMALLINT CS_INT DEFAULT -1, "EmailOnAdd" NVARCHAR(1) DEFAULT 'N', "PDFOnAdd" NVARCHAR(1) DEFAULT 'N', "EmailSbj" NVARCHAR(254), "EmailBody" NCLOB MEMORY THRESHOLD 1000, "BlockWHT08" NVARCHAR(1) DEFAULT 'N', "BlockExprt" NVARCHAR(1) DEFAULT 'N', "BlockPrint" NVARCHAR(1) DEFAULT 'N', "BlockMail" NVARCHAR(1) DEFAULT 'N', "BlockToPDF" NVARCHAR(1) DEFAULT 'N', "BlockFax" NVARCHAR(1) DEFAULT 'N', "PoDropPrss" NVARCHAR(1) DEFAULT 'Y', "ShowCash" NVARCHAR(1) DEFAULT 'N', "PRUseBPTax" NVARCHAR(1) DEFAULT 'N', "EnblTtlEgD" NVARCHAR(1) DEFAULT 'N', "EnblUpdUDF" NVARCHAR(1) DEFAULT 'N', "EnblDpmTax" NVARCHAR(1) DEFAULT 'N', "ChkRefBP" NVARCHAR(1) DEFAULT 'N', "ChkRefYear" NVARCHAR(1) DEFAULT 'N', "BspDpmType" NVARCHAR(1) DEFAULT 'E', "ReopenByC" NVARCHAR(1) DEFAULT 'N', "ForceReByC" NVARCHAR(1) DEFAULT 'N', "OpenSnB" NVARCHAR(1) DEFAULT 'N', "BItmDscUpd" NVARCHAR(1) DEFAULT 'N', "DeferrTax" NVARCHAR(1) DEFAULT 'N', "LogInstanc" INTEGER CS_INT DEFAULT 0, "CtlActSlct" NVARCHAR(1) DEFAULT 'N', "SepDiscDpm" NVARCHAR(1) DEFAULT 'N', "DiffCigCup" NVARCHAR(1) DEFAULT 'Y', "NotDeferTa" NVARCHAR(1) DEFAULT 'N', "EmailSignD" NVARCHAR(1) DEFAULT 'N', "DftPriList" SMALLINT CS_INT, PRIMARY KEY ("PrintId", "ObjType")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "ADP1_OBJECT" ON "SBODEMODE"."ADP1" ( "ObjType" ASC )