Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - IGC Tables and Views

TABLE - IGC.IGC_ARC_PUR_CANDIDATES

TABLE - IGC.IGC_CBC_ARCHIVE_JE_BATCHES

TABLE - IGC.IGC_CBC_ARCHIVE_JE_LINES

TABLE - IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES

TABLE - IGC.IGC_CBC_ARCHIVE_MC_JE_LINES

TABLE - IGC.IGC_CBC_BA_RANGES

TABLE - IGC.IGC_CBC_INTERFACE_EXCEPTIONS

TABLE - IGC.IGC_CBC_JE_BATCHES

TABLE - IGC.IGC_CBC_JE_LINES

TABLE - IGC.IGC_CBC_MC_JE_BATCHES

TABLE - IGC.IGC_CBC_MC_JE_LINES

TABLE - IGC.IGC_CBC_OPEN_INTERFACE

TABLE - IGC.IGC_CBC_SUMMARY_TEMPLATES

TABLE - IGC.IGC_CC_ACCESS

TABLE - IGC.IGC_CC_ACCT_LINES

TABLE - IGC.IGC_CC_ACCT_LINES_INTERFACE

TABLE - IGC.IGC_CC_ACCT_LINE_HISTORY

TABLE - IGC.IGC_CC_ACTIONS

TABLE - IGC.IGC_CC_ARC_ACCT_LINES

TABLE - IGC.IGC_CC_ARC_ACCT_LINE_HIST

TABLE - IGC.IGC_CC_ARC_ACTIONS

TABLE - IGC.IGC_CC_ARC_DET_PF

TABLE - IGC.IGC_CC_ARC_DET_PF_HIST

TABLE - IGC.IGC_CC_ARC_MC_ACCT_LINES

TABLE - IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST

TABLE - IGC.IGC_CC_ARC_MC_DET_PF

TABLE - IGC.IGC_CC_ARC_MC_DET_PF_HIST

TABLE - IGC.IGC_CC_ARC_MC_HEADERS

TABLE - IGC.IGC_CC_ARC_MC_HEADER_HIST

TABLE - IGC.IGC_CC_ARC_PO_DISTRIBUTION_ALL

TABLE - IGC.IGC_CC_ARC_PO_HEADERS_ALL

TABLE - IGC.IGC_CC_ARC_PO_LINES_ALL

TABLE - IGC.IGC_CC_ARC_PO_LINE_LOC_ALL

TABLE - IGC.IGC_CC_BC_ENABLE

TABLE - IGC.IGC_CC_DET_PF

TABLE - IGC.IGC_CC_DET_PF_HISTORY

TABLE - IGC.IGC_CC_DET_PF_INTERFACE

TABLE - IGC.IGC_CC_ENCMBRNC_CTRLS

TABLE - IGC.IGC_CC_GROUPS

TABLE - IGC.IGC_CC_GROUP_USERS

TABLE - IGC.IGC_CC_INTERFACE

TABLE - IGC.IGC_CC_MC_ACCT_LINES

TABLE - IGC.IGC_CC_MC_ACCT_LINE_HISTORY

TABLE - IGC.IGC_CC_MC_DET_PF

TABLE - IGC.IGC_CC_MC_DET_PF_HISTORY

TABLE - IGC.IGC_CC_MC_HEADERS

TABLE - IGC.IGC_CC_MC_HEADER_HISTORY

TABLE - IGC.IGC_CC_NUMBER_METHODS

TABLE - IGC.IGC_CC_SYSTEM_PARAMETERS

VIEW - APPS.IGCBV_CBC_BALANCES

VIEW - APPS.IGCBV_CBC_BUDGET_BALANCES

VIEW - APPS.IGCBV_CBC_ENCUMBRANCE_BALANCES

VIEW - APPS.IGCBV_CBC_JOURNAL_BATCHES

VIEW - APPS.IGCBV_CBC_JOURNAL_LINES

VIEW - APPS.IGCBV_CBC_MC_JOURNAL_BATCHES

VIEW - APPS.IGCBV_CBC_MC_JOURNAL_LINES

VIEW - APPS.IGCBV_CC_ACCOUNT_LINES

VIEW - APPS.IGCBV_CC_ACTION_HISTORIES

VIEW - APPS.IGCBV_CC_CONTRACT_COMMITMENTS

