In this section, you can find the following information
Sale, Refund, and Void Event Mapping Table
In the table below, the mapping data for the following events is presented:
- SaleEvent (trans type in ["sale", "network sale"])
- RefundEvent (trans type in ["refund sale", "refund network sale"])
- VoidEvent (trans type in ["void"]) transactions
Sale, Refund, and Void Event Mapping Table
| Conexxus | Verifone proprietary | Description |
|---|---|---|
| JournalReport/SaleEvent*/EventSequenceID | Event code number | |
| JournalReport/SaleEvent/TrainingModeFlag | --- | |
| JournalReport/SaleEvent/CashierID | trans/trHeader/cashier{sysid} | Cashier code |
| JournalReport/SaleEvent/RegisterID | trans/trHeader/cashier{posNum} | Register code |
| JournalReport/SaleEvent/TillID | trans/trHeader/till | Till code |
| JournalReport/SaleEvent/OutsideSalesFlag | ||
| JournalReport/SaleEvent/TransactionID | trans/trHeader/trTickNum/trSeq | Transaction ID |
| JournalReport/SaleEvent/EventStartDate | DATE(trans/trHeader/date) | Start date for Event |
| JournalReport/SaleEvent/EventStartTime | TIME(trans/trHeader/date) | Start time for Event |
| JournalReport/SaleEvent/EventEndDate | DATE(trans/trHeader/date)+trans/ trHeader/duration | End date for Event |
| JournalReport/SaleEvent/EventEndTime | TIME(trans/trHeader/date)+trans/ trHeader/duration | End time for Event |
| JournalReport/SaleEvent/BusinessDate | Business date for event | |
| JournalReport/SaleEvent/ReceiptDate | --- | Receipt date for event |
| JournalReport/SaleEvent/ReceiptTime | --- | Receipt time for event |
| JournalReport/SaleEvent/OfflineFlag | ||
| JournalReport/SaleEvent/SuspendFlag | trans{type="suspended"}=true | Indicates the credit card authorization terminal was in a suspend mode at the time of the sale |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FeeLine/FeeID | trans/trLines/trLine/ trlFee/trlFeeNum | An ID for a fee applied to a transaction |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FeeLine/MerchandiseCode | trans/trLines/trLine/ trlFee/trlFeeDepNum | Fee Department code |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FeeLine/Description | trans/trLines/trLine/ trlFee/trlFeeName | Native language description for Fee |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FeeLine/FeeAmount | trans/trLines/trLine/ trlFee/trlFeeAmount | The amount of a fee applied to a transaction |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ ItemCode/POSCodeFormat | --- | Format for POSCode |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine /ItemCode/POSCode | trans/trLines/trLine/trlUPC | The scan code or PLU number used to access an item's information |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ ItemCode/POSCodeModifier | --- | Modifier for item |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine /Description | Trans/trLines/trLine/ trlDesc | Native language description for an item |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine /MerchandiseCode | trans/trLines/trLine/ TrlDept{number} | Item Department code |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/RegularSellPrice | trans/trLines/trLine/ trlUnitPrice | The non-promotional price of the transaction item/fuel grade. It can be negative. It is the price at which the item should normally be sold as modified by the provided qualifiers |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine /SalesQuantity | trans/trLines/trLine/trlQty | The quantity sold of the item/merchandise code sales, less refunds and voids |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine /SalesAmount | trans/trLines/trLine/ TrlLineTot | The currency amount before tax of the item/merchandise code sales, less refunds, promotions, discounts, and voids |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ PriceOverride/PriceOverridePrice | trans/trLines/trLine/ trlPrcOvrd | Item standard price before Price Override |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ Discount/DiscountAmount | trans/trLines/trLine/ trlDisc | Sum of all discounts associated with the item/merchandise code being reported. For fuel grade sales this sum is not reflected in FuelGradeSalesAmount. For PJR this is the amount of the discount associated with the individual item in the transaction or with the transaction as a whole |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ Discount/DiscountQuantity | trans/trLines/trLine/ trlQty | Total quantity of discount transactions associated with the DiscountAmount for the item/merchandise code/fuel grade being reported. This volume represents the volume of product sold with the discount. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ Promotion/PromotionID | trans/trLines/trLine/ trlMixMatches/ trlMatchLine/trlPromotionID | The identification of the promotion |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ Promotion/PromotionAmount | trans/trLines/trLine/ trlMixMatches/ trlMatchLine/trlPromoAmount | Sum of value of promotions associated with the item/merchandise code being reported. For PJR the amount of the promotion associated with the item in the transaction or with the total transaction |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/ Promotion/PromotionReason | trans/trLines/trLine/ trlMixMatches/ trlMatchLine/trlMatchName | The reason for the promo |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemLine/Promotion/ extension/PromotionQuantity | trans/trLines/trLine/ trlMixMatches/ trlMatchLine/trlMatchQuantity | Total quantity of items promoted |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemTax/TaxLevelID | trans/trLines/trLine/ trlTaxes/trlTax{sysid} | A pointer to the Tax Level Table. The values of the table specify the tax level being reported. It usually defines a tax rate or table |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/ItemTax/TaxableSalesAmount | trans/trLines/trLine/ trlTaxes/trlTax | TSum of the taxable value of all sales for this TaxLevelID net of discounts and promotional allowances and after refunds |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/MerchandiseCodeLine/ MerchandiseCode | trans/trLines/trLine {type}="dept"/TrlDept{number} | Department code |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/MerchandiseCodeLine/ Description | trans/trLines/trLine {type}="dept"/TrlDept | Native language description for a department |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/MerchandiseCodeLine/ RegularSellPrice | trans/trLines/trLine{type}="dept"/trlUnitPrice | The non-promotional price of the department. It can be negative. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/MerchandiseCodeLine/ SalesQuantity | trans/trLines/trLine {type}="dept"/trlQty | The quantity sold of the item/merchandise code sales, less refunds and voids |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/MerchandiseCodeLine/ SalesAmount | trans/trLines/trLine{type}="dept"/TrlLineTot | The currency amount before tax of the item/merchandise code sales, less refunds, promotions, discounts, and voids |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/FuelGradeID | trans/trLines/trLine/ trlFuel/fuelProd{NAXMLFuelGradeID} | FuelGradeID for the fuel grade |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/ServiceLevelCode | trans/trLines/trLine/ trlFuel/fuelSvcMode | A code denoting the type of service by which the customer purchases the fuel grade. This is typically used for self/full serve pricing. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/Description | trans/trLines/trLine/ trlFuel/fuelProd | Native language description for fuel grade |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/MerchandiseCode | trans/trLines/trLine/ TrlDept{number} | Department code for fuel |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/RegularSellPrice | trans/trLines/trLine/ trlFuel/basePrice | The non-promotional price of the fuel |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/SalesQuantity | trans/trLines/trLine/ trlFuel/fuelVolume | The volume sold of the fuel |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/SalesAmount | trans/trLines/trLine/ TrlLineTot | The currency amount before tax of the fuel sales, less refunds, promotions, discounts, and voids |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/DiscountAmount | trans/trLines/trLine/ trlPopDisc/trlpdAmount | The amount of the discount associated with the individual item/fuel in the transaction |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/FuelLine/DiscountVolume | trans/trLines/trLine/ trlPopDisc/trlpdVolume | The fuel volume, for which discount is applied |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/Loyalty/ AccountInfo/AccountID | trans/trLoyalty/ trloAccount | Loyalty account |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/Loyalty/ LoyaltyProgramName | trans/trLines/ trLine/trloPPGDisc{programID} trans/ trLines/trLine/ trloLnItemDisc{programID} | Loyalty Server alias |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/Loyalty/DiscountAmount | trans/trLines/trLine/ trloPPGDisc/PPGTotDisc trans/trLines/trLine/ trloLnItemDisc/discAmt | Loyalty discount |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/Loyalty/LoyaltyQuantity | trans/trLines/trLine/ trloPPGDisc/PPGVol trans/trLines/trLine/ trloLnItemDisc/qty | fuel volume/item quantity for which Loyalty discount is applied |
| JournalReport/SaleEvent /TransactionDetailGroup/ TransactionLine/TransactionTax/TaxLevelID | trValue/trTax/taxAmts/ taxAmt{sysid} | A pointer to the Tax Level Table. The values of the table specify the tax level being reported. It usually defines a tax rate or table |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/TaxRate | trValue/trTax/taxAmts/ taxRate | Tax Rate in percents |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxReceiptDescription | trValue/trTax/taxAmts/ taxAmt{cat} | Tax name on receipt |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxableSalesAmount | trValue/trTax/taxAmts/ taxAmt | TSum of the taxable value of all sales for this TaxLevelID net of discounts and promotional allowances and after refunds |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxCollectedAmount | trValue/trTax/taxAmts/ taxNet | Collected tax for TaxLevelID |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxForgivenSalesAmount | trValue/trTax/taxAmts/ taxForgivenAgainst | Sum of the sales for this TaxLevelID sold on a tax forgiven basis net of discounts and promotional allowances and before refunds. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxForgivenAmount | Retrieving data. Wait a few seconds and try to cut or copy again. | The amount of tax that was not collected because the tax was forgiven. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TransactionTax/ TaxForgivenReason | Reason for Tax Forgiving, usually FOOD STAMP | |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TenderInfo/ Tender/TenderCode | trPaylines/trPayline/ trpPaycode | The identifier for a Tender |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TenderInfo/ Tender/TenderSubCode | TrPaylines/trPayline/ trpPaycode{mop} | A pointer to a value in the Tender Type Sub table. The values indicate the sub-categories of the type of tender that were used to finalize item/merchandise code sales. |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TenderInfo/TenderAmount | TrPaylines/trPayline/trpAmt | Sum of Tender |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TenderInfo/ChangeFlag | IF trPaylines/trPayline/ trpPaycode=Change THEN ChangeFlag=yes | indicates change may be given |
| JournalReport/SaleEvent/TransactionDetailGroup/ TransactionLine/TenderInfo/AccountInfo/AccountID | trPaylines/trPayline/ trpCardInfo/trpcAccount | The identification of the account related to the tender type |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalGrossAmount | trans/trValue/trTotNoTax | The gross amount of the transaction before applying transaction level discounts, promotions, taxes, etc., but net of item level discounts, promotions, etc. |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalNetAmount | trans/trValue/trTotNoTax | The net amount of the transaction after applying transaction level discounts, promotions, taxes, etc. |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalTaxSalesAmount | --- | |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalTaxNetAmount | trans/trValue/trTotTax | The sum of all tax that was applied to items being sold in the transaction |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalGrandAmount | trans/trValue/trSTotalizer | The total amount of the transaction after applying transaction level discounts, promotions, taxes, etc |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalTaxForgivenAmount | SUM(trValue/trTax/ taxAmts/taxForgiven) | The sum of all tax that was forgiven in the transaction |
| JournalReport/SaleEvent/TransactionSummary/ TransactionTotalFeeNetAmount | SUM(trans/trLines/trLine/ trlFee/trlFeeAmount) | The net of fees in the transaction |
* In this and all other rows in the table, the SaleEvent structure is also applicable to the RefundEvent and VoiceEvent.
