Description |
* Objective
** When capturing Transaction details from the POS for reporting on rebates, users need reporting to be able to reconcile the data.
* Requirements
** Add New Report/Search Grid for Checkout Transaction Journal
** Source Table (tblSTTranslogRebates)
** Ouput
*** Group on Parent (Transaction) with Children Rows (Tran Details)
*** Columns
**** Transaction
***** Store# + Description (intStoreId)
***** Checkout Date(intCheckoutId)
***** Tran # (intTermMsgSN)
***** Tran Type (strTranType)
***** Tran Date/Time (dtmDate)
***** Cashier Name (strCashier)
***** Total (dblTrValueTrTotWTax)
**** Detail
***** Dept # (intTrlDeptNumber)
***** Dept Desc (strTrlDept)
***** Network Code (strTrlNetwCode)
***** UPC (strTrlUPC)
***** Item Desc (strTrlDesc)
***** Quantity (dblTrlQty)
***** Price (dblTrlUnitPrice)
***** Line Total (dblTrlLineTot)
|