Skip to content

app.payout_accounts

TableRow level security on

Where an org pays a payee: a reference held by the payment provider, never bank details (Section 4.4.4).

Primary key: id

Columns of app.payout_accounts
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoPaying org.References app.organizations.id
person_iduuidYesPayee person.References app.people.id
organization_iduuidYesPayee external account.References app.organizations.id
providerapp.payout_providerNoStripe Connect or the org's accounting system.
provider_account_referencetextNoThe provider's account or vendor reference.
account_last4textYesLast four characters the provider reports for display, when it reports them.
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id