Properties shared between overlays and origin objects
Properties inherited from origin object
Property inherited from origin object | Permitted modification on overlay object |
---|---|
Object name | You cannot change in an overlay. |
Unique indexes | You cannot change in an overlay. |
FTS
| If these values are set in the base, they are inherited from the base. You cannot change the values in the overlay form. If the values are modified in the base form, they are inherited in the overlay form. See Configuring forms for multiple-form FTS. |
Audit and archiving | If set in the base, you cannot modify in an overlay. See How-auditing-and-archiving-work-with-overlays-and-custom-objects. |
Form application owner | You cannot change in an overlay. |
Join form information | If you overlay a member form's field and you overlay the same field on the join form, you will see changes made in the member form overlay in the join. |
Vendor form plug-in | You cannot change the server plug-in that is used to supply data for the vendor form. |
View form database table | You cannot change the source table used to supply data for the view form. |
An overlay of a form has data in the same tables as the origin form. An overlay of a field has data in the same columns as the origin field. Some changes to data can cause extra columns to be created in a table, or can affect what is written in the columns. The following table explains these changes.
Impact of modifying shared properties on the database tables
Property | Permitted modification on overlay | Impact on database table |
---|---|---|
Enum or Selection field | There are no restrictions on changing the properties of an Enum field. If you add new values, the data is stored and available through the overlay object and the origin object, but the origin object cannot display a label for the enum field. If the same value is later added to the origin object through an upgrade, you must reconcile the difference. | Enumerated values are stored in a column that is visible to the origin and overlay objects. |
FTS and multiform search properties | Most FTS properties on origin and overlay objects are to be considered cumulative. The following multiform search properties cannot be cumulative (exceptions):
| There is no impact on the database, but effects are seen in the origin object and the overlay. |
Functional currency for a Currency field |
| For each functional currency that you add to a Currency field, a column is added in the database. The number of columns in the database is a sum of the number of functional currencies added to the origin object and its overlay. |
Length of a Character field | Changing the field length | Lengths of the origin Character field and its overlay are compared to find the maximum of the two. Actual length of the corresponding column in the main data table is set to this value. For example, if the origin field's length is 100 bytes and the overlay field's length is 200 bytes, the size of the corresponding database column is 200 bytes. Switching from a CLOB to a shorter database length can cause loss of data because they are different database types. |
Next request ID block size | You can set this property independently on the overlaid and overlay objects. | At runtime, the maximum of the next ID block size of the overlaid and overlay object is used. |
Non-unique index on a form |
| Actual indexes on the main data table reflect a combination of the indexes on the origin object and its overlay. |
Status History | By default, Status History is enabled for a form. When Status History is disabled, the AR System server removes any current status history entries. Status History must be disabled on both the origin and overlay objects for it to be removed.
| If Status History is enabled on one of the origin and overlay objects and is disabled on the other, the status history will only be stored on the object where it is enabled. |
Archive and audit | If set in the origin form, data for both the origin and the overlay are archived and audited to the same place. |