The Payment mode is based on the fact payment_details_fact.

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