Purchasing.Suppliers_Archive
Documentation | WideWorldImporters |
Schema | Purchasing |
Name | Suppliers_Archive |
Modules | Purchasing, History tables |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | SupplierID | int | Numeric ID used for reference to a supplier within the database | |||||
Numeric ID used for reference to a supplier within the database |
||||||||
2 | SupplierName | nvarchar(100) | Supplier's full name (usually a trading name) | |||||
Supplier's full name (usually a trading name) |
||||||||
3 | SupplierCategoryID | int | Supplier's category | |||||
Supplier's category |
||||||||
4 | PrimaryContactPersonID | int | Primary contact | |||||
Primary contact |
||||||||
5 | AlternateContactPersonID | int | Alternate contact | |||||
Alternate contact |
||||||||
6 | DeliveryMethodID | int | Standard delivery method for stock items received from this supplier | |||||
Standard delivery method for stock items received from this supplier |
||||||||
7 | DeliveryCityID | int | ID of the delivery city for this address | |||||
ID of the delivery city for this address |
||||||||
8 | PostalCityID | int | ID of the mailing city for this address | |||||
ID of the mailing city for this address |
||||||||
9 | SupplierReference | nvarchar(20) | Supplier reference for our organization (might be our account number at the supplier) | |||||
Supplier reference for our organization (might be our account number at the supplier) |
||||||||
10 | BankAccountName | nvarchar(50) | Supplier's bank account name (ie name on the account) | |||||
Supplier's bank account name (ie name on the account) |
||||||||
11 | BankAccountBranch | nvarchar(50) | Supplier's bank branch | |||||
Supplier's bank branch |
||||||||
12 | BankAccountCode | nvarchar(20) | Supplier's bank account code (usually a numeric reference for the bank branch) | |||||
Supplier's bank account code (usually a numeric reference for the bank branch) |
||||||||
13 | BankAccountNumber | nvarchar(20) | Supplier's bank account number | |||||
Supplier's bank account number |
||||||||
14 | BankInternationalCode | nvarchar(20) | Supplier's bank's international code (such as a SWIFT code) | |||||
Supplier's bank's international code (such as a SWIFT code) |
||||||||
15 | PaymentDays | int | Number of days for payment of an invoice (ie payment terms) | |||||
Number of days for payment of an invoice (ie payment terms) |
||||||||
16 | InternalComments | nvarchar(MAX) | Internal comments (not exposed outside organization) | |||||
Internal comments (not exposed outside organization) |
||||||||
17 | PhoneNumber | nvarchar(20) | Phone number | |||||
Phone number |
||||||||
18 | FaxNumber | nvarchar(20) | Fax number | |||||
Fax number |
||||||||
19 | WebsiteURL | nvarchar(256) | URL for the website for this supplier | |||||
URL for the website for this supplier |
||||||||
20 | DeliveryAddressLine1 | nvarchar(60) | First delivery address line for the supplier | |||||
First delivery address line for the supplier |
||||||||
21 | DeliveryAddressLine2 | nvarchar(60) | Second delivery address line for the supplier | |||||
Second delivery address line for the supplier |
||||||||
22 | DeliveryPostalCode | nvarchar(10) | Delivery postal code for the supplier | |||||
Delivery postal code for the supplier |
||||||||
23 | DeliveryLocation | geography | Geographic location for the supplier's office/warehouse | |||||
Geographic location for the supplier's office/warehouse |
||||||||
24 | PostalAddressLine1 | nvarchar(60) | First postal address line for the supplier | |||||
First postal address line for the supplier |
||||||||
25 | PostalAddressLine2 | nvarchar(60) | Second postal address line for the supplier | |||||
Second postal address line for the supplier |
||||||||
26 | PostalPostalCode | nvarchar(10) | Postal code for the supplier when sending by mail | |||||
Postal code for the supplier when sending by mail |
||||||||
27 | LastEditedBy | int | ||||||
28 | ValidFrom | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
29 | 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