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