Push to Warehouse Schema

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.

balance_reports

Column Name	Type
`__version__`	`timestamp`
`as_of_datetime`	`timestamp`
`balance_report_type`	`string`
`created_at`	`timestamp`
`id`	`string`
`internal_account_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`updated_at`	`timestamp`

cases

Column Name	Type
`__version__`	`timestamp`
`caseable_id`	`string`
`caseable_type`	`string`
`created_at`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`reason`	`string`
`status`	`string`
`updated_at`	`timestamp`

counterparties

Column Name	Type
`__version__`	`timestamp`
`created_at`	`timestamp`
`discarded_at`	`timestamp`
`email`	`string`
`id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`name`	`string`
`organization_id`	`string`
`raw_json`	`json`
`send_remittance_advice`	`boolean`
`updated_at`	`timestamp`
`verification_status`	`string`

decisions

Column Name	Type
`__version__`	`timestamp`
`created_at`	`timestamp`
`decision_type`	`string`
`decisionable_id`	`string`
`decisionable_type`	`string`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`score`	`string`
`status`	`string`
`updated_at`	`timestamp`

events

Column Name	Type
`__version__`	`timestamp`
`data`	`json`
`event`	`string`
`event_time`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`resource`	`string`
`resource_id`	`string`

expected_payments

Column Name	Type
`__version__`	`timestamp`
`counterparty_id`	`string`
`created_at`	`timestamp`
`currency`	`string`
`description`	`string`
`direction`	`string`
`id`	`string`
`internal_account_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`reconciliation_method`	`string`
`remittance_information`	`string`
`statement_descriptor`	`string`
`status`	`string`
`updated_at`	`timestamp`

external_accounts

Column Name	Type
`__version__`	`timestamp`
`account_type`	`string`
`counterparty_id`	`string`
`created_at`	`timestamp`
`discarded_at`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`name`	`string`
`organization_id`	`string`
`party_name`	`string`
`party_type`	`string`
`raw_json`	`json`
`updated_at`	`timestamp`
`verification_status`	`string`

incoming_payment_details

Column Name	Type
`__version__`	`timestamp`
`amount`	`bigint`
`as_of_date`	`date`
`created_at`	`timestamp`
`currency`	`string`
`data`	`json`
`direction`	`string`
`id`	`string`
`internal_account_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`status`	`string`
`updated_at`	`timestamp`
`vendor_id`	`string`
`virtual_account_id`	`string`

invoice_line_items

Column Name	Type
`__version__`	`timestamp`
`amount`	`decimal`
`created_at`	`timestamp`
`description`	`string`
`direction`	`string`
`id`	`string`
`invoice_id`	`string`
`live_mode`	`boolean`
`name`	`string`
`organization_id`	`string`
`quantity`	`decimal`
`raw_json`	`json`
`unit_amount`	`decimal`
`updated_at`	`timestamp`

invoices

Column Name	Type
`__version__`	`timestamp`
`counterparty_id`	`string`
`created_at`	`timestamp`
`currency`	`string`
`description`	`string`
`due_date`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`notification_email_addresses`	`string`
`notifications_enabled`	`boolean`
`number`	`string`
`organization_id`	`string`
`originating_account_id`	`string`
`payment_effective_date`	`date`
`payment_method`	`string`
`payment_type`	`string`
`raw_json`	`json`
`receiving_account_id`	`string`
`status`	`string`
`total_amount`	`decimal`
`updated_at`	`timestamp`

ledger_account_balances

Column Name	Type
`created_at`	`timestamp`
`id`	`string`
`ledger_account_id`	`string`
`live_mode`	`boolean`
`lock_version`	`integer`
`organization_id`	`string`
`updated_at`	`timestamp`

ledger_account_parent_categorizations

Column Name	Type
`created_at`	`timestamp`
`depth`	`integer`
`id`	`string`
`ledger_account_category_id`	`string`
`ledger_account_id`	`string`
`ledger_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`updated_at`	`timestamp`

ledger_account_payouts

Column Name	Type
`amount`	`decimal`
`created_at`	`timestamp`
`currency`	`string`
`currency_exponent`	`decimal`
`description`	`string`
`effective_at_upper_bound`	`date`
`funding_ledger_account_id`	`string`
`id`	`string`
`ledger_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`organization_id`	`string`
`payout_ledger_account_id`	`string`
`status`	`string`
`updated_at`	`timestamp`

ledger_account_settlements

Column Name	Type
`amount`	`decimal`
`contra_ledger_account_id`	`string`
`created_at`	`timestamp`
`currency`	`string`
`currency_exponent`	`decimal`
`description`	`string`
`effective_at_upper_bound`	`timestamp`
`id`	`string`
`ledger_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`organization_id`	`string`
`settled_ledger_account_id`	`string`
`settlement_entry_direction`	`string`
`status`	`string`
`updated_at`	`timestamp`

ledger_accounts

Column Name	Type
`created_at`	`timestamp`
`description`	`string`
`discarded_at`	`timestamp`
`id`	`string`
`ledger_id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`name`	`string`
`normal_balance`	`string`
`organization_id`	`string`
`updated_at`	`timestamp`

ledger_entries

