STC
Tables (5)
BOM (MBOM)
- Itm_pcd (Key) — Primary key — NOT NULL
- Itm_cd (Key2) — Primary key — NOT NULL
- Proc_cd (Key3) — Primary key — NOT NULL
- Itm_cd (Key4) — Foreign key → ItemPrice.Itm_cd — NOT NULL
- Itm_Price (Key22) — Foreign key → ItemPrice.Itm_Price — NOT NULL
Item master (Item Master)
- Itm_cd (Key) — Primary key — NOT NULL
- 비중 (Field)
ItemPrice (Item Price)
- Itm_cd (Key) — Primary key — NOT NULL
- Itm_Price (Key2) — Primary key — NOT NULL
Machine Master (고정자산)
- act_cd (Key) — Primary key — NOT NULL
- mc_type (Key2) — Primary key — NOT NULL
Routing (Item Routing)
- Itm_cd (Key) — Primary key — NOT NULL
- Proc_cd (Key2) — Primary key — NOT NULL
- Kcal (Key3) — NOT NULL
- MC1-1 (Key4) — NOT NULL
- MC1-2 (Key5) — NOT NULL
- MC1-3 (Key6) — NOT NULL
- MC2-1 (Key7) — NOT NULL
- MC2-2 (Key8) — NOT NULL
- MC2-3 (Key9) — NOT NULL
- Itm_pcd (Key10) — Foreign key → BOM.Itm_pcd — NOT NULL
- Itm_cd (Key22) — Foreign key → BOM.Itm_cd — NOT NULL
- Proc_cd (Key32) — Foreign key → BOM.Proc_cd — NOT NULL