> 
> 
> 
> 
The Data Mapping Field Definition lookup displays definitions related to a given field in OLE. This information includes definitions such as the functional field description, the length of the field, whether or not it is encrypted, and the name of the field at the database level
Note
This data can only be updated by a technical resource and many of the values here are only meaningful to a technical user.
 |
Data Mapping Field Definition Lookup definition
|
Title |
Description |
|
Namespace |
Required. Select the namespace (large functional category) associated with the field you wish to search for. |
|
Component |
Required. Enter or search for and return the component (more specific functional category, such as a given screen or document section) associated with the field you wish to search for. |
|
Field |
Optional. Enter the field name of the field you wish to search for or use the lookup to search for it. |
|
Description |
Optional. Search for a field by its description. Remember that wildcards can be used, such as *account* to return all fields with the word 'account' in their description. |
|
Database Table Name |
Optional. Enter the name of the table in which the field you're searching for resides. |
|
Database Field Name |
Optional. Enter the name that identifies the field in the database. |
 |
The results display the namespace, component, field name, description and database field name and table name. Click on the linked field name to view the inquiry which contains additional data fields.
 |
Fields appearing on the inquiry and not previously described above are detailed here.
Data Mapping Field Definition Inquiry definition
|
Title |
Description |
|
Database Data Type |
The type of data expected for this field by the database. |
|
Application Data Type |
The type of data the application expects in this field. |
|
Database Defined Length |
The maximum character length of the field in the database. |
|
Application Defined Length |
The maximum character length of the field in the application. |
|
Decimal Places |
The number of decimal places supported by this field. |
|
Reference Component |
OLE component where this field originates. For example, an account number field has a reference component of 'account' indicating it is defined on the Account document. |
|
Required |
Indicates if the field must be completed for this particular component. |
|
Validation Pattern |
The technical pattern used to determine if the data in the field is valid. |
|
Encrypted |
Indicates if the field is encrypted at the database level. |
|
Mask Pattern |
If a field is masked (its content partially or fully obscured to unauthorized users) this field defines the type of masking used. |
