The Points template is based on the fact Points
Lets you export the data of points related events such as points issual, and points deduction (redeemed, expired, and returned) including source details. You will get only the detailed break up of deducted points but not the the summarized one.
The template will have the filters redeemable and not applicable (deducted), applied by default.
Note: Points that are redeemed will be tagged to a transaction only if both the transaction and points redemption occurs with in the span of +/- 15 minutes.
|allocated_points||Number of points allocated|
|auto_update_time_pa||Date and time when the Points Awarded table is recently updated (Unix timestamp)|
|auto_update_time_pabp||Date and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp)|
|auto_update_time_pacp||Date and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp)|
|auto_update_time_pal||Date and time when the Points Awarded Lineitem table is recently updated (Unix timestamp)|
|auto_update_time_palp||Date and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp)|
|auto_update_time_pd||Date and time when the Points Deductions table is recently updated (Unix timestamp)|
|awarded_ref_id||The reference id of the awarded points that were deducted|
|bill_id||Loyalty log id or bill id for which the points are awarded or redeemed|
|bill_number||Bill number for which the points are awarded or redeemed|
|deducted_points||Number of redeemed, returned or expired points|
|event_id||Unique id of each event entry of the corresponding table|
awarded_date, awarded_expiry_date, awarded_points_promotion, awarded_zone_till, category, deduction_type, event_date, event_time, event_user, event_zone_till, expiry_date, expiry_time, latest_updated_date, latest_updated_time, old_category, points_promotion, points_event_type, points_awarded_type
Note: Awarded date and expiry date will be deprecated. Instead you can use event_date and awarded_expiry_date respectively.