1. Tables and Views for SCM
  2. VCS_COLLAB_ENT

VCS_COLLAB_ENT

Identifies an entry used for item collaboration.

Details

  • Schema: FUSION

  • Object owner: VCS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

VCS_COLLAB_ENT_PK

ENTRY_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ENTRY_ID NUMBER 18 Yes Primary key indentifying a collaboration entry Active
ORCH_CORRELATION_CODE VARCHAR2 64 Correlation code to keep track orchestration process instance
ENTRY_TYPE_ID NUMBER 18 Identifies the type of collaboration. Active
SHIP_FROM_ID NUMBER 18 Yes Identifies the participant where the goods will be shipped from Active
INVENTORY_ITEM_ID NUMBER 18 Yes ID of the inventory item to be used in collaboration Active
INVENTORY_ITEM_ORG_ID NUMBER 18 Yes Org ID of the item to be used in collaboration process
SHIP_TO_ID NUMBER 18 Yes Identifies the participant where the goods will be shipped to Active
COLLAB_SOURCE_ID NUMBER 18 Yes ID of a collaboration source that this collaboration entry belongs to Active
FORECAST_HORIZON_END_DATE DATE Identifies the date in the future we will be providing forecast data
TIME_LEVEL VARCHAR2 32 Identifies the granularity of the data being sent/displayed for the supplier. Could be day, week, month.
SLA_DAYS NUMBER 18 Identifies in days how long we should wait for a participant to respond
COMMIT_HORIZON_END_DATE DATE Identifies the date in the future we have to look for commits
COLLAB_ENTRY_VERSION NUMBER 9 Identifies the version of the collaboration entry based on number of times it's been included in collaboration
SLA_PAST_DUE_ACTION_CODE VARCHAR2 32 Captures the past due action for SLA. Valid values are null or AUTO_COMMIT.
AUTO_COMMIT_PERIOD_CODE VARCHAR2 32 The period of time for which commits will be provided. Valid values are COMMIT_HORIZON or DAYS.
AUTO_COMMIT_PERIOD_FACTOR NUMBER 9 If AUTO_COMMIT_PERIOD_CODE is not a predefined measurement, this field will capture the time range of schedule details to be committed.
COMMIT_QUANTITY_PREF_CODE VARCHAR2 32 How the commit quantity will be determined: Percentage of Forecast or Previous Forecast Commit
COMMIT_PERCENT_FACTOR NUMBER Whole number percentage of forecast qty value, populated if Previous Forecast Commit is the preference identified in COMMIT_QUANTITY_PREF.
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
IS_CURRENT_FLAG VARCHAR2 1 Yes A flag that identifies current collaboration entries
IS_MANAGED_FLAG VARCHAR2 1 Yes A flag that identifies if a collaboration entry is for a managed relationship.
DROP_SHIP_FLAG VARCHAR2 1 Yes A column heading that identifies the collaboration entry as drop ship.
STATUS_CODE VARCHAR2 32 Yes Identifies the current state of the collaboration entry Active
PUBLISHED_BY NUMBER 18 Person Id of Supply Plan Publisher.
PUBLISHED_DATE TIMESTAMP The most recent date forecast information was published.
MAX_FORECAST_VERSION NUMBER 9 Identifies the number of mid-cycle forecast updates performed on this collaboration entry.
COMMIT_DATE TIMESTAMP The most recent date commit information was published.
COMMIT_DUE_DATE TIMESTAMP The latest commit due date for all the planning schedule details attached to the collaboration entry.
DETAIL_LAST_UPDATE_ENT TIMESTAMP Schedule Details enterprise last edit - last time any schedule details for an entry was updated by the enterprise user.
DETAIL_LAST_UPDATE_SUP TIMESTAMP Schedule Details supplier last edit - last time any schedule details for an entry was updated by the supplier user.
DETAIL_LAST_UPDATE_FRCST_ENT TIMESTAMP Schedule Details enterprise last edit - last time any forecast details for an entry was updated by the enterprise user.
DETAIL_LAST_UPDATE_FRCST_SUP TIMESTAMP Schedule Details supplier last edit - last time any forecast details for an entry was updated by the supplier user.
SUP_DRAFT_QTY_FLAG VARCHAR2 1 Yes Schedule Details Supplier Active Draft Values - 'Y' if any schedule details is in supplier draft.
ENT_DRAFT_QTY_FLAG VARCHAR2 1 Yes Schedule Details Enterprise Active Draft Values - 'Y' if any schedule details is in enterprise draft.
MAX_COMMIT_VERSION NUMBER 9 Identifies the number of mid-cycle commit updates performed on this collaboration entry.
PUBLISH_CYCLE_START_DATE DATE The calculated start date based on the plan scenario publish cycle.
PUBLISH_CYCLE_END_DATE DATE The calculated end date based on the plan scenario publish cycle.
FORECAST_HORIZON_FQTY NUMBER An aggregated value that shows the total of all forecast quantities for the collaboration entry within the Forecast Horizon.
COMMIT_HORIZON_FQTY NUMBER An aggregated value that shows the total of all forecast quantities for the collaboration entry within the Commit Horizon.
COMMIT_HORIZON_CQTY NUMBER An aggregated value that shows the total of all Commit quantities for the collaboration entry within the Commit Horizon.
COMMITTED_BY NUMBER 18 The party identifier for the user who performed the commit.
COMMITTED_BY_PARTY VARCHAR2 30 The type of user that performed the commitment.
LAST_PUBLISHED_PLAN_NAME VARCHAR2 30 The last supply plan used within the planning cycle to publish the collaboration order forecast.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
EXTERNAL_REFERENCE_FLAG VARCHAR2 1 Identifies if any of the data is externally referenced.
COLLAB_IDENTITY_ID NUMBER 18 Yes Provides collab entry identification across multiple publish cycles.
PRIMARY_UOM_CODE VARCHAR2 3 Identifies the supply chain collaboration primary unit of measure for supply planning collaboration. This collaboration unit of measure is determined by the collaboration relationship. All collaboration order forecast quantities are stored in this unit of measure.
PUBLISHED_UOM_CODE VARCHAR2 3 The published unit of measure for the collaboration entry. All measures are assumed to be in this unit of measure.
BASE_UOM_CODE VARCHAR2 3 Identifies the primary unit of measure managed on the item record. Base quantities are calculated by the system.
COLLAB_UOM_SOURCE_CODE VARCHAR2 32 Yes The unit of measure definition source code that defines the collaboration unit of measure resolution strategy.
PUBLISHED_ON_HAND_QTY NUMBER The on-hand quantity published with the collaboration order forecast stored in the collaboration unit of measure (PRIMARY_UOM_CODE).
SUPPLIER_ON_HAND_QTY NUMBER Quantity of the supplier on-hand inventory for the item, stored in the collaboration unit of measure (PRIMARY_UOM_CODE).
SUPPLIER_ON_HAND_PUB_BY NUMBER 18 User who most recently published the supplier on-hand quantity.
SUPPLIER_ON_HAND_PUB_DATE TIMESTAMP Date when the supplier on-hand quantity was published.
CM_ON_HAND_QTY NUMBER Quantity of the contract manufacturing on-hand inventory for the item, stored in the collaboration unit of measure (PRIMARY_UOM_CODE).
CM_ON_HAND_PUB_BY NUMBER 18 User who most recently published the contract manufacturing on-hand quantity.
CM_ON_HAND_PUB_DATE TIMESTAMP Date when the contract manufacturing on-hand quantity was published.
SUPPLIER_ON_HAND_PUB_BY_PARTY VARCHAR2 30 The type of user who published the supplier on-hand quantity. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'.
CM_ON_HAND_PUB_BY_PARTY VARCHAR2 30 The type of user who published the contract manufacturing on-hand quantity. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'.
PUBLISH_BY_PARTY VARCHAR2 30 The type of user who last published forecast information. The allowed values in this column are 'ORA_VCS_ENTERPRISE_VAL' and 'ORA_VCS_SUPPLIER_VAL'.
MANUFACTURER_NAME VARCHAR2 100 Name of the manufacturer of the part number.
MANUFACTURER_PART_NUMBER VARCHAR2 100 Number that identifies the item at the manufacturer.
NOTE_TO_SUPPLIER VARCHAR2 1000 Note from the collaboration planner to the supplier.
NOTE_TO_PLANNER VARCHAR2 1000 Note from the supplier to the collaboration planner.

