Show TOC

 View Grouping: POS Transaction Information

 

The reuse views in this grouping obtain information about point-of-sale (POS) transactions.

Structure

This view grouping contains the following main reuse views:

  • POS log header (POSLogHeader)

    This view obtains transactional data from the transaction log header from the transaction log (TLOG).

  • POS log loyalty (POSLogLoyalty)

    This view obtains the loyalty information on transaction or item level from the TLOG.

  • POS Log Item Analytic (POSLogItemAnalytic)

    This view obtains the transaction item information from the TLOG.

Measures and Attributes

Some important measures and attributes are:

  • POS log header (POSLogHeader) view

    • The view provides general data, such as the order channel, store ID, transaction date, time, and number, department, operator ID, partner ID, transaction status, data status, and the customer number.

    • The view provides information about values, such as the transaction amount.

  • POS log loyalty (POSLogLoyalty) view

    • The view provides general data, such as the store ID, transaction date, time, status, and number, department, operator ID, partner ID, business type and location, customer number, loyalty number, customer card number, loyalty program, customer cardholder name, card type, and the card validity dates.

    • The provides information about values, such as the transaction turnover amount, value of the loyalty points awarded, eligible sales value, eligible quantity, value of the loyalty points redeemed, and the total value of the loyalty points.

  • POS Log Item Analytic (POSLogItemAnalytic) view

    • The view provides general data, such as the customer number, item category and subcategory, material number and group, promotion ID (if applicable), item ID, transaction date, time and status, partner ID, operator ID, transaction number, date and time, store ID, and the order channel.

    • The view provides information about values such as the quantity, sales amount, normal sales amount, cost amount, tax-included and tax-excluded amount, and the distributed discounts, taxes, and tender amounts.

Used Tables and Views

The views select data from the following main tables:

  • /POSDW/TLOGF (POS transaction log flat file)