Fetch Account
These function can be used to get and map the account identifier or its corresponding column values in ORMB system to the input payload i.e. manipulate the service payload.
Account identifier can be retrieved for either the given PER_ID_NBR i.e. with reference to the defined relationship between Person and Account in “Account Person Relationship” table or ACCT_NBR i.e. with reference to the relationship defined in the “Maintains External Account Numbers” table.
Other remaining field inputs are optional. Input fields with no mapping can have “NULL” value in the function.
Function:
FETCH(ACCT[COLUMN_NAME,PER_ID_NBR,ID_TYPE_CD,ACCT_REL_TYPE_CD,
ACCT_NBR,ACCT_NBR_TYPE_CD,DIVISION,ACCT_USAGE_FLG,PRIM_SW,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 | |
| PER_ID_NBR | Person Id Number | Person Identifier |
| ID_TYPE_CD | Person Identifier Type | Person Identifier |
| ACCT_REL_TYPE_CD | Account Relationship Type | Account Person Relationship |
| ACCT_NBR | Account Identifier | Maintains External Account Numbers |
| ACCT_NBR_TYPE_CD | Account Identifier Type | Maintains External Account Numbers |
| DIVISION | Division | Account |
| ACCT_USAGE_FLG | Account Usage | Account |
| PRIM_SW | Primary ID switch | Person Identifier |
| 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 |
| PER_ID | Person ID (Returned only when PER_ID_NBR is passed as an function input) | Person Identifier |
| ID_TYPE_CD | Person Identifier Type (Returned only when PER_ID_NBR is passed as an function input) | Person Identifier |
| ACCT_REL_TYPE_CD | Account Relationship Type (Returned only when PER_ID_NBR is passed as an function input) | Account Person Relationship |
| ACCT_NBR_TYPE_CD | Account Identifier Type | Maintains External Account Numbers |
| ACCT_USAGE_FLG | Account Usage | Account |
| VERSION | Version | Account |