maiven gateway · online··
manifest · 1d ago
Sign in Back to catalog
Definition
Daily cash movement and running balance rolled up by currency and region. running_balance is already cumulative per account, so read it on the latest as_of_day rather than summing over days.
Watch out for
- highSumming running_balance across days
running_balance is already cumulative; summing it across days compounds nonsensically. Read the latest as_of_day instead.
- mediumMixing currencies
Balances are per currency (USD / EUR). Summing running_balance across currencies mixes units; group by currency first.
Questions this answers
- “What is the current cash balance by currency?”
- “Net cash flow last month.”
9 of 9
Column
Type
Description
Tests · PII
as_of_day
Date
Calendar day of the cash activity. Date. Grain + sort key.
1 test
currency
String
Account currency (USD / EUR / unknown). Dimension.
1 test
region
String
Account region (US / EU / unknown). Dimension.
1 test
cash_in
Decimal(18, 2)
Summed credit (cash-in) on the day. Decimal(18,2).
1 test
cash_out
Decimal(18, 2)
Summed debit (cash-out) on the day. Decimal(18,2).
1 test
net_flow
Decimal(18, 2)
Day's net cash flow — cash_in - cash_out. Decimal(18,2).
1 test
running_balance
Decimal(18, 2)
Summed cumulative balance through the day (per currency/region). Decimal(18,2).
1 test
transaction_count
UInt64
Bank transactions on the day. UInt64.
1 test
accounts_count
UInt64
Distinct bank accounts in the bucket. UInt64.
1 test