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

Measure	Description
bill_amount	The net transaction amount
bill_discount	The total discount on the bill amount
bill_id	A unique id generated for the bill internally by capillary system. It helps in differentiating one customer's bill with the other
central_gst	Central GST (Goods and Service Tax) amount levied on the bill. GST is charged at state level and central level.
integrated_gst	GST (Goods and Service Tax) amount levied by the central government in case of inter-state supplies and imports
payment_mode_amount	Amount paid through a specific payment mode
payment_mode_details_id	Unique id associated to a specific payment mode
quantity	Quantity of items purchased
state_gst	State GST (Goods and Service Tax) amount levied on the bill. GST is charged at state level and central level.
tax_amount	Total 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