Transactions

The Transactions template is based on the fact Bill Lineitems.

This template lets you export transactions related details such as

  • Bill and line-item level transactions
  • Member and non-member transactions
  • Store level transactions
  • Audience list (irrespective of selected date-range)
  • Transaction level points
  • Transactions of user segments
  • Transaction level custom fields, and extended fields
  • Line item level custom fields and extended fields
  • User level extended fields

Measures

ColumnDescription
bill_discountThe total bill level discount provided for a transaction
bill_idA unique id generated for the bill internally by capillary system. It helps in differentiating one customer's bill with the other
bill_numberA unique number for a transaction that is either auto-generated at the POS machine or provided manually. The uniqueness of the bill numbers depend on the configurations
converted_bill_idThe new bill id after conversion from non-loyal to loyal
conversion_dateDate when a customer is converted from non-member to member
initial_bill_valueThe total bill amount excluding tax and discount
days_since_last_visitThe number of days since the customer's last transaction
group_sizeThe approximate count of the diners associated with a single order. This is specific to F&B
initial_bill_valueDescribes the bill amount that is made by a customer before tax and discounting is applied
initial_line_item_valueThe original price of the particular line-item before tax and discount
item_codeThe unique code of the specific line-item
line_item_amountTotal amount after discount and tax is applied
line_item_discountDiscount given for the particular line-item
line_item_idUnique id generated by the system for the specific line-item
org_level_visit_countTotal number of customers visited across all the stores of the org
org_level_visit_day_countTotal number of customers visited across all the stores of the org on that specific day
parent_line_item_idParent line item id for the specific child product
quantityThe quantity of a specific line-item purchased
rateThe price of a specific line-item, i.e., (item price*item quantity)
redeemed_pointsNumber of points redeemed for a specific transaction
visit_countnth visit of a customer, its based on ranking. Rank is defined via transaction
visit_day_countnth visit of a customer, its based on ranking. rank is defined via dates
yearStands for year when billing is done
central_gstGST tax that is levied by the central government
bill_amountThe net transaction amount
bill_discountThe total discount on the bill amount
additional_discountExtra discount availed on a transaction, for example, discount on combo or bulk items. However, this is a extended field and takes the user input values.
auto_update_time_billDate and time (in Unix timestamp) when the bill level information is updated
auto_update_time_bill_extended_fieldsDate and time (in Unix timestamp) when bill level extended fields are updated
auto_update_time_combo_detailsDate and time (in Unix timestamp) when the bill combo details are updated
auto_update_time_lineitemDate and time (in Unix timestamp) when the line-item information is updated
auto_update_time_lineitem_extended_fieldsDate and time (in Unix timestamp) when line-item level extended fields are updated
auto_update_time_shippingDate and time (in Unix timestamp) when order shipping details are updated
integrated_gstGST levied by the central government for inter-state supplies and imports
lineitem_central_gstCentral government GST levied on that particular line item
lineitem_delivered_fromStore or location from which the line item will be shipped
lineitem_design_codeDesign code of the current line item
lineitem_imei_numberUnique IMEI number of the line item (applicable for mobile phones)
lineitem_inseam
lineitem_making_chargeMaking charge for that particular line item (applicable for jewelry brand)
lineitem_metal_ratePrice charged only for metal based on the metal weight (applicable for jewelry brand)
lineitem_metal_weightMetal weight of the line item excluding store weight
lineitem_serial_numberUnique serial number of the line-item
lineitem_service_tax_amountAmount charged as service tax for that specific line item
lineitem_service_tax_percentageService tax levied on the specific line item
lineitem_sizeSize of the line item
lineitem_state_gstState GST levied on that particular line item
lineitem_stone_chargeCharge levied for stores in the item based on the stone weight (applicable for jewelry brand)
lineitem_stone_weightStore weight in the line item (applicable for jewelry brand)
lineitem_supplier_codeUnique code of the vendor who supplies that specific item
lineitem_uuidUniversal Unique Identifier (UUID) of that particular line item
lineitem_vat_amountPrice of the line item
lineitem_vat_tax_percentagePercentage of VAT levied on the line item
metal_purityPurity of that particular metal (applicable for jewelry brands specific. Example 99% gold
notesThis is an additional field where some important notes on the line-item can be mentioned while capturing line-item level data, for example, some custom description of line-item
reason-
ship_address_line1Shipping address specified in line 1 such as building name, door number, and street
ship_address_line2More details of the shipping address such as land mark, and area
ship_cityCity to which the item needs to be shipped
ship_countryCountry to which the order item needs to ship
ship_emailEmail id of the recipient as in the shipping address
ship_first_nameFirst name of the recipient as in the shipping address
ship_last_nameLast name of the recipient as in the shipping address
ship_phonePhone number associated to the customer's shipping shipping address
ship_stateState to which the order item need to ship
ship_zipPostal code of the order item's shipping address
state_gstState GST levied on the order item
tax_amountTotal tax levied at the bill level
total_quantityTotal quantity of all the line items of the current bill
total_unit_costTotal price of the item including tax and other charges
outlier_status (of bill or lineitem)Minimum acceptable bill amount or lineitem amount