When you select the PO Number Formats and then click Add, or select a table entry and then click Copy, all editable fields from the PO Number Formats tab are displayed. This enables you to either add a new PO number format, or copy an existing PO number format.

The following options are available.

Format

The format string for a possible purchase order number. Multiple formats can be entered per profile ID, with one per index.

The # character is a wildcard that represents any number. The @ character represents any alpha character.

For example, 45######## indicates a purchase order number as a ten-digit number beginning with 45.

@@##### finds a purchase order number that has two alphabetic characters followed by 5 digits.

It is recommended to define these strings as precisely as possible to ensure that the correct value is located.

For more information on Simple Expressions see the Transformation Designer Help.

Ignore Characters

A list of allowed characters that may appear in a purchase order number. For example, a hyphen, forward slash, or a period.

This list does not need comma separation.