IGI Tables (223)

IGI - Public Sector Financials International — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
IGI_AP_INVOICES_ALL	8	Extended table that contains additional payables invoice information
IGI_AP_TRAN_TEMP	14	Upgrade Table to store information related to Gross Base Vat feature.
IGI_AR_ADJUSTMENTS_ALL	9	Cash basis posting information
IGI_AR_CASH_BASIS_DISTS_ALL	23	Distribution information for combined basis accounting
IGI_AR_CASH_RECEIPT_HIST_ALL	11	Cash posting control information
IGI_AR_CORR_PAY_SCHED_ALL	8	Invoice and correspondence information for invoices selected for dunning
IGI_AR_JOURNAL_INTERIM	93	Copy of AR_JOURNAL_INTERIM_ALL. Used by ARC and CBR.
IGI_AR_MISC_CASH_DISTS_ALL	9	Cash posting control information
IGI_AR_POSTING_CONTROL	15	Process control information for cash basis transfer programs
IGI_AR_REC_APPLICATIONS_ALL	9	Cash posting control information
IGI_AR_SYSTEM_OPTIONS_ALL	21	Extended Receivables system options table
IGI_BUD_AUTOCOPY_CONTROL	2	Contols autocopy of accounting flexfields
IGI_BUD_BUDGET_VERSIONS	7	Extended table linked to GL_BUDGET_VERSIONS
IGI_BUD_CODE_COMBINATIONS	4	Extended table linked to GL_CODE_COMBINATIONS
IGI_BUD_CODE_RANGES	68	Contains information on code ranges used by budgeting extensions
IGI_BUD_FROZEN_CCIDS	2	Contains information on frozen code combinations
IGI_BUD_JOURNAL_BATCHES	16	Contains information on budget journal batches
IGI_BUD_JOURNAL_HEADERS	19	Contains information on budget journal headers
IGI_BUD_JOURNAL_LINES	20	Contains information on budget journal lines
IGI_BUD_JOURNAL_PERIODS	15	Contains information on budget journal periods
IGI_BUD_NY_BALANCES	6	Contains information on next years balances
IGI_BUD_PROFILE_CODES	10	Holds details of profile codes
IGI_BUD_PROFILE_DEFAULTS	9	Holds default profile codes
IGI_BUD_PROFILE_PERIODS	9	Holds profile period details
IGI_BUD_RANGE_CODES	12	Contains details of range codes
IGI_BUD_REASON_CODES	10	Contains details of reason codes
IGI_BUD_SHEET_HEADERS	9	Contains details for spreadsheet journal headers
IGI_BUD_SHEET_LINES	97	Contains details of journal lines created from spreadsheet
IGI_CBR_AP_INTERFACE	9	Contains records of invoices that have been posted to the Accrual Set of Books but not the Cash.
IGI_CBR_AP_INV_RECONCILE	4	Contains remaining unpaid amount for invoices
IGI_CBR_AP_RECONCILE	9	Contains records of unpaid invoices
IGI_CBR_ARC_INTERFACE	38	Contains reconciled records for invoices between cash and accrual set of books
IGI_CBR_GL_INTERFACE	15	Stores information about Journal LInes that have not been copied across from the accrual set of books to the linked cash set of books.
IGI_CBR_GL_RECON_BALANCE	5	Contains beginning balance and period amount of account in Accrual and Cash Set of Books
IGI_CBR_GL_SEGMENT	1	Contains accounting segments
IGI_CBR_GL_TOTAL_INTERFACE	6	Contains reconciled records for Accrual and Cash Set of Books
IGI_CEC_DIST_SUMMARY_ALL	95	Contains details of PO_DISTRIBUTIONS
IGI_CEC_ENCUMBRANCE_TYPES_ALL	4	Holds details of encumbrances
IGI_CIS_CERT_NI_NUMBERS_ALL	9	Stores NI Number for CIS Withholding Tax Certificates
IGI_CIS_CI36_EXTRACT	22	Stores data extracted for the (IGIPCI36) 'End of Year Returns' report
IGI_CIS_CI36_PAYMENTS	25	Stores payments to be processed for the (IGIPCI36) 'End of Year Returns' report
IGI_CIS_PAYMENT_VOUCHERS_ALL	14	Stores CIS Payment Voucher details for Invoice Payments
IGI_COM_COPY_AUDIT	13	Holds audit details
IGI_COM_SOB_LINK	8	Links Sets of Books
IGI_DOSSIER_NUMBERING	16	Stores dossier numbering schemes
IGI_DOS_DESTINATIONS	79	Stores destinations against a dossier
IGI_DOS_DESTINATION_USAGES	14	Records usages of the destinations defined
IGI_DOS_DEST_ALLOC	16	Stores allocations against the destination transaction.
IGI_DOS_DOC_TYPES	39	Stores dossier document types
IGI_DOS_ITEMS	10	Stores dossier items
IGI_DOS_SOURCES	79	Stores sources against a dossier
IGI_DOS_SOURCE_ALLOC	16	Stores allocations against the source transaction
IGI_DOS_SOURCE_USAGES	15	Records usages of the sources defined
IGI_DOS_TRX_DEST	76	Stores destination transactions
IGI_DOS_TRX_DEST_HIST	77	Stores historical destination transactions
IGI_DOS_TRX_HEADERS	48	Stores transaction header information
IGI_DOS_TRX_HEADERS_HIST	49	Stores historical transaction header information
IGI_DOS_TRX_SOURCES	74	Stores source transactions
IGI_DOS_TRX_SOURCES_HIST	75	Stores historical source transactions
IGI_DUN_CHARGE_ALL	34	Temporarily holds the calculated charges for a dunning charge run
IGI_DUN_CUST_LETTER_SET_CUR	7	Allows entry of currency records against a parent dunning letter set
IGI_DUN_CUST_LETTER_SET_LINES	15	Holds values for multiple currencies for each letter in the dunning letter set
IGI_DUN_CUST_PROF	8	Extended table that stores one row for each row in HZ_CUSTOMER_PROFILES
IGI_DUN_CUST_PROF_CLASS	8	Extended table that stores one record for each AR_CUSTOMER_PROFILE_CLASS
IGI_DUN_LETTER_SETS	8	Extended table that stores one record for each record on AR_DUNNING_LETTER_SETS
IGI_DUN_LETTER_SET_CUR	7	Allows entry of currency records against a parent dunning letter set
IGI_DUN_LETTER_SET_LINES	11	Holds values for multiple currencies for each letter in the dunning letter set
IGI_DUN_TEMP	5	Temporary table that stores transaction processing information for overdue invoices requiring dunning charges
IGI_EER_SETUP	12	Holds details of drill down setup
IGI_EXP_APPRV_PROFILES_ALL	12	Holds details of workflow approval profiles created through the Workflow Approval Profile form.
IGI_EXP_AP_TRANS_ALL	25	Stores the payables transactions that are held within a DU
IGI_EXP_AR_TRANS_ALL	25	Stores the receivables transactions that are held within a DU
IGI_EXP_CANCELLATIONS	13	Stores cancelled Exchange Protocol numbers when an accounts officer cancels a dialog unit
IGI_EXP_DIAL_DOC_TEMP	10	Temporary table used during the dialog unit creation process
IGI_EXP_DIAL_UNIT_DEF_ALL	34	Stores all information pertaining to dialog unit setup
IGI_EXP_DOC_TYPE	9	Stores information on the various documents used by exchange protocol
IGI_EXP_DUS_ALL	38	Stores the dialog units
IGI_EXP_DU_TYPE_DETAILS_ALL	9	Stores the detail level information for the DU type definition
IGI_EXP_DU_TYPE_HEADERS_ALL	14	Stores the headers information for the DU type definition
IGI_EXP_JOBS_ACTIONS	12	Stores details of approval privileges for individual job identifers
IGI_EXP_NUMBERING_ALL	20	Stores code combinations and numbering information for exchange protocol numbering
IGI_EXP_NUM_SCHEMES_ALL	14	Stores details of the numbering schemes for exchange protocol numbering
IGI_EXP_POSITION_ACTION	16	Stores details of approval privileges for individual position identifiers
IGI_EXP_POS_ACTIONS_ALL	12	Stores the actions that can be performed by positions used in the approval hierarchy as defined in the form IGIPWFAC
IGI_EXP_POS_STRUCTURES	36	Holds information about position hierarchies defined for each business group
IGI_EXP_TEMP	6	Temporary table used by the exchange protocol find documents
IGI_EXP_TRANSACTIONS	13	Stores history of all completed dialog unit transactions, including numbers
IGI_EXP_TRAN_UNIT_DEF_ALL	24	Stores information about exchange protocol transmission units
IGI_EXP_TRX_TYPE	10	Stores details of the standard applications transaction types used by exchange protocol
IGI_EXP_TUS_ALL	35	Stores the transmission units
IGI_EXP_TU_TYPE_DETAILS_ALL	9	Stores the detail level information for the TU Type definition
IGI_EXP_TU_TYPE_HEADERS_ALL	13	Stores the headers information for the TU type definition
IGI_EXP_WKF_ASSIGN	7	Records which document type is assigned to a workflow
IGI_EXP_WKF_FLOWS_ALL	8	Stores individual flow information, as well as the associated workflow
IGI_EXP_WKF_PROFILE_ALL	11	Holds details of workflow profiles created through the workflow profile form
IGI_EXP_WKF_STEP_ALL	10	Stores individual workflow step setup information created through the workflow profile creation form
IGI_GCC_GL_FA_INST_OPTIONS	10	Stores status of non Multi Organization OPSFI requirements
IGI_GCC_INST_OPTIONS_ALL	11	Stores status of Multi Organization OPSFl requirements
IGI_IAC_ADJUSTMENTS	20	Holds the accounting information. Driver table for creating Journals
IGI_IAC_ASSET_BALANCES	19	Holds periodic asset balance position
IGI_IAC_ASSET_BAL_INTERFACE	29	Interface table for Inflation Accounting
IGI_IAC_BOOK_CONTROLS	12	Holds information of the books, sources and categories used for Inflation Accounting
IGI_IAC_CAL_IDX_VALUES	10	Holds Price Index Values for all periods of the calendar
IGI_IAC_CAL_PRICE_INDEXES	12	Holds Calendar Information for the Price Index
IGI_IAC_CATEGORY_BOOKS	21	Holds Category information as General Fund, Operating Expense, Backlog Accounts and Revaluation types associated to the categoryHolds Catego
IGI_IAC_DET_BALANCES	30	Holds distribution level balance information whcih is made up due to Reval Reserve , Operating Account, Backlog.
IGI_IAC_DISTRIBUTION_ACCOUNTS	11	Holds the accounts for each distribution, for future use only
IGI_IAC_EXCEPTIONS	10	Holds the assets that fall under exception conditions at the time of Revaluation
IGI_IAC_FA_DEPRN	14	Holds Oracle Fixed Assets Year To Date
IGI_IAC_PRICE_INDEXES	8	Holds the Price Index information for Inflation Accounting
IGI_IAC_PROJECTIONS	12	Holds information of the Asset Depreciation Projections
IGI_IAC_PROJ_DETAILS	19	Holds details of Projection Calculations
IGI_IAC_REVALUATIONS	14	Holds information of Revaluations for a book and a period
IGI_IAC_REVALUATION_RATES	15	Holds the rates for each asset selected in a revaluation run, which is fed into revaluation process
IGI_IAC_REVAL_ASSET_RULES	16	Holds the rules for each asset selected in a revaluation run, which is fed into revaluation process
IGI_IAC_REVAL_CATEGORIES	9	Holds the category information in a revaluation run
IGI_IAC_TRANSACTION_HEADERS	20	Holds the details of the transactions performed against all assets
IGI_IAC_XLA_LINES_GT	51
IGI_IMP_IAC_CONTROLS	11	Stores Inflation Accounting data preparation parameters
IGI_IMP_IAC_INTERFACE	49	Stores the asset details used for the implementation reconciliation.
IGI_IMP_IAC_INTERFACE_CTRL	10	Stores information about the status of each category of a book that has been chosen for data preparation.
IGI_IMP_IAC_INTERFACE_PY_ADD	34	Stores asset information for each asset processed by the Inflation Accounting Prior Year Addition program
IGI_IMP_IAC_INTERMEDIATE	40	Stores asset information returned by the Inflation Accounting implementation import process
IGI_INSTALMENT_AUDIT_ALL	11	Records one record for each change made to the payment terms of an invoice
IGI_INST_VERSION	3	This table is used by the upgrade process to store the version of the software prior to the install is used to guide the upgrade process.
IGI_INT_ARCH_REFS	20	Archives generic interface data
IGI_INT_BK_ID_MAP	7	Holds details of Set of Books relationship
IGI_INT_DESCRIPTRS	15	Contains descriptor details
IGI_INT_FILE	8	Holds transfer file information
IGI_INT_FOOTER	4	Holds check total information
IGI_INT_HEADER	12	Holds details of journal header
IGI_INT_LINES	42	Holds line details
IGI_INT_PERIOD_MAP	9	Contains period mapping information
IGI_INVOICE_DISTRIBUTIONS_ALL	17	Invoice distribution line information
IGI_INV_DIST_GT	17
IGI_ITR_ACTION_HISTORY	16	Maintains the Approval Action History for all charge lines
IGI_ITR_CHARGE_AUTH	7	Contains charge authorizer information
IGI_ITR_CHARGE_AUTH_TMP	7	Contains charge authorizer information
IGI_ITR_CHARGE_CENTER	11	Contains user defined charge centers
IGI_ITR_CHARGE_CENTER_TMP	11	Contains user defined charge centers
IGI_ITR_CHARGE_HEADERS	23	Holds charge header details
IGI_ITR_CHARGE_HEADERS_TMP	23	Holds charge header details
IGI_ITR_CHARGE_LINES	43	Holds details of charge lines
IGI_ITR_CHARGE_LINES_AUDIT	36	Holds details of deleted charge lines
IGI_ITR_CHARGE_LINES_AUDIT_TMP	36	Holds details of deleted charge lines
IGI_ITR_CHARGE_LINES_TMP	43	Holds details of charge lines
IGI_ITR_CHARGE_ORIG	46	Holds the Originator information for a charge center
IGI_ITR_CHARGE_RANGES	70	Contains user defined accounting ranges
IGI_ITR_CHARGE_RANGES_TMP	70	Contains user defined accounting ranges
IGI_ITR_CHARGE_SERVICE	12	Holds the Service information for a charge center
IGI_ITR_CHARGE_SETUP	15	Maintains Internal Trading System Options which define usage of the Charges by a User
IGI_ITR_SERVICE	10	Defines Service Types
IGI_MHC_ADDITIONAL_DEPRN	15	Additional depreication expense calculation is stored in this table.
IGI_MHC_BOOK_CONTROLS	9	This table contains names of all the books that have been defined as a Modified Historic Accounting Tax Book.
IGI_MHC_CALENDAR_PERIODS	8	This table holds the Modified Historic Cost Accounting period information.
IGI_MHC_CALENDAR_PRICE_INDEXES	7	This table holds the price index defined for each calendar period.
IGI_MHC_CATEGORY_BOOKS	15	This table holds the Backlog Depreciation , General Fund and Current Year Operating Expense Account details for a Category and Book combina
IGI_MHC_CATEGORY_BOOK_DEFAULTS	13	This table holds the flags that indicate whether revaluation is allowed for the asset category or not.
IGI_MHC_DEPRN_DETAIL	26	This table contains the depreciation amounts detailing the backlog components at the distribution line level. Where Modified Historic Cost
IGI_MHC_DEPRN_SUMMARY	25	This table holds additional depreciation information like the Backlog Depreciation figures for an asset.
IGI_MHC_DISTRIBUTION_ACCOUNTS	9	This table holds generated account and code combination information for the Backlog Depreciation account for a distribution.
IGI_MHC_GEN_INTERFACE	39	This table holds the temporary details of an asset at the distribution level after it has been imported or upgraded into the MHCA system.
IGI_MHC_IDX_REVALUATIONS	54	When you define a mass revaluation request using the Extended MassRevaluation form, the form inserts a row that storesthe default revaluati
IGI_MHC_IDX_REVALUATION_RULES	34	When you define a mass revaluation request using the Extended MassRevaluation form, the form inserts a row that storesthe default revaluati
IGI_MHC_LEDGER	36	This table is an intermediate table. Records are transferred from this table into the GL_INTERFACE and FA_ADJUSTMENT tables after each logic
IGI_MHC_MCPP_RUN	8	Each time the Mass Copy Post Processor is run, a record is created in the IGI_MHC_MCPP_RUN table.The MCPP_RUN_STATUS is updated to 'COMPLETE
IGI_MHC_PROJ_INTERIM	11	Stores depreciation projections
IGI_MHC_RESERVE_LEDGER	21	Temporary storage area for the reserve ledger reports
IGI_MHC_REVALUATION_DETAIL	38	When the Mass Revaluation program is run , either for INDEXED, ADHOC or CATCHUP revaluation, a record is inserted into the IGI_MHC_REVALUATI
IGI_MHC_REVALUATION_SUMMARY	34	When the Extended Mass Revaluation program is run, either in Preview Mode or in the Live Mode, a record is inserted into the IGI_MHC_REVALUA
IGI_MHC_REVAL_DETAIL_EVENTS	9	The Modified Historic Cost Accounting Revaluation Engine is called each time a transaction / event occurs in an assets life like Retirement,
IGI_MHC_REVAL_TN_EXCEPTIONS	9	Temporary Negative Revaluation Assets are stored in this table.
IGI_MHC_TEMP_REVAL_PARAMS	5	MHCA Temporary Revaluation Parameters
IGI_MHC_TRANSACTION_HEADERS	11	This table holds additional information required to check if the Modified Historic Cost Accounting processes have been run on each transac
IGI_MPP_AP_INVOICES	8	Extended multi-period Ppsting table containing information about invoices
IGI_MPP_AP_INVOICE_DISTS	11	Extended multi-period posting table containing information about invoice distributions
IGI_MPP_AP_INVOICE_DISTS_DET	17	Contains multi -period posting distribution spread for each invoice distribution
IGI_MPP_EXPENSE_RULES_ALL	10	Associates rules with expense accounts
IGI_MPP_INVOICE_TRANSFER	9	Temporary table containing selected invoices which are to be transferred to multi -period posting tables.
IGI_MPP_SETUP_ALL	11	Contains setup information for multi -period posting
IGI_MPP_SUBLEDGER	38	Contains accounting entries related to multi -period posting
IGI_PLSQL_CONTROL	4	Error log table for the Standing Charges requirement
IGI_PO_TRAN_TEMP	14	Temporary information about the Purchasing data is stored in here.
IGI_PO_VAT_HIST	9	Temporary information about the Purchasing data is stored in here.
IGI_PO_VENDORS	8	Extended table which contains additional single third party supplier information.
IGI_RA_ADDRESSES_ALL	11	Extended table which contains additional single third party site information .
IGI_RA_CUSTOMERS	8	Extended table which contains additional single third party customer information.
IGI_RA_CUSTOMER_TRX_ALL	11	Table which contains additional receivable transaction information.
IGI_RECOVERABLE_LINES_ALL	18	Table which contains additional recoverable information for cash basis transaction information for the Gross Based VAT functionality.
IGI_REQ_TRAN_TEMP	12	Temporary table storing the requisition information for GBV upgrade.
IGI_REQ_VAT_HIST	9	This is a temporary table used for GBV migration from 10.7/11.03 to 11i.
IGI_RPI_AUDIT_ITEMS_ALL	12	Records charge items price updates, each of which represent a price update to a specific charge item
IGI_RPI_BILL_CHARGE_PERIODS	8	Contains inter-component period relationships
IGI_RPI_COMPONENTS	8	Contains basic categories of periods used in Standing Charges
IGI_RPI_COMPONENT_PERIODS	13	Stores the periods related to the individual components
IGI_RPI_ITEMS_ALL	21	Defines items and services used in standing charges
IGI_RPI_LINE_AUDIT_DET_ALL	20	Records standing charge line price updates, each of which represents a price update to a specific standing charge line charge item
IGI_RPI_LINE_DETAILS_ALL	28	Records standing charge lines, each of which represents a charge for a specific item
IGI_RPI_PERIOD_SCHEDULES	15	Stores period schedule information
IGI_RPI_STANDING_CHARGES_ALL	42	Records Standing Charges from which invoices can be generated
IGI_RPI_UPDATE_HDR_ALL	16	Records global update header information
IGI_RPI_UPDATE_LINES_ALL	18	Records global update line information for charge items and standing charge line charge items
IGI_SAP_APP_RANGES	69	Details of associated flexfield ranges for each secondary invoice approver.
IGI_SAP_DEPARTMENT_APPROVERS	9	List of departmental secondary approvers.
IGI_SAP_GROUP_ALL	8	List of groups, secondary approvers and their associated invoice clerks.
IGI_SAP_INVOICE_CLERK	9	List of invoice clerks assigned to secondary approvers.
IGI_SLS_ALLOCATIONS	13	SLS Table to store the allocations.
IGI_SLS_ALLOCATIONS_AUDIT	13	Audit Table for IGI_SLS_ALLOCATIONS
IGI_SLS_CONSOLIDATE_GROUPS	9	Security Group Merge/Transfer/Replicate history.
IGI_SLS_GROUPS	12	Table to store the groups
IGI_SLS_GROUPS_AUDIT	12	Audit Table for IGI_SLS_GROUPS
IGI_SLS_SECURE_TABLES	16	Table to store the secure tables defined for SLS
IGI_SLS_SECURE_TABLES_AUDIT	15	Audit tables for IGI_SLS_SECURE_TABLES
IGI_SLS_SECURITY_GROUP_ALLOC	2	Table to store only the tables that are secured in the database for each group
IGI_STP_BATCHES_ALL	9	Stores batch information created after third party netting transactions are completed.
IGI_STP_CANDIDATES_ALL	30	Used internally for deriving which transactions, either Payables or Receivables, are available for netting.
IGI_STP_CONTROL	9	Stores the Netting Transaction Batch information submitted
IGI_STP_NET_TRX_TYPES_ALL	9	Holds Single Third Party Netting Transaction Types.
IGI_STP_NET_TYPE_ALLOC_ALL	13	Stores all netting type allocations for a netting transaction type
IGI_STP_PACKAGES_ALL	36	Stores information on Single Third Party netting transactions.
IGI_TEMP_PO_VAT_FACTOR	6	This is a temporary table used for GBV migration from 10.7/11.03 to 11i
IGI_TEMP_REQ_VAT_FACTOR	6	This is a temporary table used for GBV migration from 10.7/11.03 to 11i
IGI_VAT_RECLAIM_RANGES	69	This is a temporary table used for GBV migration from 10.7/11.03 to 11i.