Recurly: Account Daily Overview

Description

• Each record is a day in an account and its accumulated balance totals based on all line item transactions up to that day.

Supported Data Sources

• Recurly

Columns

Type	Name	Description
STRING	account_id	Account associated with balance transactions.
DATETIME	account_created_at	Timestamp of when the account entry was created.
STRING	account_city	City in the world the account is associated with.
STRING	account_company	The company related with the account.
STRING	account_country	Country in the world the account is associated with.
STRING	account_code	The unique identifier of the account. This cannot be changed once the account is created. Provided during account creation.
STRING	account_email	Email address associated with the account.
STRING	account_first_name	First name associated with the account.
STRING	account_last_name	Last name associated with the account.
BOOLEAN	account_is_tax_exempt	The tax status of the account. true exempts tax on the account, false applies tax on the account.
STRING	account_postal_code	Postal code in the world the account is associated with.
STRING	account_region	Region in the world the account is associated with (usually would be state if it was a U.S. account.)
STRING	account_state	Current state of the account.
STRING	account_username	A secondary value for the account.
STRING	account_daily_id	Unique account key, based on account id and date of balance data.
DATE	date_day	Date compiled transactions by day for this account balance took place.
DATE	date_week	Date compiled transactions by week for this account balance took place.
DATE	date_month	Date compiled transactions by month for this account balance took place.
DATE	date_year	Date compiled transactions by year for this account balance took place.
INTEGER	date_index	The nth date in the transaction model.
INTEGER	daily_transaction_count	Number of transactions that took place this day for this account.
DECIMAL	daily_net_change	Total sum of all transactions that took place this day for this account and the balance change that ensued.
INTEGER	daily_invoice_count	Number of invoices that day for this account.
DECIMAL	daily_charges	Total sum of all charges that took place this day for this account.
DECIMAL	daily_credits	Total sum of all credits that took place this day for this account.
DECIMAL	daily_discounts	Total sum of all discounts that took place this day for this account.
DECIMAL	daily_taxes	Total sum of all taxes that took place this day for this account.
INTEGER	daily_charge_count	Number of charges that day for this account.
INTEGER	daily_credit_count	Number of credits that day for this account.
DECIMAL	rolling_account_balance	Accumulated account balance based on previous daily transactions on this account.
INTEGER	rolling_invoices	Number of invoices on this account since it was created to the current date.
INTEGER	rolling_transactions	Number of transactions on this account since it was created to the current date.
DECIMAL	rolling_charge_balance	Accumulated charge balance based on previous daily charges on this account.
DECIMAL	rolling_credit_balance	Accumulated credit balance based on previous daily credits on this account.
DECIMAL	rolling_discount_balance	Accumulated discount balance based on previous daily discounts on this account.
DECIMAL	rolling_tax_balance	Accumulated tax balance based on previous daily taxes on this account.
INTEGER	rolling_charges	Number of charges on this account since it was created to the current date.
INTEGER	rolling_credits	Number of credits on this account since it was created to the current date.