Fetch Price List

These function can be used to get the price list along with its other corresponding field values i.e. below listed column/output values.

Either of parameter PRICELIST_ID or DESCR is mandatory inputs for this function.

Function:

FETCH(PRICE_LIST[COLUMN_NAME,PRICELIST_ID,PL_TYPE,PL_STATUS_FLG,DESCR,
LANGUAGE_CD,SET_OPERATION])

Expected list of input field/column values:

Input Parameter	Description	Table Description
COLUMN_NAME	Column name to be mapped from the returned RESULTSET. i.e. OUTPUT field name
PRICELIST_ID	Price List ID	Price List
PL_TYPE	Price List Type	Price List
PL_STATUS_FLG	Status	Price List
DESCR	Description (This can have the wild card ‘%’ to pass the partial description)	Price List
LANGUAGE_CD	Primary ID switch	Price List Language
SET_OPERATION	This is a BOOLEAN value. If TRUE - Reset operation configured at service level. If FALSE - Validate the fetch function output i.e. Throws error if returns NULL or multiple records. If NULL – Will do nothing but only throw an error if function return multiple records.

List of output field/column values: