Payment Mode Standard Export Template

The Payment Mode template is based on the payment_details fact

Allows you to export payment data, including the modes of payment used.
Granularity at bill id level.
Only a detailed breakdown of payments made, not a summarized one.
Exports the payment mode details for each transaction. You can export transaction-level data, including a breakdown 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.

Dimension Name	Description
Payment Mode Attribute	Gives the payment mode attributes such as the payment attribute name, value, and id.
User	User details such as user id, source, slab name, external id, fraud status, mobile, email, etc.
User Segments	Segment details of the customers such as valued customer, lapsed customer.
User Attributes	User attributes such as total visits, recent view.
Nps	Gives the Net Promoter Score (from 1 to 10) given by the customer.
Order Channel	Identifier for the order channel with which the order is placed, such as online or in-store.
Source	Identifier for the source of the bill, e.g., instore, e-comm, newsletter, campaigns.
Loyalty	Indicates the loyalty type of the customer.
Date	Date attributes of the payment.
Store Hierarchy (zone till)	Identifier for the store, till id.
Concept Hierarchy	Identifier for the concept.
Ou Hierarchy	Identifier for the organization unit.
Time	Time attributes of the payment.
Dim Bill Type Id	Captures the type of bill for which the payment has been made, e.g., Regular, Not interested.
Added On Date	Links to the date dimension.
Payment Mode	Includes the payment mode label and Id.
Bill Outlier	Outlier status of the bill.
Cashier Id	Identifier of the cashier.
Repeat	Shows if the customer has made previous purchases or if it's their first transaction.
Latest Updated Date	Latest date when the data is updated.
Latest Updated Time	Latest time when the data is updated.