Loyalty and Promotion - loy_* - Lobyco Help center

The Loyalty and Promotion package contains data on how customers earn bonus and receive discounts through campaigns, challenges, games, and coupons.

Scope

This package includes:

Promotion campaign activities
Challenge and game participation and rewards
Bonus balances and movements
Issued coupons and redemption

It does not include internal calculation engines, detailed rule mechanics, operational import logs, or purely technical configuration data.

Key Principle

The Loyalty and Promotion package represents how value is created and distributed to customers in the form of bonus or discount.

Accounting — Account — `loy_accounting_account`

Definition

Property	Type	Description
Id	long	Identifier for each account (Primary Key)
IsActive	boolean	Indicates whether the account is active. If false, DeactivatedAt should be set
IsAllowedToSpend	boolean	Account-specific flag to enable spending. Effectively allows spending only if the AccountType also allows it
CreatedAt	timestamp	Timestamp when the account was created
AccountTypeId	int	Determines the rules for this account
ExternalId	string	External identifier for the account
DeactivatedAt	timestamp	Timestamp when the account was deactivated. Populated when IsActive becomes false

Sample data

Id	IsActive	IsAllowedToSpend	CreatedAt	AccountTypeId	ExternalId	DeactivatedAt
001	true	true	2026-01-12 09:00:00	1	041	NULL
002	false	false	2025-12-03 14:20:00	56	072	2026-02-18 11:45:00
003	true	false	2026-02-10 08:30:00	34	093	NULL

Accounting — Account Type — `loy_accounting_account_type`

Definition

Property	Type	Description
Id	int	Identifier for each account type (Primary Key)
IsAllowedToSpend	boolean	Indicates whether the account type allows spending
Description	string	Description of the account type
Name	string	Name of the account type
MaxBalance	decimal	Maximum balance for the account type
ConversionRate	decimal	Rate of conversion for the account type

Sample data

Id	IsAllowedToSpend	Description	Name	MaxBalance	ConversionRate
1	true	Default account type	Default	1000.25	1.00
2	false	Unspecified account type	NULL	0.00	1.00
3	true	Default account type	Default	1000.25	1.00

Accounting — Entry — `loy_accounting_entry`

Definition

Property	Type	Description
Id	int	Identifier for each accounting entry (Primary Key)
TransactionId	long	Identifier for the transaction associated with the accounting entry
Amount	decimal	Monetary amount of the accounting entry
AccountId	long	Identifier for the account related to the accounting entry
CreationDate	timestamp	Timestamp when the accounting entry was created
OperationId	string	External operation identifier associated with the entry
Type	string	Nature of the accounting action
PartitionType	string	Partition type required for balance calculation

Sample data

Id	TransactionId	Amount	AccountId	CreationDate	OperationId	Type	PartitionType
1	340	125.50	1001	2026-02-10 09:15:00	081	Capture	Base
2	560	-48.00	1002	2026-02-11 14:42:00	052	Reserve	Reserve
3	67	300.00	1003	2026-02-12 08:05:00	023	Cancel	Base

Accounting — Customer Account — `loy_accounting_customer_account`

Definition

Property	Type	Description
Id	long	Identifier for the customer-account association (Primary Key)
AccountId	long	Identifier of the account
CustomerId	string	Identifier for the customer associated with the account
CreationDate	timestamp	Timestamp when the account was associated with the customer
IsActive	boolean	Indicates whether the association is currently active. If false, DeleteDate should be set
DeleteDate	timestamp	Timestamp when the association was removed / deactivated. Populated when IsActive becomes false

Sample data

Id	AccountId	CustomerId	CreationDate	IsActive	DeleteDate
1001	1081	001	2026-01-15 10:00:00	true	NULL
1002	1032	045	2025-12-20 08:30:00	false	2026-02-05 14:10:00
1003	1053	023	2026-02-10 16:45:00	true	NULL

Accounting — Transaction — `loy_accounting_transaction`

Definition

