CREATE TABLE [dbo].[APVendors]
(
[VendorID] [int] NOT NULL,
[VendorNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VendorName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSite] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PurchaseContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PurchasePhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PurchaseFax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermID] [int] NULL,
[ShipMethodID] [int] NULL,
[EIN] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VendorAccountNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreditLimit] [money] NOT NULL,
[Do1099] [bit] NOT NULL,
[Hold] [bit] NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Invoices] [money] NOT NULL CONSTRAINT [DF_APVendors_Invoices] DEFAULT ((0)),
[Unapplied] [money] NOT NULL CONSTRAINT [DF_APVendors_Unapplied] DEFAULT ((0)),
[Receipts] [money] NOT NULL CONSTRAINT [DF_APVendors_Receipts] DEFAULT ((0)),
[Orders] [money] NOT NULL CONSTRAINT [DF_APVendors_Orders] DEFAULT ((0)),
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_APVendors_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_APVendors_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_APVendors_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_APVendors_DBFileHeaderID] DEFAULT ((1)),
[OnHoldCodeID] [int] NULL,
[ExportModuleID] [int] NULL,
[EFTEnabled] [bit] NOT NULL CONSTRAINT [DF_APVendors_EFTEnabled] DEFAULT ((0)),
[EFTAccountTypeID] [int] NULL,
[EFTAccountNumber] [varchar] (17) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTAccountNumber] DEFAULT (''),
[EFTRoutingNumber] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTRoutingNumber] DEFAULT (''),
[EFTBNAccountNumber] [varbinary] (32) NOT NULL CONSTRAINT [DF_APVendors_EFTBNAccountNumber] DEFAULT ((0)),
[EFTBNRoutingNumber] [varbinary] (32) NOT NULL CONSTRAINT [DF_APVendors_EFTBNRoutingNumber] DEFAULT ((0)),
[EFTNotificationName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTNotificationName] DEFAULT (''),
[EFTNotificationPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTNotificationPhone] DEFAULT (''),
[EFTNotificationEmail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTNotificationEmail] DEFAULT (''),
[EFTNotificationBcc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_EFTNotificationBcc] DEFAULT (''),
[PendingPrenote] [bit] NOT NULL CONSTRAINT [DF_APVendors_PendingPrenote] DEFAULT ((1)),
[ActivePrenoteDate] [datetime] NULL,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_APVendors_NoteFlag] DEFAULT ((0)),
[DefaultAccountID] [int] NULL,
[DefaultDeptID] [int] NULL,
[DefaultBranchID] [int] NULL,
[ShTrackingConfigID] [int] NULL,
[ContactID] [int] NULL,
[PurchaseContactID] [int] NULL,
[ReturnContactID] [int] NULL,
[PurchaseEmail] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_APVendors_PurchaseEmail] DEFAULT (''),
[OrderMethodID] [tinyint] NOT NULL CONSTRAINT [DF_APVendors_OrderMethodID] DEFAULT ((1)),
[ProcessorVendorID] [int] NULL,
[DefaultDistributionCodeID] [int] NULL,
[DefaultDivisionID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_APVendors_NoteCount] DEFAULT ((0)),
[TaxCodeID] [int] NULL,
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_APVendors_Taxable] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [PK_APVendors] PRIMARY KEY CLUSTERED ([VendorID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ContactID_CMContacts] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DefaultAccountID_GLAccounts] FOREIGN KEY ([DefaultAccountID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DefaultBranchID_GLBranches] FOREIGN KEY ([DefaultBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DefaultDeptID_GLDepts] FOREIGN KEY ([DefaultDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DefaultDistributionCodeID_GLDistributionCodes] FOREIGN KEY ([DefaultDistributionCodeID]) REFERENCES [dbo].[GLDistributionCodes] ([DistributionCodeID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_DefaultDivisionID_GLDivisions] FOREIGN KEY ([DefaultDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_EFTAccountTypeID_CBAccountTypes] FOREIGN KEY ([EFTAccountTypeID]) REFERENCES [dbo].[CBAccountTypes] ([AccountTypeID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ExportModuleID_SHExportModules] FOREIGN KEY ([ExportModuleID]) REFERENCES [dbo].[SHExportModules] ([SHExportModuleID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_NoteID_APVendorNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[APVendorNotes] ([NoteID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_OnHoldCodeID_SHOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_OrderMethodID_SHDocSendMethods] FOREIGN KEY ([OrderMethodID]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ProcessorVendorID_POProcessorVendors] FOREIGN KEY ([ProcessorVendorID]) REFERENCES [dbo].[POProcessorVendors] ([ProcessorVendorID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_PurchaseContactID_CMContacts] FOREIGN KEY ([PurchaseContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ReturnContactID_CMContacts] FOREIGN KEY ([ReturnContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_TaxExemptCodeID_ShTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[APVendors] ADD CONSTRAINT [FK_APVendors_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO