Generated using SQL Data Dictionary demo version.
Parameter |
Data Type |
Default |
Is Output |
@OrdersToInvoice |
OrderIDList |
|
|
@PackedByPersonID |
int |
|
|
@InvoicedByPersonID |
int |
|
|
Uses:
- Sequence
- Table
- TransactionTypeID
- TransactionTypeName
- Table
- BillToCustomerID
- CustomerID
- DeliveryAddressLine1
- DeliveryAddressLine2
- DeliveryMethodID
- DeliveryRun
- PrimaryContactPersonID
- RunPosition
- Table
- AmountExcludingTax
- CustomerID
- FinalizationDate
- InvoiceID
- LastEditedBy
- LastEditedWhen
- OutstandingBalance
- PaymentMethodID
- TaxAmount
- TransactionAmount
- TransactionDate
- TransactionTypeID
- Table
- Description
- ExtendedPrice
- InvoiceID
- InvoiceLineID
- LastEditedBy
- LastEditedWhen
- LineProfit
- PackageTypeID
- Quantity
- StockItemID
- TaxAmount
- TaxRate
- UnitPrice
- Table
- AccountsPersonID
- BillToCustomerID
- Comments
- ContactPersonID
- CreditNoteReason
- CustomerID
- CustomerPurchaseOrderNumber
- DeliveryInstructions
- DeliveryMethodID
- DeliveryRun
- InternalComments
- InvoiceDate
- InvoiceID
- IsCreditNote
- LastEditedBy
- LastEditedWhen
- OrderID
- PackedByPersonID
- ReturnedDeliveryData
- RunPosition
- SalespersonPersonID
- TotalChillerItems
- TotalDryItems
- Table
- Description
- OrderID
- OrderLineID
- PackageTypeID
- PickedQuantity
- StockItemID
- TaxRate
- UnitPrice
- Table
- ContactPersonID
- CustomerID
- CustomerPurchaseOrderNumber
- OrderID
- PickingCompletedWhen
- SalespersonPersonID
- Table
- LastCostPrice
- LastEditedBy
- LastEditedWhen
- QuantityOnHand
- StockItemID
- Table
- IsChillerStock
- StockItemID
- Table
- CustomerID
- InvoiceID
- LastEditedBy
- LastEditedWhen
- PurchaseOrderID
- Quantity
- StockItemID
- SupplierID
- TransactionOccurredWhen
- TransactionTypeID