Property	Type	Description
Id	long	Identifier for each transaction (Primary Key)
Type	string	Semantic type of the transaction
OperationId	string	Identifier for the operation, used to ensure idempotency
CreationDate	timestamp	Timestamp when the transaction was created
SettlementDate	timestamp	Timestamp when the transaction was successfully processed
Metadata	string	Additional context or details stored
ExpirationDate	timestamp	Timestamp when the transaction expires
State	string	Current state of the transaction

Sample data

Id	Type	OperationId	CreationDate	SettlementDate	Metadata	ExpirationDate	State
1001	Cash	061	2026-02-10 09:00:00	2026-02-10 09:05:00	”storeId”:“023”	2026-03-10 00:00:00	Waiting
1002	Credit	052	2026-02-11 14:30:00	2026-02-11 14:45:00	”description”:“voucher”	2026-03-11 00:00:00	Successful
1003	Cash	053	2026-02-12 08:20:00	2026-02-12 08:50:00	”customerId”:“049”	2026-03-12 00:00:00	Cancelled

Accounting — Transaction Type — `loy_accounting_transaction_type`

Definition

Property	Type	Description
Id	int	Identifier for each transaction type (Primary Key)
Name	string	Name of the transaction type
IsUsedForStatistics	boolean	Indicates if the transaction type is used for statistical purposes
IsUsedForAdjustment	boolean	Indicates if the transaction type is used for adjustments

Sample data

Id	Name	IsUsedForStatistics	IsUsedForAdjustment
1	Bonus	true	false
2	Card	false	true
3	ExternalCard	true	true

Bonus Calculation — Campaign — `loy_bonuscalculation_campaign`

Definition

Property	Type	Description
Id	int	Identifier for each bonus calculation campaign (Primary Key)
Name	string	Name of the bonus calculation campaign
StartDate	timestamp	Start date of the bonus calculation campaign
EndDate	timestamp	End date of the bonus calculation campaign
Audiences	string	Audiences targeted for the bonus calculation campaign
AudienceTargetMode	string	Mode used for targeting the audiences in the bonus calculation campaign
Type	string	Type of the bonus calculation campaign
Status	string	Status of the bonus calculation campaign

Sample data

Id	Name	StartDate	EndDate	Audiences	AudienceTargetMode	Type	Status
1	Spring Bonus	2026-03-01 00:00:00	2026-03-31 23:59:59	001,004	Inclusion	ProductBonusChain	Enabled
2	Loyalty Reward	2026-01-10 08:00:00	2026-02-10 23:59:59	003	Exclusion	ProductBonusStore	Disabled
3	Weekend Flash	2026-02-15 12:00:00	2026-02-18 23:59:59	002,005	Inclusion	ProductBonusChain	Draft

Challenge — Campaign Configuration — `loy_challenge_campaign_configuration`

Definition

Property	Type	Description
ActivityId	string	Id of the challenge (Primary Key)
ActivityName	string	Name of the challenge
RequiredProgress	int	Required progress to complete the challenge (OUT OF USE)
StartTime	timestamp	Time when customers can start accumulating progress for the challenge
EndTime	timestamp	Time when customers stop accumulating progress for the challenge
ActivationLimit	int	Maximum number of activations allowed for the challenge
Audiences	string	Comma-separated list of audiences
UnifiedCampaignId	string	Id of Turboflow challenge
DeletedAt	timestamp	Time when the challenge was deleted

Sample data

ActivityId	ActivityName	RequiredProgress	StartTime	EndTime	ActivationLimit	Audiences	UnifiedCampaignId	DeletedAt
001	Stella Artois	5	2026‑03‑01 00:00:00	2026‑03‑31 23:59:59	1	001,004	001	2026‑02‑25 12:30:00
002	Coca Cola Bottle	3	2026‑02‑15 08:00:00	2026‑04‑01 20:00:00	3	004,005	005	NULL
003	Nestle KitKat Bar	2	2026‑01‑10 00:00:00	2026‑06‑30 23:59:59	2	003	008	2026‑02‑01 12:30:00

