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 |