Points are a type of incentives issued to customers as a part of loyalty or promotion. This table consists of columns related to points.
Column Name | Field Name | Description |
Latest Updated Date | latest_updated_date | Recent date of updation of when any of the tables are updated (Max date):
|
Latest Updated Time | latest_updated_time | Latest updated Timestamp of the following tables which is updated recently
|
Awarded Date | awarded_date | Date when the points are awarded |
Awarded Expiry Date | awarded_expiry_date | Date of expiry of the awarded points |
Awarded Points Promotion | awarded_points_promotion | Name of the associated points promotion |
Awarded Program | awarded_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 Till | awarded_zone_till | For deducted points, it shows Tills from which those deducted points were awarded |
Category | category | Whether points are redeemable or non-redeemable (tracker points) |
Deduction Type | deduction_type | Type of points deduction - expired, redeemed, returned |
Event Date | event_date | Event date of points awarded or deducted |
Event Program | event_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 Time | event_time | Timestamp of points awarded or deducted. |
Event User | event_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 Segments | user_segments | Segment level data (custom segments) |
Store Hierarchy | store_hierarchy | Store details associated to each event |
Concept Hierarchy | concept_hierarchy | Concept details associated to each event |
Organization | organization | Current organization id |
Points Awarded Type | points_awarded_type | Type of awarded points based on the table it updates:
|
Points Event Type | points_event_type | Type of the event - points issued or deducted |
Allocated Points | allocated_points | Number of points awarded - transaction or customer |
Auto Update Time Pa | auto_update_time_pa | Date and time when the Points Awarded table is recently updated (Unix timestamp) |
Auto Update Time Pabp | auto_update_time_pabp | Date and time when the Points Awarded Bill Promotion table is recently updated (Unix timestamp) |
Auto Update Time Pacp | auto_update_time_pacp | Date and time when the Points Awarded Customer Promotion table is recently updated (Unix timestamp) |
Auto Update Time Pal | auto_update_time_pal | Date and time when the Points Awarded Lineitem table is recently updated (Unix timestamp) |
Auto Update Time Palp | auto_update_time_palp | Date and time when the Points Awarded Lineitem Promotion table is recently updated (Unix timestamp) |
Auto Update Time Pd | auto_update_time_pd | Date and time when the Points Deductions table is recently updated (Unix timestamp) |
Awarded Ref ID | awarded_ref_ID | The reference id of the awarded points that were deducted |
Bill ID | bill_ID | Loyalty log id or bill id for which the points are awarded or redeemed |
Bill Number | bill_number | 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. |
Deducted Points | deducted_points | Number of redeemed, returned, or expired points |
Deduction Currency Value | deduction_currency_value | Holds the currency value of the deducted points. |
Deduction Summary ID | deduction_summary_ID | Deducted points related to a single event are grouped using a deduction summary ID for analysis. |
Event Id | event_ID | Unique id of each event entry of the corresponding table |
Redemption Program | redemption_program | Name of the program that is related to the redemption event. For some scenarios, the redemption program and event program can differ during point deduction. |
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 redemption bill number then the system shows 'Not Captured'. |