Table RBKBELHEA
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
RBKBELHEA | RBH | Belgian bank statement | A/P-A/R accounting | KBE |
Key | Description | Duplicates | Activity code |
---|---|---|---|
RBH0 | RBKNUM | No | |
RBH1 | ACCNUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCDES | Account description | NAM | ||||||
ACCNAM | Account holder name | NAM | ||||||
ACCNUM | Unique number | UNQ | ||||||
AMTCDT | Credit T/O | MD1 | ||||||
AMTDEB | Debit T/O | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BAN | Bank | BAN | [BAN]BAN0=[RBH]BAN | Block | ||||
BICCODBAN | Bank BIC code | A | 11 | |||||
BIDNUMBAN | Bank account no. | BID | ||||||
CPY | Company | CPY | [CPY]CPY0=[RBH]CPY | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation author | AUS | [AUS]CODUSR=[RBH]CREUSR | Other | ||||
CUR | Currency | CUR | [TCU]TCU0=[RBH]CUR | Block | ||||
DESTNAM | Recipient name | NAM | ||||||
EXTNUM | Sequence | C | 3 | |||||
FCY | Site | FCY | [FCY]FCY0=[RBH]FCY | Block | ||||
FILNAM | File name | A | 20 | |||||
FILTYP | File format | M | 8 | 3622 | ||||
FRETXT | Additional info | 10 | A | 80 | ||||
IDENTNUM | Identification no. | A | 20 | |||||
NEWAMT | New balance | MD1 | ||||||
NEWDAT | New balance date | D | ||||||
NEWSNS | New balance sign | M | 10 | 626 | ||||
OLDAMT | Previous balance | MD1 | ||||||
OLDDAT | Previous balance date | D | ||||||
OLDSNS | Previous balance sign | M | 10 | 626 | ||||
RBKNUM | Statement number | VCR | ||||||
RELTYP | Note type | M | 15 | 694 | ||||
STATUT | Status | M | 15 | 509 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | AUS | [AUS]CODUSR=[RBH]UPDUSR | Other |