Generated using SQL Data Dictionary demo version.
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 |