GMES HFPA

Tables (3)

MSPQ_HFPA_CRTN (HFPA CRTN)

  • Plant Code (PLANT_CD) — VARCHAR2(4) — Primary key — NOT NULL
  • Plant Building (PB_CD) — VARCHAR2(10) — Primary key — NOT NULL
  • Work Center (WC_CD) — VARCHAR2(5) — Primary key — NOT NULL
  • Inspection Point Id (INSPECT_POINT_ID) — VARCHAR(20) — Primary key — NOT NULL
  • Nike PO No (PO_NO) — VARCHAR2(10) — Primary key — NOT NULL
  • Nike Po Seq (PO_SEQ) — VARCHAR2(5) — Primary key — NOT NULL
  • UCC No (UCC_NO) — VARCHAR2(10) — Primary key — NOT NULL
  • Inspect No (INSPECT_NO) — VARCHAR2(8) — Primary key — NOT NULL
  • Insepection Date (INSPECT_DATE) — VARCHAR2(8)
  • Hour Code (HOUR_CD) — VARCHAR2(2)
  • Style Code (STYLE_CD) — VARCHAR2(10)
  • Carton Qty (CRTN_QTY) — NUMBER(10, 0)
  • Defect Qty (DEFECT_QTY) — NUMBER(10,1)
  • Inspector No (INSPECTOR_NO) — VHARCHAR2(20)
  • Memo (MEMO) — NVARCHAR2(300)

MSPQ_HFPA_IMAGE (HFPA IMAGE)

  • Plant Code (PLANT_CD) — VARCHAR2(4) — Foreign key → MSPQ_HFPA_INSP.Plant Code — NOT NULL
  • Inspection Date (INSPECT_DATE) — VARCHAR2(8) — Foreign key → MSPQ_HFPA_INSP.Inspection Date — NOT NULL
  • Plant Building (PB_CD) — VARCHAR(10) — Foreign key → MSPQ_HFPA_INSP.Plant Building — NOT NULL
  • Work Center (WC_CD) — VARCHAR2(5) — Foreign key → MSPQ_HFPA_INSP.Work Center — NOT NULL
  • Inspection Point ID (INSPECT_POINT_ID) — VARCHAR2(20) — Foreign key → MSPQ_HFPA_INSP.Inspection Point ID — NOT NULL
  • Inspection Seq (INSPECT_SEQ) — VARCHAR2(5) — Foreign key → MSPQ_HFPA_INSP.Inspection Seq — NOT NULL
  • Nike PO No (PO_NO) — VARCHAR(10)
  • Nike PO Seq (PO_SEQ) — VARCHAR(5)
  • UCC No (UCC_NO) — VHARCHAR2(10)
  • Inspect No (INSPECT_NO) — VARCHAR2(8)
  • Hour Code (HOUR_CD) — VARCHAR2(2)
  • Style Code (STYLE_CD) — VARCHAR2(10)
  • Shoe Image (SHOE_IMAGE) — BLOB
  • Memo (MEMO) — NVARCHAR2(300)

MSPQ_HFPA_INSP (HFPA INSP)

  • Plant Code (PLANT_CD) — VARCHAR2(4) — Primary key — NOT NULL
  • Inspection Date (INSPECT_DATE) — VARCHAR2(8) — Primary key — NOT NULL
  • Plant Building (PB_CD) — VARCHAR(10) — Primary key — NOT NULL
  • Work Center (WC_CD) — VARCHAR2(5) — Primary key — NOT NULL
  • Inspection Point ID (INSPECT_POINT_ID) — VARCHAR2(20) — Primary key — NOT NULL
  • Inspection Seq (INSPECT_SEQ) — VARCHAR2(5) — Primary key — NOT NULL
  • Nike PO No (PO_NO) — VARCHAR2(10)
  • Nike PO Seq (PO_SEQ) — VARCHAR2(5)
  • UCC No (UCC_NO) — VARCHAR2(10)
  • INSPECT No (INSPECT_NO) — VARCHAR2(3)
  • Hour Code (HOUR_CD) — VARCHAR(2)
  • Style Code (STYLE_CD) — VARCHAR2(10)
  • Size Code (SIZE_CD) — VARCHAR2(10)
  • Left/Right (LR_CD) — VARCHAR2(10)
  • Grade[B|C|R|O] (GRADE_CD) — VARCHAR2(10)
  • Defective Code (DEFECT_CD) — VARCHAR2(10)
  • Defect Qty (DEFECT_QTY) — NUMBER(10,1)
  • Inspector No (INSPECTOR_NO) — VARCHAR2(20)
  • Def. Position 1 (POS_1_YN) — VARCHAR2(1)
  • Def. Position 2 (POS_2_YN) — VARCHAR2(1)
  • Def. Position 3 (POS_3_YN) — VARCHAR2(1)
  • Def. Position 4 (POS_4_YN) — VARCHAR2(1)
  • Def. Position 5 (POS_5_YN) — VARCHAR2(1)
  • Def. Position 6 (POS_6_YN) — VARCHAR2(1)
  • Memo (MEMO) — NVARCHAR2(300)