Table 270 Bank Account in 22
- App
- Base Application
Fields, 79Keys, 5Procedures, 36Events, 23
Versions171819202122232425262728latest
Source29
Fields, 79
| Id | Name | Type | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| 1 | No. | Code[20] | - | ||||
| 2 | Name | Text[100] | - | ||||
| 3 | Search Name | Code[100] | - | ||||
| 4 | Name 2 | Text[50] | - | ||||
| 5 | Address | Text[100] | - | ||||
| 6 | Address 2 | Text[50] | - | ||||
| 7 | City | Text[30] | - | ||||
| 8 | Contact | Text[100] | - | ||||
| 9 | Phone No. | Text[30] | - | ||||
| 10 | Telex No. | Text[20] | - | ||||
| 13 | Bank Account No. | Text[30] | - | ||||
| 14 | Transit No. | Text[20] | - | ||||
| 15 | Territory Code | Code[10] | - | ||||
| 16 | Global Dimension 1 Code | Code[20] | - | ||||
| 17 | Global Dimension 2 Code | Code[20] | - | ||||
| 18 | Chain Name | Code[10] | - | ||||
| 20 | Min. Balance | Decimal | - | ||||
| 21 | Bank Acc. Posting Group | Code[20] | - | ||||
| 22 | Currency Code | Code[10] | - | ||||
| 24 | Language Code | Code[10] | - | ||||
| 26 | Statistics Group | Integer | - | ||||
| 29 | Our Contact Code | Code[20] | - | ||||
| 35 | Country/Region Code | Code[10] | - | ||||
| 37 | Amount | Decimal | - | ||||
| 38 | Comment | Boolean | - | ||||
| 39 | Blocked | Boolean | - | ||||
| 41 | Last Statement No. | Code[20] | - | ||||
| 42 | Last Payment Statement No. | Code[20] | - | ||||
| 43 | Pmt. Rec. No. Series | Code[20] | - | ||||
| 54 | Last Date Modified | Date | - | ||||
| 55 | Date Filter | Date | - | ||||
| 56 | Global Dimension 1 Filter | Code[20] | - | ||||
| 57 | Global Dimension 2 Filter | Code[20] | - | ||||
| 58 | Balance | Decimal | - | ||||
| 59 | Balance (LCY) | Decimal | - | ||||
| 60 | Net Change | Decimal | - | ||||
| 61 | Net Change (LCY) | Decimal | - | ||||
| 62 | Total on Checks | Decimal | - | ||||
| 70 | Use as Default for Currency | Boolean | - | ||||
| 84 | Fax No. | Text[30] | - | ||||
| 85 | Telex Answer Back | Text[20] | - | ||||
| 89 | Picture | Blob | Removed 18.0 | ||||
| Replaced by Image field | |||||||
| 91 | Post Code | Code[20] | - | ||||
| 92 | County | Text[30] | - | ||||
| 93 | Last Check No. | Code[20] | - | ||||
| 94 | Balance Last Statement | Decimal | - | ||||
| 95 | Balance at Date | Decimal | - | ||||
| 96 | Balance at Date (LCY) | Decimal | - | ||||
| 97 | Debit Amount | Decimal | - | ||||
| 98 | Credit Amount | Decimal | - | ||||
| 99 | Debit Amount (LCY) | Decimal | - | ||||
| 100 | Credit Amount (LCY) | Decimal | - | ||||
| 101 | Bank Branch No. | Text[20] | - | ||||
| 102 | Text[80] | - | |||||
| 103 | Home Page | Text[80] | - | ||||
| 107 | No. Series | Code[20] | - | ||||
| 108 | Check Report ID | Integer | - | ||||
| 109 | Check Report Name | Text[250] | - | ||||
| 110 | IBAN | Code[50] | - | ||||
| 111 | SWIFT Code | Code[20] | - | ||||
| 113 | Bank Statement Import Format | Code[20] | - | ||||
| 115 | Credit Transfer Msg. Nos. | Code[20] | - | ||||
| 116 | Direct Debit Msg. Nos. | Code[20] | - | ||||
| 117 | SEPA Direct Debit Exp. Format | Code[20] | - | ||||
| 121 | Bank Stmt. Service Record ID | RecordId | - | ||||
| 123 | Transaction Import Timespan | Integer | - | ||||
| 124 | Automatic Stmt. Import Enabled | Boolean | - | ||||
| 130 | IntercompanyEnable | Boolean | - | ||||
| 140 | Image | Media | - | ||||
| 170 | Creditor No. | Code[35] | - | ||||
| 1210 | Payment Export Format | Code[20] | - | ||||
| 1211 | Bank Clearing Code | Text[50] | - | ||||
| 1212 | Bank Clearing Standard | Text[50] | - | ||||
| 1213 | Bank Name - Data Conversion | Text[50] | Removed 15.0 | ||||
| Changed to AMC Banking 365 Fundamentals Extension | |||||||
| 1250 | Match Tolerance Type | Option | - | ||||
| 1251 | Match Tolerance Value | Decimal | - | ||||
| 1252 | Disable Automatic Pmt Matching | Boolean | - | ||||
| 1260 | Positive Pay Export Code | Code[20] | - | ||||
| 5061 | Mobile Phone No. | Text[30] | - | ||||
Keys, 5
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | No. | - |
| Key2 | Search Name | - |
| Key3 | Bank Acc. Posting Group | - |
| Key4 | Currency Code | - |
| Key5 | Country/Region Code | - |
Procedures, 36
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| AssistEdit | (Record Bank Account) | Boolean | public | - |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| ShowContact | () | public | - | |
| SetInsertFromContact | (Boolean) | public | - | |
| GetPaymentExportCodeunitID | () | Integer | public | - |
| GetPaymentExportXMLPortID | () | Integer | public | - |
| GetDDExportCodeunitID | () | Integer | public | - |
| GetDDExportXMLPortID | () | Integer | public | - |
| GetBankExportImportSetup | (var Record Bank Export/Import Setup) | public | - | |
| GetDDExportImportSetup | (var Record Bank Export/Import Setup) | public | - | |
| GetCreditTransferMessageNo | () | Code[20] | public | - |
| GetDirectDebitMessageNo | () | Code[20] | public | - |
| DisplayMap | () | public | - | |
| GetDataExchDef | (var Record Data Exch. Def) | public | - | |
| GetDataExchDefPaymentExport | (var Record Data Exch. Def) | public | - | |
| GetBankAccountNoWithCheck | () | Text | public | - |
| GetBankAccountNo | () | Text | public | - |
| IsInLocalCurrency | () | Boolean | public | - |
| GetPosPayExportCodeunitID | () | Integer | public | - |
| IsLinkedToBankStatementServiceProvider | () | Boolean | public | - |
| StatementProvidersExist | () | Boolean | public | - |
| LinkStatementProvider | (var Record Bank Account) | public | - | |
| SimpleLinkStatementProvider | (var Record Online Bank Acc. Link) | public | - | |
| UnlinkStatementProvider | () | public | - | |
| RefreshStatementProvider | (var Record Bank Account) | public | - | |
| RenewAccessConsentStatementProvider | (var Record Bank Account) | public | - | |
| EditAccountStatementProvider | (var Record Bank Account) | public | - | |
| UpdateBankAccountLinking | () | public | - | |
| GetUnlinkedBankAccounts | (var Record Bank Account) | public | - | |
| GetLinkedBankAccounts | (var Record Bank Account) | public | - | |
| IsAutoLogonPossible | () | Boolean | public | - |
| CreateNewAccount | (Record Online Bank Acc. Link) | public | - | |
| GetOnlineFeedStatementStatus | (var Option, var Boolean) | public | - | |
| DisableStatementProviders | () | public | - | |
| CopyBankFieldsFromCompanyInfo | (Record Company Information) | public | - | |
| GetDefaultBankAccountNoForCurrency | (Code[20]) | Code[20] | public | - |
Events, 23
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterIsUpdateNeeded | (Record Bank Account, Record Bank Account, var Boolean) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Bank Account, var Record Bank Account, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Bank Account, var Record Bank Account, Integer, var Code[20]) | - |
| Integration event | OnCheckLinkedToStatementProviderEvent | (var Record Bank Account, var Boolean) | - |
| Integration event | OnCheckAutoLogonPossibleEvent | (var Record Bank Account, var Boolean) | - |
| Integration event | OnUnlinkStatementProviderEvent | (var Record Bank Account, var Boolean) | - |
| Integration event | OnMarkAccountLinkedEvent | (var Record Online Bank Acc. Link, var Record Bank Account) | - |
| Integration event | OnSimpleLinkStatementProviderEvent | (var Record Online Bank Acc. Link, var Text) | - |
| Integration event | OnLinkStatementProviderEvent | (var Record Bank Account, var Text) | - |
| Integration event | OnRefreshStatementProviderEvent | (var Record Bank Account, var Text) | - |
| Integration event | OnGetDataExchangeDefinitionEvent | (var Code[20], var Boolean) | - |
| Integration event | OnUpdateBankAccountLinkingEvent | (var Record Bank Account, var Text) | - |
| Integration event | OnGetStatementProvidersEvent | (var Record Name/Value Buffer) | - |
| Integration event | OnDisableStatementProviderEvent | (Text) | - |
| Integration event | OnRenewAccessConsentStatementProviderEvent | (var Record Bank Account, var Text) | - |
| Integration event | OnEditAccountStatementProviderEvent | (var Record Bank Account, var Text) | - |
| Integration event | OnBeforeRunContactListPage | (var Record Contact, var Boolean) | - |
| Integration event | OnValidateBankAccount | (var Record Bank Account, Text) | - |
| Integration event | OnGetBankAccount | (var Boolean, Record Bank Account, var Text) | - |
| Integration event | OnBeforeValidateIBAN | (var Record Bank Account, var Record Bank Account, var Boolean) | - |
| Integration event | OnAfterCopyBankFieldsFromCompanyInfo | (var Record Bank Account, Record Company Information) | - |
| Integration event | OnBeforeValidateCity | (var Record Bank Account, var Record Post Code, Integer, var Boolean) | - |
| Integration event | OnBeforeValidatePostCode | (var Record Bank Account, var Record Post Code, Integer, var Boolean) | - |