Fetch Rate Map Id
These function can be used to get and map the Rate Component details with its other corresponding column/output values listed below.
Either combination of input parameters RS_CD, RC_DESCR, RS_DESCR, RC_SEQ can be passed or can directly pass input RC_MAP_ID to this function.
Function:
FETCH(RATE_COMPONENT[COLUMN_NAME,RS_CD,RC_DESCR,RS_DESCR,RC_SEQ,RC_MAP_ID,
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 | |
| RS_CD | Rate Schedule | Rate Component Map |
| RC_DESCR | Rate Component Description | Rate Component Language |
| RS_DESCR | Rate Schedule Description | Rate Schedule Language |
| RC_SEQ | Sequence | Rate Component Map |
| RC_MAP_ID | RC Map ID | Rate Component Map |
| 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:
| Output Parameter | Description | Table Description |
| RS_CD | Rate Schedule | Rate Component Map |
| RC_DESCR | Rate Component Description | Rate Component Language |
| RS_DESCR | Rate Schedule Description | Rate Schedule Language |
| RC_SEQ | Sequence | Rate Component Map |
| RC_MAP_ID | RC Map ID | Rate Component Map |