Generated using SQL Data Dictionary demo version.
Column | Data Type | Identity | Nullable | Default | |
---|---|---|---|---|---|
CustomerID | int | ||||
CustomerName | nvarchar(100) | ||||
BillToCustomerID | int | ||||
CustomerCategoryID | int | ||||
BuyingGroupID | int | X | |||
PrimaryContactPersonID | int | ||||
AlternateContactPersonID | int | X | |||
DeliveryMethodID | int | ||||
DeliveryCityID | int | ||||
PostalCityID | int | ||||
CreditLimit | decimal(18,2) | X | |||
AccountOpenedDate | date | ||||
StandardDiscountPercentage | decimal(18,3) | ||||
IsStatementSent | bit | ||||
IsOnCreditHold | bit | ||||
PaymentDays | int | ||||
PhoneNumber | nvarchar(20) | ||||
FaxNumber | nvarchar(20) | ||||
DeliveryRun | nvarchar(5) | X | |||
RunPosition | nvarchar(5) | X | |||
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 |