Fetch Account Characteristic

These function can be used to get and map the account Identifier or its corresponding Characteristic values in ORMB system to the input payload i.e. manipulate the service payload.

ACCT_​NBR input is mandatory and the other remaining field inputs are optional. Input fields with no mapping can have “NULL” value in the function.

Function:

FETCH(ACCT_CHAR[COLUMN_NAME,ACCT_NBR,ACCT_NBR_TYPE_CD,CHAR_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
ACCT_​NBR Account Identifier Maintains External Account Numbers
ACCT_​NBR_​TYPE_​CD Account Identifier Type Maintains External Account Numbers
CHAR_​TYPE_​CD Characteristic Type Code Account Characteristics
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
ACCT_​NBR_​TYPE_​CD Account Identifier Type Maintains External Account Numbers
ACCT_​USAGE_​FLG Account Usage Account
CHAR_​TYPE_​CD Characteristic Type Code Account Characteristics
CHAR_​VAL Characteristic Value Account Characteristics
EFFDT Effective Date Account Characteristics
CHAR_​VAL_​FK1 Characteristic Value FK1 Account Characteristics
CHAR_​VAL_​FK2 Characteristic Value FK2 Account Characteristics
CHAR_​VAL_​FK3 Characteristic Value FK3 Account Characteristics
CHAR_​VAL_​FK4 Characteristic Value FK4 Account Characteristics
CHAR_​VAL_​FK5 Characteristic Value FK5 Account Characteristics
VERSION Version Account