Integration.Order_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Order_Staging |
Order staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Order Staging Key | bigint | Identity | DW key for a row in the Order fact | ||||
DW key for a row in the Order fact Identity |
||||||||
2 | City Key | int | City for this order | |||||
City for this order |
||||||||
3 | Customer Key | int | Customer for this order | |||||
Customer for this order |
||||||||
4 | Stock Item Key | int | Stock item for this order | |||||
Stock item for this order |
||||||||
5 | Order Date Key | date | Order date for this order | |||||
Order date for this order |
||||||||
6 | Picked Date Key | date | Picked date for this order | |||||
Picked date for this order |
||||||||
7 | Salesperson Key | int | Salesperson for this order | |||||
Salesperson for this order |
||||||||
8 | Picker Key | int | Picker for this order | |||||
Picker for this order |
||||||||
9 | WWI Order ID | int | OrderID in source system | |||||
OrderID in source system |
||||||||
10 | WWI Backorder ID | int | BackorderID in source system | |||||
BackorderID in source system |
||||||||
11 | Description | nvarchar(100) | Description of the item supplied (Usually the stock item name but can be overridden) | |||||
Description of the item supplied (Usually the stock item name but can be overridden) |
||||||||
12 | Package | nvarchar(50) | Type of package to be supplied | |||||
Type of package to be supplied |
||||||||
13 | Quantity | int | Quantity to be supplied | |||||
Quantity to be supplied |
||||||||
14 | Unit Price | decimal(18, 2) | Unit price to be charged | |||||
Unit price to be charged |
||||||||
15 | Tax Rate | decimal(18, 3) | Tax rate to be applied | |||||
Tax rate to be applied |
||||||||
16 | Total Excluding Tax | decimal(18, 2) | Total amount excluding tax | |||||
Total amount excluding tax |
||||||||
17 | Tax Amount | decimal(18, 2) | Total amount of tax | |||||
Total amount of tax |
||||||||
18 | Total Including Tax | decimal(18, 2) | Total amount including tax | |||||
Total amount including tax |
||||||||
19 | Lineage Key | int | Lineage Key for the data load for this row | |||||
Lineage Key for the data load for this row |
||||||||
20 | WWI City ID | int | City ID in source system | |||||
City ID in source system |
||||||||
21 | WWI Customer ID | int | Customer ID in source system | |||||
Customer ID in source system |
||||||||
22 | WWI Stock Item ID | int | Stock Item ID in source system | |||||
Stock Item ID in source system |
||||||||
23 | WWI Salesperson ID | int | Salesperson person ID in source system | |||||
Salesperson person ID in source system |
||||||||
24 | WWI Picker ID | int | Picker person ID in source system | |||||
Picker person ID in source system |
||||||||
25 | Last Modified When | datetime2(7) | When this row was last modified | |||||
When this row was last modified |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Order_Staging | Order Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59