FND Design Data [Home] [Help]

View: GLFV_JOURNAL_LINES

Product: GL - General Ledger
Description: General Ledger journal lines record debit or credit amounts to General Ledger accounts, or use formulas to calculate journal amounts for General Ledger accounts.
Implementation/DBA Data: Not implemented in this database
View Text

SELECT JOURNAL_LINE.JE_HEADER_ID
, JOURNAL_ENTRY.NAME
, JOURNAL_LINE.JE_LINE_NUM
, JOURNAL_LINE.LEDGER_ID
, LEDGER.NAME
, JOURNAL_LINE.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC'
, JOURNAL_LINE.PERIOD_NAME
, JOURNAL_LINE.EFFECTIVE_DATE
, JOURNAL_LINE.ENTERED_DR
, JOURNAL_LINE.ENTERED_CR
, JOURNAL_LINE.ACCOUNTED_DR
, JOURNAL_LINE.ACCOUNTED_CR
, JOURNAL_LINE.DESCRIPTION
, JOURNAL_LINE.STAT_AMOUNT
, JOURNAL_LINE.SUBLEDGER_DOC_SEQUENCE_VALUE
, JOURNAL_LINE.REFERENCE_1
, JOURNAL_LINE.REFERENCE_2
, JOURNAL_LINE.REFERENCE_3
, JOURNAL_LINE.REFERENCE_4
, JOURNAL_LINE.REFERENCE_5
, JOURNAL_LINE.REFERENCE_6
, JOURNAL_LINE.REFERENCE_7
, JOURNAL_LINE.REFERENCE_8
, JOURNAL_LINE.REFERENCE_9
, JOURNAL_LINE.REFERENCE_10
, '_DF:SQLGL:GL_JE_LINES:JOURNAL_LINE'
, '_DF:SQLGL:GL_JE_LINES_TAX:JOURNAL_LINE'
FROM GL_LEDGERS LEDGER
, GL_JE_LINES JOURNAL_LINE
, GL_JE_HEADERS JOURNAL_ENTRY
, GL_CODE_COMBINATIONS GCC
WHERE (JOURNAL_LINE.LEDGER_ID = LEDGER.LEDGER_ID)
AND (JOURNAL_LINE.JE_HEADER_ID = JOURNAL_ENTRY.JE_HEADER_ID)
AND (JOURNAL_LINE.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID)
AND '_SEC:GL:JOURNAL_LINE.LEDGER_ID
, JOURNAL_LINE.CODE_COMBINATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
JOURNAL_ENTRY_ID
JOURNAL_ENTRY_NAME
JOURNAL_LINE_NUMBER
LEDGER_ID
LEDGER_NAME
ACCOUNT_ID
"_KF:ACCOUNT"
PERIOD_NAME
EFFECTIVE_DATE
ENTERED_DR
ENTERED_CR
CONVERTED_DR
CONVERTED_CR
DESCRIPTION
STAT_AMOUNT
SUBLEDGER_DOCUMENT_NUMBER
REFERENCE_1
REFERENCE_2
REFERENCE_3
REFERENCE_4
REFERENCE_5
REFERENCE_6
REFERENCE_7
REFERENCE_8
REFERENCE_9
REFERENCE_10
"_DF:LINE"
"_DF:TAX"