Understanding the Extract Tables

All invoice programs select data from the extract tables rather than directly from the Billing tables. The first step to printing invoices (after finalization) is to run the BI_IVCEXT extract process. The extract process populates the following extract tables:

Term	Definition
BI_EXTRCT	The main printing extract table. Inserts one row per invoice. Most calculated data applies to the entire invoice, not the invoice lines.
BI_EXTRCT_LINE	Comprised of calculated data for invoice lines. The data in this table supports printing Product Kit Descriptions with the invoice lines.
BI_EXT_HDR_NOTE	Stores the header, customer, and VAT notes that are to be printed on an invoice. If a note is a standard note, then the text that is to be printed comes from the Standard Notes table and is language specific. This table is populated with the nonstandard note text from the bill header and customer. The notes are updated as primary notes if you define the note type as a primary note type on the invoice form.
BI_EXT_LIN_NOTE	Stores line notes to be printed on an invoice.
BI_EXTRCT_GRANT	Stores Grant related information.
BI_EXT_GRANT_LN	Contains Grant lines related information.
BI_EXTRCT_TAX	Stores sales and use tax data for invoice lines.
BI_EXTRCT_VAT	Contains VAT information for invoice lines.
BI_EXT_INST_SEC	Contains installment billing information that is used only for installment invoices.
BI_EXT_INST_SUM	Contains installment billing summary information that is used only for installment invoices.
BI_EXTRCT_PROJ	Stores PeopleSoft Project lines that are extracted for Invoice sample formats PS/PSA01, PS/PSA02, and PS/PSA03.
BI_EXTR_CONTR	Stores PeopleSoft Contract lines that are extracted for Invoice sample format PS/CA only.
BI_EXTRCT_UTL	Contains PeopleSoft Contract prepaid utilization rows. Used in Invoice sample formats PS/PSA01and PS/PSA02.
BI_EXT_SHIP_TO	Contains ship-to name and address of extract based on the ship-to customer ID and ship-to address sequence number that is defined on the bill header. It is currently used in Invoice sample formats PS/PSA01, PS/PSA02, PS/PSA03 and PS/CA. For Sales Orders having a header address override, that ship-to will be extracted from the order if the bill header contains the sales order information.
BI_EXTRCT_GST	Only for India transactions.
BI_EXT_BILL_TO	Contains Bill To name and address. Only for India transactions.
BI_EXT_EXSGST	Contains HSN code, reverse charge applicability and tax rate and tax amount for the GST tax components like CGST, SGST, IGST. Only for India transactions.
PS_BI_EXTRCT_TXDTL	Contains sales tax detail.
PS_BI_EXT_EXSDTL	Contains sales/excise tax detail for India transactions.
PS_BI_EXTRCT_PAY	Contains invoice payment information.
PS_BI_EXT_SUM_GPHR	Contains summarized invoice group header information.
PS_BI_EXT_SUM_IVC	Contains summarized bill line information.
PS_BI_EXT_SUM_NT	Contains summarized bill header note information.
PS_BI_EXT_SUM_LNNT	Contains summarized bill line note information.
BI_EXT_1034	Contains 1034 Bill Header information.
BI_EXT_BAE_1035	Contains BAE 1035 information.
BI_EXT_RAE_1035	Contains RAE 1035 information.
BI_EXT_FEE_1035	Contains FEE 1035 information.
BI_EXT_GPLN_1035	Contains grouped line 1035 information.
BI_EXT_LN_1035	Contains ungrouped line 1035 information.
BI_EXT_NOTE_1035	Contains 1035 line note information.
BI_EXT_NT_BAE	Contains 1035 BAE line note information.
BI_EXT_NT_RAE	Contains 1035 RAE line note information.
BI_EXT_NT_FEE	Contains 1035 FEE line note information.
BI_EXT_NT_GRP	Contains 1035 grouped line note information.
BI_EXT_NT_LN	Contains 1035 line note information.