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_attimestampemailstringidstringlive_modebooleanmetadata_jsonjsonnamestringorganization_idstringraw_jsonjsonsend_remittance_advicebooleanupdated_attimestampverification_statusstring
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_attimestamp
Column Name Type Notes __version__timestampaccount_typestringcounterparty_idstringcreated_attimestampdiscarded_attimestampidstringlive_modebooleannamestringorganization_idstringparty_namestringparty_typestringraw_jsonjsonupdated_attimestampverification_statusstring
Column Name Type Notes __version__timestampamountbigintas_of_datedatecreated_attimestampcurrencystringdatajsondirectionstringidstringinternal_account_idstringledger_transaction_idstringlive_modebooleanorganization_idstringraw_jsonjsonstatusstringupdated_attimestampvendor_idstringvirtual_account_idstring
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 created_attimestampdepthintegeridstringledger_account_category_idstringledger_account_idstringledger_idstringlive_modebooleanorganization_idstringupdated_attimestamp
Column Name Type Notes amountdecimalcontra_ledger_account_idstringcreated_attimestampcurrencystringcurrency_exponentintegerdescriptionstringeffective_at_upper_boundtimestampidstringledger_idstringledger_transaction_idstringlive_modebooleanmetadata_jsonjsonorganization_idstringsettled_ledger_account_idstringsettlement_entry_directionstringstatusstringupdated_attimestamp
Column Name Type Notes created_attimestampdescriptionstringdiscarded_attimestampidstringledger_idstringlive_modebooleanmetadata_jsonjsonnamestringnormal_balancestringorganization_idstringupdated_attimestamp
Column Name Type Notes amount_decimaldecimalcreated_attimestampdirectionstringdiscarded_attimestampdiscarded_at_lock_versionbiginteffective_attimestampidstringledger_account_idstringledger_account_lock_versionbigintledger_account_payout_idstringledger_transaction_idstringlive_modebooleanmetadata_jsonjsonorganization_idstringpending_creditsdecimalpending_debitsdecimalposted_creditsdecimalposted_debitsdecimalupdated_attimestamp
Column Name Type Notes created_attimestampdescriptionstringeffective_attimestampeffective_datedateexternal_idstringidstringledger_idstringledgerable_idstringledgerable_typestringlive_modebooleanmetadata_jsonjsonorganization_idstringposted_attimestampreverses_ledger_transaction_idstringstatusstringupdated_attimestamp
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_attimestampforeign_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_attimestamp
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_attimestamp
Column Name Type Notes __version__timestampcreated_attimestampidstringlive_modebooleanorganization_idstringpayment_order_idstringraw_jsonjsonreasonstringstatusstringupdated_attimestamp
Column Name Type Notes __version__timestampamountbigintcounterparty_idstringcreated_attimestampdescriptionstringdiscarded_attimestampexpected_payment_idstringidstringlive_modebooleanorganization_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
