Documentation: paygo_accounts_snapshots_ts

Time Series data of events processed from meters_ts
To import data in this format you can use our API. -> API Documentation
You can also supply us with files in xlsx, csv or json format. -> Example CSV
type p14n blurred autogenerated required
account_uid string ⤫ ⤫ ✓ ⤫
organization_id + data_origin + account_external_id; FK to accounts table
snapshot_date date ⤫ ⤫ ⤫ ✓
Date for which snapshot is calculated for.
account_status enum: active, completed, defaulted, cancelled, locked, returned ⤫ ⤫ ⤫ ✓
active, completed, defaulted, cancelled, locked, returned
days_in_repayment integer ⤫ ⤫ ⤫ ✓
When negative: Days until paygo period starts - account is in downpayment period. Then counts up from zero when paygo repayment period starts.
cumulative_paid_amount float ⤫ ⤫ ⤫ ✓
The accumulated amount the customer paid to this snapshot date.
days_to_cutoff integer ⤫ ⤫ ⤫ ✓
How many days until system will switch off. Negative if locked for N days.
cumulative_days_locked integer ⤫ ⤫ ⤫ ✓
How many days system was off over its lifetime.
total_remaining_amount float ⤫ ⤫ ⤫ ✓
How much money is left to payoff the system.
account_external_id string ⤫ ⤫ ⤫ ✓
id for the specific account (e.g. paygo loan) associated with the shs device; FK to accounts table
created_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was inserted
updated_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was updated
source_id integer ⤫ ⤫ ✓ ⤫
References Source of data
organization_id integer ⤫ ⤫ ✓ ⤫
References Organization of data
custom jsonb ⤫ ⤫ ✓ ⤫
Saves additional imported data out of standard structure
data_origin string ⤫ ⤫ ✓ ⤫
Origin of the data, generic or name of the api