LotSts

Tables (4)

LOTREMEMBER (롤백 을 위한 테이블)

  • companyCode — VARCHAR — Primary key — NOT NULL
  • plant — VARCHAR — Primary key — NOT NULL
  • lotNumber — VARCHAR — Primary key — NOT NULL
  • areaId — varchar — Primary key — NOT NULL
  • matLotNumber — VARCHAR
  • qty — NUMBER

PrdLotStock (완제품 창고)

  • companyCode — varchar — Primary key — NOT NULL
  • plant — varchar — Primary key — NOT NULL
  • prodId — varchar — Primary key — NOT NULL
  • prodName — varchar
  • areaId — varchar
  • inQty — double
  • outQty — double
  • totalQty — double
  • createDt — datetime
  • createUserId — varchar
  • createUserName — varchar
  • modifiedDt — datetime
  • modifiedUserId — varchar
  • modifiedUserName — varchar

PrdLotSts (실적 생성)

  • companyCode — varchar — Primary key — NOT NULL
  • plant — varchar — Primary key — NOT NULL
  • lotNumber — varchar — Primary key — NOT NULL
  • areaId — varchar — Primary key — NOT NULL
  • lotState — varchar
  • prodId — varchar
  • prodName — varchar
  • qty — double
  • qtyUnit — VARCHAR
  • createDt — datetime
  • createUerId (createUserId) — varchar
  • createUserName — varchar
  • modifiedDt — datetime
  • modifiedUserId — varchar
  • modifiedUserName — varchar

PrdShipment (완제품 출하)

  • companyCode (comapnyCode) — varchar — Primary key — NOT NULL
  • plant — varchar — Primary key — NOT NULL
  • prodId — varchar — Primary key — NOT NULL
  • prodName — varchar
  • areaId — varchar
  • outQty — double
  • createDt — datetime
  • createUserId — varchar
  • createUserName — varchar
  • modifyedDt (modifiedDt) — datetime
  • modifyedUserId (modifiedUserId) — varchar
  • modifyedUserName (modifiedUserName) — varchar