Fact & Dimension Tables in EI
Column Descriptionbill_discountThe total bill level discount provided for a transactionbill_idA unique id generated for the bill internally by capillary syst...
Wed, 22 May, 2019 at 3:16 PM
Column Descriptionbill_amountThe net bill amount after returning a purchase - Bill amount - the cost of return itembill_idThe unique id generated for a parti...
Wed, 22 May, 2019 at 3:26 PM
Points are a type of incentives issued to customers as a part of loyalty or promotion. This table consists of columns related to points. ColumnDescripti...
Tue, 21 May, 2019 at 11:06 AM
Column Descriptionaverage_spent_per_skuThis is average amount of money a customer spends on a single quantity of product purchased in its lifetime with the b...
Tue, 21 May, 2019 at 11:07 AM
Column DescriptionBill AmountThe amount of the bill which has been made by the target customerBill DiscountDenotes the discount availed by the target custome...
Wed, 22 May, 2019 at 5:07 PM
ColumnDescriptiondate_idUnique identifier of a date in the tabledateRepresents date in the format of DD-MM-YYYY. For example, 2018-01-01day_of_monthStands fo...
Tue, 21 May, 2019 at 11:09 AM
Column Descriptiontill_idDenotes point of sale identifiertillPoint of sale nametypeIf general the store is a genuine data contributing store, if admin the st...
Tue, 21 May, 2019 at 11:08 AM
Column Descriptionmessage_countSum of credits used for the individual communicationmsg_id This is the template id generated for each message template of a ca...
Thu, 23 May, 2019 at 11:34 AM
Column Descriptionis_recurringIf yes, the campaign belong to a repeat occurring campaign who audience group is auto generated by system from time to timename...
Tue, 21 May, 2019 at 11:08 AM
Column DescriptionidIt is the campaign delivery status that gets mapped to dim_campaign_delivery_status_id of the contact and response tables nsadmin_deliver...
Tue, 21 May, 2019 at 11:08 AM