erd

Tables (32)

BCC300 (공장정보)

  • fac_cd (공장정보) — Primary key — NOT NULL

BCV100 (거래처정보)

  • cust_cd (거래처코드) — Primary key — NOT NULL

DMA100 (품목정보)

  • itm_id (Key) — Primary key — NOT NULL

DMA210 (공장별품목기준)

  • fac_cd (공장코드) — Primary key — NOT NULL
  • itm_id (품목ID) — Primary key — NOT NULL

DMA300 (품목별 사급업체)

  • cust_cd (사급업체) — Primary key — NOT NULL
  • itm_id (품목ID) — Primary key — NOT NULL
  • fac_cd (공장코드) — Primary key — NOT NULL
  • st_dt (적용시작일) — Primary key — NOT NULL

DMB100 (M-BOM)

  • itm_pid (모품목ID) — Primary key — NOT NULL
  • itm_cid (자품목ID) — Primary key — NOT NULL
  • reg_id (seq) — Primary key — NOT NULL

DMB800_A (BOM전개-소요량)

  • top_itm_id (제품id) — Primary key — NOT NULL
  • fac_cd (공장코드) — Primary key — NOT NULL
  • itm_cid (자품목id) — Primary key — NOT NULL

GAZ500 (근무일력)

  • bs_cd (사업장코드) — Primary key — NOT NULL
  • work_dt (기준일자) — Primary key — NOT NULL

LEA100 (입고정보)

  • in_no (입고번호) — Primary key — NOT NULL
  • in_sq (입고순번) — Primary key — NOT NULL

LEB100 (출고정보)

  • out_no (출고번호) — Primary key — NOT NULL
  • out_sq (출고순번) — Primary key — NOT NULL

MMA150 (구매의뢰상세)

  • req_no (구매의뢰번호) — Primary key — NOT NULL
  • req_sq (구매의뢰순번) — Primary key — NOT NULL

MMP200_A (사내 포장비등 단가정보)

  • fac_cd (공장) — Primary key — NOT NULL
  • itm_id (품목ID) — Primary key — NOT NULL
  • cust_cd (거래처코드) — Primary key — NOT NULL

MMR410_R (MRP산출)

  • mrp_no (Key) — Primary key — NOT NULL

MMR411_R (MRP대상 월계획량)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • plan_mon (생산년월) — Primary key — NOT NULL
  • p_itm_id (제품품목ID) — Primary key — NOT NULL

MMR412_R (MRP산출현재고)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • itm_id (자재품목ID) — Primary key — NOT NULL

MMR415_R (MRP산출상세)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • mrp_sq (MRP순번) — Primary key — NOT NULL

MMR421_R (월간작업일수)

  • mrp_no (Mrp번호) — Primary key — NOT NULL
  • plan_mon (계획월) — Primary key — NOT NULL

MMR422_R (주차작업일수)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • sq (순번) — Primary key — NOT NULL

MMR423_R (주차(일)별 생산계획량)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • sq (순번) — Primary key — NOT NULL
  • p_itm_id (제품품목ID) — Primary key — NOT NULL

MMR425_R (MRP 주차(일)별 소요량)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • sq (Key2) — Primary key — NOT NULL
  • mrp_ak (Key3) — Primary key — NOT NULL

MMR440_R (외자.MRP주차별 구매량확정 Head)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • pur_sq (구매순번) — Primary key — NOT NULL

MMR441_R (외자.MRP 품목별 기준정보)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • pur_sq (Key2) — Primary key — NOT NULL
  • itm_id (품목id) — Primary key — NOT NULL

MMR445_R (외자.MRP주차별 구매량확정Detail)

  • mrp_no (MRP번호) — Primary key — NOT NULL
  • pur_sq (구매순번) — Primary key — NOT NULL
  • sq (MRP순번) — Primary key — NOT NULL
  • itm_id (품목id) — Primary key — NOT NULL

MMR900 (양산품 자동발주산출)

  • mass_no (양산품자동채번NO) — Primary key — NOT NULL

MMV100 (품목매입정보)

  • itm_id (품목ID) — Primary key — NOT NULL
  • cust_cd (납품거래처코드) — Primary key — NOT NULL

MTB500 (수입 B/L)

  • co_cd (회사) — Primary key — NOT NULL
  • bl_no (B/L번호) — Primary key — NOT NULL

MTB550 (수입 INVOICE)

  • iv_no (송장번호) — Primary key — NOT NULL
  • itm_id (품번) — Primary key — NOT NULL
  • origin (원산지) — Primary key — NOT NULL
  • po_no (발주번호) — Primary key — NOT NULL
  • bl_no (B/L NO) — Primary key — NOT NULL

PPP200_A (월생산계획(차수별))

  • plan_id (계획Id) — Primary key — NOT NULL
  • plan_mon (생산계획년월) — Primary key — NOT NULL
  • itm_id (품목Id) — Primary key — NOT NULL

PPP210_A (월생산계획-차수)

  • plan_mon (계획년월) — Primary key — NOT NULL
  • fac_cd (공장코드) — Primary key — NOT NULL
  • plan_rev (계획차수) — Primary key — NOT NULL

PPZ100 (작업장정보)

  • wc_cd (작업장코드) — Primary key — NOT NULL
  • fac_cd (공장코드) — Primary key — NOT NULL
  • fr_dt (적용시작일) — Primary key — NOT NULL

구매발주상세 (MMB150)

  • po_no (발주번호) — Primary key — NOT NULL
  • po_sq (발주순번) — Primary key — NOT NULL

납품정보 (MMB200)

  • div_no (납품번호) — Primary key — NOT NULL
  • div_sq (납품순번) — Primary key — NOT NULL