VCS_VMI_RELATIONSHIPS_GT

Global temporary staging table used by the VMI Import job to store and process imported VMI relationship records, including input attributes, normalized values, validation results, processing status, and error details.

Details

• Schema: FUSION

• Object owner: VCS

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
LOAD_REQUEST_ID	NUMBER		18	Yes	Identifier of the import load request batch.
LINE_ID	NUMBER		18	Yes	Identifier of the line within the import load request.
RELATIONSHIP_KEY	NUMBER		18	Yes	Unique key of the VMI relationship record in the import data.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
SUPPLIER_NAME	VARCHAR2	240			Name of the supplier provided in the import data.
ORGANIZATION_CODE	VARCHAR2	60			Code of the inventory organization provided in the import data.
INVENTORY_ITEM_NUMBER	VARCHAR2	300			Number of the inventory item provided in the import data.
SCOPE	VARCHAR2	60			Scope of the VMI relationship provided in the import data.
STATUS	VARCHAR2	60			Status of the VMI relationship provided in the import data.
MIN_MAX_SOURCE	VARCHAR2	60			Source of Min-Max planning provided in the import data.
REQ_USERNAME	VARCHAR2	240			User name of the requester provided in the import data.
SUPPLIER_NAME_U	VARCHAR2	240			Uppercase normalized supplier name used for validation and matching.
ORGANIZATION_CODE_U	VARCHAR2	60			Uppercase normalized organization code used for validation and matching.
ITEM_NUMBER_U	VARCHAR2	300			Uppercase normalized item number used for validation and matching.
SCOPE_U	VARCHAR2	60			Uppercase normalized scope value used for validation and matching.
STATUS_U	VARCHAR2	60			Uppercase normalized status value used for validation and matching.
MIN_MAX_SOURCE_U	VARCHAR2	60			Uppercase normalized Min-Max source value used for validation and matching.
REQ_USERNAME_U	VARCHAR2	240			Uppercase normalized requester user name used for validation and matching.
VENDOR_ID	NUMBER		18		Internal identifier of the supplier.
ORGANIZATION_ID	NUMBER		18		Internal identifier of the inventory organization.
INVENTORY_ITEM_ID	NUMBER		18		Internal identifier of the inventory item.
REQ_REQUESTER_ID	NUMBER		18		Internal identifier of the requester.
ITEM_PLAN_CODE	NUMBER		18		Planning code of the inventory item.
ORG_INVENTORY_FLAG	VARCHAR2	1			Flag that indicates whether the organization is inventory-enabled.
ORG_ENABLED_FLAG	VARCHAR2	1			Flag that indicates whether the organization is enabled.
SCOPE_VALID	CHAR	1			Flag that indicates whether the scope value is valid.
STATUS_VALID	CHAR	1			Flag that indicates whether the status value is valid.
MIN_MAX_VALID	CHAR	1			Flag that indicates whether the Min-Max source value is valid.
VENDOR_VALID	CHAR	1			Flag that indicates whether the supplier is valid.
ORG_VALID	CHAR	1			Flag that indicates whether the organization is valid.
ITEM_EXISTS	CHAR	1			Flag that indicates whether the item exists.
ITEM_IN_ORG	CHAR	1			Flag that indicates whether the item is assigned to the organization.
ORG_PLAN_VALID	CHAR	1			Flag that indicates whether the organization planning setup is valid.
ORG_PLAN_OWNER_VALID	CHAR	1			Flag that indicates whether the organization plan owner is valid.
SUP_SITE_BU_VALID	CHAR	1			Flag that indicates whether the supplier site and business unit combination is valid.
REQ_VALID	CHAR	1			Flag that indicates whether the requester is valid.
HAS_ERROR	CHAR	1			Flag that indicates whether the record has validation errors.
CAN_PROCESS	CHAR	1			Flag that indicates whether the record is eligible for processing.
SCOPE_CODE	VARCHAR2	30			Internal code mapped from the scope value.
STATUS_CODE	VARCHAR2	30			Internal code mapped from the status value.
MIN_MAX_SOURCE_CODE	VARCHAR2	30			Internal code mapped from the Min-Max source value.
NEW_RELATIONSHIP_ID	NUMBER		18		Identifier of the VMI relationship created from the import record.
NEW_RELATIONSHIP_NUMBER	NUMBER		18		Number of the VMI relationship created from the import record.
INSERTED_FLAG	CHAR	1			Flag that indicates whether the record was inserted successfully.

Indexes

Index	Uniqueness	Columns
VCS_VMI_RELATIONSHIPS_GT_N1	Non Unique	LOAD_REQUEST_ID, RELATIONSHIP_KEY