# MyBankAccounts: Exact Online My Bank Accounts - Catalog: `ExactOnlineREST` - Schema: `Licence` - Primary Keys: `ID` - Label: My Bank Accounts Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `MyBankAccounts` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `BankAccount` | `varchar2` | Bank Account | ☐ | The bank account number. | | `BankAccountHolderName` | `varchar2` | Bank Account Holder Name | ☐ | Name of the holder of the bank account, as known by the bank. | | `BICCode` | `varchar2` | BIC Code | ☐ | BIC code of the bank where the bank account is held. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `Description` | `varchar2` | Description | ☐ | Description of the bank account. | | `Format` | `varchar2` | Format | ☐ | Format that belongs to the bank account number. | | `ID` | `guid` | ID | ☑ | Primary key. | | `Main` | `char` | Main | ☐ | Indicates if the bank account is the main bank account. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. |