CREATE COLUMN TABLE "IMCYC"."AINF" ("Version" INTEGER CS_INT NOT NULL , "CompnyName" NVARCHAR(100), "Flags" NVARCHAR(50) DEFAULT 'NNNNNNNNNNNNNNNNNNNNNNNNNNNNNN', "InfoL1" INTEGER CS_INT, "InfoL2" INTEGER CS_INT, "InfoA1" NVARCHAR(128), "InfoA2" NVARCHAR(50), "ACTStamp" INTEGER CS_INT DEFAULT 0, "ADMStamp" INTEGER CS_INT DEFAULT 0, "RTTStamp" INTEGER CS_INT DEFAULT 0, "CINFStamp" INTEGER CS_INT DEFAULT 0, "LawsSet" NVARCHAR(3), "EnblVatGrp" CHAR(1) CS_FIXEDSTRING, "EnblVTGPmn" CHAR(1) CS_FIXEDSTRING, "VatOOS_O" NVARCHAR(8), "VatOOS_I" NVARCHAR(8), "VatStnd_O" NVARCHAR(8), "VatStnd_I" NVARCHAR(8), "VatExmpt_O" NVARCHAR(8), "VatExmpt_I" NVARCHAR(8), "VatHalf_O" NVARCHAR(8), "VatHalf_I" NVARCHAR(8), "VatZrRt_O" NVARCHAR(8), "VatZrRt_I" NVARCHAR(8), "MaxActGrps" INTEGER CS_INT, "EnblDctSrc" CHAR(1) CS_FIXEDSTRING, "EnblRCN" CHAR(1) CS_FIXEDSTRING, "EnblCorINV" CHAR(1) CS_FIXEDSTRING, "EnblCshRep" CHAR(1) CS_FIXEDSTRING, "EnblIRTRep" CHAR(1) CS_FIXEDSTRING, "EnblTrnRep" CHAR(1) CS_FIXEDSTRING, "EnblVPMRep" CHAR(1) CS_FIXEDSTRING, "EnblACTRep" CHAR(1) CS_FIXEDSTRING, "EnblFTZ" CHAR(1) CS_FIXEDSTRING, "EnblSlfPCH" CHAR(1) CS_FIXEDSTRING, "EnblPCHUpd" CHAR(1) CS_FIXEDSTRING, "EnblRsvINV" CHAR(1) CS_FIXEDSTRING, "EnblRTDnld" CHAR(1) CS_FIXEDSTRING, "RTTDnldAdr" NVARCHAR(254), "ZPrcCode" NVARCHAR(8), "EnblExpns" CHAR(1) CS_FIXEDSTRING, "EnblRtrRep" CHAR(1) CS_FIXEDSTRING, "IsEC" CHAR(1) CS_FIXEDSTRING, "EnblCshDsc" CHAR(1) CS_FIXEDSTRING, "EnblLostCD" CHAR(1) CS_FIXEDSTRING, "NumActLvls" INTEGER CS_INT, "EnblRealRD" CHAR(1) CS_FIXEDSTRING, "EnblVTGNoD" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "EnblGLManP" CHAR(1) CS_FIXEDSTRING, "EnblOptVIP" CHAR(1) CS_FIXEDSTRING, "EnblActCrC" CHAR(1) CS_FIXEDSTRING, "EnblFrnAct" CHAR(1) CS_FIXEDSTRING, "EnblECAct" CHAR(1) CS_FIXEDSTRING, "EnblECRpt" CHAR(1) CS_FIXEDSTRING, "EnblRound" CHAR(1) CS_FIXEDSTRING, "EnblPrVatS" CHAR(1) CS_FIXEDSTRING, "EnblYrTrns" CHAR(1) CS_FIXEDSTRING, "EnblActTtl" CHAR(1) CS_FIXEDSTRING, "EnblDocWrn" CHAR(1) CS_FIXEDSTRING, "ActSegNum" SMALLINT CS_INT DEFAULT 0, "EnbSgmnAct" CHAR(1) CS_FIXEDSTRING, "SizeOfSeg0" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg1" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg2" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg3" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg4" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg5" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg6" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg7" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg8" SMALLINT CS_INT DEFAULT 0, "SizeOfSeg9" SMALLINT CS_INT DEFAULT 0, "Rprt1099" CHAR(1) CS_FIXEDSTRING, "MultiAddss" CHAR(1) CS_FIXEDSTRING, "EnbDunning" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "EnbQtyEDln" CHAR(1) CS_FIXEDSTRING, "Itw1Date" LONGDATE CS_LONGDATE, "Itw1Time" INTEGER CS_INT, "Itw1Count" INTEGER CS_INT, "EnbPayRef" CHAR(1) CS_FIXEDSTRING, "EnblDfrTax" CHAR(1) CS_FIXEDSTRING, "EnblClsPr" CHAR(1) CS_FIXEDSTRING, "EnblTaxEL" CHAR(1) CS_FIXEDSTRING, "EnableBOE" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnableWHT" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnblEquVat" CHAR(1) CS_FIXEDSTRING, "EnblFAsset" CHAR(1) CS_FIXEDSTRING, "EnblDoubt" CHAR(1) CS_FIXEDSTRING, "RateBase" CHAR(1) CS_FIXEDSTRING DEFAULT 'P', "BOEStatClo" CHAR(1) CS_FIXEDSTRING, "ARDocsInWT" CHAR(1) CS_FIXEDSTRING, "BISBnkCnt" NVARCHAR(3), "BISRBnkCd" NVARCHAR(30), "BISRBnkAc" NVARCHAR(50), "BISRBranch" NVARCHAR(50), "EnblBPConn" CHAR(1) CS_FIXEDSTRING, "EnblVATDat" CHAR(1) CS_FIXEDSTRING, "EnblStAgRp" CHAR(1) CS_FIXEDSTRING, "EnblCARepo" CHAR(1) CS_FIXEDSTRING, "EnblMatRev" CHAR(1) CS_FIXEDSTRING, "EnblMBPRec" CHAR(1) CS_FIXEDSTRING, "CshDscGros" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnblTaxInv" CHAR(1) CS_FIXEDSTRING, "EnblCorAct" CHAR(1) CS_FIXEDSTRING, "EnblRuDIP" CHAR(1) CS_FIXEDSTRING, "EnblCurDec" CHAR(1) CS_FIXEDSTRING, "EnblPayMtd" CHAR(1) CS_FIXEDSTRING, "EnblBaseUn" CHAR(1) CS_FIXEDSTRING, "EnblVATAna" CHAR(1) CS_FIXEDSTRING, "EnblExREnh" CHAR(1) CS_FIXEDSTRING, "VATGrpCal" CHAR(1) CS_FIXEDSTRING, "MaxChoose" INTEGER CS_INT DEFAULT 0, "EnblInfla" CHAR(1) CS_FIXEDSTRING, "EnblLAWHT" CHAR(1) CS_FIXEDSTRING, "EnblRTWHT" CHAR(1) CS_FIXEDSTRING, "ChkQunty" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "SriMngSys" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "BtchMngSys" CHAR(1) CS_FIXEDSTRING DEFAULT 'R', "SriCreatIn" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnblFolio" NVARCHAR(2), "EnblDocSbT" NVARCHAR(2), "IepsPayer" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DaysOrdCnc" INTEGER CS_INT DEFAULT 30, "EnblLATaxS" CHAR(1) CS_FIXEDSTRING, "PercOfAcq" DECIMAL(21,6) CS_FIXED, "MinBaseDoc" DECIMAL(21,6) CS_FIXED, "EnblDpmJdt" CHAR(1) CS_FIXEDSTRING, "EnblDownP" CHAR(1) CS_FIXEDSTRING, "EnblNDdctC" CHAR(1) CS_FIXEDSTRING, "DocNmMtd" CHAR(1) CS_FIXEDSTRING, "DoFilter" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnblOnPDCh" CHAR(1) CS_FIXEDSTRING, "EnblOnWnCr" CHAR(1) CS_FIXEDSTRING, "EnblDefInx" CHAR(1) CS_FIXEDSTRING, "EnblMxComm" CHAR(1) CS_FIXEDSTRING, "EnblIndxOp" CHAR(1) CS_FIXEDSTRING, "EnblSbtCVo" CHAR(1) CS_FIXEDSTRING, "MinAmntOAP" DECIMAL(21,6) CS_FIXED, "CredSumm" CHAR(1) CS_FIXEDSTRING, "PostdChk" CHAR(1) CS_FIXEDSTRING, "PostdCred" CHAR(1) CS_FIXEDSTRING, "CredVend" CHAR(1) CS_FIXEDSTRING, "WkoStatus" CHAR(1) CS_FIXEDSTRING, "DispTrByDf" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "stampTax" NVARCHAR(8), "MinAmntAL" DECIMAL(21,6) CS_FIXED, "BlockZeroQ" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "AutoCrIns" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnbRepomo" CHAR(1) CS_FIXEDSTRING, "RFCValidat" CHAR(1) CS_FIXEDSTRING, "MxDcsInPmt" INTEGER CS_INT DEFAULT 0, "RelStkNoPr" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CashDisc" CHAR(1) CS_FIXEDSTRING, "EnableSMS" CHAR(1) CS_FIXEDSTRING, "EnblIndic" CHAR(1) CS_FIXEDSTRING, "EnbFedTax" CHAR(1) CS_FIXEDSTRING, "EnblCounty" CHAR(1) CS_FIXEDSTRING, "Language" INTEGER CS_INT, "ChkIntgUpd" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "ChkIntgCre" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "BisBnkAcKy" INTEGER CS_INT, "EnbZeroDec" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnbDecWord" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "ChkWrdOnly" CHAR(1) CS_FIXEDSTRING, "EnBnkStmnt" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CalcVatGrp" CHAR(1) CS_FIXEDSTRING, "TaxSysType" CHAR(1) CS_FIXEDSTRING, "ESEnabled" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "RateTotal" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CompanyHis" NCLOB MEMORY THRESHOLD 1000, "EnblAssVal" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CompanySta" CHAR(1) CS_FIXEDSTRING DEFAULT 'U', "eFRTActLvs" INTEGER CS_INT, "TaxGrpType" CHAR(1) CS_FIXEDSTRING DEFAULT 'C', "InstallNo" NVARCHAR(30), "IsOldPA" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "EnbNegDoc" CHAR(1) CS_FIXEDSTRING, "Algo" SMALLINT CS_INT, "ArcComp" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "UpdatedTF" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DARDBGUID" NVARCHAR(32), "NegStoLv" CHAR(1) CS_FIXEDSTRING DEFAULT 'I', "SPNEnabled" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "PrsWkCntEb" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DashbdEb" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "BoxEffDate" LONGDATE CS_LONGDATE, "LogInstanc" INTEGER CS_INT DEFAULT 0 NOT NULL , "UpdateDate" LONGDATE CS_LONGDATE, "UserSign2" SMALLINT CS_INT, "SnapShotId" INTEGER CS_INT DEFAULT 0, "CreatedBy" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "B1SgtEb" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IsHConEnv" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "B1BuzzEb" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IMCEEnable" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DKeyId" NVARCHAR(128), "ResetDData" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "ConvDifAct" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "BasEffDate" LONGDATE CS_LONGDATE, "oldFxAss" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "MaxRowsCFL" INTEGER CS_INT DEFAULT 0, "ColSel" NCLOB MEMORY THRESHOLD 1000, "EnblSPEDUF" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DpmAffTot" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "AliasUpd" NVARCHAR(254), "TrailDays" SMALLINT CS_INT, "TestComp" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "DashConf" BLOB MEMORY THRESHOLD 1000, "SideEnable" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "IsPALInit" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "PANAVer" INTEGER CS_INT DEFAULT 0, "ExpEnable" CHAR(1) CS_FIXEDSTRING DEFAULT 'Y', "LastSsrDat" LONGDATE CS_LONGDATE, "LastSsrHsh" NVARCHAR(33), "B1iTimeOut" INTEGER CS_INT DEFAULT 30, "CpRfshEnbl" CHAR(1) CS_FIXEDSTRING DEFAULT 'N', "CpRfshIntv" INTEGER CS_INT DEFAULT 300, PRIMARY KEY INVERTED VALUE ("Version", "LogInstanc")) UNLOAD PRIORITY 5  AUTO MERGE 