grit_BNFMES_POP
Tables (11)
BS_Plant
- Key (PlantCd) — nvarchar(4) — Primary key — NOT NULL
Untitled (EQ_Fac)
- Key (FacCd) — nvarchar(10) — Primary key — NOT NULL
Untitled (MF_Order)
- Key (OrderNo) — nvarchar(20) — Primary key — NOT NULL
Untitled (MF_OrderRout)
- Key (RoutSeq) — int — Primary key — NOT NULL
Untitled (BS_Item)
- Key (ItemCd) — nvarchar(30) — Primary key — NOT NULL
Untitled (MF_Prod)
- Key (ProdSeq) — int — Primary key — NOT NULL
Untitled (BS_Proc)
- Key (ProcCd) — nvarchar(10) — Primary key — NOT NULL
Untitled (MF_OrderCons)
- Key (BomRev) — int — Primary key — NOT NULL
- Field (PItemCd) — nvarchar(30)
- Field2 (CItemSeq) — int
Untitled (IV_Stock)
- Key (LotNo) — nvarchar(50) — Primary key — NOT NULL
- Field (SICd) — nvarchar(10)
- Field (LotCd) — nvarhcar(20)
- Field (Length) — smallint
Untitled (MF_Worker)
- Key (WkCd) — navarchar(20) — Primary key — NOT NULL
Untitled (MF_ProdDefect)
- Key (DefectSeq) — int — Primary key — NOT NULL
- Key (PlantCd) — nvarchar(4) — Foreign key → BS_Plant.Key — NOT NULL
- Key (OrderNo) — nvarchar(20) — Foreign key → Untitled.Key — NOT NULL
- Key (RoutSeq) — int — Foreign key → Untitled.Key — NOT NULL
- Key (ProdSeq) — int — Foreign key → Untitled.Key — NOT NULL
- Key (WkCd) — navarchar(20) — Foreign key → Untitled.Key — NOT NULL