Table RELBANK
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| RELBANK | RBK | Bank account statement | A/P-A/R accounting |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| RBK0 | BAN+RBKNUM+RECTYP+RBKLIN | No | |
| RBK1 | BAN+RECTYP+OPEDAT+RBKNUM+RBKLIN | No | |
| RBK2 | BAN+RBKNUM | Yes | |
| RBK3 | BAN+NUMRBK | No | |
| RBK4 | NUMRBK | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTCUR | Amount in currency | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BAN | Code | BAN | [BAN]BAN0=[RBK]BAN | Block | ||||
| BANCIB | Interbank code | ADI | [ADI]CODE=306;BANCIB | Block | ||||
| BSILIN | Line number | C | 3 | BSI | ||||
| BSISTM | Bank statement | A | 30 | BSI | ||||
| CHK | Reconciliation | A | 5 | |||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[RBK]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[RBK]CUR | Block | ||||
| DATCHK | Reconciliation date | D | ||||||
| DATXTR | Extraction date | D | ||||||
| DES | Description | DES | ||||||
| ENTNUM | Entry number | A | 8 | |||||
| INDCOM | Commission level | M | 4 | 1 | ||||
| INDUVY | Unavailable | M | 4 | 1 | ||||
| NUMRBK | Internal number | UNQ | ||||||
| OPEDAT | Date | D | ||||||
| ORI | Source | M | 15 | 694 | ||||
| RBKLIN | Number | L | 8 | |||||
| RBKNUM | Statement number | VCR | ||||||
| RECTYP | Record type | M | 15 | 656 | ||||
| REF | Reference | REF | ||||||
| RENREJ | Reject reason | ADI | [ADI]CODE=305;RENREJ | Block | ||||
| SNS | Sign | C | 2 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[RBK]UPDUSR | Other | ||||
| VALDAT | Value date | D |