Mauricio aqui esta la tabla:
[CustomerId] [int] IDENTITY(1,1) NOT NULL,
[CustomerName] [varchar](100) NOT NULL,
[CustomerFirstName] [varchar](35) NULL,
[CustomerLastName] [varchar](35) NULL,
[CustomerCode] [varchar](50) NULL,
[WebPage] [varchar](100) NULL,
[EmailAddress1] [varchar](100) NULL,
[EmailAddress2] [varchar](100) NULL,
[EmailAddress3] [varchar](100) NULL,
[CreatedBy] [varchar](100) NULL,
[CreatedDateTime] [datetime] NULL CONSTRAINT [DF_CustomerInfoTable_CreatedDateTime] DEFAULT (getdate()),
[ModifiedBy] [varchar](100) NULL,
[ModifiedDateTime] [datetime] NULL CONSTRAINT [DF_CustomerInfoTable_ModifiedDateTime] DEFAULT (getdate()),
[IsDeleted] [tinyint] NULL,
[ModifiedOn] [datetime] NULL CONSTRAINT [DF_CustomerTable_ModifiedOn] DEFAULT (getdate()),
[FederalId] [int] NULL,
[BusinessAddress] [varchar](100) NULL,
[BusinessAddress2] [varchar](100) NULL,
[BusinessAddressCity] [varchar](50) NULL,
[BusinessAddressState] [varchar](2) NULL,
[BusinessAddressZipCode] [varchar](11) NULL,
[BusinessTelephone] [varchar](50) NULL,
[BusinessFax] [varchar](50) NULL,
[Note] [varchar](4000) NULL,
[PaymentTermsDays] [int] NULL,
[PaymentType] [varchar](1) NULL,
[CreditLimit] [decimal](13, 2) NULL,
[ISACTIVE] [tinyint] NULL CONSTRAINT [DF__Customer__ISACTI__50B1B6BF] DEFAULT ((0)),
[MERCHANTID] [varchar](30) NULL CONSTRAINT [DF__Customer__MERCHA__51A5DAF8] DEFAULT (''),
[BondedId] [varchar](6) NULL,
[MerchanIdExpirationDate] [datetime] NULL,
[SalesRepresentative] [varchar](50) NULL,
Código: Seleccionar todo
[int] NULL CONSTRAINT [DF__Customer__CODE__70EA477E] DEFAULT ((0)),
[CODFEE] [real] NULL CONSTRAINT [DF__Customer__CODFEE__6BA66F74] DEFAULT ((0)),
[CREDITTERMCODE] [varchar](2) NULL DEFAULT (''),
[CREDITID] [int] NULL DEFAULT ((0)),
[LP_DATE] [datetime] NULL,
[LP_AMT] [decimal](9, 2) NULL,
[PAYS_RECD] [int] NULL,
[STAT_UNAN] [int] NULL,
[CUR_CR] [decimal](9, 2) NULL,
[CUR_DR] [decimal](9, 2) NULL,
[EEIExpirationDate] [datetime] NULL,
[TitlePosition] [varchar](50) NULL,
[CreateBy] [varchar](50) NULL,
[ModifiedDate] [datetime] NULL,
[PickupFlag] [bit] NULL,
[DbaName] [varchar](50) NULL,
[CreditDate] [datetime] NULL,
[DeliveryFlag] [bit] NULL,
[LinesRepId] [int] NULL,
[InvoiceBalances] [decimal](18, 2) NULL,
[CustomerType] [int] NULL,
[CarrierFactor] [decimal](18, 2) NULL,