Column Name	Type
`amount_decimal`	`decimal`
`created_at`	`timestamp`
`direction`	`string`
`discarded_at`	`timestamp`
`discarded_at_lock_version`	`bigint`
`effective_at`	`timestamp`
`id`	`string`
`ledger_account_id`	`string`
`ledger_account_lock_version`	`bigint`
`ledger_account_payout_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`organization_id`	`string`
`pending_credits`	`decimal`
`pending_debits`	`decimal`
`posted_credits`	`decimal`
`posted_debits`	`decimal`
`updated_at`	`timestamp`

ledger_transactions

Column Name	Type
`created_at`	`timestamp`
`description`	`string`
`effective_at`	`timestamp`
`effective_date`	`date`
`external_id`	`string`
`id`	`string`
`ledger_id`	`string`
`ledgerable_id`	`string`
`ledgerable_type`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`organization_id`	`string`
`posted_at`	`timestamp`
`reverses_ledger_transaction_id`	`string`
`status`	`string`
`updated_at`	`timestamp`

ledgers

Column Name	Type
`created_at`	`timestamp`
`currency`	`string`
`description`	`string`
`discarded_at`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`name`	`string`
`organization_id`	`string`
`updated_at`	`timestamp`

line_items

Column Name	Type
`__version__`	`timestamp`
`accounting_category_id`	`string`
`amount`	`bigint`
`created_at`	`timestamp`
`description`	`string`
`id`	`string`
`itemizable_id`	`string`
`itemizable_type`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`updated_at`	`timestamp`

payment_orders

Column Name	Type
`__version__`	`timestamp`
`accounting_category_id`	`string`
`amount`	`bigint`
`charge_bearer`	`string`
`counterparty_id`	`string`
`created_at`	`timestamp`
`currency`	`string`
`description`	`string`
`direction`	`string`
`effective_date`	`date`
`expires_at`	`timestamp`
`foreign_exchange_contract`	`string`
`foreign_exchange_indicator`	`string`
`id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`nsf_protected`	`boolean`
`organization_id`	`string`
`originating_account_id`	`string`
`originating_party_name`	`string`
`priority`	`string`
`purpose`	`string`
`raw_json`	`json`
`remittance_information`	`string`
`send_remittance_advice`	`boolean`
`statement_descriptor`	`string`
`status`	`string`
`transaction_monitoring_enabled`	`boolean`
`ultimate_originating_party_identifier`	`string`
`ultimate_originating_party_name`	`string`
`ultimate_receiving_party_identifier`	`string`
`ultimate_receiving_party_name`	`string`
`updated_at`	`timestamp`

payment_references

Column Name	Type
`__version__`	`timestamp`
`created_at`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`reference_number`	`string`
`reference_number_type`	`string`
`referenceable_id`	`string`
`referenceable_type`	`string`
`updated_at`	`timestamp`

returns

Column Name	Type
`__version__`	`timestamp`
`additional_information`	`string`
`amount`	`bigint`
`code`	`string`
`created_at`	`timestamp`
`currency`	`string`
`date_of_death`	`date`
`discarded_at`	`timestamp`
`failure_reason`	`string`
`id`	`string`
`internal_account_id`	`string`
`ledger_transaction_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`raw_json`	`json`
`reason`	`string`
`returnable_id`	`string`
`returnable_type`	`string`
`role`	`string`
`status`	`string`
`updated_at`	`timestamp`

reversals

Column Name	Type
`__version__`	`timestamp`
`created_at`	`timestamp`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`payment_order_id`	`string`
`raw_json`	`json`
`reason`	`string`
`status`	`string`
`updated_at`	`timestamp`

transaction_line_items

Column Name	Type
`__version__`	`timestamp`
`amount`	`bigint`
`counterparty_id`	`string`
`created_at`	`timestamp`
`description`	`string`
`discarded_at`	`timestamp`
`expected_payment_id`	`string`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`transactable_id`	`string`
`transactable_type`	`string`
`transaction_id`	`string`
`transaction_line_item_type`	`string`
`updated_at`	`timestamp`

transactions

Column Name	Type
`__version__`	`timestamp`
`amount`	`bigint`
`as_of_datetime`	`timestamp`
`created_at`	`timestamp`
`currency`	`string`
`details`	`json`
`direction`	`string`
`discarded_at`	`timestamp`
`id`	`string`
`internal_account_id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`posted`	`boolean`
`raw_json`	`json`
`reconciled`	`boolean`
`updated_at`	`timestamp`
`vendor_code`	`string`
`vendor_code_type`	`string`
`vendor_customer_id`	`string`
`vendor_description`	`string`
`vendor_id`	`string`

user_onboardings

Column Name	Type
`__version__`	`timestamp`
`counterparty_id`	`string`
`created_at`	`timestamp`
`external_account_id`	`string`
`id`	`string`
`live_mode`	`boolean`
`organization_id`	`string`
`party_type`	`string`
`raw_json`	`json`
`status`	`string`
`updated_at`	`timestamp`

virtual_accounts

Column Name	Type
`__version__`	`timestamp`
`counterparty_id`	`string`
`created_at`	`timestamp`
`credit_ledger_account_id`	`string`
`debit_ledger_account_id`	`string`
`description`	`string`
`discarded_at`	`timestamp`
`id`	`string`
`internal_account_id`	`string`
`live_mode`	`boolean`
`metadata_json`	`json`
`name`	`string`
`organization_id`	`string`
`raw_json`	`json`
`updated_at`	`timestamp`