Populating the INTFC_BI_NOTE Table for standard notes

The INTFC_BI_NOTE table has the same key structure as the INTFC_BI table; consider it an extension of the INTFC_BI table. In addition to the key fields, the table contains one additional column: TEXT254. Populate this table to pass nonstandard notes along with an interface transaction line. The TEXT254 column is used to hold the note text. The value of the TRANS_TYPE_BI column for the INTFC_BI_NOTE table must be NOTE.

For every row in INTFC_BI_NOTE, there must exist a row in INTFC_BI with the same key values. You do not, however, need a row in INTFC_BI_NOTE for every row in INTFC_BI.

If you are passing standard notes (the note is already predefined in the PeopleSoft Billing system), you do not need to pass an associated INTFC_BI_NOTE row. Specify the note code in the STD_NOTE_CD column.

If you elect to pass a nonstandard note in INTFC_BI_NOTE, the associated row in INTFC_BI must have the standard note code column (STD_NOTE_CD) set to blank.

The following table demonstrates how to populate the INTFC_BI_NOTE table:

Field Number	Field	NOTE
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: For note transactions, do not initialize TRANS_TYPE_BI_SEQ to zero. For note transactions, TRANS_TYPE_BI_SEQ must begin with 1.
5	PROCESS_INSTANCE	Leave blank.
6	TEXT254 (note text)	Required if standard note (STD_NOTE_CD) is left blank on the associated row in INTFC_BI.
7	ADD_DTTM	Required for accurate reporting purposes and for taking advantage of interface workflow function.
8	LAST_UPDATE_DTTM	Leave blank.