Challenge — Lottery Winner — `loy_challenge_lottery_winner`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
ActivityId	string	Id of the challenge
CustomerId	string	Id of the customer who won the lottery
RewardId	string	Id of the reward won by the customer
RewardTitle	string	Title of the reward won by the customer
DrawDate	timestamp	Time when the lottery draw was done
RemoveDate	timestamp	Time when the customer was removed from a draw
RemoveReason	string	Reason for removing the customer from the lottery
CardId	string	Id of the customer card randomly selected as winning
IsBackup	boolean	Indicates whether the winner is primary or backup

Sample data

Id	ActivityId	CustomerId	RewardId	RewardTitle	DrawDate	RemoveDate	RemoveReason	CardId	IsBackup
1001	061	003	005	Free Coffee Voucher	2026-02-10 10:00:00	NULL	NULL	001	false
1002	032	045	022	Free KitKat Bar	2026-02-11 15:30:00	2026-02-12 12:00:00	Duplicate entry	017	true
1003	083	078	031	Gift Card €20	2026-02-12 09:45:00	NULL	NULL	009	false

Challenge — Challenge Reward — `loy_challenge_challengereward`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
ActivityId	string	Id of the challenge
RewardId	string	Id of the reward won by the customer

Sample data

Id	ActivityId	RewardId
1001	001	001
1005	002	002
1003	003	004

Challenge — Customer Card — `loy_challenge_customer_card`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
CardId	string	Id of the card
ActivityId	string	Id of the challenge
CustomerId	string	Id of the customer to whom the card belongs
ActivatedAt	timestamp	Time when the card was activated
ClosedAt	timestamp	Time when the card was closed and the reward was assigned
ExpiresAt	timestamp	Time when the card expires for the triggered challenge

Sample data

Id	CardId	ActivityId	CustomerId	ActivatedAt	ClosedAt	ExpiresAt
1001	001	001	001	2026‑03‑01 09:12:00	2026‑03‑05 10:00:00	2026‑04‑01 00:00:00
1002	002	002	002	2026‑02‑20 14:45:33	2026‑02‑28 16:22:11	2026‑03‑15 00:00:00
1003	003	003	003	2026‑01‑18 07:30:10	2026‑01‑25 12:40:55	2026‑02‑20 00:00:00

Challenge — Progress Operations — `loy_challenge_progress_operations`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
CardId	string	Id of the customer card
PurchaseId	string	Id of the purchase for which progress was granted
Progress	decimal(19, 2)	Amount of progress that was granted
StoreId	string	Id of the store where the purchase was made
PurchaseTime	timestamp	Time when the purchase was made

Sample data

Id	CardId	PurchaseId	Progress	StoreId	PurchaseTime
1001	001	001	12.50	001	2026‑03‑01 09:12:00
1002	006	009	7.00	004	2026‑02‑20 14:45:33
1003	003	002	3.75	003	2026‑01‑18 07:30:10

Challenge — Progress Rule — `loy_challenge_progress_rule` (NOT AVAILABLE IN THE CURRENT VERSION)

Definition

Property	Type	Description
Id	int	Id of the progress rule (Primary Key)
ActivityId	string	Id of the challenge
ProgressCalculationType	string	Type of progress calculation
RequiredProgress	int	Progress required to complete a single card of the challenge
UnitsOfMeasure	string	Unit of measure for the progress rule
PaymentTypes	string	Type of payment (e.g. Cash, Card)
MinimumPurchaseAmount	decimal(13,4)	Minimum amount for purchase to grant progress for Store Visit calculation type

Sample data

Id	ActivityId	ProgressCalculationType	RequiredProgress	UnitsOfMeasure	PaymentTypes	MinimumPurchaseAmount
1	001	ProductCount	5	Kilogram	Cash	NULL
2	002	StoreVisit	2	NULL	Cash	NULL
3	003	PurchaseAmount	50	NULL	Card	5.5000

Challenge — Reward — `loy_challenge_reward`

Definition

Property	Type	Description
Id	long	Id of the reward (Primary Key)
OfferId	string	Id of the offer for Coupon rewards
Title	string	Title of the coupon or manually inputted reward in the admin tool
Type	string	Type of reward
TotalRewards	long	Number of rewards that can be assigned to a customer
BonusAmount	decimal(10, 2)	Amount of bonus to be granted when the Bonus reward is won

