Properties of a Table Column

The following table describes properties that Siebel CRM commonly uses with a table column.

Property	Description
Default	Stores a default value when Siebel CRM adds new table rows.
Foreign Key Table	Stores the table that this column references a foreign key. Siebel Enterprise Integration Manager (EIM) uses this information. For more information, see Mapping a Custom Table to an Interface Table.
LOV Bounded	Stores import behavior for EIM. If LOV Bounded is TRUE, then, during import, EIM checks the values against the values contained in a list defined in the LOV Type property. In that situation, LOV data must be imported first into the S_LST_OF_VAL table, and the LOV Type property must be defined. This property is read-only for a predefined column in Siebel CRM but you can edit it for a custom extension column.
LOV Type	Stores the list of values domain that the Siebel schema uses to validate this column. Siebel CRM uses it in conjunction with the LOV Bounded property. You define a list of values domain in the Administration - Data screen, List of Values view in the Siebel client. This property is read-only for a predefined column in Siebel CRM but you can edit it for a custom extension column.
Name	Stores the name of the database column in the database table.
Nullable	Indicates if the Siebel database can or cannot store NULL in this column. If TRUE, then Siebel CRM can store NULL.
Physical Type	For more information, see Physical Type Property of a Table Column.
Precision	Stores the maximum number of digits in a number column. For a noninteger column, the precision is 22. For an integer column, the precision is 10.
Primary Key	Stores the primary key for the table. If TRUE, then this column is the primary key for the table. With minor exceptions, the ROW_ID column in a table is the primary key, and it contains a TRUE value for this property.
Scale	Stores the maximum number of digits after the decimal point. For a noninteger column, the scale is 7. For an integer column, the scale is 0.
Type	For more information, see Type Property of a Table Column.
User Key Sequence	Stores the sequence in the user key where this column fits.