VCS_VMI_REP_ITEM_REQUESTS

Details

Schema: FUSION
Object owner: VCS
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
VCS_VMI_REP_ITEM_REQUESTS_PK	REPLENISHMENT_REQUEST_INT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
REPLENISHMENT_REQUEST_INT_ID	NUMBER		18	Yes	Primary key identifying the interface record.
UPLOAD_FILE_ID	NUMBER		18		Unique identifier of the uploaded flat file.
IMPORT_TYPE_CODE	VARCHAR2	32		Yes	Identifies the type of import of the interface data.
STATUS_CODE	VARCHAR2	32			Status of the record. Valid values "SUCCESS", "FAILURE".
VENDOR_NAME	VARCHAR2	360			Identifies the supplier name participating in vendor-managed inventory.
VENDOR_ID	NUMBER		18		Identifies the supplier participating in vendor-managed inventory.
VENDOR_SITE_CODE	VARCHAR2	240			Identifies the supplier site code participating in vendor-managed inventory.
VENDOR_SITE_ID	NUMBER		18		Identifies the supplier site participating in vendor-managed inventory.
ORGANIZATION_CODE	VARCHAR2	32			Identifies the organization participating in vendor-managed inventory.
ORGANIZATION_ID	NUMBER		18		Identifies the organization participating in vendor-managed inventory.
SUBINVENTORY	VARCHAR2	32			Identifies the subinventory participating in vendor-managed inventory.
ITEM_NUMBER	VARCHAR2	300			Identifies the item participating in vendor-managed inventory.
INVENTORY_ITEM_ID	NUMBER		18		Identifies the item participating in vendor-managed inventory.
QUANTITY	NUMBER				Identifies the inventory required at a specific organization or subinventory.
DELIVERY_DATE	DATE				Date by which the requested item is needed.
NOTES	VARCHAR2	1000			Note to the buyer who will be processing the request.
MIN_QUANTITY	NUMBER				Identifies the minimum inventory required at a specific organization or subinventory.
MAX_QUANTITY	NUMBER				Identifies the maximum inventory required at a specific organization or subinventory.
UPLOAD_ROW_NUMBER	NUMBER		18		Row number of the record in upload file.
INTERNAL_REQUEST_ID	NUMBER		18		Unique identifier of the request.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PRC_BU_NAME	VARCHAR2	240			Identifies the supplier's procurement business unit name.
PRC_BU_ID	NUMBER		18		Identifies the supplier's procurement business unit id.

Indexes

Index	Uniqueness	Tablespace	Columns
VCS_VMI_REP_ITEM_REQS_INT_N1	Non Unique	Default	LAST_UPDATE_DATE, IMPORT_TYPE_CODE
VCS_VMI_REP_ITEM_REQS_INT_N2	Non Unique	Default	VENDOR_ID, ORGANIZATION_ID, INVENTORY_ITEM_ID, UPLOAD_FILE_ID, SUBINVENTORY
VCS_VMI_REP_ITEM_REQS_INT_U1	Unique	Default	REPLENISHMENT_REQUEST_INT_ID