VIEW - APPS.IGCBV_CC_DETAIL_PAY_FORECASTS

VIEW - APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS

VIEW - APPS.IGCBV_CC_NUMBER_METHODS

VIEW - APPS.IGCBV_CC_PERIODS

VIEW - APPS.IGCBV_CC_RELEASES

VIEW - APPS.IGCBV_CC_RELEASE_ACCOUNT_LINES

VIEW - APPS.IGCBV_CC_REL_DET_PAY_FORECASTS

VIEW - APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS

VIEW - APPS.IGCBV_CC_ROUTING_CONTROLS

VIEW - APPS.IGCBV_CC_SUMMARY_PAY_FORECASTS

VIEW - APPS.IGCBV_MC_ACCOUNT_LINES

VIEW - APPS.IGCBV_MC_CONTRACT_COMMITMENTS

VIEW - APPS.IGCBV_MC_DETAIL_PAY_FORECASTS

VIEW - APPS.IGCBV_MC_RELEASES

VIEW - APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES

VIEW - APPS.IGCBV_MC_REL_DET_PAY_FORECASTS

VIEW - APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS

VIEW - APPS.IGCBV_MC_SUMMARY_PAY_FORECASTS

VIEW - APPS.IGCFV_CBC_BALANCES

VIEW - APPS.IGCFV_CBC_BUDGET_BALANCES

VIEW - APPS.IGCFV_CBC_ENCUMBRANCE_BALANCES

VIEW - APPS.IGCFV_CBC_JOURNAL_BATCHES

VIEW - APPS.IGCFV_CBC_JOURNAL_LINES

VIEW - APPS.IGCFV_CBC_MC_JOURNAL_BATCHES

VIEW - APPS.IGCFV_CBC_MC_JOURNAL_LINES

VIEW - APPS.IGCFV_CC_ACCOUNT_LINES

VIEW - APPS.IGCFV_CC_ACTION_HISTORIES

VIEW - APPS.IGCFV_CC_CONTRACT_COMMITMENTS

VIEW - APPS.IGCFV_CC_DETAIL_PAY_FORECASTS

VIEW - APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS

VIEW - APPS.IGCFV_CC_NUMBER_METHODS

VIEW - APPS.IGCFV_CC_PERIODS

VIEW - APPS.IGCFV_CC_RELEASES

VIEW - APPS.IGCFV_CC_RELEASE_ACCOUNT_LINES

VIEW - APPS.IGCFV_CC_REL_DET_PAY_FORECASTS

VIEW - APPS.IGCFV_CC_REL_SUM_PAY_FORECASTS

VIEW - APPS.IGCFV_CC_ROUTING_CONTROLS

VIEW - APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS

VIEW - APPS.IGCFV_MC_ACCOUNT_LINES

VIEW - APPS.IGCFV_MC_CONTRACT_COMMITMENTS

VIEW - APPS.IGCFV_MC_DETAIL_PAY_FORECASTS

VIEW - APPS.IGCFV_MC_RELEASES

VIEW - APPS.IGCFV_MC_RELEASE_ACCOUNT_LINES

VIEW - APPS.IGCFV_MC_REL_DET_PAY_FORECASTS

VIEW - APPS.IGCFV_MC_REL_SUM_PAY_FORECASTS

VIEW - APPS.IGCFV_MC_SUMMARY_PAY_FORECASTS

VIEW - APPS.IGC_CBC_ALL_BAL_V

VIEW - APPS.IGC_CBC_AUDIT_TRAILS_V

VIEW - APPS.IGC_CBC_BALANCES_V

VIEW - APPS.IGC_CBC_BAL_V

VIEW - APPS.IGC_CBC_BA_RANGES_FCL_V

VIEW - APPS.IGC_CBC_BA_RANGES_V

VIEW - APPS.IGC_CBC_DETAIL_BAL_V

VIEW - APPS.IGC_CBC_DET_BALANCES_V

VIEW - APPS.IGC_CBC_DR_V

VIEW - APPS.IGC_CBC_JE_BATCHES_V

VIEW - APPS.IGC_CBC_JE_LINES_BAL_ALL_V

VIEW - APPS.IGC_CBC_JE_LINES_BAL_PTD_V

VIEW - APPS.IGC_CBC_JE_LINES_V

VIEW - APPS.IGC_CBC_SUMMARY_BAL_V

