Tables [dbo].[APVendors]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:54 AM Thursday, March 21, 2019
Last Modified1:16:00 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_APVendors: VendorIDVendorIDint4
False
VendorNumbervarchar(15)15
False
VendorNamevarchar(50)50
False
Addressvarchar(60)60
False
Cityvarchar(30)30
False
Statevarchar(15)15
False
Zipvarchar(10)10
False
Countryvarchar(15)15
False
Contactvarchar(50)50
False
Phonevarchar(30)30
False
Faxvarchar(30)30
False
Emailvarchar(255)255
False
WebSitevarchar(50)50
False
PurchaseContactvarchar(50)50
False
PurchasePhonevarchar(30)30
False
PurchaseFaxvarchar(30)30
False
Foreign Keys FK_APVendors_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Foreign Keys FK_APVendors_ShipMethodID_ShShipMethods: [dbo].[ShShipMethods].ShipMethodIDShipMethodIDint4
True
EINvarchar(15)15
False
VendorAccountNumbervarchar(30)30
False
CreditLimitmoney8
False
Do1099bit1
False
Holdbit1
False
Remarksvarchar(1024)1024
False
Invoicesmoney8
False
((0))
Unappliedmoney8
False
((0))
Receiptsmoney8
False
((0))
Ordersmoney8
False
((0))
Activebit1
False
Locksint4
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_APVendors_DBFileHeaderID_DBFileHeader: [dbo].[DBFileHeader].DBFileHeaderIDDBFileHeaderIDint4
False
((1))
Foreign Keys FK_APVendors_OnHoldCodeID_SHOnHoldCodes: [dbo].[ShOnHoldCodes].OnHoldCodeIDOnHoldCodeIDint4
True
Foreign Keys FK_APVendors_ExportModuleID_SHExportModules: [dbo].[SHExportModules].ExportModuleIDExportModuleIDint4
True
EFTEnabledbit1
False
((0))
Foreign Keys FK_APVendors_EFTAccountTypeID_CBAccountTypes: [dbo].[CBAccountTypes].EFTAccountTypeIDEFTAccountTypeIDint4
True
EFTAccountNumbervarchar(17)17
False
('')
EFTRoutingNumbervarchar(9)9
False
('')
EFTBNAccountNumbervarbinary(32)32
False
((0))
EFTBNRoutingNumbervarbinary(32)32
False
((0))
EFTNotificationNamevarchar(50)50
False
('')
EFTNotificationPhonevarchar(30)30
False
('')
EFTNotificationEmailvarchar(50)50
False
('')
EFTNotificationBccvarchar(50)50
False
('')
PendingPrenotebit1
False
((1))
ActivePrenoteDatedatetime8
True
Foreign Keys FK_APVendors_NoteID_APVendorNotes: [dbo].[APVendorNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Foreign Keys FK_APVendors_DefaultAccountID_GLAccounts: [dbo].[GLAccounts].DefaultAccountIDDefaultAccountIDint4
True
Foreign Keys FK_APVendors_DefaultDeptID_GLDepts: [dbo].[GLDepts].DefaultDeptIDDefaultDeptIDint4
True
Foreign Keys FK_APVendors_DefaultBranchID_GLBranches: [dbo].[GLBranches].DefaultBranchIDDefaultBranchIDint4
True
Foreign Keys FK_APVendors_ShTrackingConfigID_ShTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
Foreign Keys FK_APVendors_ContactID_CMContacts: [dbo].[CMContacts].ContactIDContactIDint4
True
Foreign Keys FK_APVendors_PurchaseContactID_CMContacts: [dbo].[CMContacts].PurchaseContactIDPurchaseContactIDint4
True
Foreign Keys FK_APVendors_ReturnContactID_CMContacts: [dbo].[CMContacts].ReturnContactIDReturnContactIDint4
True
PurchaseEmailvarchar(255)255
False
('')
Foreign Keys FK_APVendors_OrderMethodID_SHDocSendMethods: [dbo].[SHDocSendMethods].OrderMethodIDOrderMethodIDtinyint1
False
((1))
Foreign Keys FK_APVendors_ProcessorVendorID_POProcessorVendors: [dbo].[POProcessorVendors].ProcessorVendorIDProcessorVendorIDint4
True
Foreign Keys FK_APVendors_DefaultDistributionCodeID_GLDistributionCodes: [dbo].[GLDistributionCodes].DefaultDistributionCodeIDDefaultDistributionCodeIDint4
True
Foreign Keys FK_APVendors_DefaultDivisionID_GLDivisions: [dbo].[GLDivisions].DefaultDivisionIDDefaultDivisionIDint4
True
NoteCountint4
False
((0))
Foreign Keys FK_APVendors_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
Foreign Keys FK_APVendors_TaxExemptCodeID_ShTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_APVendors: VendorIDPK_APVendorsVendorID
True
80
NameColumns
FK_APVendors_ContactID_CMContactsContactID->[dbo].[CMContacts].[ContactID]
FK_APVendors_DBFileHeaderID_DBFileHeaderDBFileHeaderID->[dbo].[DBFileHeader].[DBFileHeaderID]
FK_APVendors_DefaultAccountID_GLAccountsDefaultAccountID->[dbo].[GLAccounts].[AccountID]
FK_APVendors_DefaultBranchID_GLBranchesDefaultBranchID->[dbo].[GLBranches].[BranchID]
FK_APVendors_DefaultDeptID_GLDeptsDefaultDeptID->[dbo].[GLDepts].[DeptID]
FK_APVendors_DefaultDistributionCodeID_GLDistributionCodesDefaultDistributionCodeID->[dbo].[GLDistributionCodes].[DistributionCodeID]
FK_APVendors_DefaultDivisionID_GLDivisionsDefaultDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_APVendors_EFTAccountTypeID_CBAccountTypesEFTAccountTypeID->[dbo].[CBAccountTypes].[AccountTypeID]
FK_APVendors_ExportModuleID_SHExportModulesExportModuleID->[dbo].[SHExportModules].[SHExportModuleID]
FK_APVendors_NoteID_APVendorNotesNoteID->[dbo].[APVendorNotes].[NoteID]
FK_APVendors_OnHoldCodeID_SHOnHoldCodesOnHoldCodeID->[dbo].[ShOnHoldCodes].[OnHoldCodeID]
FK_APVendors_OrderMethodID_SHDocSendMethodsOrderMethodID->[dbo].[SHDocSendMethods].[DocSendMethodID]
FK_APVendors_ProcessorVendorID_POProcessorVendorsProcessorVendorID->[dbo].[POProcessorVendors].[ProcessorVendorID]
FK_APVendors_PurchaseContactID_CMContactsPurchaseContactID->[dbo].[CMContacts].[ContactID]
FK_APVendors_ReturnContactID_CMContactsReturnContactID->[dbo].[CMContacts].[ContactID]
FK_APVendors_ShipMethodID_ShShipMethodsShipMethodID->[dbo].[ShShipMethods].[ShipMethodID]
FK_APVendors_ShTrackingConfigID_ShTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
FK_APVendors_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_APVendors_TaxExemptCodeID_ShTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_APVendors_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
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