Generated using SQL Data Dictionary demo version.
| Parameter |
Data Type |
Default |
Is Output |
| @LastCutoff |
datetime2 |
|
|
| @NewCutoff |
datetime2 |
|
|
Result:
| Column |
Data Type |
Nullable |
| Invoice Date Key |
date |
X |
| Delivery Date Key |
date |
X |
| WWI Invoice ID |
int |
|
| Description |
nvarchar(100) |
|
| Package |
nvarchar(50) |
|
| Quantity |
int |
|
| Unit Price |
decimal(18,2) |
X |
| Tax Rate |
decimal(18,3) |
|
| Total Excluding Tax |
decimal(19,2) |
X |
| Tax Amount |
decimal(18,2) |
|
| Profit |
decimal(18,2) |
|
| Total Including Tax |
decimal(18,2) |
|
| Total Dry Items |
int |
|
| Total Chiller Items |
int |
|
| WWI City ID |
int |
|
| WWI Customer ID |
int |
|
| WWI Bill To Customer ID |
int |
|
| WWI Stock Item ID |
int |
|
| WWI Saleperson ID |
int |
|
| Last Modified When |
datetime2 |
|
Uses:
- Table
- CustomerID
- DeliveryCityID
- Table
- Description
- ExtendedPrice
- InvoiceID
- InvoiceLineID
- LastEditedWhen
- LineProfit
- PackageTypeID
- Quantity
- StockItemID
- TaxAmount
- TaxRate
- UnitPrice
- Table
- BillToCustomerID
- ConfirmedDeliveryTime
- CustomerID
- InvoiceDate
- InvoiceID
- LastEditedWhen
- SalespersonPersonID
- Table
- PackageTypeID
- PackageTypeName
- Table
- IsChillerStock
- StockItemID