Table TABFILBAN
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TABFILBAN | TFB | Bank file definitions | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TFB0 | COD+BAN+RECTYP+ORDNUM+LEG+NUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BAN | Bank | BAN | [BAN]BAN0=[TFB]BAN | Block | ||||
| BANLEG | Bank - Legislation | A | 25 | |||||
| CND | Line condition | AFR | 250 | |||||
| COD | Bank file | A | 10 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | 99 | CUR | [TCU]TCU0=[TFB]CUR | Other | |||
| CURCTL | Currency | M | 15 | 3684 | ||||
| CURMULT | Multicurrency | M | 4 | 1 | ||||
| DES | Description | DES | ||||||
| DESLIN | Title | DES | ||||||
| DESSHO | Short description | SHO | ||||||
| DESTRA | Description | AX3 | ||||||
| ENDSEP | End separator | A | 250 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FILEXO | File extension | A | 4 | |||||
| FILFMT | Character coding | M | 10 | 945 | ||||
| FILREF | File extension | A | 2 | |||||
| FLDDEL | Field delimiter | A | 1 | |||||
| FLDSEP | Field separator | A | 8 | |||||
| FLDTYP | Field type | M | 15 | 681 | ||||
| FMT | Format | M | 15 | 3627 | ||||
| FORCND | Condition | AFR | 40 | |||||
| FRM | Formula | AFR | 250 | |||||
| FRMGRP | Group | M | 4 | 1 | ||||
| LEG | Legislation | ADI | [ADI]CODE=909;LEG | Block | ||||
| LNG | Length | C | 3 | |||||
| NATPAY | File family | M | 5 | 2604 | ||||
| NUM | Order no. | C | 2 | |||||
| OBY | Mandatory | M | 4 | 1 | ||||
| ORDNUM | Order | C | 3 | |||||
| RECTYP | Record type | M | 15 | 656 | ||||
| SHOTRA | Short description | AX1 | ||||||
| STRSEP | Start separator | A | 250 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |