CREATE TABLE [dbo].[AccountingVendor]
(
[AccountingVendorId] [int] NOT NULL IDENTITY(1, 1),
[Name] [varchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VendorNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Hidden] [bit] NOT NULL CONSTRAINT [DF_AccountingVendor_Hidden] DEFAULT ((0)),
[OnHold] [bit] NOT NULL,
[Ten99Type] [smallint] NOT NULL CONSTRAINT [DF_AccountingVendor_Ten99Type] DEFAULT ((1)),
[Phone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Contact] [varchar] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Status] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountingVendorClassFid] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingVendor] ADD CONSTRAINT [PK_AccountingVendor] PRIMARY KEY CLUSTERED  ([AccountingVendorId]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_AccountingVendor_Name] ON [dbo].[AccountingVendor] ([Name]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_AccountingVendor_VendorNumber] ON [dbo].[AccountingVendor] ([VendorNumber]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AccountingVendor] ADD CONSTRAINT [FK_AccountingVendor_AccountingVendorClass] FOREIGN KEY ([AccountingVendorClassFid]) REFERENCES [dbo].[AccountingVendorClass] ([AccountingVendorClassId])
GO
GRANT SELECT ON  [dbo].[AccountingVendor] TO [MssExec]
GRANT INSERT ON  [dbo].[AccountingVendor] TO [MssExec]
GRANT DELETE ON  [dbo].[AccountingVendor] TO [MssExec]
GRANT UPDATE ON  [dbo].[AccountingVendor] TO [MssExec]
GO