# Recharge: Billing History ## Description * Each record represents an order, enriched with metrics about related charges and line items. ## Supported Data Sources * Recharge ## Columns | Type | Name | Description | | -------- | --------------------------------------- | ------------------------------------------------------------------------------------------------------------- | | INTEGER | order\_id | The unique identifier of the order. | | INTEGER | external\_order\_id\_ecommerce | The ID for the order in your external ecommerce platform. | | INTEGER | external\_order\_number\_ecommerce | The order number in your external ecommerce platform. | | INTEGER | customer\_id | Unique numeric identifier for the customer associated with the order. | | STRING | email | The email address of the customer. | | DATETIME | order\_created\_at | The date and time the order was created. | | STRING | order\_status | The status of the order. Possible values are SUCCESS, ERROR, QUEUED, CANCELLED. | | DATETIME | order\_updated\_at | The date and time the order was last updated. | | INTEGER | charge\_id | The unique identifier of the charge. | | STRING | transaction\_id | The unique identifier of the transaction. | | STRING | charge\_status | The status of the charge. Possible values are SUCCESS, ERROR, QUEUED, SKIPPED, REFUNDED, PARTIALLY\_REFUNDED. | | BOOLEAN | is\_prepaid | Boolean indicating if the Order is prepaid. | | DECIMAL | order\_total\_price | The total amount due of the order. | | STRING | order\_type | Possible values are CHECKOUT, RECURRING. | | DATETIME | order\_processed\_at | The date and time the order was processed. | | DATETIME | order\_scheduled\_at | The date time of when the associated order is/was scheduled to process. | | DATETIME | order\_shipped\_date | The date and time the order was shipped. | | INTEGER | address\_id | The unique identifier of the address. | | BOOLEAN | is\_deleted | Boolean indicating if the order (record) is deleted. | | DATETIME | charge\_created\_at | The date and time the charge was created. | | STRING | payment\_processor | The name of the payment processor. | | STRING | tags | A comma-separated list of tags on the charge. | | INTEGER | orders\_count | The number of orders generated from this charge (Will be >1 for prepaid). | | STRING | charge\_type | Possible values are CHECKOUT, RECURRING. | | DECIMAL | charge\_total\_price | The total amount due of the charge. | | DECIMAL | calculated\_order\_total\_price | The `charge_total_price` divided equally amongst all orders stemming from the same charge | | DECIMAL | charge\_subtotal\_price | The combined price of all charge line\_items minus any discounts. Does not include taxes and shipping. | | DECIMAL | calculated\_order\_subtotal\_price | The `charge_subtotal_price` divided equally amongst all orders stemming from the same charge. | | DECIMAL | charge\_tax\_lines | The tax lines associated with the charge. | | DECIMAL | calculated\_order\_tax\_lines | The charge\_tax\_lines divided equally amongst all orders stemming from the same charge. | | INTEGER | charge\_total\_discounts | The sum of the discounts applied to the charge. | | DECIMAL | calculated\_order\_total\_discounts | The charge\_total\_discounts divided equally amongst all orders stemming from the same charge. | | INTEGER | charge\_total\_refunds | The sum of all refunds that were applied to the charge. | | DECIMAL | calculated\_order\_total\_refunds | The charge\_total\_refunds divided equally amongst all orders stemming from the same charge. | | DECIMAL | charge\_total\_tax | The total tax due associated with the charge. | | DECIMAL | calculated\_order\_total\_tax | The charge\_total\_tax divided equally amongst all orders stemming from the same charge. | | INTEGER | charge\_total\_weight\_grams | The total weight of all items in the charge in grams. | | DECIMAL | calculated\_order\_total\_weight\_grams | The charge\_total\_weight\_grams divided equally amongst all orders stemming from the same charge. | | DECIMAL | charge\_total\_shipping | The total shipping costs associated with the charge. | | DECIMAL | calculated\_order\_total\_shipping | The charge\_total\_shipping divided equally amongst all orders stemming from the same charge. | | INTEGER | order\_item\_quantity | The total number of items in the order. | | DECIMAL | order\_line\_item\_total | The total price of all line items in the order. Does not include discounts, shipping, or tax. | | DECIMAL | total\_net\_charge\_value | The total net value of the charge, calculated as the total price minus total discounts. | | DECIMAL | total\_calculated\_net\_order\_value | The `total_net_charge_value` divided equally amongst all orders stemming from the same charge. | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/recharge-billing-history.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.