VIEW - APPS.IGC_CBC_SUMMARY_COMBINATIONS_V

VIEW - APPS.IGC_CBC_SUMMARY_TEMPLATES_V

VIEW - APPS.IGC_CBC_SUMMARY_TEMPLATE_FCL_V

VIEW - APPS.IGC_CC_ACCESS_V

VIEW - APPS.IGC_CC_ACCT_LINES_V

VIEW - APPS.IGC_CC_ACCT_LINE_VERSION_V

VIEW - APPS.IGC_CC_ACTIONS_V

VIEW - APPS.IGC_CC_BC_ENABLE_V

VIEW - APPS.IGC_CC_CLOSED_CANC_HDRS_V

VIEW - APPS.IGC_CC_CONTROL_FUNCTIONS_V

VIEW - APPS.IGC_CC_DET_PF_V

VIEW - APPS.IGC_CC_DET_PF_VERSION_V

VIEW - APPS.IGC_CC_ENCMBRNC_CTRLS_V

VIEW - APPS.IGC_CC_ENCMBRNC_ORG_V

VIEW - APPS.IGC_CC_GROUPS_V

VIEW - APPS.IGC_CC_GROUP_USERS_V

VIEW - APPS.IGC_CC_HDRS_MAX_DATES_V

VIEW - APPS.IGC_CC_HEADERS_V

VIEW - APPS.IGC_CC_HEADER_VERSION_V

VIEW - APPS.IGC_CC_INTERFACE_BATCHES_V

VIEW - APPS.IGC_CC_INTERFACE_V

VIEW - APPS.IGC_CC_NUMBER_METHODS_V

VIEW - APPS.IGC_CC_PERIODS_V

VIEW - APPS.IGC_CC_ROUTING_CTRLS_V

VIEW - APPS.IGC_CC_SMRY_PF_V

VIEW - APPS.IGC_CC_SMRY_PF_VERSION_V

VIEW - APPS.IGC_CC_SYSTEM_PARAMETERS_V

Table: IGC_ARC_PUR_CANDIDATES

Comments

IGC_ARC_PUR_CANDIDATES temporarily stores contract commitment information for rows about to be archived or purged from the system.

Indexes

Columns

[top of page]

IGC.IGC_ARC_PUR_CANDIDATES does not reference any database object

IGC.IGC_ARC_PUR_CANDIDATES is referenced by following:

IGC

VIEW - IGC_ARC_PUR_CANDIDATES#

[top of page]

Table: IGC_CBC_ARCHIVE_JE_BATCHES

Comments

IGC_CBC_ARCHIVE_JE_BATCHES temporarily stores journal entry batches that have been archived to tape or disk. These entries can also be purged from the system at later date.

Indexes

Columns

[top of page]

IGC.IGC_CBC_ARCHIVE_JE_BATCHES does not reference any database object

IGC.IGC_CBC_ARCHIVE_JE_BATCHES is referenced by following:

IGC

VIEW - IGC_CBC_ARCHIVE_JE_BATCHES#

[top of page]

Table: IGC_CBC_ARCHIVE_JE_LINES

Comments

IGC_CBC_ARCHIVE_JE_LINES temporarily stores journal entry lines that have been archived from the table.

Indexes

Columns

[top of page]

IGC.IGC_CBC_ARCHIVE_JE_LINES does not reference any database object

IGC.IGC_CBC_ARCHIVE_JE_LINES is referenced by following:

IGC

VIEW - IGC_CBC_ARCHIVE_JE_LINES#

[top of page]

Table: IGC_CBC_ARCHIVE_MC_JE_BATCHES

Comments

IGC_CBC_ARCHIVE_MC_JE_BATCHES temporarily stores the multiple reporting currency values for journal entry batches that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES does not reference any database object

IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES is referenced by following:

IGC

VIEW - IGC_CBC_ARCHIVE_MC_JE_BATCHES#

[top of page]

Table: IGC_CBC_ARCHIVE_MC_JE_LINES

Comments

IGC_CBC_ARCHIVE_MC_JE_LINES temporarily stores the multiple reporting currency values for journal entry lines that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CBC_ARCHIVE_MC_JE_LINES does not reference any database object

IGC.IGC_CBC_ARCHIVE_MC_JE_LINES is referenced by following:

IGC