Sample data

Id	OfferId	Title	Type	TotalRewards	BonusAmount
1001	001	Welcome Bonus	Coupon	100	10.00
1002	004	Holiday Coupon	Bonus	250	25.00
1003	002	Loyalty Reward	Coupon	50	5.00

Game — Attempt — `loy_game_attempt`

Definition

Property	Type	Description
AttemptId	string	Id of the attempt (Primary Key)
GameId	long	Id of the game
CustomerId	string	Id of the customer
IsWin	boolean	Indicates whether the attempt allows winning
StartDate	timestamp	Start time of the attempt
EndDate	timestamp	End time of the attempt
RewardId	string	Id of the reward
IsWinOnFinish	boolean	Indicates whether the attempt was a win on finish

Sample data

AttemptId	GameId	CustomerId	IsWin	StartDate	EndDate	RewardId	IsWinOnFinish
001	1001	001	true	2026‑03‑01 09:12:00	2026‑03‑01 09:15:00	002	true
002	1007	003	false	2026‑02‑20 14:45:33	2026‑02‑20 14:50:00	008	false
003	1003	009	true	2026‑01‑18 07:30:10	2026‑01‑18 07:35:00	004	true

Game — Configuration — `loy_game_configuration`

Definition

Property	Type	Description
StartDate	timestamp	Start time of the game
EndDate	timestamp	End time of the game
Name	string	Name of the game
Id	long	Id of the game (Primary Key)
Url	string	URL of the game
Audiences	string	List of audiences
UnifiedCampaignId	string	Id of Turboflow campaign

Sample data

StartDate	EndDate	Name	Id	Url	Audiences	UnifiedCampaignId
2026‑03‑01 00:00:00	2026‑03‑31 23:59:59	Summer Game	1001	https://game1.example	001,002	001
2026‑02‑15 08:00:00	2026‑04‑01 20:00:00	Winter Spin	1002	https://game2.example	010,022	002
2026‑01‑10 00:00:00	2026‑06‑30 23:59:59	Lucky Draw	1003	https://game3.example	005	003

Game — Customer Reward — `loy_game_customer_reward`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
RewardId	string	Id of the reward
CustomerId	string	Id of the customer
AssignedAt	timestamp	Time when the reward was assigned
ReservationValidTo	timestamp	Time until the reservation is valid
AttemptId	string	Id of the attempt

Sample data

Id	RewardId	CustomerId	AssignedAt	ReservationValidTo	AttemptId
1001	091	001	2026‑03‑01 09:12:00	2026‑03‑10 12:00:00	003
1002	022	004	2026‑02‑20 14:45:33	2026‑02‑28 09:45:00	002
1003	073	008	2026‑01‑18 07:30:10	2026‑02‑15 17:20:00	006

Game — Game Reward — `loy_game_gamereward`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
GameId	long	Id of the game
RewardId	string	Id of the reward

Sample data

Id	GameId	RewardId
1001	1001	061
1002	1023	067
1003	1079	058

Game — Lottery Winner — `loy_game_lottery_winner`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
GameId	long	Id of the game
CustomerId	string	Id of the winning customer
WinDate	timestamp	Time when the lottery was won
DrawDate	timestamp	Time of the draw
RemoveDate	timestamp	Time when the lottery winner was removed
RewardId	string	Id of the reward
AttemptId	string	Id of the attempt

Sample data

Id	GameId	CustomerId	WinDate	DrawDate	RemoveDate	RewardId	AttemptId
1001	1001	001	2026‑03‑01 09:15:00	2026‑03‑01 09:12:00	2026‑03‑10 12:00:00	001	011
1002	1072	033	2026‑02‑20 14:50:00	2026‑02‑20 14:45:33	2026‑02‑28 09:45:00	087	042
1003	1043	083	2026‑01‑18 07:35:00	2026‑01‑18 07:30:10	2026‑02‑15 17:20:00	093	063

