CSG_C2.0_PJT

테이블 (5)

CSG설비마스터 (csg_equip_master)

  • werks (plant_code) — 기본 키 — NOT NULL
  • arbpl (workcenter_code) — 기본 키 — NOT NULL
  • equnr (mac_id) — 기본 키 — NOT NULL
  • line (line_code)
  • eqtyp
  • eqart
  • zz_eq_stlv1
  • zz_eq_stlv2
  • zstat
  • txt04
  • txt30
  • tplnr
  • submt
  • zz_eq_stn_type
  • zz_eq_stn_qty
  • zz_eq_lay_qty
  • zz_eq_inj_qty
  • Field2 (zz_eq_scr_qty)
  • Field (aps_yn)

MST 설비마스터 (mst_equip_master)

  • Key (plant_code) — 기본 키 — NOT NULL
  • Field (company_code)
  • Field3 (plantbd_code)
  • Field4 (workcenter_code)
  • Field (line)
  • Field2 (functional_location_code)
  • Field5 (equipment_code)
  • Field6 (equipment_desc)
  • Field7 (equipment_type)
  • Field8 (prt)
  • Field (station_type)
  • Field2 (station_qty)
  • Field3 (dispatching_mode)
  • Field4 (use_yn)

기능위치 (csg_functional_location)

  • plant_code (werks) — 기본 키 — NOT NULL
  • functional_location_desc (pltxt)
  • functional_location_level (level)
  • functional_location_level_code (lvcd)
  • functional_location_level_desc (lvtxt)
  • functional_location (tplma)
  • workcenter_code (arbpl)
  • lvorm
  • create_date (aedat)
  • create_time (aezet)
  • use_yn

워크센터 마스터 (csg_workcenter_master)

  • Key (key_code) — 기본 키 — NOT NULL
  • sync_version — NOT NULL
  • plant_code (werks)
  • workcenter_code (arbpl)
  • workcenter_desc (ktext) — NOT NULL
  • wc_stime (begzt)
  • wc_etime (endzt)
  • break_time (pause)
  • storage_location (stand)
  • factory_code (ortgr)
  • txt
  • use_yn

워크센터 마스터 (mst_workcenter_master)

  • Key (key_code) — 기본 키 — NOT NULL
  • company — NOT NULL
  • plant (plant_code)
  • plant_desc
  • factory (factory_code) — NOT NULL
  • factory_desc
  • plantbd (plantbd_code)
  • break_time (plantbd_desc)
  • work_center (workcenter_code(arbpl))
  • work_center_desc (workcenter_desc)
  • work_center_start_time (wc_stime)
  • work_center_end_time (wc_etime)
  • break_time
  • storage_location (storage_location_code)
  • flow_sep_yn