| TR | 1 | TransDate | Date | TransDate | Date | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TransDate | | GroupPrompt | | | HelpText | @SYS16696 (Voucher posting date.) | | Label | | | Mandatory | No | | Name | TransDate | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Date | | Visible | Yes |
|
| TR | 2 | Voucher | Voucher number | Voucher | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Voucher | | GroupPrompt | | | HelpText | @SYS8543 (Voucher number used when posting) | | Label | @SYS12336 (Voucher number) | | Mandatory | No | | Name | Voucher | | SaveContents | Yes | | StringSize | 20 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| FK | 3 | LedgerAccountNum | Ledger account | LedgerAccount | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | LedgerAccount | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | LedgerAccountNum | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 4 | LedgerTransType | Ledger transaction type | LedgerTransType | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | EnumType | LedgerTransType | | ExtendedDataType | | | GroupPrompt | | | HelpText | | | Label | @SYS11115 (Ledger transaction type) | | Mandatory | No | | Name | LedgerTransType | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Enum | | Visible | Yes |
|
| TR FK | 5 | AccountId | Bank account | CompanyBankAccountId | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | CompanyBankAccountId | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | AccountId | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 6 | AmountCur | Amount currency | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS27825 (Amount of the posting in currency) | | Label | | | Mandatory | No | | Name | AmountCur | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Real | | Visible | Yes |
|
| | 7 | AmountMST | Amount | AmountMST | Real | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | AmountMST | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS9993 (Transaction amount in default currency) | | Label | | | Mandatory | No | | Name | AmountMST | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Real | | Visible | Yes |
|
| FK | 8 | CurrencyCode | Currency | CurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | CurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | Yes | | Name | CurrencyCode | | SaveContents | Yes | | StringSize | 3 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 9 | AccountStatement | Bank statement | BankAccountStatementNum | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankAccountStatementNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | AccountStatement | | SaveContents | Yes | | StringSize | 20 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 10 | 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 | No | | Name | AccountStatementDate | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Date | | Visible | Yes |
|
| FK | 11 | BankTransType | Bank transaction type | BankTransactionType | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankTransactionType | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | BankTransType | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 12 | PaymReference | Payment reference | PaymReference | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PaymReference | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PaymReference | | SaveContents | Yes | | StringSize | 20 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 13 | PaymentMode | Method of payment | PaymMode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | PaymMode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | PaymentMode | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 14 | DepositNum | Deposit slip | BankDepositNum | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankDepositNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | DepositNum | | SaveContents | Yes | | StringSize | 20 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 15 | Reconciled | Reconciled | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS25476 (Transaction has been reconciled.) | | Label | @SYS22247 (Reconciled) | | Mandatory | No | | Name | Reconciled | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Enum | | Visible | Yes |
|
| | 16 | Included | Cleared | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS25091 (Include the transaction in the account statement?) | | Label | @SYS50993 (Cleared) | | Mandatory | No | | Name | Included | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Enum | | Visible | Yes |
|
| | 17 | AmountCorrect | Correction amount | AmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | AmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | @SYS28394 (Amount to be added to the original transaction to make the reconciliation balance) | | Label | @SYS28655 (Correction amount) | | Mandatory | No | | Name | AmountCorrect | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Real | | Visible | Yes |
|
| FK | 18 | Dimension | Department | Dimension | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | Dimension | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Dimension | | SaveContents | Yes | | StringSize | 10 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 19 | Manual | Manual | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS28646 (Manual posting) | | Label | @SYS9232 (Manual) | | Mandatory | No | | Name | Manual | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Enum | | Visible | Yes |
|
| | 20 | ChequeNum | Check number | BankChequeNum | String | Show |
| Adjustment | Right | | AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | ExtendedDataType | BankChequeNum | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | ChequeNum | | SaveContents | Yes | | StringSize | 30 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 21 | Txt | Transaction text | TransTxt | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | TransTxt | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | Txt | | SaveContents | Yes | | StringSize | 30 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 22 | Cancel | Cancellation | NoYes | Enum | Show |
| AliasFor | | | AllowEdit | No | | AllowEditOnCreate | No | | ConfigurationKey | | | EnumType | NoYes | | ExtendedDataType | | | GroupPrompt | | | HelpText | @SYS28689 (Marking that payment is canceled.) | | Label | @SYS4412 (Cancellation) | | Mandatory | No | | Name | Cancel | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Enum | | Visible | Yes |
|
| | 23 | BankTransCurrencyCode | Registration currency | BankTransCurrencyCode | String | Show |
| Adjustment | Left | | AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankTransCurrencyCode | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | BankTransCurrencyCode | | SaveContents | Yes | | StringSize | 3 | | Table | BankAccountTrans | | Type | String | | Visible | Yes |
|
| | 24 | BankTransAmountCur | Registration amount | BankTransAmountCur | Real | Show |
| AliasFor | | | AllowEdit | Yes | | AllowEditOnCreate | Yes | | ConfigurationKey | | | ExtendedDataType | BankTransAmountCur | | FieldUpdate | Absolute | | GroupPrompt | | | HelpText | | | Label | | | Mandatory | No | | Name | BankTransAmountCur | | SaveContents | Yes | | Table | BankAccountTrans | | Type | Real | | Visible | Yes |
|