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

TABLE: JA.JA_CN_JOURNAL_LINES_GT

Object Details
Object Name: JA_CN_JOURNAL_LINES_GT
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JA_CN_JOURNAL_LINES_GT
Subobject Name:
Status: VALID

JA_CN_JOURNAL_LINES_GT is a session level global temporary table which stores combined journal lines before they are exported to flat file. The reason to create this temporary is that according to the logic of procedure run_export, the journal lines were extracted in sort by account number which doesn't fulfill the requirements. We need to save journal lines to this temp table and sort them before they are exported and in this way, it is also helpful for debugging.

Temporary Table Details

JA.JA_CN_JOURNAL_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
JA_CN_JOURNAL_LINES_GT_N1 NORMAL NONUNIQUE Tablespace ColumnJOURNAL_NUMBER
ColumnJE_LINE_NUM
ColumnSTART_DATE
Columns
Name Datatype Length Mandatory Comments
JOURNAL_NUMBER VARCHAR2 (150)
Number of a Journal
JE_CATEGORY VARCHAR2 (25) Yes Journal entry category.
DESCRIPTION VARCHAR2 (240)
Description
DEFAULT_EFFECTIVE_DATE DATE
Yes Journal entry effective date
JE_LINE_NUM VARCHAR2 (30) Yes Line number of GL line
ACCOUNT_SEGMENT_VALUE VARCHAR2 (150) Yes Nature account number
ACCOUNTED_DR NUMBER

Journal entry line debit amount in base currency
ACCOUNTED_CR NUMBER

Journal entry line credit amount in base currency
ENTERED_DR NUMBER

Journal entry line debit amount in entered currency
ENTERED_CR NUMBER

Journal entry line credit amount in entered currency
CURRENCY_CODE VARCHAR2 (80) Yes Currency
CURRENCY_CONVERSION_RATE NUMBER

Currency exchange rate
JOURNAL_PREPARER VARCHAR2 (240)
Journal preparer
COST_CENTER VARCHAR2 (100)
Cost center segment
THIRD_PARTY_NUMBER VARCHAR2 (300)
Number of third party, such as customer name or vendor name
PERSONNEL_NUMBER VARCHAR2 (300)
Personnel number
PROJECT_NUMBER VARCHAR2 (100)
Number of project. If "Project" is defined as "Chart of account", value of project segment
HAS_THIRD_PARTY VARCHAR2 (240)
'S'or 'C' indicates whether this natural account has third party subsidiary of supplier or customer.
HAS_COST_CENTER VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has cost center subsidiary.
HAS_PERSONNEL VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has personnel subsidiary.
HAS_PROJECT VARCHAR2 (240)
'Y'or 'N' indicates whether this natural account has project subsidiary.
JOURNAL_APPROVER VARCHAR2 (240)
Journal approver
JOURNAL_POSTER VARCHAR2 (240)
Journal poster
PERIOD_NAME VARCHAR2 (15) Yes Period name
START_DATE DATE
Yes Start date
Query Text

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


SELECT JOURNAL_NUMBER
,      JE_CATEGORY
,      DESCRIPTION
,      DEFAULT_EFFECTIVE_DATE
,      JE_LINE_NUM
,      ACCOUNT_SEGMENT_VALUE
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENTERED_DR
,      ENTERED_CR
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      JOURNAL_PREPARER
,      COST_CENTER
,      THIRD_PARTY_NUMBER
,      PERSONNEL_NUMBER
,      PROJECT_NUMBER
,      HAS_THIRD_PARTY
,      HAS_COST_CENTER
,      HAS_PERSONNEL
,      HAS_PROJECT
,      JOURNAL_APPROVER
,      JOURNAL_POSTER
,      PERIOD_NAME
,      START_DATE
FROM JA.JA_CN_JOURNAL_LINES_GT;

Dependencies

[top of page]

JA.JA_CN_JOURNAL_LINES_GT does not reference any database object

JA.JA_CN_JOURNAL_LINES_GT is referenced by following:

SchemaAPPS
SynonymJA_CN_JOURNAL_LINES_GT