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


Column NameField NameDescription
Bill ID
bill_ID
Loyalty log id or bill id for which the points are awarded or redeemed.
Bill Numberbill_numberThe system-generated bill number for which the points are awarded or redeemed. When the redemption bill number is not captured, the bill number field identifies the approximate bill for the redemption event. Here, the system captures the +/- 15mins of transaction details from the points redemption time and considers the closest transaction event time.
Redemption Bill ID
redemption_bill_ID
Loyalty log ID or bill ID for which the points are redeemed. The billing ID is generated by Capillary's system.
Redemption Bill Number
redeemption_bill_number
Bill number for which the points are redeemed. The bill number is passed from the source data. If the source data doesn't have any value for the redemption bill number then the system shows 'Not Captured'.
Latest Updated Datelatest_updated_date
Recent date of updation of when any of the tables are updated (Max date):
  • Points Awarded
  • Points Awarded Bill Promotion
  • Points Awarded Customer Promotion
  • Points Awarded Lineitem
  • Points Awarded Lineitem Promotion
Latest Updated Timelatest_updated_time
Latest 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 Dateawarded_date
Date when the points are awarded
Awarded Expiry Dateawarded_expiry_date
Date of expiry of the awarded points 
Awarded Points Promotionawarded_points_promotion
Name of the associated points promotion 
Awarded Programawarded_program
Name of the program that awarded the points. The awarded program and event program is the same at the time of the point issue. 
Awarded Zone Tillawarded_zone_till
For deducted points, it shows Tills from which those deducted points were awarded
Categorycategory
Whether points are redeemable or non-redeemable (tracker points)
Deduction Typededuction_type
Type of points deduction - expired, redeemed, returned
Event Dateevent_date
Event date of points awarded or deducted
Event Programevent_program
Name of the program that is associated with events such as point issue, point deduction, point expiry, and more. The event program and awarded program is the same at the time of the point issue. But it can differ during point redemption.
Event Timeevent_time
Timestamp of points awarded or deducted.
Event Userevent_user
Lets 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 Segmentsuser_segments
Segment level data (custom segments)
Store Hierarchystore_hierarchy
Store details associated to each event
Concept Hierarchyconcept_hierarchy
Concept details associated to each event
Organizationorganization
Current organization id
Points Awarded Typepoints_awarded_type
Type 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 Typepoints_event_type
Type of the event - points issued or deducted
Allocated Pointsallocated_points
Number of points awarded - transaction or customer
Auto Update Time Paauto_update_time_pa
Date and time when the Points Awarded table is recently updated (Unix timestamp)
Auto Update Time Pabpauto_update_time_pabp
Date and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp)
Auto Update Time Pacpauto_update_time_pacp
Date and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp)
Auto Update Time Palauto_update_time_pal
Date and time when the Points Awarded Lineitem table is recently updated (Unix timestamp)
Auto Update Time Palpauto_update_time_palp
Date and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp)
Auto Update Time Pdauto_update_time_pd
Date and time when the Points Deductions table is recently updated (Unix timestamp)
Awarded Ref IDawarded_ref_IDThe reference id of the awarded points that were deducted
Deducted Pointsdeducted_pointsNumber of redeemed, returned, or expired points
Deduction Currency Value
deduction_currency_value
Holds the currency value of the deducted points.
Deduction Summary IDdeduction_summary_ID
Deducted points related to a single event are grouped using a deduction summary ID for analysis.
Event Idevent_IDUnique id of each event entry of the corresponding table
Redemption Programredemption_programName of the program that is related to the redemption event. For some scenarios, the redemption program and event program can differ during point deduction.