When you select a record in the Stored Procedure Settings table, and then click Add or Copy, all editable fields from the Stored Procedure Settings are displayed. This enables you to either add a new stored procedure or to copy an existing stored procedure.

The following options are available.

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.