Integration.Purchase_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Purchase_Staging |
Purchase staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Purchase Staging Key | bigint | Identity | DW key for a row in the Purchase fact | ||||
DW key for a row in the Purchase fact Identity |
||||||||
2 | Date Key | date | Purchase order date | |||||
Purchase order date |
||||||||
3 | Supplier Key | int | Supplier for this purchase order | |||||
Supplier for this purchase order |
||||||||
4 | Stock Item Key | int | Stock item for this purchase order | |||||
Stock item for this purchase order |
||||||||
5 | WWI Purchase Order ID | int | Purchase order ID in source system | |||||
Purchase order ID in source system |
||||||||
6 | Ordered Outers | int | Quantity of outers (ordering packages) | |||||
Quantity of outers (ordering packages) |
||||||||
7 | Ordered Quantity | int | Quantity of inners (selling packages) | |||||
Quantity of inners (selling packages) |
||||||||
8 | Received Outers | int | Received outers (so far) | |||||
Received outers (so far) |
||||||||
9 | Package | nvarchar(50) | Package ordered | |||||
Package ordered |
||||||||
10 | Is Order Finalized | bit | Is this purchase order now finalized? | |||||
Is this purchase order now finalized? |
||||||||
11 | WWI Supplier ID | int | Supplier ID in source system | |||||
Supplier ID in source system |
||||||||
12 | WWI Stock Item ID | int | Stock Item ID in source system | |||||
Stock Item ID in source system |
||||||||
13 | 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_Purchase_Staging | Purchase Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59