OSND View

Tables (4)

Product Quality External OSND Table (4)

  • Company Code (COMPANY_CD) — VARCHAR2(10)
  • Company Name (COMPANY_NAME) — NVARCHAR2(100)
  • Plant Code (PLANT_CD) — VARCHAR2(10)
  • Plant Name (PLANT_NAME) — NVARCHAR2(100)
  • Supply Plant Code (SUPPLY_PLANT_CD) — VARCHAR2(10)
  • Plant Building Code (PB_CD) — VARCHAR2(20)
  • Plant Building Name (PB_NAME) — VARCHAR2(60)
  • Item Class Type (ITEM_CLASS_TYPE) — VARCHAR2(2)
  • Line (LN) — VARCHAR2(3)
  • Model Code (MODEL_CD) — VARCHAR2(4000)
  • Model Name (MODEL_NAME) — VARCHAR2(4000)
  • Style Code (STYLE_CD) — VARCHAR2(10)
  • Reason Code (REASON_CD) — VARCHAR2(40)
  • Reason Name (REASON_NAME) — VARCHAR2(1000)
  • In Qty (IN_QTY) — NUMBER
  • OSND Type (OSND_TYPE) — VARCHAR2(6)
  • OSND External Qty (OSND_EX_QTY) — NUMBER
  • Incoming Scan Date (I_SCN_DT) — DATE
  • Outgoing Scan Date (O_SCN_DT) — DATE
  • Prod Scan Date (P_SCN_DT) — DATE

V_PQ_EX_OSND (1)

  • Company Code (COMPANY_CD) — VARCHAR2(10)
  • Compant Name (COMPANT_NAME) — NVARCHAR2(100)
  • Plant Code (PLANT_CD) — VARCHAR2(10)
  • Plant Name (PLANT_NAME) — NVARCHAR2(100)
  • Plant Building Code (PB_CD) — VARCHAR2(20)
  • Plant Building Name (PB_NAME) — VARCHAR2(60)
  • Item Class Type (ITEM_CLASS_TYPE) — VARCHAR2(2)
  • In Date (IN_DATE) — VARCHAR2(8)
  • LN — VARCHAR2(3)
  • Model Code (MODEL_CD) — VARCHAR2(4000)
  • Model Name (MODEL_NAME) — VARCHAR2(4000)
  • Style code (STYLE_CD) — VARCHAR2(10)
  • Reason Code (REASON_CD) — VARCHAR2(40)
  • Reason Name (REASON_NAME) — VARCHAR2(1000)
  • Field (IN_QTY) — NUMBER
  • Defect Qty (DEFECT_QTY) — NUMBER
  • Replen Qty (REPLEN_QTY) — NUMBER
  • Send Qty (SEND_QTY) — NUMBER
  • Prepare Qty (PREPARE_QTY) — NUMBER
  • Replen Date (REPLEN_DATE) — VARCHAR2(8)

V_PQ_EX_OSND_V3 (3)

  • Company Code (COMPANY_CD) — VARCHAR2(10)
  • Company Name (COMPANT_NAME) — NVARCHAR2(100)
  • Plant Code (PLANT_CD) — VARCHAR2(10)
  • Plant Name (PLANT_NAME) — NVARCHAR2(100)
  • Plant Building Code (PB_CD) — VARCHAR2(20)
  • Plant Building Name (PB_NAME) — VARCHAR2(60)
  • Item Class Type (ITEM_CLASS_TYPE) — VARCHAR2(2)
  • In Date (IN_DATE) — VARCHAR2(8)
  • LN — VARCHAR2(3)
  • Model Code (MODEL_CD) — VARCHAR2(4000)
  • Model Name (MODEL_NAME) — VARCHAR2(4000)
  • Style code (STYLE_CD) — VARCHAR2(10)
  • Reason Code (REASON_CD) — VARCHAR2(40)
  • Reason Name (REASON_NAME) — VARCHAR2(1000)
  • Field (IN_QTY) — NUMBER
  • Defect Qty (DEFECT_QTY) — NUMBER
  • Defect O Qty (DEFECT_O_QTY) — NUMBER
  • Defect S Qty (DEFECT_S_QTY) — NUMBER
  • Defect D Qty (DEFECT_D_QTY) — NUMBER
  • Defect I Qty (DEFECT_I_QTY) — NUMBER
  • Defect L Qty (DEFECT_L_QTY) — NUMBER
  • Replen Qty (REPLEN_QTY) — NUMBER
  • Replen O Qty (REPLEN_O_QTY) — NUMBER
  • Replen S Qty (REPLEN_S_QTY) — NUMBER
  • Replen D Qty (REPLEN_D_QTY) — NUMBER
  • Replen I Qty (REPLEN_I_QTY) — NUMBER
  • Replen L Qty (REPLEN_L_QTY) — NUMBER
  • Send Qty (SEND_QTY) — NUMBER
  • Prepare Qty (PREPARE_QTY) — NUMBER
  • Replen Date (REPLEN_DATE) — VARCHAR2(8)
  • Replen O Date (REPLEN_O_DATE) — VARCHAR2(8)
  • Replen S Date (REPLEN_S_DATE) — VARCHAR2(8)
  • Replen D Date (REPLEN_D_DATE) — VARCHAR2(8)
  • Replen I Date (REPLEN_I_DATE) — VARCHAR2(8)
  • Replen L Date (REPLEN_L_DATE) — VARCHAR2(8)

V_PQ_VL_OSND (2)

  • Company Code (COMPANY_CD) — VARCHAR2(10)
  • Compant Name (COMPANT_NAME) — NVARCHAR2(100)
  • Plant Code (PLANT_CD) — VARCHAR2(10)
  • Plant Name (PLANT_NAME) — NVARCHAR2(100)
  • Plant Building Code (PB_CD) — VARCHAR2(20)
  • Plant Building Name (PB_NAME) — VARCHAR2(60)
  • Item Class Type (ITEM_CLASS_TYPE) — VARCHAR2(2)
  • In Date (IN_DATE) — VARCHAR2(8)
  • LN — VARCHAR2(3)
  • Model Code (MODEL_CD) — VARCHAR2(4000)
  • Model Name (MODEL_NAME) — VARCHAR2(4000)
  • Style code (STYLE_CD) — VARCHAR2(10)
  • Reason Code (REASON_CD) — VARCHAR2(40)
  • Reason Name (REASON_NAME) — VARCHAR2(1000)
  • Field (IN_QTY) — NUMBER
  • Defect Qty (DEFECT_QTY) — NUMBER
  • Replen Qty (REPLEN_QTY) — NUMBER
  • Send Qty (SEND_QTY) — NUMBER
  • Prepare Qty (PREPARE_QTY) — NUMBER
  • Replen Date (REPLEN_DATE) — VARCHAR2(8)