payment_checkpoint

This table is aggregated at the event level and contains all Business Events (such as Transactions)

Field Name	Type	Description	Example
checkpoint	date
game_id	int
user_id	string
player_id	string
is_converting	boolean	flag indicating whether it's the first time the player is making a payment (since we have history of it)	TRUE
first_paid	date	date of the player's first payment	2020-01-01
currency	string	currency code (e.g. GBP) in which the payment was made	GBP
amount	float	amount of the payment transaction, in local currency cents	199
amount_usd	float	amount of the payment transaction, in USD cents	247.34
cart_type	string	cart type, e.g. IAP	iap
item_type	string	item type bought, depending on the game, e.g. "LivesPack"	LivesPack
item_id	string	item id bought, depending on the game, e.g. "life_x48"	life_x48
transaction_num	int	number of the transaction	1
receipt_valid	boolean	whether the transaction receipt has been validated or not (note, in many cases the validation might happen later on, hence at the time of the event it might not be available)	FALSE
session_num	int	session number in which the payment occurred	5