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 (charater): Customer- Card ID mask
  • LOC_BRAND_CD (numeric): Brand ID key
  • LOCATION_CD (numeric): Location ID key
  • POS_TP_CD (charater): Transaction classification (P – physical or O – Online)
  • SKU (numeric): Stock Keeping Unit
  • QTY (numeric): number of items sold (quantity)
  • NET_SLS_AMT (numeric): Net amount of sales (of the transaction)
  • GROSS_SLS_AMT (numeric): Gross amount of sales (of the transaction)

Data and Resources

Additional Info

Field Value
Last Updated November 15, 2021, 08:34 (UTC)
Created November 3, 2020, 08:48 (UTC)