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)