Alias (S)

Not used.

Cascade Clear (S)

A TRUE or FALSE value. TRUE indicates to EIM how to handle this foreign key on delete of the related entity.

Leave FALSE for extension columns.

Default (S)

The value used for this column in new records.

Denormalization Path (S)

The path that is being denormalized if this is a denormalization column.

Applies to denormalization of user key columns into intersection tables.

EIM Processing Column Flag (S)

A TRUE or FALSE value. TRUE indicates that this interface table's column is reserved for EIM processing.

This flag should not be used for customer data.

Force Case (S)

Indicates if new values should be forced to uppercase letters.

Foreign Key Table Name (S)

Specifies the table to which this column is a foreign key, used by EIM.

Lov Bounded (S)

A TRUE or FALSE value.

If LOV Bounded is TRUE, EIM checks the values as it imports against the values contained in a list defined in LOV Type. In that case, LOV data should be imported first into S_LST_OF_VAL, and LOV Type must be specified.

This property is read-only for standard columns in Siebel applications, but is editable for columns that have been added by way of the Database Extension Designer.

Lov Type (S)

Specifies the list of values domain in which this column is validated. Used in conjunction with the LOV Bounded property. List of values domains are defined in List of Values Administration in the client.

This property is read-only for standard columns in Siebel applications but is editable for columns that have been added by way of the Database Extension Designer.

Name (S)

Specifies the name, which must be unique within the table.

Nullable (S)

A TRUE or FALSE value. TRUE indicates that NULL can be stored in this column by the database.

Physical Type (S)

Identifies the data type of the column in the database.

Precision (S)

The total number of digits in a number column.

For non-integer columns, the precision is 22. For integer columns, the precision is 10.

Primary Child Col (S)

Used by EIM. For Siebel Systems use only.

Primary Child Column Name (S)

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

Primary Child Table Name (S)

The name of the table from which the primary child is to be found.

Primary Inter Table Name (S)

Used by EIM. For Siebel Systems use only.

Primary Join Column Name (S)

The name of the column on which to join to the base record.

Primary Key (S)

A TRUE or FALSE value. If TRUE, consider this column part of the primary key of the table.

Required (S)

A TRUE or FALSE value. If TRUE, the application requires this column. For example, even if the database allows NULLs, the application does not.

Scale (S)

The number of decimal digits in a number column, out of the total number of digits (precision).

For non-integer columns, the scale is 7. For integer columns, the scale is 0.

Sequence Object (S)

A TRUE or FALSE value. TRUE indicates that a Sequence Object is specified, in which case column values are auto-generated.

For Siebel Systems use only.

For each table, there should be only one foreign key for the foreign key table.

Text Length (S)

The length in characters for Text and Varchar columns.

Translation Table Name (S)

The name of the translation table.

Type (S)

Describes what this column is used for.

Use FKey (S)

A TRUE or FALSE value. TRUE indicates that this foreign key is to be used by synchronization in evaluating visibility. Leave FALSE in extension columns.

Use Key Sequence (S)

The sequence in the user key where this column fits.

User Name (S)

The "user-friendly" name for the column.

Valid Condition (S)

The expression for validating column values.