Populating the INTFC_BI table for NOTE transactions

The following table demonstrates how to populate the INTFC_BI fields for NOTE transactions:

Field Number Field Name Required for NOTE Transactions? Remarks

1

INTFC_ID (interface ID)

Required.

Used to group or batch a collection of Billing interface activity.

2

INTFC_LINE_NUM (interface line number)

Required.

Each unique interface line number for an interface ID represents a separate bill line charge.

3

TRANS_TYPE_BI (transaction type)

Required.

Value must be NOTE.

4

TRANS_TYPE_BI_SEQ (transaction type sequence)

Required.

If more than one note is populated for a particular LINE transaction, the transaction type sequence must be used for uniqueness.

Note: Do not initialize to zero, for note transactions, TRANS_TYPE_BI_SEQ must begin with 1.

13

LOAD_STATUS_BI

Optional.

May initialize to NEW or leave blank.

15

BUSINESS_UNIT (billing business unit)

Required.

Must be a valid billing business unit.

156

NOTE_TYPE

Optional.

 

157

STD_NOTE_FLAG (standard note flag)

Optional.

Y is the default value if a standard note code (STD_NOTE_CD) exists and the note text (TEXT254) is blank. N is the default value if note text (TEXT254) is populated and standard note code (STD_NOTE_CD) is blank.

158

INTERNAL_FLAG

Required.

Must be Y or N.

159

HDR_OR_LINE_NOTE (header or line note flag)

Optional.

Values are: H (header note) and L (line note). L appears as the default value, if left blank.

184

REIMB_AGREEMENT

Optional.

 

246

ADD_DTTM

Optional.

Allows accurate reporting on interface activity. Used by interface workflow functions.