Indexes

Index Uniqueness Tablespace Columns Status
VCS_COLLAB_ENT_N1 Non Unique Default INVENTORY_ITEM_ID, INVENTORY_ITEM_ORG_ID, SHIP_FROM_ID, SHIP_TO_ID
VCS_COLLAB_ENT_N2 Non Unique Default SHIP_TO_ID
VCS_COLLAB_ENT_N3 Non Unique Default SHIP_FROM_ID, IS_CURRENT_FLAG
VCS_COLLAB_ENT_N4 Non Unique Default INVENTORY_ITEM_ID, IS_CURRENT_FLAG, COMMIT_DATE, INVENTORY_ITEM_ORG_ID, SHIP_FROM_ID
VCS_COLLAB_ENT_N5 Non Unique Default COLLAB_IDENTITY_ID
VCS_COLLAB_ENT_N6 Non Unique Default IS_CURRENT_FLAG, IS_MANAGED_FLAG, COMMIT_DATE, SUP_DRAFT_QTY_FLAG, DETAIL_LAST_UPDATE_SUP, COMMIT_DUE_DATE
VCS_COLLAB_ENT_N7 Non Unique Default UPPER("ORCH_CORRELATION_CODE")
VCS_ITEM_COLLAB_ENT_U1 Unique FUSION_TS_TX_IDX ENTRY_ID Active