Table TABFILBAN
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TABFILBAN | TFB | Bank file definitions | Payroll |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TFB0 | COD+BAN+RECTYP+ORDNUM+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 | ||||
| CND | Condition | AFR | 250 | |||||
| COD | Bank file | A | 10 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CURMULT | Multi-currency | M | 4 | 1 | ||||
| DES | Title | DES | ||||||
| DESLIN | Title | DES | ||||||
| DESSHO | Short title | SHO | ||||||
| ENDSEP | Separator to | A | 250 | |||||
| EXPNUM | Export number | L | 8 | |||||
| FILEXT | File extension | A | 4 | |||||
| FILREF | File prefix | A | 2 | |||||
| FLDTYP | Field type | M | 15 | 681 | ||||
| FMT | Format | M | 15 | 2532 | ||||
| FORCND | Condition | AFR | 30 | |||||
| FRM | Formula | AFR | 80 | |||||
| LNG | Length | C | 3 | |||||
| NUM | Order no. | C | 2 | |||||
| OBY | Mandatory | M | 4 | 1 | ||||
| ORDNUM | Order | C | 3 | |||||
| RECTYP | Record type | M | 15 | 656 | ||||
| STRSEP | Separator from | A | 250 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |