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_ITEM_INTERFACE

Object Details

Object Name:	JA_CN_ITEM_INTERFACE
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JA_CN_ITEM_INTERFACE
Subobject Name:
Status:	VALID

The 'JA_CN_ITEM_INTERFACE' table is the interface table. It will store the journals user import. Data in this table will import to JA_CN_JOURNAL_LINES table by interface program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
JOURNAL_GROUP	NUMBER	(15)	Yes	Identifier of journal
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Identifier of legal entity
LEDGER_ID	NUMBER	(15)	Yes	Identifier of Ledger
PERIOD_NAME	VARCHAR2	(15)	Yes	Period Name
JE_CATEGORY	VARCHAR2	(25)	Yes	Journal entry category
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency Code
CURRENCY_CONVERSION_RATE	NUMBER			Currency exchange rate
JE_LINE_NUM	VARCHAR2	(30)	Yes	Line number of GL line
DESCRIPTION	VARCHAR2	(240)		Decription
THIRD_PARTY_NUMBER	VARCHAR2	(300)		Number of third party, such as customer name or vender name
PERSONNEL_ID	NUMBER			Personnel ID
PROJECT_NUMBER	VARCHAR2	(100)		Number of project. If "Project" is defined as "Chart of account", value of project segment
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
PROJECT_SOURCE	VARCHAR2	(3)	Yes	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'
JOURNAL_CREATOR_ID	NUMBER			ID of journal in General Ledger
SEGMENT1	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT2	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT3	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT4	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT5	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT6	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT7	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT8	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT9	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT10	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT11	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT12	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT13	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT14	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT15	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT16	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT17	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT18	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT19	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT20	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT21	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT22	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT23	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT24	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT25	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT26	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT27	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT28	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT29	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
SEGMENT30	VARCHAR2	(25)		Flexfield Segment for Code Combination ID
STATUS	VARCHAR2	(10)		A flag to indicate the import status, 'S'is success, initial with 'E' is error code. 'EL01' indicates legal entity is not consistent with profile.'EC01' segment combination is null and code combination id is also null'EC02' indicates the code combination id doesn't exist in table gl_code_combinations.'EC03' indicates the segment combination doesn't map a code combination id, ie, this segment combinattion hasn't defined already.'EC04' indicates code combination id is not consistent with segment combination.--if all the necessary segments are not null, but some other segments are also not null, program will not check other segments, because other segments will be used for other goal.'P' the journal is processing.'P1'journal lines which all segments is null.'P2'journal lines of which count of used segment is consistent with current COA.'ECS1' indicates the comany segment is not consistent with the legal and ledger.'EB01' indicates the DR and CR not balance in the same journal and same legal entity id.'ECG1' category is unvalidated.'ECC1' currency code is unvalidated.'ETP1' third party type is unvalidated.'ETP2' third party type is null but thirdy party number is not null.'ETP3' thirdy party number doesn't exist. Thirdy type is 'C''ETP4' thirdy party number doesn't exist. Thirdy type is 'S''ETP5'Third type is 'N' and third party number is not null.'EPR1' personal number doesn't exist.'EPS1' project source doesn't exist.'EPS2' when project source in interface table is p and it's not consistent with the project flag of subsidiary account form.'EPS3' when project source in interface table is 'COA' and it's not consistent with the project flag of subsidiary account form and the history segment is also null.'EPS4' Project source isn't set up in subsidiary account form.'EPN1' project number doesn't exist. Project source is 'PA''EPN2' project number doesn't exist. Project source is 'COA''EPN3' Project Source is 'N', but project number is not null.'EJC1' journal creator number doesn't exist'EJA1' journal approver number doesn't exist'EJP1' journal poster number doesn't exist
CODE_COMBINATION_ID	NUMBER	(15)
DEFAULT_EFFECTIVE_DATE	DATE		Yes
JOURNAL_APPROVER_ID	NUMBER
JOURNAL_POSTER_ID	NUMBER

Query Text

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


SELECT JOURNAL_GROUP
,      LEGAL_ENTITY_ID
,      LEDGER_ID
,      PERIOD_NAME
,      JE_CATEGORY
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE
,      JE_LINE_NUM
,      DESCRIPTION
,      THIRD_PARTY_NUMBER
,      PERSONNEL_ID
,      PROJECT_NUMBER
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      PROJECT_SOURCE
,      THIRD_PARTY_TYPE
,      JOURNAL_CREATOR_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
,      STATUS
,      CODE_COMBINATION_ID
,      DEFAULT_EFFECTIVE_DATE
,      JOURNAL_APPROVER_ID
,      JOURNAL_POSTER_ID
FROM JA.JA_CN_ITEM_INTERFACE;

Dependencies

[top of page]

JA.JA_CN_ITEM_INTERFACE does not reference any database object

JA.JA_CN_ITEM_INTERFACE is referenced by following:

APPS: JA_CN_ITEM_INTERFACE