1. Tables and Views for Sales and Fusion Service
  2. ATC_PRODSPEC_CHAR_VALUES_

ATC_PRODSPEC_CHAR_VALUES_

Stores details of product speci char value

Details

  • Schema: FUSION

  • Object owner: ATC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

ATC_PRODSPEC_CHAR_VALUES_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, CHAR_VALUE_ID

Columns

Name Datatype Length Precision Not-null Comments
CHAR_VALUE_ID NUMBER 18 Yes Unique row id
DEFAULT_FLAG VARCHAR2 1 Indicates if the value is the default value for a characteristic
RANGE_INTERVAL VARCHAR2 200 An indicator that specifies the inclusion or exclusion of the valueFrom and valueTo attributes. If applicable, possible values are "open", "closed", "closedBottom" and "closedTop".
REGEX VARCHAR2 200 Regular expression to define constraint on the allowed value
VALUE_FROM VARCHAR2 200 The low range value that a characteristic can take on
VALUE_TO VARCHAR2 200 The upper range value that a characteristic can take on
VALUE_TYPE_CODE VARCHAR2 200 Indicates the value type
VALUE VARCHAR2 4000 A discrete value that the characteristic can take on. the value type is defined by 'valueType' characteristic
PROD_SPEC_CHAR_VALUE CLOB A discrete value that the product spec characteristic can take on.
VALUE_RESTRICTION_FLAG VARCHAR2 1 Indicates if the value is restricted
PARENT_CHAR_NAME VARCHAR2 200 Indicates the parent char name
UNIT_OF_MEASURE VARCHAR2 200 Indicates unit of measure
VALUE_CODE VARCHAR2 200 A optional code for the value where applicable
SPEC_CHAR_VALUE_RELATIONSHIP CLOB SPEC_CHAR_VALUE_RELATIONSHIP
AT_TYPE VARCHAR2 200 Represent the actual class type of an entity
AT_BASE_TYPE VARCHAR2 200 Represent the base class of a given resource that has been extended
AT_SCHEMA_LOCATION VARCHAR2 1000 Indicates a url which points to a schema which allow specifying user-defined properties of an Entity or to specify the expected characteristics of an entity
START_DATE_TIME TIMESTAMP Start time from which the prod spec char value is valid
END_DATE_TIME TIMESTAMP End Time to which the prod spec char value is valid
ENTITY_NAME VARCHAR2 100 Indicates the name of the entity
ENTITY_ID NUMBER 18 Indicates the Id of the entity to which it is associated
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP 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 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.
CHAR_VALUE_SEQ NUMBER 18 Indicates the sequence where attribute values appear during runtime
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
ATC_PRODSPEC_CHAR_VALUES_PK_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, CHAR_VALUE_ID