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. |