Integration.Sale_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Sale_Staging |
Sale staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Sale Staging Key | bigint | Identity | DW key for a row in the Sale fact | ||||
DW key for a row in the Sale fact Identity |
||||||||
2 | City Key | int | City for this invoice | |||||
City for this invoice |
||||||||
3 | Customer Key | int | Customer for this invoice | |||||
Customer for this invoice |
||||||||
4 | Bill To Customer Key | int | Bill To Customer for this invoice | |||||
Bill To Customer for this invoice |
||||||||
5 | Stock Item Key | int | Stock item for this invoice | |||||
Stock item for this invoice |
||||||||
6 | Invoice Date Key | date | Invoice date for this invoice | |||||
Invoice date for this invoice |
||||||||
7 | Delivery Date Key | date | Date that these items were delivered | |||||
Date that these items were delivered |
||||||||
8 | Salesperson Key | int | Salesperson for this invoice | |||||
Salesperson for this invoice |
||||||||
9 | WWI Invoice ID | int | InvoiceID in source system | |||||
InvoiceID in source system |
||||||||
10 | 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) |
||||||||
11 | Package | nvarchar(50) | Type of package supplied | |||||
Type of package supplied |
||||||||
12 | Quantity | int | Quantity supplied | |||||
Quantity supplied |
||||||||
13 | Unit Price | decimal(18, 2) | Unit price charged | |||||
Unit price charged |
||||||||
14 | Tax Rate | decimal(18, 3) | Tax rate applied | |||||
Tax rate applied |
||||||||
15 | Total Excluding Tax | decimal(18, 2) | Total amount excluding tax | |||||
Total amount excluding tax |
||||||||
16 | Tax Amount | decimal(18, 2) | Total amount of tax | |||||
Total amount of tax |
||||||||
17 | Profit | decimal(18, 2) | Total amount of profit | |||||
Total amount of profit |
||||||||
18 | Total Including Tax | decimal(18, 2) | Total amount including tax | |||||
Total amount including tax |
||||||||
19 | Total Dry Items | int | Total number of dry items | |||||
Total number of dry items |
||||||||
20 | Total Chiller Items | int | Total number of chiller items | |||||
Total number of chiller items |
||||||||
21 | WWI City ID | int | City ID in source system | |||||
City ID in source system |
||||||||
22 | WWI Customer ID | int | Customer ID in source system | |||||
Customer ID in source system |
||||||||
23 | WWI Bill To Customer ID | int | Bill to Customer ID in source system | |||||
Bill to Customer ID in source system |
||||||||
24 | WWI Stock Item ID | int | Stock Item ID in source system | |||||
Stock Item ID in source system |
||||||||
25 | WWI Salesperson ID | int | Salesperson person ID in source system | |||||
Salesperson person ID in source system |
||||||||
26 | 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_Sale_Staging | Sale Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59