Points are a type of incentives issued to customers as a part of loyalty or promotion. This table consists of columns related to points. 


ColumnDescription
latest_updated_dateRecent date of updation of when any of the table is updated (Max date):
  • Points Awarded
  • Points Awarded Bill Promotion
  • Points Awarded Customer Promotion
  • Points Awarded Lineitem
  • Points Awarded Lineitem Promotion
latest_updated_timeLatest updated Timestamp of the following tables which is updated recently
  • Points Awarded
  • Points Awarded Bill Promotion
  • Points Awarded Customer Promotion
  • Points Awarded Lineitem
  • Points Awarded Lineitem Promotion

awarded_dateDate when the points are awarded
awarded_expiry_dateDate of expiry of the awarded points 
awarded_points_promotionName of the associated points promotion 
awarded_zone_tillFor deducted points, it shows Tills from which those deducted points were awarded
categoryWhether points are redeemable or non-redeemable (tracker points)
deduction_typeType of points deduction - expired, redeemed, returned
DateEvent date of points awarded or deducted
TimeTimestamp of points awarded or deducted
Event UserLets you capture all customer level details except custom fields. For example, you can export registered till id, registered store name, extended field details and so on
User SegmentsSegment level data (custom segments)
Store Hierarchy Store details associated to each event
Concept HierarchyConcept details associated to each event
OrganizationCurrent organization id
points_awarded_typeType of awarded points based on the table it updates:
  • Points Awarded
  • Points Awarded Bill Promotion
  • Points Awarded Customer Promotion
  • Points Awarded Lineitem
  • Points Awarded Lineitem Promotion
points_event_typeType of the event - points issued or deducted
Allocated PointsNumber of points awarded - transaction or customer
Auto Update Time PaDate and time when the Points Awarded table is recently updated (Unix timestamp)
Auto Update Time PabpDate and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp)
Auto Update Time PacpDate and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp)
Auto Update Time PalDate and time when the Points Awarded Lineitem table is recently updated (Unix timestamp)
Auto Update Time PalpDate and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp)
Auto Update Time PdDate and time when the Points Deductions table is recently updated (Unix timestamp)
Awarded Ref IdThe reference id of the awarded points that were deducted
Bill IdLoyalty log id or bill id for which the points are awarded or redeemed 
Bill NumberBill number for which the points are awarded or redeemed
Deducted PointsNumber of redeemed, returned or expired points
Event IdUnique id of each event entry of the corresponding table