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)