This set of views expose the Inventory-related data. The set consists of the views described in the following table.
View | Description | Interpreted Columns | SQL Filename |
---|---|---|---|
YNA_INVENTORY_AUDIT_VW | This view exposes the data in the YFS_INVENTORY_AUDIT table. |
None |
|
YNA_INVENTORY_COST_ MATCH_VW |
This view exposes the data in the YFS_INVENTORY_MATCH table. |
None |
|
YNA_INV_COST_SHIPMENT_VW | This view exposes the data in the YFS_INVENTORY_SHIPMENT andYFS_ORDER_HEADER tables. In addition to the columns of YFS_INVENTORY_SHIPMENT table, this view also exposes the seller organization on the order where the shipment was made. |
None |
|
YNA_INVENTORY_DEMAND_VW | This view exposes the data in the YFS_INVENTORY_DEMAND table. |
None |
|
YNA_INVENTORY_ITEM_VW | This view exposes the data in the YFS_INVENTORY_ITEM table. |
None |
|
YNA_INVENTORY_SUPPLY_VW | This view exposes the data in the INVENTORY_SUPPLY table. |
None |
|
YNA_INVENTORY_TAG_VW | This view exposes the data in the YFS_INVENTORY_TAG table . |
None |
|
YNA_INVENTORY_STATUS_VW | This view exposes data from the YFS_INVENTORY_STATUS table |
None |
|
YNA_INVENTORY_STATUS_NL_VW | This view exposes selected columns from the YFS_INVENTORY_STATUS table. |
None |
|
YNA_GLOBAL_SERIAL_NUM_VW | This view exposes the data in the YFS_GLOBAL_SERIAL_NUM table. |
None |
|
YNA_INVENTORY_RECEIPT_VW | This view exposes the data in the YFS_INVENTORY_RECEIPT table. |
None |
|
YNA_RES_POOL_VW | This view exposes the data in the YFS_RES_POOL table. |
None |
|
YNA_RES_POOL_CAPCTY _CONS_VW |
This view exposes data from the YFS_RES _POOL_CAPCTY_CONSMPTN table. |
None |
l |
YNA_RES_POOL_ CONSMPTN_DTLS_VW |
This view exposes the data in the YFS_RES_ POOL_CONSMPTN_DTLS table. |
None |
|
YNA_SERVICE_RESOURCE _VW |
This view exposes the data in the YFS_ SERVICE_RESOURCE table. |
None |
|