-
Auditing process
Field (Type): Description id (integer): Audit Id wasproposedbyclerk (bolean): Clerk decides to audit a cart waspropesedbyaisystem (bolean): AI System recommended audit... -
User
Id (integer): User Id first_purchase (bolean): Is first purchases has been made last_login (date): Last login time stamp last_checkout (date): Last checkout time stamp -
Cart
Field (Type): Description id (integer): Cart id store_id (integer): Store id totalproducts (integer): Total number of items totalcost (decimal): Total cart cost... -
Cart Items
id (integer): Item id ean (integer): Item EAN Code eanlist (text): List of valid EANs for the item cartid (integer): Cart Id discr (text): Item Type (Product ou Coupon)... -
Customer DNA
All possibly relevant segmentations on customer level allowing the identification of different profiles. CUSTOMER_ACCOUNT_NR_MASK (charater): Id mask client-card SEGM_DSC_VALUE... -
Customer's Transactions
TIME_KEY (numeric): Transaction day (YYYYMMDD) Hora_HHMMSS (charater): Transaction time (HHMMSS) TRANSACTION_ID_MASK (charater): Transaction ID mask CUSTOMER_ACCOUNT_NR_MASK... -
SIGA
time_key (numeric): Transaction Date (YYYYMMDD) CUSTOMER_ACCOUNT_NR_MASK (charater): Id Mask do Client-Card location_cd (numeric): Id Key of the store checkin_id (numeric):... -
Product Catalogue
Schema for the following attributes: column_name json_level data_type description id root uuid product variation identifier name root text product... -
Tira Vez
Digital ‘kiosk’ available at the store entrance, in which customers can click for retrieving promotion coupons. It provides the date (and time) of entry at the store....