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 |