Game — Reward — `loy_game_reward`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
ExternalId	string	External Id referencing the offer that assigns a Coupon reward
Title	string	Title of the reward
ValidFrom	timestamp	Start time when the Coupon reward is valid
ValidTo	timestamp	End time when the Coupon reward is valid
TotalRewards	long	Total quantity of rewards available
IsActive	boolean	Indicates whether the reward is currently active
BonusAmount	decimal(10,2)	Additional amount or bonus associated with the reward
Type	string	Type of reward

Sample data

Id	ExternalId	Title	ValidFrom	ValidTo	TotalRewards	IsActive	BonusAmount	Type
1001	071	Welcome Bonus	2026‑03‑01 00:00:00	2026‑03‑31 23:59:59	100	true	10.00	Bonus
1002	062	Holiday Coupon	2026‑02‑15 08:00:00	2026‑04‑01 20:00:00	250	false	25.00	Bonus
1003	033	Loyalty Reward	2026‑01‑10 00:00:00	2026‑06‑30 23:59:59	50	true	5.00	Coupon

Promotion — Coupon — `loy_promotion_coupon`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
CouponId	string	Id of the coupon used in the promotion
ReservationId	string	Id of the reservation associated with the coupon
AssignedAt	timestamp	Time when the coupon was assigned to a customer
DateToPickUp	timestamp	Time for picking up the coupon
CustomerId	string	Id of the customer who received the coupon
CampaignId	string	Id of the promotional campaign linked to the coupon
ActivatedAt	timestamp	Time when the coupon was activated for use
PosCouponId	string	Id of the coupon used in the point of sale system
DeletedAt	timestamp	Time when the coupon entry was deleted (OUT OF USE)
ReservationValidTo	timestamp	Time indicating the validity period of the reservation
VisibleFrom	timestamp	Time indicating when the coupon became visible for customers

Sample data

Id	CouponId	ReservationId	AssignedAt	DateToPickUp	CustomerId	CampaignId	ActivatedAt	PosCouponId	DeletedAt	ReservationValidTo	VisibleFrom
1001	001	081	2026‑03‑01 09:10:00	2026‑03‑05 10:00:00	045	081	2026‑03‑01 09:12:00	001	2026‑03‑10 12:00:00	2026‑03‑15 23:59:59	2026‑03‑01 00:00:00
1002	082	082	2026‑02‑20 14:40:00	2026‑02‑25 16:00:00	001	052	2026‑02‑20 14:45:33	052	NULL	2026‑03‑01 23:59:59	2026‑02‑15 08:00:00
1003	023	053	2026‑01‑18 07:25:00	2026‑01‑22 12:00:00	067	003	2026‑01‑18 07:30:10	023	2026‑02‑28 09:45:00	2026‑02‑20 23:59:59	2026‑01‑10 00:00:00

Promotion — Coupon Redemption — `loy_promotion_coupon_redemption`

Definition

Property	Type	Description
Id	int	Internal Id (Primary Key)
CouponId	string	Id of the coupon being redeemed
RedeemedAt	timestamp	Time when the coupon was redeemed
IdempotencyKey	string	Unique key to ensure idempotent processing of redemption
CanceledAt	timestamp	Time when the coupon redemption was cancelled

Sample data

Id	CouponId	RedeemedAt	IdempotencyKey	CanceledAt
1	041	2026‑03‑01 09:12:00	061	2026‑03‑10 12:00:00
2	032	2026‑02‑20 14:45:33	062	NULL
3	063	2026‑01‑18 07:30:10	083	2026‑02‑28 09:45:00

Promotion — Offer — `loy_promotion_offer`

Definition

Property	Type	Description
Id	int	Internal Id (Primary Key)
OfferId	string	Id of the offer
UnifiedCampaignId	string	Id of the Turboflow campaign
Name	string	Name of the offer - visible to admins
ValidFrom	timestamp	Time when the coupons for the offer become available to pick up in store
ValidTo	timestamp	Time when the coupons for the offer stop being available to pick up in store
Title	string	Title of the offer - visible to customers
OfferType	string	Type of offer
Audiences	string	Audiences targeted by the offer
FundedBy	string	Entity responsible for funding the offer
DeletedAt	timestamp	Time when the offer was deleted

