Column
Description
bill_amountThe net bill amount after returning a purchase - Bill amount - the cost of return item
bill_idThe unique id generated for a particular bill internally in the capillary system
bill_numberThe unique number of a particular 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 bill id issued to the customer for that particular transaction
issued_lineitem_idUnique line-item id issued to the customer for that particular line-item of a transaction
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
quantityQuantity of that particular line-item returned
ratePrice of the return item including offers and discounts or the actual cost of the item
yearThe year in which the transaction is returned or return is recorded
outlier_status
Minimum amount of lineitem to consider a bill valid