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.