SIMENS

Tables (9)

BAS_PRODUCT_ORDER (PRODUCT ORDER)

  • ORDER_ID (PRIMARY KEY) — NVARCHAR(30) — Primary key — NOT NULL
  • ITEMCD (Field) — NVARCHAR(30)
  • ITEMNM (Field2) — NVARCHAR(30)

PLN_PRODUCTION_PLAN (CATH PLAN)

  • PRD_PLAN_NO (PRIMARY KEY) — varchat(30) — Primary key — NOT NULL
  • PF_ID (Field7) — INT

PLN_PRODUCTION_PLAN_DTL (CATH PLAN DETAIL)

  • PRD_PLAN_NO (PRIMARY KEY2) — varchat(30) — Primary key — NOT NULL
  • TSK_ID (Key) — INT — Primary key — NOT NULL
  • TSK_USER (Key2) — VARCHAR(20) — Primary key — NOT NULL
  • PROCESS_CODE (Field) — VARCHAR(20)
  • PROCESS_GROUP_CODE (Field2) — VARCHAR(50)
  • TASK_CODE (Field3) — VARCHAR(50)
  • TASK_GROUP_CODE (Field4)

PRDORDERH_PER (작업지시 작업자 정보)

  • ORDERKEY (PRIMARY KEY) — NVARCHAR(50) — Primary key — NOT NULL
  • TSK_USER (UNIQUE KEY) — Primary key — NOT NULL

PRDORDERH_TIME (작업지시 작업 시간 정보)

  • ORDERKEY (Key) — NVARCHAR(50) — Primary key — NOT NULL
  • TSK_USER (Field) — NVARCHAR(50)
  • ORDGRPNO (Field2) — NVARCHAR(50)
  • WSTIME (Field3) — DATETIME
  • WETIME (Field4) — DATETIME

PRSORDERH (작업지시 (개별+생산))

  • ORDERKEY (PRIMARY KEY) — NVARCHAR(50) — Primary key — NOT NULL
  • ORDGRPNO (UNIQUE KEY) — NVARCHAR(50) — Primary key
  • PRD_KEY (KEY) — NVARCHAR(50) — NOT NULL
  • PO_NO (Field) — NVARCHAR(50)
  • PRD_KEY (Field7) — NVARCHAR(50)
  • PROCESS_GROUP_CODE (Field2)
  • PROCESS_CODE (Field3)
  • TASK_GROUP_CODE (Field4)
  • TASK_CODE (Field5)
  • TASK_SEQ (Field6)
  • PARAMETER (Field9) — NVARCHAR(MAX)
  • ORDGB (Field8)

PRSWORKTR (실적관리 통합 헤더)

  • WORK_KEY (Key) — NVARCHAR(50) — Primary key — NOT NULL
  • ORDGRPNO (Field3)
  • SERIALNO (Field) — NVARCHAR(50)
  • LOTNO (Field2) — NVARCHAR(50)

PRSWORKTRD (실적관리 상세)

  • WORK_KEY (Key) — NVARCHAR(50) — Primary key — NOT NULL
  • TSK_USER (Field)
  • PARAMETER_RESULT_JSON (Field2)
  • STIME (Field3)
  • ETIME (Field4)
  • JOBGB (Field5)
  • ORDERKEY (Field6)

WORK_START (WORK START)

  • PRD_KEY (PRIMARY KEY) — NVARCHAR(50) — Primary key — NOT NULL
  • PO_NO (UNIQUE KEY) — NVARCHAR(50) — NOT NULL
  • PRD_PLAN_NO (Field2) — NAVRCHAR(50)
  • PF_ID (Field5)
  • ITEMCD (Field6)
  • ITEMNM (Field7)
  • VARIANT (Field8)
  • ETR_NO (Field9)
  • ORDERQTY (Field10)
  • PO_TYPE (Field4)
  • DEPTTYPE (Field3) — NVARCHAR(10)