The V1URDLOG table is used for ANURDLOG and HSURDFIL views. The following table describes the columns in the V1URDLOG table:
Column | Type | Length | Decimal | Domain |
---|---|---|---|---|
MCRECID | BINARY | 4 | 0 | machine/company ID |
FILRECID | BINARY | 9 | 0 | file ID |
FILLIB | CHARACTER | 128 | 0 | file library |
FILTYPE | CHARACTER | 4 | 0 | file type |
FILNAME | CHARACTER | 128 | 0 | file name |
FILVER | BINARY | 3 | 0 | file version |
RECFMT | CHARACTER | 10 | 0 | format of record |
MACHINEID | CHARACTER | 10 | 0 | machine identifier |
CDSOC | CHARACTER | 10 | 0 | company name |
DTCALC | CHARACTER | 8 | 0 | last tecalculation date |
FLDNAME | CHARACTER | 128 | 0 | field name |
FLDDISPL | BINARY | 5 | 0 | field position |
FLDVAL | CHARACTER | 32 | 0 | field value |
DATEFMT | CHARACTER | 10 | 0 | date format |
MSGMNE | CHARACTER | 5 | 0 | message type |
MSGID | CHARACTER | 7 | 0 | message code |
MSGDESC | CHARACTER | 132 | 0 | message description |
OCCURS | CHARACTER | 9 | 0 | OCCURS |
GRAVITY | CHARACTER | 2 | 0 | severity |
FLSTOP | CHARACTER | 1 | 0 | stop elaboration flag |
TRCIMG | CHARACTER | 512 | 0 | record image |
TRCRRN | BINARY | 9 | 0 | internal RRN |
IMPDTTM | TIMESTAMP | 26 | 0 | logging date/time |