Table RBKBELDET
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
RBKBELDET | RBD | Belgian bank statement detail | A/P-A/R accounting | KBE |
Key | Description | Duplicates | Activity code |
---|---|---|---|
RBD0 | RBKNUM+RBKLIN | No | |
RBD1 | FRMNUM | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ACCBAN | Bank account | GAC | [GAC]GAC0=COA;ACCBAN | Block | ||||
ACCDAT | Accounting date | D | ||||||
ACCTMP | Temporary account | GAC | [GAC]GAC0=COA;ACCTMP | Block | ||||
AMTCUR | Amount in currency | MD1 | ||||||
AUUID | Single identifier | AUUID | ||||||
BPRNAM | Company name | NAM | ||||||
BPRNUM | BP code | BPR | [BPR]BPR0=[RBD]BPRNUM | Block | ||||
COA | Chart code | COA | [COA]COA0=[RBD]COA | Block | ||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | User | AUS | [AUS]CODUSR=[RBD]CREUSR | Other | ||||
FCYLIN | Site | FCY | [FCY]FCY0=[RBD]FCYLIN | Block | ||||
FRMNUM | Slip no. | VCR | ||||||
PAYTYP | Payment transaction | TPY | [TPY]TPY0=PAYTYP;[V]GSUPCLE | Block | ||||
PYHNUM | Payment number | VCR | ||||||
RBKLIN | Statement line number | L | 8 | |||||
RBKNUM | Statement number | VCR | ||||||
SNS | Sign | M | 15 | 661 | ||||
STATUT | Status | M | 15 | 509 | ||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | User | AUS | [AUS]CODUSR=[RBD]UPDUSR | Other | ||||
VALDAT | Value date | D | ||||||
VALFLG | To validate | M | 4 | 1 |