Payment Mode Standard Export Template

The Payment Mode template is based on the fact payment_details fact

  • With this template you can export the data of payment made and the modes of Payment made
  • Granularity is at bill id level.
  • You will get only the detailed break up of payment made but not the summarized one.
  • This template lets you export the payment mode details of a transaction.
  • You can export transaction level dump with a split of payment modes.
  • A bill can be paid through cash, credit card, gift card, points or coupon redemption or some other means either fully or partially.

Measures

MeasureDescription
bill_amountThe net transaction amount
bill_discountThe total discount on the bill amount
bill_idA unique id generated for the bill internally by capillary system. It helps in differentiating one customer's bill with the other
central_gstCentral GST (Goods and Service Tax) amount levied on the bill. GST is charged at state level and central level.
integrated_gstGST (Goods and Service Tax) amount levied by the central government in case of inter-state supplies and imports
payment_mode_amountAmount paid through a specific payment mode
payment_mode_details_idUnique id associated to a specific payment mode
quantityQuantity of items purchased
state_gstState GST (Goods and Service Tax) amount levied on the bill. GST is charged at state level and central level.
tax_amountTotal tax levied at the bill level

Dimensions

event_time, event_user, event_zone_till, latest_updated_date, latest_updated_time, loyalty_type, nps, org_level_repeat_bill_status, payment_mode, repeat_status, source_type, added_on_date, bill_outlier_status, bill_type, cashier, event_date