Fields - Main

Select Fields from Admin Menu to navigate to the Fields View. Field Metadata can be edited in the Main Tab

Field MetaData - Main Tab

Field MetaData - Main Tab

Fastpath: If you change a field's label, the new label appears on ALL transactions on which the field exists.
Warning: A field's label can be overridden for a specific table. If this is the case and you change the field's name on this transaction, the change will have no effect when the field is displayed for that specific table. If you find this to be true, change the field's label on the respective table on which it was overridden. You do this using the Table Maintenance transaction (for details see the Oracle Utilities Application Framework Administration Guide).

Properties Description

Open this page using Admin Menu, Field.

Many fields on this page are protected as only the product development group may change them. The following describes fields you may change for records that are part of the base product. Fields containing information that may be of interest are also described.

Field Name uniquely identifies this field.

Fastpath: If you introduce new fields, you must prefix the field with CM. If you do not do this, there is a possibility that a future release of the application could introduce a new field with the name you allocated.

Owner indicates if this field is owned by the base package or by your implementation (Customer Modification). The system sets the owner to Customer Modification when you add a field. This information is display-only.

Base Field

Data Type indicates if the field will hold Character, Date, DateTime, Number, Time, or Varchar2 data.

Ext Data Type

Precision defines the length of the field. In the case of variable length fields, it is the maximum length possible.

Scale

Sign

Level

88 Cpybk

Description contains the label of the field. This is the label of the field that appears on the various pages on which the field is displayed. Note, the field's label can be overridden for a specific table (by specifying an Override Label on the table/field information; for details see the Oracle Utilities Application Framework Administration Guide).

Java Field Name

Override Label

Check Work Field if the field does not represent a database table column.

Help Text

Special Notescontains any notes or special information about the field.