Specifying Data Values

The same formatting rules for specifying payload data values applies to filters. Unless otherwise stated, follow the general rules specified for dates, financial periods and data dictionary values.

Dates

When writing filter selection conditions that use dates, specify the date in ddmmccyy format, for example:

<Filter>
<Item name="/PurchaseOrder/EntryDate" operator="EQU" value="02052004"/>
</Filter>

Financial Periods

When writing filter selection conditions that use financial periods, specify the period in 'pppccyy' format, for example:

<Filter>
<Item name="/Asset/StartPeriod" operator="EQU" value="0012004"/>
</Filter>

Data Dictionary Values

When writing filter selection conditions that use data items that have Data Dictionary Values, (DDVs), specify the DDV.

Note: Data Dictionary Values are special values that can be assigned to XML payload elements. They have specific meanings and are used to reduce the amount of information retrieved from, or sent to, the SunSystems database. For example, the following values are valid for the <Status> element in an Accounts payload: 0,1, 2 and 3. These are a shorthand way of representing their meanings: Open, Hidden, Suspended/Held and Closed/Completed, respectively.

Using Status as an example, your filter should specify value="0", rather than value="open".

The values written to the output payload are the DDVs and not the text equivalent. So, the <Status> element is written as: <Status>0</Status> and not <Status>Open</Status>.