VCS_COLLAB_ATTRIBUTES

Details

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

Primary Key

Name	Columns
VCS_COLLAB_ATTRIBUTES_PK	ATTRIBUTE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
ATTRIBUTE_ID	NUMBER		18	Yes	Primary key identifying a collaboration attributes for a relationship
RELATIONSHIP_ID	NUMBER		18	Yes	Identifies the relationship to which these attributes are applied
FORECAST_HORIZON_DAYS	NUMBER		18		Identifies in days how far we will provide forecast data
TIME_LEVEL	VARCHAR2	32			Identifies the granularity of the data being sent/displayed for the supplier.
SLA_DAYS	NUMBER		18		Identifies in days how long we should wait for a partner to respond
COMMIT_HORIZON_DAYS	NUMBER		18		Identifies in days how far in the future we have to look for commits
SLA_PAST_DUE_ACTION_CODE	VARCHAR2	32			Captures the past due action for SLA.
AUTO_COMMIT_PERIOD_CODE	VARCHAR2	32			The period of time for which commits will be provided.
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_CODE.
TRDNG_PRTNR_VIEW_FRCSTS_FLAG	VARCHAR2	1		Yes	Allows selected contacts of the Ship-to the ability to view forecasts for items shipped to them
TRDNG_PRTNR_EDIT_FRCSTS_FLAG	VARCHAR2	1		Yes	Allows selected contacts of the Ship-to the ability to enter and submit forecast quantity changes and republish the order forecast to the upstream supplier
TRDNG_PRTNR_EDIT_COMMITS_FLAG	VARCHAR2	1		Yes	Allows selected contacts of the Ship-to the ability enter and submit commit quantities back to the Enterprise
COLLAB_AGGR_LEVEL_CODE	VARCHAR2	32		Yes	A column heading that identifies the dimensional aggregation level for the collaboration relationship
COLLAB_UOM_SOURCE_CODE	VARCHAR2	32		Yes	The unit of measure definition source code that defines the collaboration unit of measure resolution strategy.
OTHER_COLLAB_UOM_CODE	VARCHAR2	3			The unit of measure code selected when the unit of measure definition source code is Other.
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.
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.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
VCS_COLLAB_ATTRIBUTES_N1	Non Unique	Default	RELATIONSHIP_ID, TRDNG_PRTNR_VIEW_FRCSTS_FLAG, TRDNG_PRTNR_EDIT_FRCSTS_FLAG, TRDNG_PRTNR_EDIT_COMMITS_FLAG
VCS_COLLAB_ATTRIBUTES_U1	Unique	Default	ATTRIBUTE_ID
VCS_COLLAB_ATTRIBUTES_U2	Unique	Default	RELATIONSHIP_ID	Obsolete
VCS_COLLAB_ATTRIBUTES_U3	Unique	Default	RELATIONSHIP_ID, COLLAB_AGGR_LEVEL_CODE