The Push to Warehouse table schema aims to emulate the API schema as closely as possible. Our API Reference includes detailed descriptions of each object type and its constituent fields.
Each Push to Warehouse table includes a raw_json column, which contains a JSON-serialized representation of each object in precisely the same format that we use for API responses and Webhook payloads. The remainder of the columns for each table (with the exception of the __version__ metadata attribute) are produced by "flattening" the raw JSON values as a convenience measure. Note that the specified data types are based on the input data type and may differ from your warehouse output type.
Column Name Type Notes __version__timestampas_of_datedateas_of_datetimetimestampDeprecated - prefer as_of_date and as_of_time . Represents the bank-reported effective datetime for the Balance Report. Due to a known bug, this value is currently expressed as a UTC timestamp. A value of "2024-09-01T01:00:00Z" should be understood to indicate that the Balance was effective as of "2024-09-01 01:00:00" in the bank's time zone.as_of_timestringbalance_report_typestringcreated_attimestampidstringinternal_account_idstringlive_modebooleanorganization_idstringraw_jsonjsonupdated_attimestamp
Column Name Type Notes __version__timestampcreated_attimestampdiscarded_attimestampidstringlive_modebooleanorganization_idstringraw_jsonjsonupdated_attimestampvendor_customer_idstringvendor_idstringvendor_namestring
Column Name Type Notes __version__timestampcreated_attimestampdiscarded_attimestampemailstringidstringlive_modebooleanmetadata_jsonjsonnamestringorganization_idstringraw_jsonjsonsend_remittance_advicebooleanupdated_attimestampverification_statusstringexternal_idstring
Column Name Type Notes __version__timestampdatajsoneventstringevent_timetimestampidstringlive_modebooleanorganization_idstringresourcestringresource_idstring
Column Name Type Notes __version__timestampcounterparty_idstringcreated_attimestampcurrencystringdescriptionstringdirectionstringidstringinternal_account_idstringledger_transaction_idstringlive_modebooleanorganization_idstringraw_jsonjsonreconciliation_methodstringremittance_informationstringstatement_descriptorstringstatusstringupdated_attimestampexternal_idstring
Column Name Type Notes __version__timestampaccount_typestringcounterparty_idstringcreated_attimestampdiscarded_attimestampidstringlive_modebooleannamestringorganization_idstringparty_namestringparty_typestringraw_jsonjsonupdated_attimestampverification_statusstringexternal_idstring
Column Name Type Notes __version__timestampamountbigintas_of_datedatecreated_attimestampcurrencystringdatajsondirectionstringidstringinternal_account_idstringledger_transaction_idstringlive_modebooleanorganization_idstringraw_jsonjsonstatusstringupdated_attimestampvendor_idstringvirtual_account_idstringreconciliation_status_textstringDo not use reconciliation_status - if you are, please drop it from your data warehouse.
Column Name Type Notes __version__timestampaccount_typestringcounterparty_idstringcreated_attimestampcurrencystringidstringlive_modebooleannamestringorganization_idstringparent_account_idstringparty_namestringparty_typestringraw_jsonjsonupdated_attimestamp
Column Name Type Notes __version__timestampamountdecimalcreated_attimestampdescriptionstringdirectionstringidstringinvoice_idstringlive_modebooleannamestringorganization_idstringquantitydecimalraw_jsonjsonunit_amountdecimalupdated_attimestamp
Column Name Type Notes __version__timestampcounterparty_idstringcreated_attimestampcurrencystringdescriptionstringdue_datetimestampidstringlive_modebooleannotification_email_addressesstringnotifications_enabledbooleannumberstringorganization_idstringoriginating_account_idstringpayment_effective_datedatepayment_methodstringpayment_typestringraw_jsonjsonreceiving_account_idstringstatusstringtotal_amountdecimalupdated_attimestamp
Column Name Type Notes __version__timestampcreated_attimestampcurrencystringcurrency_exponentintegerdescriptionstringdiscarded_attimestampexternal_idstringidstringledger_idstringlive_modebooleanmetadata_jsonjsonnamestringnormal_balancestringorganization_idstringupdated_attimestamp
Column Name Type Notes created_attimestampdepthintegeridstringledger_account_category_idstringledger_account_idstringledger_idstringlive_modebooleanorganization_idstringupdated_attimestamp
Column Name Type Notes __version__timestampamountdecimalcontra_ledger_account_idstringcreated_attimestampcurrencystringcurrency_exponentintegerdescriptionstringeffective_at_upper_boundtimestampidstringledger_idstringledger_transaction_idstringlive_modebooleanmetadata_jsonjsonorganization_idstringsettled_ledger_account_idstringsettlement_entry_directionstringstatusstringupdated_attimestamp
Column Name Type Notes __version__timestampcreated_attimestampcurrencystringcurrency_exponentintegerdescriptionstringdiscarded_attimestampexternal_idstringidstringledger_idstringlive_modebooleanmetadata_jsonjsonnamestringnormal_balancestringorganization_idstringupdated_attimestamp
Column Name Type Notes __version__timestampamount_decimaldecimalAs in our API, Ledger Entry amounts are reported as integers denominated in the currency's smallest unit (e.g. cents for USD accounts). created_attimestampdirectionstringdiscarded_attimestampdiscarded_at_lock_versionbiginteffective_attimestampidstringledger_account_idstringledger_account_lock_versionbigintledger_account_payout_idstringledger_transaction_idstringlive_modebooleanmetadata_jsonjsonorganization_idstringpending_creditsdecimalpending_debitsdecimalposted_creditsdecimalposted_debitsdecimalstatusstringupdated_attimestamp
Column Name Type Notes __version__timestampcreated_attimestampdescriptionstringeffective_attimestampeffective_datedateDeprecated - prefer effective_at . Represents the time at which the ledger transaction happened for reporting purposes.external_idstringidstringledger_idstringledgerable_idstringledgerable_typestringlive_modebooleanmetadata_jsonjsonorganization_idstringposted_attimestampreverses_ledger_transaction_idstringstatusstringupdated_attimestamparchived_reasonstring
Column Name Type Notes created_attimestampcurrencystringdescriptionstringdiscarded_attimestampidstringlive_modebooleanmetadata_jsonjsonnamestringorganization_idstringupdated_attimestamp
Column Name Type Notes __version__timestampaccounting_category_idstringamountbigintcreated_attimestampdescriptionstringidstringitemizable_idstringitemizable_typestringlive_modebooleanorganization_idstringraw_jsonjsonupdated_attimestamp
Column Name Type Notes __version__timestampaccounting_category_idstringamountbigintcharge_bearerstringcounterparty_idstringcreated_attimestampcurrencystringdescriptionstringdirectionstringeffective_datedateexpires_attimestampexternal_idstringforeign_exchange_contractstringforeign_exchange_indicatorstringidstringledger_transaction_idstringlive_modebooleannsf_protectedbooleanorganization_idstringoriginating_account_idstringoriginating_party_namestringprioritystringpurposestringraw_jsonjsonreceiving_account_idstringreceiving_account_typestringremittance_informationstringsend_remittance_advicebooleanstatement_descriptorstringstatusstringtransaction_monitoring_enabledbooleantypestringultimate_originating_party_identifierstringultimate_originating_party_namestringultimate_receiving_party_identifierstringultimate_receiving_party_namestringupdated_attimestampreconciliation_statusstring
Column Name Type Notes __version__timestampcreated_attimestampidstringlive_modebooleanorganization_idstringraw_jsonjsonreference_numberstringreference_number_typestringreferenceable_idstringreferenceable_typestringupdated_attimestamp
Column Name Type Notes __version__timestampadditional_informationstringamountbigintcodestringcreated_attimestampcurrencystringdate_of_deathdatediscarded_attimestampfailure_reasonstringidstringinternal_account_idstringledger_transaction_idstringlive_modebooleanorganization_idstringraw_jsonjsonreasonstringreturnable_idstringreturnable_typestringrolestringstatusstringupdated_attimestampreconciliation_statusstring
Column Name Type Notes __version__timestampcreated_attimestampidstringlive_modebooleanorganization_idstringpayment_order_idstringraw_jsonjsonreasonstringstatusstringupdated_attimestampreconciliation_statusstring
Column Name Type Notes __version__timestampamountbigintcounterparty_idstringcreated_attimestampdescriptionstringdiscarded_attimestampexpected_payment_idstringidstringlive_modebooleanorganization_idstringreconciliation_group_idstringtransactable_idstringtransactable_typestringtransaction_idstringtransaction_line_item_typestringupdated_attimestamp
Column Name Type Notes __version__timestampamountbigintas_of_datedateas_of_datetimetimestampDeprecated - prefer as_of_date and as_of_time . Represents the bank-reported effective datetime for the Transaction. Due to a known bug, this value is currently expressed as a UTC timestamp. A value of "2024-09-01T01:00:00Z" should be understood to indicate that the Transaction was effective as of "2024-09-01 01:00:00" in the bank's time zone.as_of_timestringcreated_attimestampcurrencystringdetailsjsondirectionstringdiscarded_attimestampidstringinternal_account_idstringlive_modebooleanorganization_idstringpostedbooleanraw_jsonjsonreconciledbooleanupdated_attimestampvendor_codestringvendor_code_typestringvendor_customer_idstringvendor_descriptionstringvendor_idstring
Column Name Type Notes __version__timestampcounterparty_idstringcreated_attimestampcredit_ledger_account_idstringdebit_ledger_account_idstringdescriptionstringdiscarded_attimestampidstringinternal_account_idstringlive_modebooleanmetadata_jsonjsonnamestringorganization_idstringraw_jsonjsonupdated_attimestamp
