Conventions when using duplicate field names
In some calls, such as
getitemexpanded, you might have to pass in field names that are the same but that exist in different tables. In these cases, in order to distinguish which field belongs to which table, you need to append the initial letter to the table name when passing in the argument. If you use this convention with a single argument you must use it with all other field names in that call as well, regardless of whether they are duplicate field names.
Example:
• g.guests_no (guests table)
• i.item_id (items table)
• t.trans_no (transact table)
• a. address_id (address table)
In addition, field names such as c60 that do not appear in the data dictionary are automatically generated when there are duplicate field names in joined data sets. The description in the data set tells exactly what the duplicate field is.
Example:
<s:AttributeType name='c52' rs:name='department' rs:number='53' rs:nullable='true'
rs:writeunknown='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='10'
rs:fixedlength='true'/>
</s:AttributeType>