Fetch Invoice Construct ID

These function can be used to get the Invoice Construct Identifier and other corresponding below listed column/output values.

Invoice Contract identifier can be retrieved using Account Identifier i.e. ACCT_​NBR. Using this identifier we look for BILLING ACCOUNT ID in Construct table.

ACCT_​NBR is mandatory input while the other remaining input parameters are optional for this function.

Function: 

FETCH(INV_CONSTRUCT[COLUMN_NAME,ACCT_NBR,ACCT_NBR_TYPE_CD,ACCT_ID,
TEMPLATE_PURPOSE_FLG,EFFT_START_DT,EFFT_END_DT,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
ACCT_​ID Account ID Maintains External Account Numbers
TEMPLATE_​PURPOSE_​FLG Template Purpose Flag Construct Template
EFFT_​START_​DT Effective Start Date Construct
EFFT_​END_​DT Effective End Date Construct
STATUS_​FLG Status Flag. By default its value will be ‘ACTV’. Construct
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
CONSTRUCT_​ID Construct ID Construct
TEMPLATE_​PURPOSE_​FLG Template Purpose Flag Construct Template
EFFT_​START_​DT Effective Start Date Construct
EFFT_​END_​DT Effective End Date Construct
CONSTRUCT_​DESC Contract Description Construct
TYPE_​FLG Type Flag Construct
VERSION_​NUM Version Number Construct
BILLING_​ACCT_​ID Contract Type Construct Template
STATUS_​FLG Status Flag Construct