|
| STATUS
| NOT NULL
| VARCHAR2 (50)
|
| SET_OF_BOOKS_ID
| NOT NULL
| NUMBER (15)
|
| USER_JE_SOURCE_NAME
| NOT NULL
| VARCHAR2 (25)
|
| USER_JE_CATEGORY_NAME
| NOT NULL
| VARCHAR2 (25)
|
| ACCOUNTING_DATE
| NOT NULL
| DATE
|
| CURRENCY_CODE
| NOT NULL
| VARCHAR2 (15)
|
| DATE_CREATED
| NOT NULL
| DATE
|
| CREATED_BY
| NOT NULL
| NUMBER (15)
|
| ACTUAL_FLAG
| NOT NULL
| VARCHAR2 (1)
|
| ENCUMBRANCE_TYPE_ID
|
| NUMBER
|
| BUDGET_VERSION_ID
|
| NUMBER
|
| CURRENCY_
CONVERSION_DATE
|
| DATE
|
| USER_CURRENCY_CONVERSION_TYPE
|
| VARCHAR2 (30)
|
| CURRENCY_CONVERSION_RATE
|
| NUMBER
|
| SEGMENT1 到
SEGMENT30
|
| VARCHAR (25)
|
| ENTERED_DR
|
| NUMBER
|
| ENTERED_CR
|
| NUMBER
|
| ACCOUNTED_DR
|
| NUMBER
|
| ACCOUNTED_CR
|
| NUMBER
|
| TRANSACTION_DATE
|
| DATE
|
| REFERENCE1
|
| VARCHAR2 (100)
|
| REFERENCE2
|
| VARCHAR2 (240)
|
| REFERENCE3
|
| VARCHAR2 (100)
|
| REFERENCE4
|
| VARCHAR2 (100)
|
| REFERENCE5
|
| VARCHAR2 (240)
|
| REFERENCE6 through
REFERENCE9
|
| VARCHAR2 (100)
|
| REFERENCE10
|
| VARCHAR2 (240)
|
| REFERENCE11 through
REFERENCE20
|
| VARCHAR2 (100)
|
| REFERENCE21 through
REFERENCE30
|
| VARCHAR2 (240)
|
| GROUP_ID
|
| NUMBER (15)
|
| JE_BATCH_ID
|
| NUMBER (15)
|
| PERIOD_NAME
|
| VARCHAR2 (15)
|
| JE_HEADER_ID
|
| NUMBER (15)
|
| JE_LINE_NUM
|
| NUMBER (15)
|
| CHART_OF_ACCOUNTS_ID
|
| NUMBER (15)
|
| FUNCTIONAL_CURRENCY_CODE
|
| VARCHAR2 (15)
|
| CODE_COMBINATION_ID
|
| NUMBER (15)
|
| DATE_CREATED_IN_GL
|
| DATE
|
| WARNING_CODE
|
| VARCHAR2 (4)
|
| STATUS_DESCRIPTION
|
| VARCHAR2 (240)
|
| DESCR_FLEX_ERROR_
MESSAGE
|
| VARCHAR2 (240)
|
| STAT_AMOUNT
|
| NUMBER
|
| REQUEST_ID
|
| NUMBER (15)
|
| SUBLEDGER_DOC_SEQUENCE_ID
|
| NUMBER
|
| SUBLEDGER_DOC_SEQUENCE_VALUE
|
| NUMBER
|
| USSGL_TRANSACTION_CODE
|
| VARCHAR2 (30)
|
| ATTRIBUTE1 through
ATTRIBUTE20
|
| VARCHAR2 (150)
|
| CONTEXT
|
| VARCHAR2 (150)
|
| CONTEXT2
|
| VARCHAR2 (150)
|
| CONTEXT3
|
| VARCHAR2 (150)
|
| INVOICE_DATE
|
| DATE
|
| INVOICE_AMOUNT
|
| NUMBER
|
| INVOICE_IDENTIFIER
|
| VARCHAR2 (20)
|
| TAX_CODE
|
| VARCHAR2 (15)
|
