Tables of Significant Impact

This table contains information about tables of significant impact:

Table	Required/Optional	Description	Used
Bill By (BI_BILL_BY)	Required for external interface.	The criteria that you use to group billing activity onto a single bill. An example is contract number, where each contract number for a customer defines a separate bill.	Used only for billing activity coming through an external interface.
Distribution Code (DST_CODE_TBL)	Conditional.	Represents a valid combination of ChartFields to be posted to the general ledger.	This code makes the deferred distribution code appear by default. Each billing identifier, such as a charge code, discount, or surcharge, may have a default distribution code.
Invoice Format (BI_IVC_FORM)	Required.	A combination of parameters that control the display of information, such as notes, taxes, discounts and surcharges, and sorting of lines, for a particular invoice layout.	Used in the pro forma and invoice printing process.
Invoice Layout (BI_IVC_LAYOUT)	Required.	Identifies the Structured Query Report (SQR) program that controls the general layout of the invoice.	Uniquely named in the actual SQR program.
Invoice Number ID (BI_IVC_NUM)	Required.	Defines an invoice numbering scheme, including how many parts, text for prefixes and suffixes, next autosequence number, and length of field.	You can use many different invoice numbering schemes throughout the system at various levels.
Page Series (BI_PNLSERIESHDR)	Conditional.	Defines the pages and their order of use for bill entry.	You can assign a different page series at various levels, such as business unit or bill type, depending on your needs.
Payment Terms (PAY_TRMS_TBL) and Payment Terms Timing (PAY_TRMS_TIME)	Required.	Payment term identifies the payment due date and any payment discounts. You establish a payment terms timing so that the system can calculate a payment term.	Payment terms mainly provide information that is to be printed on invoices. Processing, such as calculating discounts, takes place in the receivables system.
Sort By Identifier (BI_SORT_BY)	Required.	Identifies the sort order of bill lines on an invoice, such as by alphabetical bill line description or descending charge from date.	Each invoice format has a sort by identifier. The Pro Forma Pre-process or Invoice Finalization (BIIVC000) process assigns invoice line sequence numbers accordingly.