test
Tables (3)
ZT_LOT_HIST (lot history)
- MANDT — CLNT — Primary key — NOT NULL
- KEYZ1 (PAYMENT LOT) — CHAR — Primary key — NOT NULL
- SEQ (SEQUENCE) — NUM — Primary key — NOT NULL
- CDATE (CREATE DATE) — DATS — NOT NULL
- CNAME (USER NAME) — CHAR
- CTIME (TIME) — TIMS — NOT NULL
- COMMENT — CHAR
- REASON_ID — INT — Foreign key → ZT_LOT_REASON.Id — NOT NULL
- RESOLUTION_ID — INT — Foreign key → ZT_LOT_RESOL.Id — NOT NULL
- MDATE (MODIFY DATE) — DATS
- MTIME (MODIFY TIME) — TIMS
- MNAME (Field)
ZT_LOT_REASON (lot reason master)
- Id (SEQUENCE ID) — INT — Primary key — NOT NULL
- REASON_TXT (REASON TEXT) — CHAR — NOT NULL
- LOT_TYPE (LOT TYPE) — CHAR — NOT NULL
ZT_LOT_RESOL (lot resolution master)
- Id (SEQUENCE ID) — INT — Primary key — NOT NULL
- RESOLU_TXT (RESOLUTION TEXT) — CHAR — NOT NULL
- LOT_TYPE (LOT TYPE) — CHAR — NOT NULL