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