Integration.Transaction_Staging
Documentation | WideWorldImportersDW |
Schema | Integration |
Name | Transaction_Staging |
Transaction staging table
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | Transaction Staging Key | bigint | Identity | DW key for a row in the Transaction fact | ||||
DW key for a row in the Transaction fact Identity |
||||||||
2 | Date Key | date | Transaction date | |||||
Transaction date |
||||||||
3 | Customer Key | int | Customer (if applicable) | |||||
Customer (if applicable) |
||||||||
4 | Bill To Customer Key | int | Bill to customer (if applicable) | |||||
Bill to 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 | Payment Method Key | int | Payment method (if applicable) | |||||
Payment method (if applicable) |
||||||||
8 | WWI Customer Transaction ID | int | Customer transaction ID in source system | |||||
Customer transaction ID in source system |
||||||||
9 | WWI Supplier Transaction ID | int | Supplier transaction ID in source system | |||||
Supplier transaction ID in source system |
||||||||
10 | WWI Invoice ID | int | Invoice ID in source system | |||||
Invoice ID in source system |
||||||||
11 | WWI Purchase Order ID | int | Purchase order ID in source system | |||||
Purchase order ID in source system |
||||||||
12 | Supplier Invoice Number | nvarchar(20) | Supplier invoice number (if applicable) | |||||
Supplier invoice number (if applicable) |
||||||||
13 | Total Excluding Tax | decimal(18, 2) | Total amount excluding tax | |||||
Total amount excluding tax |
||||||||
14 | Tax Amount | decimal(18, 2) | Total amount of tax | |||||
Total amount of tax |
||||||||
15 | Total Including Tax | decimal(18, 2) | Total amount including tax | |||||
Total amount including tax |
||||||||
16 | Outstanding Balance | decimal(18, 2) | Amount still outstanding for this transaction | |||||
Amount still outstanding for this transaction |
||||||||
17 | Is Finalized | bit | Has this transaction been finalized? | |||||
Has this transaction been finalized? |
||||||||
18 | WWI Customer ID | int | Customer ID in source system | |||||
Customer ID in source system |
||||||||
19 | WWI Bill To Customer ID | int | Bill to Customer ID in source system | |||||
Bill to Customer ID in source system |
||||||||
20 | WWI Supplier ID | int | Supplier ID in source system | |||||
Supplier ID in source system |
||||||||
21 | WWI Transaction Type ID | int | Transaction Type ID in source system | |||||
Transaction Type ID in source system |
||||||||
22 | WWI Payment Method ID | int | Payment method ID in source system | |||||
Payment method ID in source system |
||||||||
23 | 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_Transaction_Staging | Transaction Staging Key | Primary key (nonclustered) constraint. | |
Primary key (nonclustered) constraint. |
Exported: 2019-02-04 23:05, Last imported: 2018-08-10 09:59