JA_CN_TRANS_MAPPING_GT
This table contains journal and subledger transaction information. Oracle internal use only.
Details
-
Schema: FUSION
-
Object owner: JA
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| 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_NUM | NUMBER | 18 | Oracle internal use only. | ||
| JE_LINE_DESC | VARCHAR2 | 240 | Oracle internal use only. | ||
| EVENT_CLASS | VARCHAR2 | 80 | Oracle internal use only. | ||
| EVENT_TYPE | VARCHAR2 | 80 | Oracle internal use only. | ||
| TRANSACTION_DATE | DATE | Oracle internal use only. | |||
| SLA_HEADER_DESC | VARCHAR2 | 1000 | Oracle internal use only. | ||
| CUSTOMER_SUPPLIER_NAME | VARCHAR2 | 360 | Oracle internal use only. | ||
| RECEIPT_PAYMENT_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| TRX_INVOICE_NUMBER | VARCHAR2 | 50 | Oracle internal use only. | ||
| INTER_BATCH_NUMBER | NUMBER | 18 | Oracle internal use only. | ||
| PO_NUMBER | VARCHAR2 | 30 | Oracle internal use only. | ||
| RECEIPT_NUMBER | VARCHAR2 | 30 | Oracle internal use only. |