VIEW - IGC_CBC_ARCHIVE_MC_JE_LINES#

[top of page]

Table: IGC_CBC_BA_RANGES

Primary Key: ICBR_PK

1. CBC_RANGE_ID

Foreign Keys from this table:

Comments

IGC_CBC_BA_RANGES stores the fund check level codes that are specific to Contract Commitment at the budget assignment ranges level. For each row in the GL_BUDGET_ASSIGNMENT_RANGES table, there may be one and only one row in this table. The fund check level in Contract Commitment may differ from the fund check level in General Ledger; therefore, the one to one relationship is required.

Indexes

Columns

[top of page]

IGC.IGC_CBC_BA_RANGES does not reference any database object

IGC.IGC_CBC_BA_RANGES is referenced by following:

IGC

VIEW - IGC_CBC_BA_RANGES#

[top of page]

Table: IGC_CBC_INTERFACE_EXCEPTIONS

Comments

IGC_CBC_INTERFACE_EXCEPTIONS stores temporary data pertaining to errors that were generated during the commitment budgetary control module's open interface data load validation. Prior to the start of the open interface data load validation, the data from the previous load is deleted from the table.

Indexes

Columns

[top of page]

IGC.IGC_CBC_INTERFACE_EXCEPTIONS does not reference any database object

IGC.IGC_CBC_INTERFACE_EXCEPTIONS is referenced by following:

IGC

VIEW - IGC_CBC_INTERFACE_EXCEPTIONS#

[top of page]

Table: IGC_CBC_JE_BATCHES

Primary Key: IGC_CBC_JE_BATCHES_PK

1. CBC_JE_BATCH_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CBC_JE_BATCHES stores journal entry batches for the Commitment Budgetary Control submodule. For each request for funds reservation that is initiated in Contract Commitment, a row is inserted into this table. Each row includes the batch identifier, batch name, description, status, running total debits and credits, and other information.

Indexes

Columns

[top of page]

IGC.IGC_CBC_JE_BATCHES does not reference any database object

IGC.IGC_CBC_JE_BATCHES is referenced by following:

IGC

VIEW - IGC_CBC_JE_BATCHES#

[top of page]

Table: IGC_CBC_JE_LINES

Primary Key: IGC_CBCJEL_PK

1. CBC_JE_BATCH_ID
2. CBC_JE_LINE_NUM

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CBC_JE_LINES stores information about each journal entry line.
There is an optional one to many relationship between IGC_CBC_JE_BATCHES and this table. For each journal entry batch, there can be several journal entry lines in the IGC_CBC_JE_LINES table with the same CBC_JE_BATCH_ID, but different values for the CBC_JE_LINE_NUM.

Indexes

Columns

[top of page]

IGC.IGC_CBC_JE_LINES does not reference any database object

IGC.IGC_CBC_JE_LINES is referenced by following:

IGC

VIEW - IGC_CBC_JE_LINES#

[top of page]

Table: IGC_CBC_MC_JE_BATCHES

Primary Key: IGCMJB_PK

1. CBC_JE_BATCH_ID
2. REPORTING_SET_OF_BOOKS_ID

Foreign Keys from this table:

Comments

IGC_CBC_MC_JE_BATCHES stores reporting currency information for each commitment budgetary control journal entry batch. There is an optional one to many relationship between IGC_CBC_JE_BATCHES and this table. For each journal entry batch, there can be several batches in the IGC_CBC_MC_JE_BATCHES table with the same CBC_JE_BATCH_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of batches stored in the IGC_CBC_MC_JE_BATCHES table corresponds with the number of Reporting Sets of Books that have been defined.

Indexes

Columns

[top of page]

IGC.IGC_CBC_MC_JE_BATCHES does not reference any database object

IGC.IGC_CBC_MC_JE_BATCHES is referenced by following:

IGC

VIEW - IGC_CBC_MC_JE_BATCHES#

[top of page]

Table: IGC_CBC_MC_JE_LINES

Primary Key: IGC_CBC_MC_JE_LINES_PK

1. CBC_JE_BATCH_ID
2. CBC_JE_LINE_NUM
3. REPORTING_SET_OF_BOOKS_ID

Foreign Keys from this table:

Comments

