Fetch Price Assignment
These function can be used to get the price assignment details for the given Owner ID or Price Item Code or Price Assign ID.
Function:
FETCH(PRICE_ASSIGNMENT[COLUMN_NAME,OWNER_ID,PRICEITEM_CD,PRICE_STATUS_FLAG,
CRR_DT,PRICE_ASGN_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 | |
| OWNER_ID | Owner ID | Price Assignment |
| PRICEITEM_CD | Price Item | Price Assignment |
| PRICE_STATUS_FLAG | Pricing Status | Price Assignment |
| CRR_DT | This date will be compared to be greater than or equal to END DATE in Price Assignment | Price Assignment |
| PRICE_ASGN_ID | Price Assignment ID | Price Assignment |
| 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 |
| PRICE_ASGN_ID | Price Assignment ID | Price Assignment |
| OWNER_ID | Owner ID | Price Assignment |
| PA_OWNER_TYPE_FLG | Price Assignment Owner Type Flag | Price Assignment |
| START_DT | Start Date | Price Assignment |
| END_DT | End Date | Price Assignment |
| PRICEITEM_CD | Price Item | Price Assignment |
| PRICE_CURRENCY_CD | Pricing Currency | Price Assignment |
| PRICE_STATUS_FLAG | Pricing Status | Price Assignment |
| RS_CD | Rate Schedule | Price Assignment |
| PA_TYPE_FLAG | Price Assignment Type | Price Assignment |
| TXN_RATING_CRITERIA | Transaction Rating Criteria | Price Assignment |