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.
|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|
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