Understanding the INTFC_BI_AEDS Table

The Billing Interface Accounting Entry and Discount/Surcharge table (INTFC_BI_AEDS) contains only AE, DDS and DS transactions. The following four attributes comprise the key to the INTFC_BI_AEDS 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 bill line charge on the INTFC_BI table to which this accounting entry, discount, or surcharge applies.
TRANS_TYPE_BI (transaction type billing)	Characterizes the type of data being stored. Options are: AE (bill line accounting entry). DS (bill line discount or surcharge). DDS (bill line deferred discount or surcharge entry). For each interface line number associated with an interface ID, there should be only one row of transaction type LINE in the INTFC_BI table. There can be multiple rows with transaction types containing AE, DS, or DDS values in the INTFC_BI_AEDS table. When the contract liability feature is enabled, bill lines using revenue recognition basis other than INV (invoice date) must have contract liability ChartFields associated with the revenue ChartFields.
TRANS_TYPE_BI_SEQ (transaction type billing sequence)	The part of the key that provides uniqueness in the event that there are multiple AE, DS, or DDS transactions for a bill line charge.