| X | TR FK | 1 | AccountId | Bank account | CompanyBankAccountId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | Bank | | ExtendedDataType | CompanyBankAccountId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AccountId | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountStatement | | Type | String | | Visible | Yes |
|
| X | | 2 | AccountStatementDate | Bank account statement date | TransDate | Date | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | @SYS21760 (Date of the account statement) | | Label | @SYS26785 (Bank account statement date) | | Mandatory | Yes | | Name | AccountStatementDate | | SaveContents | Yes | | Table | BankAccountStatement | | Type | Date | | Visible | Yes |
|
| | 3 | ReconcileDate | Reconciled | TransDate | Date | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | @SYS23130 (Date of reconciliation) | | Label | @SYS22247 (Reconciled) | | Mandatory | No | | Name | ReconcileDate | | SaveContents | Yes | | Table | BankAccountStatement | | Type | Date | | Visible | Yes |
|
| X | | 4 | AccountStatementNum | Bank statement | BankAccountStatementNum | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankAccountStatementNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AccountStatementNum | | SaveContents | Yes | | StringSize | 20 | | Table | BankAccountStatement | | Type | String | | Visible | Yes |
|
| | 5 | EndingBalance | Ending balance | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS50987 (Balance on account statement after payments, disbursements, fees, and interest) | | Label | @SYS50986 (Ending balance) | | Mandatory | No | | Name | EndingBalance | | SaveContents | Yes | | Table | BankAccountStatement | | Type | Real | | Visible | Yes |
|
| FK | 6 | CurrencyCode | Currency | CurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | CurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | CurrencyCode | | SaveContents | Yes | | StringSize | 3 | | Table | BankAccountStatement | | Type | String | | Visible | Yes |
|