Integration.Customer_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Customer_Staging |
Customer staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Customer Staging Key | int | Identity | Row ID within the staging table | ||||
Row ID within the staging table Identity |
||||||||
2 | WWI Customer ID | int | Numeric ID used for reference to a customer within the WWI database | |||||
Numeric ID used for reference to a customer within the WWI database |
||||||||
3 | Customer | nvarchar(100) | Customer's full name (usually a trading name) | |||||
Customer's full name (usually a trading name) |
||||||||
4 | Bill To Customer | nvarchar(100) | Bill to customer's full name | |||||
Bill to customer's full name |
||||||||
5 | Category | nvarchar(50) | Customer's category | |||||
Customer's category |
||||||||
6 | Buying Group | nvarchar(50) | Customer's buying group | |||||
Customer's buying group |
||||||||
7 | Primary Contact | nvarchar(50) | Primary contact | |||||
Primary contact |
||||||||
8 | Postal Code | nvarchar(10) | Delivery postal code for the customer | |||||
Delivery postal code for the customer |
||||||||
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_Customer_Staging | Customer Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59