JA_CN_GL_JOURNAL_GT
This table contains the journal header and line information along with the subledger information for journal and subledger transaction mapping report. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
JE_BATCH_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
JE_HEADER_ID | NUMBER | 18 | Yes | Oracle internal use only. | |
JE_LINE_NUM | NUMBER | 18 | Yes | Oracle internal use only. | |
AE_HEADER_ID | NUMBER | 18 | Yes | Identifier of accounting entry. | |
AE_LINE_NUM | NUMBER | 18 | Yes | Number that is associated with each subledger journal entry line. | |
PERIOD | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
ACCOUNT | VARCHAR2 | 779 | Oracle internal use only. | ||
ACCOUNT_DESC | VARCHAR2 | 1000 | Oracle internal use only. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Yes | Oracle internal use only. | |
CURRENCY_CONVERSION_RATE | NUMBER | Oracle internal use only. | |||
ENTERED_DR | NUMBER | Oracle internal use only. | |||
ENTERED_CR | NUMBER | Oracle internal use only. | |||
ACCOUNTED_DR | NUMBER | Oracle internal use only. | |||
ACCOUNTED_CR | NUMBER | Oracle internal use only. | |||
ENTERED_AMOUNT | NUMBER | Oracle internal use only. | |||
ACCOUNTED_AMOUNT | NUMBER | Oracle internal use only. | |||
JE_SOURCE | VARCHAR2 | 25 | Yes | Oracle internal use only. | |
JE_CATEGORY | VARCHAR2 | 25 | Yes | Oracle internal use only. | |
JOURNAL_BATCH_NAME | VARCHAR2 | 100 | Yes | Oracle internal use only. | |
JOURNAL_NAME | VARCHAR2 | 100 | Yes | Oracle internal use only. | |
JOURNAL_DESC | VARCHAR2 | 240 | Oracle internal use only. | ||
DOCUMENT_NUMBER | NUMBER | 18 | Oracle internal use only. | ||
VOUCHER_NUMBER | NUMBER | 18 | Oracle internal use only. | ||
GL_DATE | DATE | Oracle internal use only. | |||
JE_LINE_DESC | VARCHAR2 | 240 | Oracle internal use only. |