CREATE COLUMN TABLE "SBODEMOPT"."OVTR" ("AbsEntry" INTEGER CS_INT NOT NULL , "ReportName" NVARCHAR(50) NOT NULL , "RptLayout" NVARCHAR(1) DEFAULT 'R', "FirstPrint" INTEGER CS_INT, "FromDate" LONGDATE CS_LONGDATE, "ToDate" LONGDATE CS_LONGDATE, "TaxDate" NVARCHAR(1) DEFAULT 'N', "RoundSum" NVARCHAR(1) DEFAULT 'N', "Declration" NVARCHAR(1) DEFAULT 'O', "FilterType" NVARCHAR(1) DEFAULT 'N' NOT NULL , "ExcludeWT" NVARCHAR(1) DEFAULT 'N', "CustomerIn" NVARCHAR(1) DEFAULT 'Y', "VendorIn" NVARCHAR(1) DEFAULT 'Y', "Period" NVARCHAR(1) DEFAULT 'Q', "Quarter" INTEGER CS_INT, "Year" INTEGER CS_INT, "DocType" NVARCHAR(1) DEFAULT 'P', "CreditMemo" NVARCHAR(1) DEFAULT 'N', "DocTypeIn" NVARCHAR(1) DEFAULT 'N', "FirstReg" INTEGER CS_INT, "AccountIn" NVARCHAR(1) DEFAULT 'N', "DeferTaxIn" NVARCHAR(1) DEFAULT 'Y', "ApndxOOrP" NVARCHAR(1) DEFAULT 'Y', "DispOBCB" NVARCHAR(1) DEFAULT 'Y', "FromSeries" INTEGER CS_INT, "ToSeries" INTEGER CS_INT, "canceltn" NVARCHAR(1) DEFAULT 'N', "HideNTrans" NVARCHAR(1) DEFAULT 'N', "SeriesIn" NVARCHAR(1) DEFAULT 'N', "UserCode" NVARCHAR(25), "FromCardCo" NVARCHAR(15), "ToCardCo" NVARCHAR(15), "SizeOfStru" INTEGER CS_INT, "PostFrDate" LONGDATE CS_LONGDATE, "PostToDate" LONGDATE CS_LONGDATE, "DocFrDate" LONGDATE CS_LONGDATE, "DocToDate" LONGDATE CS_LONGDATE, "FromDoc1Nu" NVARCHAR(11), "ToDoc1Nu" NVARCHAR(11), "Serie1" NVARCHAR(11) DEFAULT 'Y', "Serie1CB" NVARCHAR(1) DEFAULT 'N', "Doc1Type" INTEGER CS_INT, "FromDoc2Nu" NVARCHAR(11), "ToDoc2Nu" NVARCHAR(11), "Serie2" NVARCHAR(11) DEFAULT 'Y', "Serie2CB" NVARCHAR(1) DEFAULT 'N', "Doc2Type" INTEGER CS_INT, "FromDoc3Nu" NVARCHAR(11), "ToDoc3Nu" NVARCHAR(11), "Serie3" NVARCHAR(11) DEFAULT 'Y', "Serie3CB" NVARCHAR(1) DEFAULT 'N', "Doc3Type" INTEGER CS_INT, "FromDoc4Nu" NVARCHAR(11), "ToDoc4Nu" NVARCHAR(11), "Serie4" NVARCHAR(11) DEFAULT 'Y', "Serie4CB" NVARCHAR(1) DEFAULT 'N', "Doc4Type" INTEGER CS_INT, "FromDoc5Nu" NVARCHAR(11), "ToDoc5Nu" NVARCHAR(11), "Serie5" NVARCHAR(11) DEFAULT 'Y', "Serie5CB" NVARCHAR(1) DEFAULT 'N', "Doc5Type" INTEGER CS_INT, "DateRBtn" NVARCHAR(1) DEFAULT 'I', "MarkDocsIn" NVARCHAR(1) DEFAULT 'Y', "ExRate" NVARCHAR(1) DEFAULT 'P', "ExRateDate" NVARCHAR(1) DEFAULT 'P', "TrsPerioTp" NVARCHAR(1), "TrsPerioNu" INTEGER CS_INT, "TrsYear" SMALLINT CS_INT, "TrsAdjtNum" SMALLINT CS_INT, "DateType" NVARCHAR(1) DEFAULT 'P', "IncServDoc" NVARCHAR(1) DEFAULT 'Y', "GrpBySCode" NVARCHAR(1) DEFAULT 'Y', "IncUnReDoc" NVARCHAR(1) DEFAULT 'Y', "DoYearSum" NVARCHAR(1), "DefTaxOnly" NVARCHAR(1) DEFAULT 'N', "ExcElDoc" NVARCHAR(1) DEFAULT 'N', "QtrByMnt" NVARCHAR(1) DEFAULT 'N', "OnlyExtnTx" NVARCHAR(1) DEFAULT 'N', "IncludeWTR" NVARCHAR(1) DEFAULT 'Y', PRIMARY KEY ("AbsEntry")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OVTR_NAME" ON "SBODEMOPT"."OVTR" ( "ReportName" ASC, "FilterType" ASC )