Return Transactions Standard Export Template

This template is based on the fact Return Bill Line Items

It contains details of transaction returns of any type. For example, partial return, full return, exchange of items (mixed transaction). However, it is required to specify parent bill id when returning an item. The parent bill id is the bill id of the actual transaction of the item. If the parent bill id is left blank, you will see the column blank in the export file.

Measures

MeasureDescription
auto_update_time_returned_billDate and time (in Unix timestamp) when the return bill level information is updated.
auto_update_time_returned_lineitemDate and time (in Unix timestamp) when the return bill line item information is updated.
bill_amountThe net bill amount after returning a purchase - Bill amount - the cost of return item.
bill_idThe unique id generated for a particular return bill internally in the capillary system.
bill_numberThe unique number of a particular return bill which is either generated at the POS machine or provided manually.
exchange_bill_idThe unique id generated internally in the Capillary system for the mixed transaction (item exchange).
issued_bill_idUnique parent bill id of that particular transaction.
issued_lineitem_idUnique parent line-item id for that particular line-item of a transaction.
parent_bill_numberActual transaction number of the return item used in case of exchange. This will be blank if the parent bill number is not mentioned during return.
item_codeUnique item code of the returned line item.
line_item_amountNet amount of the line item including discount and tax.
line_item_discountDiscount given for that particular line item.
line_item_idUnique internal reference id for the line item.
line_item_valuePrice of the line item excluding discount and tax.
notesAny specific note mentioned for a transaction return.
quantityQuantity of a line-item returned.
ratePurchase price of the return item - the actual cost after availing offers and discounts.
parent_bill_outlier_statusOutlier status of the parent bill id of the return bill.
parent_bill_lineitem_outlier_statusOutlier status of the bill line item.

Dimensions

Dimension NameDescription
Store HierarchyIdentifier for the store.
Concept HierarchyIdentifier for the concept.
Ou HierarchyIdentifier for the organization unit.
Returned TypeIdentifier for the return type.
ProductProduct details such as color, style, description, price, image url, item code, category, sub-category, item id, etc.
Product AttributesProduct attributes such as description, item Sku, and item Id.
DateDate attributes.
MembershipDetails such as membership type, and Id.
UserUser details such as user id, source, slab name, external id, fraud status, mobile, email, etc.
User SegmentsSegment details of the customers such as valued customer, lapsed customer.
User AttributesUser attributes such as total visits, recent view.
TimeTime attributes.
Parent Bill Lineitem Outlier StatusGives the outlier status of the parent bill line item.
Parent Bill Outlier StatusOutlier status of the parent bill.
Bill OutlierOutlier status of the bill.
Latest Updated DateLast updated date details.
Latest Updated TimeLast updated time details.