Sales.Customers_Archive
Documentation | WideWorldImporters |
Schema | Sales |
Name | Customers_Archive |
Modules | Sales, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | CustomerID | int | Numeric ID used for reference to a customer within the database | |||||
Numeric ID used for reference to a customer within the database |
||||||||
2 | CustomerName | nvarchar(100) | Customer's full name (usually a trading name) | |||||
Customer's full name (usually a trading name) |
||||||||
3 | BillToCustomerID | int | Customer that this is billed to (usually the same customer but can be another parent company) | |||||
Customer that this is billed to (usually the same customer but can be another parent company) |
||||||||
4 | CustomerCategoryID | int | Customer's category | |||||
Customer's category |
||||||||
5 | BuyingGroupID | int | Customer's buying group (optional) | |||||
Customer's buying group (optional) |
||||||||
6 | PrimaryContactPersonID | int | Primary contact | |||||
Primary contact |
||||||||
7 | AlternateContactPersonID | int | Alternate contact | |||||
Alternate contact |
||||||||
8 | DeliveryMethodID | int | Standard delivery method for stock items sent to this customer | |||||
Standard delivery method for stock items sent to this customer |
||||||||
9 | DeliveryCityID | int | ID of the delivery city for this address | |||||
ID of the delivery city for this address |
||||||||
10 | PostalCityID | int | ID of the postal city for this address | |||||
ID of the postal city for this address |
||||||||
11 | CreditLimit | decimal(18, 2) | Credit limit for this customer (NULL if unlimited) | |||||
Credit limit for this customer (NULL if unlimited) |
||||||||
12 | AccountOpenedDate | date | Date this customer account was opened | |||||
Date this customer account was opened |
||||||||
13 | StandardDiscountPercentage | decimal(18, 3) | Standard discount offered to this customer | |||||
Standard discount offered to this customer |
||||||||
14 | IsStatementSent | bit | Is a statement sent to this customer? (Or do they just pay on each invoice?) | |||||
Is a statement sent to this customer? (Or do they just pay on each invoice?) |
||||||||
15 | IsOnCreditHold | bit | Is this customer on credit hold? (Prevents further deliveries to this customer) | |||||
Is this customer on credit hold? (Prevents further deliveries to this customer) |
||||||||
16 | PaymentDays | int | Number of days for payment of an invoice (ie payment terms) | |||||
Number of days for payment of an invoice (ie payment terms) |
||||||||
17 | PhoneNumber | nvarchar(20) | Phone number | |||||
Phone number |
||||||||
18 | FaxNumber | nvarchar(20) | Fax number | |||||
Fax number |
||||||||
19 | DeliveryRun | nvarchar(5) | Normal delivery run for this customer | |||||
Normal delivery run for this customer |
||||||||
20 | RunPosition | nvarchar(5) | Normal position in the delivery run for this customer | |||||
Normal position in the delivery run for this customer |
||||||||
21 | WebsiteURL | nvarchar(256) | URL for the website for this customer | |||||
URL for the website for this customer |
||||||||
22 | DeliveryAddressLine1 | nvarchar(60) | First delivery address line for the customer | |||||
First delivery address line for the customer |
||||||||
23 | DeliveryAddressLine2 | nvarchar(60) | Second delivery address line for the customer | |||||
Second delivery address line for the customer |
||||||||
24 | DeliveryPostalCode | nvarchar(10) | Delivery postal code for the customer | |||||
Delivery postal code for the customer |
||||||||
25 | DeliveryLocation | geography | Geographic location for the customer's office/warehouse | |||||
Geographic location for the customer's office/warehouse |
||||||||
26 | PostalAddressLine1 | nvarchar(60) | First postal address line for the customer | |||||
First postal address line for the customer |
||||||||
27 | PostalAddressLine2 | nvarchar(60) | Second postal address line for the customer | |||||
Second postal address line for the customer |
||||||||
28 | PostalPostalCode | nvarchar(10) | Postal code for the customer when sending by mail | |||||
Postal code for the customer when sending by mail |
||||||||
29 | LastEditedBy | int | ||||||
30 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
31 | ValidTo | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51