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


TABLE: JA.JA_CN_JOURNAL_LINES_REQ

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

The 'JA_CN_JOURNAL_LINES_REQ' table stores temporarily journal lines of current session, which itemized with information of related subsidiary accounts if any

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JA_CN_JOURNAL_LINES_REQ_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnJE_HEADER_ID
ColumnJE_LINE_NUM
Columns
Name Datatype Length Mandatory Comments
JE_HEADER_ID NUMBER (15) Yes Identifier of GL header
SET_OF_BOOKS_ID NUMBER (15)
Identifier of GL set of book
LEGAL_ENTITY_ID NUMBER (15) Yes Identifier of legal entity
JE_LINE_NUM VARCHAR2 (30) Yes Line number of GL line
JE_CATEGORY VARCHAR2 (25) Yes Journal entry category
DEFAULT_EFFECTIVE_DATE DATE
Yes Journal entry effective date
PERIOD_NAME VARCHAR2 (15) Yes Accounting period
CURRENCY_CODE VARCHAR2 (15) Yes Currency
CURRENCY_CONVERSION_RATE NUMBER

Currency exchange rate
JOURNAL_NUMBER NUMBER

Number of a Journal, it is sequence number by legal entity and period
LINE_NUMBER VARCHAR2 (50)
Number of line after splitting
DESCRIPTION VARCHAR2 (240)
Description
CODE_COMBINATION_ID NUMBER
Yes Key flexfield combination defining column
COMPANY_SEGMENT VARCHAR2 (100) Yes Balance segment
ACCOUNT_SEGMENT VARCHAR2 (150) Yes Nature account number
COST_CENTER VARCHAR2 (100)
Cost center segment
PROJECT_NUMBER VARCHAR2 (100)
Number of project. If "Project" is defined as "Chart of account", value of project segment
PROJECT_ID NUMBER

Identifier of project
THIRD_PARTY_ID NUMBER

Identifier of third party, such as customer_id or vender_id
THIRD_PARTY_NUMBER VARCHAR2 (300)
Number of third party, such as customer name or vender name
PROJECT_SOURCE VARCHAR2 (3)
Source of project. If "Project" is defined as "Chart of account", "COA". If "Project" is defined as "Project module", "PA".
THIRD_PARTY_TYPE VARCHAR2 (1)
Source to indicate what type of the third party is, 'C' means 'Customer' and 'S' means 'Supplier'
PERSONNEL_ID NUMBER

Identifier of personnel
PERSONNEL_NUMBER VARCHAR2 (300)
Personnel number
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
POPULATE_CODE VARCHAR2 (4000)
To indicate current record is populated by which SQL statement, only for debug and trace intention.
STATUS VARCHAR2 (1) Yes A flag to indicate if current record has been calculated into balance table. Available value is 'P' or 'U'
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER

Current request ID
JOURNAL_CREATED_BY NUMBER

Creator of journal in General Ledger
JOURNAL_APPROVER VARCHAR2 (240)
Creator's name of journal in General Ledger
JOURNAL_CREATOR VARCHAR2 (240)
Approver of journal in General Ledger
JOURNAL_POSTED_BY NUMBER

Poster of journal in General Ledger
JOURNAL_POSTER VARCHAR2 (240)
Poster's name of journal in General Ledger
LEDGER_ID NUMBER
Yes Identifier of Ledger
SEGMENT1 VARCHAR2 (20)
Subsidiary Segment
SEGMENT2 VARCHAR2 (20)
Segment to store extra information
SEGMENT3 VARCHAR2 (20)
Segment to store extra information
SEGMENT4 VARCHAR2 (20)
Segment to store extra information
SEGMENT5 VARCHAR2 (20)
Segment to store extra information
SEGMENT6 VARCHAR2 (20)
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
SETTLEMENT_METHOD_NUMBER VARCHAR2 (200)
Settlement Method Number
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Conversion Type
Query Text

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


SELECT JE_HEADER_ID
,      SET_OF_BOOKS_ID
,      LEGAL_ENTITY_ID
,      JE_LINE_NUM
,      JE_CATEGORY
,      DEFAULT_EFFECTIVE_DATE
,      PERIOD_NAME
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      JOURNAL_NUMBER
,      LINE_NUMBER
,      DESCRIPTION
,      CODE_COMBINATION_ID
,      COMPANY_SEGMENT
,      ACCOUNT_SEGMENT
,      COST_CENTER
,      PROJECT_NUMBER
,      PROJECT_ID
,      THIRD_PARTY_ID
,      THIRD_PARTY_NUMBER
,      PROJECT_SOURCE
,      THIRD_PARTY_TYPE
,      PERSONNEL_ID
,      PERSONNEL_NUMBER
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      POPULATE_CODE
,      STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      JOURNAL_CREATED_BY
,      JOURNAL_APPROVER
,      JOURNAL_CREATOR
,      JOURNAL_POSTED_BY
,      JOURNAL_POSTER
,      LEDGER_ID
,      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
,      SETTLEMENT_METHOD_NUMBER
,      CURRENCY_CONVERSION_TYPE
FROM JA.JA_CN_JOURNAL_LINES_REQ;

Dependencies

[top of page]

JA.JA_CN_JOURNAL_LINES_REQ does not reference any database object

JA.JA_CN_JOURNAL_LINES_REQ is referenced by following:

SchemaJA
ViewJA_CN_JOURNAL_LINES_REQ#