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