The Reward Type Sync is used to export current details of reward types that can be issued within the database.
Upon each execution, all reward types will be included with current information. Files can optionally be split into X records per file, which are then FTPed to the predetermined location. Files can be compressed and/or PGP encrypted prior to being transferred.
Note: This information is available as a PDF for portability. Reward Type Sync.pdf
Table of Contents
Reward Type Sync
| Name | Standard_Reward_Type_Sync_{Database #}_{Sync Id}_YYYYMMDDHHMMSS.txt Or Standard_Reward_Type_Sync_{Database #}_{Sync Id}_YYYYMMDDHHMMSS _{File Number}.txt [Max records per file option] |
| Format | Pipe delimited |
| Frequency | Daily |
| Source | Aimia |
| Contents | Details for all reward types in the database. |
| Field Name | Type | Notes |
|---|---|---|
| Internal Reward Type Id | Numeric(10) | |
| Reward Type Name | String(120) | |
| Reward Type External Reference | String(20) | |
| Reward Category Name | String(120) | |
| Reward Master Type | String(10) | Choice, Forced, Gift Card, Internal, Recurring, Variable |
Example Data
Internal Reward Type Id|Reward Type Name|Reward Type External Reference|Reward Category Name|Reward Master Type
12|$10 Forced Reward||Default Category|Forced
13|Unique $20 Dinner Reward|20_DINNER_REWARD|Default Category|Choice
14|Visa Gift Card|VISA|Default Category|Gift Card
