[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGI_ITR_CHARGE_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | IGI |
| FND Design Data: |  IGI.IGI_ITR_CHARGE_LINES
|
| Subobject Name: | |
| Status: | VALID |
IGI_CHARGE_LINES stores cross charge lines. There is a one-to-many relationship between cross charge headers and cross charge lines. Each row in this table stores the associated cross charge header identifier, the line number, the associated code combination identifier, and the debits and credits for the journal line.
Each row also stores the cross charge authorization flag and the suggested amount for rejected journals. This table corresponds to the Cross Charge Lines region of the Internal Charge Entry window.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGI_ITR_CHARGE_LINES_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 IT_HEADER_ID
IT_LINE_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| IT_HEADER_ID | NUMBER | (15) | Yes | Cross charge header identifier |
| IT_LINE_NUM | NUMBER | (15) | Yes | Cross charge line number |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
| CODE_COMBINATION_ID | NUMBER | (15) | Key Flexfield combination defining column | |
| CHARGE_CENTER_ID | NUMBER | (15) | Yes | Internal trading charge center identifier |
| EFFECTIVE_DATE | DATE | Cross charge line default date | ||
| ENTERED_DR | NUMBER | Cross charge line debit amount in entered currency | ||
| ENTERED_CR | NUMBER | Cross charge line credit amount in entered currency | ||
| DESCRIPTION | VARCHAR2 | (240) | Cross charge line description | |
| STATUS_FLAG | VARCHAR2 | (1) | Values are A for Accept, R for Reject, or E for Reauthorize. | |
| POSTING_FLAG | VARCHAR2 | (1) | Values are S for Submit, F for Fundsfail, O for Postfail, D for Deleted, or P for Posted. | |
| SUBMIT_DATE | DATE | Date cross charge submitted | ||
| SUGGESTED_AMOUNT | NUMBER | Amount for rejected cross charges | ||
| REJECTION_NOTE | VARCHAR2 | (240) | Rejected cross charge line detail | |
| CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
| CREATED_BY | NUMBER | Yes | 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). | ||
| 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). | ||
| IT_SERVICE_LINE_ID | NUMBER | (15) | Service Line Identifier | |
| RECEIVING_CODE_COMBINATION_ID | NUMBER | (15) | Code Combination Identifier | |
| CREATION_CODE_COMBINATION_ID | NUMBER | (15) | Code Combination Identifier | |
| CHARGE_SERVICE_ID | NUMBER | (15) | Service Linked to Charge Center Identifier | |
| CREA_COST_CENTER | VARCHAR2 | (30) | Cost Center Segment for Creation Account | |
| CREA_CONF_SEGMENT_VALUE | VARCHAR2 | (30) | Configurable Segment for Creation Account | |
| RECV_COST_CENTER | VARCHAR2 | (30) | Cost Center Segment for Receiving Account | |
| RECV_CONF_SEGMENT_VALUE | VARCHAR2 | (30) | Configurable Segment for Receiving Account | |
| SUGGESTED_RECV_CCID | NUMBER | (15) | Suggested Code Combination Identifier for Receiving Account | |
| FAILED_FUNDS_LOOKUP_CODE | VARCHAR2 | (1) | Check Funds Status | |
| ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Y / N | |
| ENCUMBERED_AMOUNT | NUMBER | Value of amount encumbered | ||
| UNENCUMBERED_AMOUNT | NUMBER | Value of amount unencumbered | ||
| GL_ENCUMBERED_DATE | DATE | Date of encumbrance in GL | ||
| GL_ENCUMBERED_PERIOD_NAME | VARCHAR2 | (15) | Period of encumbrance in GL | |
| GL_CANCELLED_DATE | DATE | Date of cancellation in GL | ||
| PREVENT_ENCUMBRANCE_FLAG | VARCHAR2 | (1) | Y / N | |
| JE_HEADER_ID | NUMBER | (15) | Journal Header Identifier | |
| RECEIVER_ID | NUMBER | (15) | Receiver Identifier | |
| CHARGE_RANGE_ID | NUMBER | (15) | Charge Range Identifier | |
| PACKET_ID | NUMBER | (15) | GL_BC_PACKET Identifier | |
| REVERSAL_FLAG | VARCHAR2 | (1) | Y / N | |
| LINK_REFERNCE_NUM | NUMBER | (15) | Link Reference for Charge Lines | |
| SERVICE_ID | NUMBER | (15) | Service Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT IT_HEADER_ID
, IT_LINE_NUM
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, CHARGE_CENTER_ID
, EFFECTIVE_DATE
, ENTERED_DR
, ENTERED_CR
, DESCRIPTION
, STATUS_FLAG
, POSTING_FLAG
, SUBMIT_DATE
, SUGGESTED_AMOUNT
, REJECTION_NOTE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, IT_SERVICE_LINE_ID
, RECEIVING_CODE_COMBINATION_ID
, CREATION_CODE_COMBINATION_ID
, CHARGE_SERVICE_ID
, CREA_COST_CENTER
, CREA_CONF_SEGMENT_VALUE
, RECV_COST_CENTER
, RECV_CONF_SEGMENT_VALUE
, SUGGESTED_RECV_CCID
, FAILED_FUNDS_LOOKUP_CODE
, ENCUMBRANCE_FLAG
, ENCUMBERED_AMOUNT
, UNENCUMBERED_AMOUNT
, GL_ENCUMBERED_DATE
, GL_ENCUMBERED_PERIOD_NAME
, GL_CANCELLED_DATE
, PREVENT_ENCUMBRANCE_FLAG
, JE_HEADER_ID
, RECEIVER_ID
, CHARGE_RANGE_ID
, PACKET_ID
, REVERSAL_FLAG
, LINK_REFERNCE_NUM
, SERVICE_ID
FROM IGI.IGI_ITR_CHARGE_LINES;
IGI.IGI_ITR_CHARGE_LINES does not reference any database object
IGI.IGI_ITR_CHARGE_LINES is referenced by following:
APPS
IGI_ITR_CHARGE_LINES
|
|
|
|