This set of views expose the Receiving Discrepancy-related data. The set consists of the views described in the following table.
View | Description | Interpreted Columns | SQL Filename |
---|---|---|---|
YNA_RECEIVING_DISCREPANCY_VW | This view exposes the data in the YFS_RECEIVING_ DISCREPANCY table. |
None |
|
YNA_RECEIVING_DISCR_DTL_VW | This view exposes the data in the YFS_RECEIVING_DISCR_ DTL table. |
None |
|
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 |
|
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 |
|
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 |
|