Documentation: payments_ts

Payment time series data for SHS Accounts or Meter Accounts
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
uid string ⤫ ⤫ ✓ ⤫
account_origin + account_uid + payment_external_id + paid_at
payment_external_id string ⤫ ⤫ ⤫ ✓
ID for the specific payment as tracked by the data provider (source)
purpose string ⤫ ⤫ ⤫ ⤫
e.g.: Paygo payment, Loan repayment, cash purchase, tariff payment, etc.
paid_at datetime ⤫ ⤫ ⤫ ✓
date payment was made (including time if available)
amount float ⤫ ⤫ ⤫ ✓
amount of payment, in whatever currency is specified
currency string ⤫ ⤫ ⤫ ✓
currency in which payment was made according to ISO code https://en.wikipedia.org/wiki/List_of_circulating_currencies
purchase_item string ⤫ ⤫ ⤫ ⤫
item or rate which was purchased with the payment, e.g. 'Energy', 'TV', 'Uptime'
purchase_unit string ⤫ ⤫ ⤫ ⤫
unit of the purchase, e.g. 'wh', 'pcs', 'days'
purchase_quantity float ⤫ ⤫ ⤫ ⤫
amount of units of the item purchased
provider_name string ⤫ ⤫ ⤫ ⤫
who provided payment for particular payment (e.g. airtel, cash, MTN)
provider_transaction_id string ⤫ ⤫ ⤫ ⤫
data validation, was transaction actually done
reverted_at datetime ⤫ ⤫ ⤫ ⤫
datetime of when payment was reverted
days_active float ⤫ ⤫ ⤫ ⤫
information from shs table, is calculated
account_external_id string ⤫ ⤫ ⤫ ✓
external id for the specific account (e.g. paygo loan) associated with the shs or meter
account_uid string ⤫ ⤫ ✓ ⤫
organization_id + data_origin + account_external_id
account_origin enum: meters, shs ⤫ ⤫ ⤫ ✓
The table where we find the matching account_uid
created_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was inserted
updated_at datetime ⤫ ⤫ ✓ ⤫
Timestamp when row was updated
source_id integer ⤫ ⤫ ✓ ⤫
References Source of data
import_id integer ⤫ ⤫ ✓ ⤫
References Import 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
last_import_id integer ⤫ ⤫ ✓ ⤫
Id of the last import which updated the record
last_source_id integer ⤫ ⤫ ✓ ⤫
Id of the last Source which updated the record