|
|
|
|
|
|
|
|
|
| Previous | Next | Contents | Index | Navigation | Glossary | Library |
| Column Name | Null? | Type |
|---|---|---|
| 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 through 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) | |
| Table 1 - 2. GL_INTERFACE Table (Page 3 of 3) | ||
Assigning Values for Additional Required and Conditionally Required Columns
Assigning Values for Currency Conversion
Assigning Values to Optional Columns
Required NULL Columns in the GL_INTERFACE Table
About Journal Import Validation
| Previous | Next | Contents | Index | Navigation | Glossary | Library |