Using special characters

The fields that are a part of the logical key for any record in the Sterling Selling and Fulfillment Foundation schema (such as OrganizationCode and OrderNo) have some restrictions. For such fields, the application does not support the use of special characters listed in the following table.

Special Character Description
& Ampersand
> Greater Than
< Less Than
% Percent
" Quotation Mark
+ Plus sign
' Single quotation or Apostrophe
( Parenthesis
) Parenthesis
[ Square Bracket
] Square Bracket

Note: You can use the plus (+) and ampersand (&) signs only in the ItemID field.
Note: A forward slash (/) must not be used in attributes that form part of a path in another attribute. For example, Category ID must not include a forward slash, as Category ID is used to form the attribute Category Path, which uses the forward slash as a path separator.

In addition,IBM® recommends against using third-party vendors' reserved special characters. For example, in certain situations, data with underscore characters ("_") on an Oracle database could result in unexpectedly slow query performance because the database deciphers the underscore as a single character wildcard.

The following fields have no restrictions and support all characters:
Note: The Sterling Selling and Fulfillment Foundation Mobile Device does not support the use of the ampersand (&) character.