Generated using SQL Data Dictionary demo version.


Table Purchasing.Suppliers_Archive (13 rows)


  Column Data Type Identity Nullable Default
SupplierID int
SupplierName nvarchar(100)
SupplierCategoryID int
PrimaryContactPersonID int
AlternateContactPersonID int
DeliveryMethodID int X
DeliveryCityID int
PostalCityID int
SupplierReference nvarchar(20) X
BankAccountName nvarchar(50) X
BankAccountBranch nvarchar(50) X
BankAccountCode nvarchar(20) X
BankAccountNumber nvarchar(20) X
BankInternationalCode nvarchar(20) X
PaymentDays int
InternalComments nvarchar(max) X
PhoneNumber nvarchar(20)
FaxNumber nvarchar(20)
WebsiteURL nvarchar(256)
DeliveryAddressLine1 nvarchar(60)
DeliveryAddressLine2 nvarchar(60) X
DeliveryPostalCode nvarchar(10)
DeliveryLocation geography X
PostalAddressLine1 nvarchar(60)
PostalAddressLine2 nvarchar(60) X
PostalPostalCode nvarchar(10)
LastEditedBy int
ValidFrom datetime2
ValidTo datetime2

Indexes:


Used by: