[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_JE_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_JE_LINES
|
| Subobject Name: | |
| Status: | VALID |
GL_JE_LINES stores the journal entry lines that you enter in the Enter Journals form. There is a one-to-many relationship between journal entries and journal entry lines. Each row in this table stores the associated journal entry header ID, the line number, the associated code combination ID, and the debits or credits associated with the journal line. STATUS is 'U' for unposted or 'P' for posted.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_JE_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 JE_HEADER_ID
JE_LINE_NUM
|
| GL_JE_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CODE_COMBINATION_ID
PERIOD_NAME
|
| GL_JE_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUBLEDGER_DOC_SEQUENCE_VALUE
SUBLEDGER_DOC_SEQUENCE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| JE_HEADER_ID | NUMBER | (15) | Yes | Journal entry header defining column |
| JE_LINE_NUM | NUMBER | (15) | Yes | Journal entry line number |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LEDGER_ID | NUMBER | (15) | Yes | Ledger defining column |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | Key flexfield combination defining column |
| PERIOD_NAME | VARCHAR2 | (15) | Yes | Accounting period |
| EFFECTIVE_DATE | DATE | Yes | Journal entry line effective date | |
| STATUS | VARCHAR2 | (1) | Yes | Journal entry line status |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| ENTERED_DR | NUMBER | Journal entry line debit amount in entered currency | ||
| ENTERED_CR | NUMBER | Journal entry line credit amount in entered currency | ||
| ACCOUNTED_DR | NUMBER | Journal entry line debit amount in base currency | ||
| ACCOUNTED_CR | NUMBER | Journal entry line credit amount in base currency | ||
| DESCRIPTION | VARCHAR2 | (240) | Journal entry line description | |
| LINE_TYPE_CODE | VARCHAR2 | (20) | Line type | |
| 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 | |
| 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 | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
| CONTEXT | VARCHAR2 | (150) | Descriptive flexfield context column | |
| CONTEXT2 | VARCHAR2 | (150) | Descriptive flexfield context column | |
| INVOICE_DATE | DATE | Value added tax descriptive flexfield column | ||
| TAX_CODE | VARCHAR2 | (15) | Value added tax descriptive flexfield column | |
| INVOICE_IDENTIFIER | VARCHAR2 | (20) | Value added tax descriptive flexfield column | |
| INVOICE_AMOUNT | NUMBER | Value added tax descriptive flexfield column | ||
| NO1 | VARCHAR2 | (150) | Value added tax descriptive flexfield column | |
| STAT_AMOUNT | NUMBER | Statistical Amount | ||
| IGNORE_RATE_FLAG | VARCHAR2 | (1) | Modify amounts if exchange rate changes | |
| CONTEXT3 | VARCHAR2 | (150) | Descriptive flexfield context column | |
| USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | Government transaction code | |
| SUBLEDGER_DOC_SEQUENCE_ID | NUMBER | Sequential numbering sequence defining column | ||
| CONTEXT4 | VARCHAR2 | (150) | Descriptive flexfield structure defining column | |
| SUBLEDGER_DOC_SEQUENCE_VALUE | NUMBER | Sequential numbering sequence value | ||
| REFERENCE_6 | VARCHAR2 | (240) | Journal entry line reference column | |
| REFERENCE_7 | VARCHAR2 | (240) | Journal entry line reference column | |
| GL_SL_LINK_ID | NUMBER | Link to associated subledger data | ||
| GL_SL_LINK_TABLE | VARCHAR2 | (30) | Table containing associated subledger data | |
| 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 | |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | Reserved for country-specific functionality | |
| JGZZ_RECON_STATUS_11I | VARCHAR2 | (1) | No Longer Used in R12 | |
| JGZZ_RECON_DATE_11I | DATE | No Longer Used in R12 | ||
| JGZZ_RECON_ID_11I | NUMBER | No Longer Used in R12 | ||
| JGZZ_RECON_REF_11I | VARCHAR2 | (240) | No Longer Used in R12 | |
| JGZZ_RECON_CONTEXT_11I | VARCHAR2 | (30) | No Longer Used in R12 | |
| TAXABLE_LINE_FLAG | VARCHAR2 | (1) | Taxable line flag for automatic tax calculations | |
| TAX_TYPE_CODE | VARCHAR2 | (1) | Tax type (Input or Output) for automatic tax calculations | |
| TAX_CODE_ID | NUMBER | (15) | Tax code defining column for automatic tax calculations | |
| TAX_ROUNDING_RULE_CODE | VARCHAR2 | (1) | Rounding rule used for automatic tax calculations | |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | (1) | Amount includes tax flag for automatic tax calculations | |
| TAX_DOCUMENT_IDENTIFIER | VARCHAR2 | (50) | Tax document identifier | |
| TAX_DOCUMENT_DATE | DATE | Tax document date | ||
| TAX_CUSTOMER_NAME | VARCHAR2 | (240) | Tax customer name | |
| TAX_CUSTOMER_REFERENCE | VARCHAR2 | (240) | Tax customer reference | |
| TAX_REGISTRATION_NUMBER | VARCHAR2 | (50) | Tax registration number | |
| TAX_LINE_FLAG | VARCHAR2 | (1) | Automatically generated tax line flag | |
| TAX_GROUP_ID | NUMBER | (15) | Tax group id for automatic tax calculations | |
| CO_THIRD_PARTY | VARCHAR2 | (14) | Columbian third party | |
| CO_PROCESSED_FLAG | VARCHAR2 | (1) | Columbian third party processed flag |
Cut, paste (and edit) the following text to query this object:
SELECT JE_HEADER_ID
, JE_LINE_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LEDGER_ID
, CODE_COMBINATION_ID
, PERIOD_NAME
, EFFECTIVE_DATE
, STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, DESCRIPTION
, LINE_TYPE_CODE
, REFERENCE_1
, REFERENCE_2
, REFERENCE_3
, REFERENCE_4
, REFERENCE_5
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, CONTEXT
, CONTEXT2
, INVOICE_DATE
, TAX_CODE
, INVOICE_IDENTIFIER
, INVOICE_AMOUNT
, NO1
, STAT_AMOUNT
, IGNORE_RATE_FLAG
, CONTEXT3
, USSGL_TRANSACTION_CODE
, SUBLEDGER_DOC_SEQUENCE_ID
, CONTEXT4
, SUBLEDGER_DOC_SEQUENCE_VALUE
, REFERENCE_6
, REFERENCE_7
, GL_SL_LINK_ID
, GL_SL_LINK_TABLE
, REFERENCE_8
, REFERENCE_9
, REFERENCE_10
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, JGZZ_RECON_STATUS_11I
, JGZZ_RECON_DATE_11I
, JGZZ_RECON_ID_11I
, JGZZ_RECON_REF_11I
, JGZZ_RECON_CONTEXT_11I
, TAXABLE_LINE_FLAG
, TAX_TYPE_CODE
, TAX_CODE_ID
, TAX_ROUNDING_RULE_CODE
, AMOUNT_INCLUDES_TAX_FLAG
, TAX_DOCUMENT_IDENTIFIER
, TAX_DOCUMENT_DATE
, TAX_CUSTOMER_NAME
, TAX_CUSTOMER_REFERENCE
, TAX_REGISTRATION_NUMBER
, TAX_LINE_FLAG
, TAX_GROUP_ID
, CO_THIRD_PARTY
, CO_PROCESSED_FLAG
FROM GL.GL_JE_LINES;
GL.GL_JE_LINES does not reference any database object
GL.GL_JE_LINES is referenced by following:
GL
GL_JE_LINES#
|
|
|
|