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