These settings are where purchase order lookups are defined. See the Use Stored Procedure option in both Solution Configuration Manager > Profile Settings > PO Number Validation and the Solution Configuration Manager > Profile Settings > 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 as input. Select "O" for output.