Populating the INTFC_BI_NOTE Table
This topic provides an overview of the INTFC_BI_NOTE table and discusses how to populate the INTFC_BI_NOTE table.
The Billing Interface Note/Comment table (INTFC_BI_NOTE) contains the text of nonstandard notes and comments. Each record corresponds to a record on the INTFC_BI table having a transaction type of NOTE. The following four attributes comprise the key to the INTFC_BI_NOTE table:
Term |
Definition |
---|---|
INTFC_ID (interface ID) |
Represents a group or batch of billing activity—that is, a collection of billing activity that may be produced by a billing source system. For example, a system may generate a group or batch each night, while another may produce a group or batch for a certain kind of billing activity. |
INTFC_LINE_NUM (interface line number) |
With INTFC_ID, identifies the NOTE record on the INTFC_BI table to which this note entry applies. |
TRANS_TYPE_BI (transaction type billing) |
Characterizes the type of data being stored. NOTE (custom note or comment) is the only valid option. |
TRANS_TYPE_BI_SEQ (transaction type billing sequence) |
Part of the key that provides uniqueness in the event that there are multiple notes or comments for a bill line charge. |
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. |