Show last authors
1 (% class="lead" %)
2 Loymax Smart Communications receives Loyalty Program customer data from [[DWH>>doc:Main.Usage.BI-analytics.Data_upload_from_DWH.WebHome]].
3
4 Data export occurs once per day.
5
6 The table below shows the data exported from DWH:
7
8 (% class="table-bordered" %)
9 |**Customer data**|(((
10 * LP Member internal identifier
11 * Full name
12 * First name
13 * Last name
14 * Second name
15 * Gender
16 * Email
17 * Phone number
18 * Push identifier or token for Push API
19 * Device type ID for Azure push notification integration
20 * Date of birth
21 * Residence details (country, city)
22 * Loyalty Program registration date
23 )))
24 |**Customer bonus account data**|(((
25 * Number of active bonus points
26 * Number of bonus points pending activation
27 * Number of bonus points pending expiration
28 * Next bonus expiration date
29 * Number of bonus points expiring on the next expiration date
30 )))
31 |**Customer loyalty card data**|(((
32 * Card name
33 * Card number
34 * Activation date
35 * Card status
36 * Card type
37 * Card category
38 )))
39 |**Customer receipt information**|(((
40 * Receipt number
41 * Receipt date
42 * Receipt status
43 * Number of items in the receipt
44 * Total receipt amount (including all discounts)
45 )))
46 |**Product categories**|(((
47 * Product category name
48 )))
49 |**Product**|(((
50 * Product name
51 * SKU
52 )))
53 |**Store**|(((
54 * Store name
55 )))
56
57 (% class="box" %)
58 (((
59 **See also:**
60
61 * [[Data transmission to Smart Communications from the Loymax system via RabbitMQ>>doc:Main.Usage.Service_interaction.Event_transmission.WebHome]]
62 )))
Created 2025/11/19 09:53
Last edited 2025/11/19 09:53