Table 270 Bank Account
80 fields
| Id | Name | Type | Versions |
|---|---|---|---|
| 1 | No. | Code[20] | 17-29 |
| 2 | Name | Text[100] | 17-29 |
| 3 | Search Name | Code[100] | 17-29 |
| 4 | Name 2 | Text[50] | 17-29 |
| 5 | Address | Text[100] | 17-29 |
| 6 | Address 2 | Text[50] | 17-29 |
| 7 | City | Text[30] | 17-29 |
| 8 | Contact | Text[100] | 17-29 |
| 9 | Phone No. | Text[30] | 17-29 |
| 10 | Telex No. | Text[20] | 17-29 |
| 13 | Bank Account No. | Text[30] | 17-29 |
| 14 | Transit No. | Text[20] | 17-29 |
| 15 | Territory Code | Code[10] | 17-29 |
| 16 | Global Dimension 1 Code | Code[20] | 17-29 |
| 17 | Global Dimension 2 Code | Code[20] | 17-29 |
| 18 | Chain Name | Code[10] | 17-29 |
| 20 | Min. Balance | Decimal | 17-29 |
| 21 | Bank Acc. Posting Group | Code[20] | 17-29 |
| 22 | Currency Code | Code[10] | 17-29 |
| 24 | Language Code | Code[10] | 17-29 |
| 25 | Format Region | Text[80] | new in 23 |
| 26 | Statistics Group | Integer | 17-29 |
| 29 | Our Contact Code | Code[20] | 17-29 |
| 35 | Country/Region Code | Code[10] | 17-29 |
| 37 | Amount | Decimal | 17-29 |
| 38 | Comment | Boolean | 17-29 |
| 39 | Blocked | Boolean | 17-29 |
| 41 | Last Statement No. | Code[20] | 17-29 |
| 42 | Last Payment Statement No. | Code[20] | 17-29 |
| 43 | Pmt. Rec. No. Series | Code[20] | new in 21 |
| 54 | Last Date Modified | Date | 17-29 |
| 55 | Date Filter | Date | 17-29 |
| 56 | Global Dimension 1 Filter | Code[20] | 17-29 |
| 57 | Global Dimension 2 Filter | Code[20] | 17-29 |
| 58 | Balance | Decimal | 17-29 |
| 59 | Balance (LCY) | Decimal | 17-29 |
| 60 | Net Change | Decimal | 17-29 |
| 61 | Net Change (LCY) | Decimal | 17-29 |
| 62 | Total on Checks | Decimal | 17-29 |
| 70 | Use as Default for Currency | Boolean | new in 20 |
| 84 | Fax No. | Text[30] | 17-29 |
| 85 | Telex Answer Back | Text[20] | 17-29 |
| 91 | Post Code | Code[20] | 17-29 |
| 92 | County | Text[30] | 17-29 |
| 93 | Last Check No. | Code[20] | 17-29 |
| 94 | Balance Last Statement | Decimal | 17-29 |
| 95 | Balance at Date | Decimal | 17-29 |
| 96 | Balance at Date (LCY) | Decimal | 17-29 |
| 97 | Debit Amount | Decimal | 17-29 |
| 98 | Credit Amount | Decimal | 17-29 |
| 99 | Debit Amount (LCY) | Decimal | 17-29 |
| 100 | Credit Amount (LCY) | Decimal | 17-29 |
| 101 | Bank Branch No. | Text[20] | 17-29 |
| 102 | Text[80] | 17-29 | |
| 103 | Home Page | Text[255] | 17-29changed in 27 |
| 107 | No. Series | Code[20] | 17-29 |
| 108 | Check Report ID | Integer | 17-29 |
| 109 | Check Report Name | Text[250] | 17-29 |
| 110 | IBAN | Code[50] | 17-29 |
| 111 | SWIFT Code | Code[20] | 17-29 |
| 113 | Bank Statement Import Format | Code[20] | 17-29 |
| 115 | Credit Transfer Msg. Nos. | Code[20] | 17-29 |
| 116 | Direct Debit Msg. Nos. | Code[20] | 17-29 |
| 117 | SEPA Direct Debit Exp. Format | Code[20] | 17-29 |
| 121 | Bank Stmt. Service Record ID | RecordId | 17-29 |
| 123 | Transaction Import Timespan | Integer | 17-29 |
| 124 | Automatic Stmt. Import Enabled | Boolean | 17-29 |
| 130 | IntercompanyEnable | Boolean | new in 22 |
| 140 | Image | Media | 17-29 |
| 170 | Creditor No. | Code[35] | 17-29 |
| 1210 | Payment Export Format | Code[20] | 17-29 |
| 1211 | Bank Clearing Code | Text[50] | 17-29 |
| 1212 | Bank Clearing Standard | Text[50] | 17-29 |
| 1250 | Match Tolerance Type | Option | 17-29 |
| 1251 | Match Tolerance Value | Decimal | 17-29 |
| 1252 | Disable Automatic Pmt Matching | Boolean | new in 18 |
| 1253 | Disable Bank Rec. Optimization | Boolean | new in 23 |
| 1260 | Positive Pay Export Code | Code[20] | 17-29 |
| 1280 | Check Transmitted | Boolean | new in 24 |
| 5061 | Mobile Phone No. | Text[30] | 17-29 |