Sample data

Id	OfferId	UnifiedCampaignId	Name	ValidFrom	ValidTo	Title	OfferType	Audiences	FundedBy	DeletedAt
1	041	021	Spring Promo	2026‑03‑01 00:00:00	2026‑03‑31 23:59:59	Spring Savings	game	004,005	Retailer	2026‑03‑10 12:00:00
2	052	062	Winter Deal	2026‑02‑15 08:00:00	2026‑04‑01 20:00:00	Winter Rewards	appCoupon	005,023	Retailer	NULL
3	023	093	Loyalty Bonus	2026‑01‑10 00:00:00	2026‑06‑30 23:59:59	Loyalty Gift	segmentedAppCoupon	003,099	Retailer	2026‑02‑28 09:45:00

Promotion — Personal Offer Coupon — `loy_promotion_personal_offer_coupon`

Definition

Property	Type	Description
Id	long	Internal Id (Primary Key)
CouponId	string	Id of the coupon
ReservationId	string	Id of the reservation
AssignedAt	timestamp	Time when the coupon was assigned
DateToPickUp	timestamp	Time until the coupon has to be picked up in the store
CustomerId	string	Id of the customer to whom the coupon is assigned
CampaignId	string	Id of the offer associated with the coupon
ActivatedAt	timestamp	Time when the coupon was activated
PosCouponId	string	External Id of the coupon used during redemption
DeletedAt	timestamp	Time when the coupon was deleted
VisibleFrom	timestamp	Time when the coupon becomes visible in the mobile app

Sample data

Id	CouponId	ReservationId	AssignedAt	DateToPickUp	CustomerId	CampaignId	ActivatedAt	PosCouponId	DeletedAt	VisibleFrom
1001	071	001	2026-02-10 09:00:00	2026-02-15 23:59:59	081	067	2026-02-12 10:00:00	061	NULL	2026-02-10 00:00:00
1002	091	044	2026-02-11 14:20:00	2026-02-16 20:00:00	005	078	2026-02-22 10:00:00	NULL	2026-02-25 16:30:00	2026-02-23 00:00:00
1003	033	088	2026-02-12 08:45:00	2026-02-18 18:00:00	067	053	2026-02-13 09:30:00	019	NULL	2026-02-12 00:00:00

Promotion — Discount Rule — `loy_promotion_discount_rule`

Definition

Property	Type	Description
Id	int	Internal Id (Primary Key) used as Foreign Key in Affiliation
OfferId	string	Id of the promotion offer, to which this rule belongs
Type	string	Type of applied discount

Sample data

Id	OfferId	Type
24	7e63a9ee-a0ff-426f-822a-c4266375b017	FixedPrice
18	fa72492a-b081-409d-a02f-b4088bff5acb	Percentage
23	7e63a9ee-a0ff-426f-822a-c4266375b017	Amount

Promotion — Affiliation — `loy_promotion_affiliation`

Definition

Property	Type	Description
Id	int	Internal Id (Primary Key)
Value	string	Actual product/category id
DiscountRuleId	int	Id of the rule, to which this affiliation belongs
AffiliationType	string	Indicates whether the discount rule targets a product or a whole product category
ApplicationType	string	Indicates whether the listed items are included or excluded from the discount calculation

Sample data

Id	Value	DiscountRuleId	AffiliationType	ApplicationType
13	352311881	13	Product	Include
169	MixAndMatch2	172	Category	Include
224	352311881	237	Product	Exclude

Last modified on August 13, 2026

⌘I

​Scope

​Key Principle

​Accounting — Account — loy_accounting_account

​Definition

​Sample data

​Accounting — Account Type — loy_accounting_account_type

​Definition

​Sample data

​Accounting — Entry — loy_accounting_entry

​Definition

​Sample data

​Accounting — Customer Account — loy_accounting_customer_account

​Definition

​Sample data

​Accounting — Transaction — loy_accounting_transaction

​Definition

​Sample data

​Accounting — Transaction Type — loy_accounting_transaction_type

​Definition

​Sample data

​Bonus Calculation — Campaign — loy_bonuscalculation_campaign

