Table RELMT940
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| RELMT940 | RLT | File FMT940 (header) | A/P-A/R accounting | KDE |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| RLT0 | FILNUM+TRFNUM+SEQNUM | No | |
| RLT1 | BAN+FILNUM | Yes | |
| RLT2 | BAN+FILNUM+TRFNUM+SEQNUM | No | |
| RLT3 | BAN+TRFNUM+SEQNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BAN | Bank | BAN | [BAN]BAN0=[RLT]BAN | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[RLT]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[RLT]CREUSR | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[RLT]CUR | Block | ||||
| FCY | Site | FCY | [FCY]FCY0=[RLT]FCY | Block | ||||
| FILNUM | File number | VCR | ||||||
| REFBAN | Bank statement ID | A | 30 | |||||
| SEQNUM | Sequence number | A | 12 | |||||
| TRFNUM | Transaction number | A | 20 | |||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[RLT]UPDUSR | Other |