WMS

Tables (3)

BaseEntitiy (Untitled3)

  • createdDateTime (Field) — LocalDateTime
  • creater (Field2) — varchar(20)
  • modifiedDateTime (Field3) — LocalDateTime
  • modifier (Field4) — varchar(20)

Inbound Detail (Untitled2)

  • inboundDetailId (Key) — varchar(100) — Primary key — NOT NULL
  • inboundOrderNumber (Key2) — long(20) — Primary key — NOT NULL
  • inboundOrderSequence (Key3) — varchar(20) — Primary key — NOT NULL
  • materialCode (Field) — varchar(100)
  • plantCode (Field2) — varchar(100)
  • Field3

Inbound Master (Untitled)

  • inboundId (Key) — varchar(100) — Primary key — NOT NULL
  • inboundOrderNumber (Key2) — long(20) — Primary key — NOT NULL
  • inboundOrderSequence (Key4) — varchar(20) — Primary key — NOT NULL
  • materialDocumentNumber (Key3) — varchar(20) — Primary key — NOT NULL
  • inboundType (Field2) — varchar(20)
  • supplierName (Field) — varchar(20)
  • supplierCode (Field3) — varchar(20)
  • requester (Field4) — varchar(30)
  • requesterEmployeeNumber (Field5) — varchar(30)
  • inboundProcessingType (Field6) — varchar(30)
  • Field7