IGC_CBC_MC_JE_LINES stores reporting currency information for each Commitment Budgetary Control journal entry line in Contract Commitment. There is an optional one to many relationship between IGC_CBC_JE_LINES and this table. For each journal entry line, there can be several lines in the IGC_CBC_MC_JE_LINES table with the same CBC_JE_BATCH_ID and CBC_JE_LINE_NUM, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CBC_MC_JE_BATCHES table will correspond with the number of Reporting Sets of Books that have been defined.

Indexes

Columns

[top of page]

IGC.IGC_CBC_MC_JE_LINES does not reference any database object

IGC.IGC_CBC_MC_JE_LINES is referenced by following:

IGC

VIEW - IGC_CBC_MC_JE_LINES#

[top of page]

Table: IGC_CBC_OPEN_INTERFACE

Comments

IGC_CBC_OPEN_INTERFACE stores temporary data during the commitment budgetary control module's open interface loading process. The data is stored in this table so that it can be validated prior to insertion into the IGC_CBC_JE_LINES table. Prior to the start of the open interface load, the data from the previous load is deleted from the table.
Scope: public
Product: IGI
Lifecycle: active
Display Name: Commitment Budgetary Control Interface
Category: BUSINESS_ENTITY IGC_ENCUMBERANCE_JOURNAL

Indexes

Columns

[top of page]

IGC.IGC_CBC_OPEN_INTERFACE does not reference any database object

IGC.IGC_CBC_OPEN_INTERFACE is referenced by following:

IGC

VIEW - IGC_CBC_OPEN_INTERFACE#

[top of page]

Table: IGC_CBC_SUMMARY_TEMPLATES

Primary Key: ICST_PK

1. TEMPLATE_ID

Foreign Keys from this table:

Comments

IGC_CBC_SUMMARY_TEMPLATES stores the fund check level codes that are specific to Contract Commitment at the summary template level. For each row in the GL_SUMMARY_TEMPLATES table, there may be one and only one row in this table. The fund check level in Contract Commitment may differ from the fund check level in General Ledger; therefore, a one to one relationship is required.

Indexes

Columns

[top of page]

IGC.IGC_CBC_SUMMARY_TEMPLATES does not reference any database object

IGC.IGC_CBC_SUMMARY_TEMPLATES is referenced by following:

IGC

VIEW - IGC_CBC_SUMMARY_TEMPLATES#

[top of page]

Table: IGC_CC_ACCESS

Primary Key: IGC_CC_ACCESS_PK

1. CC_ACCESS_ID

Foreign Keys from this table:

Comments

IGC_CC_ACCESS stores information required to assign update privileges on individual contracts to groups of users. This table represents an association between IGC_CC_GROUP_USERS and IGC_CC_HEADERS. For each contract, more than one group user may have access. Each group user may have access to more than one contract.

Indexes

Columns

[top of page]

IGC.IGC_CC_ACCESS does not reference any database object

IGC.IGC_CC_ACCESS is referenced by following:

IGC

VIEW - IGC_CC_ACCESS#

[top of page]

Table: IGC_CC_ACCT_LINES

Primary Key: IGCCAL_PK

1. CC_ACCT_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CC_ACCT_LINES stores current information pertaining to each account line of the contract commitment. For each contract in the IGC_CC_HEADERS table, there can be one or more account lines in the IGC_CC_ACCT_LINES table. Each row includes the corresponding CC_HEADER_ID for this contract, the line number, and information specific to the General Ledger account and the project expenditures for the account line. If commitment budgetary control is enabled and if this is a parent contract, the amount for this account line, in the functional currency, is encumbered against the commitment budget. The CC_ACCT_ENCMBRNC_AMT reflects the total amount that has been encumbered to date for the given account line. If the account line is for a release contract commitment, the account line will be related to a parent account line. The PARENT_HEADER_ID and PARENT_ACCT_LINE_ID form the relationship between the parent contract commitment and the release contract commitment for any given account line.

Indexes

Columns

[top of page]

IGC.IGC_CC_ACCT_LINES does not reference any database object

IGC.IGC_CC_ACCT_LINES is referenced by following:

IGC

VIEW - IGC_CC_ACCT_LINES#

[top of page]

Table: IGC_CC_ACCT_LINES_INTERFACE

Primary Key: ICALI_PK

