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
Updated 21 days ago