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