ZCA_DATA_CAPTURE_DT_B

This table stores AI evaluation text for specific attributes of business objects.

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
ZCA_DATA_CAPTURE_DT_B_PK	DATA_CAP_DT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
DATA_CAP_DT_ID	NUMBER		18	Yes	Unique identifier (Primary Key) of the Sales Motion Design Time Data Capture object.
DATA_CAP_DT_NUMBER	VARCHAR2	255		Yes	Public unique identifier (Alternate Key) of the Sales Motion Design Time Data Capture object.	Obsolete
OBJECT_CODE	VARCHAR2	100			Indicates Sales Object Code.
STATUS_CODE	VARCHAR2	30			Indicates if the Data Capture for field is enabled.
DATA_CAPTURE_FIELD	VARCHAR2	255			Data Capture field.	Obsolete
CRITERIA	CLOB				Criteria expression used to associate Source objects to transactional objects
RANK	NUMBER	8			Rank in which the rule to be applied if there is overlapping criteria.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.

Indexes

Index	Uniqueness	Tablespace	Columns	Status
ZCA_DATA_CAPTURE_DT_B_PK	Unique	Default	DATA_CAP_DT_ID
ZCA_DATA_CAPTURE_DT_B_U1	Unique	Default	DATA_CAP_DT_NUMBER	Obsolete