Purchasing.Suppliers

Columns

• //

  ${escapify(column.description)}
  SupplierID
  [int] NOT NULL DEFAULT (NEXT VALUE FOR [Sequences].[SupplierID])
• //

  ${escapify(column.description)}
  SupplierName
  [nvarchar](100) NOT NULL
• //

  ${escapify(column.description)}
  SupplierCategoryID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  PrimaryContactPersonID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  AlternateContactPersonID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  DeliveryMethodID
  [int] NULL
• //

  ${escapify(column.description)}
  DeliveryCityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  PostalCityID
  [int] NOT NULL
• //

  ${escapify(column.description)}
  SupplierReference
  [nvarchar](20) NULL
• //

  ${escapify(column.description)}
  BankAccountName
  [nvarchar](50) NULL

  //

  MASKING FUNCTION

  default()
• //

  ${escapify(column.description)}
  BankAccountBranch
  [nvarchar](50) NULL

  //

  MASKING FUNCTION

  default()
• //

  ${escapify(column.description)}
  BankAccountCode
  [nvarchar](20) NULL

  //

  MASKING FUNCTION

  default()
• //

  ${escapify(column.description)}
  BankAccountNumber
  [nvarchar](20) NULL

  //

  MASKING FUNCTION

  default()
• //

  ${escapify(column.description)}
  BankInternationalCode
  [nvarchar](20) NULL

  //

  MASKING FUNCTION

  default()
• //

  ${escapify(column.description)}
  PaymentDays
  [int] NOT NULL
• //

  ${escapify(column.description)}
  InternalComments
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  PhoneNumber
  [nvarchar](20) NOT NULL
• //

  ${escapify(column.description)}
  FaxNumber
  [nvarchar](20) NOT NULL
• //

  ${escapify(column.description)}
  WebsiteURL
  [nvarchar](256) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryAddressLine1
  [nvarchar](60) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryAddressLine2
  [nvarchar](60) NULL
• //

  ${escapify(column.description)}
  DeliveryPostalCode
  [nvarchar](10) NOT NULL
• //

  ${escapify(column.description)}
  DeliveryLocation
  [geography] NULL
• //

  ${escapify(column.description)}
  PostalAddressLine1
  [nvarchar](60) NOT NULL
• //

  ${escapify(column.description)}
  PostalAddressLine2
  [nvarchar](60) NULL
• //

  ${escapify(column.description)}
  PostalPostalCode
  [nvarchar](10) NOT NULL
• LastEditedBy
  [int] NOT NULL
• ValidFrom
  [datetime2](8) NOT NULL
• ValidTo
  [datetime2](8) NOT NULL

Indexes

• PK_Purchasing_Suppliers
  UNIQUE CLUSTERED
  SupplierID
• UQ_Purchasing_Suppliers_SupplierName
  UNIQUE NONCLUSTERED
  SupplierName
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_SupplierCategoryID
  NONCLUSTERED
  SupplierCategoryID
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_PrimaryContactPersonID
  NONCLUSTERED
  PrimaryContactPersonID
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_AlternateContactPersonID
  NONCLUSTERED
  AlternateContactPersonID
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_DeliveryMethodID
  NONCLUSTERED
  DeliveryMethodID
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_DeliveryCityID
  NONCLUSTERED
  DeliveryCityID
• //

  Auto-created to support a foreign key
  FK_Purchasing_Suppliers_PostalCityID
  NONCLUSTERED
  PostalCityID

Foreign Keys

• FK_Purchasing_Suppliers_AlternateContactPersonID_Application_People
  Application.People
  AlternateContactPersonID ⥱ PersonID
• FK_Purchasing_Suppliers_Application_People
  Application.People
  LastEditedBy ⥱ PersonID
• FK_Purchasing_Suppliers_DeliveryCityID_Application_Cities
  Application.Cities
  DeliveryCityID ⥱ CityID
• FK_Purchasing_Suppliers_DeliveryMethodID_Application_DeliveryMethods
  Application.DeliveryMethods
  DeliveryMethodID ⥱ DeliveryMethodID
• FK_Purchasing_Suppliers_PostalCityID_Application_Cities
  Application.Cities
  PostalCityID ⥱ CityID
• FK_Purchasing_Suppliers_PrimaryContactPersonID_Application_People
  Application.People
  PrimaryContactPersonID ⥱ PersonID
• FK_Purchasing_Suppliers_SupplierCategoryID_Purchasing_SupplierCategories
  Purchasing.SupplierCategories
  SupplierCategoryID ⥱ SupplierCategoryID

Sample Data