Receiving Discrepancy Views

This set of views expose the Receiving Discrepancy-related data. The set consists of the views described in the following table.

Table 1. Receiving Discrepancy Views
View Description Interpreted Columns SQL Filename
YNA_RECEIVING_DISCREPANCY_VW

This view exposes the data in the YFS_RECEIVING_

DISCREPANCY table.

None
TRANSACTION/
Receiving_Discrepancy.sql
YNA_RECEIVING_DISCR_DTL_VW

This view exposes the data in the YFS_RECEIVING_DISCR_

DTL table.

None
TRANSACTION/Receiving_
Discrepancy_Detail.sql
YNA_RECEIPT_LOT_DISCR_NL_VW

This view obtains the lot discrepancies in receipts by joining the data in the YFS_SHIPMENT,

YFS_SHIPMENT_LINE, YFS_ORDER_LINE, YFS_RECEIPT_HEADER,

YFS_ORDER_HEADER, YFS_ORDER_LINE_REQ_TAG,

YFS_RECEIPT_LINE tables.

None
TRANSACTION/Receipt_
Lot_DiscrepancyNL.sql
YNA_RECEIPT_QTY_DISCR_NL_VW

This view obtains the quantity discrepancies in receipts by joining the data in the YFS

_RECEIVING_DISCREPANCY,

YFS_SHIPMENT,

YFS_ORDER_LINE,

YFS_RECEIPT_HEADER, and YFS_ORDER_HEADER tables.

None
TRANSACTION/Receipt_
Quantity_DiscrepancyNL.sql
YNA_RECEIPT_SL_DISCR_NL_VW

This view obtains the serial discrepancies in receipts by joining the data in the

YFS_SHIPMENT, YFS_SHIPMENT_LINE, YFS_RECEIPT_HEADER,

YFS_ORDER_LINE, and YFS_RECEIPT_LINE tables.

None
TRANSACTION/Receipt_
Serial_DiscrepancyNL.sql