Oracle CRM On Demand Desktop Administration Guide > XML Files Reference >

XML Code to Map a Field in DB_FACADE storage

For objects that use DB FACADE storage, the mapping of a field is different and has the following structure:

<database>
   <types>
      <type id="Currency" icon="type_image:Currency:16">
         <field id="Name">
            <type>
               <simple type="string" />
            </type>
         </field>
      </type>
   </types>
</database>

The following attributes must be defined for the <type> element:

• id. Defines the ID or name of the Oracle CRM On Demand object that Oracle CRM On Demand Desktop maps to when DB FACADE storage is used.
• icon. Defines the image used to accompany an object's records in a list. The id attribute for the <field> element defines the ID or name of the Oracle CRM On Demand object's field.

The type attribute for <simple> element defines the type of the Oracle CRM On Demand object's field. The type attribute can have the following values for corresponding data types, for example, string for a string data type:

• string
• integer
• double
• boolean
• datetime

For the ID fields, that is, the fields used in links, the following construction exists, and you must use this construction when a field contains a link to the object placed in DB FACADE storage.

<field id="Primary Employee Id">
   <type>
      <foreign_key>
         <type_id>Employee</type_id>
      </foreign_key>
    </type>
</field>

However, when a field contains a link to the object placed in Outlook storage, use the following construction:

<field id="Primary Contact Id">
   <type>
      <simple type="binary" />
   </type>
</field>