These settings are where purchase order lookups are defined. See the Use Stored Procedure option in both Settings > IP Configuration > Capture Profiles > PO Number Settings > PO Number Validation tab and the Settings > IP Configuration > Capture Profiles > Line Pairing Settings.

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 stored procedure parameter index.

Parameter Name

The name of the stored procedure parameter.

This value is mandatory for each stored procedure parameter.

Parameter Type

The stored procedure parameter type.

Possible options include BOOLEAN, INT, DATE, DOUBLE, and VARCHAR. For any other entries, such as a blank entry, the UNKNOWN type is used.

Parameter Size

This setting only applies if the Parameter Type is set to VARCHAR above.

In this case, this setting specifies the maximum length allowed. If this setting is left blank, or contains zero or a non-numeric entry, a default size of 50 is used.

Parameter Value

The definition of the parameter. You can specify one of the following field technical names.

• PONumber

• CompanyCode

Note These are case sensitive and must match the field names exactly.

Parameter Direction

Select I if you want the parameter direction set to input. Select O for output.

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 Stored Procedure Settings - Edit window.

Add

Adds an entry to the table.

Click to open the Stored Procedure Settings - 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 to copy the selected table entry and open the Stored Procedure Settings - New window.

Delete

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