These settings define purchase order number formatting for extraction. It is possible to add multiple entries for these settings. As a result, the settings are displayed in a table.

The following column settings are available.

Index

The unique ID assigned by the system for each format string used to generate purchase order number alternatives.

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 Help for Transformation Designer.

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.

The following buttons are available at the bottom of the window.

Edit

Opens a selected entry in the table so that you can make changes as needed.

Click to open the PO Number Formats - Edit window.

Add

Adds an entry to the table.

Click to open the PO Number Formats - New window.

Copy

Makes a copy of the selected table entry so that you can make a new entry to the table based on the copy.

Click a copy of the selected table entry and open the PO Number Formats - New window.

Delete

Click to remove the selected entry from the table, but after confirmation only.