​Definition

​Sample data

​Challenge — Campaign Configuration — loy_challenge_campaign_configuration

​Definition

​Sample data

​Challenge — Lottery Winner — loy_challenge_lottery_winner

​Definition

​Sample data

​Challenge — Challenge Reward — loy_challenge_challengereward

​Definition

​Sample data

​Challenge — Customer Card — loy_challenge_customer_card

​Definition

​Sample data

​Challenge — Progress Operations — loy_challenge_progress_operations

​Definition

​Sample data

​Challenge — Progress Rule — loy_challenge_progress_rule (NOT AVAILABLE IN THE CURRENT VERSION)

​Definition

​Sample data

​Challenge — Reward — loy_challenge_reward

​Definition

​Sample data

​Game — Attempt — loy_game_attempt

​Definition

​Sample data

​Game — Configuration — loy_game_configuration

​Definition

​Sample data

​Game — Customer Reward — loy_game_customer_reward

​Definition

​Sample data

​Game — Game Reward — loy_game_gamereward

​Definition

​Sample data

​Game — Lottery Winner — loy_game_lottery_winner

​Definition

​Sample data

​Game — Reward — loy_game_reward

​Definition

​Sample data

​Promotion — Coupon — loy_promotion_coupon

​Definition

​Sample data

​Promotion — Coupon Redemption — loy_promotion_coupon_redemption

​Definition

​Sample data

​Promotion — Offer — loy_promotion_offer

​Definition

​Sample data

​Promotion — Personal Offer Coupon — loy_promotion_personal_offer_coupon

​Definition

​Sample data

​Promotion — Discount Rule — loy_promotion_discount_rule

​Definition

​Sample data

​Promotion — Affiliation — loy_promotion_affiliation

​Definition

​Sample data

Scope

Key Principle

Accounting — Account — `loy_accounting_account`

Definition

Sample data

Accounting — Account Type — `loy_accounting_account_type`

Definition

Sample data

Accounting — Entry — `loy_accounting_entry`

Definition

Sample data

Accounting — Customer Account — `loy_accounting_customer_account`

Definition

Sample data

Accounting — Transaction — `loy_accounting_transaction`

Definition

Sample data

Accounting — Transaction Type — `loy_accounting_transaction_type`

Definition

Sample data

Bonus Calculation — Campaign — `loy_bonuscalculation_campaign`

Definition

Sample data

Challenge — Campaign Configuration — `loy_challenge_campaign_configuration`

Definition

Sample data

Challenge — Lottery Winner — `loy_challenge_lottery_winner`

Definition

Sample data

Challenge — Challenge Reward — `loy_challenge_challengereward`

Definition

Sample data

Challenge — Customer Card — `loy_challenge_customer_card`

Definition

Sample data

Challenge — Progress Operations — `loy_challenge_progress_operations`

Definition

Sample data

Challenge — Progress Rule — `loy_challenge_progress_rule` (NOT AVAILABLE IN THE CURRENT VERSION)

Definition

Sample data

Challenge — Reward — `loy_challenge_reward`

Definition

Sample data

Game — Attempt — `loy_game_attempt`

Definition

Sample data

Game — Configuration — `loy_game_configuration`

Definition

Sample data

Game — Customer Reward — `loy_game_customer_reward`

Definition

Sample data

Game — Game Reward — `loy_game_gamereward`

Definition

Sample data

Game — Lottery Winner — `loy_game_lottery_winner`

Definition

Sample data

Game — Reward — `loy_game_reward`

Definition

Sample data

Promotion — Coupon — `loy_promotion_coupon`

Definition

Sample data

Promotion — Coupon Redemption — `loy_promotion_coupon_redemption`

Definition

Sample data

Promotion — Offer — `loy_promotion_offer`

Definition

Sample data

Promotion — Personal Offer Coupon — `loy_promotion_personal_offer_coupon`

Definition

Sample data

Promotion — Discount Rule — `loy_promotion_discount_rule`

Definition

Sample data

Promotion — Affiliation — `loy_promotion_affiliation`

Definition

Sample data