1. INTERFACE_ACCT_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CC_ACCT_LINES_INTERFACE temporarily stores account line information during the contract commitment's open interface data load. If the data passes all of the validations, then it is inserted into the IGC_CC_ACCT_LINES table.
Scope: public
Product: IGI
Lifecycle: active
Display Name: Contract Commitment Journal Line
Category: BUSINESS_ENTITY IGC_CONTRACT_COMMITMENT

Indexes

Columns

[top of page]

IGC.IGC_CC_ACCT_LINES_INTERFACE does not reference any database object

IGC.IGC_CC_ACCT_LINES_INTERFACE is referenced by following:

IGC

VIEW - IGC_CC_ACCT_LINES_INTERFACE#

[top of page]

Table: IGC_CC_ACCT_LINE_HISTORY

Primary Key: IGC_CCALH_PK

1. CC_ACCT_LINE_ID
2. CC_ACCT_VERSION_NUM

Foreign Keys from this table:

Comments

IGC_CC_ACCT_LINE_HISTORY stores information specific to a given version of an account line of the contract. A new version of an account line is created any time there is a significant change to the account line, such as the amount or the project information for the account line. When this information changes, the entire row of the previous version of the IGC_CC_ACCT_LINE row is inserted into IGC_CC_ACCT_LINE_HISTORY and the version number of the contract in the IGC_CC_HEADERS table will increase. The insertion of this row occurs systematically.

Indexes

Columns

[top of page]

IGC.IGC_CC_ACCT_LINE_HISTORY does not reference any database object

IGC.IGC_CC_ACCT_LINE_HISTORY is referenced by following:

IGC

VIEW - IGC_CC_ACCT_LINE_HISTORY#

[top of page]

Table: IGC_CC_ACTIONS

Primary Key: IGC_CCA_PK

1. CC_HEADER_ID
2. CC_ACTION_NUM

Foreign Keys from this table:

Comments

IGC_CC_ACTIONS stores information specific to significant actions that have taken place against the given contract. For each row in the IGC_CC_HEADERS table, there may be one or more rows in the IGC_CC_ACTIONS table. The number of actions inserted into this table depends on the number of actions performed against the contract. When certain actions take place, such as the initiation, transition, or approval, a row is inserted into this table. This information is inserted automatically by the system.

Indexes

Columns

[top of page]

IGC.IGC_CC_ACTIONS does not reference any database object

IGC.IGC_CC_ACTIONS is referenced by following:

IGC

VIEW - IGC_CC_ACTIONS#

[top of page]

Table: IGC_CC_ARC_ACCT_LINES

Primary Key: ICAAL_PK

1. CC_ACCT_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CC_ARC_ACCT_LINES temporarily stores account lines tthat have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_ACCT_LINES does not reference any database object

IGC.IGC_CC_ARC_ACCT_LINES is referenced by following:

IGC

VIEW - IGC_CC_ARC_ACCT_LINES#

[top of page]

Table: IGC_CC_ARC_ACCT_LINE_HIST

Primary Key: ICAALH_PK

1. CC_ACCT_LINE_ID
2. CC_ACCT_VERSION_NUM

Foreign Keys from this table:

Comments

IGC_CC_ARC_ACCT_LINE_HIST temporarily stores account line versions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_ACCT_LINE_HIST does not reference any database object

IGC.IGC_CC_ARC_ACCT_LINE_HIST is referenced by following:

IGC

VIEW - IGC_CC_ARC_ACCT_LINE_HIST#

[top of page]

Table: IGC_CC_ARC_ACTIONS

Primary Key: ICAA_PK

1. CC_HEADER_ID
2. CC_ACTION_NUM

Foreign Keys from this table:

Comments

IGC_CC_ARC_ACTIONS temporarily stores contract actions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_ACTIONS does not reference any database object

IGC.IGC_CC_ARC_ACTIONS is referenced by following:

IGC

VIEW - IGC_CC_ARC_ACTIONS#

[top of page]

Table: IGC_CC_ARC_DET_PF

Primary Key: ICADP_PK

1. CC_DET_PF_LINE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

IGC_CC_ARC_DET_PF temporarily stores detail payment forecast lines that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_DET_PF does not reference any database object

IGC.IGC_CC_ARC_DET_PF is referenced by following:

IGC

VIEW - IGC_CC_ARC_DET_PF#

[top of page]

Table: IGC_CC_ARC_DET_PF_HIST

Primary Key: ICADPH_PK

