Hi,

The LOV SQL should return both the supplier name and the customer number (or supplier number).

Create Two Columns in Your Integrator:
For example:
Attribute1: Supplier/Vendor Name (with Table LOV attached)
Attribute2: Supplier Number or ID (to capture supplier_number or vendor_id)

Define the Table LOV With Return Attributes:
In WebADI's “Define Table LOV” form (or when defining via the integrator interface), you can assign Return Attributes. This mapping determines which LOV column populates which attribute in your integrator.
Specify:

Display Column: Maps to Supplier/Vendor Name (populates Attribute1)
Return Column(s): Map Supplier Number/ID to Attribute2

For example:
Table column 1: SUPPLIER_NAME ➔ Binds to Attribute1 (displayed)
Table column 2: SUPPLIER_NUMBER or SUPPLIER_ID ➔ Binds to Attribute2 (not shown but auto-filled on selection)

Setting Up the Return Mapping:
In the “Define Table LOV” UI, there should be a Return Attributes section.
For the column you want to return (e.g., supplier number), enter the target attribute (e.g., Attribute2) in the “Attribute Name” field.

Validate and Test:
When using the integrator, selecting a value from the LOV should populate Attribute1 with the vendor name and Attribute2 with the vendor number or ID.

Make sure both attributes are defined as columns in your integrator definition.
You must set up the Return Attribute mapping for your LOV in the custom integrator definition; this is not a default behavior, but a specific setup step.

Regards,

Monika