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 | Description |
| latest_updated_date | Recent date of updation of when any of the table is updated (Max date):
|
| latest_updated_time | Latest updated Timestamp of the following tables which is updated recently
|
| awarded_date | Date when the points are awarded |
| awarded_expiry_date | Date of expiry of the awarded points |
| awarded_points_promotion | Name of the associated points promotion |
| awarded_zone_till | For deducted points, it shows Tills from which those deducted points were awarded |
| category | Whether points are redeemable or non-redeemable (tracker points) |
| deduction_type | Type of points deduction - expired, redeemed, returned |
| Date | Event date of points awarded or deducted |
| Time | Timestamp of points awarded or deducted |
| 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 | Segment level data (custom segments) |
| Store Hierarchy | Store details associated to each event |
| Concept Hierarchy | Concept details associated to each event |
| Organization | Current organization id |
| points_awarded_type | Type of awarded points based on the table it updates:
|
| points_event_type | Type of the event - points issued or deducted |
| Allocated Points | Number of points awarded - transaction or customer |
| 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 |