Column
Description
Bill AmountThe amount of the bill which has been made by the target customer
Bill DiscountDenotes the discount availed by the target customer in the response bill
Bill IDStands for the identifier of the transaction made by target customer
Bill NumberStands for external bill number captured in our system generated by brand
Bill Amount
Amount of a specific bill
Item Code
Unique identifier of product
Line Item Amount
Denotes amount at product level
Line Item Discount
Discount availed on the line-item
Line Item ID
Unique internal reference id associated to a lineitem
Quantity
Quantity of line-item purchased
Redeemed Points
Number of points redeemed for the transaction
Total Link Click Count
Number of clicks on a link sent through a campaign
Msg ID
It is a template id that is generated when a message is sent.  If there are 5 types of messages sent in a campaign, it will have 5 different message ids
latest_updated_date
Date when a specific data are recently updated.
latest_updated_time
Time when a specific data are recently updated.
Bill Outlier
Outlier status of a bill
campaign_delivery_status
Delivery status of a campaign. Veneno Statuses:
DELAYED_DELIVERY, CLICKED,OPENED, SENT, DELIVERED, NOT_DELIVERED, FAILED, SENT_TO_NSADMIN, SENT_TO_CALL_TASK, BLOCKED, DND_BLOCKED, NDNC_BLOCKED, CREDIT_LIMIT_EXCEEDED, RELEVANCE_TIMEOUT , PARTIAL_RESPONSE,RATE_LIMIT_EXCEEDED, IN_GTW ,HARD_BOUNCED, SOFT_BOUNCED,TIMEOUT, RETRY_TIMEOUT , HANDLER_NOT_FOUND, OPENED_INTOUCH, CLICKED_INTOUCH, MARKED_SPAM, GTW_NOT_FOUND, ,ORG_DISABLED,MARKED_UNSUBSCRIBED, SUBSCRIPTION_SERVICE_ERROR, GTW_PROCESSED, MOBILE_WHITELISTED_BLOCKED
campaign_group
Name of the campaign group
campaign
Name of the campaign
campaign_message

campaign_schedule_date
Date when a campaign is  scheduled
campaign_schedule_time
Time when a campaign is schedules
communication_channel
Communication channel of campaign messages
communication_type
Type of communication. Values: Test, Control, Trans, Trans_EMF
email_open_date
Date when customer opened the email message
email_open_time
Time when customer opened the email message
Date
Date of transaction of a customer during campaign period
TimeTime of transaction of a customer during campaign period
User
Responder details
User Segments
If any user segments created
Store Hierarchy
Transacted store details
Concept Hierarchy
Transacted concept details
Product
Purchased item details
Product Attributes
Attributes of the item that are available
Line Item Outlier
Outlier status of Lineitem
Loyalty
Loyalty type of the customer - loyalty, non-loyalty
Repeat
Customer repeat status - customer visit > 1
Source
Customer registered source. Values: Instore, e-comm, newsletter, campaigns, NCA, wechat, martjack, webengage, facebook, tmall, others
unsubscription status
Unsubscription status of the user fpr a specific campaign