Generated using SQL Data Dictionary demo version.
Parameter |
Data Type |
Default |
Is Output |
@LastCutoff |
datetime2 |
|
|
@NewCutoff |
datetime2 |
|
|
Result:
Column |
Data Type |
Nullable |
Order Date Key |
date |
X |
Picked Date Key |
date |
X |
WWI Order ID |
int |
|
WWI Backorder ID |
int |
X |
Description |
nvarchar(100) |
|
Package |
nvarchar(50) |
|
Quantity |
int |
|
Unit Price |
decimal(18,2) |
X |
Tax Rate |
decimal(18,3) |
|
Total Excluding Tax |
decimal(29,2) |
X |
Tax Amount |
decimal(38,6) |
X |
Total Including Tax |
decimal(38,6) |
X |
WWI City ID |
int |
|
WWI Customer ID |
int |
|
WWI Stock Item ID |
int |
|
WWI Salesperson ID |
int |
|
WWI Picker ID |
int |
X |
Last Modified When |
datetime2 |
|
Uses:
- Table
- CustomerID
- DeliveryCityID
- Table
- Description
- LastEditedWhen
- OrderID
- PackageTypeID
- PickingCompletedWhen
- Quantity
- StockItemID
- TaxRate
- UnitPrice
- Table
- BackorderOrderID
- CustomerID
- LastEditedWhen
- OrderDate
- OrderID
- PickedByPersonID
- SalespersonPersonID
- Table
- PackageTypeID
- PackageTypeName