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