Return Transactions

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

Measure	Description
auto_update_time_returned_bill	Date and time (in Unix timestamp) when the return bill level information is updated
auto_update_time_returned_lineitem	Date and time (in Unix timestamp) when the return bill line item information is updated
bill_amount	The net bill amount after returning a purchase - Bill amount - the cost of return item
bill_id	The unique id generated for a particular return bill internally in the capillary system
bill_number	The unique number of a particular return bill which is either generated at the POS machine or provided manually
exchange_bill_id	The unique id generated internally in the Capillary system for the mixed transaction (item exchange)
issued_bill_id	Unique parent bill id of that particular transaction
issued_lineitem_id	Unique parent line-item id for that particular line-item of a transaction
parent_bill_number	Actual 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_code	Unique item code of the returned line item
line_item_amount	Net amount of the line item including discount and tax
line_item_discount	Discount given for that particular line item
line_item_id	Unique internal reference id for the line item
line_item_value	Price of the line item excluding discount and tax
notes	Any specific note mentioned for a transaction return
quantity	Quantity of a line-item returned
rate	Purchase price of the return item - the actual cost after availing offers and discounts
parent_bill_outlier_status	Outlier status of the parent bill id of the return bill
parent_bill_lineitem_outlier_status	Outlier status of the bill line item

Dimensions

bill_outlier_status, event_date, event_time, event_user, event_zone_till, item, latest_updated_date, latest_updated_time, parent_bill_outlier_status, parent_line_item_outlier_status, returned_type, membership