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 |