CREATE TABLE TasasDTF ( nAnno INT DEFAULT (0) NOT NULL, nMes INT DEFAULT (0) NOT NULL, nSem INT DEFAULT (0) NOT NULL, DTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, TIBC_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, Factor_Mon DECIMAL(14,4) DEFAULT (0) NOT NULL CONSTRAINT PK_TasasDTF PRIMARY KEY CLUSTERED (nAnno,nMes,nSem)) GO CREATE TABLE TasasInteres ( IdTasa VARCHAR(4) NOT NULL, DescTasa VARCHAR(50) NOT NULL, TipoInteres VARCHAR(10) DEFAULT ('COMPUESTO') NOT NULL, TipoPeriodo VARCHAR(10) DEFAULT ('MENSUAL') NOT NULL, CausaInteres INT DEFAULT (0) NOT NULL, TipoDTF VARCHAR(10) DEFAULT ('VARIABLE') NOT NULL, DTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, Spread_TA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaEfectiva DECIMAL(14,4) DEFAULT (0) NOT NULL, OpcCompra DECIMAL(14,4) DEFAULT (0) NOT NULL, Inactivo BIT DEFAULT (0) NOT NULL CONSTRAINT PK_TasasInteres PRIMARY KEY CLUSTERED (IdTasa), CONSTRAINT CK_TasasInteresDescTasa CHECK ((len([DescTasa]) > 0)), CONSTRAINT CK_TasasInteresIdTasa CHECK ((len([IdTasa]) > 0)), CONSTRAINT CK_TasasInteresTipoDTF CHECK ((len([TipoDTF]) > 0)), CONSTRAINT CK_TasasInteresTipoInteres CHECK ((len([TipoInteres]) > 0)), CONSTRAINT CK_TasasInteresTipoPeriodo CHECK ((len([TipoPeriodo]) > 0))) GO CREATE TABLE TasasIntmora ( IdMora VARCHAR(4) NOT NULL, DescMora VARCHAR(50) NOT NULL, TipoInteres VARCHAR(10) DEFAULT ('VARIABLE') NOT NULL, TasaEA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaEM DECIMAL(14,4) DEFAULT (0) NOT NULL, DiasGracia INT DEFAULT (0) NOT NULL, Inactivo BIT DEFAULT (0) NOT NULL CONSTRAINT PK_TasasIntmora PRIMARY KEY CLUSTERED (IdMora), CONSTRAINT CK_TasasIntmoraDescMora CHECK ((len([DescMora]) > 0)), CONSTRAINT CK_TasasIntmoraIdMora CHECK ((len([IdMora]) > 0)), CONSTRAINT CK_TasasIntmoraTipoInteres CHECK ((len([TipoInteres]) > 0))) GO CREATE TABLE Trn_FinPrestamo ( TipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, FecPrestamo SMALLDATETIME NOT NULL, FecCorte SMALLDATETIME NOT NULL, IdConcepto VARCHAR(4) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, VrPrestamo MONEY DEFAULT (0) NOT NULL, IdTasa VARCHAR(4) NOT NULL, NPlazos INT DEFAULT (0) NOT NULL, Causacion VARCHAR(10) DEFAULT ('MENSUAL') NOT NULL, IdMora VARCHAR(4) NOT NULL, NContrato INT DEFAULT (0) NOT NULL, CdCiaCon CHAR(2) DEFAULT ('01') NOT NULL, NActaJunta INT DEFAULT (0) NOT NULL, NumCredito VARCHAR(20) NOT NULL, IdVend VARCHAR(16) NOT NULL, pVehiculo VARCHAR(10), CdConductor VARCHAR(16) DEFAULT ('0') NOT NULL, TipoGarantia VARCHAR(10) DEFAULT ('HIPOTECA') NOT NULL, VrGarantia MONEY DEFAULT (0) NOT NULL, DescGarantia VARCHAR(250), CxPagar BIT DEFAULT (0) NOT NULL, NumCuotaIni INT DEFAULT (0) NOT NULL, AcumCapital MONEY DEFAULT (0) NOT NULL, AcumIntereses MONEY DEFAULT (0) NOT NULL, AcumIntMora MONEY DEFAULT (0) NOT NULL, AcumCuotas INT DEFAULT (0) NOT NULL, PagosCapital MONEY DEFAULT (0) NOT NULL, PagosIntereses MONEY DEFAULT (0) NOT NULL, PagosIntMora MONEY DEFAULT (0) NOT NULL, CuotasPagadas INT DEFAULT (0) NOT NULL, CuotasMora INT DEFAULT (0) NOT NULL, TipoAprob VARCHAR(20) DEFAULT ('JUNTADIRECTIVA') NOT NULL, OrigenAdd VARCHAR(10) NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, IdCiaCom CHAR(2) NOT NULL, Anulado BIT DEFAULT (0) NOT NULL, NumDev INT DEFAULT (0) NOT NULL, FecDev SMALLDATETIME, Observacion VARCHAR(250), IdEstado VARCHAR(4) NOT NULL, TimeSys SMALLDATETIME NOT NULL, FecUpdate SMALLDATETIME, IdCiaCrea CHAR(2) DEFAULT ('01') NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinPrestamo PRIMARY KEY CLUSTERED (TipDoc,IdPrestamo,IdCia), CONSTRAINT CK_Trn_FinPrestamoCausacion CHECK ((len([Causacion]) > 0)), CONSTRAINT CK_Trn_FinPrestamoCdCiaCon CHECK ((len([CdCiaCon]) > 0)), CONSTRAINT CK_Trn_FinPrestamoCdConductor CHECK ((len([CdConductor]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdCiaCom CHECK ((len([IdCiaCom]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdCiaCrea CHECK ((len([IdCiaCrea]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdEstado CHECK ((len([IdEstado]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdMora CHECK ((len([IdMora]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdTasa CHECK ((len([IdTasa]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinPrestamoIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinPrestamoNumCredito CHECK ((len([NumCredito]) > 0)), CONSTRAINT CK_Trn_FinPrestamoOrigenAdd CHECK ((len([OrigenAdd]) > 0)), CONSTRAINT CK_Trn_FinPrestamoTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinPrestamoTipDoc CHECK ((len([TipDoc]) > 0)), CONSTRAINT CK_Trn_FinPrestamoTipoAprob CHECK ((len([TipoAprob]) > 0))) GO CREATE TABLE Trn_FinCuotas ( TipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Item INT DEFAULT (1) NOT NULL, NumCuota INT DEFAULT (0) NOT NULL, Fecha SMALLDATETIME NOT NULL, FechaVence SMALLDATETIME NOT NULL, VrTotal MONEY DEFAULT (0) NOT NULL, VrAbonado MONEY DEFAULT (0) NOT NULL, TipoTasa VARCHAR(10) DEFAULT ('VARIABLE') NOT NULL, DTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaNom DECIMAL(14,4) DEFAULT (0) NOT NULL, Spread_TA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaEfe DECIMAL(14,4) DEFAULT (0) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, Concepto VARCHAR(10) DEFAULT ('CAPITAL') NOT NULL, TipoCuota INT DEFAULT (0) NOT NULL, NumCausacion INT DEFAULT (0) NOT NULL, IdCiaCau CHAR(2) DEFAULT ('00') NOT NULL, Detalle VARCHAR(250), FecUltPago SMALLDATETIME, FecLiqMora SMALLDATETIME, FechaCrea SMALLDATETIME NOT NULL CONSTRAINT PK_Trn_FinCuotas PRIMARY KEY CLUSTERED (TipDoc,IdPrestamo,IdCia,Item), CONSTRAINT CK_Trn_FinCuotasConcepto CHECK ((len([Concepto]) > 0)), CONSTRAINT CK_Trn_FinCuotasIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinCuotasIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinCuotasIdCiaCau CHECK ((len([IdCiaCau]) > 0)), CONSTRAINT CK_Trn_FinCuotasIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinCuotasTipDoc CHECK ((len([TipDoc]) > 0)), CONSTRAINT CK_Trn_FinCuotasTipoTasa CHECK ((len([TipoTasa]) > 0))) GO CREATE TABLE Trn_FinAbonos ( TipRec VARCHAR(3) NOT NULL, Recibo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Item INT DEFAULT (0) NOT NULL, Fecha SMALLDATETIME NOT NULL, TipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCiaPre CHAR(2) NOT NULL, ItemPre INT DEFAULT (0) NOT NULL, TotalAbono MONEY DEFAULT (0) NOT NULL, VrBaseCms MONEY DEFAULT (0) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, IdVend VARCHAR(16) NOT NULL, Comision DECIMAL(14,4) DEFAULT (0) NOT NULL, CantGal DECIMAL(14,4) DEFAULT (0) NOT NULL, Detalle VARCHAR(150), TipoAplica INT DEFAULT (0) NOT NULL, FecPago SMALLDATETIME NOT NULL, TimeSys SMALLDATETIME NOT NULL CONSTRAINT PK_Trn_FinAbonos PRIMARY KEY CLUSTERED (TipRec,Recibo,IdCia,Item), CONSTRAINT CK_Trn_FinAbonosIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinAbonosIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinAbonosIdCiaPre CHECK ((len([IdCiaPre]) > 0)), CONSTRAINT CK_Trn_FinAbonosIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinAbonosIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinAbonosTipDoc CHECK ((len([TipDoc]) > 0)), CONSTRAINT CK_Trn_FinAbonosTipRec CHECK ((len([TipRec]) > 0))) GO CREATE TABLE Trn_FinDevPre ( TipDev VARCHAR(3) DEFAULT ('DP1') NOT NULL, Devolucion INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, IdConcepto VARCHAR(4) NOT NULL, TipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCiaDoc CHAR(2) DEFAULT ('01') NOT NULL, FecDoc SMALLDATETIME NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, VrPrestamo MONEY DEFAULT (0) NOT NULL, IdVend VARCHAR(16) NOT NULL, CxPagar BIT DEFAULT (0) NOT NULL, ModdDev VARCHAR(10) DEFAULT ('TOTAL') NOT NULL, OrigenAdd VARCHAR(10) NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, IdCiaCom CHAR(2) NOT NULL, Observacion VARCHAR(250), IdEstado VARCHAR(4) NOT NULL, TimeSys SMALLDATETIME NOT NULL, FecUpdate SMALLDATETIME, IdCiaCrea CHAR(2) DEFAULT ('01') NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinDevPre PRIMARY KEY CLUSTERED (TipDev,Devolucion,IdCia), CONSTRAINT CK_Trn_FinDevPreIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdCiaCom CHECK ((len([IdCiaCom]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdCiaCrea CHECK ((len([IdCiaCrea]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdCiaDoc CHECK ((len([IdCiaDoc]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdEstado CHECK ((len([IdEstado]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinDevPreIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinDevPreModdDev CHECK (([ModdDev] = 'PARCIAL' or [ModdDev] = 'TOTAL')), CONSTRAINT CK_Trn_FinDevPreOrigenAdd CHECK ((len([OrigenAdd]) > 0)), CONSTRAINT CK_Trn_FinDevPreTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinDevPreTipDev CHECK ((len([TipDev]) > 0)), CONSTRAINT CK_Trn_FinDevPreTipDoc CHECK ((len([TipDoc]) > 0))) GO CREATE TABLE Trn_FinAfavor ( TipDoc VARCHAR(3) DEFAULT ('RC2') NOT NULL, Recibo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, VrAFavor MONEY DEFAULT (0) NOT NULL, VrOtrosDb MONEY DEFAULT (0) NOT NULL, VrAbono MONEY DEFAULT (0) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, IdVend VARCHAR(16) NOT NULL CONSTRAINT PK_Trn_FinAfavor PRIMARY KEY CLUSTERED (TipDoc,Recibo,IdCia), CONSTRAINT CK_Trn_FinAfavorIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinAfavorIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinAfavorIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinAfavorIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinAfavorTipDoc CHECK ((len([TipDoc]) > 0))) GO CREATE TABLE Trn_FinRecibos ( TipDoc VARCHAR(3) DEFAULT ('RC2') NOT NULL, Recibo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, IdConcepto VARCHAR(4) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, FecPago SMALLDATETIME NOT NULL, VrRecibido MONEY DEFAULT (0) NOT NULL, VrSubTotal MONEY DEFAULT (0) NOT NULL, VrRetencion MONEY DEFAULT (0) NOT NULL, VrReteICA MONEY DEFAULT (0) NOT NULL, VrReteIVA MONEY DEFAULT (0) NOT NULL, VrOtros MONEY DEFAULT (0) NOT NULL, VrOtrDcto MONEY DEFAULT (0) NOT NULL, VrPagosMas MONEY DEFAULT (0) NOT NULL, VrNeto MONEY DEFAULT (0) NOT NULL, VrAplicado MONEY DEFAULT (0) NOT NULL, VrEfectivo MONEY DEFAULT (0) NOT NULL, VrAnticipo MONEY DEFAULT (0) NOT NULL, BaseRet MONEY DEFAULT (0) NOT NULL, BaseIca MONEY DEFAULT (0) NOT NULL, BaseRiv MONEY DEFAULT (0) NOT NULL, TarifaRet DECIMAL(14,4) DEFAULT (0) NOT NULL, TarifaIca DECIMAL(14,4) DEFAULT (0) NOT NULL, TarifaRiv DECIMAL(14,4) DEFAULT (0) NOT NULL, CodTarRet VARCHAR(4), CodTarIca VARCHAR(4), CodTarRiv VARCHAR(4), IdVend VARCHAR(16) NOT NULL, TarifaCom DECIMAL(14,4) DEFAULT (0) NOT NULL, CodTarCom VARCHAR(4), EnEfectivo BIT DEFAULT (0) NOT NULL, CdForma VARCHAR(4), NumForma VARCHAR(20), DetallePago VARCHAR(250), CdBanco VARCHAR(4) DEFAULT ('0') NOT NULL, CdCta VARCHAR(4) DEFAULT ('0') NOT NULL, Referencia VARCHAR(50), pVehiculo VARCHAR(10), CdConductor VARCHAR(16) DEFAULT ('0') NOT NULL, TipDcm VARCHAR(3) DEFAULT ('0') NOT NULL, Documento INT DEFAULT (0) NOT NULL, IdCiaDcm CHAR(2) DEFAULT ('00') NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, IdCiaCom CHAR(2) NOT NULL, Anulado BIT DEFAULT (0) NOT NULL, NumDev INT DEFAULT (0) NOT NULL, FecDev SMALLDATETIME, Observacion VARCHAR(250), IdEstado VARCHAR(4) NOT NULL, OrigenAdd VARCHAR(10) NOT NULL, TimeSys SMALLDATETIME NOT NULL, FecUpdate SMALLDATETIME, IdCiaCrea CHAR(2) DEFAULT ('01') NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinRecibos PRIMARY KEY CLUSTERED (TipDoc,Recibo,IdCia), CONSTRAINT CK_Trn_FinRecibosCdBanco CHECK ((len([CdBanco]) > 0)), CONSTRAINT CK_Trn_FinRecibosCdConductor CHECK ((len([CdConductor]) > 0)), CONSTRAINT CK_Trn_FinRecibosCdCta CHECK ((len([CdCta]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdCiaCom CHECK ((len([IdCiaCom]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdCiaCrea CHECK ((len([IdCiaCrea]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdCiaDcm CHECK ((len([IdCiaDcm]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdEstado CHECK ((len([IdEstado]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinRecibosIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinRecibosOrigenAdd CHECK ((len([OrigenAdd]) > 0)), CONSTRAINT CK_Trn_FinRecibosTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinRecibosTipDcm CHECK ((len([TipDcm]) > 0)), CONSTRAINT CK_Trn_FinRecibosTipDoc CHECK ((len([TipDoc]) > 0))) GO CREATE TABLE tm_PreAbonos ( tmNumero VARCHAR(5) NOT NULL, tmItem INT DEFAULT (0) NOT NULL, tmTipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, tmIdPrestamo INT DEFAULT (0) NOT NULL, tmIdCiaPre CHAR(2) NOT NULL, tmItemPre INT DEFAULT (0) NOT NULL, tmVrAbono MONEY DEFAULT (0) NOT NULL, tmVrBaseCms MONEY DEFAULT (0) NOT NULL, tmIdCliente VARCHAR(16) NOT NULL, tmIdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, tmIdVend VARCHAR(16) NOT NULL, tmComision DECIMAL(14,4) DEFAULT (0) NOT NULL, tmDetalle VARCHAR(150), tmGalones DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTipoAplica INT DEFAULT (0) NOT NULL, tmCodTarCom VARCHAR(4), tmTipRec VARCHAR(3), tmRecibo INT DEFAULT (0) NOT NULL, tmCiaRec CHAR(2), tmItemRec INT DEFAULT (0) NOT NULL, tmFecPago SMALLDATETIME CONSTRAINT PK_tm_PreAbonos PRIMARY KEY CLUSTERED (tmNumero,tmItem), CONSTRAINT CK_tm_PreAbonostmIdAgencia CHECK ((len([tmIdAgencia]) > 0)), CONSTRAINT CK_tm_PreAbonostmIdCiaPre CHECK ((len([tmIdCiaPre]) > 0)), CONSTRAINT CK_tm_PreAbonostmIdCliente CHECK ((len([tmIdCliente]) > 0)), CONSTRAINT CK_tm_PreAbonostmIdVend CHECK ((len([tmIdVend]) > 0)), CONSTRAINT CK_tm_PreAbonostmNumero CHECK ((len([tmNumero]) > 0)), CONSTRAINT CK_tm_PreAbonostmTipDoc CHECK ((len([tmTipDoc]) > 0))) GO CREATE TABLE tm_PreCuotas ( tmNumero VARCHAR(5) NOT NULL, tmItem INT DEFAULT (0) NOT NULL, tmTipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, tmPrestamo INT DEFAULT (0) NOT NULL, tmIdCiaPre CHAR(2) DEFAULT ('01') NOT NULL, tmItemPre INT DEFAULT (0) NOT NULL, tmCuota INT DEFAULT (0) NOT NULL, tmConcepto VARCHAR(10) DEFAULT ('CAPITAL') NOT NULL, tmFecCausa SMALLDATETIME NOT NULL, tmFecVence SMALLDATETIME NOT NULL, tmVrTotal MONEY DEFAULT (0) NOT NULL, tmTipoTasa VARCHAR(10) DEFAULT ('VARIABLE') NOT NULL, tmDTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaNom DECIMAL(14,4) DEFAULT (0) NOT NULL, tmSpread DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaEfe DECIMAL(14,4) DEFAULT (0) NOT NULL, tmIdCliente VARCHAR(16) NOT NULL, tmIdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, tmIdVend VARCHAR(16) NOT NULL, tmEstado INT DEFAULT (0) NOT NULL, tmDetalle VARCHAR(250), tmTotAbono MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_tm_PreCuotas PRIMARY KEY CLUSTERED (tmNumero,tmItem), CONSTRAINT CK_tm_PreCuotastmConcepto CHECK ((len([tmConcepto]) > 0)), CONSTRAINT CK_tm_PreCuotastmIdAgencia CHECK ((len([tmIdAgencia]) > 0)), CONSTRAINT CK_tm_PreCuotastmIdCiaPre CHECK ((len([tmIdCiaPre]) > 0)), CONSTRAINT CK_tm_PreCuotastmIdCliente CHECK ((len([tmIdCliente]) > 0)), CONSTRAINT CK_tm_PreCuotastmIdVend CHECK ((len([tmIdVend]) > 0)), CONSTRAINT CK_tm_PreCuotastmNumero CHECK ((len([tmNumero]) > 0)), CONSTRAINT CK_tm_PreCuotastmTipDoc CHECK ((len([tmTipDoc]) > 0)), CONSTRAINT CK_tm_PreCuotastmTipoTasa CHECK ((len([tmTipoTasa]) > 0))) GO CREATE TABLE FinClieSaldos ( IdClie VARCHAR(16) NOT NULL, CdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, IdCia CHAR(2) NOT NULL, VrSaldo MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_FinClieSaldos PRIMARY KEY CLUSTERED (IdClie,CdAgencia,IdCia), CONSTRAINT CK_FinClieSaldosCdAgencia CHECK ((len([CdAgencia]) > 0)), CONSTRAINT CK_FinClieSaldosIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_FinClieSaldosIdClie CHECK ((len([IdClie]) > 0))) GO CREATE TABLE Trn_FinDevRec ( TipDev VARCHAR(3) DEFAULT ('OD2') NOT NULL, Devolucion INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, IdConcepto VARCHAR(4) NOT NULL, TipDoc VARCHAR(3) DEFAULT ('RC2') NOT NULL, Recibo INT DEFAULT (0) NOT NULL, IdCiaDoc CHAR(2) DEFAULT ('01') NOT NULL, FecDoc SMALLDATETIME NOT NULL, FecPago SMALLDATETIME NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, VrRecibido MONEY DEFAULT (0) NOT NULL, VrSubTotal MONEY DEFAULT (0) NOT NULL, VrRetencion MONEY DEFAULT (0) NOT NULL, VrReteICA MONEY DEFAULT (0) NOT NULL, VrReteIVA MONEY DEFAULT (0) NOT NULL, VrOtros MONEY DEFAULT (0) NOT NULL, VrOtrDcto MONEY DEFAULT (0) NOT NULL, VrPagosMas MONEY DEFAULT (0) NOT NULL, VrNeto MONEY DEFAULT (0) NOT NULL, VrAplicado MONEY DEFAULT (0) NOT NULL, VrAnticipo MONEY DEFAULT (0) NOT NULL, VrEfectivo MONEY DEFAULT (0) NOT NULL, BaseRet MONEY DEFAULT (0) NOT NULL, BaseIca MONEY DEFAULT (0) NOT NULL, BaseRiv MONEY DEFAULT (0) NOT NULL, IdVend VARCHAR(16) NOT NULL, TarifaCom DECIMAL(14,4) DEFAULT (0) NOT NULL, CodTarCom VARCHAR(4), EnEfectivo BIT DEFAULT (0) NOT NULL, Referencia VARCHAR(50), NumAutoriza INT DEFAULT (0) NOT NULL, ModdDev VARCHAR(10) DEFAULT ('TOTAL') NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, IdCiaCom CHAR(2) NOT NULL, Observacion VARCHAR(250), IdEstado VARCHAR(4) NOT NULL, OrigenAdd VARCHAR(10) NOT NULL, TimeSys SMALLDATETIME NOT NULL, FecUpdate SMALLDATETIME, IdCiaCrea CHAR(2) DEFAULT ('01') NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinDevRec PRIMARY KEY CLUSTERED (TipDev,Devolucion,IdCia), CONSTRAINT CK_Trn_FinDevRecIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdCiaCom CHECK ((len([IdCiaCom]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdCiaCrea CHECK ((len([IdCiaCrea]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdCiaDoc CHECK ((len([IdCiaDoc]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdEstado CHECK ((len([IdEstado]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinDevRecIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinDevRecModdDev CHECK (([ModdDev] = 'PARCIAL' or [ModdDev] = 'TOTAL')), CONSTRAINT CK_Trn_FinDevRecOrigenAdd CHECK ((len([OrigenAdd]) > 0)), CONSTRAINT CK_Trn_FinDevRecTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinDevRecTipDev CHECK ((len([TipDev]) > 0)), CONSTRAINT CK_Trn_FinDevRecTipDoc CHECK ((len([TipDoc]) > 0))) GO CREATE TABLE tm_PreIntMora ( tmNumero VARCHAR(5) NOT NULL, tmItem INT DEFAULT (0) NOT NULL, tmTipDoc VARCHAR(3) NOT NULL, tmPrestamo INT DEFAULT (0) NOT NULL, tmIdCia CHAR(2) NOT NULL, tmItemPre INT DEFAULT (0) NOT NULL, tmIdCliente VARCHAR(16) NOT NULL, tmIdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, tmIdVend VARCHAR(16) NOT NULL, tmFecVence SMALLDATETIME NOT NULL, tmVrTotal MONEY DEFAULT (0) NOT NULL, tmVrAbonado MONEY DEFAULT (0) NOT NULL, tmFecUltLiq SMALLDATETIME NOT NULL, tmFecIniLiq SMALLDATETIME NOT NULL, tmFecFinLiq SMALLDATETIME NOT NULL, tmDiasLiq INT DEFAULT (0) NOT NULL, tmDiasGracia INT DEFAULT (0) NOT NULL, tmBaseLiq MONEY DEFAULT (0) NOT NULL, tmTasaEA DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaEM DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaDia DECIMAL(14,4) DEFAULT (0) NOT NULL, tmVrLiquida MONEY DEFAULT (0) NOT NULL, tmTarifaIva DECIMAL(14,4) DEFAULT (0) NOT NULL, tmVrIva MONEY DEFAULT (0) NOT NULL, tmEstado INT DEFAULT (0) NOT NULL, tmDetalle VARCHAR(250) CONSTRAINT PK_tm_PreIntMora PRIMARY KEY CLUSTERED (tmNumero,tmItem), CONSTRAINT CK_tm_PreIntMoratmIdAgencia CHECK ((len([tmIdAgencia]) > 0)), CONSTRAINT CK_tm_PreIntMoratmIdCia CHECK ((len([tmIdCia]) > 0)), CONSTRAINT CK_tm_PreIntMoratmIdCliente CHECK ((len([tmIdCliente]) > 0)), CONSTRAINT CK_tm_PreIntMoratmIdVend CHECK ((len([tmIdVend]) > 0)), CONSTRAINT CK_tm_PreIntMoratmNumero CHECK ((len([tmNumero]) > 0)), CONSTRAINT CK_tm_PreIntMoratmTipDoc CHECK ((len([tmTipDoc]) > 0))) GO CREATE TABLE Trn_FinCauMora ( TipoProc VARCHAR(3) DEFAULT ('INT') NOT NULL, NumProc INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Item INT DEFAULT (0) NOT NULL, TipDoc VARCHAR(3) NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCiaPre CHAR(2) NOT NULL, ItemPre INT DEFAULT (0) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, IdVend VARCHAR(16) NOT NULL, FecVence SMALLDATETIME NOT NULL, VrTotal MONEY DEFAULT (0) NOT NULL, VrAbonado MONEY DEFAULT (0) NOT NULL, FecUltLiq SMALLDATETIME NOT NULL, FecIniLiq SMALLDATETIME NOT NULL, FecFinLiq SMALLDATETIME NOT NULL, DiasLiquida INT DEFAULT (0) NOT NULL, DiasGracia INT DEFAULT (0) NOT NULL, BaseLiquida MONEY DEFAULT (0) NOT NULL, TasaEA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaEM DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaDia DECIMAL(14,4) DEFAULT (0) NOT NULL, VrLiquida MONEY DEFAULT (0) NOT NULL, TarifaIva DECIMAL(14,4) DEFAULT (0) NOT NULL, VrIvaInt MONEY DEFAULT (0) NOT NULL, NumNotaDb INT DEFAULT (0) NOT NULL, NumComp INT DEFAULT (0) NOT NULL CONSTRAINT PK_Trn_FinCauMora PRIMARY KEY CLUSTERED (TipoProc,NumProc,IdCia,Item), CONSTRAINT CK_Trn_FinCauMoraIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinCauMoraIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinCauMoraIdCiaPre CHECK ((len([IdCiaPre]) > 0)), CONSTRAINT CK_Trn_FinCauMoraIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinCauMoraIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinCauMoraTipDoc CHECK ((len([TipDoc]) > 0)), CONSTRAINT CK_Trn_FinCauMoraTipoProc CHECK ((len([TipoProc]) > 0))) GO CREATE TABLE Trn_FinCausacion ( TipoProc VARCHAR(3) DEFAULT ('CAU') NOT NULL, NumProc INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, TotalCapital MONEY DEFAULT (0) NOT NULL, TotalInteres MONEY DEFAULT (0) NOT NULL, TotalIntMora MONEY DEFAULT (0) NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, Anulado BIT DEFAULT (0) NOT NULL, Observacion VARCHAR(250), TimeSys SMALLDATETIME NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinCausacion PRIMARY KEY CLUSTERED (TipoProc,NumProc,IdCia), CONSTRAINT CK_Trn_FinCausacionIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinCausacionIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinCausacionTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinCausacionTipoProc CHECK ((len([TipoProc]) > 0))) GO CREATE TABLE Trn_FinNotas ( TipDoc VARCHAR(3) DEFAULT ('ND2') NOT NULL, NumNota INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Fecha SMALLDATETIME NOT NULL, IdConcepto VARCHAR(4) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, FechaVence SMALLDATETIME NOT NULL, VrSubTotal MONEY DEFAULT (0) NOT NULL, VrImpuesto MONEY DEFAULT (0) NOT NULL, VrRetencion MONEY DEFAULT (0) NOT NULL, VrReteICA MONEY DEFAULT (0) NOT NULL, VrReteIVA MONEY DEFAULT (0) NOT NULL, VrSancion MONEY DEFAULT (0) NOT NULL, VrOtros MONEY DEFAULT (0) NOT NULL, VrNeto MONEY DEFAULT (0) NOT NULL, VrAplicado MONEY DEFAULT (0) NOT NULL, VrAnticipo MONEY DEFAULT (0) NOT NULL, BaseImp MONEY DEFAULT (0) NOT NULL, BaseRet MONEY DEFAULT (0) NOT NULL, BaseIca MONEY DEFAULT (0) NOT NULL, BaseRiv MONEY DEFAULT (0) NOT NULL, TarifaIva DECIMAL(14,4) DEFAULT (0) NOT NULL, TarifaRet DECIMAL(14,4) DEFAULT (0) NOT NULL, TarifaIca DECIMAL(14,4) DEFAULT (0) NOT NULL, TarifaRiv DECIMAL(14,4) DEFAULT (0) NOT NULL, CodTarIva VARCHAR(4), CodTarRet VARCHAR(4), CodTarIca VARCHAR(4), CodTarRiv VARCHAR(4), IdCCosto VARCHAR(16) NOT NULL, IdSubCos VARCHAR(16) NOT NULL, IdVend VARCHAR(16) NOT NULL, TarifaCom DECIMAL(14,4) DEFAULT (0) NOT NULL, CodTarCom VARCHAR(4), Referencia VARCHAR(50), pVehiculo VARCHAR(10), CdConductor VARCHAR(16) DEFAULT ('0') NOT NULL, TipDcm VARCHAR(3) DEFAULT ('0') NOT NULL, Documento INT DEFAULT (0) NOT NULL, IdCiaDcm CHAR(2) DEFAULT ('00') NOT NULL, FecDcm SMALLDATETIME, CdForma VARCHAR(4) DEFAULT ('0') NOT NULL, NumCheque VARCHAR(20), CdBanco VARCHAR(4) DEFAULT ('0') NOT NULL, MulPlazos BIT DEFAULT (0) NOT NULL, IdPlazo VARCHAR(4) DEFAULT ('0') NOT NULL, Modalidad VARCHAR(10) DEFAULT ('NOTA') NOT NULL, TipCom VARCHAR(3) NOT NULL, Comprobante INT DEFAULT (0) NOT NULL, IdCiaCom CHAR(2) NOT NULL, Observacion VARCHAR(250), Anulado BIT DEFAULT (0) NOT NULL, IdEstado VARCHAR(4) NOT NULL, OrigenAdd VARCHAR(10) NOT NULL, TimeSys SMALLDATETIME NOT NULL, FecUpdate SMALLDATETIME, IdCiaCrea CHAR(2) DEFAULT ('01') NOT NULL, IdUsuario VARCHAR(11) NOT NULL CONSTRAINT PK_Trn_FinNotas PRIMARY KEY CLUSTERED (TipDoc,NumNota,IdCia), CONSTRAINT CK_Trn_FinNotasCdBanco CHECK ((len([CdBanco]) > 0)), CONSTRAINT CK_Trn_FinNotasCdConductor CHECK ((len([CdConductor]) > 0)), CONSTRAINT CK_Trn_FinNotasCdForma CHECK ((len([CdForma]) > 0)), CONSTRAINT CK_Trn_FinNotasIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCCosto CHECK ((len([IdCCosto]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCiaCom CHECK ((len([IdCiaCom]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCiaCrea CHECK ((len([IdCiaCrea]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCiaDcm CHECK ((len([IdCiaDcm]) > 0)), CONSTRAINT CK_Trn_FinNotasIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_Trn_FinNotasIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_Trn_FinNotasIdEstado CHECK ((len([IdEstado]) > 0)), CONSTRAINT CK_Trn_FinNotasIdPlazo CHECK ((len([IdPlazo]) > 0)), CONSTRAINT CK_Trn_FinNotasIdSubCos CHECK ((len([IdSubCos]) > 0)), CONSTRAINT CK_Trn_FinNotasIdUsuario CHECK ((len([IdUsuario]) > 0)), CONSTRAINT CK_Trn_FinNotasIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_Trn_FinNotasModalidad CHECK (([Modalidad] = 'CHEQUES' or ([Modalidad] = 'MORA' or [Modalidad] = 'NOTA'))), CONSTRAINT CK_Trn_FinNotasOrigenAdd CHECK ((len([OrigenAdd]) > 0)), CONSTRAINT CK_Trn_FinNotasTipCom CHECK ((len([TipCom]) > 0)), CONSTRAINT CK_Trn_FinNotasTipDcm CHECK ((len([TipDcm]) > 0)), CONSTRAINT CK_Trn_FinNotasTipDoc CHECK ((len([TipDoc]) > 0))) GO --actualización agosto 12/2009 CREATE TABLE AcuPrestamos ( nAnno INT DEFAULT (0) NOT NULL, nMes INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, SaldoAnt MONEY DEFAULT (0) NOT NULL, Prestamos MONEY DEFAULT (0) NOT NULL, DevPrestamos MONEY DEFAULT (0) NOT NULL, Recibos MONEY DEFAULT (0) NOT NULL, DevRecibos MONEY DEFAULT (0) NOT NULL, NotasDeb MONEY DEFAULT (0) NOT NULL, NotasCre MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_AcuPrestamos PRIMARY KEY CLUSTERED (nAnno,nMes,IdCia,IdCliente,IdAgencia), CONSTRAINT CK_AcuPrestamosIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_AcuPrestamosIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_AcuPrestamosIdCliente CHECK ((len([IdCliente]) > 0))) GO CREATE TABLE tm_PreMovi ( tmEst CHAR(2) DEFAULT ('01') NOT NULL, tmTipDoc VARCHAR(3) DEFAULT ('PR1') NOT NULL, tmNumero INT DEFAULT (0) NOT NULL, tmIdCia CHAR(2) DEFAULT ('01') NOT NULL, tmItem INT DEFAULT (0) NOT NULL, tmFecha SMALLDATETIME NOT NULL, tmIdCliente VARCHAR(16) NOT NULL, tmIdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, tmIdVend VARCHAR(16) NOT NULL, tmCargos MONEY DEFAULT (0) NOT NULL, tmAbonos MONEY DEFAULT (0) NOT NULL, tmNumCuota INT DEFAULT (0) NOT NULL, tmTimeSys SMALLDATETIME NOT NULL, tmFecVence SMALLDATETIME, tmCdConcepto VARCHAR(4) DEFAULT ('0') NOT NULL, tmConcepto VARCHAR(10), tmDetalle VARCHAR(250), tmReferencia VARCHAR(50), tmTipoTasa VARCHAR(10), tmDTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaNom DECIMAL(14,4) DEFAULT (0) NOT NULL, tmPuntos DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTasaEfe DECIMAL(14,4) DEFAULT (0) NOT NULL, tmTipRef VARCHAR(3) DEFAULT ('0') NOT NULL, tmDocRef INT DEFAULT (0) NOT NULL, tmIdCiaRef CHAR(2) DEFAULT ('00') NOT NULL, tmNumForma VARCHAR(20), tmCdBanco VARCHAR(4) DEFAULT ('0') NOT NULL, tmBeneficiario VARCHAR(150), tmCdForma VARCHAR(4), tmEnEfectivo BIT DEFAULT (0) NOT NULL, tmTotalAbono MONEY DEFAULT (0) NOT NULL, tmVrAfavor MONEY DEFAULT (0) NOT NULL, tmTipCom VARCHAR(3) NOT NULL, tmComprobante INT DEFAULT (0) NOT NULL, tmIdCiaCom CHAR(2) NOT NULL, tmAnulado BIT DEFAULT (0) NOT NULL, tmNumDev INT DEFAULT (0) NOT NULL, tmFecDev SMALLDATETIME, tmIdUsuario VARCHAR(11) NOT NULL, tmSanClie MONEY DEFAULT (0) NOT NULL, tmSanClieCia MONEY DEFAULT (0) NOT NULL, tmSanAge MONEY DEFAULT (0) NOT NULL, tmSanAgeCia MONEY DEFAULT (0) NOT NULL CONSTRAINT PK_tm_PreMovi PRIMARY KEY CLUSTERED (tmEst,tmTipDoc,tmNumero,tmIdCia,tmItem), CONSTRAINT CK_tm_PreMovitmCdBanco CHECK ((len([tmCdBanco]) > 0)), CONSTRAINT CK_tm_PreMovitmCdConcepto CHECK ((len([tmCdConcepto]) > 0)), CONSTRAINT CK_tm_PreMovitmEst CHECK ((len([tmEst]) > 0)), CONSTRAINT CK_tm_PreMovitmIdAgencia CHECK ((len([tmIdAgencia]) > 0)), CONSTRAINT CK_tm_PreMovitmIdCia CHECK ((len([tmIdCia]) > 0)), CONSTRAINT CK_tm_PreMovitmIdCiaCom CHECK ((len([tmIdCiaCom]) > 0)), CONSTRAINT CK_tm_PreMovitmIdCiaRef CHECK ((len([tmIdCiaRef]) > 0)), CONSTRAINT CK_tm_PreMovitmIdCliente CHECK ((len([tmIdCliente]) > 0)), CONSTRAINT CK_tm_PreMovitmIdUsuario CHECK ((len([tmIdUsuario]) > 0)), CONSTRAINT CK_tm_PreMovitmIdVend CHECK ((len([tmIdVend]) > 0)), CONSTRAINT CK_tm_PreMovitmTipCom CHECK ((len([tmTipCom]) > 0)), CONSTRAINT CK_tm_PreMovitmTipDoc CHECK ((len([tmTipDoc]) > 0)), CONSTRAINT CK_tm_PreMovitmTipRef CHECK ((len([tmTipRef]) > 0))) GO CREATE TABLE tm_PreCartera ( tmEst CHAR(2) NOT NULL, TipDoc VARCHAR(3) NOT NULL, IdPrestamo INT DEFAULT (0) NOT NULL, IdCia CHAR(2) DEFAULT ('01') NOT NULL, Item INT DEFAULT (1) NOT NULL, NumCuota INT DEFAULT (0) NOT NULL, Fecha SMALLDATETIME NOT NULL, FechaVence SMALLDATETIME NOT NULL, VrTotal MONEY DEFAULT (0) NOT NULL, VrAbonado MONEY DEFAULT (0) NOT NULL, VrSaldo MONEY DEFAULT (0) NOT NULL, TipoTasa VARCHAR(10), DTF_EA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaNom DECIMAL(14,4) DEFAULT (0) NOT NULL, Spread_TA DECIMAL(14,4) DEFAULT (0) NOT NULL, TasaEfe DECIMAL(14,4) DEFAULT (0) NOT NULL, IdCliente VARCHAR(16) NOT NULL, IdAgencia VARCHAR(16) DEFAULT ('0') NOT NULL, IdVend VARCHAR(16) NOT NULL, Concepto VARCHAR(10), TipoCuota INT DEFAULT (0) NOT NULL, NumCausacion INT DEFAULT (0) NOT NULL, IdCiaCau CHAR(2) DEFAULT ('00') NOT NULL, Detalle VARCHAR(250), IdConcepto VARCHAR(4) NOT NULL, FecUltPago SMALLDATETIME, FecLiqMora SMALLDATETIME, FechaCrea SMALLDATETIME NOT NULL, CtaForma VARCHAR(30) NOT NULL, Beneficiario VARCHAR(150), RefCheque VARCHAR(50), NumCheque VARCHAR(20), CdBanco VARCHAR(4) CONSTRAINT PK_tm_PreCartera PRIMARY KEY CLUSTERED (tmEst,TipDoc,IdPrestamo,IdCia,Item), CONSTRAINT CK_tm_PreCarteraCtaForma CHECK ((len([CtaForma]) > 0)), CONSTRAINT CK_tm_PreCarteraIdAgencia CHECK ((len([IdAgencia]) > 0)), CONSTRAINT CK_tm_PreCarteraIdCia CHECK ((len([IdCia]) > 0)), CONSTRAINT CK_tm_PreCarteraIdCiaCau CHECK ((len([IdCiaCau]) > 0)), CONSTRAINT CK_tm_PreCarteraIdCliente CHECK ((len([IdCliente]) > 0)), CONSTRAINT CK_tm_PreCarteraIdConcepto CHECK ((len([IdConcepto]) > 0)), CONSTRAINT CK_tm_PreCarteraIdVend CHECK ((len([IdVend]) > 0)), CONSTRAINT CK_tm_PreCarteraTipDoc CHECK ((len([TipDoc]) > 0)), CONSTRAINT CK_tm_PreCarteratmEst CHECK ((len([tmEst]) > 0))) GO