Transactions Standard Export Template
The Transactions template is based on the fact Bill Lineitems.
This template lets you export transactions related details such as
- Bill and line-item level transactions
- Member and non-member transactions
- Store level transactions
- Audience list (irrespective of selected date-range)
- Transaction level points
- Transactions of user segments
- Transaction level custom fields, and extended fields
- Line item level custom fields and extended fields
- User level extended fields
Measures
| Column | Description |
|---|---|
| bill_discount | The total bill level discount provided for a transaction |
| bill_id | A unique id generated for the bill internally by capillary system. It helps in differentiating one customer's bill with the other |
| bill_number | A unique number for a transaction that is either auto-generated at the POS machine or provided manually. The uniqueness of the bill numbers depend on the configurations |
| converted_bill_id | The new bill id after conversion from non-loyal to loyal |
| conversion_date | Date when a customer is converted from non-member to member |
| initial_bill_value | The total bill amount excluding tax and discount |
| days_since_last_visit | The number of days since the customer's last transaction |
| group_size | The approximate count of the diners associated with a single order. This is specific to F&B |
| initial_bill_value | Describes the bill amount that is made by a customer before tax and discounting is applied |
| initial_line_item_value | The original price of the particular line-item before tax and discount |
| item_code | The unique code of the specific line-item |
| line_item_amount | Total amount after discount and tax is applied |
| line_item_discount | Discount given for the particular line-item |
| line_item_id | Unique id generated by the system for the specific line-item |
| org_level_visit_count | Total number of customers visited across all the stores of the org |
| org_level_visit_day_count | Total number of customers visited across all the stores of the org on that specific day |
| parent_line_item_id | Parent line item id for the specific child product |
| quantity | The quantity of a specific line-item purchased |
| rate | The price of a specific line-item, i.e., (item price*item quantity) |
| redeemed_points | Number of points redeemed for a specific transaction |
| visit_count | nth visit of a customer, its based on ranking. Rank is defined via transaction |
| visit_day_count | nth visit of a customer, its based on ranking. rank is defined via dates |
| year | Stands for year when billing is done |
| central_gst | GST tax that is levied by the central government |
| bill_amount | The net transaction amount |
| bill_discount | The total discount on the bill amount |
| additional_discount | Extra discount availed on a transaction, for example, discount on combo or bulk items. However, this is a extended field and takes the user input values. |
| auto_update_time_bill | Date and time (in Unix timestamp) when the bill level information is updated |
| auto_update_time_bill_extended_fields | Date and time (in Unix timestamp) when bill level extended fields are updated |
| auto_update_time_combo_details | Date and time (in Unix timestamp) when the bill combo details are updated |
| auto_update_time_lineitem | Date and time (in Unix timestamp) when the line-item information is updated |
| auto_update_time_lineitem_extended_fields | Date and time (in Unix timestamp) when line-item level extended fields are updated |
| auto_update_time_shipping | Date and time (in Unix timestamp) when order shipping details are updated |
| integrated_gst | GST levied by the central government for inter-state supplies and imports |
| lineitem_central_gst | Central government GST levied on that particular line item |
| lineitem_delivered_from | Store or location from which the line item will be shipped |
| lineitem_design_code | Design code of the current line item |
| lineitem_imei_number | Unique IMEI number of the line item (applicable for mobile phones) |
| lineitem_inseam | |
| lineitem_making_charge | Making charge for that particular line item (applicable for jewelry brand) |
| lineitem_metal_rate | Price charged only for metal based on the metal weight (applicable for jewelry brand) |
| lineitem_metal_weight | Metal weight of the line item excluding store weight |
| lineitem_serial_number | Unique serial number of the line-item |
| lineitem_service_tax_amount | Amount charged as service tax for that specific line item |
| lineitem_service_tax_percentage | Service tax levied on the specific line item |
| lineitem_size | Size of the line item |
| lineitem_state_gst | State GST levied on that particular line item |
| lineitem_stone_charge | Charge levied for stores in the item based on the stone weight (applicable for jewelry brand) |
| lineitem_stone_weight | Store weight in the line item (applicable for jewelry brand) |
| lineitem_supplier_code | Unique code of the vendor who supplies that specific item |
| lineitem_uuid | Universal Unique Identifier (UUID) of that particular line item |
| lineitem_vat_amount | Price of the line item |
| lineitem_vat_tax_percentage | Percentage of VAT levied on the line item |
| metal_purity | Purity of that particular metal (applicable for jewelry brands specific. Example 99% gold |
| notes | This is an additional field where some important notes on the line-item can be mentioned while capturing line-item level data, for example, some custom description of line-item |
| reason | - |
| ship_address_line1 | Shipping address specified in line 1 such as building name, door number, and street |
| ship_address_line2 | More details of the shipping address such as land mark, and area |
| ship_city | City to which the item needs to be shipped |
| ship_country | Country to which the order item needs to ship |
| ship_email | Email id of the recipient as in the shipping address |
| ship_first_name | First name of the recipient as in the shipping address |
| ship_last_name | Last name of the recipient as in the shipping address |
| ship_phone | Phone number associated to the customer's shipping shipping address |
| ship_state | State to which the order item need to ship |
| ship_zip | Postal code of the order item's shipping address |
| state_gst | State GST levied on the order item |
| tax_amount | Total tax levied at the bill level |
| total_quantity | Total quantity of all the line items of the current bill |
| total_unit_cost | Total price of the item including tax and other charges |
| outlier_status (of bill or lineitem) | Minimum acceptable bill amount or lineitem amount |
Updated 25 days ago