USE [FSLibrary]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [NonClusteredIndex-20200701-082116]    Script Date: 7/2/2020 9:11:26 AM ******/
CREATE NONCLUSTERED INDEX [idx_AgreementNumVer] ON [dbo].[tbl_IMPORT_BlackSmithAgreements]
(
	[eai_batchid] ASC,
	[ownerId] ASC,
	[ownerType] ASC,
	[AgreementNumber] ASC,
	[AgreementVersion] ASC
)
INCLUDE([BenefiicaryType],[BeneficiaryCustomerNbr]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO