Organisation Bank account

Organisation Bank account table stores information about Bank accounts linked to organisation. It is used in invoice for maintaining payments from buyer and also in export/sales order for document generation.

Attributes

bankId: primary key of the bank accounts table.

orgId: Foreign key of the organisation table. This field stores the information of the Organisation id to which bank account belongs.

currency: Currency in which bank accepts payments.

swiftCode: Swift Code of the bank.

bankName: Name of the bank.

accountNumber: Account number of the organisation in bank.

ifscCode: IFSC code of the bank.

holderName: Bank account holder name.

branchAddress: Branch address of the bank.

accountTitle: Title of the bank account.

isIntermediary: Boolean value indicating whether bank has any intermediary bank.

intermediarySwiftCode: Swift code of the intermediary bank.

intermediaryBankName: Name of the intermediary bank.

isPrimary: Boolean value indicating whether bank account is primary bank account of oragnisation.

otherData: JSON object to stores information about other bank related information which does not require any computation on them.

createdBy: Foreign key of the User table. This field stores the information of the email id which created the bank account.

updatedBy: Foreign key of the User table. This field stores the information of the email id which updated the bank account.

---

Associations

Organisation

Bank account always belongs any one organisation.

CreatedUser

Bank account always created by any one user belongs to organisation.

UpdatedUser

Bank account always updated by any one user belongs to organisation.