CREATE TABLE [LBF] (
[NodId] [int] NOT NULL ,
[CodContract] [varchar] (20) NOT NULL ,
[CodCategorie] [varchar] (20) NOT NULL ,
[DataInregistrare] [datetime] NOT NULL ,
[DataInregistrareAjustata] [datetime] NULL ,
[CodClient] [int] NOT NULL ,
[NumeClient] [varchar] (61) NULL ,
[Moneda] [varchar] (3) NULL ,
[DobandaPlatita] [money] NULL ,
[PrincipalPlatit] [money] NULL ,
[ComFlatFee] [money] NULL ,
[ComRetailer] [money] NULL ,
[ComAsigurari] [money] NULL ,
[PrincipalRestant] [money] NULL ,
[DobandaRestanta] [money] NULL ,
[RataPlatita] [money] NULL ,
[Sold] [money] NULL ,
[DataReferinta] [datetime] NOT NULL ,
[RataSchimbRONMedie] [decimal](30, 4) NULL ,
[RataSchimbRON] [decimal](20, 10) NULL ,
[SoldIRR] [money] NULL ,
[ValoareContract] [money] NOT NULL ,
[RataDobandaAnuala] [float] NULL ,
[DurataCreditInitiala] [int] NOT NULL ,
[DataInceputCredit] [datetime] NOT NULL ,
[DataSfarsitCredit] [datetime] NULL ,
[LuniScurse] [int] NOT NULL ,
[LuniRamase] [int] NOT NULL ,
[TipRezidentaClient] [varchar] (10) NULL ,
[TipCredit] [int] NOT NULL ,
[Terminat] [int] NOT NULL ,
[RataSchimbRONZi] [decimal](20, 13) NULL ,
[AmendamentPrincipal] [money] NULL ,
[ComAdministrareLunar] [money] NULL ,
[ComAsigurareLunar] [money] NULL ,
CONSTRAINT [iNodContractDataf] UNIQUE NONCLUSTERED
(
[NodId],
[CodContract],
[DataReferinta],
[DataInregistrareAjustata]
) WITH FILLFACTOR = 20 ON [PRIMARY]
) ON [PRIMARY]
GO