1. CC_DET_PF_LINE_ID
2. CC_DET_PF_VERSION_NUM

Foreign Keys from this table:

Comments

IGC_CC_ARC_DET_PF_HIST temporarily stores detail payment forecast line versions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_DET_PF_HIST does not reference any database object

IGC.IGC_CC_ARC_DET_PF_HIST is referenced by following:

IGC

VIEW - IGC_CC_ARC_DET_PF_HIST#

[top of page]

Table: IGC_CC_ARC_MC_ACCT_LINES

Primary Key: ICAMAL_PK

1. CC_ACCT_LINE_ID
2. SET_OF_BOOKS_ID

Comments

IGC_CC_ARC_MC_ACCT_LINES temporarily stores multiple reporting currency information on account lines that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_ACCT_LINES does not reference any database object

IGC.IGC_CC_ARC_MC_ACCT_LINES is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_ACCT_LINES#

[top of page]

Table: IGC_CC_ARC_MC_ACCT_LINE_HIST

Primary Key: ICAMCALH_PK

1. CC_ACCT_VERSION_NUM
2. CC_ACCT_LINE_ID
3. SET_OF_BOOKS_ID

Comments

IGC_CC_ARC_MC_ACCT_LINE_HIST temporarily stores multiple reporting currency information on account line versions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST does not reference any database object

IGC.IGC_CC_ARC_MC_ACCT_LINE_HIST is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_ACCT_LINE_HIST#

[top of page]

Table: IGC_CC_ARC_MC_DET_PF

Primary Key: ICAMDP_PK

1. CC_DET_PF_LINE_ID
2. SET_OF_BOOKS_ID

Comments

IGC_CC_ARC_MC_DET_PF temporarily stores multiple reporting currency information on detail payment forecast lines that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_DET_PF does not reference any database object

IGC.IGC_CC_ARC_MC_DET_PF is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_DET_PF#

[top of page]

Table: IGC_CC_ARC_MC_DET_PF_HIST

Primary Key: ICAMDPH_PK

1. CC_DET_PF_LINE_ID
2. CC_DET_PF_VERSION_NUM
3. SET_OF_BOOKS_ID

Comments

IGC_CC_ARC_MC_DET_PF_HIST temporarily stores multiple reporting currency information on detail payment forecast line versions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_DET_PF_HIST does not reference any database object

IGC.IGC_CC_ARC_MC_DET_PF_HIST is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_DET_PF_HIST#

[top of page]

Table: IGC_CC_ARC_MC_HEADERS

Primary Key: ICAMH_PK

1. CC_HEADER_ID
2. SET_OF_BOOKS_ID

Comments

IGC_CC_ARC_MC_HEADERS temporarily stores multiple reporting currency information on contracts that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_HEADERS does not reference any database object

IGC.IGC_CC_ARC_MC_HEADERS is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_HEADERS#

[top of page]

Table: IGC_CC_ARC_MC_HEADER_HIST

Primary Key: ICAMHH_PK

1. CC_HEADER_ID
2. SET_OF_BOOKS_ID
3. CC_VERSION_NUM

Comments

IGC_CC_ARC_MC_HEADER_HIST temporarily stores multiple reporting currency information on contract versions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_MC_HEADER_HIST does not reference any database object

IGC.IGC_CC_ARC_MC_HEADER_HIST is referenced by following:

IGC

VIEW - IGC_CC_ARC_MC_HEADER_HIST#

[top of page]

Table: IGC_CC_ARC_PO_DISTRIBUTION_ALL

Primary Key: ICAPDA_PK

1. PO_DISTRIBUTION_ID

Comments

IGC_CC_ARC_PO_DISTRIBUTION_ALL temporarily stores purchase order distributions that have been archived.

Indexes

Columns

[top of page]

IGC.IGC_CC_ARC_PO_DISTRIBUTION_ALL does not reference any database object

IGC.IGC_CC_ARC_PO_DISTRIBUTION_ALL is referenced by following:

IGC

VIEW - IGC_CC_ARC_PO_DISTRIBUTION_AL#

[top of page]

Table: IGC_CC_ARC_PO_HEADERS_ALL

Primary Key: ICAPHA_PK

1. PO_HEADER_ID

Comments

IGC_CC_ARC_PO_HEADERS_ALL temporarily stores purchase order header information that has been archived.

Indexes

Columns