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.
Description: | Candidate rows to be archived |
---|
IGC_ARC_PUR_CANDIDATES temporarily stores contract commitment information for rows about to be archived or purged from the system.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_ARC_PUR_CANDIDATES_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CC_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Contract commitment defining column | ||
CC_NUM | VARCHAR2 | (20) | Contract commitment number | |
CC_ACCT_LINE_ID | NUMBER | Account line defining column | ||
CC_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column | ||
LAST_ACTIVITY_DATE | DATE | Date activity last occurred on this contract |
IGC.IGC_ARC_PUR_CANDIDATES does not reference any database object
IGC.IGC_ARC_PUR_CANDIDATES is referenced by following:
Description: | Journal entry batches to be archived |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_ARCHIVE_JE_BATCHES_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CBC_JE_BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
CC_HEADER_ID | NUMBER | Contract commitment defining column | ||
NAME | VARCHAR2 | (100) | Y | Name of journal entry batch |
BATCH_STATUS | VARCHAR2 | (1) | Journal entry batch status | |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | Balance type. Values are Actual, Budget, or Encumbrance. |
BUDGETARY_CONTROL_STATUS | VARCHAR2 | (1) | Y | Journal entry batch funds check status |
APPROVAL_STATUS_CODE | VARCHAR2 | (1) | Y | Journal entry batch approval status |
DESCRIPTION | VARCHAR2 | (240) | Journal entry batch description | |
EFFECTIVE_DATE | DATE | Y | Transaction effective date | |
RUNNING_TOTAL_DR | NUMBER | Batch running total debit, entered currency | ||
RUNNING_TOTAL_CR | NUMBER | Batch running total credit, entered currency | ||
CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield context column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CBC_ARCHIVE_JE_BATCHES does not reference any database object
IGC.IGC_CBC_ARCHIVE_JE_BATCHES is referenced by following:
Description: | Journal entry lines to be archived |
---|
IGC_CBC_ARCHIVE_JE_LINES temporarily stores journal entry lines that have been archived from the table.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_ARCHIVE_JE_LINES_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
CBC_JE_BATCH_ID
CBC_JE_LINE_NUM |
IGC_CBC_ARCHIVE_JE_LINES_N2 | NONUNIQUE | APPS_TS_ARCHIVE |
SET_OF_BOOKS_ID
PERIOD_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
JE_SOURCE | VARCHAR2 | (25) | Y | Journal entry source |
JE_CATEGORY | VARCHAR2 | (25) | Y | Journal entry category |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | Balance type. Values are Actual, Budget, or Encumbrance. |
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type defining column | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | Key Flexfield structure balancing segment value | |
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | Y | Detail account, summary account flag. Values are D or S. |
CODE_COMBINATION_ID | NUMBER | (15) | Y | Key Flexfield combination defining column |
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | Funds checking severity level | |
AMOUNT_TYPE | VARCHAR2 | (4) | Amount type such as period to date or year to date | |
EFFECTIVE_DATE | DATE | Y | Date journal entry is effective | |
POSTED_DATE | DATE | Date journal entry was posted | ||
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
DR_CR_CODE | VARCHAR2 | (1) | Debit or credit | |
ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
DESCRIPTION | VARCHAR2 | (240) | Journal entry line description | |
BUDGET_TYPE | VARCHAR2 | (15) | Budget type, always commitment | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
PERIOD_NAME | VARCHAR2 | (15) | System-generated accounting period name | |
QUARTER_NUM | NUMBER | (15) | Quarter number of accounting period | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
STATUS | VARCHAR2 | (1) | Y | Status of line entry. Values are T or P. |
CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield context column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
REFERENCE_1 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_2 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_3 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_4 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_5 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_7 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_8 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_9 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_10 | VARCHAR2 | (240) | Journal entry line reference column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
SUB_HEADER_ID | NUMBER | Contains header id of originating document |
IGC.IGC_CBC_ARCHIVE_JE_LINES does not reference any database object
IGC.IGC_CBC_ARCHIVE_JE_LINES is referenced by following:
Description: | Multiple reporting currency table for commitment budgetary control journal entry batches to be archived |
---|
IGC_CBC_ARCHIVE_MC_JE_BATCHES temporarily stores the multiple reporting currency values for journal entry batches that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_ARCHIVE_MC_JE_BAT_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
CBC_JE_BATCH_ID
REPORTING_SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
REPORTING_SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
REPORTING_CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code for reporting Set of Books |
RUNNING_TOTAL_DR | NUMBER | Batch running total debit, entered currency | ||
RUNNING_TOTAL_CR | NUMBER | Batch running total credit, entered currency | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CONVERSION_DATE | DATE | Currency conversion date | ||
CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES does not reference any database object
IGC.IGC_CBC_ARCHIVE_MC_JE_BATCHES is referenced by following:
Description: | Multiple reporting currency table for commitment budgetary control journal entry lines to be archived |
---|
IGC_CBC_ARCHIVE_MC_JE_LINES temporarily stores the multiple reporting currency values for journal entry lines that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_ARCHIVE_MC_JE_LINES_N1 | NONUNIQUE | APPS_TS_ARCHIVE |
CBC_JE_BATCH_ID
CBC_JE_LINE_NUM REPORTING_SET_OF_BOOKS_ID |
IGC_CBC_ARCHIVE_MC_JE_LINES_N2 | NONUNIQUE | APPS_TS_ARCHIVE | CBC_JE_BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
REPORTING_SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
REPORTING_CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code for reporting Set of Books |
ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
CONVERSION_DATE | DATE | Currency conversion date | ||
CONVERSION_RATE | NUMBER | Currency conversion rate | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CBC_ARCHIVE_MC_JE_LINES does not reference any database object
IGC.IGC_CBC_ARCHIVE_MC_JE_LINES is referenced by following:
Description: | Funds check level information specific to contract commitments |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_BA_RANGES.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_BA_RANGES_U1 | UNIQUE | APPS_TS_TX_IDX | CBC_RANGE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_RANGE_ID | NUMBER | (15) | Y | Account range assignment defining column |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
SBC_FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | Y | Funds checking severity level of standard budget |
CBC_OVERRIDE | VARCHAR2 | (1) | Y | The funds check severity level of standard budget override at commitment budget level |
BUDGET_ENTITY_ID | NUMBER | (15) | Y | Budget organization defining column |
STATUS | VARCHAR2 | (1) | Y | Current status of assignment range |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
IGC.IGC_CBC_BA_RANGES does not reference any database object
IGC.IGC_CBC_BA_RANGES is referenced by following:
Description: | Errors generated during the commitment budgetary control module's open interface loading process |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_INTERFACE_EXCEPS_N1 | NONUNIQUE | APPS_TS_INTERFACE |
PERIOD_NAME
SET_OF_BOOKS_ID |
IGC_CBC_INTERFACE_EXCEPS_N2 | NONUNIQUE | APPS_TS_INTERFACE |
CBC_JE_LINE_NUM
SET_OF_BOOKS_ID |
IGC_CBC_INTERFACE_EXCEPS_N3 | NONUNIQUE | APPS_TS_INTERFACE | SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Journal entry batch defining column | |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
RESULT_CODE | VARCHAR2 | (3) | Error code of data validation | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
PERIOD_NAME | VARCHAR2 | (15) | System-generated accounting period name | |
QUARTER_NUM | NUMBER | (15) | Quarter number of accounting period | |
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
SET_OF_BOOKS_ID | NUMBER | (15) | Accounting books defining column |
IGC.IGC_CBC_INTERFACE_EXCEPTIONS does not reference any database object
IGC.IGC_CBC_INTERFACE_EXCEPTIONS is referenced by following:
Description: | Commitment budgetary control batches |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_JE_BATCHES.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_MC_JE_BATCHES.CBC_JE_BATCH_ID | IGC_CBC_JE_BATCHES |
IGC_CBC_JE_LINES.CBC_JE_BATCH_ID | IGC_CBC_JE_BATCHES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_JE_BATCHES_U1 | UNIQUE | APPS_TS_TX_IDX | CBC_JE_BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
CC_HEADER_ID | NUMBER | Contract commitment defining column | ||
NAME | VARCHAR2 | (100) | Y | Name of journal entry batch |
BATCH_STATUS | VARCHAR2 | (1) | Journal entry batch status | |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | Balance type. Values are Actual, Budget, or Encumbrance. |
BUDGETARY_CONTROL_STATUS | VARCHAR2 | (1) | Y | Journal entry batch funds check status |
APPROVAL_STATUS_CODE | VARCHAR2 | (1) | Y | Journal entry batch approval status |
DESCRIPTION | VARCHAR2 | (240) | Journal entry batch description | |
EFFECTIVE_DATE | DATE | Y | Transaction effective date | |
RUNNING_TOTAL_DR | NUMBER | Batch running total debit, entered currency | ||
RUNNING_TOTAL_CR | NUMBER | Batch running total credit, entered currency | ||
CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield context column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CBC_JE_BATCHES does not reference any database object
IGC.IGC_CBC_JE_BATCHES is referenced by following:
Description: | Commitment budgetary control journal entry lines |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_JE_LINES.CURRENCY_CODE | FND_CURRENCIES |
IGC_CBC_JE_LINES.BUDGET_VERSION_ID | GL_BUDGET_VERSIONS |
IGC_CBC_JE_LINES.CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
IGC_CBC_JE_LINES.ENCUMBRANCE_TYPE_ID | GL_ENCUMBRANCE_TYPES |
IGC_CBC_JE_LINES.PERIOD_SET_NAME
IGC_CBC_JE_LINES.PERIOD_NAME |
GL_PERIODS |
IGC_CBC_JE_LINES.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
IGC_CBC_JE_LINES.CBC_JE_BATCH_ID | IGC_CBC_JE_BATCHES |
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_MC_JE_LINES.CBC_JE_BATCH_ID
IGC_CBC_MC_JE_LINES.CBC_JE_LINE_NUM |
IGC_CBC_JE_LINES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_JE_LINES_U1 | UNIQUE | APPS_TS_TX_IDX |
CBC_JE_BATCH_ID
CBC_JE_LINE_NUM |
IGC_CBC_JE_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
CODE_COMBINATION_ID |
IGC_CBC_JE_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | CBC_JE_BATCH_ID |
IGC_CBC_JE_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX |
CODE_COMBINATION_ID
PERIOD_YEAR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
JE_SOURCE | VARCHAR2 | (25) | Y | Journal entry source |
JE_CATEGORY | VARCHAR2 | (25) | Y | Journal entry category |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | Balance type. Values are Actual, Budget, or Encumbrance. |
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type defining column | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | Key Flexfield structure balancing segment value | |
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | Y | Flag to indicate if account is detail or summary |
CODE_COMBINATION_ID | NUMBER | (15) | Y | Key Flexfield combination defining column |
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | Funds checking severity level | |
AMOUNT_TYPE | VARCHAR2 | (4) | Amount type. Values are period to date, quarter to date, or year to date. | |
EFFECTIVE_DATE | DATE | Y | Date journal entry is effective | |
POSTED_DATE | DATE | Date journal entry was posted | ||
PERIOD_YEAR | NUMBER | (15) | Accounting period year | |
DR_CR_CODE | VARCHAR2 | (1) | Debit or credit | |
ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
DESCRIPTION | VARCHAR2 | (240) | Journal entry line description | |
BUDGET_TYPE | VARCHAR2 | (15) | Budget type. Value is always commitment. | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
PERIOD_NAME | VARCHAR2 | (15) | System-generated accounting period name | |
QUARTER_NUM | NUMBER | (15) | Quarter number of accounting period | |
PERIOD_NUM | NUMBER | (15) | Accounting period number | |
STATUS | VARCHAR2 | (1) | Y | Status of line entry. Values are T or P. |
CONTEXT | VARCHAR2 | (150) | Descriptive Flexfield context column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
REFERENCE_1 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_2 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_3 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_4 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_5 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_7 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_8 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_9 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_10 | VARCHAR2 | (240) | Journal entry line reference column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
SUB_HEADER_ID | NUMBER | Contains header id of originating document | ||
MIG_RESULT_CODE | VARCHAR2 | (3) | R11i Data Migration result code. | |
MIG_REQUEST_ID | NUMBER | (15) | R11i Data Migration Request ID | |
AE_HEADER_ID | NUMBER | (15) | R11i migrated XLA AE_HEADER_ID | |
AE_LINE_NUM | NUMBER | (15) | R11i migrated XLA AE_LINE_NUM |
IGC.IGC_CBC_JE_LINES does not reference any database object
IGC.IGC_CBC_JE_LINES is referenced by following:
Description: | Multiple reporting currency table for commitment budgetary control batches |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_MC_JE_BATCHES.REPORTING_SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
IGC_CBC_MC_JE_BATCHES.CBC_JE_BATCH_ID | IGC_CBC_JE_BATCHES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_MC_JE_BATCHES_U1 | UNIQUE | APPS_TS_TX_IDX |
CBC_JE_BATCH_ID
REPORTING_SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
REPORTING_SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
REPORTING_CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code for Reporting Set of Books |
RUNNING_TOTAL_DR | NUMBER | Batch running total debit, entered currency | ||
RUNNING_TOTAL_CR | NUMBER | Batch running total credit, entered currency | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CBC_MC_JE_BATCHES does not reference any database object
IGC.IGC_CBC_MC_JE_BATCHES is referenced by following:
Description: | Multiple reporting currency table for commitment budgetary control journal entry lines |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_MC_JE_LINES.REPORTING_SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
IGC_CBC_MC_JE_LINES.CBC_JE_BATCH_ID
IGC_CBC_MC_JE_LINES.CBC_JE_LINE_NUM |
IGC_CBC_JE_LINES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_MC_JE_LINES_U1 | NONUNIQUE | APPS_TS_TX_IDX |
CBC_JE_BATCH_ID
CBC_JE_LINE_NUM REPORTING_SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CBC_JE_BATCH_ID | NUMBER | (15) | Y | Journal entry batch defining column |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
REPORTING_SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
REPORTING_CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code for Reporting Set of Books |
ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CBC_MC_JE_LINES does not reference any database object
IGC.IGC_CBC_MC_JE_LINES is referenced by following:
Description: | Temporary data for the commitment budgetary control module's open interface loading process |
---|
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
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_OPEN_INTERFACE_U1 | UNIQUE | APPS_TS_INTERFACE |
SET_OF_BOOKS_ID
BATCH_LINE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | (15) | Y | Key Flexfield combination defining column |
BATCH_LINE_NUM | NUMBER | (15) | Y | Journal entry line number |
CC_TRANSACTION_DATE | DATE | Y | Date the funds check or reservation was initiated | |
CC_FUNC_DR_AMT | NUMBER | Functional debit amount | ||
CC_FUNC_CR_AMT | NUMBER | Functional credit amount | ||
JE_SOURCE_NAME | VARCHAR2 | (25) | Y | Journal entry source |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Y | Journal entry category |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Y | Encumbrance type defining column |
TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | Description of transaction | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
REFERENCE_1 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_2 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_3 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_4 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_5 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_7 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_8 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_9 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_10 | VARCHAR2 | (240) | Journal entry line reference column |
IGC.IGC_CBC_OPEN_INTERFACE does not reference any database object
IGC.IGC_CBC_OPEN_INTERFACE is referenced by following:
Description: | Funds check level information specific to contract commitments |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CBC_SUMMARY_TEMPLATES.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
IGC_CBC_SUMMARY_TEMPLATES.TEMPLATE_ID | GL_SUMMARY_TEMPLATES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CBC_SUMMARY_TEMPLATES_U1 | UNIQUE | APPS_TS_TX_IDX | TEMPLATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (15) | Y | Summary template defining column |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
CBC_OVERRIDE | VARCHAR2 | (1) | Y | Funds check severity level override at commitment budget level |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
MIG_RESULT_CODE | VARCHAR2 | (3) | R11i Data Migration result code | |
MIG_REQUEST_ID | NUMBER | (15) | R11i Data Migration Request code. |
IGC.IGC_CBC_SUMMARY_TEMPLATES does not reference any database object
IGC.IGC_CBC_SUMMARY_TEMPLATES is referenced by following:
Description: | Access control table for contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCESS.USER_ID | FND_USER |
IGC_CC_ACCESS.CC_GROUP_ID | % |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ACCESS_U1 | UNIQUE | APPS_TS_TX_IDX | CC_ACCESS_ID |
IGC_CC_ACCESS_N1 | NONUNIQUE | APPS_TS_TX_IDX | CC_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCESS_ID | NUMBER | Y | Access defining column | |
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
CC_GROUP_ID | NUMBER | Access group defining column | ||
USER_ID | NUMBER | (15) | User defining column | |
CC_ACCESS_LEVEL | VARCHAR2 | (1) | Y | Contract access level |
CC_ACCESS_TYPE | VARCHAR2 | (10) | Y | Contract access type |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CC_ACCESS does not reference any database object
IGC.IGC_CC_ACCESS is referenced by following:
Description: | Account lines for contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCT_LINES.TAX_ID | AP_TAX_CODES_ALL |
IGC_CC_ACCT_LINES.CC_CHARGE_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
IGC_CC_ACCT_LINES.CC_BUDGET_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
IGC_CC_ACCT_LINES.PARENT_ACCT_LINE_ID | IGC_CC_ACCT_LINES |
IGC_CC_ACCT_LINES.CC_HEADER_ID | % |
IGC_CC_ACCT_LINES.EXPENDITURE_TYPE | PA_EXPENDITURE_TYPES |
IGC_CC_ACCT_LINES.PROJECT_ID | PA_PROJECTS_ALL |
IGC_CC_ACCT_LINES.TASK_ID | PA_TASKS |
IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINES_ALL |
IGC_CC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINE_LOCATIONS_ALL |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCT_LINES.PARENT_ACCT_LINE_ID | IGC_CC_ACCT_LINES |
IGC_CC_DET_PF_INTERFACE.INTERFACE_ACCT_LINE_ID | IGC_CC_ACCT_LINES |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ACCT_LINES_U1 | UNIQUE | APPS_TS_TX_IDX | CC_ACCT_LINE_ID |
IGC_CC_ACCT_LINES_N1 | NONUNIQUE | APPS_TS_TX_IDX | CC_HEADER_ID |
IGC_CC_ACCT_LINES_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_HEADER_ID |
IGC_CC_ACCT_LINES_N3 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_ACCT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for charge account | |
CC_ACCT_LINE_NUM | NUMBER | Y | Account line number | |
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for budget account | |
CC_ACCT_ENTERED_AMT | NUMBER | Account line entered amount | ||
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount | ||
CC_ACCT_DESC | VARCHAR2 | (240) | Account line description | |
CC_ACCT_BILLED_AMT | NUMBER | Account line billed amount | ||
CC_ACCT_UNBILLED_AMT | NUMBER | Account line unbilled amount | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the line is taxable | |
TAX_ID | NUMBER | (15) | Tax code identifier | |
CC_ACCT_ENCMBRNC_AMT | NUMBER | Amount of the account line that has been encumbered to date on the commitment budget | ||
CC_ACCT_ENCMBRNC_DATE | DATE | Date account line was last encumbered on the commitment budget | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this account line was encumbered | |
PROJECT_ID | NUMBER | (15) | Project accounting project unique identifier | |
TASK_ID | NUMBER | (15) | Project accounting task unique identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Project accounting expenditure operating unit unique identifier | ||
EXPENDITURE_ITEM_DATE | DATE | Date the project expenditure item occurred if account line is related to a project | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_FUNC_WITHHELD_AMT | NUMBER | Functional Withheld Amount | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in the Entered Currency | ||
EVENT_ID | NUMBER | (15) | Event Identifier | |
TAX_CLASSIF_CODE | VARCHAR2 | (50) | Tax Classification Code |
IGC.IGC_CC_ACCT_LINES does not reference any database object
IGC.IGC_CC_ACCT_LINES is referenced by following:
Description: | Open interface table for IGC_CC_ACCT_LINES |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_PARENT_ACCT_LINE_ID | IGC_CC_ACCT_LINES_INTERFACE |
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_HEADER_ID | IGC_CC_HEADERS |
IGC_CC_ACCT_LINES_INTERFACE.PROJECT_ID | PA_PROJECTS_ALL |
IGC_CC_ACCT_LINES_INTERFACE.TASK_ID | PA_TASKS |
IGC_CC_ACCT_LINES_INTERFACE.EXPENDITURE_TYPE | PA_EXPENDITURE_TYPES |
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID | PO_LINES_ALL |
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_ACCT_LINE_ID | PO_LINE_LOCATIONS_ALL |
IGC_CC_ACCT_LINES_INTERFACE.CC_BUDGET_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
IGC_CC_ACCT_LINES_INTERFACE.TAX_ID | AP_TAX_CODES_ALL |
IGC_CC_ACCT_LINES_INTERFACE.CC_CHARGE_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCT_LINES_INTERFACE.INTERFACE_PARENT_ACCT_LINE_ID | IGC_CC_ACCT_LINES_INTERFACE |
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
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ACCT_LINES_INTERFACE_U1 | UNIQUE | APPS_TS_INTERFACE | INTERFACE_ACCT_LINE_ID |
IGC_CC_ACCT_LINES_INTERFACE_U2 | UNIQUE | APPS_TS_INTERFACE |
INTERFACE_HEADER_ID
CC_ACCT_LINE_NUM |
IGC_CC_ACCT_LINES_INTERFACE_N1 | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_HEADER_ID |
IGC_CC_ACCT_LINES_INTERFACE_N2 | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_PARENT_ACCT_LINE_ID |
IGC_CC_ACCT_LINES_INTERFACE_N3 | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
INTERFACE_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
INTERFACE_PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
INTERFACE_PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for charge account | |
CC_ACCT_LINE_NUM | NUMBER | Y | Account line number | |
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for budget account | |
CC_ACCT_ENTERED_AMT | NUMBER | Account line entered amount | ||
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount | ||
CC_ACCT_DESC | VARCHAR2 | (240) | Account line description | |
CC_ACCT_BILLED_AMT | NUMBER | Account line billed amount | ||
CC_ACCT_UNBILLED_AMT | NUMBER | Account line unbilled amount | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the line is taxable | |
TAX_ID | NUMBER | (15) | Tax code identifier | |
CC_ACCT_ENCMBRNC_AMT | NUMBER | Amount of the account line that has been encumbered to date on the commitment budget | ||
CC_ACCT_ENCMBRNC_DATE | DATE | Date account line was last encumbered on the commitment budget | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this account line was encumbered | |
PROJECT_ID | NUMBER | (15) | Project accounting project unique identifier | |
TASK_ID | NUMBER | (15) | Project accounting task unique identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Project accounting expenditure operating unit unique identifier | ||
EXPENDITURE_ITEM_DATE | DATE | Date project expenditure item occurred if the account line is related to a project | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
BATCH_ID | NUMBER | Y | Interface batch defining column | |
PROCESS_STATUS | VARCHAR2 | (1) | Not currently used | |
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in the Entered Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) | Tax Classification Code |
IGC.IGC_CC_ACCT_LINES_INTERFACE does not reference any database object
IGC.IGC_CC_ACCT_LINES_INTERFACE is referenced by following:
Description: | History of account line versions |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACCT_LINE_HISTORY.CC_ACCT_LINE_ID | % |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ACCT_LINE_HISTORY_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_ACCT_LINE_ID
CC_ACCT_VERSION_NUM |
IGC_CC_ACCT_LINE_HISTORY_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CC_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
CC_ACCT_LINE_NUM | NUMBER | Y | Account line number | |
CC_ACCT_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_ACCT_VERSION_ACTION | VARCHAR2 | (1) | Y | Action corresponding to the creation of this version |
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for charge account | |
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for budget account | |
CC_ACCT_ENTERED_AMT | NUMBER | Account line entered amount | ||
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount | ||
CC_ACCT_DESC | VARCHAR2 | (240) | Account line description | |
CC_ACCT_BILLED_AMT | NUMBER | Account line billed amount | ||
CC_ACCT_UNBILLED_AMT | NUMBER | Account line unbilled amount | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the line is taxable | |
TAX_ID | NUMBER | (15) | Tax code identifier | |
CC_ACCT_ENCMBRNC_AMT | NUMBER | Amount of the account line that has been encumbered, to date, on the commitment budget | ||
CC_ACCT_ENCMBRNC_DATE | DATE | Date account line was last encumbered on the commitment budget | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this account line was encumbered | |
PROJECT_ID | NUMBER | (15) | Project accounting project unique identifier | |
TASK_ID | NUMBER | (15) | Project accounting task unique identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Project accounting expenditure operating unit unique identifier | ||
EXPENDITURE_ITEM_DATE | DATE | Date the project expenditure item occurred if the account line is related to a project | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in the Entered Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) | Tax Classification Code |
IGC.IGC_CC_ACCT_LINE_HISTORY does not reference any database object
IGC.IGC_CC_ACCT_LINE_HISTORY is referenced by following:
Description: | Actions performed against contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ACTIONS.CC_HEADER_ID | % |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ACTIONS_U1 | UNIQUE | APPS_TS_TX_IDX |
CC_HEADER_ID
CC_ACTION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
CC_ACTION_NUM | NUMBER | Y | Contract commitment action line number | |
CC_ACTION_VERSION_NUM | NUMBER | Contract commitment version number | ||
CC_ACTION_TYPE | VARCHAR2 | (2) | Category of action committed against a contract | |
CC_ACTION_STATE | VARCHAR2 | (2) | State of the contract | |
CC_ACTION_CTRL_STATUS | VARCHAR2 | (1) | Control status of the contract commitment | |
CC_ACTION_APPRVL_STATUS | VARCHAR2 | (2) | Approval status of the contract commitment | |
CC_ACTION_NOTES | VARCHAR2 | (240) | Free-formatted text describing the nature of the action | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CC_ACTIONS does not reference any database object
IGC.IGC_CC_ACTIONS is referenced by following:
Description: | Account lines for contracts to be archived |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_ACCT_LINES.PARENT_ACCT_LINE_ID | IGC_CC_ARC_ACCT_LINES |
IGC_CC_ARC_ACCT_LINES.CC_HEADER_ID | % |
IGC_CC_ARC_ACCT_LINES.PROJECT_ID | PA_PROJECTS_ALL |
IGC_CC_ARC_ACCT_LINES.TASK_ID | PA_TASKS |
IGC_CC_ARC_ACCT_LINES.EXPENDITURE_TYPE | PA_EXPENDITURE_TYPES |
IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINES_ALL |
IGC_CC_ARC_ACCT_LINES.CC_ACCT_LINE_ID | PO_LINE_LOCATIONS_ALL |
IGC_CC_ARC_ACCT_LINES.CC_BUDGET_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
IGC_CC_ARC_ACCT_LINES.TAX_ID | AP_TAX_CODES_ALL |
IGC_CC_ARC_ACCT_LINES.CC_CHARGE_CODE_COMBINATION_ID | GL_CODE_COMBINATIONS |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_ACCT_LINES.PARENT_ACCT_LINE_ID | IGC_CC_ARC_ACCT_LINES |
IGC_CC_ARC_ACCT_LINES temporarily stores account lines tthat have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_ACCT_LINES_U1 | UNIQUE | APPS_TS_ARCHIVE | CC_ACCT_LINE_ID |
IGC_CC_ARC_ACCT_LINES_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CC_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for charge account | |
CC_ACCT_LINE_NUM | NUMBER | Y | Account line number | |
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | Key flexfield combination defining column for budget account | |
CC_ACCT_ENTERED_AMT | NUMBER | Account line entered amount | ||
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount | ||
CC_ACCT_DESC | VARCHAR2 | (240) | Account line description | |
CC_ACCT_BILLED_AMT | NUMBER | Account line billed amount | ||
CC_ACCT_UNBILLED_AMT | NUMBER | Account line unbilled amount | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the line is taxable | |
TAX_ID | NUMBER | (15) | Tax code identifier | |
CC_ACCT_ENCMBRNC_AMT | NUMBER | Amount of the account line that has been encumbered to date on the commitment budget | ||
CC_ACCT_ENCMBRNC_DATE | DATE | Date account line was last encumbered on the commitment budget | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this account line was encumbered | |
PROJECT_ID | NUMBER | (15) | Project accounting project unique identifier | |
TASK_ID | NUMBER | (15) | Project accounting task unique identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Project accounting expenditure operating unit unique identifier | ||
EXPENDITURE_ITEM_DATE | DATE | Date project expenditure item occurred if the account line is related to a project | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in the Entered Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) | Tax Classification Code |
IGC.IGC_CC_ARC_ACCT_LINES does not reference any database object
IGC.IGC_CC_ARC_ACCT_LINES is referenced by following:
Description: | History of account line versions to be archived |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_ACCT_LINE_HIST.CC_ACCT_LINE_ID | % |
IGC_CC_ARC_ACCT_LINE_HIST temporarily stores account line versions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_ACCT_LINE_HIST_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_ACCT_LINE_ID
CC_ACCT_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
PARENT_HEADER_ID | NUMBER | Contract commitment defining column for the parent contract | ||
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
CC_ACCT_LINE_NUM | NUMBER | Y | Account line number | |
CC_ACCT_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_ACCT_VERSION_ACTION | VARCHAR2 | (1) | Y | Action corresponding to the creation of this version |
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for charge account | |
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column for budget account | |
CC_ACCT_ENTERED_AMT | NUMBER | Account line entered amount | ||
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount | ||
CC_ACCT_DESC | VARCHAR2 | (240) | Account line description | |
CC_ACCT_BILLED_AMT | NUMBER | Account line billed amount | ||
CC_ACCT_UNBILLED_AMT | NUMBER | Account line unbilled amount | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if the line is taxable | |
TAX_ID | NUMBER | (15) | Tax code identifier | |
CC_ACCT_ENCMBRNC_AMT | NUMBER | Amount of account line that has been encumbered to date on the commitment budget | ||
CC_ACCT_ENCMBRNC_DATE | DATE | Date account line was last encumbered on the commitment budget | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this account line was encumbered | |
PROJECT_ID | NUMBER | (15) | Project accounting project unique identifier | |
TASK_ID | NUMBER | (15) | Project accounting task unique identifier | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
EXPENDITURE_ORG_ID | NUMBER | Project accounting expenditure operating unit unique identifier | ||
EXPENDITURE_ITEM_DATE | DATE | Date project expenditure item occurred if the account line is related to a project | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in the Entered Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) | Tax Classification Code |
IGC.IGC_CC_ARC_ACCT_LINE_HIST does not reference any database object
IGC.IGC_CC_ARC_ACCT_LINE_HIST is referenced by following:
Description: | Actions performed against contracts to be archived |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_ACTIONS.CC_HEADER_ID | % |
IGC_CC_ARC_ACTIONS temporarily stores contract actions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_ACTIONS_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_HEADER_ID
CC_ACTION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
CC_ACTION_NUM | NUMBER | Y | Contract commitment action line number | |
CC_ACTION_VERSION_NUM | NUMBER | Contract commitment version number | ||
CC_ACTION_TYPE | VARCHAR2 | (2) | Category of action committed against a contract | |
CC_ACTION_STATE | VARCHAR2 | (2) | State of the contract | |
CC_ACTION_CTRL_STATUS | VARCHAR2 | (1) | Control status of the contract commitment | |
CC_ACTION_APPRVL_STATUS | VARCHAR2 | (2) | Approval status of the contract commitment | |
CC_ACTION_NOTES | VARCHAR2 | (240) | Free-formatted text describing the nature of the action | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CC_ARC_ACTIONS does not reference any database object
IGC.IGC_CC_ARC_ACTIONS is referenced by following:
Description: | Detail payment forecast lines for contracts to be archived |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_DET_PF.CC_ACCT_LINE_ID | % |
IGC_CC_ARC_DET_PF.CC_DET_PF_LINE_ID | PO_DISTRIBUTIONS_ALL |
IGC_CC_ARC_DET_PF.PARENT_DET_PF_LINE_ID | IGC_CC_ARC_DET_PF |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_DET_PF.PARENT_DET_PF_LINE_ID | IGC_CC_ARC_DET_PF |
IGC_CC_ARC_DET_PF temporarily stores detail payment forecast lines that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_DET_PF_U1 | UNIQUE | APPS_TS_ARCHIVE | CC_DET_PF_LINE_ID |
IGC_CC_ARC_DET_PF_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CC_ACCT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
CC_DET_PF_LINE_NUM | NUMBER | Y | Detail payment forecast line number | |
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
PARENT_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column for parent detail payment forecast line | ||
CC_DET_PF_ENTERED_AMT | NUMBER | Detail payment forecast entered line amount | ||
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_DATE | DATE | Y | Detail payment forecast line date | |
CC_DET_PF_BILLED_AMT | NUMBER | Detail payment forecast line billed amount | ||
CC_DET_PF_UNBILLED_AMT | NUMBER | Detail payment forecast line unbilled amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Amount of the detail payment forecast line that has been encumbered to date on the standard budget | ||
CC_DET_PF_ENCMBRNC_DATE | DATE | Date detail payment forecast line was last encumbered on the standard budget | ||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this line of the detail payment forecast was encumbered | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_ARC_DET_PF does not reference any database object
IGC.IGC_CC_ARC_DET_PF is referenced by following:
Description: | Detail payment forecast line versions to be archived |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ARC_DET_PF_HIST.CC_DET_PF_LINE_ID | % |
IGC_CC_ARC_DET_PF_HIST temporarily stores detail payment forecast line versions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_DET_PF_HIST_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_DET_PF_LINE_ID
CC_DET_PF_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
CC_DET_PF_LINE_NUM | NUMBER | Y | Detail payment forecast line number | |
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
PARENT_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column for parent detail payment forecast line | ||
CC_DET_PF_VERSION_NUM | NUMBER | Y | Detail payment forecast line version number | |
CC_DET_PF_VERSION_ACTION | VARCHAR2 | (1) | Y | Detail payment forecast line version action |
CC_DET_PF_ENTERED_AMT | NUMBER | Detail payment forecast entered line amount | ||
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_DATE | DATE | Detail payment forecast line date | ||
CC_DET_PF_BILLED_AMT | NUMBER | Detail payment forecast line billed amount | ||
CC_DET_PF_UNBILLED_AMT | NUMBER | Detail payment forecast line unbilled amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Amount of the detail payment forecast line that has been encumbered to date on the standard budget | ||
CC_DET_PF_ENCMBRNC_DATE | DATE | Date detail payment forecast line was last encumbered on the standard budget | ||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this line of the detail payment forecast was encumbered | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_ARC_DET_PF_HIST does not reference any database object
IGC.IGC_CC_ARC_DET_PF_HIST is referenced by following:
Description: | Multiple reporting currency table for account lines to be archived |
---|
IGC_CC_ARC_MC_ACCT_LINES temporarily stores multiple reporting currency information on account lines that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_ACCT_LINES_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_ACCT_LINE_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount to be converted | ||
CC_ACCT_ENCMBRNC_AMT | NUMBER | Account line encumbrance amount to be converted | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency |
IGC.IGC_CC_ARC_MC_ACCT_LINES does not reference any database object
IGC.IGC_CC_ARC_MC_ACCT_LINES is referenced by following:
Description: | Multiple reporting currency table for account lines to be archived |
---|
IGC_CC_ARC_MC_ACCT_LINE_HIST temporarily stores multiple reporting currency information on account line versions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_ACCT_LINE_HIS_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_ACCT_VERSION_NUM
CC_ACCT_LINE_ID SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount to be converted | ||
CC_ACCT_ENCMBRNC_AMT | NUMBER | Account line encumbrance amount to be converted | ||
CC_ACCT_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_ACCT_VERSION_ACTION | VARCHAR2 | (1) | Y | Action corresponding to the creation of this version |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency |
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:
Description: | Multiple reporting currency table for detail payment forecast lines to be archived |
---|
IGC_CC_ARC_MC_DET_PF temporarily stores multiple reporting currency information on detail payment forecast lines that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_DET_PF_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_DET_PF_LINE_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional amount to be converted | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Detail payment forecast encumbrance amount to be converted | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_ARC_MC_DET_PF does not reference any database object
IGC.IGC_CC_ARC_MC_DET_PF is referenced by following:
Description: | Multiple reporting currency table for detail payment forecast lines to be archived |
---|
IGC_CC_ARC_MC_DET_PF_HIST temporarily stores multiple reporting currency information on detail payment forecast line versions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_DET_PF_HIST_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_DET_PF_VERSION_NUM
CC_DET_PF_LINE_ID SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional amount to be converted | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Detail payment forecast encumbrance amount to be converted | ||
CC_DET_PF_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_DET_PF_VERSION_ACTION | VARCHAR2 | (1) | Y | Action corresponding to the creation of this version |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
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:
Description: | Multiple reporting currency table for contracts to be archived |
---|
IGC_CC_ARC_MC_HEADERS temporarily stores multiple reporting currency information on contracts that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_HEADERS_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_HEADER_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_ARC_MC_HEADERS does not reference any database object
IGC.IGC_CC_ARC_MC_HEADERS is referenced by following:
Description: | Multiple reporting currency table for contracts to be archived |
---|
IGC_CC_ARC_MC_HEADER_HIST temporarily stores multiple reporting currency information on contract versions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_MC_HEADER_HIST_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_HEADER_ID
SET_OF_BOOKS_ID CC_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_VERSION_ACTION | VARCHAR2 | (1) | Y | Action corresponding to the creation of this version |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_ARC_MC_HEADER_HIST does not reference any database object
IGC.IGC_CC_ARC_MC_HEADER_HIST is referenced by following:
Description: | Purchase order distributions to be archived |
---|
IGC_CC_ARC_PO_DISTRIBUTION_ALL temporarily stores purchase order distributions that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_PO_DISTRIB_ALL_U1 | UNIQUE | APPS_TS_ARCHIVE | PO_DISTRIBUTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_DISTRIBUTION_ID | NUMBER | Y | Document distribution unique identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PO_HEADER_ID | NUMBER | Y | Document header unique identifier | |
PO_LINE_ID | NUMBER | Y | Document line unique identifier | |
LINE_LOCATION_ID | NUMBER | Y | Document shipment schedule unique identifier | |
SET_OF_BOOKS_ID | NUMBER | Y | Accounting books defining column | |
CODE_COMBINATION_ID | NUMBER | Y | Key Flexfield combination defining column | |
QUANTITY_ORDERED | NUMBER | Y | Quantity ordered on the distribution | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
PO_RELEASE_ID | NUMBER | Release unique identifier | ||
QUANTITY_DELIVERED | NUMBER | Quantity delivered against the distribution | ||
QUANTITY_BILLED | NUMBER | Quantity invoiced by Oracle Payables against the distribution | ||
QUANTITY_CANCELLED | NUMBER | Quantity cancelled for the distribution | ||
REQ_HEADER_REFERENCE_NUM | VARCHAR2 | (25) | Requisition number of requisition line placed on this distribution | |
REQ_LINE_REFERENCE_NUM | VARCHAR2 | (25) | Line number of requisition line placed on the distribution | |
REQ_DISTRIBUTION_ID | NUMBER | Requisition distribution unique identifier | ||
DELIVER_TO_LOCATION_ID | NUMBER | Unique identifier for the delivery location | ||
DELIVER_TO_PERSON_ID | NUMBER | (9) | Unique identifier for the requestor | |
RATE_DATE | DATE | Currency conversion date | ||
RATE | NUMBER | Currency conversion rate | ||
AMOUNT_BILLED | NUMBER | Amount invoiced by Oracle Payables against the distribution | ||
ACCRUED_FLAG | VARCHAR2 | (1) | Indicates whether the distribution was accrued or not | |
ENCUMBERED_FLAG | VARCHAR2 | (1) | Distribution encumbered flag | |
ENCUMBERED_AMOUNT | NUMBER | Encumbered amount for distribution | ||
UNENCUMBERED_QUANTITY | NUMBER | Quantity unencumbered on the distribution | ||
UNENCUMBERED_AMOUNT | NUMBER | Amount unencumbered on the distribution | ||
FAILED_FUNDS_LOOKUP_CODE | VARCHAR2 | (25) | Type of budgetary control approval failure | |
GL_ENCUMBERED_DATE | DATE | Date distribution was encumbered | ||
GL_ENCUMBERED_PERIOD_NAME | VARCHAR2 | (15) | Period in which the distribution was encumbered | |
GL_CANCELLED_DATE | DATE | Date distribution was cancelled | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Describes final destination of the purchased items | |
DESTINATION_ORGANIZATION_ID | NUMBER | Final destination organization unique identifier | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | Subinventory unique identifier for inventory purchases | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
WIP_ENTITY_ID | NUMBER | Work in progress job or repetitive assembly identifier | ||
WIP_OPERATION_SEQ_NUM | NUMBER | Work in progress sequence number within a routing | ||
WIP_RESOURCE_SEQ_NUM | NUMBER | Work in progress resource sequence number | ||
WIP_REPETITIVE_SCHEDULE_ID | NUMBER | Work in progress repetitive schedule identifier | ||
WIP_LINE_ID | NUMBER | Work in progress line identifier | ||
BOM_RESOURCE_ID | NUMBER | Bill of Materials resource unique identifier | ||
BUDGET_ACCOUNT_ID | NUMBER | General Ledger budget account unique identifier | ||
ACCRUAL_ACCOUNT_ID | NUMBER | General Ledger accrual account unique identifier | ||
VARIANCE_ACCOUNT_ID | NUMBER | General Ledger variance account unique identifier | ||
PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Indicates whether distribution should be encumbered | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States Standard General Ledger transaction code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | United States Standard General Ledger Descriptive Flexfield context column | |
DESTINATION_CONTEXT | VARCHAR2 | (30) | Destination details protected Descriptive Flexfield context column | |
DISTRIBUTION_NUM | NUMBER | Y | Distribution number | |
SOURCE_DISTRIBUTION_ID | NUMBER | Unique identifier of planned purchase order distribution that was referenced when creating this scheduled release distribution | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
PROJECT_ID | NUMBER | Project accounting project unique identifier | ||
TASK_ID | NUMBER | Project accounting task unique identifier | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | Project accounting expenditure type | |
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | Project accounting descriptive Flexfield context column | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | Project accounting expenditure organization unique identifier | ||
GL_CLOSED_DATE | DATE | Date the distribution was final-closed | ||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | Indicates whether items are accrued on receipt | |
EXPENDITURE_ITEM_DATE | DATE | Project accounting expenditure item date | ||
ORG_ID | NUMBER | Organization identifier | ||
KANBAN_CARD_ID | NUMBER | Primary key for the kanban card | ||
AWARD_ID | NUMBER | (15) | Award identifier | |
MRC_RATE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and currency conversion date pairs. | |
MRC_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and currency conversion rate pairs. | |
MRC_ENCUMBERED_AMOUNT | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and encumbered amount for distribution pairs. | |
MRC_UNENCUMBERED_AMOUNT | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and unencumbered amount for distribution pairs. | |
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | Project Manufacturing end item unit number | |
RECOVERABLE_TAX | NUMBER | Recoverable tax amount | ||
NONRECOVERABLE_TAX | NUMBER | Nonrecoverable tax amount | ||
RECOVERY_RATE | NUMBER | Percentage of tax that can be recovered | ||
TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicator of whether tax recovery should be used | |
BASE_AMOUNT_BILLED | NUMBER | Base amount billed | ||
TAX_RECOVERY_RATE | NUMBER | (15) | Percentage of tax that can be recovered | |
MRC_BASE_AMOUNT_BILLED | VARCHAR2 | (2000) | Multiple Reporting Currency base amount billed |
IGC.IGC_CC_ARC_PO_DISTRIBUTION_ALL does not reference any database object
IGC.IGC_CC_ARC_PO_DISTRIBUTION_ALL is referenced by following:
Description: | Document headers for purchase orders, purchase agreements, quotations, and RFQs to be archived |
---|
IGC_CC_ARC_PO_HEADERS_ALL temporarily stores purchase order header information that has been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_PO_HEADERS_ALL_U1 | UNIQUE | APPS_TS_ARCHIVE | PO_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_HEADER_ID | NUMBER | Y | Document header unique identifier | |
AGENT_ID | NUMBER | (9) | Y | Buyer unique identifier |
TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Y | Type of document |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
SEGMENT1 | VARCHAR2 | (20) | Y | Key flexfield segment |
SUMMARY_FLAG | VARCHAR2 | (1) | Y | Key Flexflield summary flag |
ENABLED_FLAG | VARCHAR2 | (1) | Y | Key Flexfield enabled flag |
SEGMENT2 | VARCHAR2 | (20) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (20) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (20) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (20) | Key flexfield segment | |
START_DATE_ACTIVE | DATE | Key Flexfield start date | ||
END_DATE_ACTIVE | DATE | Key Flexfield end date | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
VENDOR_ID | NUMBER | Supplier unique identifier | ||
VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
VENDOR_CONTACT_ID | NUMBER | Supplier contact unique identifier | ||
SHIP_TO_LOCATION_ID | NUMBER | Ship-to location unique identifier | ||
BILL_TO_LOCATION_ID | NUMBER | Bill-to location unique identifier | ||
TERMS_ID | NUMBER | Payment terms unique identifier | ||
SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Type of carrier to be used | |
FOB_LOOKUP_CODE | VARCHAR2 | (25) | Type of free-on-board terms for document | |
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | Type of freight terms for document | |
STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Status of request for proposals or quotation | |
CURRENCY_CODE | VARCHAR2 | (15) | Unique identifier for currency | |
RATE_TYPE | VARCHAR2 | (30) | Currency conversion rate type | |
RATE_DATE | DATE | Currency conversion date | ||
RATE | NUMBER | Currency conversion rate | ||
FROM_HEADER_ID | NUMBER | Unique identifier of request for proposals used to autocreate another document | ||
FROM_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Document type of document used to autocreate another document | |
START_DATE | DATE | Date document becomes effective | ||
END_DATE | DATE | Expiration date of document | ||
BLANKET_TOTAL_AMOUNT | NUMBER | Amount agreed for planned or blanket purchase order | ||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of purchase order | |
REVISION_NUM | NUMBER | Document revision number | ||
REVISED_DATE | DATE | Date document was last revised | ||
APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether purchase order is approved or not | |
APPROVED_DATE | DATE | Date purchase order was last approved | ||
AMOUNT_LIMIT | NUMBER | Maximum amount that can be released against the purchase order | ||
MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a blanket or planned purchase order | ||
NOTE_TO_AUTHORIZER | VARCHAR2 | (240) | Not currently used | |
NOTE_TO_VENDOR | VARCHAR2 | (240) | Note to the supplier | |
NOTE_TO_RECEIVER | VARCHAR2 | (240) | Note to the receiver of the purchase order | |
PRINT_COUNT | NUMBER | Number of times document was printed | ||
PRINTED_DATE | DATE | Date document was last printed | ||
VENDOR_ORDER_NUM | VARCHAR2 | (25) | No longer used | |
CONFIRMING_ORDER_FLAG | VARCHAR2 | (1) | Indicates whether purchase order is a confirming order or not | |
COMMENTS | VARCHAR2 | (240) | Descriptive comments for document | |
REPLY_DATE | DATE | Date supplier replied to the request for quote | ||
REPLY_METHOD_LOOKUP_CODE | VARCHAR2 | (25) | Method supplier should use to reply to the request for quote | |
RFQ_CLOSE_DATE | DATE | Date request for quote will be closed | ||
QUOTE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Type of quotation | |
QUOTATION_CLASS_CODE | VARCHAR2 | (25) | Class of quotation | |
QUOTE_WARNING_DELAY_UNIT | VARCHAR2 | (25) | Warning delay unit of measure | |
QUOTE_WARNING_DELAY | NUMBER | Number of days prior to expiration of the quotation that you should be notified | ||
QUOTE_VENDOR_QUOTE_NUMBER | VARCHAR2 | (25) | Number of quotation for the supplier | |
ACCEPTANCE_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether acceptance from the supplier is required or not | |
ACCEPTANCE_DUE_DATE | DATE | Date by which supplier should accept | ||
CLOSED_DATE | DATE | Date document was closed | ||
USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether purchase order is on hold or not | |
APPROVAL_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether a quote or request for quote requires approval | |
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether purchase order is cancelled or not | |
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Indicates whether user wants to prevent this purchase order from being automatically rescheduled by themanufacturing application | |
FIRM_DATE | DATE | Date from which the purchase order if firmed | ||
FROZEN_FLAG | VARCHAR2 | (1) | Indicates whether document is frozen or not | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CLOSED_CODE | VARCHAR2 | (25) | Describes closure status of the document | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States Standard General Ledger transaction code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | United States Standard General Ledger Descriptive Flexfield context column | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ORG_ID | NUMBER | Organization identifier | ||
SUPPLY_AGREEMENT_FLAG | VARCHAR2 | (1) | Supplier agreement flag for supplier scheduling | |
EDI_PROCESSED_FLAG | VARCHAR2 | (1) | EDI processed flag | |
EDI_PROCESSED_STATUS | VARCHAR2 | (10) | EDI processed status flag | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Global Descriptive Flexfield stucture defining column | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Audit trail reference | |
REFERENCE_NUM | VARCHAR2 | (25) | Audit trail reference | |
WF_ITEM_TYPE | VARCHAR2 | (8) | Workflow approval item type | |
WF_ITEM_KEY | VARCHAR2 | (240) | Workflow approval item key | |
MRC_RATE_TYPE | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and currency conversion rate type pairs. | |
MRC_RATE_DATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and currency conversion date pairs. | |
MRC_RATE | VARCHAR2 | (2000) | Multiple Reporting Currencies only. Concatenated string of Reporting Set of Books identifier and currency conversion rate pairs. | |
PCARD_ID | NUMBER | (15) | Unique identifier for procurement card used for the order | |
PRICE_UPDATE_TOLERANCE | NUMBER | Maximum percentage increase allowed in price or sales catalog update | ||
PAY_ON_CODE | VARCHAR2 | (25) | Indicates whether purchase order is paid upon receipt |
IGC.IGC_CC_ARC_PO_HEADERS_ALL does not reference any database object
IGC.IGC_CC_ARC_PO_HEADERS_ALL is referenced by following:
Description: | Purchase document lines for purchase orders, purchase agreements, quotations, and RFQs to be archived |
---|
IGC_CC_ARC_PO_LINES_ALL temporarily stores purchase document lines that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_PO_LINES_ALL_U1 | UNIQUE | APPS_TS_ARCHIVE | PO_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PO_LINE_ID | NUMBER | Y | Document line unique identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PO_HEADER_ID | NUMBER | Y | Document header unique identifier | |
LINE_TYPE_ID | NUMBER | Y | Line type unique identifier | |
LINE_NUM | NUMBER | Y | Line number | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
ITEM_ID | NUMBER | Item unique identifier | ||
ITEM_REVISION | VARCHAR2 | (3) | Item revision | |
CATEGORY_ID | NUMBER | Item category unique identifier | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item description | |
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Unit of measure for the quantity ordered | |
QUANTITY_COMMITTED | NUMBER | Quantity agreed for an agreement line | ||
COMMITTED_AMOUNT | NUMBER | Amount agreed for an agreement line | ||
ALLOW_PRICE_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicates whether or not user can change the price on releases | |
NOT_TO_EXCEED_PRICE | NUMBER | Price limit that user cannot exceed on a release shipment | ||
LIST_PRICE_PER_UNIT | NUMBER | List price for item on the line | ||
UNIT_PRICE | NUMBER | Unit price for line | ||
QUANTITY | NUMBER | Quantity ordered on line | ||
UN_NUMBER_ID | NUMBER | UN number unique identifier | ||
HAZARD_CLASS_ID | NUMBER | Hazard class unique identifier | ||
NOTE_TO_VENDOR | VARCHAR2 | (240) | Short note to supplier | |
FROM_HEADER_ID | NUMBER | Quotation unique identifier | ||
FROM_LINE_ID | NUMBER | Quotation line unique identifier | ||
MIN_ORDER_QUANTITY | NUMBER | Minimum order quantity for a quotation line | ||
MAX_ORDER_QUANTITY | NUMBER | Maximum order quantity for a quotation line | ||
QTY_RCV_TOLERANCE | NUMBER | Quantity received tolerance percentage | ||
OVER_TOLERANCE_ERROR_FLAG | VARCHAR2 | (25) | Indicates whether or not user rejects receipts exceeding the tolerance | |
MARKET_PRICE | NUMBER | Market price for item on the line | ||
UNORDERED_FLAG | VARCHAR2 | (1) | Indicates whether or not line was created from unordered receipts | |
CLOSED_FLAG | VARCHAR2 | (1) | Indicates whether line is closed or not | |
USER_HOLD_FLAG | VARCHAR2 | (1) | Indicates whether line is on hold or not. No longer used. | |
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether line is cancelled or not | |
CANCELLED_BY | NUMBER | (9) | Unique identifier of employee who cancelled the line | |
CANCEL_DATE | DATE | Cancellation date | ||
CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by employee | |
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (30) | Firming status of line. No longer used. | |
FIRM_DATE | DATE | Date line becomes firmed. No longer used. | ||
VENDOR_PRODUCT_NUM | VARCHAR2 | (25) | Supplier product number | |
CONTRACT_NUM | VARCHAR2 | (25) | Contract number referenced on line | |
TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether document line is taxable or not | |
TAX_NAME | VARCHAR2 | (15) | Tax code applying to line | |
TYPE_1099 | VARCHAR2 | (10) | 1099 type for purchase order line | |
CAPITAL_EXPENSE_FLAG | VARCHAR2 | (1) | Indicates whether line is for a capital expense or not | |
NEGOTIATED_BY_PREPARER_FLAG | VARCHAR2 | (1) | Indicates whether buyer negotiated the price or not | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
REFERENCE_NUM | VARCHAR2 | (25) | Reference number. No longer used. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
MIN_RELEASE_AMOUNT | NUMBER | Minimum amount that can be released against a planned or blanket agreement line | ||
PRICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Price type of line | |
CLOSED_CODE | VARCHAR2 | (25) | Describes closure status of line | |
PRICE_BREAK_LOOKUP_CODE | VARCHAR2 | (25) | Describes pricing scheme for blanket agreement line price breaks | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States Standard General Ledger transaction code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | United States Standard General Ledger Descriptive Flexfield context column | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
CLOSED_DATE | DATE | Date line is closed | ||
CLOSED_REASON | VARCHAR2 | (240) | Describes why line is closed | |
CLOSED_BY | NUMBER | (9) | Unique identifier of employee who closed the line | |
TRANSACTION_REASON_CODE | VARCHAR2 | (25) | Transaction reason | |
ORG_ID | NUMBER | Organization identifier | ||
QC_GRADE | VARCHAR2 | (25) | Stores quality control grade wanted on the purchase order line | |
BASE_UOM | VARCHAR2 | (25) | Stores base unit of measure for the item ordered | |
BASE_QTY | NUMBER | Converted ordered quantity from the transaction unit of measure to base unit of measure | ||
SECONDARY_UOM | VARCHAR2 | (25) | Stores the item's dual unit of measure for the item ordered | |
SECONDARY_QTY | NUMBER | Converted quantity from base unit of measure to dual unit of measure | ||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Global Descriptive Flexfield Structure defining column | |
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
LINE_REFERENCE_NUM | VARCHAR2 | (25) | Audit trail reference. Needed for 832 EDI transaction. | |
PROJECT_ID | NUMBER | Project Accounting project unique identifier | ||
TASK_ID | NUMBER | Project Accounting task unique identifier | ||
EXPIRATION_DATE | DATE | Date after which the item on this catalog line can no longer be ordered | ||
TAX_CODE_ID | NUMBER | Unique identifier for tax code |
IGC.IGC_CC_ARC_PO_LINES_ALL does not reference any database object
IGC.IGC_CC_ARC_PO_LINES_ALL is referenced by following:
Description: | Document shipment schedules for purchase orders, purchase agreements, quotations, and RFQs to be archived |
---|
IGC_CC_ARC_PO_LINE_LOC_ALL temporarily stores document shipment schedules that have been archived.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ARC_PO_LINE_LOC_ALL_U1 | UNIQUE | APPS_TS_ARCHIVE | LINE_LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_LOCATION_ID | NUMBER | Y | Document shipment schedule unique identifier | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
PO_HEADER_ID | NUMBER | Y | Document header unique identifier | |
PO_LINE_ID | NUMBER | Y | Document line unique identifier | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
QUANTITY | NUMBER | Quantity ordered or break quantity for blanket purchase | ||
QUANTITY_RECEIVED | NUMBER | Quantity received to date | ||
QUANTITY_ACCEPTED | NUMBER | Quantity accepted to date after inspection | ||
QUANTITY_REJECTED | NUMBER | Quantity rejected to date after inspection | ||
QUANTITY_BILLED | NUMBER | Quantity invoiced to date by Oracle Payables | ||
QUANTITY_CANCELLED | NUMBER | Quantity cancelled | ||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | Price break quantity unit of measure | |
PO_RELEASE_ID | NUMBER | Release unique identifier for a release shipment | ||
SHIP_TO_LOCATION_ID | NUMBER | Unique identifier for the ship-to-location | ||
SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | Type of carrier for the request for quote or quotation shipment | |
NEED_BY_DATE | DATE | Need by date for the shipment schedule | ||
PROMISED_DATE | DATE | Supplier promised delivery date | ||
LAST_ACCEPT_DATE | DATE | Last acceptable receipt date for the shipment | ||
PRICE_OVERRIDE | NUMBER | Order shipment price or break price for blanket purchase orders | ||
ENCUMBERED_FLAG | VARCHAR2 | (1) | Indicates whether the shipment is encumbered or not | |
ENCUMBERED_DATE | DATE | Date of encumbrance for shipment | ||
UNENCUMBERED_QUANTITY | NUMBER | Unemcumbered quantity to date. No longer used. | ||
FOB_LOOKUP_CODE | VARCHAR2 | (25) | Type of free-on-board terms for the shipment | |
FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | Type of freight terms for the request for quote or quotation shipment | |
TAXABLE_FLAG | VARCHAR2 | (1) | Indicates whether shipment is taxable or not | |
TAX_NAME | VARCHAR2 | (15) | Tax code for shipment | |
ESTIMATED_TAX_AMOUNT | NUMBER | Estimated tax amount for purchase order shipment. No longer used. | ||
FROM_HEADER_ID | NUMBER | Unique identifier of request for quotes used to autocreate the quotation | ||
FROM_LINE_ID | NUMBER | Unique identifier of request for quotes line used to autocreate the quotation line | ||
FROM_LINE_LOCATION_ID | NUMBER | Unique identifier of request for quotes shipment used to autocreate a quotation shipment | ||
START_DATE | DATE | Effective date of the price break. Applies to request for quotes and quotations only. | ||
END_DATE | DATE | Expiration date of the price break. Applies to request for quotes and quotations only. | ||
LEAD_TIME | NUMBER | Lead time for the price break. Applies to request for quotes and quotations only. | ||
LEAD_TIME_UNIT | VARCHAR2 | (25) | Unit of measure for the lead time | |
PRICE_DISCOUNT | NUMBER | Discount percentage for price break. Applies to request for quotes and quotations only. | ||
TERMS_ID | NUMBER | Payment terms unique identifier | ||
APPROVED_FLAG | VARCHAR2 | (1) | Indicates whether shipment is approved or not | |
APPROVED_DATE | DATE | Approval date for shipment. No longer used. | ||
CLOSED_FLAG | VARCHAR2 | (1) | No longer used | |
CANCEL_FLAG | VARCHAR2 | (1) | Indicates whether shipment is cancelled or not | |
CANCELLED_BY | NUMBER | (9) | Unique identifier of employee who cancelled the shipment | |
CANCEL_DATE | DATE | Cancellation date | ||
CANCEL_REASON | VARCHAR2 | (240) | Cancellation reason provided by the employee | |
FIRM_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | Indicates whether shipment is firmed or not | |
FIRM_DATE | DATE | No longer used | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
UNIT_OF_MEASURE_CLASS | VARCHAR2 | (25) | Unit of measure class. No longer used. | |
ENCUMBER_NOW | VARCHAR2 | (1) | Indicates whether shipment must be inspected before the invoice is paid | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
INSPECTION_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether shipment must be inspected before the invoice is paid | |
RECEIPT_REQUIRED_FLAG | VARCHAR2 | (1) | Indicates whether shipment must be received before the invoice is paid | |
QTY_RCV_TOLERANCE | NUMBER | Maximum over-receipt tolerance percentage | ||
QTY_RCV_EXCEPTION_CODE | VARCHAR2 | (25) | Describes what action is taken when the quantity received tolerance is exceeded | |
ENFORCE_SHIP_TO_LOCATION_CODE | VARCHAR2 | (25) | Describes what action is taken when the receiving location differs from the ship-to-location | |
ALLOW_SUBSTITUTE_RECEIPTS_FLAG | VARCHAR2 | (1) | Indicates whether substitute items can be received in place of the ordered items | |
DAYS_EARLY_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received early | ||
DAYS_LATE_RECEIPT_ALLOWED | NUMBER | Maximum acceptable number of days items can be received early | ||
RECEIPT_DAYS_EXCEPTION_CODE | VARCHAR2 | (25) | Describes what action is taken when items are received earlier or later than the allowed number of days specified | |
INVOICE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for invoice when billed | ||
RECEIVE_CLOSE_TOLERANCE | NUMBER | Percentage tolerance within which a shipment is automatically closed for receiving | ||
SHIP_TO_ORGANIZATION_ID | NUMBER | Ship-to organization unique identifier | ||
SHIPMENT_NUM | NUMBER | Shipment line number | ||
SOURCE_SHIPMENT_ID | NUMBER | Unique identifier of planned purchase order shipment that was referenced when creating this scheduled release shipment | ||
SHIPMENT_TYPE | VARCHAR2 | (25) | Y | Type of shipment |
CLOSED_CODE | VARCHAR2 | (25) | Describes closure status of shipment | |
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | United States Standard General Ledger transaction code | |
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | United States Standard General Ledger Descriptive Flexfield context column | |
RECEIVING_ROUTING_ID | NUMBER | Receipt routing unique identifier | ||
ACCRUE_ON_RECEIPT_FLAG | VARCHAR2 | (1) | Indicates whether items are accrued on receipt | |
CLOSED_REASON | VARCHAR2 | (240) | Describes why shipment is closed | |
CLOSED_DATE | DATE | Date shipment is closed | ||
CLOSED_BY | NUMBER | (9) | Unique identifier of employee who closed the shipment | |
ORG_ID | NUMBER | Organization identifier | ||
GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | Global Descriptive Flexfield segment | |
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Global Descriptive Flexfield structure defining segment | |
QUANTITY_SHIPPED | NUMBER | Quantity shipped | ||
COUNTRY_OF_ORIGIN_CODE | VARCHAR2 | (2) | Country of manufacturing for the shipment | |
TAX_USER_OVERRIDE_FLAG | VARCHAR2 | (1) | Indicator of whether somone overrode the default tax | |
MATCH_FLAG | VARCHAR2 | (1) | Match Flag | |
MATCH_OPTION | VARCHAR2 | (25) | Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt | |
TAX_CODE_ID | NUMBER | Unique identifier for the tax code | ||
CALCULATE_TAX_FLAG | VARCHAR2 | (1) | Indicator of whether tax needs to be calculated | |
CHANGE_PROMISED_DATE_REASON | VARCHAR2 | (240) | Reason for changing the promised-by date |
IGC.IGC_CC_ARC_PO_LINE_LOC_ALL does not reference any database object
IGC.IGC_CC_ARC_PO_LINE_LOC_ALL is referenced by following:
Description: | Commitment budgetary control enable |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_BC_ENABLE.SET_OF_BOOKS_ID | GL_SETS_OF_BOOKS |
IGC_CC_BC_ENABLE stores information required to enable or disable commitment budgetary control for the given Set of Books. Commitment budgetary control is enabled and disabled separate and apart from standard budgetary control.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_BC_ENABLE_U1 | UNIQUE | APPS_TS_TX_IDX | SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
CC_BC_ENABLE_FLAG | VARCHAR2 | (1) | Flag to indicate whether commitment budgetary control is enabled | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CBC_PO_ENABLE | VARCHAR2 | (1) | Flag if 'Y' implies that Commitment Budget Control is enabled for Purchase Orders, if 'N' then disabled |
IGC.IGC_CC_BC_ENABLE does not reference any database object
IGC.IGC_CC_BC_ENABLE is referenced by following:
Description: | Detail payment forecast lines for contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_DET_PF.PARENT_DET_PF_LINE_ID | IGC_CC_DET_PF |
IGC_CC_DET_PF.CC_ACCT_LINE_ID | % |
IGC_CC_DET_PF.CC_DET_PF_LINE_ID | PO_DISTRIBUTIONS_ALL |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_DET_PF.PARENT_DET_PF_LINE_ID | IGC_CC_DET_PF |
IGC_CC_DET_PF stores current information pertaining to each line of the detail payment forecast for the given account line of the contract. For each row in the IGC_CC_ACCT_LINE table, there can be one or more rows in the IGC_CC_DET_PF table. Each row includes the corresponding CC_ACCT_LINE_ID for the given account line, the payment forecast line number, and other information specific to the detail payment forecast line. If standard budgetary control is enabled and if this is a parent contract, the amount for this payment forecast line, in the functional currency, is encumbered against the standard budget. The CC_DET_PF_AMT reflects the total amount that has been encumbered to date for this line of the payment forecast. If the payment forecast line is for a release contract commitment, the payment forecast line will be related to a parent detail payment forecast line. The PARENT_ACCT_LINE_ID and PARENT_DET_PF_LINE_ID form the relationship between the parent contract commitment and the release contract commitment for any given release payment forecast line.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_DET_PF_U1 | UNIQUE | APPS_TS_TX_IDX | CC_DET_PF_LINE_ID |
IGC_CC_DET_PF_N1 | NONUNIQUE | APPS_TS_TX_IDX | CC_ACCT_LINE_ID |
IGC_CC_DET_PF_N2 | NONUNIQUE | APPS_TS_TX_IDX | PARENT_DET_PF_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
CC_DET_PF_LINE_NUM | NUMBER | Y | Detail payment forecast line number | |
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
PARENT_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column for parent detail payment forecast line | ||
CC_DET_PF_ENTERED_AMT | NUMBER | Detail payment forecast entered line amount | ||
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_DATE | DATE | Y | Detail payment forecast line date | |
CC_DET_PF_BILLED_AMT | NUMBER | Detail payment forecast line billed amount | ||
CC_DET_PF_UNBILLED_AMT | NUMBER | Detail payment forecast line unbilled amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Amount of detail payment forecast line that has been encumbered to date on the standard budget | ||
CC_DET_PF_ENCMBRNC_DATE | DATE | Date detail payment forecast line was last encumbered on the standard budget | ||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this line of the detail payment forecast was encumbered | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_DET_PF does not reference any database object
IGC.IGC_CC_DET_PF is referenced by following:
Description: | Detail payment forecast line versions |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_DET_PF_HISTORY.CC_DET_PF_LINE_ID | % |
IGC_CC_DET_PF_HISTORY stores information specific to a given version of a detail payment forecast line of the contract. A new version of a detail payment forecast line is created any time there is a significant change to the detail payment forecast, such as the amount. When this information changes, the entire row of the previous version of the IGC_CC_DET_PF row is inserted into IGC_CC_DET_PF_HISTORY and the version number of the contract in the IGC_CC_HEADERS table will increase. The insertion of this row occurs systematically.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_DET_PF_HISTORY_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_DET_PF_LINE_ID
CC_DET_PF_VERSION_NUM |
IGC_CC_DET_PF_HISTORY_N1 | NONUNIQUE | APPS_TS_ARCHIVE | CC_ACCT_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
CC_DET_PF_LINE_NUM | NUMBER | Y | Detail payment forecast line number | |
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
PARENT_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column for parent detail payment forecast line | ||
CC_DET_PF_VERSION_NUM | NUMBER | Y | Detail payment forecast line version number | |
CC_DET_PF_VERSION_ACTION | VARCHAR2 | (1) | Y | Detail payment forecast line version action |
CC_DET_PF_ENTERED_AMT | NUMBER | Detail payment forecast entered line amount | ||
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_DATE | DATE | Detail payment forecast line date | ||
CC_DET_PF_BILLED_AMT | NUMBER | Detail payment forecast line billed amount | ||
CC_DET_PF_UNBILLED_AMT | NUMBER | Detail payment forecast line unbilled amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Amount of detail payment forecast line that has been encumbered to date on the standard budget | ||
CC_DET_PF_ENCMBRNC_DATE | DATE | Date detail payment forecast line was last encumbered on the standard budget | ||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this line of the detail payment forecast was encumbered | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_DET_PF_HISTORY does not reference any database object
IGC.IGC_CC_DET_PF_HISTORY is referenced by following:
Description: | Open interface table for IGC_CC_DET_PF_INTERFACE |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_DET_PF_INTERFACE.INTERFACE_ACCT_LINE_ID | IGC_CC_ACCT_LINES |
IGC_CC_DET_PF_INTERFACE.INTERFACE_DET_PF_LINE_ID | PO_DISTRIBUTIONS_ALL |
IGC_CC_DET_PF_INTERFACE.INTERFACE_PAR_DET_PF_LINE_ID | IGC_CC_DET_PF_INTERFACE |
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_DET_PF_INTERFACE.INTERFACE_PAR_DET_PF_LINE_ID | IGC_CC_DET_PF_INTERFACE |
IGC_CC_DET_PF_INTERFACE temporarily stores detail payment forecast 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_DET_PF table.
Scope: public
Product: IGI
Lifecycle: active
Display Name: Contract Commitment Payment Forecast Interface
Category: BUSINESS_ENTITY IGC_CONTRACT_COMMITMENT
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_DET_PF_INTERFACE_U1 | UNIQUE | APPS_TS_INTERFACE | INTERFACE_DET_PF_LINE_ID |
IGC_CC_DET_PF_INTERFACE_U2 | UNIQUE | APPS_TS_INTERFACE |
INTERFACE_ACCT_LINE_ID
CC_DET_PF_LINE_NUM |
IGC_CC_DET_PF_INTERFACE_N1 | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_ACCT_LINE_ID |
IGC_CC_DET_PF_INTERFACE_N2 | NONUNIQUE | APPS_TS_INTERFACE | INTERFACE_PAR_DET_PF_LINE_ID |
IGC_CC_DET_PF_INTERFACE_N3 | NONUNIQUE | APPS_TS_INTERFACE | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
INTERFACE_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
CC_DET_PF_LINE_NUM | NUMBER | Y | Detail payment forecast line number | |
INTERFACE_PARENT_ACCT_LINE_ID | NUMBER | Account line defining column for parent account line | ||
INTERFACE_PAR_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column for parent detail payment forecast line | ||
CC_DET_PF_ENTERED_AMT | NUMBER | Detail payment forecast entered line amount | ||
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_DATE | DATE | Y | Detail payment forecast line date | |
CC_DET_PF_BILLED_AMT | NUMBER | Detail payment forecast line billed amount | ||
CC_DET_PF_UNBILLED_AMT | NUMBER | Detail payment forecast line unbilled amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Amount of the detail payment forecast line that has been encumbered to date on the standard budget | ||
CC_DET_PF_ENCMBRNC_DATE | DATE | Date detail payment forecast line was last encumbered on the standard budget | ||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | Encumbrance status, as of the last time this line of the detail payment forecast was encumbered | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
BATCH_ID | NUMBER | Y | Interface batch defining column | |
PROCESS_STATUS | VARCHAR2 | (1) | Not currently used |
IGC.IGC_CC_DET_PF_INTERFACE does not reference any database object
IGC.IGC_CC_DET_PF_INTERFACE is referenced by following:
Description: | Encumbrance type enable for contract states |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_ENCMBRNC_CTRLS.CC_CONF_ENCMBRNC_TYPE_ID | GL_ENCUMBRANCE_TYPES |
IGC_CC_ENCMBRNC_CTRLS.CC_PROV_ENCMBRNC_TYPE_ID | GL_ENCUMBRANCE_TYPES |
IGC_CC_ENCMBRNC_CTRLS stores information used to assign encumbrance types to the individual states of the contract commitment.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_ENCMBRNC_CTRLS_A_N1 | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_BUDGET_TYPE | VARCHAR2 | (2) | Y | Budget type. Values are Standard or Commitment. |
CC_PROV_ENCMBRNC_TYPE_ID | NUMBER | (15) | Encumbrance type defining column for provisional contracts | |
CC_CONF_ENCMBRNC_TYPE_ID | NUMBER | (15) | Encumbrance type defining column for confirmed contracts | |
CC_PROV_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | Flag to enable encumbrance type for provisional contracts | |
CC_CONF_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | Flag to enable encumbrance type for confirmed contracts | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
SET_OF_BOOKS_ID | NUMBER | (15) | Set of Books Id |
IGC.IGC_CC_ENCMBRNC_CTRLS does not reference any database object
IGC.IGC_CC_ENCMBRNC_CTRLS is referenced by following:
Description: | Groups defining common users |
---|
IGC_CC_GROUPS stores information specific to approval groups. The groups can be created to represent a group of users who have a level of approval authority in common. There is an optional one to many relationship between GL_SET_OF_BOOKS and this table. For each Set of Books, there can be several lines in the IGC_CC_GROUPS table with the same SET_OF_BOOKS_ID, but different values for the CC_GROUP_ID.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_GROUPS_U2 | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
CC_GROUP_NAME |
IGC_CC_GROUP_U1 | UNIQUE | APPS_TS_TX_IDX | CC_GROUP_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_GROUP_ID | NUMBER | Y | Access group defining column | |
SET_OF_BOOKS_ID | NUMBER | Y | Accounting books defining column | |
CC_GROUP_NAME | VARCHAR2 | (30) | Y | Access group name |
CC_GROUP_DESC | VARCHAR2 | (150) | Access group description | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_GROUPS does not reference any database object
IGC.IGC_CC_GROUPS is referenced by following:
Description: | Group assignments to users |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_GROUP_USERS.USER_ID | FND_USER |
IGC_CC_GROUP_USERS.CC_GROUP_ID | % |
IGC_CC_GROUP_USERS stores information required to assign individual users to specific approval groups. There is an optional one to many relationship between IGC_CC_GROUPS and this table. For each group, there can be several lines in the IGC_CC_GROUP USERS table with the same CC_GROUP_ID, but different values for the USER_ID.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_GROUP_USER_U1 | UNIQUE | APPS_TS_TX_IDX |
CC_GROUP_ID
USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_GROUP_ID | NUMBER | Y | Access group defining column | |
USER_ID | NUMBER | (15) | Y | User defining column |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
IGC.IGC_CC_GROUP_USERS does not reference any database object
IGC.IGC_CC_GROUP_USERS is referenced by following:
Description: | Interface table for passing transactions to the commitment budgetary control submodule for funds checking and reservation |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_INTERFACE.CC_DET_PF_LINE_ID | % |
IGC_CC_INTERFACE.CC_ACCT_LINE_ID | % |
IGC_CC_INTERFACE.CC_HEADER_ID | % |
IGC_CC_INTERFACE stores information from the Contract Commitment system that is to be passed to the Commitment Budgetary Control submodule for funds checking and funds reservation. Both a funds check and a funds reservation request can be initiated from Contract Commitment. When the tasks are initiated, the system inserts the rows into this table, which acts as an interface to the submodule. The funds check and reservation may occur in the General Ledger standard budget and commitment budget, depending on whether budgetary control has been inabled in those systems. This table temporarily stores all of the information required to accomplish the tasks in the submodules.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_INTERFACE_U1 | UNIQUE | APPS_TS_INTERFACE |
CC_HEADER_ID
DOCUMENT_TYPE ACTUAL_FLAG BATCH_LINE_NUM |
IGC_CC_INTERFACE_N1 | NONUNIQUE | APPS_TS_INTERFACE |
CC_HEADER_ID
ACTUAL_FLAG |
IGC_CC_INTERFACE_N2 | NONUNIQUE | APPS_TS_INTERFACE | CC_ACCT_LINE_ID |
IGC_CC_INTERFACE_N3 | NONUNIQUE | APPS_TS_INTERFACE | CC_DET_PF_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Document identifier defining column | |
CC_VERSION_NUM | NUMBER | Contract commitment version number | ||
CC_ACCT_LINE_ID | NUMBER | Account line defining column | ||
CC_DET_PF_LINE_ID | NUMBER | Detail payment forecast line defining column | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | Key Flexfield combination defining column |
BATCH_LINE_NUM | NUMBER | Y | Line number of batch | |
CC_TRANSACTION_DATE | DATE | Y | Accounting date of contract | |
CC_FUNC_DR_AMT | NUMBER | Transactional debit amount | ||
CC_FUNC_CR_AMT | NUMBER | Transactional credit amount | ||
JE_SOURCE_NAME | VARCHAR2 | (25) | Journal entry source | |
JE_CATEGORY_NAME | VARCHAR2 | (25) | Journal entry category | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
PERIOD_NAME | VARCHAR2 | (15) | Accounting period | |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | Balance type. Values are Actual, Budget, or Encumbrance. |
BUDGET_DEST_FLAG | VARCHAR2 | (1) | Y | Flag to indicate whether the line is for commitment or standard budget |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Accounting books defining column |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type defining column | |
CBC_RESULT_CODE | VARCHAR2 | (3) | Result code for transaction line | |
STATUS_CODE | VARCHAR2 | (2) | Status code for batch | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
BUDGET_AMT | NUMBER | Budget amount for this account and period | ||
COMMITMENT_ENCMBRNC_AMT | NUMBER | Encumbrance amount of commitment type for this account and period | ||
OBLIGATION_ENCMBRNC_AMT | NUMBER | Encumbrance amount of obligation type for this account and period | ||
CC_ENCMBRNC_DATE | DATE | Date on which this transaction is encumbered | ||
FUNDS_AVAILABLE_AMT | NUMBER | Funds available for this account and period | ||
CURRENCY_CODE | VARCHAR2 | (15) | Y | Currency code for functional currency for this transaction |
DOCUMENT_TYPE | VARCHAR2 | (25) | Y | Category for this document type |
TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | Description for this transaction | |
PA_FLAG | VARCHAR2 | (1) | Flag to indicate whethere there are any associated Projects | |
RESULT_CODE_SOURCE | VARCHAR2 | (1) | Result Code Source | |
BATCH_ID | NUMBER | (20) | Batch Identifier | |
REFERENCE_1 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_2 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_3 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_4 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_5 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_7 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_8 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_9 | VARCHAR2 | (240) | Journal entry line reference column | |
REFERENCE_10 | VARCHAR2 | (240) | Journal entry line reference column | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
EVENT_ID | NUMBER | SLA Event ID | ||
PROJECT_LINE | VARCHAR2 | (1) | Flag to indicate whether row is created by PA. | |
PA_BURDEN_FLAG | VARCHAR2 | (1) | Flag to indicate whether row is PA Burden line |
IGC.IGC_CC_INTERFACE does not reference any database object
IGC.IGC_CC_INTERFACE is referenced by following:
Description: | Multiple reporting currency table for account lines |
---|
IGC_CC_MC_ACCT_LINES stores reporting currency information for each account line in the IGC_CC_ACCT_LINE table. There is an optional one to many relationship between IGC_CC_ACCT_LINES and this table. For each account line, there can be several lines in the IGC_CC_MC_ACCT_LINE table with the same CC_ACCT_LINE_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_ACCT_LINES table corresponds with the number of Reporting Sets of Books that have been defined.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_ACCT_LINES_U1 | UNIQUE | APPS_TS_TX_IDX |
CC_ACCT_LINE_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount to be converted | ||
CC_ACCT_ENCMBRNC_AMT | NUMBER | Account line encumbrance amount to be converted | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency |
IGC.IGC_CC_MC_ACCT_LINES does not reference any database object
IGC.IGC_CC_MC_ACCT_LINES is referenced by following:
Description: | Multiple reporting currency versions for account lines |
---|
IGC_CC_MC_ACCT_LINE_HISTORY stores information specific to Multiple Reporting Currency versions for account lines.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_ACCT_LINE_HISTORY_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_ACCT_LINE_ID
SET_OF_BOOKS_ID CC_ACCT_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | Account line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_ACCT_FUNC_AMT | NUMBER | Account line functional amount to be converted | ||
CC_ACCT_ENCMBRNC_AMT | NUMBER | Account line encumbrance amount to be converted | ||
CC_ACCT_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_ACCT_VERSION_ACTION | VARCHAR2 | (1) | Y | Contract commitment version action |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies | ||
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in the Functional Currency |
IGC.IGC_CC_MC_ACCT_LINE_HISTORY does not reference any database object
IGC.IGC_CC_MC_ACCT_LINE_HISTORY is referenced by following:
Description: | Multiple reporting currency table for detail payment forecast lines |
---|
IGC_CC_MC_DET_PF stores reporting currency information for each account line in the IGC_CC_DET_PF table. There is an optional one to many relationship between IGC_CC_DET_PF and this table. For each detail payment forecast line, there can be several lines in the IGC_CC_MC_DET_PF table with the same CC_DET_PF_LINE_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_DET_PF table corresponds with the number of Reporting Sets of Books that have been defined.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_DET_PF_U1 | UNIQUE | APPS_TS_TX_IDX |
CC_DET_PF_LINE_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional amount to be converted | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Detail payment forecast encumbrance amount to be converted | ||
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_MC_DET_PF does not reference any database object
IGC.IGC_CC_MC_DET_PF is referenced by following:
Description: | Multiple reporting currency versions for detail payment forecast lines |
---|
IGC_CC_MC_DET_PF_HISTORY stores information specific to Multiple Reporting Currency versions for detail payment forecast lines.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_DET_PF_HISTORY_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_DET_PF_LINE_ID
SET_OF_BOOKS_ID CC_DET_PF_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | Y | Detail payment forecast line defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_DET_PF_FUNC_AMT | NUMBER | Detail payment forecast functional amount to be converted | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | Detail payment forecast encumbrance amount to be converted | ||
CC_DET_PF_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_DET_PF_VERSION_ACTION | VARCHAR2 | (1) | Y | Contract commitment version action |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_MC_DET_PF_HISTORY does not reference any database object
IGC.IGC_CC_MC_DET_PF_HISTORY is referenced by following:
Description: | Multiple reporting currency table for contracts |
---|
IGC_CC_MC_HEADERS stores reporting currency information for each contract in the IGC_CC_HEADERS table. There is an optional one to many relationship between IGC_CC_HEADERS and this table. For each contract, there can be several lines in the IGC_CC_MC_HEADERS table with the same CC_HEADER_ID, but different values for the REPORTING_SET_OF_BOOKS_ID. The number of lines stored in the IGC_CC_MC_HEADERS table corresponds with the number of Reporting Sets of Books that have been defined.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_HEADERS_U1 | UNIQUE | APPS_TS_TX_IDX |
CC_HEADER_ID
SET_OF_BOOKS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_MC_HEADERS does not reference any database object
IGC.IGC_CC_MC_HEADERS is referenced by following:
Description: | Multiple reporting currency versions for contracts |
---|
IGC_CC_MC_HEADER_HISTORY stores information specific to Multiple Reporting Currency versions for contracts.
Index | Type | Tablespace | Column |
---|---|---|---|
IGC_CC_MC_HEADER_HISTORY_U1 | UNIQUE | APPS_TS_ARCHIVE |
CC_HEADER_ID
SET_OF_BOOKS_ID CC_VERSION_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | Contract commitment defining column | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | Reporting Set of Books defining column |
CC_VERSION_NUM | NUMBER | Y | Contract commitment version number | |
CC_VERSION_ACTION | VARCHAR2 | (1) | Y | Contract commitment version action |
CONVERSION_TYPE | VARCHAR2 | (30) | Conversion type used for converting between currencies | |
CONVERSION_DATE | DATE | Conversion date used for converting the currencies | ||
CONVERSION_RATE | NUMBER | Conversion rate used for converting the currencies |
IGC.IGC_CC_MC_HEADER_HISTORY does not reference any database object
IGC.IGC_CC_MC_HEADER_HISTORY is referenced by following:
Description: | Numbering methods for contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_NUMBER_METHODS.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
IGC_CC_NUMBER_METHODS stores information for determining the data type and numbering method used for contracts. For each organization, the data type and numbering method can be defined.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_NUM_METHOD | VARCHAR2 | (1) | Numbering method used for contract numbers | |
CC_NUM_DATATYPE | VARCHAR2 | (1) | Data type used for numbering method | |
CC_NEXT_NUM | NUMBER | (20) | Next sequential number for contracts using the automatic numbering method | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CC_PREFIX | VARCHAR2 | (5) | Prefix for the Contract Commitment number if Automatic Numbering is used |
IGC.IGC_CC_NUMBER_METHODS does not reference any database object
IGC.IGC_CC_NUMBER_METHODS is referenced by following:
Description: | System parameters for contracts |
---|
Foreign Key Column | Foreign Table |
---|---|
IGC_CC_SYSTEM_PARAMETERS.ORG_ID | HR_ALL_ORGANIZATION_UNITS |
IGC_CC_SYSTEM_PARAMETERS stores information about Contract Commitment specific system parameters.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Y | Organization identifier |
DEFAULT_RATE_TYPE | VARCHAR2 | (25) | Default currency rate type for contracts | |
ENFORCE_VENDOR_HOLD_FLAG | VARCHAR2 | (1) | Indicator to enforce supplier holds during contract commitment approval | |
TAX_FROM_VENDOR_FLAG | VARCHAR2 | (1) | Default tax code from the supplier | |
TAX_FROM_VENDOR_SITE_FLAG | VARCHAR2 | (1) | Default tax code from the supplier site | |
TAX_FROM_SYSTEM_FLAG | VARCHAR2 | (1) | Default tax code from Financial Options window | |
TAX_HIER_VENDOR | NUMBER | (15) | Supplier position in tax code defaulting hierarchy | |
TAX_HIER_VENDOR_SITE | NUMBER | (15) | Supplier site position in tax code defaulting hierarchy | |
TAX_HIER_SYSTEM | NUMBER | (15) | Financial options in tax code defaulting hierarchy | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
IGC.IGC_CC_SYSTEM_PARAMETERS does not reference any database object
IGC.IGC_CC_SYSTEM_PARAMETERS is referenced by following:
A Business Intelligence System view
IGCBV_CBC_BALANCES display balances that are the cumulative results of financial operations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | |||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER |
APPS.IGCBV_CBC_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_BUDGET_BALANCES display budget balances that are estimated results of future financial operations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | |||
BUDGET_VERSION_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Y |
APPS.IGCBV_CBC_BUDGET_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_ENCUMBRANCE_BALANCES display encumbrance balances that are provisional contract expenditures. Encumbrance balances are only in functional currency.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | Key flexfield structure defining column | |
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | |||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y |
APPS.IGCBV_CBC_ENCUMBRANCE_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_JOURNAL_BATCHES display commitment budgetary control journal batches which are groups of related journal entries which share the same general ledger period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NAME | VARCHAR2 | (100) | Y | |
_LA:BATCH_STATUS | CHAR | (52) | ||
_LA:BALANCE_TYPE | CHAR | (49) | ||
_LA:APPROVAL_STATUS | CHAR | (70) | ||
_LA:FUNDS_CHECK_STATUS | CHAR | (68) | ||
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
EFFECTIVE_DATE | DATE | Y | ||
DESCRIPTION | VARCHAR2 | (240) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | |||
BATCH_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CBC_JOURNAL_BATCHES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_JOURNAL_LINES display the commitment budgetary control journal lines which are groups of related journal lines that record debit and credit amounts to commitment budgetary control accounts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_LINE_NUMBER | NUMBER | (15) | Y | |
JOURNAL_SOURCE | VARCHAR2 | (25) | Y | |
JOURNAL_CATEGORY | VARCHAR2 | (25) | Y | |
_LA:BALANCE_TYPE | CHAR | (60) | ||
EFFECTIVE_DATE | DATE | Y | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
POSTED_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
REFERENCE_1 | VARCHAR2 | (240) | ||
REFERENCE_2 | VARCHAR2 | (240) | ||
REFERENCE_3 | VARCHAR2 | (240) | ||
REFERENCE_4 | VARCHAR2 | (240) | ||
REFERENCE_5 | VARCHAR2 | (240) | ||
REFERENCE_6 | VARCHAR2 | (240) | ||
REFERENCE_7 | VARCHAR2 | (240) | ||
REFERENCE_8 | VARCHAR2 | (240) | ||
REFERENCE_9 | VARCHAR2 | (240) | ||
REFERENCE_10 | VARCHAR2 | (240) | ||
BATCH_NAME | VARCHAR2 | (100) | Y | |
BUDGET_TYPE | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
BUDGET_VERSION_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
BATCH_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CBC_JOURNAL_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_MC_JOURNAL_BATCHES store multiple reporting currency information for each Commitment Budgetary Control journal entry batch.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
BATCH_NAME | VARCHAR2 | (100) | Y | |
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CONTRACT_COMMITMENT_ID | NUMBER | |||
BATCH_ID | NUMBER | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_CBC_MC_JOURNAL_BATCHES is not referenced by any database object
A Business Intelligence System view
IGCBV_CBC_MC_JOURNAL_LINES store multiple reporting currency information for each Commitment Budgetary Control journal entry line in Oracle Contract Commitments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
BATCH_NAME | VARCHAR2 | (100) | Y | |
JOURNAL_LINE_NUMBER | NUMBER | (15) | Y | |
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
BATCH_ID | NUMBER | (15) | Y |
APPS.IGCBV_CBC_MC_JOURNAL_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_ACCOUNT_LINES display the accounting distribution of the contract commitment. If this account line belongs to a parent contract commitment and commitment budgetary control is enabled, the amounts are encumbered against the commitment budget of the parent contract commitment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCOUNT_ENTERED_AMOUNT | NUMBER | |||
ACCOUNT_FUNCTIONAL_AMOUNT | NUMBER | |||
ACCOUNT_BILLED_AMOUNT | NUMBER | |||
ACCOUNT_UNBILLED_AMOUNT | NUMBER | |||
ACCOUNT_ENCUMBRANCE_AMOUNT | NUMBER | |||
ACCOUNT_ENCUMBRANCE_DATE | DATE | |||
_LA:ACCOUNT_TAXABLE_FLAG | CHAR | (51) | ||
_LA:ACCT_ENCUMBRANCE_STATUS | CHAR | (73) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | ||
BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
TAX_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORG_ID | NUMBER | |||
ACCOUNT_LINE_ID | NUMBER | Y | ||
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_ACTION_HISTORIES display the series of actions that are initiated against the contract commitment. Actions are created by events that occur in both Contract Commitment system and Workflow subsystem.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_NUMBER | NUMBER | Y | ||
_LA:ACTION_TYPE | CHAR | (57) | ||
_LA:ACTION_STATE | CHAR | (52) | ||
_LA:ACTION_CONTROL_STATUS | CHAR | (67) | ||
_LA:ACTION_APPROVAL_STATUS | CHAR | (70) | ||
ACTION_NOTES | VARCHAR2 | (240) | ||
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_ACTION_HISTORIES is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_CONTRACT_COMMITMENTS displays general information about the financial representation of a contract. A contract commitment can stand alone such as an individual contract commitment, it can be related to another contract commitment such as a cover contract commitment, or it can be consumed by one or more release contract commitments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
_LA:APPROVAL_STATUS | CHAR | (63) | ||
_LA:CONTROL_STATUS | CHAR | (60) | ||
_LA:ENCUMBRANCE_STATUS | CHAR | (68) | ||
_LA:STATE | CHAR | (45) | ||
_LA:TYPE | CHAR | (43) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
END_EFFECTIVE_DATE | DATE | |||
START_EFFECTIVE_DATE | DATE | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
TERM_ID | NUMBER | (15) | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
LOCATION_ID | NUMBER | (15) | ||
OWNER_USER_ID | NUMBER | (15) | Y | |
PREPARER_USER_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
APPS.IGCBV_CC_CONTRACT_COMMITMENTS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_DETAIL_PAY_FORECASTS display a break out of the contract commitment summary payment forecast into the amounts that are expected to be paid out. Payment forecast is shown at any detail level desired as determined by the payment forecast date which is determined by the general ledger period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
DETAIL_PF_DATE | DATE | Y | ||
DETAIL_PF_ENTERED_AMOUNT | NUMBER | |||
DETAIL_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
DETAIL_PF_BILLED_AMOUNT | NUMBER | |||
DETAIL_PF_UNBILLED_AMOUNT | NUMBER | |||
DETAIL_PF_ENCUMBER_AMOUNT | NUMBER | |||
_LA:DETAIL_PF_ENCUMBR_STATUS | CHAR | (75) | ||
DETAIL_PF_LAST_ENCUMBER_DATE | DATE | |||
ACCOUNT_LINE_ID | NUMBER | Y | ||
DETAIL_PF_LINE_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_DETAIL_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_ENCUMBRANCE_CONTROLS display the association between the operating unit, budget type, contract commitment state and general ledger encumbrance type. This determines the type of encumbrances that can occur for the combination of the listed types, and whether or not the given combination is enabled.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:PROV_ENCMBR_ENABLED_FLAG | CHAR | (59) | ||
_LA:CONF_ENCMBR_ENABLED_FLAG | CHAR | (59) | ||
PROVISIONAL_ENCMBRANCE_TYPE_ID | NUMBER | (15) | ||
CONFIRMED_ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
BUDGET_TYPE | VARCHAR2 | (2) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_ENCUMBRANCE_CONTROLS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_TYPES display the category of contract commitment types that determine that nature of the contract and how the contract will be processed. The contract commitment types are seeded with the application and are specific to the operating unit.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:NUMBERING_METHOD | CHAR | (58) | ||
_LA:NUMBER_DATATYPE | CHAR | (62) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATED_BY | NUMBER | Y |
APPS.IGCBV_CC_NUMBER_METHODS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_PERIODS display the contract commitment period that corresponds to a general ledger period. This period may be opened and closed at times other than the general ledger periods.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:PERIOD_STATUS | CHAR | (61) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_PERIODS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_RELEASES display a contract within a contract such as a release contract commitment within a cover contract commitment, in which the anticipated expenditures amounts must fall within the parent contract commitment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_VERSION_NUMBER | NUMBER | Y | ||
_LA:RELEASE_CONTROL_STATUS | CHAR | (60) | ||
_LA:RELEASE_APPROVAL_STATUS | CHAR | (63) | ||
_LA:TYPE | CHAR | (43) | ||
_LA:STATE | CHAR | (45) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
START_EFFECTIVE_DATE | DATE | |||
END_EFFECTIVE_DATE | DATE | |||
ORGANIZATION_ID | NUMBER | (15) | Y | |
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
TERM_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
PREPARER_USER_ID | NUMBER | (15) | Y | |
OWNER_USER_ID | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. |
APPS.IGCBV_CC_RELEASES is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_RELEASE_ACCOUNT_LINES display the accounting distribution for the contract commitment release.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
RELEASE_ACCOUNT_ENTERED_AMOUNT | NUMBER | |||
RELEASE_ACCT_FUNCTIONAL_AMOUNT | NUMBER | |||
RELEASE_ACCOUNT_BILLED_AMOUNT | NUMBER | |||
RELEASE_ACCT_UNBILLED_AMOUNT | NUMBER | |||
_LA:ACCOUNT_TAXABLE_FLAG | CHAR | (51) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORG_ID | NUMBER | |||
CHARGE_CODE_COMBINATION | NUMBER | (15) | ||
BUDGET_CODE_COMBINATION | NUMBER | (15) | ||
TAX_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_RELEASE_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_REL_DET_PAY_FORECASTS display a break out of the contract commitment release summary payment forecast into the amounts that are expected to be paid out. Payment forecast is shown at any detail level desired as determined by the payment forecast date.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
RELEASE_DETAIL_PF_DATE | DATE | Y | ||
REL_DETAIL_PF_ENTERED_AMOUNT | NUMBER | |||
REL_DET_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_DETAIL_PF_BILLED_AMOUNT | NUMBER | |||
REL_DET_PF_UNBILLED_AMOUNT | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
PARENT_DETAIL_PF_LINE_ID | NUMBER | |||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
RELEASE_DETAIL_PF_LINE_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_REL_DET_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_SUMMARY_PAY_FORECASTS display a break out of the contract commitment account line into the amounts that are expected to be paid out. The payment forecast is at the summary level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REL_SUMMARY_PF_ENTERED_AMOUNT | NUMBER | |||
REL_SUM_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_BILLED_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_UNBILLED_AMOUNT | NUMBER | |||
RELEASE_SUM_PF_ENCUMBER_AMOUNT | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | (15) | Y | |
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y |
APPS.IGCBV_CC_REL_SUM_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_CC_ROUTING_CONTROLS display an association between contract commitment types and contract commitment states, in which routing controls may be established. Routing controls define the rules that determine how the contract commitment approvals can take place.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:APPROVAL_ALLOWED_FLAG | CHAR | (53) | ||
_LA:PREPARER_ENCM_ALLOW_FLAG | CHAR | (54) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
TYPE | VARCHAR2 | (1) | Y | Type of contract commitment |
STATE | VARCHAR2 | (2) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCBV_CC_ROUTING_CONTROLS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_SUMMARY_PAY_FORECASTS displays a break out of the contract commitment account line into the amounts that are expected to be paid out. The payment forecast is at the summary level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_PF_ENTERED_AMOUNT | NUMBER | |||
SUMMARY_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
SUMMARY_PF_BILLED_AMOUNT | NUMBER | |||
SUMMARY_PF_UNBILLED_AMOUNT | NUMBER | |||
SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y |
APPS.IGCBV_CC_SUMMARY_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_ACCOUNT_LINES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment account line based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCT_LINE_FUNCTIONAL_AMOUNT | NUMBER | |||
ACCT_LINE_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_CONTRACT_COMMITMENTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_CONTRACT_COMMITMENTS is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_DETAIL_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment detail payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
DETAIL_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
DETAIL_PF_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ACCOUNT_LINE_ID | NUMBER | Y | ||
DETAIL_PF_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_DETAIL_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_RELEASES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_VERSION_NUMBER | NUMBER | Y | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_RELEASES is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_RELEASE_ACCOUNT_LINES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release account line based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
RELEASE_ACCT_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_ACCT_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_RELEASE_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_REL_DET_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release detail payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
REL_DET_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_DET_PF_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
PARENT_DETAIL_PF_LINE_ID | NUMBER | |||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
RELEASE_DETAIL_PF_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_REL_DET_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_REL_SUM_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release summaryl payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REL_SUM_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_REL_SUM_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCBV_MC_SUMMARY_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment summary payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_PF_FUNTIONAL_AMOUNT | NUMBER | |||
SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCBV_MC_SUMMARY_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_BALANCES display balances that are the cumulative results of financial operations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | |||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER |
APPS.IGCFV_CBC_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_BUDGET_BALANCES display budget balances that are estimated results of future financial operations.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | |||
BUDGET_VERSION_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Y |
APPS.IGCFV_CBC_BUDGET_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_ENCUMBRANCE_BALANCES display encumbrance balances that are provisional contract expenditures. Encumbrance balances are only in functional currency.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
QUARTER_NUMBER | NUMBER | |||
PERIOD_NUMBER | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
PERIOD_TO_DATE_BALANCE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | |||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y |
APPS.IGCFV_CBC_ENCUMBRANCE_BALANCES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_JOURNAL_BATCHES display commitment budgetary control journal batches which are groups of related journal entries which share the same general ledger period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NAME | VARCHAR2 | (100) | Y | |
_LA:BATCH_STATUS | CHAR | (52) | ||
_LA:BALANCE_TYPE | CHAR | (49) | ||
_LA:APPROVAL_STATUS | CHAR | (70) | ||
_LA:FUNDS_CHECK_STATUS | CHAR | (68) | ||
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
EFFECTIVE_DATE | DATE | Y | ||
DESCRIPTION | VARCHAR2 | (240) | ||
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | |||
BATCH_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CBC_JOURNAL_BATCHES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_JOURNAL_LINES display the commitment budgetary control journal lines which are groups of related journal lines that record debit and credit amounts to commitment budgetary control accounts.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOURNAL_LINE_NUMBER | NUMBER | (15) | Y | |
JOURNAL_SOURCE | VARCHAR2 | (25) | Y | |
JOURNAL_CATEGORY | VARCHAR2 | (25) | Y | |
_LA:BALANCE_TYPE | CHAR | (60) | ||
EFFECTIVE_DATE | DATE | Y | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
POSTED_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
REFERENCE_1 | VARCHAR2 | (240) | ||
REFERENCE_2 | VARCHAR2 | (240) | ||
REFERENCE_3 | VARCHAR2 | (240) | ||
REFERENCE_4 | VARCHAR2 | (240) | ||
REFERENCE_5 | VARCHAR2 | (240) | ||
REFERENCE_6 | VARCHAR2 | (240) | ||
REFERENCE_7 | VARCHAR2 | (240) | ||
REFERENCE_8 | VARCHAR2 | (240) | ||
REFERENCE_9 | VARCHAR2 | (240) | ||
REFERENCE_10 | VARCHAR2 | (240) | ||
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
BUDGET_VERSION_NAME | VARCHAR2 | (15) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
BATCH_NAME | VARCHAR2 | (100) | Y | |
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
BUDGET_TYPE | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
BUDGET_VERSION_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
BATCH_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CBC_JOURNAL_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_MC_JOURNAL_BATCHES store multiple reporting currency information for each Commitment Budgetary Control journal entry batch.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
BATCH_NAME | VARCHAR2 | (100) | Y | |
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
CONTRACT_COMMITMENT_ID | NUMBER | |||
BATCH_ID | NUMBER | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_CBC_MC_JOURNAL_BATCHES is not referenced by any database object
A Business Intelligence System view
IGCFV_CBC_MC_JOURNAL_LINES store multiple reporting currency information for each Commitment Budgetary Control journal entry line in Oracle Contract Commitments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
BATCH_NAME | VARCHAR2 | (100) | Y | |
JOURNAL_LINE_NUMBER | NUMBER | (15) | Y | |
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
BATCH_ID | NUMBER | (15) | Y |
APPS.IGCFV_CBC_MC_JOURNAL_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_ACCOUNT_LINES display the accounting distribution of the contract commitment. If this account line belongs to a parent contract commitment and commitment budgetary control is enabled, the amounts are encumbered against the commitment budget of the parent contract commitment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCOUNT_ENTERED_AMOUNT | NUMBER | |||
ACCOUNT_FUNCTIONAL_AMOUNT | NUMBER | |||
ACCOUNT_BILLED_AMOUNT | NUMBER | |||
ACCOUNT_UNBILLED_AMOUNT | NUMBER | |||
ACCOUNT_ENCUMBRANCE_AMOUNT | NUMBER | |||
ACCOUNT_ENCUMBRANCE_DATE | DATE | |||
_LA:ACCOUNT_TAXABLE_FLAG | CHAR | (51) | ||
_LA:ACCT_ENCUMBRANCE_STATUS | CHAR | (73) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
_DF | CHAR | (32) | ||
TAX_NAME | VARCHAR2 | (15) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
TASK_NUMBER | VARCHAR2 | (25) | ||
TASK_NAME | VARCHAR2 | (20) | ||
PROJECT_ORG_USE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
CONTRACT_COMMIMTMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | ||
BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
TAX_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORG_ID | NUMBER | |||
ACCOUNT_LINE_ID | NUMBER | Y | ||
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_ACTION_HISTORIES display the series of actions that are initiated against the contract commitment. Actions are created by events that occur in both Contract Commitment system and Workflow subsystem.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION_NUMBER | NUMBER | Y | ||
_LA:ACTION_TYPE | CHAR | (57) | ||
_LA:ACTION_STATE | CHAR | (52) | ||
_LA:ACTION_CONTROL_STATUS | CHAR | (67) | ||
_LA:ACTION_APPROVAL_STATUS | CHAR | (70) | ||
ACTION_NOTES | VARCHAR2 | (240) | ||
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_ACTION_HISTORIES is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_CONTRACT_COMMITMENTS displays general information about the financial representation of a contract. A contract commitment can stand alone such as an individual contract commitment, it can be related to another contract commitment such as a cover contract commitment, or it can be consumed by one or more release contract commitments.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
_LA:APPROVAL_STATUS | CHAR | (63) | ||
_LA:CONTROL_STATUS | CHAR | (60) | ||
_LA:ENCUMBRANCE_STATUS | CHAR | (68) | ||
_LA:STATE | CHAR | (45) | ||
_LA:TYPE | CHAR | (43) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
END_EFFECTIVE_DATE | DATE | |||
START_EFFECTIVE_DATE | DATE | |||
_DF | CHAR | (30) | ||
USER_NAME | VARCHAR2 | (100) | ||
TERMS_NAME | VARCHAR2 | (50) | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
CONVERSION_USER_TYPES | VARCHAR2 | (30) | ||
LOCATION_CODE | VARCHAR2 | (60) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDORS_NUMBER | VARCHAR2 | (30) | ||
VENDOR_CONTACTS_LAST_NAME | VARCHAR2 | (15) | ||
VENDOR_CONTACTS_FIRST_NAME | VARCHAR2 | (15) | ||
VENDOR_SITES_CODE | VARCHAR2 | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
TERM_ID | NUMBER | (15) | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
VENDOR_CONTACT_ID | NUMBER | |||
LOCATION_ID | NUMBER | (15) | ||
OWNER_USER_ID | NUMBER | (15) | Y | |
PREPARER_USER_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
APPS.IGCFV_CC_CONTRACT_COMMITMENTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_DETAIL_PAY_FORECASTS display a break out of the contract commitment summary payment forecast into the amounts that are expected to be paid out. Payment forecast is shown at any detail level desired as determined by the payment forecast date which is determined by the general ledger period.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
DETAIL_PF_DATE | DATE | Y | ||
DETAIL_PF_ENTERED_AMOUNT | NUMBER | |||
DETAIL_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
DETAIL_PF_BILLED_AMOUNT | NUMBER | |||
DETAIL_PF_UNBILLED_AMOUNT | NUMBER | |||
DETAIL_PF_ENCUMBER_AMOUNT | NUMBER | |||
_LA:DETAIL_PF_ENCUMBR_STATUS | CHAR | (75) | ||
DETAIL_PF_LAST_ENCUMBER_DATE | DATE | |||
_DF | CHAR | (28) | ||
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y | ||
DETAIL_PF_LINE_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_DETAIL_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_ENCUMBRANCE_CONTROLS display the association between the operating unit, budget type, contract commitment state and general ledger encumbrance type. This determines the type of encumbrances that can occur for the combination of the listed types, and whether or not the given combination is enabled.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:PROV_ENCMBR_ENABLED_FLAG | CHAR | (59) | ||
_LA:CONF_ENCMBR_ENABLED_FLAG | CHAR | (59) | ||
ENCUMBRANCE_TYPE_NAME | VARCHAR2 | (30) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PROVISIONAL_ENCUMBRNCE_TYPE_ID | NUMBER | (15) | ||
CONFIRMED_ENCUMBRNCE_TYPE_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
BUDGET_TYPE | VARCHAR2 | (2) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_ENCUMBRANCE_CONTROLS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_TYPES display the category of contract commitment types that determine that nature of the contract and how the contract will be processed. The contract commitment types are seeded with the application and are specific to the operating unit.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:NUMBERING_METHOD | CHAR | (58) | ||
_LA:NUMBER_DATATYPE | CHAR | (62) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | ||
CREATION_DATE | DATE | Y | ||
LAST_UPDATED_BY | NUMBER | Y | ||
CREATED_BY | NUMBER | Y |
APPS.IGCFV_CC_NUMBER_METHODS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_PERIODS display the contract commitment period that corresponds to a general ledger period. This period may be opened and closed at times other than the general ledger periods.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:PERIOD_STATUS | CHAR | (61) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
PERIOD_SET_NAME | VARCHAR2 | (15) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_PERIODS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_RELEASES display a contract within a contract such as a release contract commitment within a cover contract commitment, in which the anticipated expenditures amounts must fall within the parent contract commitment.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_VERSION_NUMBER | NUMBER | Y | ||
_LA:RELEASE_APPROVAL_STATUS | CHAR | (71) | ||
_LA:RELEASE_CONTROL_STATUS | CHAR | (68) | ||
_LA:STATE | CHAR | (53) | ||
_LA:TYPE | CHAR | (51) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
START_EFFECTIVE_DATE | DATE | |||
END_EFFECTIVE_DATE | DATE | |||
_DF | CHAR | (30) | ||
USER_NAME | VARCHAR2 | (100) | ||
TERMS_NAME | VARCHAR2 | (50) | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
CONVERSION_USER_TYPES | VARCHAR2 | (30) | ||
LOCATION_CODE | VARCHAR2 | (60) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDORS_NUMBER | VARCHAR2 | (30) | ||
VENDOR_CONTACTS_LAST_NAME | VARCHAR2 | (15) | ||
VENDOR_CONTACTS_FIRST_NAME | VARCHAR2 | (15) | ||
VENDOR_SITES_CODE | VARCHAR2 | (15) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
TERM_ID | NUMBER | (15) | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | |||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
VENDOR_CONTACT_ID | NUMBER | |||
LOCATION_ID | NUMBER | (15) | ||
OWNER_USER_ID | NUMBER | (15) | Y | |
PREPARER_USER_ID | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. |
APPS.IGCFV_CC_RELEASES is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_RELEASE_ACCOUNT_LINES display the accounting distribution for the contract commitment release.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
RELEASE_ACCOUNT_ENTERED_AMOUNT | NUMBER | |||
RELEASE_ACCT_FUNCTIONAL_AMOUNT | NUMBER | |||
RELEASE_ACCOUNT_BILLED_AMOUNT | NUMBER | |||
RELEASE_ACCT_UNBILLED_AMOUNT | NUMBER | |||
_LA:ACCOUNT_TAXABLE_FLAG | CHAR | (58) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (240) | ||
_KF:GL_ACCOUNT | CHAR | (34) | ||
_DF | CHAR | (32) | ||
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
TAX_NAME | VARCHAR2 | (15) | ||
PROJECT_NAME | VARCHAR2 | (30) | ||
PROJECT_NUMBER | VARCHAR2 | (25) | ||
TASK_NUMBER | VARCHAR2 | (25) | ||
TASK_NAME | VARCHAR2 | (20) | ||
PROJECT_ORG_USE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_CATEGORY | VARCHAR2 | (30) | ||
CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | ||
BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
TAX_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORG_ID | NUMBER | |||
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_RELEASE_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_REL_DET_PAY_FORECASTS display a break out of the contract commitment release summary payment forecast into the amounts that are expected to be paid out. Payment forecast is shown at any detail level desired as determined by the payment forecast date.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
RELEASE_DETAIL_PF_DATE | DATE | Y | ||
REL_DETAIL_PF_ENTERED_AMOUNT | NUMBER | |||
REL_DET_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_DETAIL_PF_BILLED_AMOUNT | NUMBER | |||
REL_DET_PF_UNBILLED_AMOUNT | NUMBER | |||
_DF | CHAR | (28) | ||
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
PARENT_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
PARENT_DETAIL_PF_LINE_ID | NUMBER | |||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
RELEASE_DETAIL_PF_LINE_ID | NUMBER | Y | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_REL_DET_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_SUMMARY_PAY_FORECASTS display a break out of the contract commitment account line into the amounts that are expected to be paid out. The payment forecast is at the summary level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REL_SUMMARY_PF_ENTERED_AMOUNT | NUMBER | |||
REL_SUM_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_BILLED_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_UNBILLED_AMOUNT | NUMBER | |||
RELEASE_SUM_PF_ENCUMBER_AMOUNT | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y |
APPS.IGCFV_CC_REL_SUM_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_ROUTING_CONTROLS display an association between contract commitment types and contract commitment states, in which routing controls may be established. Routing controls define the rules that determine how the contract commitment approvals can take place.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
_LA:APPROVAL_ALLOWED_FLAG | CHAR | (53) | ||
_LA:PREPARER_ENCM_ALLOW_FLAG | CHAR | (54) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
TYPE | VARCHAR2 | (1) | Y | Type of contract commitment |
STATE | VARCHAR2 | (2) | Y | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGCFV_CC_ROUTING_CONTROLS is not referenced by any database object
A Business Intelligence System view
IGCFV_CC_SUMMARY_PAY_FORECASTS displays a break out of the contract commitment account line into the amounts that are expected to be paid out. The payment forecast is at the summary level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_PF_ENTERED_AMOUNT | NUMBER | |||
SUMMARY_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
SUMMARY_PF_BILLED_AMOUNT | NUMBER | |||
SUMMARY_PF_UNBILLED_AMOUNT | NUMBER | |||
SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y |
APPS.IGCFV_CC_SUMMARY_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_ACCOUNT_LINES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment account line based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCT_LINE_FUNCTIONAL_AMOUNT | NUMBER | |||
ACCT_LINE_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_CONTRACT_COMMITMENTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
CONTRACT_VERSION_NUMBER | NUMBER | Y | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
RATE_NAME | VARCHAR2 | (30) | ||
RATE_DESCRIPTION | VARCHAR2 | (240) | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_CONTRACT_COMMITMENTS is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_DETAIL_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment detail payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
DETAIL_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
DETAIL_PF_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
ACCOUNT_LINE_ID | NUMBER | Y | ||
DETAIL_PF_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_DETAIL_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_RELEASES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_VERSION_NUMBER | NUMBER | Y | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
RATE_NAME | VARCHAR2 | (30) | ||
RATE_DESCRIPTION | VARCHAR2 | (240) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
ORGANIZATION_ID | NUMBER | (15) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_RELEASES is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_RELEASE_ACCOUNT_LINES show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release account line based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
RELEASE_ACCT_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_ACCT_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_RELEASE_ACCOUNT_LINES is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_REL_DET_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release detail payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELEASE_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
REL_DET_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_DET_PF_ENCUMBRANCE_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
PARENT_DETAIL_PF_LINE_NUMBER | NUMBER | Y | ||
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
PARENT_DETAIL_PF_LINE_ID | NUMBER | |||
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
RELEASE_DETAIL_PF_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_REL_DET_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_REL_SUM_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment release summaryl payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REL_SUM_PF_FUNCTIONAL_AMOUNT | NUMBER | |||
REL_SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
RELEASE_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
RELEASE_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
PARENT_CONTRACT_NUMBER | VARCHAR2 | (20) | Y | |
PARENT_ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
PARENT_CONTRACT_COMMITMENT_ID | NUMBER | |||
PARENT_ACCOUNT_LINE_ID | NUMBER | |||
RELEASE_CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
RELEASE_ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_REL_SUM_PAY_FORECASTS is not referenced by any database object
A Business Intelligence System view
IGCFV_MC_SUMMARY_PAY_FORECASTS show multiple reporting currencies functionality, which allows an alternative currency to be specified for a contract commitment summary payment forecast based on the set of books.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUMMARY_PF_FUNTIONAL_AMOUNT | NUMBER | |||
SUMMARY_PF_ENCUMBER_AMOUNT | NUMBER | |||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
PERIOD_YEAR | NUMBER | (15) | Y | |
CONTRACT_COMMITMENT_NUMBER | VARCHAR2 | (20) | Y | |
ACCOUNT_LINE_NUMBER | NUMBER | Y | ||
SETS_OF_BOOKS_NAME | VARCHAR2 | (30) | Y | |
SETS_OF_BOOKS_SHORT_NAME | VARCHAR2 | (20) | Y | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Y | |
CONTRACT_COMMITMENT_ID | NUMBER | Y | ||
ORGANIZATION_ID | NUMBER | (15) | Y | |
ACCOUNT_LINE_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y |
APPS.IGCFV_MC_SUMMARY_PAY_FORECASTS is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
FUNCTIONAL_PERIOD_NET_DR | NUMBER | |||
FUNCTIONAL_PERIOD_NET_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
QUARTER_NUM | NUMBER | (15) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | ||
SHOW_ACTUAL_FLAG | VARCHAR2 | (240) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
TEMPLATE_ID | NUMBER | |||
TEMPLATE_NAME | VARCHAR2 | (50) | ||
QTD_BALANCE | NUMBER | |||
YTD_BALANCE | NUMBER | |||
PTD_BALANCE | NUMBER |
APPS.IGC_CBC_ALL_BAL_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CBC_AUDIT_TRAILS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CODE_COMBINATION_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | |||
BUDGET_AMOUNT | NUMBER | |||
COMM_AMOUNT | NUMBER | |||
ACT_AMOUNT | NUMBER | |||
OTH_AMOUNT | NUMBER | |||
TOT_AMOUNT | NUMBER | |||
FA_AMOUNT | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_NAME | VARCHAR2 | (20) | ||
TEMPLATE_ID | NUMBER | |||
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Y | |
ACCOUNT_TYPE | VARCHAR2 | (1) | Y | |
SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT21 | VARCHAR2 | (25) | ||
SEGMENT22 | VARCHAR2 | (25) | ||
SEGMENT23 | VARCHAR2 | (25) | ||
SEGMENT24 | VARCHAR2 | (25) | ||
SEGMENT25 | VARCHAR2 | (25) | ||
SEGMENT26 | VARCHAR2 | (25) | ||
SEGMENT27 | VARCHAR2 | (25) | ||
SEGMENT28 | VARCHAR2 | (25) | ||
SEGMENT29 | VARCHAR2 | (25) | ||
SEGMENT30 | VARCHAR2 | (25) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (150) | ||
SEGMENT_ATTRIBUTE1 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE2 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE3 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE4 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE5 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE6 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE7 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE8 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE9 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE10 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE11 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE12 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE13 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE14 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE15 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE16 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE17 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE18 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE19 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE20 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE21 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE22 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE23 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE24 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE25 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE26 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE27 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE28 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE29 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE30 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE31 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE32 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE33 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE34 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE35 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE36 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE37 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE38 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE39 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE40 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE41 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE42 | VARCHAR2 | (60) | ||
REFERENCE1 | VARCHAR2 | (1) | ||
REFERENCE2 | VARCHAR2 | (1) | ||
REFERENCE3 | VARCHAR2 | (25) | ||
REFERENCE4 | VARCHAR2 | (1) | ||
REFERENCE5 | VARCHAR2 | (1) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
APPS.IGC_CBC_BALANCES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | |||
BUDGET_AMOUNT | NUMBER | |||
COMM_AMOUNT | NUMBER | |||
ACT_AMOUNT | NUMBER | |||
OTH_AMOUNT | NUMBER | |||
TOT_AMOUNT | NUMBER | |||
FA_AMOUNT | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_NAME | VARCHAR2 | (20) | ||
TEMPLATE_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CBC_BA_RANGES_FCL_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CBC_BA_RANGES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
AMOUNT_TYPE | VARCHAR2 | (4) | ||
FUNCTIONAL_PERIOD_NET_DR | NUMBER | |||
FUNCTIONAL_PERIOD_NET_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
QUARTER_NUM | NUMBER | (15) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
SHOW_ACTUAL_FLAG | VARCHAR2 | (240) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
TEMPLATE_ID | NUMBER | (15) | ||
TEMPLATE_NAME | VARCHAR2 | (50) | ||
QTD_BALANCE | NUMBER | |||
YTD_BALANCE | NUMBER | |||
PTD_BALANCE | NUMBER |
APPS.IGC_CBC_DETAIL_BAL_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
BUDGET_VERSION_ID | NUMBER | |||
BUDGET_AMOUNT | NUMBER | |||
COMM_AMOUNT | NUMBER | |||
ACT_AMOUNT | NUMBER | |||
OTH_AMOUNT | NUMBER | |||
TOT_AMOUNT | NUMBER | |||
FA_AMOUNT | NUMBER | |||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_NAME | VARCHAR2 | (20) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | rowid | |
CC_HEADER_ID | NUMBER | Y | ||
CC_ACCT_LINE_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
BATCH_LINE_NUM | NUMBER | Y | ||
CC_TRANSACTION_DATE | DATE | Y | ||
CC_FUNC_DR_AMT | NUMBER | |||
CC_FUNC_CR_AMT | NUMBER | |||
TRANSACTION_AMOUNT | NUMBER | |||
JE_SOURCE_NAME | VARCHAR2 | (25) | ||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
BALANCE_TYPE | VARCHAR2 | (240) | ||
RESULT_CODE_SOURCE | VARCHAR2 | (1) | ||
BUDGET_DEST_FLAG | VARCHAR2 | (1) | Y | |
BUDGET_TYPE | VARCHAR2 | (80) | ||
AMOUNT_TYPE_CODE | VARCHAR2 | (240) | ||
AMOUNT_TYPE | VARCHAR2 | (80) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
CBC_RESULT_CODE | VARCHAR2 | (3) | ||
RESULT_CODE_MEANING | VARCHAR2 | (240) | ||
STATUS_CODE | VARCHAR2 | (2) | ||
STATUS_CODE_MEANING | VARCHAR2 | (80) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
BUDGET_AMT | NUMBER | |||
COMMITMENT_ENCMBRNC_AMT | NUMBER | |||
OBLIGATION_ENCMBRNC_AMT | NUMBER | |||
ENCUMBRED_AMOUNT | NUMBER | |||
FUNDS_AVAILABLE_AMT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
REFERENCE_6 | VARCHAR2 | (240) | ||
DOCUMENT_TYPE | VARCHAR2 | (25) | Y |
APPS.IGC_CBC_DR_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CBC_JE_BATCH_ID | NUMBER | (15) | Y | |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CC_HEADER_ID | NUMBER | |||
NAME | VARCHAR2 | (100) | Y | |
BATCH_STATUS | VARCHAR2 | (1) | ||
SHOW_BATCH_STATUS | CHAR | (6) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
SHOW_ACTUAL_FLAG | VARCHAR2 | (240) | ||
BUDGETARY_CONTROL_STATUS | VARCHAR2 | (1) | Y | |
SHOW_BC_STATUS | VARCHAR2 | (80) | Y | |
APPROVAL_STATUS_CODE | VARCHAR2 | (1) | Y | |
DESCRIPTION | VARCHAR2 | (240) | ||
EFFECTIVE_DATE | DATE | Y | ||
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
CONTEXT | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
START_DATE | DATE | Y | ||
END_DATE | DATE | Y | ||
PERIOD_YEAR | NUMBER | (15) | Y | |
PERIOD_NUM | NUMBER | (15) | Y | |
USER_JE_SOURCE_NAME | VARCHAR2 | (25) | Y | |
LEDGER_NAME | VARCHAR2 | (30) | Y |
APPS.IGC_CBC_JE_BATCHES_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | (15) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
QUARTER_NUM | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
STATUS | VARCHAR2 | (1) | ||
PTD_BALANCE | NUMBER | |||
QTD_BALANCE | NUMBER | |||
YTD_BALANCE | NUMBER |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_FLAG | VARCHAR2 | (1) | ||
SET_OF_BOOKS_ID | NUMBER | |||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BUDGET_VERSION_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
AMOUNT_TYPE | VARCHAR2 | (4) | ||
PERIOD_YEAR | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
QUARTER_NUM | NUMBER | |||
PERIOD_NUM | NUMBER | |||
STATUS | VARCHAR2 | (1) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
PTD_BALANCE | NUMBER | |||
PERIOD_SET_NAME | VARCHAR2 | (15) |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CBC_JE_BATCH_ID | NUMBER | (15) | Y | |
CBC_JE_LINE_NUM | NUMBER | (15) | Y | |
BATCH_NAME | VARCHAR2 | (100) | Y | |
BATCH_EFFECTIVE_DATE | DATE | Y | ||
BATCH_DESCRIPTION | VARCHAR2 | (240) | ||
RUNNING_TOTAL_DR | NUMBER | |||
RUNNING_TOTAL_CR | NUMBER | |||
JE_SOURCE | VARCHAR2 | (25) | Y | |
JE_CATEGORY | VARCHAR2 | (25) | Y | |
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
SHOW_ACTUAL_FLAG | VARCHAR2 | (240) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
DETAIL_SUMMARY_CODE | VARCHAR2 | (1) | Y | |
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
FUNDS_CHECK_LEVEL_CODE | VARCHAR2 | (1) | ||
AMOUNT_TYPE | VARCHAR2 | (4) | ||
EFFECTIVE_DATE | DATE | Y | ||
POSTED_DATE | DATE | |||
PERIOD_YEAR | NUMBER | (15) | ||
DR_CR_CODE | VARCHAR2 | (1) | ||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
DESCRIPTION | VARCHAR2 | (240) | ||
BUDGET_TYPE | VARCHAR2 | (15) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
QUARTER_NUM | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
STATUS | VARCHAR2 | (1) | Y | |
CONTEXT | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
REFERENCE_1 | VARCHAR2 | (240) | ||
REFERENCE_2 | VARCHAR2 | (240) | ||
REFERENCE_3 | VARCHAR2 | (240) | ||
REFERENCE_4 | VARCHAR2 | (240) | ||
REFERENCE_5 | VARCHAR2 | (240) | ||
REFERENCE_6 | VARCHAR2 | (240) | ||
REFERENCE_7 | VARCHAR2 | (240) | ||
REFERENCE_8 | VARCHAR2 | (240) | ||
REFERENCE_9 | VARCHAR2 | (240) | ||
REFERENCE_10 | VARCHAR2 | (240) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.IGC_CBC_JE_LINES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
FUNCTIONAL_PERIOD_NET_DR | NUMBER | |||
FUNCTIONAL_PERIOD_NET_CR | NUMBER | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PERIOD_YEAR | NUMBER | (15) | ||
PERIOD_NUM | NUMBER | (15) | ||
QUARTER_NUM | NUMBER | (15) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
SHOW_ACTUAL_FLAG | VARCHAR2 | (240) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
TEMPLATE_ID | NUMBER | (15) | Y | |
TEMPLATE_NAME | VARCHAR2 | (50) | ||
QTD_BALANCE | NUMBER | |||
YTD_BALANCE | NUMBER | |||
PTD_BALANCE | NUMBER |
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Y | |
DETAIL_POSTING_ALLOWED_FLAG | VARCHAR2 | (1) | Y | |
DETAIL_BUDGETING_ALLOWED_FLAG | VARCHAR2 | (1) | Y | |
ACCOUNT_TYPE | VARCHAR2 | (1) | Y | |
ENABLED_FLAG | VARCHAR2 | (1) | Y | |
SUMMARY_FLAG | VARCHAR2 | (1) | Y | |
SEGMENT1 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT2 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT3 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT4 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT5 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT6 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT7 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT8 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT9 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT10 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT11 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT12 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT13 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT14 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT15 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT16 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT17 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT18 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT19 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT20 | VARCHAR2 | (25) | Key flexfield segment | |
SEGMENT21 | VARCHAR2 | (25) | ||
SEGMENT22 | VARCHAR2 | (25) | ||
SEGMENT23 | VARCHAR2 | (25) | ||
SEGMENT24 | VARCHAR2 | (25) | ||
SEGMENT25 | VARCHAR2 | (25) | ||
SEGMENT26 | VARCHAR2 | (25) | ||
SEGMENT27 | VARCHAR2 | (25) | ||
SEGMENT28 | VARCHAR2 | (25) | ||
SEGMENT29 | VARCHAR2 | (25) | ||
SEGMENT30 | VARCHAR2 | (25) | ||
DESCRIPTION | VARCHAR2 | (240) | ||
TEMPLATE_ID | NUMBER | (15) | ||
ALLOCATION_CREATE_FLAG | VARCHAR2 | (1) | ||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTEXT | VARCHAR2 | (150) | ||
SEGMENT_ATTRIBUTE1 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE2 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE3 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE4 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE5 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE6 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE7 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE8 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE9 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE10 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE11 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE12 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE13 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE14 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE15 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE16 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE17 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE18 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE19 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE20 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE21 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE22 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE23 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE24 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE25 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE26 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE27 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE28 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE29 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE30 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE31 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE32 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE33 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE34 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE35 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE36 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE37 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE38 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE39 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE40 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE41 | VARCHAR2 | (60) | ||
SEGMENT_ATTRIBUTE42 | VARCHAR2 | (60) |
APPS.IGC_CBC_SUMMARY_COMBINATIONS_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CBC_SUMMARY_TEMPLATES_V is not referenced by any database object
Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CBC_SUMMARY_TEMPLATE_FCL_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_HEADER_ID | NUMBER | |||
CC_ACCESS_ID | NUMBER | |||
CC_ACCESS_LEVEL | VARCHAR2 | (1) | ||
CC_ACCESS_TYPE | VARCHAR2 | (10) | ||
CC_ACCESS_TYPE_NAME | VARCHAR2 | (80) | ||
CC_GROUP_ID | NUMBER | |||
CC_GROUP_NAME | VARCHAR2 | (30) | ||
USER_ID | NUMBER | Application user identifier | ||
USER_NAME | VARCHAR2 | (100) | Application username (what a user types in at the Oracle Applications sign-on screen) | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). |
APPS.IGC_CC_ACCESS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_HEADER_ID | NUMBER | Y | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_TYPE | VARCHAR2 | (80) | ||
CC_TYPE_CODE | VARCHAR2 | (1) | Y | |
CC_NUM | VARCHAR2 | (20) | Y | |
CC_ACCT_LINE_ID | NUMBER | Y | ||
CC_ACCT_LINE_NUM | NUMBER | Y | ||
CC_ACCT_DESC | VARCHAR2 | (240) | ||
PARENT_HEADER_ID | NUMBER | |||
PARENT_ACCT_LINE_ID | NUMBER | |||
PARENT_CC_ACCT_LINE_NUM | NUMBER | |||
CC_BUDGET_ACCT_DESC | VARCHAR2 | (240) | ||
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
CC_CHARGE_ACCT_DESC | VARCHAR2 | (240) | ||
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | ||
CC_ACCT_ENTERED_AMT | NUMBER | |||
CC_ACCT_FUNC_AMT | NUMBER | |||
CC_ACCT_BILLED_AMT | NUMBER | |||
CC_ACCT_FUNC_BILLED_AMT | NUMBER | |||
CC_ACCT_ENCMBRNC_AMT | NUMBER | |||
CC_ACCT_UNENCMBRD_AMT | NUMBER | |||
CC_ACCT_UNBILLED_AMT | NUMBER | |||
CC_ACCT_COMP_FUNC_AMT | NUMBER | Account line functional amount | ||
PROJECT_NUMBER | VARCHAR2 | (25) | The project number that uniquely identifies the project. The project number can be user-entered or system-generated as defined in the implementation options | |
PROJECT_ID | NUMBER | (15) | The system-generated number that uniquely identifies the project | |
TASK_NUMBER | VARCHAR2 | (25) | User-defined number that uniquely identifies the task within a project. It is recommended to number tasks based on the wbs since that is how tasks are ordered in some reports. However note: task numbers do not record the wbs structure | |
TASK_ID | NUMBER | (15) | The system-generated number that uniquely identifies the task | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | The expenditure for which the alias is created | |
EXPENDITURE_ORG_NAME | VARCHAR2 | (240) | Name of the organization. | |
EXPENDITURE_ORG_ID | NUMBER | Identifier of the Organization | ||
EXPENDITURE_ITEM_DATE | DATE | Project accounting expenditure item date | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | ||
TAX_NAME | VARCHAR2 | (50) | ||
TAX_ID | NUMBER | (15) | ||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | ||
CC_ACCT_ENCMBRNC_DATE | DATE | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CC_FUNC_WITHHELD_AMT | NUMBER | Withheld Amount in Functional Currency | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in Entered Currency | ||
CC_COMP_FUNC_WHLD_AMT | NUMBER | Computed Withheld Amount in functional Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | |||
CC_HEADER_ID | NUMBER | |||
PARENT_HEADER_ID | NUMBER | |||
PARENT_ACCT_LINE_ID | NUMBER | |||
CC_ACCT_LINE_NUM | NUMBER | |||
CC_CHARGE_CODE_COMBINATION_ID | NUMBER | (15) | ||
CC_BUDGET_CODE_COMBINATION_ID | NUMBER | (15) | ||
CC_ACCT_ENTERED_AMT | NUMBER | |||
CC_ACCT_FUNC_AMT | NUMBER | |||
CC_ACCT_DESC | VARCHAR2 | (240) | ||
CC_ACCT_TAXABLE_FLAG | VARCHAR2 | (1) | ||
TAX_ID | NUMBER | (15) | ||
CC_ACCT_ENCMBRNC_AMT | NUMBER | |||
CC_ACCT_ENCMBRNC_STATUS | VARCHAR2 | (1) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
EXPENDITURE_ORG_ID | NUMBER | |||
EXPENDITURE_ITEM_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_ACCT_ENCMBRNC_DATE | DATE | |||
CC_FUNC_WITHHELD_AMT | NUMBER | Functional Withheld Amount | ||
CC_ENT_WITHHELD_AMT | NUMBER | Withheld Amount in Entered Currency | ||
TAX_CLASSIF_CODE | VARCHAR2 | (50) |
APPS.IGC_CC_ACCT_LINE_VERSION_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_HEADER_ID | NUMBER | Y | ||
CC_ACTION_NUM | NUMBER | Y | ||
CC_ACTION_VERSION_NUM | NUMBER | |||
CC_ACTION_TYPE | VARCHAR2 | (2) | ||
CC_ACTION_TYPE_DESC | VARCHAR2 | (80) | ||
CC_ACTION_STATE | VARCHAR2 | (2) | ||
CC_ACTION_STATE_DESC | VARCHAR2 | (80) | ||
CC_ACTION_CTRL_STATUS | VARCHAR2 | (1) | ||
CC_ACTION_CTRL_STATUS_DESC | VARCHAR2 | (80) | ||
CC_ACTION_APPRVL_STATUS | VARCHAR2 | (2) | ||
CC_ACTION_APPRVL_STATUS_DESC | VARCHAR2 | (80) | ||
CC_ACTION_NOTES | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY_NAME | VARCHAR2 | (100) | Y |
APPS.IGC_CC_ACTIONS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
NAME | VARCHAR2 | (30) | Y | |
CC_BC_ENABLE_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CBC_PO_ENABLE | VARCHAR2 | (1) | Flag if 'Y' implies that Commitment Budget Control is enabled for Purchase Orders, if 'N' then disabled |
APPS.IGC_CC_BC_ENABLE_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HD_ID | NUMBER | |||
CC_NUM_VAL | VARCHAR2 | (20) | Y | |
CC_ACT_ID | NUMBER | Y | ||
CC_PF_ID | NUMBER | Y | ||
MAX_DT | DATE |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTROL_FUNCTION_ID | NUMBER | Y | ||
CC_TYPE | VARCHAR2 | (1) | Y | |
CC_TYPE_NAME | VARCHAR2 | (80) | Y | |
CC_STATE | VARCHAR2 | (2) | Y | |
CC_STATE_NAME | VARCHAR2 | (80) | Y | |
CONTROL_GROUP_ID | NUMBER | (15) | Y | |
CONTROL_GROUP_NAME | VARCHAR2 | (80) | Y | |
JOB_ID | NUMBER | (15) | ||
POSITION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | |||
ORG_ID | NUMBER | Organization identifier | ||
END_DATE | DATE | |||
START_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.IGC_CC_CONTROL_FUNCTIONS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_DET_PF_LINE_ID | NUMBER | Y | ||
CC_DET_PF_LINE_NUM | NUMBER | Y | ||
CC_ACCT_LINE_NUM | NUMBER | |||
CC_ACCT_LINE_ID | NUMBER | Y | ||
PARENT_DET_PF_LINE_NUM | NUMBER | |||
PARENT_DET_PF_LINE_ID | NUMBER | |||
PARENT_ACCT_LINE_ID | NUMBER | |||
CC_DET_PF_ENTERED_AMT | NUMBER | |||
CC_DET_PF_FUNC_AMT | NUMBER | |||
CC_DET_PF_DATE | DATE | Y | ||
CC_DET_PF_BILLED_AMT | NUMBER | |||
CC_DET_PF_FUNC_BILLED_AMT | NUMBER | |||
CC_DET_PF_UNBILLED_AMT | NUMBER | |||
CC_DET_PF_COMP_FUNC_AMT | NUMBER | Detail payment forecast functional line amount | ||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | |||
CC_DET_PF_UNENCMBRD_AMT | NUMBER | |||
CC_DET_PF_ENCMBRNC_DATE | DATE | |||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | ||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_DET_PF_LINE_ID | NUMBER | |||
CC_DET_PF_LINE_NUM | NUMBER | |||
CC_ACCT_LINE_ID | NUMBER | |||
PARENT_ACCT_LINE_ID | NUMBER | |||
PARENT_DET_PF_LINE_ID | NUMBER | |||
CC_DET_PF_ENTERED_AMT | NUMBER | |||
CC_DET_PF_FUNC_AMT | NUMBER | |||
CC_DET_PF_DATE | DATE | |||
CC_DET_PF_ENCMBRNC_AMT | NUMBER | |||
CC_DET_PF_ENCMBRNC_DATE | DATE | |||
CC_DET_PF_ENCMBRNC_STATUS | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_BUDGET_TYPE | VARCHAR2 | (2) | Y | |
CC_PROV_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
CC_PROV_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
CC_CONF_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
CC_CONF_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
CC_PROV_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | ||
CC_CONF_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | ||
AP_REQ_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_REQ_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
AP_PURCH_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_PURCH_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
AP_INV_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_INV_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
SET_OF_BOOKS_ID | NUMBER | (15) |
APPS.IGC_CC_ENCMBRNC_CTRLS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_BUDGET_TYPE | VARCHAR2 | (2) | Y | |
CC_PROV_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
CC_PROV_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
CC_CONF_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
CC_CONF_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
CC_PROV_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | ||
CC_CONF_ENCMBRNC_ENABLE_FLAG | VARCHAR2 | (1) | ||
AP_REQ_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_REQ_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
AP_PURCH_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_PURCH_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
AP_INV_ENCMBRNC_TYPE_ID | NUMBER | (15) | ||
AP_INV_ENCMBRNC_TYPE | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
SET_OF_BOOKS_ID | NUMBER | (15) |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_GROUP_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
CC_GROUP_NAME | VARCHAR2 | (30) | Y | |
CC_GROUP_DESC | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.IGC_CC_GROUPS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_GROUP_ID | NUMBER | Y | ||
USER_ID | NUMBER | (15) | Y | |
USER_NAME | VARCHAR2 | (100) | Y | Application username (what a user types in at the Oracle Applications sign-on screen) |
START_DATE | DATE | Y | The date the password becomes active | |
END_DATE | DATE | The date the password expires | ||
DESCRIPTION | VARCHAR2 | (240) | Description | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Y | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment |
APPS.IGC_CC_GROUP_USERS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HDR_ID | NUMBER | |||
MAX_ACTIVITY_DATE | DATE |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CC_HEADER_ID | NUMBER | Y | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_TYPE | VARCHAR2 | (80) | ||
CC_TYPE_CODE | VARCHAR2 | (1) | Y | |
CC_NUM | VARCHAR2 | (20) | Y | Contract commitment number |
CC_REF_NUM | VARCHAR2 | (240) | ||
CC_VERSION_NUM | NUMBER | Y | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CC_STATE | VARCHAR2 | (80) | ||
CC_STATE_CODE | VARCHAR2 | (2) | Y | |
CC_APPRVL_STATUS | VARCHAR2 | (80) | ||
CC_APPRVL_STATUS_CODE | VARCHAR2 | (2) | Y | |
CC_CTRL_STATUS | VARCHAR2 | (80) | ||
CC_CTRL_STATUS_CODE | VARCHAR2 | (1) | Y | |
VENDOR_NAME | VARCHAR2 | (240) | ||
VENDOR_NUMBER | VARCHAR2 | (30) | Supplier number | |
VENDOR_ID | NUMBER | |||
VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT | VARCHAR2 | (31) | ||
VENDOR_CONTACT_ID | NUMBER | |||
CC_PREPARER_USER_NAME | VARCHAR2 | (100) | ||
CC_PREPARER_USER_ID | NUMBER | (15) | Y | |
CC_PREPARER_EMP_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc preparer employee name | |
CC_PREPARER_EMP_ID | NUMBER | (15) | System generated person primary key from PER_PEOPLE_S for Cc Preparer Employee Id. | |
CC_OWNER_USER_NAME | VARCHAR2 | (100) | ||
CC_OWNER_USER_ID | NUMBER | (15) | Y | |
CC_OWNER_EMP_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc owner employee name. | |
CC_OWNER_EMP_ID | NUMBER | (15) | System generated person primary key from PER_PEOPLE_S for Cc Owner Employee Id. | |
TERM_NAME | VARCHAR2 | (50) | ||
TERM_ID | NUMBER | (15) | ||
BILL_TO_LOCATION | VARCHAR2 | (60) | ||
BILL_TO_LOCATION_ID | NUMBER | (15) | Bill-to location unique identifier | |
CC_DESC | VARCHAR2 | (240) | ||
CC_ACCT_DATE | DATE | |||
CC_START_DATE | DATE | |||
CC_END_DATE | DATE | |||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
CONVERSION_DATE | DATE | |||
CONVERSION_RATE | NUMBER | |||
PARENT_CC_HEADER_ID | NUMBER | |||
CC_ENCMBRNC_STATUS | VARCHAR2 | (80) | ||
CC_ENCMBRNC_STATUS_CODE | VARCHAR2 | (1) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
PARENT_CC_NUM | VARCHAR2 | (20) | Contract commitment number | |
HOLD_FLAG | VARCHAR2 | (1) | Indicator of whether the supplier is on purchasing hold | |
CC_CURRENT_USER_NAME | VARCHAR2 | (100) | Application username (what a user types in at the Oracle Applications sign-on screen) | |
CC_CURRENT_USER_ID | NUMBER | (15) | ||
ACCESS_LEVEL | VARCHAR2 | (1) | Application username (what a user types in at the Oracle Applications sign-on screen) | |
WF_ITEM_TYPE | VARCHAR2 | (8) | ||
WF_ITEM_KEY | VARCHAR2 | (240) | ||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CC_GUARANTEE_FLAG | VARCHAR2 | (1) | Indicates whether the contract commitment is a Guarantee Commitment. |
APPS.IGC_CC_HEADERS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | |||
ORG_ID | NUMBER | (15) | Organization identifier | |
CC_TYPE | VARCHAR2 | (1) | ||
CC_NUM | VARCHAR2 | (20) | ||
CC_REF_NUM | VARCHAR2 | (240) | ||
CC_VERSION_NUM | NUMBER | |||
PARENT_HEADER_ID | NUMBER | |||
CC_STATE | VARCHAR2 | (2) | ||
CC_CTRL_STATUS | VARCHAR2 | (1) | ||
CC_ENCMBRNC_STATUS | VARCHAR2 | (1) | ||
CC_APPRVL_STATUS | VARCHAR2 | (2) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
TERM_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CC_ACCT_DATE | DATE | |||
CC_DESC | VARCHAR2 | (240) | ||
CC_START_DATE | DATE | |||
CC_END_DATE | DATE | |||
CC_OWNER_USER_ID | NUMBER | |||
CC_OWNER_EMP_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc owner employee name. | |
CC_PREPARER_USER_ID | NUMBER | |||
CC_PREPARER_EMP_NAME | VARCHAR2 | (240) | Concatenation of last name, title, first name, middle names and the name the person is known by and who is cc preparer employee name | |
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_TYPE | VARCHAR2 | (30) | ||
CONVERSION_DATE | DATE | |||
CONVERSION_RATE | NUMBER | |||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CC_CURRENT_USER_ID | NUMBER | |||
WF_ITEM_TYPE | VARCHAR2 | (8) | ||
WF_ITEM_KEY | VARCHAR2 | (240) | ||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CC_GUARANTEE_FLAG | VARCHAR2 | (1) | Indicates whether the contract commitment is a Guarantee Commitment. |
APPS.IGC_CC_HEADER_VERSION_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_ID | NUMBER | Y | ||
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
ORG_ID | NUMBER | (15) | Y | Organization identifier |
APPS.IGC_CC_INTERFACE_BATCHES_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_HEADER_ID | NUMBER | Y | ||
CC_ACCT_LINE_ID | NUMBER | |||
CC_DET_PF_LINE_ID | NUMBER | |||
CODE_COMBINATION_ID | NUMBER | (15) | Y | |
BATCH_LINE_NUM | NUMBER | Y | ||
CC_TRANSACTION_DATE | DATE | Y | ||
CC_FUNC_DR_AMT | NUMBER | |||
CC_FUNC_CR_AMT | NUMBER | |||
JE_SOURCE_NAME | VARCHAR2 | (25) | ||
JE_CATEGORY_NAME | VARCHAR2 | (25) | ||
PERIOD_SET_NAME | VARCHAR2 | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) | ||
ACTUAL_FLAG | VARCHAR2 | (1) | Y | |
BUDGET_DEST_FLAG | VARCHAR2 | (1) | Y | |
SET_OF_BOOKS_ID | NUMBER | (15) | Y | |
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
CBC_RESULT_CODE | VARCHAR2 | (3) | ||
STATUS_CODE | VARCHAR2 | (2) | ||
BUDGET_VERSION_ID | NUMBER | (15) | ||
BUDGET_AMT | NUMBER | |||
COMMITMENT_ENCMBRNC_AMT | NUMBER | |||
OBLIGATION_ENCMBRNC_AMT | NUMBER | |||
FUNDS_AVAILABLE_AMT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | Y | |
DOCUMENT_TYPE | VARCHAR2 | (25) | Y | |
TRANSACTION_DESCRIPTION | VARCHAR2 | (240) | ||
PA_FLAG | VARCHAR2 | (1) | ||
RESULT_CODE_SOURCE | VARCHAR2 | (1) | ||
BATCH_ID | NUMBER | (20) | ||
REFERENCE_1 | VARCHAR2 | (240) | ||
REFERENCE_2 | VARCHAR2 | (240) | ||
REFERENCE_3 | VARCHAR2 | (240) | ||
REFERENCE_4 | VARCHAR2 | (240) | ||
REFERENCE_5 | VARCHAR2 | (240) | ||
REFERENCE_6 | VARCHAR2 | (240) | ||
REFERENCE_7 | VARCHAR2 | (240) | ||
REFERENCE_8 | VARCHAR2 | (240) | ||
REFERENCE_9 | VARCHAR2 | (240) | ||
REFERENCE_10 | VARCHAR2 | (240) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CC_VERSION_NUM | NUMBER | |||
CC_ENCMBRNC_DATE | DATE |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CC_NUMBER_METHODS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
PERIOD_SET_NAME | VARCHAR2 | (15) | Y | |
PERIOD_NAME | VARCHAR2 | (15) | Y | |
PERIOD_NUM | NUMBER | (15) | Y | |
PERIOD_YEAR | NUMBER | (15) | Y | |
START_DATE | DATE | Y | ||
END_DATE | DATE | Y | ||
CC_PERIOD_STATUS | VARCHAR2 | (1) | ||
CC_PERIOD_STATUS_DESC | VARCHAR2 | (80) | ||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_TYPE | VARCHAR2 | (1) | Y | |
CC_TYPE_NAME | VARCHAR2 | (80) | Y | |
CC_STATE | VARCHAR2 | (2) | Y | |
CC_STATE_NAME | VARCHAR2 | (80) | Y | |
CC_CAN_PRPR_APPRV_FLAG | VARCHAR2 | (1) | ||
CC_CAN_PRPR_ENCMBR_FLAG | VARCHAR2 | (1) | ||
WF_APPROVAL_ITEMTYPE | VARCHAR2 | (240) | ||
WF_APPROVAL_PROCESS | VARCHAR2 | (240) | ||
DEFAULT_APPROVAL_PATH_ID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Y | Standard Who column - date when a user last updated this row. | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Y | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | Y | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATED_BY | NUMBER | Y | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
APPS.IGC_CC_ROUTING_CTRLS_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | Y | ||
CC_FISCAL_YEAR | NUMBER | (15) | Y | |
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_SMRY_PF_ENT_AMT | NUMBER | |||
CC_SMRY_PF_FUNC_AMT | NUMBER | |||
CC_SMRY_PF_BILLED_AMT | NUMBER | |||
CC_SMRY_PF_ENCMBRNC_AMT | NUMBER | |||
CC_SMRY_PF_UNENCMBRD_AMT | NUMBER |
APPS.IGC_CC_SMRY_PF_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CC_ACCT_LINE_ID | NUMBER | |||
CC_FISCAL_YEAR | NUMBER | (15) | Y | |
ORG_ID | NUMBER | (15) | Y | Organization identifier |
CC_SMRY_PF_ENT_AMT | NUMBER | |||
CC_SMRY_PF_FUNC_AMT | NUMBER | |||
CC_SMRY_PF_ENCMBRNC_AMT | NUMBER |
APPS.IGC_CC_SMRY_PF_VERSION_V is not referenced by any database object
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DUMMY | VARCHAR2 | (1) |
APPS.IGC_CC_SYSTEM_PARAMETERS_V is not referenced by any database object
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |