eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	JA.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:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
JA_CN_JOURNAL_LINES_GT_N1	NORMAL	NONUNIQUE		JOURNAL_NUMBER JE_LINE_NUM START_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
SETTLEMENT_METHOD_NUMBER	VARCHAR2	(60)		Settlement Method Number
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)		Currency exchange type
PERIOD_NUM	NUMBER			Period Number
JOURNAL_SOURCE	VARCHAR2	(25)		Journal Source
SEGMENT1	VARCHAR2	(25)		Segment to store extra information
SEGMENT2	VARCHAR2	(25)		Segment to store extra information
SEGMENT3	VARCHAR2	(25)		Segment to store extra information
SEGMENT4	VARCHAR2	(25)		Segment to store extra information
SEGMENT5	VARCHAR2	(25)		Segment to store extra information
SEGMENT6	VARCHAR2	(25)		Segment to store extra information
SEGMENT7	VARCHAR2	(25)		Segment to store extra information
SEGMENT8	VARCHAR2	(25)		Segment to store extra information
SEGMENT9	VARCHAR2	(25)		Segment to store extra information
SEGMENT10	VARCHAR2	(25)		Segment to store extra information
SEGMENT11	VARCHAR2	(25)		Segment to store extra information
SEGMENT12	VARCHAR2	(25)		Segment to store extra information
SEGMENT13	VARCHAR2	(25)		Segment to store extra information
SEGMENT14	VARCHAR2	(25)		Segment to store extra information
SEGMENT15	VARCHAR2	(25)		Segment to store extra information
SEGMENT16	VARCHAR2	(25)		Segment to store extra information
SEGMENT17	VARCHAR2	(25)		Segment to store extra information
SEGMENT18	VARCHAR2	(25)		Segment to store extra information
SEGMENT19	VARCHAR2	(25)		Segment to store extra information
SEGMENT20	VARCHAR2	(25)		Segment to store extra information
SEGMENT21	VARCHAR2	(25)		Segment to store extra information
SEGMENT22	VARCHAR2	(25)		Segment to store extra information
SEGMENT23	VARCHAR2	(25)		Segment to store extra information
SEGMENT24	VARCHAR2	(25)		Segment to store extra information
SEGMENT25	VARCHAR2	(25)		Segment to store extra information
SEGMENT26	VARCHAR2	(25)		Segment to store extra information
SEGMENT27	VARCHAR2	(25)		Segment to store extra information
SEGMENT28	VARCHAR2	(25)		Segment to store extra information
SEGMENT29	VARCHAR2	(25)		Segment to store extra information
SEGMENT30	VARCHAR2	(25)		Segment to store extra information

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
,      SETTLEMENT_METHOD_NUMBER
,      CURRENCY_CONVERSION_TYPE
,      PERIOD_NUM
,      JOURNAL_SOURCE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
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:

APPS: JA_CN_JOURNAL_LINES_GT