mobile loyalty and nav data mapping - ls retail for... · mobile loyalty and nav data mapping 8...
TRANSCRIPT
![Page 1: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/1.jpg)
© Copyright 2013, LS Retail ehf. All rights reserved. All trademarks belong to their respective holders
LS Retail
Mobile Loyalty Data Mapping
Mobile/NAV
![Page 2: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/2.jpg)
LS Retail ehf. Katrinartun 2, 105 Reykjavik, Iceland
Tel: +354 414 5700 Fax: +354 571 2728
Contents
1 Mobile Loyalty – Data Mapping ............................................................................................ 3
1.1 M_2MOBILE .................................................................................................................................... 3
1.2 M_TR2_MOBILE ............................................................................................................................ 4
1.3 MOB_2_NAV .................................................................................................................................... 4
2 M_2MOBILE .................................................................................................................................. 5
3 M_TR2_MOBILE ....................................................................................................................... 17
4 MOB_2_NAV – reverse replication .................................................................................... 20
![Page 3: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/3.jpg)
© Copyright 2013, LS Retail ehf. All rights reserved. All trademarks belong to their respective holders
1 Mobile Loyalty – Data Mapping
This document describes the table and field mapping for the data replication.
Apart from the web services three jobs are used in this solution:
M_2MOBILE and M_TR2_MOBILE, replicate data from NAV to the Mobile database. MOB_2_NAV replicates data from the Mobile db to NAV.
Following is a list of jobs and subjobs. The following chapters will also show field mapping of each table.
1.1 M_2MOBILE
Subjob ID NAV table name NAV table no Mobile db table name
M_ACCOUNT Member Account 99009001 Account
M_BARCODE Barcodes 99001451 Barcode
M_CARD Membership Cards 99009003 Card
M_CLUB Member Club 99009000 Club
M_CONTACT Member Contact 99009002 Contact
M_DEVICE Login Device 99009048 Device
M_DEVICE_USER Login Device User 99009049 DeviceUser
M_IMAGE Retail to Images 99009063 Image
M_IMAGE_LINK Retail Image Link 99009064 ImageLink
M_ITEM Item 27 Item
M_ITEM_CAT Item Category 5722 ItemCategory
M_ITEM_HTML Item Extended text 10001411 ItemHtml
M_ITEM_UOM Item Unit of Measure 5404 ItemUom
M_MEMBER_TR Member Offer Trigger 99009044 MemberTrigger
M_NOTIFICATION Member Notification 99009043 Notification
M_OFFER Published Offer 99009041 Offer
M_OFFER_LINE Published Offer Detail Line
99009042 OfferLine
M_PR_GROUP Product Group 5723 ProductGroup
M_PRICE Sales Price 7002 Price
M_SCHEME Member Scheme 99009024 Scheme
M_STORE Store 99001470 Store
M_STORE_OPENING_HOUR Mobile Store Opening Hours
99009062 StoreHours
M_TENDERTYPE Tender Type 99001462 TenderType
![Page 4: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/4.jpg)
Mobile Loyalty and NAV Data Mapping 4
M_UOM Unit of Measure 204 UnitOfMeasure
M_USER Member User Login 99009045 User
M_VALID_PERIOD Validation Period 99001481 ValidationPeriod
M_VARIANT Item Variant 5401 Variant
1.2 M_TR2_MOBILE
NAV table name NAV table no Mobile db table name
Transaction Header 99001472 Transaction
Trans. Sales Entry 99001473 TransactionSale
Trans. Payment Entry 99001474 TransactionPayment
1.3 MOB_2_NAV
Subjob ID Mobile db table name NAV table name NAV table no.
M_NOTIFICATION_LOG NotificationLog Member Notification Log
99009053
MEMBER_CONT_PROFILE ContactProfile Member AttrubuteValue
99009015
![Page 5: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/5.jpg)
Mobile Loyalty and NAV Data Mapping 5
2 M_2MOBILE
The first screenshot shows a typical subjob, then all subjobs are listed with screenshots of relevant Transfer Field List.
From Table Filters for the following subjobs
M_ACCOUNT Member Account 99009001 to Account 1221579390, Member Account to Mobile
![Page 6: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/6.jpg)
Mobile Loyalty and NAV Data Mapping 6
M_BARCODE Barcodes 99001451 to Barcode 978102525, Barcode to Mobile
M_CARD Membership Cards 99009003 to Card 162099618, Membership Cards to Mobile
![Page 7: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/7.jpg)
Mobile Loyalty and NAV Data Mapping 7
M_CLUB Member Club 99009000 to Club 1157579162, Member Club to Mobile
M_CONTACT Member Contact 99009002 to Contact 997578592, Member Contact to Mobile
M_DEVICE Login Device 99009048 to Device 283148054, Login Device
![Page 8: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/8.jpg)
Mobile Loyalty and NAV Data Mapping 8
M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User to Mobile
M_IMAGE Retail Image 99009063 to Images 861246123, Retail Image to Mobile
M_IMAGE_LINK Retail Image Link 99009064 to ImageLink 1293247662, Image Links to Mobile
![Page 9: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/9.jpg)
Mobile Loyalty and NAV Data Mapping 9
M_ITEM Item 27 to Item 818101955, Item to Mobile
M_ITEM_CAT Item Category 5722 to ItemCategory 1541580530, Item Category to Mobile
M_ITEM_HTML Item HTML 10001411 to ItemHtml
![Page 10: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/10.jpg)
Mobile Loyalty and NAV Data Mapping 10
M_ITEM_UOM Item Unit of Measure 5404 to ItemUom 914102297, Item Unit of Measure to Mobile
M_MEMBER_TR Member Offer Trigger 99009044 to MemberTrigger 580197117, Member Triggers to Mobile
![Page 11: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/11.jpg)
Mobile Loyalty and NAV Data Mapping 11
M_NOTIFICATION Member Notification 99009043 to Notification 1218103380, Notification to Mobile
M_OFFER Published Offer 99009041 to Offer 549576996, Published Offers to Mobile
![Page 12: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/12.jpg)
Mobile Loyalty and NAV Data Mapping 12
M_OFFER_LINE Published Offer Detail Line 99009042 to OfferLine 1429580131, Published Offer Line to Mobile
M_PR_GROUP Product Group 5723 to ProductGroup 1573580644, Product Group to Mobile
M_PRICE Sales Price 7002 to Price 1010102639, Prices to Mobile
M_SCHEME Member Scheme 99009024 to Scheme 245575913, Member Scheme to Mobile
![Page 13: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/13.jpg)
Mobile Loyalty and NAV Data Mapping 13
![Page 14: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/14.jpg)
Mobile Loyalty and NAV Data Mapping 14
M_STORE Store 99001470 to 1301579675 Store, Stores to Mobile
M_STORE_OPENING_HOUR Mobile Store Opening Hours 99009062 to StoreHours 1333579789, Store Opening Hours to Mobile
M_TENDERTYPE Tender Type 99001462 to TenderType 274100017, Tender type to Mobile
![Page 15: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/15.jpg)
Mobile Loyalty and NAV Data Mapping 15
M_UOM Unit of Measure 204 to UnitOfMeasure 850102069, Unit of Measure to Mobile
M_USER Member User Login 99009045 to User 370100359, Member Account User to Mobile
M_VALID_PERIOD Validation Period 99001481 to ValidationPeriod 99999, Validation Period to Mobile
![Page 16: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/16.jpg)
Mobile Loyalty and NAV Data Mapping 16
M_VARIANT Item Variant 5401 to Variant 866102126, Item variant to Mobile
![Page 17: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/17.jpg)
Mobile Loyalty and NAV Data Mapping 17
3 M_TR2_MOBILE
One subjob is defined for the transactions with two linked tables.
Subjob
Linked Tables
From Table Filters
![Page 18: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/18.jpg)
Mobile Loyalty and NAV Data Mapping 18
M_TRANSACTION Transaction Header 99001472 to Transaction 1890105774, Transaction Header to Mobile
Trans. Sales Entry 99001473 to 174623665 TransactionSale
Filters and Links (for Trans. Sales Entry)
![Page 19: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/19.jpg)
Mobile Loyalty and NAV Data Mapping 19
Trans. Payment Entry 99001474 to TransactionPayment 494624805
Filters and Links (for Trans. Payment Entry)
![Page 20: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/20.jpg)
Mobile Loyalty and NAV Data Mapping 20
4 MOB_2_NAV – reverse replication
This job replicated data from Mobile to NAV
From Table Filters for the following subjobs
M_NOTIFICATION_LOG NotificationLog 907150277 to Member Notification Log 99009053, Notification Log from Mobile
![Page 21: Mobile Loyalty and NAV Data Mapping - LS Retail for... · Mobile Loyalty and NAV Data Mapping 8 M_DEVICE_USER Login Device User 99009049 to DeviceUser 338100245, Login Device User](https://reader030.vdocuments.us/reader030/viewer/2022041104/5f0555ca7e708231d41274c1/html5/thumbnails/21.jpg)
Mobile Loyalty and NAV Data Mapping 21
MEMBER_CONT_PROFILE ContactProfile1044198770 to Member AttrubuteValue 99009015, Member contact Profile to Attribute Value
M_MEMBER_PROFILE - this subjob is not used.