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 |