VCS_VMI_RELATIONSHIP_SUBS_GT

Global temporary staging table used by the VMI Import job to process subinventory-level details for imported VMI relationships, normalized values, validation results, processing status, and errors.

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 parent 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.
SUBINVENTORY	VARCHAR2	100			Name of the subinventory 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.
SUBINVENTORY_U	VARCHAR2	100			Uppercase normalized subinventory name 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.
REQ_REQUESTER_ID	NUMBER		18		Internal identifier of the requester.
PARENT_LINE_ID	NUMBER		18		Identifier of the parent relationship line in the import data.
PARENT_SCOPE_U	VARCHAR2	60			Uppercase normalized scope value of the parent relationship.
PARENT_ORG_ID	NUMBER		18		Internal identifier of the parent inventory organization.
PARENT_ITEM_ID	NUMBER		18		Internal identifier of the parent inventory item.
MIN_MAX_VALID	CHAR	1			Flag that indicates whether the Min-Max source value is valid.
REQ_VALID	CHAR	1			Flag that indicates whether the requester is valid.
SUB_EXISTS	CHAR	1			Flag that indicates whether the subinventory exists.
SUB_QTY_TRACKED	CHAR	1			Flag that indicates whether quantity tracking is enabled for the subinventory.
SUB_STORAGE_TYPE	CHAR	1			Flag that indicates whether the subinventory has a valid storage type.
SUB_ACTIVE	CHAR	1			Flag that indicates whether the subinventory is active.
SUB_PLAN_VALID	CHAR	1			Flag that indicates whether the subinventory planning setup is valid.
SUB_PLAN_OWNER_VALID	CHAR	1			Flag that indicates whether the subinventory plan owner 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.

Indexes

Index	Uniqueness	Columns
VCS_VMI_REL_SUBS_GT_N1	Non Unique	LOAD_REQUEST_ID, RELATIONSHIP_KEY