Fetch Functions

These are generic functions that can be used to get the required entity identifiers or its corresponding attributes that persist in ORMB system.

We can get the different field/column values using single fetch function. Provided FETCH functions that has an input parameter SET_​OPERATION has got the capability to reset the configured corresponding service level operation.

Function inputs can have the LITERAL values i.e. static values enclosed in single quotes or the CONSTANT values i.e. ”:BUS_​DATE, :BUS_​DTTM , :STD_​DATE, :STD_​DTTM, :SYSDATE, :SYS_​DTTM, :CHAR_​DATE, :FILENAME, :FILE_​ID“ or those configured FIELD names in FIELD TRANSFORMATION whose mapped value will be referred.

FETCH functions can be used in only FIELD TRANSFORMATION section but not in HEADER and FOOTER TRANSFORMATION.

List of FETCH functions:

• Fetch Account

• Fetch Account Characteristic

• Fetch Account Party UID

• Fetch Adjustment Contract

• Fetch Characteristic Entity Flag

• Fetch Characteristic Type Flag

• Fetch Contract

• Fetch Extendable Lookup value

• Fetch Invoice Construct ID

• Fetch Lookup

• Fetch Parent Person

• Fetch Price Assignment

• Fetch Person

• Fetch Person Characteristic

• Fetch Price Item Contract

• Fetch Price List

• Fetch Price List Characteristic

• Fetch Price List Assignment ID

• Fetch Person Party UID

• Fetch Person Relationship

• Fetch Rate Map Id

• Fetch User

• Check Access Group

Parent Topic: Supported Functions for Default Value