Table BANK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| BANK | BAN | Bank accounts | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| BAN0 | BAN | No | |
| BAN1 | CPY+FLDFIFCP+FLDSDA | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ABANUM | ABA number | A | 9 | KUS | ||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=13;ACCCOD;[V]GSUPCLE | Block | ||||
| ACS | Access code | ACS | [ACS]ACS0=[BAN]ACS | Block | ||||
| ADDLIG | Address | 3 | A | 35 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BACS | BACS reference | A | 30 | KUK | ||||
| BAN | Code | BAN | [BAN]BAN0=[BAN]BAN | Delete | ||||
| BANACC | Account | GAC | [GAC]GAC0=COA;BANACC | Block | ||||
| BANBPR | BP code | BPR | [BPR]BPR0=[BAN]BANBPR | Block | ||||
| BANCSH | Bank or cash | M | 15 | 653 | ||||
| BANFIL | Bank file | A | 10 | KPO | ||||
| BANTRA | Bank transit | A | 9 | CHQMG | ||||
| BANTRM | Bank terms | A | 10 | |||||
| BICCOD | BIC code | A | 11 | |||||
| BIDEXS | Bank account no. | BID | ||||||
| BIDNUM | Bank acct. number | BID | ||||||
| BNKPROBALCTL | Balance control | M | 4 | 1 | ||||
| BSIREFBAN | Bank statement ID | A | 50 | BSI | ||||
| BVRCUSTID | Customer ID ISR | A | 12 | KSW | ||||
| BVRNUM | ISR customer no. | A | 11 | KSW | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CFOEXD | Cash excluded | M | 4 | 1 | CFOM | |||
| CHGDAT | Euro changeover date | D | ||||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CHKACC | Checking account | A | 17 | CHQMG | ||||
| CHKCOD | Reconciliation | A | 5 | |||||
| CHKFMT | Format | M | 15 | 2760 | CHQMG | |||
| CHQTYPFLG | O/L check remit. | M | 4 | 1 | ||||
| COA | Chart code | COA | [COA]COA0=[BAN]COA | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[BAN]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CRN | Site tax ID no. | CRT | ||||||
| CRY | Country | CRY | [TCY]TCY0=[BAN]CRY | Block | ||||
| CRYNAM | Country name | A | 30 | |||||
| CTY | City | CTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[BAN]CUR | Block | ||||
| CUREXS | Expense currency | CUR | [TCU]TCU0=[BAN]CUREXS | Block | ||||
| DEPRAT | Early discount rate | RAT | ||||||
| DES | Description | DES | ||||||
| DESSHO | Short description | SHO | ||||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[BAN]DIE | Block | ANA | |||
| EXPNUM | Export number | L | 8 | |||||
| FAX | Fax | TEL | ||||||
| FCY | Site | FCY | [FCY]FCY0=[BAN]FCY | Block | ||||
| FILEXT | File extension | A | 3 | |||||
| FLDFIFCP | FIFO conversion process | M | 4 | 1 | FIFRC | |||
| FLDSDA | Start date | D | FIFRC | |||||
| FRMDUDFLG | Deposit by due date | M | 4 | 1 | ||||
| GTE | Entry type | 10 | GTE | [GTE]GTE0=GTE(indice);[V]GSUPCLE | Block | |||
| HMRC | HMRC refunds | 5 | M | 4 | 1 | KUK | ||
| IBACOD | IBAN code | A | 34 | |||||
| INPAYTRA | Incoming payment transaction | A | 10 | REGBC | ||||
| JOU | Journal | 10 | JOU | [JOU]JOU0=JOU(indice);[V]GSUPCLE | Block | |||
| JOUTYP | Journal type | 10 | M | 15 | 660 | |||
| MCRPRT | MICR printing | M | 4 | 1 | CHQMG | |||
| NBRJOU | Number of journals | C | 2 | |||||
| NXTSEQ | Next check no. | A | 15 | CHQMG | ||||
| OLDCUR | Old currency | A | 3 | |||||
| OUTPAYTRA | Outgoing payment transaction | A | 10 | REGBC | ||||
| PAB1 | Paying bank 1 | A | 30 | |||||
| PAB2 | Paying bank 2 | A | 30 | |||||
| PABDUDFLG | Payment order by due date | M | 4 | 1 | ||||
| PAYTPY | Provisional payment | MD1 | ||||||
| POSCOD | Postal code | POS | ||||||
| POSPAYFIL | Bank file | A | 10 | CHQMG | ||||
| QRCIBACOD | QR-IBAN | A | 34 | KSW | ||||
| RECCPT | Addi recording | M | 4 | 1 | ||||
| ROLLNUM | B/Soc roll no | A | 30 | KUK | ||||
| SAT | State | SAT | ||||||
| SCTPROLOT | Processing by batch | M | 4 | 1 | ||||
| SENNUM | Credit transfer issuer no. | A | 50 | |||||
| SENNUM2 | Direct debit issuer no. | A | 20 | |||||
| SGLIDACH | ACH individual ID | A | 15 | KUS | ||||
| SGLIDMTS | MTS individual ID | A | 15 | KUS | ||||
| SRTCOD | Sort code | 5 | A | 8 | KUK | |||
| SUN | Service reference number | A | 6 | KUK | ||||
| TEL | Telephone | TEL | ||||||
| TREACC | Account | 10 | GAC | [GAC]GAC0=COA;TREACC(indice) | Block | |||
| TRECOD | Treasury interface | A | 12 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WEB | Internet address | A | 50 |