Integration.Supplier_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Supplier_Staging |
Supplier staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Supplier Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
2 | WWI Supplier ID | int | Numeric ID used for reference to a supplier within the WWI database | |||||
Numeric ID used for reference to a supplier within the WWI database |
||||||||
3 | Supplier | nvarchar(100) | Supplier's full name (usually a trading name) | |||||
Supplier's full name (usually a trading name) |
||||||||
4 | Category | nvarchar(50) | Supplier's category | |||||
Supplier's category |
||||||||
5 | Primary Contact | nvarchar(50) | Primary contact | |||||
Primary contact |
||||||||
6 | Supplier Reference | 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) |
||||||||
7 | Payment Days | int | Number of days for payment of an invoice (ie payment terms) | |||||
Number of days for payment of an invoice (ie payment terms) |
||||||||
8 | Postal Code | nvarchar(10) | Delivery postal code for the supplier | |||||
Delivery postal code for the supplier |
||||||||
9 | Valid From | datetime2(7) | Valid from this date and time | |||||
Valid from this date and time |
||||||||
10 | Valid To | datetime2(7) | Valid until this date and time | |||||
Valid until this date and time |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Supplier_Staging | Supplier Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59