CREATE COLUMN TABLE "SBODEMOPT"."OPWZ" ("IdNumber" INTEGER CS_INT NOT NULL , "PmntDate" LONGDATE CS_LONGDATE, "NextDate" LONGDATE CS_LONGDATE, "OutgoType" NVARCHAR(1) DEFAULT 'N', "IncomType" NVARCHAR(1) DEFAULT 'N', "CheckPmntM" NVARCHAR(1) DEFAULT 'N', "BnkTrnsPmM" NVARCHAR(1) DEFAULT 'N', "FilePath" NCLOB MEMORY THRESHOLD 1000, "PostDtFrom" LONGDATE CS_LONGDATE, "PostDtTo" LONGDATE CS_LONGDATE, "ValDteFrom" LONGDATE CS_LONGDATE, "ValDateTo" LONGDATE CS_LONGDATE, "ApInvAmntF" DECIMAL(21,6) CS_FIXED, "ApInvAmntT" DECIMAL(21,6) CS_FIXED, "PchNoFrom" INTEGER CS_INT, "PchNoTo" INTEGER CS_INT, "InvNoFrom" INTEGER CS_INT, "InvNoTo" INTEGER CS_INT, "SelPriorit" INTEGER CS_INT, "Status" NVARCHAR(1) DEFAULT 'S', "WizardName" NVARCHAR(100) NOT NULL , "StatusDisc" NVARCHAR(100), "Canceled" NVARCHAR(1) DEFAULT 'N', "BoePmnMn" NVARCHAR(1) DEFAULT 'N', "SeriesOut" INTEGER CS_INT DEFAULT 0, "SeriesIn" INTEGER CS_INT DEFAULT 0, "TotalOut" DECIMAL(21,6) CS_FIXED, "TotalIn" DECIMAL(21,6) CS_FIXED, "ViewIntBal" NVARCHAR(1) DEFAULT 'N', "SelMthd" NVARCHAR(1) DEFAULT 'D', "MINumFrom" INTEGER CS_INT, "MINumTo" INTEGER CS_INT, "MIDateFrom" LONGDATE CS_LONGDATE, "MIDateTo" LONGDATE CS_LONGDATE, "MIVNumFrom" INTEGER CS_INT, "MIVNumTo" INTEGER CS_INT, "MIVDateFro" LONGDATE CS_LONGDATE, "MIVDateTo" LONGDATE CS_LONGDATE, "APDocDtFrm" LONGDATE CS_LONGDATE, "APDocDtTo" LONGDATE CS_LONGDATE, "APDueDtFrm" LONGDATE CS_LONGDATE, "NxtPmntDat" LONGDATE CS_LONGDATE, "MinPayAR" DECIMAL(21,6) CS_FIXED, "MinPayAP" DECIMAL(21,6) CS_FIXED, "ShowAtCard" NVARCHAR(1) DEFAULT 'N', "TolerDays" SMALLINT CS_INT, "MinCashDis" DECIMAL(21,6) CS_FIXED, "NegBalBP" NVARCHAR(1) DEFAULT 'N', "ManualJE" NVARCHAR(1) DEFAULT 'Y', "NegTrans" NVARCHAR(1) DEFAULT 'Y', "CDTransApp" NVARCHAR(1) DEFAULT 'N', "UserSign" SMALLINT CS_INT, "CigTo" INTEGER CS_INT, "CupFrom" INTEGER CS_INT, "CupTo" INTEGER CS_INT, "CigFrom" INTEGER CS_INT, "BPLId" INTEGER CS_INT, "BoeDDFrom" LONGDATE CS_LONGDATE, "BoeDDTo" LONGDATE CS_LONGDATE, "BoeNumFrom" INTEGER CS_INT, "BoeNumTo" INTEGER CS_INT, "BoeStatus" NVARCHAR(32), "HaExistBoe" NVARCHAR(1) DEFAULT 'N', "SeriesPOO" INTEGER CS_INT DEFAULT 0, "SeriesPOI" INTEGER CS_INT DEFAULT 0, "SeqType" NVARCHAR(4), "PayDueDate" NVARCHAR(1) DEFAULT 'R', "CentrPay" NVARCHAR(1) DEFAULT 'N', "BA_AP_From" INTEGER CS_INT, "BA_AP_To" INTEGER CS_INT, "BA_AR_From" INTEGER CS_INT, "BA_AR_To" INTEGER CS_INT, "JobId" INTEGER CS_INT, "ZeroBalBP" NVARCHAR(1) DEFAULT 'Y', "ZeroBalDoc" NVARCHAR(50) DEFAULT 'YNNNNYNNNNN', PRIMARY KEY ("IdNumber")) UNLOAD PRIORITY 5  AUTO MERGE ;
CREATE UNIQUE INDEX "OPWZ_NAME" ON "SBODEMOPT"."OPWZ" ( "WizardName" ASC )