Data transmission from DWH to Smart Communications

Loymax Smart Communications receives Loyalty Program customer data from DWH.

Data export occurs once per day.

The table below shows the data exported from DWH:

Customer data
  • LP Member internal identifier
  • Full name
  • First name
  • Last name
  • Second name
  • Gender
  • Email
  • Phone number
  • Push identifier or token for Push API
  • Device type ID for Azure push notification integration
  • Date of birth
  • Residence details (country, city)
  • Loyalty Program registration date
Customer bonus account data
  • Number of active bonus points
  • Number of bonus points pending activation
  • Number of bonus points pending expiration
  • Next bonus expiration date
  • Number of bonus points expiring on the next expiration date
Customer loyalty card data
  • Card name
  • Card number
  • Activation date
  • Card status
  • Card type
  • Card category
Customer receipt information
  • Receipt number
  • Receipt date
  • Receipt status
  • Number of items in the receipt
  • Total receipt amount (including all discounts)
Product categories
  • Product category name
Product
  • Product name
  • SKU
Store
  • Store name

See also:

Created 2025/11/19 09:53
Last edited 2025/11/19 09:53