DBA Data[Home] [Help] [Dependency Information]

TABLE: IGC.IGC_CC_ACCT_LINES_INTERFACE

Object Details
Object Name: IGC_CC_ACCT_LINES_INTERFACE
Object Type: TABLE
Owner: IGC
FND Design Data: TableIGC.IGC_CC_ACCT_LINES_INTERFACE
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_ACCT_LINES_INTERFACE_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_ACCT_LINE_ID
IGC_CC_ACCT_LINES_INTERFACE_U2 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_HEADER_ID
ColumnCC_ACCT_LINE_NUM
IGC_CC_ACCT_LINES_INTERFACE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_HEADER_ID
IGC_CC_ACCT_LINES_INTERFACE_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnINTERFACE_PARENT_ACCT_LINE_ID
IGC_CC_ACCT_LINES_INTERFACE_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
Columns
Name Datatype Length Mandatory Comments
INTERFACE_HEADER_ID NUMBER
Yes Contract commitment defining column
INTERFACE_ACCT_LINE_ID NUMBER
Yes 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
Yes 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
Yes 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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT INTERFACE_HEADER_ID
,      INTERFACE_ACCT_LINE_ID
,      INTERFACE_PARENT_HEADER_ID
,      INTERFACE_PARENT_ACCT_LINE_ID
,      CC_CHARGE_CODE_COMBINATION_ID
,      CC_ACCT_LINE_NUM
,      CC_BUDGET_CODE_COMBINATION_ID
,      CC_ACCT_ENTERED_AMT
,      CC_ACCT_FUNC_AMT
,      CC_ACCT_DESC
,      CC_ACCT_BILLED_AMT
,      CC_ACCT_UNBILLED_AMT
,      CC_ACCT_TAXABLE_FLAG
,      TAX_ID
,      CC_ACCT_ENCMBRNC_AMT
,      CC_ACCT_ENCMBRNC_DATE
,      CC_ACCT_ENCMBRNC_STATUS
,      PROJECT_ID
,      TASK_ID
,      EXPENDITURE_TYPE
,      EXPENDITURE_ORG_ID
,      EXPENDITURE_ITEM_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BATCH_ID
,      PROCESS_STATUS
,      CC_FUNC_WITHHELD_AMT
,      CC_ENT_WITHHELD_AMT
,      TAX_CLASSIF_CODE
FROM IGC.IGC_CC_ACCT_LINES_INTERFACE;

Dependencies

[top of page]

IGC.IGC_CC_ACCT_LINES_INTERFACE does not reference any database object

IGC.IGC_CC_ACCT_LINES_INTERFACE is referenced by following:

SchemaIGC
ViewIGC_CC_ACCT_LINES_INTERFACE#