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