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