Fetch Account

The fetch account function can be used to get and map the account identifier or its corresponding column values in the 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
COLUMN_NAME	Column name to be mapped from the returned RESULTSET. i.e. OUTPUT field name.
PER_ID_NBR	Person identification number.
ID_TYPE_CD	Person identifier type.
ACCT_REL_TYPE_CD	Account relationship type.
ACCT_NBR	Account identifier.
ACCT_NBR_TYPE_CD	Account identifier type.
DIVISION	Division.
ACCT_USAGE_FLG	Account usage.
PRIM_SW	Primary ID switch.
SET_OPERATION	This is a `BOOLEAN` value. If TRUE - Reset operation is configured at the service level. If FALSE - Validates the fetch function output i.e. throws error if returns `NULL` or multiple records. If NULL – Will respond with an error if any function returns multiple records.

List of output field/column values:

Output Parameter	Description
ACCT_ID	Account ID.
CIS_DIVISION	Division of the account.
CURRENCY_CD	Currency code of the account
PER_ID	Person ID. Note: Returned only when PER_ID_NBR is passed as the function input.
ID_TYPE_CD	Person identifier type. Note: Returned only when PER_ID_NBR is passed as the function input.
ACCT_REL_TYPE_CD	Account relationship type. Note: Returned only when PER_ID_NBR is passed as the function input.
ACCT_NBR_TYPE_CD	Account identifier type.
ACCT_USAGE_FLG	Account usage.
VERSION	Version.