Alias (S)

Not used.

Cascade Clear (S)

If TRUE, then EIM clears this foreign key if Siebel CRM deletes the related entity. This property must be FALSE for an extension column.

Default (S)

Specifies the value that Siebel CRM uses for this column in a new record.

Denormalization Path (S)

Specifies the path that Siebel CRM denormalizes if this is a denormalization column. Applies to denormalization of a user key column into an intersection table.

EIM Processing Column Flag (S)

If TRUE, then the column for this interface table is reserved for EIM processing. You must not use this property to allow this column to contain customer data.

Force Case (S)

Specifies to force new values to uppercase letters.

Foreign Key Table Name (S)

Specifies the table to which this column is a foreign key, EIM uses this property.

Lov Bounded (S)

If TRUE, then EIM examines the values in a list defined in a LOV Type. You must configure Siebel CRM to first import LOV data into the S_LST_OF_VAL table and you must specify LOV Type.

This property is read-only for a predefined column in Siebel CRM but is editable for a column that you add through the Database Extension Designer.

Lov Type (S)

Specifies the list of values where Siebel CRM validates this column. Siebel CRM uses the Lov Type property with the LOV Bounded property. You define a list of values in List of Values administration screen in the client.

This property is read-only for a predefined column in Siebel CRM but is editable for a column that you add through the Database Extension Designer.

Name (S)

Specifies a name that must be unique in the table.

Nullable (S)

If TRUE, then Siebel CRM can save NULL in this column.

Physical Type (S)

Specifies the data type of the column in the Siebel database.

Precision (S)

For more information, see About the Scale and Precision Properties.

Primary Child Col (S)

EIM uses this property. For Oracle use only.

Primary Child Column Name (S)

Specifies the name of the column that contains the primary ID value.

Primary Child Table Name (S)

Specifies the name of the table where Siebel CRM can locate the primary child.

Primary Inter Table Name (S)

EIM uses this property. For Oracle use only.

Primary Join Column Name (S)

Specifies the name of the column that Siebel CRM uses to join the record.

Primary Key (S)

If TRUE, then Siebel CRM uses this column as part of the primary key of the table.

Required (S)

If TRUE, then Siebel CRM requires this column. This requirement is true even if the Siebel database allows a NULL value.

Scale (S)

For more information, see About the Scale and Precision Properties.

Sequence Object (S)

If TRUE, then Siebel CRM uses a sequence object and automatically creates case column values. Only one foreign key can exist for the foreign key table for each table.

For Oracle use only.

Text Length (S)

Specifies the length in characters for a Text column or Varchar column. The column size in Siebel Tools is not the same as the column size in the physical database. For more information about this difference, see 531960.1 (Article ID) on My Oracle Support.

Translate

For Oracle internal use only. You must leave this property set to FALSE for an extension column.

Translation Table Name (S)

Specifies the name of the translation table.

Type (S)

Specifies the type.

Use FKey (S)

If TRUE, then Siebel CRM uses this foreign key during synchronization to evaluate visibility. You must leave this property set to FALSE for an extension column.

Use Key Sequence (S)

Specifies the order that Siebel CRM uses this column in the user key.

User Name (S)

Specifies the user-friendly name for the column.

Valid Condition (S)

Specifies the expression that Siebel CRM uses to validate column values.