BankAccount

A BankAccount record is used to represent further information for an ExternalAccount record where the authority issuing the account is a bank.

It contains extra fields that are banking specific which can then be used for integrations with bank systems.

Section: Position Keeping

Metadata

Base Table Class: Static
Default Size: Account = 500

Fields

Name	Type	Size (bytes)	Description
Id	Integer (signed)	8	The unique identifier of this BankAccount. Not editable Read-only
Status	Set of Status	4
ExternalAccount	Foreign key to ExternalAccount	8	This is a reference to the ExternalAccount table. It is keyed by the ExternalAccount column in this table to the Id column in the ExternalAccount table. Required
ExternalFK	Integer (unsigned)	8
PairedAccount	Foreign key to BankAccount	8
IsZeroBalanceAccount	Integer (unsigned)	1
IsCustomerAccount	Integer (unsigned)	1
IsExchangeRevenueAccount	Integer (unsigned)	1
RoutingNumber	String	40
IBANValue	String	34
BankAccountType	String	34
BankAccountNumber	String	34
BankAccountName	String	34
BankAccountId	String	34
ABA	String	34
BankName	String	34
BankAddress1	String	34
BankAddress2	String	34
BankAddress3	String	34
City	String	34
State	String	34
PostCode	String	34
Name	String	48	The long text identifier of this BankAccount.
FFC	Foreign key to BankAccount	8
Country	Foreign key to Country	8	This is a reference to the Country table. It is keyed by the Country column in this table to the Id column in the Country table.
BICId	String	34
FEDId	String	34
CHIPSId	String	34
UpdateNumber	Integer (unsigned)	8	A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. Not editable
OwnerUser	Foreign key to User	8	The Id of the User that owns this BankAccount.
OwnerGroup	Foreign key to Group	8	The Id of the Group that owns this BankAccount.
OwnerFirm	Foreign key to Firm	8	The Id of the Firm that owns this BankAccount.
CreateUser	Foreign key to User	8	The Id of the User that created this BankAccount. Not editable Read-only
CreateTimestamp	Integer (unsigned)	8	The time at which this BankAccount was created. Not editable Read-only
UpdateUser	Foreign key to User	8	The Id of the User that last updated this BankAccount. Not editable Read-only
UpdateTimestamp	Integer (unsigned)	8	The time at which this BankAccount was last updated. Not editable Read-only

Foreign Keys

The following diagram shows the tables that have a foreign key link to the BankAccount table. All Table nodes can be clicked to take you to that table's definition page.

graph LR;
	Account-->|BankAccount|BankAccount
	click Account "/marketgrid/developer/model/tables/Account"