CREATE TABLE Trn_TraFacMasivo ( 
Id BIGINT IDENTITY ( 1,1 ) NOT NULL,
IdCia CHAR(2) DEFAULT ('01') NOT NULL,
NumTransac VARCHAR(20) NOT NULL,
Fecha DATETIME NOT NULL,
TipFact VARCHAR(3) NOT NULL,
NumFactura INT DEFAULT ((0)) NOT NULL,
IdCiaFact CHAR(2) DEFAULT ('01') NOT NULL,
TipRem VARCHAR(3) NOT NULL,
Remesa INT DEFAULT ((0)) NOT NULL,
IdCiaRem CHAR(2) NOT NULL,
ItemRem INT DEFAULT ((0)) NOT NULL,
FechaCrea DATETIME NOT NULL,
IdUsuario VARCHAR(11) NOT NULL
 CONSTRAINT PK_Trn_TraFacMasivo PRIMARY KEY NONCLUSTERED (Id),
 CONSTRAINT CK_Trn_TraFacMasivoIdCia CHECK ((len([IdCia])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoIdCiaFact CHECK ((len([IdCiaFact])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoIdCiaRem CHECK ((len([IdCiaRem])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoIdUsuario CHECK ((len([IdUsuario])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoNumTransac CHECK ((len([NumTransac])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoTipFact CHECK ((len([TipFact])>(0))),
 CONSTRAINT CK_Trn_TraFacMasivoTipRem CHECK ((len([TipRem])>(0))))
GO
ALTER TABLE tm_TraRemFact ADD tmEstado INT DEFAULT(0) NOT NULL,tmObserv VARCHAR(500),tmTotFletes MONEY DEFAULT(0) NOT NULL
,tmTotOtros MONEY DEFAULT(0) NOT NULL,tmTotCargos MONEY DEFAULT(0) NOT NULL,tmTotDctos MONEY DEFAULT(0) NOT NULL
,tmTotCostoAfi MONEY DEFAULT(0) NOT NULL,tmTotCostoRem MONEY DEFAULT(0) NOT NULL
,tmReteCree MONEY DEFAULT(0) NOT NULL,tmTarifaCree DECIMAL(14,4) DEFAULT(0) NOT NULL,tmCdTarCree VARCHAR(4)
,tmReteIva MONEY DEFAULT(0) NOT NULL,tmTarifaRiv DECIMAL(14,4) DEFAULT(0) NOT NULL,tmCdTarRiv VARCHAR(4)
,tmTarifaAri DECIMAL(14,4) DEFAULT(0) NOT NULL,tmCdTarAri VARCHAR(4)
,tmBaseIva MONEY DEFAULT(0) NOT NULL,tmBaseRet MONEY DEFAULT(0) NOT NULL,tmBaseIca MONEY DEFAULT(0) NOT NULL,tmBaseRiv MONEY DEFAULT(0) NOT NULL
,tmVrNeto MONEY DEFAULT(0) NOT NULL 
GO
ALTER TABLE TercCliente ADD TipoFMR INT DEFAULT(0) NOT NULL
GO
INSERT INTO Sys_ObjetosApp (IdObj,IdGrupo,SubModulo,IndObj,Nombre,Formulario,Permisos,NivelMinimo,NomArchivo)
 VALUES ('FRMFACRMT','TRAPRO','TRA',24,'Facturación Masiva de Remesas','FRMFACRMT','SSSSSSSSSSSSS',0,'')
GO
INSERT INTO Sys_Roles (IdObj,IdRole,Funcion)
 VALUES ('FRMFACRMT','PZO','Permitir Seleccionar Plazo de Factura')
INSERT INTO Sys_Roles (IdObj,IdRole,Funcion)
 VALUES ('FRMFACRMT','MCL','Permitir Multiples Clientes (Factura Individual)')
GO 
 CREATE CLUSTERED INDEX IX_Trn_TraFacMasivo_NumTransac ON Trn_TraFacMasivo(IdCia,NumTransac,Id)
 CREATE NONCLUSTERED INDEX IX_Trn_TraFacMasivo_NumFactura ON Trn_TraFacMasivo(TipFact,NumFactura,IdCiaFact)