Fetch Adjustment Contract
These function can be used to get and map the account identifier, Contract ID or its corresponding column values in ORMB system to the input payload i.e. manipulate the service payload.
Get the Contract ID, Contract Type for the relationship between “SA Type Adjustment Type Profile” and “Adjustment Type / Adjustment Type Profile”
ACCT_NBR is mandatory input and other remaining field inputs are optional. Input fields with no mapping can have “NULL” value in the function.
Function:
FETCH(ADJSA[COLUMN_NAME,ACCT_NBR,ACCT_NBR_TYPE_CD,ADJ_TYP_CD,
DIVISION,ACCT_USAGE_FLG,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 | |
| ACCT_NBR | Account Identifier | Maintains External Account Numbers |
| ACCT_NBR_TYPE_CD | Account Identifier Type | Maintains External Account Numbers |
| ADJ_TYP_CD | Adjustment Type Code | Adjustment Type / Adjustment Type Profile |
| DIVISION | Division | Account |
| ACCT_USAGE_FLG | Account Usage | Account |
| 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 |
| ACCT_ID | Account ID | Account |
| CIS_DIVISION | Division of an Account | Account |
| CURRENCY_CD | Currency Code of an Account | Account |
| SA_ID | Contract ID | SA (Service Agreement) |
| SA_TYPE_CD | Contract Type | SA (Service Agreement) |
| ADJ_TYPE_CD | Account Relationship Type | Adjustment Type / Adjustment Type Profile |
| ACCT_NBR_TYPE_CD | Account Identifier Type | Maintains External Account Numbers |
| ACCT_USAGE_FLG | Account Usage | Account |
| VERSION | Version | SA (Service Agreement) |