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)