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