1. Tables and Views for SCM
  2. VCS_VMI_RELATIONSHIPS_INT

VCS_VMI_RELATIONSHIPS_INT

Allows an import of vendor-managed inventory relationships.

Details

  • Schema: FUSION

  • Object owner: VCS

  • Object type: TABLE

  • Tablespace: INTERFACE

Primary Key

Name Columns

VCS_VMI_RELATIONSHIPS_INT_PK

LINE_ID, LOAD_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
LINE_ID NUMBER 18 Yes Unique identifier for vendor-managed relationships import file.
RELATIONSHIP_KEY VARCHAR2 64 Yes This key is used only during the import transaction to link VCS_VMI_RELATIONSHIPS data whose scope is Subinventory to VCS_VMI_RELATIONSHIP_SUBS.
REQUEST_STATUS_CODE VARCHAR2 30 Identifies the status of the batch.
ORGANIZATION_CODE VARCHAR2 300 Yes The inventory organization receiving the goods being shipped.
ORGANIZATION_ID NUMBER 18 Identifies the organization participating in vendor-managed inventory.
INVENTORY_ITEM_NUMBER VARCHAR2 300 Yes The item being managed by the supplier.
INVENTORY_ITEM_ID NUMBER 18 Identifies the item participating in vendor-managed inventory.
SUPPLIER_NAME VARCHAR2 360 Yes The supplier managing the inventory.
VENDOR_ID NUMBER 18 Identifies the supplier participating in vendor-managed inventory.
SCOPE VARCHAR2 80 Yes The scope of the relationship. This specifies which level of on-hand quantities you would like to share with the supplier.
REQUISITION_REQ_USERNAME VARCHAR2 64 Identifies the requisition requester username at the organization level.
REQ_REQUESTER_ID NUMBER 18 Identifies the requisition requester at the organization level.
MIN_MAX_SOURCE VARCHAR2 80 Identifies the source for min-max inventory thresholds at the organization level.
STATUS VARCHAR2 80 Identifies the current state of the VMI relationship.
LOAD_REQUEST_ID NUMBER 18 Yes Identifies the instance that loads the data
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
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. Active

Indexes

Index Uniqueness Tablespace Columns
VCS_VMI_RELS_INT_U1 Unique Default LINE_ID, LOAD_REQUEST_ID