11111
Tables (57)
BOMR
- BOM_CD — VARCHAR2(6)
- BOM_SQ — NUMBER — NOT NULL
- EDCTS_CD — VARCHAR2(6)
- RSC_CD — VARCHAR2(6)
- PRCS_CD — VARCHAR2(6)
- UNIT — VARCHAR2(30)
- USE_CNT — NUMBER
- REMK — VARCHAR2(1000)
- USE_YN — VARCHAR2(2)
CCDS
- CCD — VARCHAR2(6)
- CCD_NM — VARCHAR2(50)
- CCD_DESCT — VARCHAR2(50)
- USE_YN — VARCHAR2(2)
CCDS_DTL
- CCD_DTL — VARCHAR2(6)
- CCD — VARCHAR2(6)
- CCD_DTL_NM — VARCHAR2(50)
- CCD_DTL_DESCT — VARCHAR2(50)
- DTL_USE_YN — VARCHAR2(2)
Common_Material_Release
- RSC_OUST_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- OUST_CNT — NUMBER
- OUST_DT — DATE
- OUST_TYP — VARCHAR2(50)
DEFECT
- DEFECT_CD — NUMBER
- EDCTS_CD — NUMBER
- RSC_CD — NUMBER
- PROCESS_CD — NUMBER
- DEFECT_NAME — VARCHAR(50)
- DEFECT_DESC — VARCHAR(100)
EDCTS
- EDCTS_CD — VARCHAR2(6)
- PRDT_NM — VARCHAR2(50)
- SPEC — VARCHAR2(50)
- UNIT — VARCHAR2(30)
- SAF_STC — NUMBER
EDCTS_IST
- EDCTS_IST_NO — VARCHAR2(30)
- EDCTS_IST_DT — DATE
- EDCTS_CD — VARCHAR2(50)
- EDCTS_LOT_NO — VARCHAR2(50)
EDCTS_OUST
- EDCTS_OUST_NO — VARCHAR2(30)
- EDCTS_CD — VARCHAR2(50)
- EDCTS_LOT_NO — VARCHAR2(50)
- EDCTS_OUST_CNT — NUMBER
- ORDER_NO — VARCHAR2(50)
EDCTS_STC
- EDCTS_LOT_NO — VARCHAR2(50)
- EDCTS_CD — VARCHAR(50)
- EDCTS_IST_NO — VARCHAR2(30)
- LOT_CNT — NUMBER
EQM
- EQM_CD — VARCHAR2(30)
- LINE_CD — VARCHAR2(30)
- PRCS_CD — VARCHAR2(30)
- PRCS_NM — VARCHAR2(30)
- EQM_FG — VARCHAR2(30)
- EQM_NM — VARCHAR2(30)
- EQM_IST_DT — DATE
- EQM_YN — VARCHAR2(10)
- CHCK_PERD — NUMBER
- MIN_TEMP — VARCHAR2(2)
- MAX_TEMP — VARCHAR2(30)
EQM_CHCK
- CHCK_CD — VARCHAR2(30)
- EQM_CD — VARCHAR2(30)
- EQM_NM — VARCHAR2(30)
- CHCK_DT — DATE
- DISPO_MATTER — VARCHAR2(10)
- DISPO_CTNT — VARCHAR2(1000)
- JDGMNT — VARCHAR2(10)
- CHCK_PSCH — VARCHAR2(30)
EQM_CHECK
- CHCK_CD — VARCHAR2(30)
- EQM_CD — VARCHAR2(30)
- EQM_NM — VARCHAR2(30)
- CHCK_DT — DATE
- DISPO_MATTER — VARCHAR2(10)
- DISPO_CTNT — VARCHAR2(1000)
- JDGMNT — VARCHAR2(10)
- CHCK_PSCH — VARCHAR2(30)
EQM_IMAGE
- EQM_CD — VARCHAR2(30)
- PRCS_CD — VARCHAR2(30)
- EQM_IMG — VARCHAR2(100)
EQM_LINE
- LINE_CD — VARCHAR2(30)
- LINE_NM — VARCHAR2(30)
- EQM_PSCH — VARCHAR2(30)
- UPH_CNT — NUMBER
- USE_YN — VARCHAR(10)
EQM_OPR
- NOPR_CD — VARCHAR2(30)
- EQM_CD — VARCHAR2(30)
- FR_DT — DATE
- TO_DT — DATE
- OPERT_CTNT — VARCHAR2(30)
FP
- FP_CD — INT
- WORKER — VARCHAR2(50)
- START_DT — DATE
- END_DT — DATE
- DEFECT_QTY — NUMBER
- PROD_QTY — NUMBER
- REMARKS — VARCHAR2(100)
- PROD_ORDER_DETAIL — VARCHAR2(100)
- EDCTS_CD — VARCHAR2(50)
- PROCESS_CD — VARCHAR2(200)
INDICA
- INDICA_DT — PRIMARY
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- PREF_RANK — NUMBER
- NOW_ST — VARCHAR2(10)
INDICA_DTL
- PROD_ORDER_DETAIL — VARCHAR2(100)
- INDICA_DT — VARCHAR2(50)
- PLAN_CD — VARCHAR2(50)
- BOM_CD — VARCHAR2(6)
- ORDER_CNT — NUMBER
- WK_FR_DT — DATE
- LINE_CD — VARCHAR2(50)
- LINE_PSCH — VARCHAR2(50)
- INDICA_CNT — NUMBER
- EDCTS_CD — VARCHAR2(50)
ISSUE
- EDCTS_OUST_NO — VARCHAR2(30)
- EDCTS_CD — VARCHAR2(50)
- EDCTS_LOT_NO — VARCHAR2(50)
- EDCTS_OUST_CNT — NUMBER
- ORDER_NO — VARCHAR2(50)
Material_Inventory
- RSC_CD — VARCHAR2(50)
- RSC_STC — NUMBER
- AVAL_STC — NUMBER
Material_Inventory_History
- CLS_YYMM — VARCHAR2(20)
- RSC_CD — VARCHAR2(20)
- IST_CNT — NUMBER
- OUST_CNT — NUMBER
- PRVMM_STC — NUMBER
Material_Release_Details
- RSC_OUST_CD — VARCHAR2(50)
- LOT_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- OUST_CNT — NUMBER
ORDER_SHEET
- ORDER_NO — VARCHAR2(30)
- EDCTS_CD — VARCHAR(50)
- VEND_CD — VARCHAR2(6)
- ORDER_DT — DATE
- VEND_NM — VARCHAR2(50)
- PRDT_NM — VARCHAR2(50)
- ORDER_CNT — NUMBER
- PROG_APPE — VARCHAR2(10)
- PAPRD_DT — DATE
PLAN
- PLAN_CD — VARCHAR2(50)
- PAPRD_DT — DATE
- NOW_ST — VARCHAR2(10)
- PLAN_DT — DATE
- ORDER_NO — VARCHAR2(50)
PLAN_DTL
- PREF_RANK — NUMBER
- LINE_CD — VARCHAR2(50)
- PLAN_CD — VARCHAR2(50)
- EDCTS_CD — VARCHAR(50)
- ORDER_CNT — NUMBER
- INDICA_CNT — NUMBER
- WK_TO_DT — DATE
- WK_FR_DT — DATE
PRCS
- PRCS_CD — VARCHAR2(50)
- EQM_CD — VARCHAR2(30)
- PRCS_NM — VARCHAR2(50)
- PRCS_FG — VARCHAR2(50)
- PRCS_CTNT — VARCHAR2(2000)
PRCS_PROG
- PRCS_CD — VARCHAR2(50)
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- WK_FR_TM — DATE
- WK_TO_TM — DATE
- INDICA_CNT — NUMBER
- LINE_CD — VARCHAR2(50)
- PREF_RANK — NUMBER
PRODUCTION_PLANNING
- PLAN_CD — VARCHAR2(50)
- PAPRD_DT — DATE
- NOW_ST — VARCHAR2(10)
- PLAN_DT — DATE
- ORDER_NO — VARCHAR2(50)
PROD_INSTR_DETAIL
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- BOM_CD — VARCHAR2(6)
- ORDER_CNT — NUMBER
- WK_FR_DT — DATE
- LINE_CD — VARCHAR2(50)
- LINE_PSCH — VARCHAR2(50)
- INDICA_CNT — NUMBER
- EDCTS_CD — VARCHAR2(50)
PROD_ORDER
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- PREF_RANK — NUMBER
- NOW_ST — VARCHAR2(10)
PROD_PLAN_DETAIL
- PREF_RANK — NUMBER
- LINE_CD — VARCHAR2(50)
- PLAN_CD — VARCHAR2(50)
- EDCTS_CD — VARCHAR(50)
- ORDER_CNT — NUMBER
- INDICA_CNT — NUMBER
- WK_TO_DT — DATE
- WK_FR_DT — DATE
RECEIPT
- EDCTS_IST_NO — VARCHAR2(30)
- EDCTS_IST_DT — DATE
- EDCTS_CD — VARCHAR2(50)
- EDCTS_LOT_NO — VARCHAR2(50)
RSC
- RSC_CD — VARCHAR2(6)
- VEND_CD — VARCHAR2(6)
- RSC_NM — VARCHAR2(50)
- RSC_SPEC — VARCHAR2(50)
- MNG_UNIT — VARCHAR2(30)
- RSC_TYP — VARCHAR2(50)
- SAF_STC — NUMBER
- USE_YN — VARCHAR2(2)
RSC_INSP
- INSP_CD — NUMBER
- INSP_DT — DATE
- INSP_TSTR — VARCHAR2(30)
- stocking_date — DATE
RSC_INSP_DTL
- RSC_INSP_CD — VARCHAR2(6)
- RSC_CD — VARCHAR2(50)
- ORDER_CD — VARCHAR2(50)
- INSP_CNT — NUMBER
- INSP_FAIL_CNT — NUMBER
- defect_number — VARCHAR2(50)
- defect_content — VARCHAR2(50)
RSC_IST
- IST_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(20)
- IST_DT — DATE
- IST_CNT — NUMBER
- IST_TYP — VARCHAR2(50)
RSC_LOT
- PRC_LOT_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- IST_CD — VARCHAR2(50)
- RSC_INSP_CD — VARCHAR2(50)
- ORDR_CD — VARCHAR2(50)
- LOT_CNT — NUMBER
- LOT_RMN_CNT — NUMBER
- EXP_DT — DATE
RSC_ORDR
- ORDR_CD — VARCHAR2(50)
- VEND_CD — VARCHAR2(50)
- ORDR_REQ_DT — DATE
RSC_ORDR_DTL
- ORDR_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- ORDR_CNT — NUMBER
- RMN_CNT — NUMBER
- PAPRD_CMND_DT — DATE
RSC_OUST
- RSC_OUST_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- OUST_CNT — NUMBER
- OUST_DT — DATE
- OUST_TYP — VARCHAR2(50)
RSC_OUST_STL
- RSC_OUST_CD — VARCHAR2(50)
- LOT_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- OUST_CNT — NUMBER
RSC_STC
- RSC_CD — VARCHAR2(50)
- RSC_STC — NUMBER
- AVAL_STC — NUMBER
RSC_STC_HIST
- CLS_YYMM — VARCHAR2(20)
- RSC_CD — VARCHAR2(20)
- IST_CNT — NUMBER
- OUST_CNT — NUMBER
- PRVMM_STC — NUMBER
STOCK
- EDCTS_LOT_NO — VARCHAR2(50)
- EDCTS_CD — VARCHAR(50)
- EDCTS_IST_NO — VARCHAR2(30)
- LOT_CNT — NUMBER
VEND
- VEND_CD — VARCHAR2(6)
- VEND_NM — VARCHAR2(50)
- BINZO — VARCHAR2(20)
- TELNO — VARCHAR2(20)
- REMK — VARCHAR2(1000)
- VEND_TYP — VARCHAR2(50)
bill_of_materials
- BOM_CD — VARCHAR2(6)
- BOM_SQ — NUMBER — NOT NULL
- EDCTS_CD — VARCHAR2(6)
- RSC_CD — VARCHAR2(6)
- PRCS_CD — VARCHAR2(6)
- UNIT — VARCHAR2(30)
- USE_CNT — NUMBER
- REMK — VARCHAR2(1000)
- USE_YN — VARCHAR2(2)
material_lot_management
- PRC_LOT_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- IST_CD — VARCHAR2(50)
- RSC_INSP_CD — VARCHAR2(50)
- ORDR_CD — VARCHAR2(50)
- LOT_CNT — NUMBER
- LOT_RMN_CNT — NUMBER
- EXP_DT — DATE
material_management
- RSC_CD — VARCHAR2(6)
- VEND_CD — VARCHAR2(6)
- RSC_NM — VARCHAR2(50)
- RSC_SPEC — VARCHAR2(50)
- MNG_UNIT — VARCHAR2(30)
- RSC_TYP — VARCHAR2(50)
- SAF_STC — NUMBER
- USE_YN — VARCHAR2(2)
material_order
- ORDR_CD — VARCHAR2(50)
- VEND_CD — VARCHAR2(50)
- ORDR_REQ_DT — DATE
material_order_details
- ORDR_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(50)
- ORDR_CNT — NUMBER
- RMN_CNT — NUMBER
- PAPRD_CMND_DT — DATE
material_warehousing
- IST_CD — VARCHAR2(50)
- RSC_CD — VARCHAR2(20)
- IST_DT — DATE
- IST_CNT — NUMBER
- IST_TYP — VARCHAR2(50)
material_warehousing_inspection
- INSP_CD — NUMBER
- INSP_DT — DATE
- INSP_TSTR — VARCHAR2(30)
- stocking_date — DATE
material_warehousing_inspection_defect
- INF_CD — VARCHAR2(20)
- RSC_CD — VARCHAR2(6)
- INSP_CD — VARCHAR2(50)
- ORDR_CD — VARCHAR2(50)
- INF_CNT — NUMBER
material_warehousing_inspection_details
- RSC_INSP_CD — VARCHAR2(6)
- RSC_CD — VARCHAR2(50)
- ORDER_CD — VARCHAR2(50)
- INSP_CNT — NUMBER
- INSP_FAIL_CNT — NUMBER
- defect_number — VARCHAR2(50)
- defect_content — VARCHAR2(50)
process_control
- PRCS_CD — VARCHAR2(50)
- PRCS_NM — VARCHAR2(50)
- PRCS_FG — VARCHAR2(50)
- PRCS_CTNT — VARCHAR2(2000)
process_defect_details
- PRCS_CD — VARCHAR2(50)
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- - — -생산계획코드
- INFER_NM — VARCHAR2(50)
progress_management
- PRCS_CD — VARCHAR2(50)
- INDICA_DT — DATE
- PLAN_CD — VARCHAR2(50)
- WK_FR_TM — DATE
- WK_TO_TM — DATE
- PRCS_PSCH — VARCHAR2(30)
- INDICA_CNT — NUMBER
- - — -
- PROD_CTN — NUMBER
- LINE_CD — VARCHAR2(50)
- PREF_RANK — NUMBER