Integration.Movement_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Movement_Staging |
Movement staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Movement Staging Key | bigint | Identity | DW key for a row in the Movement fact | ||||
DW key for a row in the Movement fact Identity |
||||||||
2 | Date Key | date | Transaction date | |||||
Transaction date |
||||||||
3 | Stock Item Key | int | Stock item for this purchase order | |||||
Stock item for this purchase order |
||||||||
4 | Customer Key | int | Customer (if applicable) | |||||
Customer (if applicable) |
||||||||
5 | Supplier Key | int | Supplier (if applicable) | |||||
Supplier (if applicable) |
||||||||
6 | Transaction Type Key | int | Type of transaction | |||||
Type of transaction |
||||||||
7 | WWI Stock Item Transaction ID | int | Stock item transaction ID in source system | |||||
Stock item transaction ID in source system |
||||||||
8 | WWI Invoice ID | int | Invoice ID in source system | |||||
Invoice ID in source system |
||||||||
9 | WWI Purchase Order ID | int | Purchase order ID in source system | |||||
Purchase order ID in source system |
||||||||
10 | Quantity | int | Quantity of stock movement (positive is incoming stock, negative is outgoing) | |||||
Quantity of stock movement (positive is incoming stock, negative is outgoing) |
||||||||
11 | WWI Stock Item ID | int | Stock Item ID in source system | |||||
Stock Item ID in source system |
||||||||
12 | WWI Customer ID | int | Customer ID in source system | |||||
Customer ID in source system |
||||||||
13 | WWI Supplier ID | int | Supplier ID in source system | |||||
Supplier ID in source system |
||||||||
14 | WWI Transaction Type ID | int | Transaction Type ID in source system | |||||
Transaction Type ID in source system |
||||||||
15 | Last Modifed When | datetime2(7) | When this row was last modified | |||||
When this row was last modified |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_Integration_Movement_Staging | Movement Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59