| General Ledger - GL_ARCHIVE_BALANCES | Archive account balances |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Accounting books defining column |
| TRANSLATED_FLAG | Flag indicating translated balance |
| REVALUATION_STATUS | Not currently used |
| PERIOD_TYPE | Accounting period type |
| PERIOD_YEAR | Accounting period year |
| PERIOD_NUM | Accounting period number |
| PERIOD_NET_DR | Period net debit balance |
| PERIOD_NET_CR | Period net credit balance |
| PERIOD_TO_DATE_ADB | Not currently used |
| QUARTER_TO_DATE_DR | Quarter to date debit balance |
| QUARTER_TO_DATE_CR | Quarter to date credit balance |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| QUARTER_TO_DATE_ADB | Not currently used |
| YEAR_TO_DATE_ADB | Not currently used |
| PROJECT_TO_DATE_DR | Accumulated project debit balance |
| PROJECT_TO_DATE_CR | Accumulated project credit balance |
| PROJECT_TO_DATE_ADB | Not currently used |
| BEGIN_BALANCE_DR | Beginning debit balance |
| BEGIN_BALANCE_CR | Beginning credit balance |
| PERIOD_NET_DR_BEQ | Period net debit balance, base currency |
| PERIOD_NET_CR_BEQ | Period net credit balance, base currency |
| BEGIN_BALANCE_DR_BEQ | Beginning debit balance, base currency |
| CURRENCY_CODE | Currency |
| BEGIN_BALANCE_CR_BEQ | Beginning credit balance, base currency |
| TEMPLATE_ID | Summary template defining column |
| ENCUMBRANCE_DOC_ID | Purchasing encumbrance column |
| ENCUMBRANCE_LINE_NUM | Purchasing encumbrance column |
| PERIOD_NAME | Accounting period |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance batch defining column |
| General Ledger - GL_ARCHIVE_HISTORY | History of the archive and purges of journals and balances |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| LAST_PURGED_EFF_PERIOD_NUM | Effective period number of the latest purged period within this fiscal year |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| STATUS | 'A' for archived, 'B' for both archived and purged |
| ARCHIVE_DATE | Date archived |
| ARCHIVED_BY | User who ran archive program |
| TOTAL_RECORDS_ARCHIVED | Number of records archived |
| PURGE_DATE | Date purged |
| PURGED_BY | User who ran purge program |
| TOTAL_RECORDS_PURGED | Number of records purged |
| FISCAL_YEAR | Fiscal year data archived/purged |
| SET_OF_BOOKS_ID | Accounting books defining column |
| TOTAL_HEADERS_PURGED | For internal use by the Archive/Purge Program |
| TOTAL_LINES_PURGED | For internal use by the Archive/Purge Program |
| TOTAL_REFERENCES_PURGED | For internal use by the Archive/Purge Program |
| MAX_JE_HEADER_ID | For internal use by the Archive/Purge Program |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| DATA_TYPE | 'A' for all balances, or 'J' for journal archiving and purging |
| BUDGET_VERSION_ID | Budget version defining column |
| LAST_ARCHIVED_EFF_PERIOD_NUM | Effective period number of the latest archived period within this fiscal year |
| General Ledger - GL_BUDGET_PERIOD_RANGES | Status of budget period ranges (open/not open) |
|---|---|
| Column Name | Descritpion |
| BUDGET_VERSION_ID | Budget version defining column |
| PERIOD_YEAR | Fiscal year accounting period falls in |
| START_PERIOD_NAME | First accounting period of range |
| START_PERIOD_NUM | Number of first accounting period of range |
| END_PERIOD_NAME | Final accounting period of range |
| END_PERIOD_NUM | Number of final accounting period of range |
| OPEN_FLAG | Open range flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_BUDGET_RANGE_INTERIM | Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| DR_FLAG | Debit/Credit flag |
| STAT_AMOUNT13 | Statistical amount for budget journals |
| STATUS_NUMBER | 0 for new budget records, request id when Budget Posting starts |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| PERIOD1_AMOUNT | Budget period amount |
| PERIOD2_AMOUNT | Budget period amount |
| PERIOD3_AMOUNT | Budget period amount |
| PERIOD4_AMOUNT | Budget period amount |
| PERIOD5_AMOUNT | Budget period amount |
| PERIOD6_AMOUNT | Budget period amount |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| PERIOD7_AMOUNT | Budget period amount |
| SET_OF_BOOKS_ID | Accounting books defining column |
| PERIOD8_AMOUNT | Budget period amount |
| PERIOD9_AMOUNT | Budget period amount |
| PERIOD10_AMOUNT | Budget period amount |
| PERIOD11_AMOUNT | Budget period amount |
| PERIOD12_AMOUNT | Budget period amount |
| PERIOD13_AMOUNT | Budget period amount |
| OLD_PERIOD1_AMOUNT | Old budget period amount |
| OLD_PERIOD2_AMOUNT | Old budget period amount |
| OLD_PERIOD3_AMOUNT | Old budget period amount |
| CURRENCY_CODE | Currency |
| OLD_PERIOD4_AMOUNT | Old budget period amount |
| OLD_PERIOD5_AMOUNT | Old budget period amount |
| OLD_PERIOD6_AMOUNT | Old budget period amount |
| OLD_PERIOD7_AMOUNT | Old budget period amount |
| OLD_PERIOD8_AMOUNT | Old budget period amount |
| OLD_PERIOD9_AMOUNT | Old budget period amount |
| OLD_PERIOD10_AMOUNT | Old budget period amount |
| OLD_PERIOD11_AMOUNT | Old budget period amount |
| OLD_PERIOD12_AMOUNT | Old budget period amount |
| OLD_PERIOD13_AMOUNT | Old budget period amount |
| BUDGET_VERSION_ID | Budget version defining column |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| BUDGET_ENTITY_ID | Budget Organization defining column |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| PERIOD_YEAR | Accounting period year |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| PERIOD_TYPE | Accounting period type |
| ACCOUNT_TYPE | Key flexfield combination type (Asset, Liability, etc.) |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| JE_DRCR_SIGN_REFERENCE | Signs of amounts for budget journals |
| JE_LINE_DESCRIPTION1 | Line description for budget journals |
| JE_LINE_DESCRIPTION2 | Line description for budget journals |
| JE_LINE_DESCRIPTION3 | Line description for budget journals |
| JE_LINE_DESCRIPTION4 | Line description for budget journals |
| JE_LINE_DESCRIPTION5 | Line description for budget journals |
| START_PERIOD_NAME | Beginning accounting period |
| JE_LINE_DESCRIPTION6 | Line description for budget journals |
| JE_LINE_DESCRIPTION7 | Line description for budget journals |
| JE_LINE_DESCRIPTION8 | Line description for budget journals |
| JE_LINE_DESCRIPTION9 | Line description for budget journals |
| JE_LINE_DESCRIPTION10 | Line description for budget journals |
| JE_LINE_DESCRIPTION11 | Line description for budget journals |
| JE_LINE_DESCRIPTION12 | Line description for budget journals |
| JE_LINE_DESCRIPTION13 | Line description for budget journals |
| STAT_AMOUNT1 | Statistical amount for budget journals |
| STAT_AMOUNT2 | Statistical amount for budget journals |
| START_PERIOD_NUM | Beginning accounting period number |
| STAT_AMOUNT3 | Statistical amount for budget journals |
| STAT_AMOUNT4 | Statistical amount for budget journals |
| STAT_AMOUNT5 | Statistical amount for budget journals |
| STAT_AMOUNT6 | Statistical amount for budget journals |
| STAT_AMOUNT7 | Statistical amount for budget journals |
| STAT_AMOUNT8 | Statistical amount for budget journals |
| STAT_AMOUNT9 | Statistical amount for budget journals |
| STAT_AMOUNT10 | Statistical amount for budget journals |
| STAT_AMOUNT11 | Statistical amount for budget journals |
| STAT_AMOUNT12 | Statistical amount for budget journals |
| General Ledger - GL_CONSOLIDATION_AUDIT | Audit data for consolidation run |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_ID | Consolidation defining column |
| AVERAGE_CONSOLIDATION_FLAG | Average consolidation flag |
| FROM_LEDGER_ID | Subsidiary accounting books defining column |
| FROM_CODE_COMBINATION_ID | Subsidiary key flex account defining column |
| ENTERED_DR | Consolidated debit amount |
| ENTERED_CR | Consolidated credit amount |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| TO_PERIOD_NAME | Parent accounting period name |
| SEGMENT6 | Key flexfield segment |
| FROM_SET_OF_BOOKS_ID | Subsidiary accounting books defining column |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| FROM_PERIOD_NAME | Subsidiary accounting period name |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| TO_LEDGER_ID | Parent accounting books defining column |
| SEGMENT26 | Key flexfield segment |
| TO_SET_OF_BOOKS_ID | Parent accounting books defining column |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| REQUEST_ID | Consolidation concurrent request defining column |
| ACTUAL_FLAG | Balance type lookup (Actual, Budget, or Encumbrance) |
| CONSOLIDATION_TYPE | Consolidation type |
| ACCOUNTING_DATE | Accounting date |
| General Ledger - GL_HISTORICAL_RATE_RANGES | Historical translation rates account ranges |
|---|---|
| Column Name | Descritpion |
| HISTORICAL_RANGE_ID | Historical rate range defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEGMENT1_LOW | Key flexfield segment low range column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| LEDGER_ID | Accounting books defining column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| TARGET_CURRENCY | Translation target currency |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| PERIOD_NAME | Accounting period |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| SEGMENT26_LOW | Key flexfield segment low range column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| TRANSLATED_RATE | Historical rate |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| TRANSLATED_AMOUNT | Historical amount |
| STATUS | Status column used internally by Assign Historical Rates program |
| General Ledger - GL_CARRYFORWARD_RANGES | Ranges of encumbrance accounts to carry across fiscal years |
|---|---|
| Column Name | Descritpion |
| CARRYFORWARD_RANGE_ID | Carry forward process defining column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| CREATION_DATE | Standard Who column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| CREATED_BY | Standard Who column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| SEGMENT26_LOW | Key flexfield segment low range column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| SEGMENT1_LOW | Key flexfield segment low range column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| General Ledger - GL_ACCOUNT_HIERARCHIES | Summary/Detail account hierarchies |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| SUMMARY_CODE_COMBINATION_ID | Summary account key flexfield combination defining column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| DETAIL_CODE_COMBINATION_ID | Detail account key flexfield combination defining column |
| TEMPLATE_ID | Summary template defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| ORDERING_VALUE | Key flexfield account segment value |
| General Ledger - GL_AUTOMATIC_POSTING_OPTIONS | Individual automatic posting criteria |
|---|---|
| Column Name | Descritpion |
| AUTOPOST_SET_ID | Autopost set id |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ACTUAL_FLAG | Autopost criterion: balance type; can be 'A', ' B', or 'E' |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| PERIOD_NAME | Autopost criterion: journal batch posting period |
| LEDGER_ID | |
| JE_SOURCE_NAME | Autopost criterion: journal source name |
| JE_CATEGORY_NAME | Autopost criterion: journal category name |
| POSTING_PRIORITY | Posting priority |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_BUDGET_ASSIGNMENT_RANGES | Budget organization account ranges |
|---|---|
| Column Name | Descritpion |
| BUDGET_ENTITY_ID | Budget organization defining column |
| CREATION_DATE | Standard Who column |
| FUNDS_CHECK_LEVEL_CODE | No longer Used in R12 |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEQUENCE_NUMBER | Orders the account ranges |
| SEGMENT1_LOW | Key flexfield segment low range column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| LEDGER_ID | Accounting books defining column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| CURRENCY_CODE | Currency |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| ENTRY_CODE | Method to determine account balance (Entered/Calculated) |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| RANGE_ID | Flexfield assignment range defining column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| STATUS | Current status of assignment range |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| SEGMENT26_LOW | Key flexfield segment low range column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| AMOUNT_TYPE | No longer Used in R12 |
| BOUNDARY_CODE | No longer Used in R12 |
| CONTEXT | Descriptive flexfield context column |
| FUNDING_BUDGET_VERSION_ID | No longer Used in R12 |
| PROGRAM_APPLICATION_ID | Extended Who column |
| AUTOMATIC_ENCUMBRANCE_FLAG | No longer Used in R12 |
| PROGRAM_ID | Extended Who column |
| PROGRAM_UPDATE_DATE | Extended Who column |
| REQUEST_ID | Concurrent program request id |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| General Ledger - GL_BUDGET_FROZEN_RANGES | Frozen account ranges for a budget or budget organization |
|---|---|
| Column Name | Descritpion |
| BUDGET_VERSION_ID | Budget version defining column |
| SEGMENT1_LOW | Key flexfield segment low range column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| BUDGET_ENTITY_ID | Budget Organization defining column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| RANGE_ID | Key flexfield range defining column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT26_LOW | Key flexfield segment low range column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_APPLICATION_GROUPS | Application product groups that use Oracle General Ledger accounting periods |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| APPLICATION_ID | Application defining column |
| GROUP_NAME | Always 'PERIOD_STATUS' |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_ARCHIVE_BATCHES | Archive journal batches |
|---|---|
| Column Name | Descritpion |
| JE_BATCH_ID | Journal entry batch defining column |
| AVERAGE_JOURNAL_FLAG | 'Y' or 'N': Y - Average journal, 'N' - Standard journal |
| DEFAULT_EFFECTIVE_DATE | Date within default accounting period |
| BUDGETARY_CONTROL_STATUS | Journal entry batch funds check status. |
| APPROVAL_STATUS_CODE | Journal entry batch approval status. |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| STATUS_RESET_FLAG | Select/Unselect flag (posting form) |
| DEFAULT_PERIOD_NAME | Accounting period |
| UNIQUE_DATE | Not currently used |
| EARLIEST_POSTABLE_DATE | Earliest date batch can be posted |
| POSTED_DATE | Date batch was posted |
| DATE_CREATED | Date batch was created |
| DESCRIPTION | Journal entry batch description |
| CONTROL_TOTAL | Control total column |
| RUNNING_TOTAL_DR | Batch running total debit, entered currency |
| LAST_UPDATED_BY | Standard Who column |
| RUNNING_TOTAL_CR | Batch running total credit, entered currency |
| RUNNING_TOTAL_ACCOUNTED_DR | Batch running total debit, base currency |
| RUNNING_TOTAL_ACCOUNTED_CR | Batch running total credit, base currency |
| PARENT_JE_BATCH_ID | Parent MRC batch defining column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| ORG_ID | Organization defining column |
| PACKET_ID | Budgetary control packet defining column |
| NAME | Name of journal entry batch |
| USSGL_TRANSACTION_CODE | Government transaction code |
| CONTEXT2 | Descriptive flexfield structure defining column |
| POSTING_RUN_ID | Posting sequence number |
| REQUEST_ID | Posting concurrent request id |
| STATUS | Journal entry batch status |
| UNRESERVATION_PACKET_ID | Budgetary control packet defining column |
| STATUS_VERIFIED | Batch status verified by posting process (Y/N) |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| General Ledger - GL_ARCHIVE_HEADERS | Archive journal headers |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID | Journal entry header defining column |
| STATUS | Journal entry header status |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific localizations |
| JGZZ_RECON_CONTEXT | Global Reconciliation Descriptive Flexfield context |
| JGZZ_RECON_REF | Global Reconciliation Descriptive Flexfield segment |
| USSGL_TRANSACTION_CODE | Government transaction code |
| DATE_CREATED | Date journal entry header was created |
| CONTEXT2 | Descriptive Flexfield segment column |
| DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| ACCRUAL_REV_FLAG | Reversed journal entry flag |
| MULTI_BAL_SEG_FLAG | Multiple balancing segments flag |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| CONVERSION_FLAG | Translated amounts flag |
| DEFAULT_EFFECTIVE_DATE | Journal entry effective date |
| TAX_STATUS_CODE | Tax status |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| BUDGET_VERSION_ID | Budget version defining column |
| BALANCED_JE_FLAG | Balance journal entry flag |
| BALANCING_SEGMENT_VALUE | Key flexfield structure balancing segment value |
| JE_BATCH_ID | Journal entry batch defining column |
| FROM_RECURRING_HEADER_ID | Recurring batch header defining column |
| UNIQUE_DATE | Not currently used |
| EARLIEST_POSTABLE_DATE | Earliest date journal entry header can be posted |
| LAST_UPDATED_BY | Standard Who column |
| POSTED_DATE | Date journal entry header was posted |
| ACCRUAL_REV_EFFECTIVE_DATE | Reversed journal entry effective date |
| ACCRUAL_REV_PERIOD_NAME | Reversed journal entry accounting period |
| ACCRUAL_REV_STATUS | Reversed journal entry status |
| ACCRUAL_REV_JE_HEADER_ID | Reversed journal entry defining column |
| ACCRUAL_REV_CHANGE_SIGN_FLAG | Type of reversal: Y - Change Sign, N - Switch Dr/Cr |
| DESCRIPTION | Journal entry header description |
| CONTROL_TOTAL | Control total column |
| RUNNING_TOTAL_DR | Header running total debits, expressed in the entered currency |
| RUNNING_TOTAL_CR | Header running total credit, entered currency |
| SET_OF_BOOKS_ID | Accounting books defining column |
| RUNNING_TOTAL_ACCOUNTED_DR | Header running total debit, base currency |
| RUNNING_TOTAL_ACCOUNTED_CR | Header running total credit, base currency |
| CURRENCY_CONVERSION_RATE | Currency exchange rate |
| CURRENCY_CONVERSION_TYPE | Type of currency exchange rate |
| CURRENCY_CONVERSION_DATE | Date of currency exchange rate |
| EXTERNAL_REFERENCE | Extra reference column |
| PARENT_JE_HEADER_ID | Defining column for the parent journal entry in the primary MRC book |
| REVERSED_JE_HEADER_ID | Defining column for the journal entry reversed by this journal entry |
| NAME | Journal entry name |
| ORIGINATING_BAL_SEG_VALUE | The originating balancing segment value specified in the header |
| INTERCOMPANY_MODE | The intercompany mode for the journal. Valid values are 1 through 4 |
| JE_CATEGORY | Journal entry category |
| DR_BAL_SEG_VALUE | The balancing segment value used on the debit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 2 |
| CR_BAL_SEG_VALUE | The balancing segment value used on the credit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 3. |
| JE_SOURCE | Journal entry source |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| PERIOD_NAME | Accounting period |
| CONTEXT | Descriptive flexfield context column |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific localizations |
| CURRENCY_CODE | Currency |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific localizations |
| General Ledger - GL_ARCHIVE_LINES | Archive journal entry lines |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID | Journal entry header defining column |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| ENTERED_DR | Journal entry line debit amount in entered currency |
| CONTEXT | Descriptive flexfield context column |
| CONTEXT2 | Descriptive flexfield context column |
| ENTERED_CR | Journal entry line credit amount in entered currency |
| CONTEXT3 | Descriptive flexfield context column |
| CONTEXT4 | Descriptive flexfield context column |
| TAX_CODE | Value Added Tax descriptive flexfield segment |
| ACCOUNTED_DR | Journal entry line debit amount in base currency |
| INVOICE_IDENTIFIER | Value added tax descriptive flexfield segment |
| INVOICE_AMOUNT | Value Added Tax descriptive flexfield segment |
| ACCOUNTED_CR | Journal entry line credit amount in base currency |
| NO1 | Value Added Tax descriptive flexfield segment |
| STAT_AMOUNT | Statistical amount column |
| DESCRIPTION | Journal entry line description |
| IGNORE_RATE_FLAG | Modify amounts if exchange rate changes |
| INVOICE_DATE | Value added tax descriptive flexfield context column |
| REFERENCE_1 | Journal entry line reference column |
| USSGL_TRANSACTION_CODE | Government transaction code |
| REFERENCE_2 | Journal entry line reference column |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| GL_SL_LINK_ID | Link to associated subledger data |
| JE_LINE_NUM | Journal entry line number |
| REFERENCE_3 | Journal entry line reference column |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific localizations |
| REFERENCE_4 | Journal entry line reference column |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific localizations |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific localizations |
| JGZZ_RECON_STATUS | Global Reconciliation descriptive flexfield segment |
| JGZZ_RECON_DATE | Global Reconciliation descriptive flexfield segment |
| JGZZ_RECON_ID | Global Reconciliation descriptive flexfield segment |
| JGZZ_RECON_REF | Global Reconciliation descriptive flexfield segment |
| JGZZ_RECON_CONTEXT | Global Reconciliation descriptive flexfield context |
| TAXABLE_LINE_FLAG | Taxable line flag for automatic tax calculations |
| TAX_TYPE_CODE | Tax type (Input or Output) for automatic tax calculations |
| TAX_CODE_ID | Tax code defining column for automatic tax calculations |
| TAX_ROUNDING_RULE_CODE | Rounding rule used for automatic tax calculations |
| AMOUNT_INCLUDES_TAX_FLAG | Amount includes tax flag for automatic tax calculations |
| TAX_DOCUMENT_IDENTIFIER | Tax document identifier |
| TAX_DOCUMENT_DATE | Tax document date |
| TAX_CUSTOMER_NAME | Tax customer name |
| REFERENCE_5 | Journal entry line reference column |
| TAX_CUSTOMER_REFERENCE | Tax customer reference |
| TAX_REGISTRATION_NUMBER | Tax registration number |
| TAX_LINE_FLAG | Automatically generated tax line flag |
| TAX_GROUP_ID | Tax group id for automatic tax calculations |
| REFERENCE_6 | Journal entry line reference column |
| REFERENCE_7 | Journal entry line reference column |
| REFERENCE_8 | Journal entry line reference column |
| REFERENCE_9 | Journal entry line reference column |
| LAST_UPDATE_DATE | Standard Who column |
| REFERENCE_10 | Journal entry line reference column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| PERIOD_NAME | Accounting period |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| EFFECTIVE_DATE | Journal entry line debit amount in entered currency |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| STATUS | Journal entry line status |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| General Ledger - GL_ARCHIVE_REFERENCES | Archive table for GL_IMPORT_REFERENCES |
|---|---|
| Column Name | Descritpion |
| JE_BATCH_ID | Journal entry batch defining column |
| REFERENCE_2 | Journal Import reference column |
| REFERENCE_3 | Journal Import reference column |
| REFERENCE_4 | Journal Import reference column |
| REFERENCE_5 | Journal Import reference column |
| REFERENCE_6 | Journal Import reference column |
| REFERENCE_7 | Journal Import reference column |
| REFERENCE_8 | Journal Import reference column |
| REFERENCE_9 | Journal Import reference column |
| REFERENCE_10 | Journal Import reference column |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| JE_HEADER_ID | Journal entry header defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| GL_SL_LINK_ID | Link to associated subledger data |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| JE_LINE_NUM | Journal entry line number |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REFERENCE_1 | Journal Import reference column |
| General Ledger - GL_BC_DUAL | Budgetary control concurrency table |
|---|---|
| Column Name | Descritpion |
| DUMMY | Single column for locking |
| General Ledger - GL_BC_OPTIONS | Budgetary control options |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| DESCRIPTION | Budgetary control option description |
| LAST_UPDATE_LOGIN | Standard Who column |
| BC_OPTION_ID | Budgetary control option defining column |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| BC_OPTION_NAME | Budgetary control option name |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_BC_OPTION_DETAILS | Budgetary control option details |
|---|---|
| Column Name | Descritpion |
| JE_CATEGORY_NAME | Journal entry category user defined name |
| FUNDS_CHECK_LEVEL_CODE | Funds checking severity level |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| OVERRIDE_AMOUNT | Maximum transaction amount that can be used to override a funds check failure |
| BC_OPTION_ID | Budgetary control option defining column |
| TOLERANCE_PERCENTAGE | Percentage of funding budget that can be exceeded |
| TOLERANCE_AMOUNT | Allowable amount to exceed funding budget |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| JE_SOURCE_NAME | Journal entry source user defined name |
| General Ledger - GL_BC_PACKETS | Budgetary control queue table |
|---|---|
| Column Name | Descritpion |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| REFERENCE4 | Journal entry line reference column |
| REFERENCE5 | Journal entry line reference column |
| JE_BATCH_NAME | Journal entry batch name |
| JE_BATCH_ID | Journal entry batch defining column |
| JE_HEADER_ID | Journal entry header defining column |
| JE_LINE_NUM | Journal entry line number |
| JE_LINE_DESCRIPTION | Journal entry line description |
| REFERENCE6 | Journal entry line reference column |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| REFERENCE7 | Journal entry line reference column |
| REFERENCE8 | Journal entry line reference column |
| REFERENCE9 | Journal entry line reference column |
| REFERENCE10 | Journal entry line reference column |
| PERIOD_NAME | Accounting period |
| REFERENCE11 | Journal entry line reference column |
| REFERENCE12 | Journal entry line reference column |
| REFERENCE13 | Journal entry line reference column |
| REFERENCE14 | Journal entry line reference column |
| PERIOD_YEAR | Accounting period year |
| REFERENCE15 | Journal entry line reference column |
| REQUEST_ID | Concurrent request defining column |
| USSGL_PARENT_ID | Identifier for a budgetary transaction containing a |
| USSGL_LINK_TO_PARENT_ID | Identifier of the originating budgetary transaction |
| PERIOD_NUM | Accounting period number |
| EVENT_ID | Business Event identifier |
| AE_HEADER_ID | XLA journal entry header defining column |
| AE_LINE_NUM | XLA journal entry line defining column |
| BC_DATE | Validation Date used for flexfield validations (added for ER 2073811) |
| PACKET_ID | Budgetary control packet defining column |
| QUARTER_NUM | Accounting period quarter |
| SET_OF_BOOKS_ID | Accounting books defining column |
| SOURCE_DISTRIBUTION_TYPE | Source Distribution Type |
| SOURCE_DISTRIBUTION_ID_CHAR_1 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_2 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_3 | Source Reference Column |
| CURRENCY_CODE | Currency |
| SOURCE_DISTRIBUTION_ID_CHAR_4 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_5 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_1 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_2 | Source Reference Column |
| STATUS_CODE | Funds check/reservation status |
| SOURCE_DISTRIBUTION_ID_NUM_3 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_4 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_5 | Source Reference Column |
| SESSION_ID | Session Id of the calling session |
| LAST_UPDATE_DATE | Standard Who column |
| SERIAL_ID | Serial# of the calling session |
| APPLICATION_ID | Source Application Id |
| ENTITY_ID | Entity Identifier |
| GROUP_ID | Interface group identifying column |
| LAST_UPDATED_BY | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| TEMPLATE_ID | Summary template defining column |
| ENTERED_DR | Transaction debit amount in entered currency |
| ENTERED_CR | Transaction credit amount in entered currency |
| LEDGER_ID | Ledger defining column |
| ACCOUNTED_DR | Transaction debit amount in functional currency |
| ACCOUNTED_CR | Transaction credit amount in functional currency |
| USSGL_TRANSACTION_CODE | Government transaction code |
| ORIGINATING_ROWID | Row id of originating budgetary or proprietary transaction for a USSGL generated budgetary or proprietary transaction |
| ACCOUNT_SEGMENT_VALUE | Value of key flexfield account segment |
| AUTOMATIC_ENCUMBRANCE_FLAG | Automatically create encumbrance batch |
| FUNDING_BUDGET_VERSION_ID | Budget version defining column of funding budget |
| FUNDS_CHECK_LEVEL_CODE | Funds checking severity level |
| AMOUNT_TYPE | Amount type (Period to date, year to date, etc.) |
| BOUNDARY_CODE | Budgetary control time interval end point |
| JE_SOURCE_NAME | Journal entry source name |
| TOLERANCE_PERCENTAGE | Percentage of funding budget that can be exceeded |
| TOLERANCE_AMOUNT | Allowable amount to exceed funding budget |
| OVERRIDE_AMOUNT | Maximum transaction amount that can be used to override a funds check failure |
| DR_CR_CODE | Debit or credit transaction |
| ACCOUNT_TYPE | Key flexfield combination type (Asset, liability, ..., Budgetary Dr/Cr) |
| ACCOUNT_CATEGORY_CODE | Key flexfield category (Proprietary or budgetary) |
| EFFECT_ON_FUNDS_CODE | Effect of transaction on funds available, increasing or decreasing |
| RESULT_CODE | Result of funds check/reservation |
| BUDGET_POSTED_BALANCE | Posted balance used in funds available calculation |
| ACTUAL_POSTED_BALANCE | Posted balance used in funds available calculation |
| JE_CATEGORY_NAME | Journal entry category name |
| ENCUMBRANCE_POSTED_BALANCE | Posted balance used in funds available calculation |
| BUDGET_APPROVED_BALANCE | Balance approved, but not posted |
| ACTUAL_APPROVED_BALANCE | Balance approved, but not posted |
| ENCUMBRANCE_APPROVED_BALANCE | Balance approved, but not posted |
| BUDGET_PENDING_BALANCE | Balance pending funds check |
| ACTUAL_PENDING_BALANCE | Balance pending funds check |
| ENCUMBRANCE_PENDING_BALANCE | Balance pending funds check |
| REFERENCE1 | Journal entry line reference column |
| REFERENCE2 | Journal entry line reference column |
| REFERENCE3 | Journal entry line reference column |
| General Ledger - GL_BC_PACKET_ARRIVAL_ORDER | Budgetary control packet processing sequence |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| PACKET_ID | Budgetary control packet defining column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| LEDGER_ID | Ledger defining column |
| ARRIVAL_SEQ | Budgetary control packet arrival order |
| AFFECT_FUNDS_FLAG | Affect packet has on funds availability of later arriving packets |
| General Ledger - GL_BC_PERIOD_MAP | Budgetary control period boundaries |
|---|---|
| Column Name | Descritpion |
| QUERY_PERIOD_NAME | Accounting period name for transactions that affect funds availability |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| CREATION_DATE | Standard Who column |
| LEDGER_ID | Ledger defining column |
| CREATED_BY | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| REQUEST_ID | Concurrent process request id |
| PROGRAM_APPLICATION_ID | Extended Who column |
| PROGRAM_ID | Extended Who column |
| PROGRAM_UPDATE_DATE | Extended Who column |
| BOUNDARY_CODE | Budgetary control time interval end point |
| TRANSACTION_PERIOD_NAME | Accounting period name for transaction awaiting funds check |
| ACTUAL_FLAG | Transaction balance type (Actual, Budget, or Encumbrance) |
| General Ledger - GL_CONCURRENCY_CONTROL | Concurrent process internal locking mechanism |
|---|---|
| Column Name | Descritpion |
| CONCURRENCY_CLASS | Action that is being performed |
| CONCURRENCY_ENTITY_NAME | Entity for which action is being performed |
| CONCURRENCY_ENTITY_ID | The internal ID of the entity for which the action is being performed |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_DOC_SEQUENCE_AUDIT | Sequential numbering audit table |
|---|---|
| Column Name | Descritpion |
| CREATED_BY | Standard Who column |
| DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| DOC_SEQUENCE_ASSIGNMENT_ID | Sequential numbering sequence assignment defining column |
| DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_DYNAMIC_SUMM_COMBINATIONS | Newly created summary account combinations |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATED_BY | Standard Who column |
| CODE_COMBINATION_ID | Key flexfield defining column |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| DYNAMIC_GROUP_ID | Group defining column |
| SEGMENT4 | Key flexfield segment |
| SET_OF_BOOKS_ID | Accounting books defining column |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| LEDGER_ID | Accounting books defining column |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| TEMPLATE_ID | Summary template defining column |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| General Ledger - GL_IMPORT_REFERENCES | Cross-references between subledgers and Oracle General Ledger's journal entries |
|---|---|
| Column Name | Descritpion |
| JE_BATCH_ID | Journal entry batch defining column |
| REFERENCE_2 | Journal Import reference column |
| REFERENCE_3 | Journal Import reference column |
| REFERENCE_4 | Journal Import reference column |
| REFERENCE_5 | Journal Import reference column |
| REFERENCE_6 | Journal Import reference column |
| REFERENCE_7 | Journal Import reference column |
| REFERENCE_8 | Journal Import reference column |
| REFERENCE_9 | Journal Import reference column |
| REFERENCE_10 | Journal Import reference column |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequence defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequence value |
| JE_HEADER_ID | Journal entry header defining column |
| GL_SL_LINK_ID | Link to associated subledger data |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| JE_LINE_NUM | Journal entry line number |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REFERENCE_1 | Journal Import reference column |
| General Ledger - GL_BC_DUAL2 | Budgetary control concurrency table |
|---|---|
| Column Name | Descritpion |
| DUMMY | Single column for locking |
| General Ledger - GL_BC_EVENT_TIMESTAMPS | Budgetary control events (Summary Templates and Budget Assignment Ranges) |
|---|---|
| Column Name | Descritpion |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| EVENT_CODE | Budget assignment range or summary template |
| DATE_TIMESTAMP | Date with time in Hours24:Minutes:Seconds format |
| LAST_UPDATE_DATE | Standard Who column |
| General Ledger - GL_ALLOC_BATCHES | MassAllocations and MassBudget batches |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_BATCH_ID | Mass allocation batch defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| VALIDATION_REQUEST_ID | Batch validation request id |
| DESCRIPTION | Mass allocation batch description |
| SECURITY_FLAG | Enable definition access set security flag |
| NAME | Mass allocation batch name |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| VALIDATION_STATUS | Batch validation result, valid or error |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| General Ledger - GL_ALLOC_FORMULAS | MassAllocations and MassBudget formulas |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_FORMULA_ID | Mass allocation formula defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Formula description |
| CONVERSION_METHOD_CODE | The conversion method for foreign currency MassAllocation formulas. The conversion method can be 'Converted Amount' or 'Calculated Amount' |
| ALLOCATION_BATCH_ID | Mass allocation batch defining column |
| CURRENCY_CONVERSION_TYPE | Type of currency exchange rate |
| NAME | Formula name |
| RUN_SEQUENCE | Not currently used |
| JE_CATEGORY_NAME | Journal entry category |
| FULL_ALLOCATION_FLAG | Full cost pool allocation flag |
| VALIDATION_STATUS | Formula validation result |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_ALLOC_FORMULA_LINES | MassAllocations and MassBudget formula lines |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_FORMULA_ID | Mass allocation formula defining column |
| AMOUNT | Formula line amount |
| RELATIVE_PERIOD | Relative position of the accounting period whose balance is to be used in the allocation formula |
| PERIOD_NAME | Accounting period |
| CURRENCY_CODE | Currency |
| TRANSACTION_CURRENCY_11I | Obsolete |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| AMOUNT_TYPE | Amount type |
| SEGMENT_TYPES_KEY | Concatenated string of segment types (C, L, or S) |
| LINE_NUMBER | Formula line number (1,2,3,4 or 5) |
| SEGMENT_BREAK_KEY | Not currently used |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| LINE_TYPE | Formula line type (Entered, Target, or Offset) |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| OPERATOR | Not currently used (Always "E") |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT30 | Key flexfield segment |
| CURRENCY_TYPE | Currency type: Entered, Total, Statistical |
| LAST_UPDATED_BY | Standard Who column |
| TRANSACTION_CURRENCY | Transaction currency |
| ENTERED_CURRENCY | Entered currency |
| CREATION_DATE | Standard Who column |
| LEDGER_CURRENCY | Ledger currency |
| LEDGER_ID | Ledger defining column |
| CREATED_BY | Standard Who column |
| LEDGER_ACTION_CODE | Ledger action type:(Constant, Summary, or Looping) |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_ALLOC_HISTORY | History of MassAllocation and MassBudget runs |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_BATCH_ID | Allocation batch defining column |
| JOURNAL_EFFECTIVE_DATE | Journal effective date |
| CALCULATION_EFFECTIVE_DATE | Calculation effective date |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| NAME | Allocation Batch name |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ACCESS_SET_ID | Access set defining column |
| SET_OF_BOOKS_ID_11I | Obsolete |
| REQUEST_ID | Allocation concurrent request id |
| RUN_STATUS | Allocation program run status |
| FROM_PERIOD_NAME | Start accounting period |
| TO_PERIOD_NAME | End accounting period |
| TO_PERIOD_NUM | End accounting period number |
| TO_PERIOD_YEAR | End accounting period year |
| General Ledger - GL_ALLOC_INTERIM_1 | Temporary table for MassAllocations and MassBudgets |
|---|---|
| Column Name | Descritpion |
| FORMULA_ID | Mass allocation/budget formula defining column |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| FORMULA_LINE_NUMBER | Allocation/budget formula line number |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| ENTERED_AMOUNT | Amount in entered currency |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| ACCOUNTED_AMOUNT | Amount in base currency |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| General Ledger - GL_ALLOC_INTERIM_2 | Temporary table for MassAllocations and MassBudgets |
|---|---|
| Column Name | Descritpion |
| FORMULA_ID | Mass allocation/budget formula defining column |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| FORMULA_LINE_NUMBER | Allocation/Budget formula line number |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| ENTERED_AMOUNT | Amount in entered currency |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| ACCOUNTED_AMOUNT | Amount in base currency |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| General Ledger - GL_ALLOC_INTERIM_3 | Temporary table for MassAllocations and MassBudgets |
|---|---|
| Column Name | Descritpion |
| FORMULA_ID | Mass allocation/budget formula defining column |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| FORMULA_LINE_NUMBER | Allocation/Budget formula line number |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| ENTERED_AMOUNT | Amount in entered currency |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| ACCOUNTED_AMOUNT | Amount in base currency |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| General Ledger - GL_ALLOC_TARGETS | Temporary table for MassAllocations and MassBudgets |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_FORMULA_ID | Mass Allocation/Budget formula defining column |
| MAX_AMOUNT_FLAG | Line with maximum allocated amount flag |
| DESCRIPTION | Target line description |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| MESSAGE_NUMBER | System message number |
| LINE_TYPE | Formula line type (target) |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| REQUEST_ID | Concurrent process request id |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| ENTERED_AMOUNT | Amount in entered currency |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| ACCOUNTED_AMOUNT | Amount in base currency |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| JE_BATCH_ID | Journal entry batch defining column |
| JE_HEADER_ID | Journal entry header defining column |
| JE_LINE_NUM | Journal entry line number |
| PERIOD_NAME | Accounting period |
| ACCOUNTING_DATE | Date Within target accounting period |
| General Ledger - GL_CAPTURED_INFO | |
|---|---|
| Column Name | Descritpion |
| CONTEXT3 | For Descriptive Flexfield Context |
| ATTRIBUTE11 | For Descriptive Flexfield |
| ATTRIBUTE12 | For Descriptive Flexfield |
| ATTRIBUTE13 | For Descriptive Flexfield |
| ATTRIBUTE14 | For Descriptive Flexfield |
| ATTRIBUTE15 | For Descriptive Flexfield |
| ATTRIBUTE16 | For Descriptive Flexfield |
| ATTRIBUTE17 | For Descriptive Flexfield |
| ATTRIBUTE18 | For Descriptive Flexfield |
| ATTRIBUTE19 | For Descriptive Flexfield |
| ATTRIBUTE20 | For Descriptive Flexfield |
| General Ledger - GL_BALANCES | Account balances for both detail and summary accounts |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| TRANSLATED_FLAG | Translated balance flag |
| REVALUATION_STATUS | Not currently used |
| PERIOD_TYPE | Accounting period type |
| PERIOD_YEAR | Accounting period year |
| PERIOD_NUM | Accounting period number |
| PERIOD_NET_DR | Period net debit balance |
| PERIOD_NET_CR | Period net credit balance |
| PERIOD_TO_DATE_ADB | Not currently used |
| QUARTER_TO_DATE_DR | Quarter to date debit balance |
| QUARTER_TO_DATE_CR | Quarter to date credit balance |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| QUARTER_TO_DATE_ADB | Not currently used |
| SET_OF_BOOKS_ID | Accounting books defining column |
| YEAR_TO_DATE_ADB | Not currently used |
| PROJECT_TO_DATE_DR | Accumulated project debit balance (life to date balance) |
| PROJECT_TO_DATE_CR | Accumulated project credit balance |
| PROJECT_TO_DATE_ADB | Not currently used |
| BEGIN_BALANCE_DR | Beginning debit balance |
| BEGIN_BALANCE_CR | Beginning credit balance |
| PERIOD_NET_DR_BEQ | Period net debit balance, base currency |
| PERIOD_NET_CR_BEQ | Period net credit balance, base currency |
| CURRENCY_CODE | Currency |
| QUARTER_TO_DATE_DR_BEQ | Quarter to date debit balance, base currency |
| PERIOD_NAME | Accounting period |
| QUARTER_TO_DATE_CR_BEQ | Quarter to date credit balance, base currency |
| PROJECT_TO_DATE_DR_BEQ | Accumulated project debit balance (life to date balance), base currency |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| PROJECT_TO_DATE_CR_BEQ | Accumulated project credit balance (life to date balance), base currency |
| LAST_UPDATE_DATE | Standard Who column |
| BEGIN_BALANCE_DR_BEQ | Beginning debit balance, base currency |
| BEGIN_BALANCE_CR_BEQ | Beginning credit balance, base currency |
| LAST_UPDATED_BY | Standard Who column |
| TEMPLATE_ID | Summary template defining column |
| ENCUMBRANCE_DOC_ID | Purchasing encumbrance column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_LINE_NUM | Purchasing encumbrance column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| General Ledger - GL_BUDGETS | Budget definitions |
|---|---|
| Column Name | Descritpion |
| BUDGET_TYPE | Budget type (always STANDARD) |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CURRENT_VERSION_ID | Not currently used |
| LATEST_OPENED_YEAR | Latest year of the budget that is open |
| FIRST_VALID_PERIOD_NAME | Begin accounting period for the budget |
| LAST_VALID_PERIOD_NAME | Final accounting period for the budget |
| DESCRIPTION | Budget description |
| DATE_CLOSED | Date budget was closed |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| BUDGET_NAME | Budget name |
| ATTRIBUTE3 | Descriptive flexfield segment |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| LEDGER_ID | Accounting books defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| STATUS | Budgets status (Open, Closed, Current, etc.) |
| DATE_CREATED | Date budget was created |
| REQUIRE_BUDGET_JOURNALS_FLAG | Journals required for budget |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_BUDGET_ASSIGNMENTS | Budget organization accounts |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| FUNDS_CHECK_LEVEL_CODE | No longer used in R12 |
| ORDERING_VALUE | Key flexfield account segment value |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | No longer used |
| ATTRIBUTE2 | No longer used |
| ATTRIBUTE3 | No longer used |
| ATTRIBUTE4 | No longer used |
| ATTRIBUTE5 | No longer used |
| BUDGET_ENTITY_ID | Budget version defining column |
| ATTRIBUTE6 | No longer used |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE7 | No longer used |
| ATTRIBUTE8 | No longer used |
| CONTEXT | No longer used |
| AMOUNT_TYPE | No longer used in R12 |
| BOUNDARY_CODE | No longer used in R12 |
| FUNDING_BUDGET_VERSION_ID | No longer used in R12 |
| PROGRAM_APPLICATION_ID | Extended Who column |
| PROGRAM_ID | Extended Who column |
| PROGRAM_UPDATE_DATE | Extended Who column |
| CURRENCY_CODE | Currency |
| REQUEST_ID | Concurrent program request id |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| RANGE_ID | Account range assignment defining column |
| ENTRY_CODE | Method to determine account balance (Entered/Calculated) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| AUTOMATIC_ENCUMBRANCE_FLAG | No longer used in R12 |
| General Ledger - GL_BUDGET_BATCHES | Budget formula batches |
|---|---|
| Column Name | Descritpion |
| BUDGET_VERSION_ID | Budget version defining column |
| RECURRING_BATCH_ID | Recurring batch defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| STATUS | Batch status (Frozen or Unfrozen) |
| LAST_EXECUTED_DATE | Date batch last run |
| LAST_EXECUTED_START_PERIOD | Accounting period last run began with |
| LAST_EXECUTED_END_PERIOD | Accounting period last run ended with |
| General Ledger - GL_DAILY_BALANCES | Daily aggregate balances for both detail and summary accounts |
|---|---|
| Column Name | Descritpion |
| PERIOD_END_DATE | End date of the accounting period |
| END_OF_DAY15 | End of day balance for the 15th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY16 | End of day balance for the 16th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY17 | End of day balance for the 17th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY18 | End of day balance for the 18th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY19 | End of day balance for the 19th day of this accounting period. This column is only used for translated balances. |
| QUARTER_START_DATE | Start date of the quarter containing the accounting period |
| END_OF_DAY20 | End of day balance for the 20th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY21 | End of day balance for the 21st day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY22 | End of day balance for the 22nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY23 | End of day balance for the 23rd day of this accounting period. This column is only used for translated balances. |
| YEAR_START_DATE | Start date of the fiscal year containing the accounting period |
| END_OF_DAY24 | End of day balance for the 24th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY25 | End of day balance for the 25th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY26 | End of day balance for the 26th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY27 | End of day balance for the 27th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY28 | End of day balance for the 28th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY29 | End of day balance for the 29th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY30 | End of day balance for the 30th day of this accounting period. This column is only used for translated balances. |
| CREATION_DATE | Standard Who column |
| END_OF_DAY31 | End of day balance for the 31st day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY32 | End of day balance for the 32nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY33 | End of day balance for the 33rd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY34 | End of day balance for the 34th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY35 | End of day balance for the 35th day of this accounting period. This column is only used for translated balances. |
| CREATED_BY | Standard Who column |
| QUARTER_AGGREGATE1 | Aggregate of the end balances of all days in this quarter, up to and including the 1st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE2 | Aggregate of the end balances of all days in this quarter, up to and including the 2nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE3 | Aggregate of the end balances of all days in this quarter, up to and including the 3rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE4 | Aggregate of the end balances of all days in this quarter, up to and including the 4th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATE_DATE | Standard Who column |
| QUARTER_AGGREGATE5 | Aggregate of the end balances of all days in this quarter, up to and including the 5th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE6 | Aggregate of the end balances of all days in this quarter, up to and including the 6th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE7 | Aggregate of the end balances of all days in this quarter, up to and including the 7th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE8 | Aggregate of the end balances of all days in this quarter, up to and including the 8th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE9 | Aggregate of the end balances of all days in this quarter, up to and including the 9th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE10 | Aggregate of the end balances of all days in this quarter, up to and including the 10th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE11 | Aggregate of the end balances of all days in this quarter, up to and including the 11th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE12 | Aggregate of the end balances of all days in this quarter, up to and including the 12th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE13 | Aggregate of the end balances of all days in this quarter, up to and including the 13th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE14 | Aggregate of the end balances of all days in this quarter, up to and including the 13th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATED_BY | Standard Who column |
| QUARTER_AGGREGATE15 | Aggregate of the end balances of all days in this quarter, up to and including the 15th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE16 | Aggregate of the end balances of all days in this quarter, up to and including the 16th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE17 | Aggregate of the end balances of all days in this quarter, up to and including the 17th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE18 | Aggregate of the end balances of all days in this quarter, up to and including the 18th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE19 | Aggregate of the end balances of all days in this quarter, up to and including the 19th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE20 | Aggregate of the end balances of all days in this quarter, up to and including the 20th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE21 | Aggregate of the end balances of all days in this quarter, up to and including the 21st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE22 | Aggregate of the end balances of all days in this quarter, up to and including the 22nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE23 | Aggregate of the end balances of all days in this quarter, up to and including the 23rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE24 | Aggregate of the end balances of all days in this quarter, up to and including the 24th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATE_LOGIN | Standard Who column |
| QUARTER_AGGREGATE25 | Aggregate of the end balances of all days in this quarter, up to and including the 25th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE26 | Aggregate of the end balances of all days in this quarter, up to and including the 26th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE27 | Aggregate of the end balances of all days in this quarter, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE28 | Aggregate of the end balances of all days in this quarter, up to and including the 28th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE29 | Aggregate of the end balances of all days in this quarter, up to and including the 29th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE30 | Aggregate of the end balances of all days in this quarter, up to and including the 30th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE31 | Aggregate of the end balances of all days in this quarter, up to and including the 31st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE32 | Aggregate of the end balances of all days in this quarter, up to and including the 32nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE33 | Aggregate of the end balances of all days in this quarter, up to and including the 33rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE34 | Aggregate of the end balances of all days in this quarter, up to and including the3 4th day of this accounting period. This column is only used for translated balances. |
| CONVERTED_FROM_CURRENCY | Currency the balance was converted from |
| QUARTER_AGGREGATE35 | Aggregate of the end balances of all days in this quarter, up to and including the 35th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE1 | Aggregate of the end balances of all days in this year, up to and including the 1st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE2 | Aggregate of the end balances of all days in this year, up to and including the 2nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE3 | Aggregate of the end balances of all days in this year, up to and including the 3rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE4 | Aggregate of the end balances of all days in this year, up to and including the 4th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE5 | Aggregate of the end balances of all days in this year, up to and including the 5th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE6 | Aggregate of the end balances of all days in this year, up to and including the 6th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE7 | Aggregate of the end balances of all days in this year, up to and including the 7th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE8 | Aggregate of the end balances of all days in this year, up to and including the 7th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE9 | Aggregate of the end balances of all days in this year, up to and including the 9th day of this accounting period. This column is only used for translated balances. |
| PERIOD_TYPE | Accounting period type |
| YEAR_AGGREGATE10 | Aggregate of the end balances of all days in this year, up to and including the 10th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE11 | Aggregate of the end balances of all days in this year, up to and including the 11th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE12 | Aggregate of the end balances of all days in this year, up to and including the 12th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE13 | Aggregate of the end balances of all days in this year, up to and including the 13th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE14 | Aggregate of the end balances of all days in this year, up to and including the 14th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE15 | Aggregate of the end balances of all days in this year, up to and including the 15th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE16 | Aggregate of the end balances of all days in this year, up to and including the 16th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE17 | Aggregate of the end balances of all days in this year, up to and including the 17th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE18 | Aggregate of the end balances of all days in this year, up to and including the 18th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE19 | Aggregate of the end balances of all days in this year, up to and including the 19th day of this accounting period. This column is only used for translated balances. |
| PERIOD_YEAR | Accounting period year |
| YEAR_AGGREGATE20 | Aggregate of the end balances of all days in this year, up to and including the 19th day of this accounting period. This column is only used for translated balances. |
| SET_OF_BOOKS_ID | Accounting books defining column |
| YEAR_AGGREGATE21 | Aggregate of the end balances of all days in this year, up to and including the 21st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE22 | Aggregate of the end balances of all days in this year, up to and including the 22nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE23 | Aggregate of the end balances of all days in this year, up to and including the 23rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE24 | Aggregate of the end balances of all days in this year, up to and including the 24th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE25 | Aggregate of the end balances of all days in this year, up to and including the 25th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE26 | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE27 | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE28 | Aggregate of the end balances of all days in this year, up to and including the 28th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE29 | Aggregate of the end balances of all days in this year, up to and including the 29th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE30 | Aggregate of the end balances of all days in this year, up to and including the 30th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE31 | Aggregate of the end balances of all days in this year, up to and including the 31st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE32 | Aggregate of the end balances of all days in this year, up to and including the 32nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE33 | Aggregate of the end balances of all days in this year, up to and including the 33rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE34 | Aggregate of the end balances of all days in this year, up to and including the 34th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE35 | Aggregate of the end balances of all days in this year, up to and including the 35th day of this accounting period. This column is only used for translated balances. |
| PERIOD_NUM | Accounting period number |
| TEMPLATE_ID | Summary template defining column |
| OPENING_PERIOD_AGGREGATE | End of day balance of the last day of the previous period |
| OPENING_QUARTER_AGGREGATE | Aggregate of the end balances of all days in this quarter before the 1st day of this accounting period. This column is not used for translated balances. |
| LEDGER_ID | Accounting books defining column |
| OPENING_YEAR_AGGREGATE | Aggregate of the end balances of all days in this year before the 1st day of this accounting period. This column is not used for translated balances. |
| PERIOD_AGGREGATE1 | End balance of the 1st day of this accounting period |
| PERIOD_AGGREGATE2 | Aggregate of the end balances of all days in this period, up to and including the 2nd day of this accounting period |
| PERIOD_AGGREGATE3 | Aggregate of the end balances of all days in this period, up to and including the 3rd day of this accounting period |
| PERIOD_AGGREGATE4 | Aggregate of the end balances of all days in this period, up to and including the 4th day of this accounting period |
| PERIOD_AGGREGATE5 | Aggregate of the end balances of all days in this period, up to and including the 5th day of this accounting period |
| PERIOD_AGGREGATE6 | Aggregate of the end balances of all days in this period, up to and including the 5th day of this accounting period |
| PERIOD_AGGREGATE7 | Aggregate of the end balances of all days in this period, up to and including the 8th day of this accounting period |
| PERIOD_AGGREGATE8 | Aggregate of the end balances of all days in this period, up to and including the 8th day of this accounting period |
| PERIOD_AGGREGATE9 | Aggregate of the end balances of all days in this period, up to and including the 9th day of this accounting period |
| CODE_COMBINATION_ID | Key Flexfield combination defining column |
| PERIOD_AGGREGATE10 | Aggregate of the end balances of all days in this period, up to and including the 10th day of this accounting period |
| PERIOD_AGGREGATE11 | Aggregate of the end balances of all days in this period, up to and including the 11th day of this accounting period |
| PERIOD_AGGREGATE12 | Aggregate of the end balances of all days in this period, up to and including the 12th day of this accounting period |
| PERIOD_AGGREGATE13 | Aggregate of the end balances of all days in this period, up to and including the 13th day of this accounting period |
| PERIOD_AGGREGATE14 | Aggregate of the end balances of all days in this period, up to and including the 14th day of this accounting period |
| PERIOD_AGGREGATE15 | Aggregate of the end balances of all days in this period, up to and including the 15th day of this accounting period |
| PERIOD_AGGREGATE16 | Aggregate of the end balances of all days in this period, up to and including the 16th day of this accounting period |
| PERIOD_AGGREGATE17 | Aggregate of the end balances of all days in this period, up to and including the 17th day of this accounting period |
| PERIOD_AGGREGATE18 | Aggregate of the end balances of all days in this period, up to and including the 18th day of this accounting period |
| PERIOD_AGGREGATE19 | Aggregate of the end balances of all days in this period, up to and including the 19th day of this accounting period |
| CURRENCY_CODE | Currency |
| PERIOD_AGGREGATE20 | Aggregate of the end balances of all days in this period, up to and including the 20th day of this accounting period |
| PERIOD_AGGREGATE21 | Aggregate of the end balances of all days in this period, up to and including the 21st day of this accounting period |
| PERIOD_AGGREGATE22 | Aggregate of the end balances of all days in this period, up to and including the 22nd day of this accounting period |
| PERIOD_AGGREGATE23 | Aggregate of the end balances of all days in this period, up to and including the 23rd day of this accounting period |
| PERIOD_AGGREGATE24 | Aggregate of the end balances of all days in this period, up to and including the 24th day of this accounting period |
| PERIOD_AGGREGATE25 | Aggregate of the end balances of all days in this period, up to and including the 25th day of this accounting period |
| PERIOD_AGGREGATE26 | Aggregate of the end balances of all days in this period, up to and including the 26th day of this accounting period |
| PERIOD_AGGREGATE27 | Aggregate of the end balances of all days in this period, up to and including the 26th day of this accounting period |
| PERIOD_AGGREGATE28 | Aggregate of the end balances of all days in this period, up to and including the 28th day of this accounting period |
| PERIOD_AGGREGATE29 | Aggregate of the end balances of all days in this period, up to and including the 29th day of this accounting period |
| CURRENCY_TYPE | Currency type |
| PERIOD_AGGREGATE30 | Aggregate of the end balances of all days in this period, up to and including the 30th day of this accounting period |
| PERIOD_AGGREGATE31 | Aggregate of the end balances of all days in this period, up to and including the 31st day of this accounting period |
| PERIOD_AGGREGATE32 | Aggregate of the end balances of all days in this period, up to and including the 32nd day of this accounting period |
| PERIOD_AGGREGATE33 | Aggregate of the end balances of all days in this period, up to and including the 33rd day of this accounting period |
| PERIOD_AGGREGATE34 | Aggregate of the end balances of all days in this period, up to and including the 34th day of this accounting period |
| PERIOD_AGGREGATE35 | Aggregate of the end balances of all days in this period, up to and including the 35th day of this accounting period |
| END_OF_DAY1 | End of day balance for the 1st day of this accounting period. This column is only used for translated balances. |
| ACTUAL_FLAG | Always 'A' |
| END_OF_DAY2 | End of day balance for the 2nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY3 | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY4 | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY5 | End of day balance for the 5th day of this accounting period. This column is only used for translated balances. |
| PERIOD_NAME | Accounting Period |
| END_OF_DAY6 | End of day balance for the 6th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY7 | End of day balance for the 7th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY8 | End of day balance for the 8th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY9 | End of day balance for the 9th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY10 | End of day balance for the 10th day of this accounting period. This column is only used for translated balances. |
| PERIOD_START_DATE | Start date of the accounting period |
| END_OF_DAY11 | End of day balance for the 11th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY12 | End of day balance for the 12th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY13 | End of day balance for the 13th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY14 | End of day balance for the 14th day of this accounting period. This column is only used for translated balances. |
| General Ledger - GL_DATE_PERIOD_MAP | Date to period mappings |
|---|---|
| Column Name | Descritpion |
| PERIOD_SET_NAME | Period Set (Calendar) defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ACCOUNTING_DATE | Accounting date |
| PERIOD_NAME | Accounting period |
| PERIOD_TYPE | Period Type defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_BUDGET_ENTITIES | Budget organization definitions |
|---|---|
| Column Name | Descritpion |
| BUDGET_ENTITY_ID | Budget organization defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ENCRYPTED_BUDGET_PASSWORD | Encrypted budget organization password |
| DESCRIPTION | Budget Organization description |
| START_DATE | Date before which your Budget Organization is not active |
| END_DATE | Date after which your Budget Organization is no longer active |
| SEGMENT1_TYPE | Segment order column |
| SEGMENT2_TYPE | Segment order column |
| SEGMENT3_TYPE | Segment order column |
| SEGMENT4_TYPE | Segment order column |
| SEGMENT5_TYPE | Segment order column |
| NAME | Budget organization name |
| SEGMENT6_TYPE | Segment order column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| SEGMENT7_TYPE | Segment order column |
| SEGMENT8_TYPE | Segment order column |
| SEGMENT9_TYPE | Segment order column |
| SEGMENT10_TYPE | Segment order column |
| SEGMENT11_TYPE | Segment order column |
| SEGMENT12_TYPE | Segment order column |
| SEGMENT13_TYPE | Segment order column |
| SEGMENT14_TYPE | Segment order column |
| SEGMENT15_TYPE | Segment order column |
| LEDGER_ID | Accounting books defining column |
| SEGMENT16_TYPE | Segment order column |
| SEGMENT17_TYPE | Segment order column |
| SEGMENT18_TYPE | Segment order column |
| SEGMENT19_TYPE | Segment order column |
| SEGMENT20_TYPE | Segment order column |
| SEGMENT21_TYPE | Segment order column |
| SEGMENT22_TYPE | Segment order column |
| SEGMENT23_TYPE | Segment order column |
| SEGMENT24_TYPE | Segment order column |
| SEGMENT25_TYPE | Segment order column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT26_TYPE | Segment order column |
| SEGMENT27_TYPE | Segment order column |
| SEGMENT28_TYPE | Segment order column |
| SEGMENT29_TYPE | Segment order column |
| SEGMENT30_TYPE | Segment order column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| PROGRAM_APPLICATION_ID | Extended Who column |
| PROGRAM_ID | Extended Who column |
| PROGRAM_UPDATE_DATE | Extended Who column |
| REQUEST_ID | Concurrent program request id |
| BUDGET_PASSWORD_REQUIRED_FLAG | Budget Organization password required flag |
| SECURITY_FLAG | |
| STATUS_CODE | Budget organization status ('C'urrent or 'D'eleted) |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| General Ledger - GL_BUDGET_INTERFACE | Upload budget data from external sources |
|---|---|
| Column Name | Descritpion |
| BUDGET_NAME | Budget version name |
| PERIOD_TYPE | Accounting period type |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| DR_FLAG | Debit/Credit flag |
| LEDGER_ID | |
| STATUS | Line error status |
| ACCOUNT_TYPE | Key flexfield combination type (Asset, Liability, etc.) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| REQUEST_ID | Concurrent program request id |
| PERIOD1_AMOUNT | Budget period amount |
| PERIOD2_AMOUNT | Budget period amount |
| PERIOD3_AMOUNT | Budget period amount |
| BUDGET_ENTITY_NAME | Budget organization name |
| PERIOD4_AMOUNT | Budget period amount |
| PERIOD5_AMOUNT | Budget period amount |
| PERIOD6_AMOUNT | Budget period amount |
| PERIOD7_AMOUNT | Budget period amount |
| PERIOD8_AMOUNT | Budget period amount |
| PERIOD9_AMOUNT | Budget period amount |
| PERIOD10_AMOUNT | Budget period amount |
| PERIOD11_AMOUNT | Budget period amount |
| PERIOD12_AMOUNT | Budget period amount |
| PERIOD13_AMOUNT | Budget period amount |
| CURRENCY_CODE | Currency |
| PERIOD14_AMOUNT | Budget period amount |
| PERIOD15_AMOUNT | Budget period amount |
| PERIOD16_AMOUNT | Budget period amount |
| PERIOD17_AMOUNT | Budget period amount |
| PERIOD18_AMOUNT | Budget period amount |
| PERIOD19_AMOUNT | Budget period amount |
| PERIOD20_AMOUNT | Budget period amount |
| PERIOD21_AMOUNT | Budget period amount |
| PERIOD22_AMOUNT | Budget period amount |
| PERIOD23_AMOUNT | Budget period amount |
| FISCAL_YEAR | Fiscal year |
| PERIOD24_AMOUNT | Budget period amount |
| PERIOD25_AMOUNT | Budget period amount |
| PERIOD26_AMOUNT | Budget period amount |
| PERIOD27_AMOUNT | Budget period amount |
| PERIOD28_AMOUNT | Budget period amount |
| PERIOD29_AMOUNT | Budget period amount |
| PERIOD30_AMOUNT | Budget period amount |
| PERIOD31_AMOUNT | Budget period amount |
| PERIOD32_AMOUNT | Budget period amount |
| PERIOD33_AMOUNT | Budget period amount |
| UPDATE_LOGIC_TYPE | Method used to update budget balances ('A' for add, 'R' for replace) |
| PERIOD34_AMOUNT | Budget period amount |
| PERIOD35_AMOUNT | Budget period amount |
| PERIOD36_AMOUNT | Budget period amount |
| PERIOD37_AMOUNT | Budget period amount |
| PERIOD38_AMOUNT | Budget period amount |
| PERIOD39_AMOUNT | Budget period amount |
| PERIOD40_AMOUNT | Budget period amount |
| PERIOD41_AMOUNT | Budget period amount |
| PERIOD42_AMOUNT | Budget period amount |
| PERIOD43_AMOUNT | Budget period amount |
| BUDGET_ENTITY_ID | Budget organization defining column |
| PERIOD44_AMOUNT | Budget period amount |
| PERIOD45_AMOUNT | Budget period amount |
| PERIOD46_AMOUNT | Budget period amount |
| PERIOD47_AMOUNT | Budget period amount |
| PERIOD48_AMOUNT | Budget period amount |
| PERIOD49_AMOUNT | Budget period amount |
| PERIOD50_AMOUNT | Budget period amount |
| PERIOD51_AMOUNT | Budget period amount |
| PERIOD52_AMOUNT | Budget period amount |
| PERIOD53_AMOUNT | Budget period amount |
| SET_OF_BOOKS_ID | Accounting books defining column |
| PERIOD54_AMOUNT | Budget period amount |
| PERIOD55_AMOUNT | Budget period amount |
| PERIOD56_AMOUNT | Budget period amount |
| PERIOD57_AMOUNT | Budget period amount |
| PERIOD58_AMOUNT | Budget period amount |
| PERIOD59_AMOUNT | Budget period amount |
| PERIOD60_AMOUNT | Budget period amount |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| BUDGET_VERSION_ID | Budget version defining column |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| General Ledger - GL_BUDGET_INTERIM | Budget posting interim balances |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Accounting books defining column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| ACCOUNT_TYPE | Account type lookup (Asset, Liability, etc) |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| DR_FLAG | Debit amount flag |
| TRANSLATED_FLAG | Translated balance flag |
| TEMPLATE_ID | Summary template defining column |
| PERIOD1_AMOUNT | Budget period amount |
| PERIOD2_AMOUNT | Budget period amount |
| PERIOD3_AMOUNT | Budget period amount |
| PERIOD4_AMOUNT | Budget period amount |
| PERIOD5_AMOUNT | Budget period amount |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| PERIOD6_AMOUNT | Budget period amount |
| PERIOD7_AMOUNT | Budget period amount |
| PERIOD8_AMOUNT | Budget period amount |
| PERIOD9_AMOUNT | Budget period amount |
| PERIOD10_AMOUNT | Budget period amount |
| PERIOD11_AMOUNT | Budget period amount |
| PERIOD12_AMOUNT | Budget period amount |
| PERIOD13_AMOUNT | Budget period amount |
| PERIOD14_AMOUNT | Budget period amount |
| PERIOD15_AMOUNT | Budget period amount |
| CURRENCY_CODE | Currency |
| PERIOD16_AMOUNT | Budget period amount |
| PERIOD17_AMOUNT | Budget period amount |
| PERIOD18_AMOUNT | Budget period amount |
| PERIOD19_AMOUNT | Budget period amount |
| PERIOD20_AMOUNT | Budget period amount |
| PERIOD21_AMOUNT | Budget period amount |
| PERIOD22_AMOUNT | Budget period amount |
| PERIOD23_AMOUNT | Budget period amount |
| PERIOD24_AMOUNT | Budget period amount |
| PERIOD25_AMOUNT | Budget period amount |
| BUDGET_VERSION_ID | Budget version defining column |
| PERIOD26_AMOUNT | Budget period amount |
| PERIOD27_AMOUNT | Budget period amount |
| PERIOD28_AMOUNT | Budget period amount |
| PERIOD29_AMOUNT | Budget period amount |
| PERIOD30_AMOUNT | Budget period amount |
| PERIOD31_AMOUNT | Budget period amount |
| PERIOD32_AMOUNT | Budget period amount |
| PERIOD33_AMOUNT | Budget period amount |
| PERIOD34_AMOUNT | Budget period amount |
| PERIOD35_AMOUNT | Budget period amount |
| BUDGET_ENTITY_ID | Budget organization defining column |
| PERIOD36_AMOUNT | Budget period amount |
| PERIOD37_AMOUNT | Budget period amount |
| PERIOD38_AMOUNT | Budget period amount |
| PERIOD39_AMOUNT | Budget period amount |
| PERIOD40_AMOUNT | Budget period amount |
| PERIOD41_AMOUNT | Budget period amount |
| PERIOD42_AMOUNT | Budget period amount |
| PERIOD43_AMOUNT | Budget period amount |
| PERIOD44_AMOUNT | Budget period amount |
| PERIOD45_AMOUNT | Budget period amount |
| PERIOD_YEAR | Accounting period year |
| PERIOD46_AMOUNT | Budget period amount |
| PERIOD47_AMOUNT | Budget period amount |
| PERIOD48_AMOUNT | Budget period amount |
| PERIOD49_AMOUNT | Budget period amount |
| PERIOD50_AMOUNT | Budget period amount |
| PERIOD51_AMOUNT | Budget period amount |
| PERIOD52_AMOUNT | Budget period amount |
| PERIOD53_AMOUNT | Budget period amount |
| PERIOD54_AMOUNT | Budget period amount |
| PERIOD55_AMOUNT | Budget period amount |
| PERIOD_TYPE | Accounting period type |
| PERIOD56_AMOUNT | Budget period amount |
| PERIOD57_AMOUNT | Budget period amount |
| PERIOD58_AMOUNT | Budget period amount |
| PERIOD59_AMOUNT | Budget period amount |
| PERIOD60_AMOUNT | Budget period amount |
| SUM10 | Period (1 - 10) budget sum |
| SUM20 | Period (11 - 20) budget sum |
| SUM30 | Period (21 - 30) budget sum |
| SUM40 | Period (31 - 40) budget sum |
| SUM50 | Period (41 - 50) budget sum |
| STATUS_NUMBER | Accounting period number |
| SUM60 | Period (51 - 60) budget sum |
| YEAR_TO_DATE | Year to date budget amount |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| General Ledger - GL_BUDGET_TYPES | Budget type definitions |
|---|---|
| Column Name | Descritpion |
| BUDGET_TYPE | Budget type defining column (always STANDARD) |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flex context column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| AUDIT_TRAIL_FLAG | Provide audit trail flag |
| DESCRIPTION | Budget type description |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| General Ledger - GL_ARCHIVE_DAILY_BALANCES | Archive daily aggregate balances |
|---|---|
| Column Name | Descritpion |
| PERIOD_END_DATE | End date of the accounting period |
| END_OF_DAY15 | End of day balance for the 15th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY16 | End of day balance for the 16th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY17 | End of day balance for the 17th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY18 | End of day balance for the 18th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY19 | End of day balance for the 19th day of this accounting period. This column is only used for translated balances. |
| QUARTER_START_DATE | Start date of the quarter containing the accounting period |
| END_OF_DAY20 | End of day balance for the 20th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY21 | End of day balance for the 21st day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY22 | End of day balance for the 22nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY23 | End of day balance for the 23rd day of this accounting period. This column is only used for translated balances. |
| YEAR_START_DATE | Start date of the fiscal year containing the accounting period |
| END_OF_DAY24 | End of day balance for the 24th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY25 | End of day balance for the 25th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY26 | End of day balance for the 26th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY27 | End of day balance for the 27th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY28 | End of day balance for the 28th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY29 | End of day balance for the 29th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY30 | End of day balance for the 30th day of this accounting period. This column is only used for translated balances. |
| CREATION_DATE | Standard Who column |
| END_OF_DAY31 | End of day balance for the 31st day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY32 | End of day balance for the 32nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY33 | End of day balance for the 33rd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY34 | End of day balance for the 34th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY35 | End of day balance for the 35th day of this accounting period. This column is only used for translated balances. |
| CREATED_BY | Standard Who column |
| QUARTER_AGGREGATE1 | Aggregate of the end balances of all days in this quarter, up to and including the 1st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE2 | Aggregate of the end balances of all days in this quarter, up to and including the 2nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE3 | Aggregate of the end balances of all days in this quarter, up to and including the 3rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE4 | Aggregate of the end balances of all days in this quarter, up to and including the 4th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATE_DATE | Standard Who column |
| QUARTER_AGGREGATE5 | Aggregate of the end balances of all days in this quarter, up to and including the 5th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE6 | Aggregate of the end balances of all days in this quarter, up to and including the 6th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE7 | Aggregate of the end balances of all days in this quarter, up to and including the 7th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE8 | Aggregate of the end balances of all days in this quarter, up to and including the 8th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE9 | Aggregate of the end balances of all days in this quarter, up to and including the 9th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE10 | Aggregate of the end balances of all days in this quarter, up to and including the 10th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE11 | Aggregate of the end balances of all days in this quarter, up to and including the 11th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE12 | Aggregate of the end balances of all days in this quarter, up to and including the 12th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE13 | Aggregate of the end balances of all days in this quarter, up to and including the 13th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE14 | Aggregate of the end balances of all days in this quarter, up to and including the 14th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATED_BY | Standard Who column |
| QUARTER_AGGREGATE15 | Aggregate of the end balances of all days in this quarter, up to and including the 15th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE16 | Aggregate of the end balances of all days in this quarter, up to and including the 16th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE17 | Aggregate of the end balances of all days in this quarter, up to and including the 17th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE18 | Aggregate of the end balances of all days in this quarter, up to and including the 18th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE19 | Aggregate of the end balances of all days in this quarter, up to and including the 19th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE20 | Aggregate of the end balances of all days in this quarter, up to and including the 20th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE21 | Aggregate of the end balances of all days in this quarter, up to and including the 21st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE22 | Aggregate of the end balances of all days in this quarter, up to and including the 22nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE23 | Aggregate of the end balances of all days in this quarter, up to and including the 23rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE24 | Aggregate of the end balances of all days in this quarter, up to and including the 24th day of this accounting period. This column is only used for translated balances. |
| LAST_UPDATE_LOGIN | Standard Who column |
| QUARTER_AGGREGATE25 | Aggregate of the end balances of all days in this quarter, up to and including the 25th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE26 | Aggregate of the end balances of all days in this quarter, up to and including the 26th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE27 | Aggregate of the end balances of all days in this quarter, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE28 | Aggregate of the end balances of all days in this quarter, up to and including the 28th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE29 | Aggregate of the end balances of all days in this quarter, up to and including the 29th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE30 | Aggregate of the end balances of all days in this quarter, up to and including the 30th day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE31 | Aggregate of the end balances of all days in this quarter, up to and including the 31st day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE32 | Aggregate of the end balances of all days in this quarter, up to and including the 32nd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE33 | Aggregate of the end balances of all days in this quarter, up to and including the 33rd day of this accounting period. This column is only used for translated balances. |
| QUARTER_AGGREGATE34 | Aggregate of the end balances of all days in this quarter, up to and including the3 4th day of this accounting period. This column is only used for translated balances. |
| CONVERTED_FROM_CURRENCY | Currency the balance was converted from |
| QUARTER_AGGREGATE35 | Aggregate of the end balances of all days in this quarter, up to and including the 35th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE1 | Aggregate of the end balances of all days in this year, up to and including the 1st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE2 | Aggregate of the end balances of all days in this year, up to and including the 2nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE3 | Aggregate of the end balances of all days in this year, up to and including the 3rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE4 | Aggregate of the end balances of all days in this year, up to and including the 4th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE5 | Aggregate of the end balances of all days in this year, up to and including the 5th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE6 | Aggregate of the end balances of all days in this year, up to and including the 6th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE7 | Aggregate of the end balances of all days in this year, up to and including the 7th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE8 | Aggregate of the end balances of all days in this year, up to and including the 8th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE9 | Aggregate of the end balances of all days in this year, up to and including the 9th day of this accounting period. This column is only used for translated balances. |
| PERIOD_TYPE | Accounting period type |
| YEAR_AGGREGATE10 | Aggregate of the end balances of all days in this year, up to and including the 10th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE11 | Aggregate of the end balances of all days in this year, up to and including the 11th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE12 | Aggregate of the end balances of all days in this year, up to and including the 12th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE13 | Aggregate of the end balances of all days in this year, up to and including the 13th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE14 | Aggregate of the end balances of all days in this year, up to and including the 14th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE15 | Aggregate of the end balances of all days in this year, up to and including the 15th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE16 | Aggregate of the end balances of all days in this year, up to and including the 16th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE17 | Aggregate of the end balances of all days in this year, up to and including the 17th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE18 | Aggregate of the end balances of all days in this year, up to and including the 18th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE19 | Aggregate of the end balances of all days in this year, up to and including the 19th day of this accounting period. This column is only used for translated balances. |
| PERIOD_YEAR | Accounting period year |
| YEAR_AGGREGATE20 | Aggregate of the end balances of all days in this year, up to and including the 20th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE21 | Aggregate of the end balances of all days in this year, up to and including the 21st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE22 | Aggregate of the end balances of all days in this year, up to and including the 22nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE23 | Aggregate of the end balances of all days in this year, up to and including the 23rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE24 | Aggregate of the end balances of all days in this year, up to and including the 24th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE25 | Aggregate of the end balances of all days in this year, up to and including the 25th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE26 | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE27 | Aggregate of the end balances of all days in this year, up to and including the 27th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE28 | Aggregate of the end balances of all days in this year, up to and including the 28th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE29 | Aggregate of the end balances of all days in this year, up to and including the 29th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE30 | Aggregate of the end balances of all days in this year, up to and including the 30th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE31 | Aggregate of the end balances of all days in this year, up to and including the 31st day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE32 | Aggregate of the end balances of all days in this year, up to and including the 32nd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE33 | Aggregate of the end balances of all days in this year, up to and including the 33rd day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE34 | Aggregate of the end balances of all days in this year, up to and including the 34th day of this accounting period. This column is only used for translated balances. |
| YEAR_AGGREGATE35 | Aggregate of the end balances of all days in this year, up to and including the 35th day of this accounting period. This column is only used for translated balances. |
| PERIOD_NUM | Accounting period number |
| TEMPLATE_ID | Summary template defining column |
| OPENING_PERIOD_AGGREGATE | End of day balance for the last day in the previous period. This column is not used for translated balances. |
| OPENING_QUARTER_AGGREGATE | Aggregate of the end balances of all days in this quarter before the 1st day of this accounting period. This column is not used for translated balances. |
| SET_OF_BOOKS_ID | Accounting books defining column |
| OPENING_YEAR_AGGREGATE | Aggregate of the end balances of all days in this year before the 1st day of this accounting period. This column is not used for translated balances. |
| PERIOD_AGGREGATE1 | End balance of the 1st day of this accounting period |
| PERIOD_AGGREGATE2 | Aggregate of the end balances of all days in this period, up to and including the 2nd day of this accounting period |
| PERIOD_AGGREGATE3 | Aggregate of the end balances of all days in this period, up to and including the 3rd day of this accounting period |
| PERIOD_AGGREGATE4 | Aggregate of the end balances of all days in this period, up to and including the 4th day of this accounting period |
| PERIOD_AGGREGATE5 | Aggregate of the end balances of all days in this period, up to and including the 5th day of this accounting period |
| PERIOD_AGGREGATE6 | Aggregate of the end balances of all days in this period, up to and including the 6th day of this accounting period |
| PERIOD_AGGREGATE7 | Aggregate of the end balances of all days in this period, up to and including the 7th day of this accounting period |
| PERIOD_AGGREGATE8 | Aggregate of the end balances of all days in this period, up to and including the 8th day of this accounting period |
| PERIOD_AGGREGATE9 | Aggregate of the end balances of all days in this period, up to and including the 9th day of this accounting period |
| CODE_COMBINATION_ID | Key Flexfield combination defining column |
| PERIOD_AGGREGATE10 | Aggregate of the end balances of all days in this period, up to and including the 10th day of this accounting period |
| PERIOD_AGGREGATE11 | Aggregate of the end balances of all days in this period, up to and including the 11th day of this accounting period |
| PERIOD_AGGREGATE12 | Aggregate of the end balances of all days in this period, up to and including the 12th day of this accounting period |
| PERIOD_AGGREGATE13 | Aggregate of the end balances of all days in this period, up to and including the 13th day of this accounting period |
| PERIOD_AGGREGATE14 | Aggregate of the end balances of all days in this period, up to and including the 14th day of this accounting period |
| PERIOD_AGGREGATE15 | Aggregate of the end balances of all days in this period, up to and including the 15th day of this accounting period |
| PERIOD_AGGREGATE16 | Aggregate of the end balances of all days in this period, up to and including the 16th day of this accounting period |
| PERIOD_AGGREGATE17 | Aggregate of the end balances of all days in this period, up to and including the 17th day of this accounting period |
| PERIOD_AGGREGATE18 | Aggregate of the end balances of all days in this period, up to and including the 18th day of this accounting period |
| PERIOD_AGGREGATE19 | Aggregate of the end balances of all days in this period, up to and including the 19th day of this accounting period |
| CURRENCY_CODE | Currency |
| PERIOD_AGGREGATE20 | Aggregate of the end balances of all days in this period, up to and including the 20th day of this accounting period |
| PERIOD_AGGREGATE21 | Aggregate of the end balances of all days in this period, up to and including the 21st day of this accounting period |
| PERIOD_AGGREGATE22 | Aggregate of the end balances of all days in this period, up to and including the 22nd day of this accounting period |
| PERIOD_AGGREGATE23 | Aggregate of the end balances of all days in this period, up to and including the 23rd day of this accounting period |
| PERIOD_AGGREGATE24 | Aggregate of the end balances of all days in this period, up to and including the 24th day of this accounting period |
| PERIOD_AGGREGATE25 | Aggregate of the end balances of all days in this period, up to and including the 25th day of this accounting period |
| PERIOD_AGGREGATE26 | Aggregate of the end balances of all days in this period, up to and including the 26th day of this accounting period |
| PERIOD_AGGREGATE27 | Aggregate of the end balances of all days in this period, up to and including the 27th day of this accounting period |
| PERIOD_AGGREGATE28 | Aggregate of the end balances of all days in this period, up to and including the 28th day of this accounting period |
| PERIOD_AGGREGATE29 | Aggregate of the end balances of all days in this period, up to and including the 29th day of this accounting period |
| CURRENCY_TYPE | 'E', 'C', 'U', 'O', 'T': E - Entered, C - Converted, U - Cumulative, O - Out of date translation, T - Up-to-date translation |
| PERIOD_AGGREGATE30 | Aggregate of the end balances of all days in this period, up to and including the 30th day of this accounting period |
| PERIOD_AGGREGATE31 | Aggregate of the end balances of all days in this period, up to and including the 31st day of this accounting period |
| PERIOD_AGGREGATE32 | Aggregate of the end balances of all days in this period, up to and including the 32nd day of this accounting period |
| PERIOD_AGGREGATE33 | Aggregate of the end balances of all days in this period, up to and including the 33rd day of this accounting period |
| PERIOD_AGGREGATE34 | Aggregate of the end balances of all days in this period, up to and including the 34th day of this accounting period |
| PERIOD_AGGREGATE35 | Aggregate of the end balances of all days in this period, up to and including the 35th day of this accounting period |
| END_OF_DAY1 | End of day balance for the 1st day of this accounting period. This column is only used for translated balances. |
| ACTUAL_FLAG | Always 'A': A - Actual |
| END_OF_DAY2 | End of day balance for the 2nd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY3 | End of day balance for the 3rd day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY4 | End of day balance for the 4th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY5 | End of day balance for the 5th day of this accounting period. This column is only used for translated balances. |
| PERIOD_NAME | Accounting Period |
| END_OF_DAY6 | End of day balance for the 6th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY7 | End of day balance for the 7th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY8 | End of day balance for the 8th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY9 | End of day balance for the 9th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY10 | End of day balance for the 10th day of this accounting period. This column is only used for translated balances. |
| PERIOD_START_DATE | Start date of the accounting period |
| END_OF_DAY11 | End of day balance for the 11th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY12 | End of day balance for the 12th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY13 | End of day balance for the 13th day of this accounting period. This column is only used for translated balances. |
| END_OF_DAY14 | End of day balance for the 14th day of this accounting period. This column is only used for translated balances. |
| General Ledger - GL_BUDGET_VERSIONS | Budget version definitions |
|---|---|
| Column Name | Descritpion |
| BUDGET_VERSION_ID | Budget version defining column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Budget version description |
| DATE_ACTIVE | Not currently used |
| DATE_ARCHIVED | Not currently used |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| CONTROL_BUDGET_VERSION_ID | Control budget defining column |
| LAST_UPDATED_BY | Standard Who column |
| IGI_BUD_NYC_FLAG | Next year create flag |
| BUDGET_TYPE | Budget type(only STANDARD is used) |
| BUDGET_NAME | Budget Name |
| VERSION_NUM | Not currently used |
| STATUS | Version status lookup code |
| DATE_OPENED | Not currently used |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_CODE_COMBINATIONS | Account combinations |
|---|---|
| Column Name | Descritpion |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| SEGMENT1 | Key flexfield segment |
| SEGMENT_ATTRIBUTE42 | Reporting attribute key flexfield segment |
| REFERENCE1 | Reserved for localization use |
| REFERENCE2 | Reserved for localization use |
| REFERENCE3 | Reserved for localization use |
| REFERENCE4 | Reserved for localization use |
| SEGMENT2 | Key flexfield segment |
| REFERENCE5 | Reserved for localization use |
| JGZZ_RECON_FLAG | Global reconciliation descriptive flexfield segment |
| JGZZ_RECON_CONTEXT | Global reconciliation descriptive flexfield context column |
| PRESERVE_FLAG | Preserve segment value attributes flag |
| REFRESH_FLAG | Refresh segment value attributes flag |
| SEGMENT3 | Key flexfield segment |
| IGI_BALANCED_BUDGET_FLAG | Balance budget enforcement flag |
| COMPANY_COST_CENTER_ORG_ID | Organization defining column for the organization associated with the accounts' company/cost center combination. |
| SEGMENT4 | Key flexfield segment |
| REVALUATION_ID | Revaluation defining column |
| LEDGER_SEGMENT | |
| SEGMENT5 | Key flexfield segment |
| LEDGER_TYPE_CODE | |
| ALTERNATE_CODE_COMBINATION_ID | |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| DESCRIPTION | Key flexfield description |
| TEMPLATE_ID | Summary template defining column |
| ALLOCATION_CREATE_FLAG | Not currently used |
| START_DATE_ACTIVE | Date before which key flexfield combination is invalid |
| END_DATE_ACTIVE | Date after which key flexfield combination is invalid |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| DETAIL_POSTING_ALLOWED_FLAG | Detail posting flag |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONTEXT | Descriptive flex context column |
| SEGMENT_ATTRIBUTE1 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE2 | Reporting attribute key flexfield segment |
| DETAIL_BUDGETING_ALLOWED_FLAG | Detail budgeting flag |
| SEGMENT_ATTRIBUTE3 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE4 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE5 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE6 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE7 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE8 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE9 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE10 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE11 | Reporting attribute key flexfield segment |
| ACCOUNT_TYPE | Key flexfield combination type (Asset, Liability, etc) |
| SEGMENT_ATTRIBUTE12 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE13 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE14 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE15 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE16 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE17 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE18 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE19 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE20 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE21 | Reporting attribute key flexfield segment |
| ENABLED_FLAG | Key flexfield enabled flag |
| SEGMENT_ATTRIBUTE22 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE23 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE24 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE25 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE26 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE27 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE28 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE29 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE30 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE31 | Reporting attribute key flexfield segment |
| SUMMARY_FLAG | Summary account flag |
| SEGMENT_ATTRIBUTE32 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE33 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE34 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE35 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE36 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE37 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE38 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE39 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE40 | Reporting attribute key flexfield segment |
| SEGMENT_ATTRIBUTE41 | Reporting attribute key flexfield segment |
| General Ledger - GL_CONSOLIDATION | Consolidation definitions |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_ID | Consolidation defining column |
| USAGE_CODE | Consolidation Usage (Standard, Average, or Standard & Average) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| RUN_JOURNAL_IMPORT_FLAG | Run journal import flag |
| SUMMARIZE_LINES_FLAG | Run journal import in summary mode flag |
| END_DATE_ACTIVE | Date on which consolidation becomes invalid |
| AUDIT_MODE_FLAG | Run journal import in audit mode flag |
| DESCRIPTION | Consolidation description |
| METHOD | Consolidation method lookup (Balances, Transaction) |
| FROM_CURRENCY_CODE | Subsidiary currency (Functional or STAT) |
| TO_LEDGER_ID | Parent accounting books defining column |
| START_DATE_ACTIVE_11I | No Longer Used in R12 |
| END_DATE_ACTIVE_11I | No Longer Used in R12 |
| FROM_LOCATION | No longer used |
| FROM_SET_OF_BOOKS_ID | Subsidiary accounting books defining column |
| FROM_ORACLE_ID | No longer used |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| FROM_LEDGER_ID | Subsidiary accounting books defining column |
| CONTEXT | Descriptive flex context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| START_DATE_ACTIVE | Date on which consolidation becomes valid |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| RUN_POSTING_FLAG | Run journal posting flag |
| COA_MAPPING_ID | |
| NAME | Consolidation name |
| TO_SET_OF_BOOKS_ID | Parent accounting books defining column |
| SECURITY_FLAG |
| General Ledger - GL_CONSOLIDATION_ACCOUNTS | Account ranges for consolidating balances |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_RUN_ID | Consolidation run process defining column |
| SEGMENT1_LOW | Key flexfield segment low range column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| CONSOLIDATION_ID | Consolidation defining column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| FROM_SET_OF_BOOKS_ID | Parent accounting books defining column |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| FROM_LEDGER_ID | Subsidiary accounting books defining column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| ELEMENT_SEQUENCE | Line number of the account range |
| SEGMENT26_LOW | Key flexfield segment low range column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_CONSOLIDATION_HISTORY | History of consolidation runs |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_RUN_ID | Consolidation run process defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| FROM_BUDGET_NAME | Subsidiary budget name |
| CONSOLIDATION_ID | Consolidation defining column |
| FROM_BUDGET_VERSION_ID | Subsidiary budget defining column |
| TO_BUDGET_NAME | Parent budget name |
| TO_BUDGET_VERSION_ID | Parent budget defining column |
| AMOUNT_TYPE | Amount type consolidated |
| FROM_DATE | Subsidiary effective date |
| FROM_PERIOD_NAME | Subsidiary period name |
| AVERAGE_TO_PERIOD_NAME | Parent period name for average journals |
| CONSOLIDATION_SET_ID | Consolidation set defining column |
| OBSOLETE_CONSOLIDATION_FLAG | Flag which indicates whether the current consolidation transfer is obsolete |
| STATUS | Consolidation status |
| REQUEST_ID | Id of the request currently processing this consolidation run (or journal batch) |
| GROUP_ID | Group id of the consolidation data in journal import |
| JE_BATCH_ID | Defining column of the consolidation batch produced by journal import |
| TO_PERIOD_NAME | Parent period name |
| RUN_POSTING_FLAG | Run journal posting flag |
| TARGET_USER_NAME | User name in target database. |
| TO_CURRENCY_CODE | Parent currency |
| TARGET_RESP_NAME | Responsibility name in target database |
| TARGET_DATABASE_NAME | Target database name |
| METHOD_FLAG | Consolidation method (Balances, Transactions) |
| RUN_EASYLINK_FLAG | Submit Journal Import process |
| ACTUAL_FLAG | Balance type lookup (Actual, Budget, or Encumbrance) |
| AVERAGE_CONSOLIDATION_FLAG | Average consolidation flag |
| General Ledger - GL_CONS_BATCHES | Transaction method consolidation batches |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_ID | Consolidation defining column |
| CONSOLIDATION_RUN_ID | Consolidation run process defining column |
| JE_BATCH_ID | Consolidation journal batch defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_CONS_FLEXFIELD_MAP | Consolidation account rules |
|---|---|
| Column Name | Descritpion |
| FLEXFIELD_MAP_ID | Consolidation flexfield map defining column |
| SEGMENT1_HIGH | Key flexfield segment high range column |
| SEGMENT2_LOW | Key flexfield segment low range column |
| SEGMENT2_HIGH | Key flexfield segment high range column |
| SEGMENT3_LOW | Key flexfield segment low range column |
| SEGMENT3_HIGH | Key flexfield segment high range column |
| SEGMENT4_LOW | Key flexfield segment low range column |
| SEGMENT4_HIGH | Key flexfield segment high range column |
| SEGMENT5_LOW | Key flexfield segment low range column |
| SEGMENT5_HIGH | Key flexfield segment high range column |
| SEGMENT6_LOW | Key flexfield segment low range column |
| CONSOLIDATION_ID_11I | No Longer Used in R12 |
| SEGMENT6_HIGH | Key flexfield segment high range column |
| CONSOLIDATION_ID | Consolidation defining column |
| SEGMENT7_LOW | Key flexfield segment low range column |
| SEGMENT7_HIGH | Key flexfield segment high range column |
| SEGMENT8_LOW | Key flexfield segment low range column |
| SEGMENT8_HIGH | Key flexfield segment high range column |
| SEGMENT9_LOW | Key flexfield segment low range column |
| SEGMENT9_HIGH | Key flexfield segment high range column |
| SEGMENT10_LOW | Key flexfield segment low range column |
| SEGMENT10_HIGH | Key flexfield segment high range column |
| SEGMENT11_LOW | Key flexfield segment low range column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT11_HIGH | Key flexfield segment high range column |
| SEGMENT12_LOW | Key flexfield segment low range column |
| SEGMENT12_HIGH | Key flexfield segment high range column |
| SEGMENT13_LOW | Key flexfield segment low range column |
| SEGMENT13_HIGH | Key flexfield segment high range column |
| SEGMENT14_LOW | Key flexfield segment low range column |
| SEGMENT14_HIGH | Key flexfield segment high range column |
| SEGMENT15_LOW | Key flexfield segment low range column |
| SEGMENT15_HIGH | Key flexfield segment high range column |
| SEGMENT16_LOW | Key flexfield segment low range column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT16_HIGH | Key flexfield segment high range column |
| SEGMENT17_LOW | Key flexfield segment low range column |
| SEGMENT17_HIGH | Key flexfield segment high range column |
| SEGMENT18_LOW | Key flexfield segment low range column |
| SEGMENT18_HIGH | Key flexfield segment high range column |
| SEGMENT19_LOW | Key flexfield segment low range column |
| SEGMENT19_HIGH | Key flexfield segment high range column |
| SEGMENT20_LOW | Key flexfield segment low range column |
| SEGMENT20_HIGH | Key flexfield segment high range column |
| SEGMENT21_LOW | Key flexfield segment low range column |
| TO_CODE_COMBINATION_ID | Parent key flex account defining column |
| SEGMENT21_HIGH | Key flexfield segment high range column |
| SEGMENT22_LOW | Key flexfield segment low range column |
| SEGMENT22_HIGH | Key flexfield segment high range column |
| SEGMENT23_LOW | Key flexfield segment low range column |
| SEGMENT23_HIGH | Key flexfield segment high range column |
| SEGMENT24_LOW | Key flexfield segment low range column |
| SEGMENT24_HIGH | Key flexfield segment high range column |
| SEGMENT25_LOW | Key flexfield segment low range column |
| SEGMENT25_HIGH | Key flexfield segment high range column |
| SEGMENT26_LOW | Key flexfield segment low range column |
| CREATION_DATE | Standard Who column |
| SEGMENT26_HIGH | Key flexfield segment high range column |
| SEGMENT27_LOW | Key flexfield segment low range column |
| SEGMENT27_HIGH | Key flexfield segment high range column |
| SEGMENT28_LOW | Key flexfield segment low range column |
| SEGMENT28_HIGH | Key flexfield segment high range column |
| SEGMENT29_LOW | Key flexfield segment low range column |
| SEGMENT29_HIGH | Key flexfield segment high range column |
| SEGMENT30_LOW | Key flexfield segment low range column |
| SEGMENT30_HIGH | Key flexfield segment high range column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| COA_MAPPING_ID | |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEGMENT1_LOW | Key flexfield segment low range column |
| General Ledger - GL_CONS_FLEX_HIERARCHIES | Consolidation subsidiary segment hierarchies |
|---|---|
| Column Name | Descritpion |
| SEGMENT_MAP_ID | Subsidiary segment map defining column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| PARENT_FLEX_VALUE | Parent segment value |
| CHILD_FLEX_VALUE_LOW | Subsidiary segment low range value |
| CHILD_FLEX_VALUE_HIGH | Subsidiary segment high range value |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_CONS_SEGMENT_MAP | Consolidation segment rules |
|---|---|
| Column Name | Descritpion |
| SEGMENT_MAP_ID | Consolidation segment map defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| FROM_VALUE_SET_ID | Subsidiary segment value set defining column |
| FROM_APPLICATION_COLUMN_NAME | Subsidiary segment column name |
| PARENT_ROLLUP_VALUE | Subsidiary set of books parent rollup value |
| SINGLE_VALUE | Parent segment value for single value or rollup ranges rule |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| CONSOLIDATION_ID_11I | No Longer Used in R12 |
| ATTRIBUTE3 | Descriptive flexfield segment |
| CONSOLIDATION_ID | Consolidation defining column |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Description flexfield context |
| COA_MAPPING_ID | |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| TO_VALUE_SET_ID | Parent segment value set defining column |
| TO_APPLICATION_COLUMN_NAME | Parent segment column name |
| SEGMENT_MAP_TYPE | Segment map type lookup |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| General Ledger - GL_IEA_SUBSIDIARIES | Subsidiary definitions |
|---|---|
| Column Name | Descritpion |
| SUBSIDIARY_ID | Subsidiary defining column |
| CONVERSION_TYPE_CODE | Always 'D' for Daily Rates |
| CONVERSION_TYPE | Defining column for the conversion type to use when creating journal entries |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| VIEW_PARTNER_LINES_FLAG | Controls a subsidiary's ability to view its partner's transaction lines |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| REMOTE_INSTANCE_FLAG | Determines if the subsidiary's data should be transferred to a remote database instance |
| TRANSFER_SET_OF_BOOKS_ID | Defining column of the set of books to transfer to |
| CURRENCY_CODE | Currency |
| TRANSFER_CURRENCY_CODE | Transfer currency code |
| CONTACT | Notification contact name |
| NAME | Subsidiary name |
| NOTIFICATION_THRESHOLD | Notification threshold |
| DESCRIPTION | Subsidiary description |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| COMPANY_VALUE | Subsidiary balancing segment value |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| SUBSIDIARY_TYPE_CODE | Subsidiary type (Parent or Child) |
| ENABLED_FLAG | Enabled flag |
| AUTO_APPROVE_FLAG | Allow autoapproval flag |
| General Ledger - GL_IEA_RECUR_BATCHES | Recurring intercompany batches |
|---|---|
| Column Name | Descritpion |
| RECURRING_BATCH_ID | Recurring transaction batch defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| START_DATE_ACTIVE | Date that recurring transaction batch becomes valid |
| END_DATE_ACTIVE | Date after which recurring transaction batch become invalid |
| DESCRIPTION | Recurring transaction batch description |
| LAST_EXECUTED_BY | User who last executed this recurring transaction batch |
| LAST_EXECUTED_GL_DATE | GL Date that this recurring transaction batch was last executed for |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| NAME | Recurring transaction batch name |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| REQUEST_ID | Enhanced Who column |
| PROGRAM_APPLICATION_ID | Enhanced Who column |
| PROGRAM_ID | Enhanced Who column |
| PROGRAM_UPDATE_DATE | Enhanced Who column |
| SENDING_SUBSIDIARY_ID | Sending subsidiary defining column |
| AUTOSELECT_FLAG | Automatically select batch flag |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_IEA_RECUR_HISTORY | History of recurring intercompany batch runs |
|---|---|
| Column Name | Descritpion |
| RECURRING_BATCH_ID | Recurring intercompany transaction batch defining column |
| PROGRAM_APPLICATION_ID | Enhanced Who column |
| PROGRAM_ID | Enhanced Who column |
| PROGRAM_UPDATE_DATE | Enhanced Who column |
| TRANSACTION_RUN_ID | Recurring intercompany transaction batch run defining column |
| RUN_STATUS | Run status |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REQUEST_ID | Enhanced Who column |
| General Ledger - GL_IEA_RECUR_LINES | Recurring intercompany transaction lines |
|---|---|
| Column Name | Descritpion |
| RECURRING_TRANSACTION_ID | Recurring intercompany transaction defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ENTERED_CR | Intercompany transaction line debit amount |
| ENTERED_DR | Intercompany transaction line credit amount |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| SENDER_RECEIVER_CODE | Line type (sender or receiver) |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| LINE_NUMBER | Recurring intercompany transaction line defining column |
| OFFSET_CCID | Offset key flexfield defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| General Ledger - GL_IEA_RECUR_TRANSACTIONS | Recurring intercompany transactions |
|---|---|
| Column Name | Descritpion |
| RECURRING_TRANSACTION_ID | Recurring intercompany transaction defining column |
| STATUS | Status of newly generated transaction (New, Review, or Approved) |
| SENDER_CLEARING_CCID | Sender clearing key flexfield defining column |
| RECEIVER_CLEARING_CCID | Receiver clearing key flexfield defining column |
| SENDER_CLEARING_ACCOUNT | Sender clearing natural account value |
| RECEIVER_CLEARING_ACCOUNT | Receiver clearing natural account value |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| RECURRING_BATCH_ID | Recurring intercompany transaction batch defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SENDER_RUNNING_TOTAL_DR | Sender running total debits |
| SENDER_RUNNING_TOTAL_CR | Sender running total credits |
| RECEIVER_RUNNING_TOTAL_DR | Receiver running total debits |
| RECEIVER_RUNNING_TOTAL_CR | Receiver running total credits |
| CONTROL_TOTAL | Control total |
| DESCRIPTION | Recurring intercompany transaction description |
| NOTE | Recurring intercompany transaction note |
| CONTEXT | Descriptive flexfield context |
| TRANSACTION_TYPE_ID | Transaction type defining column |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| CURRENCY_CODE | Transaction currency |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| NAME | Recurring intercompany transaction name |
| RECEIVING_SUBSIDIARY_ID | Receiving subsidiary defining column |
| RECEIVER_COA_ID | Receiving key flexfield structure defining column |
| General Ledger - GL_IEA_TRANSACTIONS | Intercompany transactions |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | Intercompany transaction defining column |
| SENDER_SEGMENT14 | Sender clearing account segment value |
| SENDER_SEGMENT15 | Sender clearing account segment value |
| RECEIVER_CLEARING_CCID | Receiver clearing key flexfield defining column |
| SENDER_SEGMENT16 | Sender clearing account segment value |
| SENDER_SEGMENT17 | Sender clearing account segment value |
| GL_DATE | Accounting date for the transaction |
| SENDER_SEGMENT18 | Sender clearing account segment value |
| SENDER_SEGMENT19 | Sender clearing account segment value |
| ENTERED_DATE | Date the transaction was submitted |
| SENDER_SEGMENT20 | Sender clearing account segment value |
| SENDER_SEGMENT21 | Sender clearing account segment value |
| SENDER_TRANSFER_FLAG | Transferred to sender flag |
| SENDER_SEGMENT22 | Sender clearing account segment value |
| SENDER_SEGMENT23 | Sender clearing account segment value |
| RECEIVER_TRANSFER_FLAG | Transferred to receiver flag |
| SENDER_SEGMENT24 | Sender clearing account segment value |
| SENDER_SEGMENT25 | Sender clearing account segment value |
| SENDER_PERIOD_NAME | Sender accounting period |
| SENDER_SEGMENT26 | Sender clearing account segment value |
| SENDER_SEGMENT27 | Sender clearing account segment value |
| RECEIVER_PERIOD_NAME | Receiver accounting period |
| SENDER_SEGMENT28 | Sender clearing account segment value |
| SENDER_SEGMENT29 | Sender clearing account segment value |
| CREATION_DATE | Standard Who column |
| SENDER_SEGMENT30 | Sender clearing account segment value |
| RECEIVER_SEGMENT1 | Receiver clearing account segment value |
| CREATED_BY | Standard Who column |
| RECEIVER_SEGMENT2 | Receiver clearing account segment value |
| RECEIVER_SEGMENT3 | Receiver clearing account segment value |
| LAST_UPDATE_DATE | Standard Who column |
| RECEIVER_SEGMENT4 | Receiver clearing account segment value |
| RECEIVER_SEGMENT5 | Receiver clearing account segment value |
| LAST_UPDATED_BY | Standard Who column |
| RECEIVER_SEGMENT6 | Receiver clearing account segment value |
| RECEIVER_SEGMENT7 | Receiver clearing account segment value |
| RECEIVER_SEGMENT8 | Receiver clearing account segment value |
| RECEIVER_SEGMENT9 | Receiver clearing account segment value |
| LAST_UPDATE_LOGIN | Standard Who column |
| RECEIVER_SEGMENT10 | Receiver clearing account segment value |
| RECEIVER_SEGMENT11 | Receiver clearing account segment value |
| RECEIVER_SEGMENT12 | Receiver clearing account segment value |
| RECEIVER_SEGMENT13 | Receiver clearing account segment value |
| SENDER_RUNNING_TOTAL_DR | Sender running total debits |
| RECEIVER_SEGMENT14 | Receiver clearing account segment value |
| RECEIVER_SEGMENT15 | Receiver clearing account segment value |
| RECEIVER_SEGMENT16 | Receiver clearing account segment value |
| RECEIVER_SEGMENT17 | Receiver clearing account segment value |
| SENDER_RUNNING_TOTAL_CR | Sender running total credits |
| RECEIVER_SEGMENT18 | Receiver clearing account segment value |
| RECEIVER_SEGMENT19 | Receiver clearing account segment value |
| SENDER_GENERATION_CODE | Indicates if the sender clearing account segment values are generated, updated, or new |
| RECEIVER_SEGMENT20 | Receiver clearing account segment value |
| RECEIVER_SEGMENT21 | Receiver clearing account segment value |
| RECEIVER_RUNNING_TOTAL_DR | Receiver running total debits |
| RECEIVER_SEGMENT22 | Receiver clearing account segment value |
| RECEIVER_SEGMENT23 | Receiver clearing account segment value |
| TRANSACTION_TYPE_ID | Transaction type defining column |
| RECEIVER_SEGMENT24 | Receiver clearing account segment value |
| RECEIVER_SEGMENT25 | Receiver clearing account segment value |
| RECEIVER_RUNNING_TOTAL_CR | Receiver running total credits |
| RECEIVER_SEGMENT26 | Receiver clearing account segment value |
| RECEIVER_SEGMENT27 | Receiver clearing account segment value |
| RECEIVER_SEGMENT28 | Receiver clearing account segment value |
| RECEIVER_SEGMENT29 | Receiver clearing account segment value |
| RECEIVER_GENERATION_CODE | Indicates if the receiver clearing account segment values are generated, updated, or new |
| RECEIVER_SEGMENT30 | Receiver clearing account segment value |
| SENDER_CONVERSION_RATE | Sender conversion rate |
| RECEIVER_CONVERSION_RATE | Receiver conversion rate |
| CONTROL_TOTAL | Control total |
| APPROVED_DATE | Date the transaction was approved |
| DESCRIPTION | Intercompany transaction description |
| NOTE | Intercompany transaction note |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| REQUEST_ID | Enhanced Who column |
| PROGRAM_APPLICATION_ID | Enhanced Who column |
| PROGRAM_ID | Enhanced Who column |
| PROGRAM_UPDATE_DATE | Enhanced Who column |
| SENDER_TRANSFER_STATUS | Sender transfer status |
| RECEIVER_TRANSFER_STATUS | Receiver transfer status |
| FROM_RECURRING_TRANSACTION_ID | Defining column of the recurring intercompany transaction that created this transaction |
| REVERSE_TRANSACTION_ID | Defining column of the intercompany transaction that reverses this transaction |
| SENDER_SEGMENT1 | Sender clearing account segment value |
| CURRENCY_CODE | Transaction currency |
| SENDER_SEGMENT2 | Sender clearing account segment value |
| SENDER_SEGMENT3 | Sender clearing account segment value |
| TRANSACTION_NUMBER | Transaction number |
| SENDER_SEGMENT4 | Sender clearing account segment value |
| SENDER_SEGMENT5 | Sender clearing account segment value |
| SENDING_SUBSIDIARY_ID | Sending subsidiary defining column |
| SENDER_SEGMENT6 | Sender clearing account segment value |
| SENDER_SEGMENT7 | Sender clearing account segment value |
| RECEIVING_SUBSIDIARY_ID | Receiving subsidiary defining column |
| SENDER_SEGMENT8 | Sender clearing account segment value |
| SENDER_SEGMENT9 | Sender clearing account segment value |
| STATUS | Transaction status |
| SENDER_SEGMENT10 | Sender clearing account segment value |
| SENDER_SEGMENT11 | Sender clearing account segment value |
| SENDER_CLEARING_CCID | Sender clearing key flexfield defining column |
| SENDER_SEGMENT12 | Sender clearing account segment value |
| SENDER_SEGMENT13 | Sender clearing account segment value |
| General Ledger - GL_IEA_TRANSACTION_LINES | Intercompany transaction lines |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_ID | Intercompany transaction defining column |
| LAST_UPDATED_BY | Standard Who column |
| SEGMENT17 | Key flexfield segment column |
| SEGMENT18 | Key flexfield segment column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SEGMENT19 | Key flexfield segment column |
| SEGMENT20 | Key flexfield segment column |
| SEGMENT21 | Key flexfield segment column |
| SEGMENT22 | Key flexfield segment column |
| ENTERED_CR | Transaction line credit amount |
| SEGMENT23 | Key flexfield segment column |
| SEGMENT24 | Key flexfield segment column |
| SEGMENT25 | Key flexfield segment column |
| SEGMENT26 | Key flexfield segment column |
| ENTERED_DR | Transaction line debit amount |
| SEGMENT27 | Key flexfield segment column |
| SEGMENT28 | Key flexfield segment column |
| SEGMENT29 | Key flexfield segment column |
| SEGMENT30 | Key flexfield segment column |
| GENERATION_CODE | Indicates if the account segments are generated, updated, or new |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| REQUEST_ID | Enhanced Who column |
| PROGRAM_APPLICATION_ID | Enhanced Who column |
| PROGRAM_ID | Enhanced Who column |
| PROGRAM_UPDATE_DATE | Enhanced Who column |
| SEGMENT1 | Key flexfield segment column |
| SEGMENT2 | Key flexfield segment column |
| SENDER_RECEIVER_CODE | Line type (Sender or Receiver) |
| SEGMENT3 | Key flexfield segment column |
| SEGMENT4 | Key flexfield segment column |
| LINE_NUMBER | Line number |
| SEGMENT5 | Key flexfield segment column |
| SEGMENT6 | Key flexfield segment column |
| SEGMENT7 | Key flexfield segment column |
| SEGMENT8 | Key flexfield segment column |
| OFFSET_CCID | Offset key flexfield defining column |
| SEGMENT9 | Key flexfield segment column |
| SEGMENT10 | Key flexfield segment column |
| CREATION_DATE | Standard Who column |
| SEGMENT11 | Key flexfield segment column |
| SEGMENT12 | Key flexfield segment column |
| CREATED_BY | Standard Who column |
| SEGMENT13 | Key flexfield segment column |
| SEGMENT14 | Key flexfield segment column |
| LAST_UPDATE_DATE | Standard Who column |
| SEGMENT15 | Key flexfield segment column |
| SEGMENT16 | Key flexfield segment column |
| General Ledger - GL_IEA_TRANSACTION_TYPES | Intercompany transaction types |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_TYPE_ID | Transaction type defining column |
| ALLOW_INTEREST_ACCRUAL_FLAG | Allow interest accrual flag |
| ALLOW_INVOICING_FLAG | Allow invoicing flag |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Transaction type description |
| CONTEXT | Descriptive flexfield context |
| NAME | Transaction type name |
| ATTRIBUTE1 | Descriptive flexfield column |
| ATTRIBUTE2 | Descriptive flexfield column |
| ATTRIBUTE3 | Descriptive flexfield column |
| ATTRIBUTE4 | Descriptive flexfield column |
| ATTRIBUTE5 | Descriptive flexfield column |
| ATTRIBUTE6 | Descriptive flexfield column |
| ATTRIBUTE7 | Descriptive flexfield column |
| ATTRIBUTE8 | Descriptive flexfield column |
| ATTRIBUTE9 | Descriptive flexfield column |
| ATTRIBUTE10 | Descriptive flexfield column |
| AUTO_APPROVE_FLAG | Allow auto-approve flag |
| ATTRIBUTE11 | Descriptive flexfield column |
| ATTRIBUTE12 | Descriptive flexfield column |
| ATTRIBUTE13 | Descriptive flexfield column |
| ATTRIBUTE14 | Descriptive flexfield column |
| ATTRIBUTE15 | Descriptive flexfield column |
| ENABLED_FLAG | Enabled flag |
| VAT_TAXABLE_FLAG | VAT taxable flag |
| General Ledger - GL_IEA_CLEARING_ACCOUNTS | Clearing accounts |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| SUBSIDIARY_ID | Subsidiary defining column |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ACCOUNT_SEGMENT_VALUE | Natural account value |
| General Ledger - GL_DAILY_CONVERSION_RATES | Foreign currency daily exchange rates |
|---|---|
| Column Name | Descritpion |
| SET_OF_BOOKS_ID | Accounting books defining column |
| FROM_CURRENCY_CODE | Foreign currency |
| CONVERSION_DATE | Currency conversion date |
| CONVERSION_RATE | Currency conversion rate |
| CONVERSION_TYPE | Currency conversion type |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| General Ledger - GL_DAILY_CONVERSION_TYPES | Foreign currency daily conversion rate types |
|---|---|
| Column Name | Descritpion |
| CONVERSION_TYPE | Conversion type name |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| USER_CONVERSION_TYPE | Conversion type user defined name |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| SECURITY_FLAG | Enable definition access set security flag |
| LAST_UPDATE_DATE | Standard Who column |
| FEM_ENABLED_FLAG | Indicates whether this rate type is available for use by Enterprise Planning and Budgeting |
| FEM_SCENARIO | Scenario under which this conversion type is used for Enterprise Planning and Budgeting |
| LAST_UPDATED_BY | Standard Who column |
| FEM_RATE_TYPE_CODE | Indicates if this rate is an average rate or an ending rate for Enterprise Planning and Budgeting purposes |
| FEM_TIMEFRAME | Time frame that this rate covers for Enterprise Planning and Budgeting purposes |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Conversion type description |
| ATTRIBUTE1 | Descriptive flexfield segment |
| General Ledger - GL_ENCUMBRANCE_TYPES | Encumbrance type definitions |
|---|---|
| Column Name | Descritpion |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| ENCUMBRANCE_TYPE_KEY | Encumbrance type key |
| ENCUMBRANCE_TYPE | Encumbrance type name |
| ENABLED_FLAG | Encumbrance type enabled flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Encumbrance type description |
| General Ledger - GL_ENTITY_BUDGETS | Freeze budget organizations for particular budgets |
|---|---|
| Column Name | Descritpion |
| BUDGET_ENTITY_ID | Budget Organization defining column |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| BUDGET_VERSION_ID | Budget version defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| FROZEN_FLAG | Freeze budget organization flag |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| General Ledger - GL_CONSOLIDATION_SETS | Consolidation sets |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_SET_ID | Consolidation set defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| METHOD | Consolidation method (Balances or Transactions) |
| DESCRIPTION | Consolidation set description |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| TO_LEDGER_ID | Parent accounting books defining column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| TO_SET_OF_BOOKS_ID | Parent accounting books defining column |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| NAME | Consolidation set name |
| RUN_POSTING_FLAG | Run journal posting flag |
| SECURITY_FLAG | |
| RUN_JOURNAL_IMPORT_FLAG | Automatically run journal import flag |
| SUMMARIZE_LINES_FLAG | Run journal import in summary mode flag |
| AUDIT_MODE_FLAG | Run journal import in audit mode flag |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| General Ledger - GL_CONS_SET_ASSIGNMENTS | Assignments of consolidations to consolidation sets |
|---|---|
| Column Name | Descritpion |
| CONSOLIDATION_SET_ID | Consolidation set defining column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONSOLIDATION_ID | Consolidation id |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CHILD_CONSOLIDATION_SET_ID | Child consolidation set defining column. |
| CONTEXT | Descriptive flexfield context |
| General Ledger - GL_AUTHORIZATION_LIMITS | Journal approval authorization limits for employees |
|---|---|
| Column Name | Descritpion |
| CREATION_DATE | Standard Who column. |
| CREATED_BY | Standard Who Column. |
| LAST_UPDATE_DATE | Standard Who Column. |
| LAST_UPDATED_BY | Standard Who Column. |
| LAST_UPDATE_LOGIN | Standard Who Column. |
| LEDGER_ID | Accounting books defining column. |
| CONTEXT | Descriptive flexfield context |
| SET_OF_BOOKS_ID | Accounting books defining column. |
| ATTRIBUTE1 | Descriptive Flexfield Segment. |
| ATTRIBUTE2 | Descriptive Flexfield Segment. |
| ATTRIBUTE3 | Descriptive Flexfield Segment. |
| ATTRIBUTE4 | Descriptive Flexfield Segment. |
| ATTRIBUTE5 | Descriptive Flexfield Segment. |
| ATTRIBUTE6 | Descriptive Flexfield Segment. |
| ATTRIBUTE7 | Descriptive Flexfield Segment. |
| ATTRIBUTE8 | Descriptive Flexfield Segment. |
| ATTRIBUTE9 | Descriptive Flexfield Segment. |
| EMPLOYEE_ID | Employee id. Foreign key to per_people. |
| ATTRIBUTE10 | Descriptive Flexfield Segment. |
| ATTRIBUTE11 | Descriptive Flexfield Segment. |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ATTRIBUTE13 | Descriptive Flexfield Segment. |
| ATTRIBUTE14 | Descriptive Flexfield Segment. |
| ATTRIBUTE15 | Descriptive Flexfield Segment. |
| AUTHORIZATION_LIMIT | Authorization limit for an employee. |
| General Ledger - GL_DAILY_RATES | Daily conversion rates for foreign currency transactions |
|---|---|
| Column Name | Descritpion |
| CONVERSION_RATE | Currency conversion rate |
| STATUS_CODE | Daily balances up to date flag |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| FROM_CURRENCY | From currency |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| TO_CURRENCY | To currency |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| CONVERSION_DATE | Currency conversion date |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| RATE_SOURCE_CODE | Identify daily rates source |
| CONVERSION_TYPE | Currency conversion type |
| General Ledger - GL_DAILY_RATES_INTERFACE | Import daily conversion rates |
|---|---|
| Column Name | Descritpion |
| USER_CONVERSION_TYPE | User currency conversion type |
| CONVERSION_RATE | Currency conversion rate |
| MODE_FLAG | Import mode ('D' - delete any matching rows from gl_daily_rates, 'I' - insert/update rows in gl_daily_rates, 'X' - invalid row) |
| INVERSE_CONVERSION_RATE | Inverse of the currency conversion rate |
| USER_ID | ID of the user who is adding the rows |
| FROM_CURRENCY | From currency |
| LAUNCH_RATE_CHANGE | Automatically launch rate change program flag |
| ERROR_CODE | Error code for unsuccessful rows |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| TO_CURRENCY | To currency |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| FROM_CONVERSION_DATE | Start of date range for which this rate is valid |
| USED_FOR_AB_TRANSLATION | Used internally during the copy of rates to the gl_daily_rates table. Do not put a value into this column |
| BATCH_NUMBER | Identifier to identify the set of records to be processed |
| TO_CONVERSION_DATE | End of date range for which this rate is valid |
| General Ledger - GL_AUTOMATIC_POSTING_SETS | Sets of automatic posting criteria |
|---|---|
| Column Name | Descritpion |
| ENABLED_FLAG | Autopost set enabled flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| AUTOPOST_SET_ID | Autopost set defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| DESCRIPTION | Description |
| NUM_OF_PRIORITY_OPTIONS | Number of top priorities in the set to be submitted for posting. |
| EFFECTIVE_DAYS_BEFORE | Number of days before the Autopost process date that a journal's effective date must be on or after |
| EFFECTIVE_DAYS_AFTER | Number of days after the Autopost process date that a journal's effective date must be on or before |
| ATTRIBUTE1 | Descriptive Flexfield Segment |
| ATTRIBUTE2 | Descriptive Flexfield Segment |
| ATTRIBUTE3 | Descriptive Flexfield Segment |
| ATTRIBUTE4 | Descriptive Flexfield Segment |
| SET_OF_BOOKS_ID_11I | No Longer Used in R12 |
| ATTRIBUTE5 | Descriptive Flexfield Segment |
| ATTRIBUTE6 | Descriptive Flexfield Segment |
| ATTRIBUTE7 | Descriptive Flexfield Segment |
| ATTRIBUTE8 | Descriptive Flexfield Segment |
| ATTRIBUTE9 | Descriptive Flexfield Segment |
| ATTRIBUTE10 | Descriptive Flexfield Segment |
| ATTRIBUTE11 | Descriptive Flexfield Segment |
| ATTRIBUTE12 | Descriptive Flexfield Segment |
| ATTRIBUTE13 | Descriptive Flexfield Segment |
| ATTRIBUTE14 | Descriptive Flexfield Segment |
| AUTOPOST_SET_NAME | Autopost set name |
| ATTRIBUTE15 | Descriptive Flexfield Segment |
| CONTEXT | Descriptive flexfield context |
| CHART_OF_ACCOUNTS_ID | |
| PERIOD_SET_NAME | |
| ACCOUNTED_PERIOD_TYPE | |
| SUBMIT_ALL_PRIORITIES_FLAG | Submit all priorities defined in the set for posting flag |
| SECURITY_FLAG |
| General Ledger - GL_HISTORICAL_RATES | Foreign currency translation rates for historical accounts |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| RATE_TYPE | Currency rate type lookup |
| TRANSLATED_RATE | Historical rate |
| TRANSLATED_AMOUNT | Historical amount |
| ACCOUNT_TYPE | Account type lookup (Asset, Liability, etc) |
| ATTRIBUTE1 | Descriptive flexfield segment |
| PERIOD_NAME | Accounting period |
| ATTRIBUTE2 | Descriptive flexfield segment |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| PERIOD_NUM | Accounting period number |
| PERIOD_YEAR | Accounting period year |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| TARGET_CURRENCY | Translation target currency |
| UPDATE_FLAG | Historical rate updated flag |
| USAGE_CODE | Historical rate usage (Average or Standard) |
| General Ledger - GL_INTERCOMPANY_ACCOUNTS | Assignments of intercompany due to and due from accounts to a source, category, and balancing segment value. |
|---|---|
| Column Name | Descritpion |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| BAL_SEG_VALUE | Balancing segment value. Any value exceeding 25 characters indicates a value of Other |
| SET_OF_BOOKS_ID | Accounting books defining column |
| DUE_TO_CCID | Intercompany Due To account |
| DUE_FROM_CCID | Intercompany Due From account |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LEDGER_ID | Accounting books defining column |
| CREATION_DATE | Standard Who column |
| JE_SOURCE_NAME | Journal entry source name |
| CREATED_BY | Standard Who column |
| CONTEXT | Descriptive flexfield context |
| JE_CATEGORY_NAME | Journal entry category name |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| General Ledger - GL_INTERFACE | Import journal entry batches |
|---|---|
| Column Name | Descritpion |
| STATUS | Journal Import status |
| CURRENCY_CONVERSION_DATE | Date of exchange rate |
| GROUP_ID | Interface group defining column |
| REQUEST_ID | Concurrent program request id |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| BUDGET_VERSION_ID | Budget version defining column |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| USER_CURRENCY_CONVERSION_TYPE | Type of exchange rate |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| CURRENCY_CONVERSION_RATE | Foreign currency exchange rate |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| CONTEXT2 | Descriptive flexfield context column |
| AVERAGE_JOURNAL_FLAG | Average journal flag |
| INVOICE_DATE | Value added tax descriptive flexfield column |
| TAX_CODE | Value added tax descriptive flexfield column |
| INVOICE_IDENTIFIER | Value added tax descriptive flexfield column |
| INVOICE_AMOUNT | Value added tax descriptive flexfield column |
| CONTEXT3 | Descriptive flexfield context column |
| USSGL_TRANSACTION_CODE | Government transaction code |
| DESCR_FLEX_ERROR_MESSAGE | Descriptive flexfield error message |
| JGZZ_RECON_REF | Global reconciliation reference |
| GL_SL_LINK_ID | Link to associated subledger data |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| REFERENCE_DATE | Reference Date |
| SET_OF_BOOKS_ID | Ledger defining column |
| LEDGER_ID | Ledger defining column |
| BALANCING_SEGMENT_VALUE | Balancing segment value |
| MANAGEMENT_SEGMENT_VALUE | Management segment value |
| ORIGINATING_BAL_SEG_VALUE | Originating balancing segment value |
| FUNDS_RESERVED_FLAG | Reserved for Oracle internal use |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| ACCOUNTING_DATE | Effective date of the transaction |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| CURRENCY_CODE | Currency |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| DATE_CREATED | Standard Who column |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| ENTERED_DR | Transaction debit amount, entered currency |
| ENTERED_CR | Transaction credit amount, entered currency |
| ACCOUNTED_DR | Transaction debit amount, base currency |
| ACCOUNTED_CR | Transaction credit amount, base currency |
| TRANSACTION_DATE | Date of transaction |
| REFERENCE1 | Journal Import reference column |
| REFERENCE2 | Journal Import reference column |
| REFERENCE3 | Journal Import reference column |
| CREATED_BY | Standard Who column |
| REFERENCE4 | Journal Import reference column |
| REFERENCE5 | Journal Import reference column |
| REFERENCE6 | Journal Import reference column |
| REFERENCE7 | Journal Import reference column |
| REFERENCE8 | Journal Import reference column |
| REFERENCE9 | Journal Import reference column |
| REFERENCE10 | Journal Import reference column |
| REFERENCE11 | Journal Import reference column |
| REFERENCE12 | Journal Import reference column |
| REFERENCE13 | Journal Import reference column |
| ACTUAL_FLAG | Balance type (actual, budget, or encumbrance) |
| REFERENCE14 | Journal Import reference column |
| REFERENCE15 | Journal Import reference column |
| REFERENCE16 | Journal Import reference column |
| REFERENCE17 | Journal Import reference column |
| REFERENCE18 | Journal Import reference column |
| REFERENCE19 | Journal Import reference column |
| REFERENCE20 | Journal Import reference column |
| REFERENCE21 | Journal Import reference column |
| REFERENCE22 | Journal Import reference column |
| REFERENCE23 | Journal Import reference column |
| USER_JE_CATEGORY_NAME | Journal entry category user defined name |
| REFERENCE24 | Journal Import reference column |
| REFERENCE25 | Journal Import reference column |
| REFERENCE26 | Journal Import reference column |
| REFERENCE27 | Journal Import reference column |
| REFERENCE28 | Journal Import reference column |
| REFERENCE29 | Journal Import reference column |
| REFERENCE30 | Journal Import reference column |
| JE_BATCH_ID | Journal entry batch defining column |
| PERIOD_NAME | Accounting period |
| USER_JE_SOURCE_NAME | Journal entry source user defined name |
| JE_HEADER_ID | Journal entry header defining column |
| JE_LINE_NUM | Journal entry line number |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| FUNCTIONAL_CURRENCY_CODE | Ledger base currency |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| DATE_CREATED_IN_GL | Date Journal Import created batch |
| WARNING_CODE | Not currently used |
| STATUS_DESCRIPTION | Journal import status description |
| STAT_AMOUNT | Statistical amount |
| General Ledger - GL_INTERFACE_CONTROL | Journal import execution control |
|---|---|
| Column Name | Descritpion |
| JE_SOURCE_NAME | Journal entry source |
| PROCESSED_TABLE_CODE | Indicates what should be done with the data once it has been processed |
| REQUEST_ID | Concurrent request defining column |
| STATUS | Journal Import status |
| INTERFACE_RUN_ID | Journal Import process defining column |
| GROUP_ID | Interface group defining column |
| INTERFACE_TABLE_NAME | Journal Import interface table |
| SET_OF_BOOKS_ID | Ledger defining column |
| PACKET_ID | Budgetary control packet defining column |
| General Ledger - GL_INTERFACE_HISTORY | Imported journal entry batches |
|---|---|
| Column Name | Descritpion |
| STATUS | Journal import status |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| GROUP_ID | Interface group defining column |
| REQUEST_ID | Concurrent program request id |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequence defining column |
| BUDGET_VERSION_ID | Budget version defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequence value |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| CURRENCY_CONVERSION_DATE | Date of exchange rate |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| USER_CURRENCY_CONVERSION_TYPE | Type of exchange rate |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| CURRENCY_CONVERSION_RATE | Foreign currency exchange rate |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| CONTEXT2 | Descriptive flexfield context column |
| INVOICE_DATE | Value added tax descriptive flexfield column |
| TAX_CODE | Value added tax descriptive flexfield column |
| AVERAGE_JOURNAL_FLAG | Average journal flag |
| INVOICE_IDENTIFIER | Value added tax descriptive flexfield column |
| INVOICE_AMOUNT | Value added tax descriptive flexfield column |
| CONTEXT3 | Descriptive flexfield context column |
| USSGL_TRANSACTION_CODE | Government transaction code |
| DESCR_FLEX_ERROR_MESSAGE | Descriptive flexfield error message |
| LEDGER_ID | Ledger defining column |
| REFERENCE_DATE | Reference date |
| GL_SL_LINK_ID | Link to associated subledger defining column |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| JGZZ_RECON_REF | Global reconciliation reference |
| SET_OF_BOOKS_ID | Ledger defining column |
| ORIGINATING_BAL_SEG_VALUE | Originating balancing segment value |
| SEGMENT1 | Key flexfield segment |
| SEGMENT2 | Key flexfield segment |
| SEGMENT3 | Key flexfield segment |
| SEGMENT4 | Key flexfield segment |
| SEGMENT5 | Key flexfield segment |
| SEGMENT6 | Key flexfield segment |
| SEGMENT7 | Key flexfield segment |
| SEGMENT8 | Key flexfield segment |
| ACCOUNTING_DATE | Effective date of the transaction |
| SEGMENT9 | Key flexfield segment |
| SEGMENT10 | Key flexfield segment |
| SEGMENT11 | Key flexfield segment |
| SEGMENT12 | Key flexfield segment |
| SEGMENT13 | Key flexfield segment |
| SEGMENT14 | Key flexfield segment |
| SEGMENT15 | Key flexfield segment |
| SEGMENT16 | Key flexfield segment |
| SEGMENT17 | Key flexfield segment |
| SEGMENT18 | Key flexfield segment |
| CURRENCY_CODE | Currency |
| SEGMENT19 | Key flexfield segment |
| SEGMENT20 | Key flexfield segment |
| SEGMENT21 | Key flexfield segment |
| SEGMENT22 | Key flexfield segment |
| SEGMENT23 | Key flexfield segment |
| SEGMENT24 | Key flexfield segment |
| SEGMENT25 | Key flexfield segment |
| SEGMENT26 | Key flexfield segment |
| SEGMENT27 | Key flexfield segment |
| SEGMENT28 | Key flexfield segment |
| DATE_CREATED | Standard Who column |
| SEGMENT29 | Key flexfield segment |
| SEGMENT30 | Key flexfield segment |
| ENTERED_DR | Transaction debit amount, entered currency |
| ENTERED_CR | Transaction credit amount, entered currency |
| ACCOUNTED_DR | Transaction debit amount, base currency |
| ACCOUNTED_CR | Transaction credit amount, base currency |
| TRANSACTION_DATE | Date of transaction |
| REFERENCE1 | Journal Import reference column |
| REFERENCE2 | Journal Import reference column |
| REFERENCE3 | Journal Import reference column |
| CREATED_BY | Standard Who column |
| REFERENCE4 | Journal Import reference column |
| REFERENCE5 | Journal Import reference column |
| REFERENCE6 | Journal Import reference column |
| REFERENCE7 | Journal Import reference column |
| REFERENCE8 | Journal Import reference column |
| REFERENCE9 | Journal Import reference column |
| REFERENCE10 | Journal Import reference column |
| REFERENCE11 | Journal Import reference column |
| REFERENCE12 | Journal Import reference column |
| REFERENCE13 | Journal Import reference column |
| ACTUAL_FLAG | Balance type (actual, budget,or encumbrance) |
| REFERENCE14 | Journal Import reference column |
| REFERENCE15 | Journal Import reference column |
| REFERENCE16 | Journal Import reference column |
| REFERENCE17 | Journal Import reference column |
| REFERENCE18 | Journal Import reference column |
| REFERENCE19 | Journal Import reference column |
| REFERENCE20 | Journal Import reference column |
| REFERENCE21 | Journal Import reference column |
| REFERENCE22 | Journal Import reference column |
| REFERENCE23 | Journal Import reference column |
| USER_JE_CATEGORY_NAME | Journal entry category user defined name |
| REFERENCE24 | Journal Import reference column |
| REFERENCE25 | Journal Import reference column |
| REFERENCE26 | Journal Import reference column |
| REFERENCE27 | Journal Import reference column |
| REFERENCE28 | Journal Import reference column |
| REFERENCE29 | Journal Import reference column |
| REFERENCE30 | Journal Import reference column |
| JE_BATCH_ID | Journal entry batch defining column |
| PERIOD_NAME | Accounting period |
| USER_JE_SOURCE_NAME | Journal entry source user defined name |
| JE_HEADER_ID | Journal entry header defining column |
| JE_LINE_NUM | Journal entry line number |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| FUNCTIONAL_CURRENCY_CODE | Ledger base currency |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| DATE_CREATED_IN_GL | Date journal import created batch |
| WARNING_CODE | Not currently used |
| STATUS_DESCRIPTION | Journal import status description |
| STAT_AMOUNT | Statistical amount |
| General Ledger - GL_JE_BATCHES | Journal entry batches |
|---|---|
| Column Name | Descritpion |
| JE_BATCH_ID | Journal entry batch defining column |
| ACCOUNTED_PERIOD_TYPE | Accounting period type |
| GROUP_ID | Interface group identifying column |
| AVERAGE_JOURNAL_FLAG | Average journal flag |
| APPROVER_EMPLOYEE_ID | Defining column of the employee who submitted the journal batch for approval |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific functionality |
| BUDGETARY_CONTROL_STATUS | Journal entry batch funds check status |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific functionality |
| APPROVAL_STATUS_CODE | Journal entry batch approval status |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific functionality |
| CREATION_DATE | Standard Who column |
| GLOBAL_ATTRIBUTE11 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE12 | Reserved for country-specific functionality |
| CREATED_BY | Standard Who column |
| GLOBAL_ATTRIBUTE13 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE14 | Reserved for country-specific functionality |
| LAST_UPDATE_LOGIN | Standard Who column |
| GLOBAL_ATTRIBUTE15 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE16 | Reserved for country-specific functionality |
| LAST_UPDATE_DATE | Standard Who column |
| STATUS_RESET_FLAG | No longer used |
| SET_OF_BOOKS_ID | Accounting books defining column |
| GLOBAL_ATTRIBUTE17 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE18 | Reserved for country-specific functionality |
| DEFAULT_PERIOD_NAME | Accounting period for batch |
| GLOBAL_ATTRIBUTE19 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE20 | Reserved for country-specific functionality |
| UNIQUE_DATE | No longer used |
| EARLIEST_POSTABLE_DATE | Earliest date batch can be posted |
| POSTED_DATE | Date batch was posted |
| DATE_CREATED | Date batch was created |
| DESCRIPTION | Journal entry batch description |
| CONTROL_TOTAL | Control total column |
| LAST_UPDATED_BY | Standard Who column |
| SET_OF_BOOKS_ID_11I | No Longer Used in R12 |
| RUNNING_TOTAL_DR | Batch running total debit, entered currency |
| RUNNING_TOTAL_CR | Batch running total credit, entered currency |
| RUNNING_TOTAL_ACCOUNTED_DR | Batch running total debit, base currency |
| RUNNING_TOTAL_ACCOUNTED_CR | Batch running total credit, base currency |
| PARENT_JE_BATCH_ID | Defining column of the parent batch in the source reporting currency ledger |
| ATTRIBUTE1 | Descriptive flexfield segment |
| NAME | Name of journal entry batch |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| STATUS | Journal entry batch status |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| UNRESERVATION_PACKET_ID | Packet defining column for last funds unreservation of batch |
| STATUS_VERIFIED | Batch status verified by posting process |
| PACKET_ID | Packet defining column for last funds check of the batch |
| USSGL_TRANSACTION_CODE | Government transaction code |
| CONTEXT2 | Descriptive flexfield structure defining column |
| POSTING_RUN_ID | Posting sequence number |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| REQUEST_ID | Posting concurrent request id |
| ORG_ID | Organization defining column |
| POSTED_BY | User who posted the journal batch |
| DEFAULT_EFFECTIVE_DATE | Date within default accounting period |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| PERIOD_SET_NAME | Accounting calendar name |
| General Ledger - GL_JE_CATEGORIES_TL | Journal entry categories |
|---|---|
| Column Name | Descritpion |
| JE_CATEGORY_NAME | Journal entry category |
| SOURCE_LANG | Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
| USER_JE_CATEGORY_NAME | Journal entry category user defined name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Category description |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| CONSOLIDATION_FLAG | Consolidation flag |
| JE_CATEGORY_KEY | Category Key |
| LANGUAGE | Language |
| General Ledger - GL_JE_HEADERS | Journal entry headers |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID | Journal entry header defining column |
| STATUS | Journal entry header status lookup code |
| DATE_CREATED | Date header created in GL |
| ACCRUAL_REV_FLAG | Reversed journal entry flag |
| MULTI_BAL_SEG_FLAG | Multiple balancing segment flag |
| CURRENCY_CONVERSION_RATE | Currency exchange rate |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| CURRENCY_CONVERSION_TYPE | Type of currency exchange rate |
| CURRENCY_CONVERSION_DATE | Currency conversion date |
| DEFAULT_EFFECTIVE_DATE | Journal entry effective date |
| EXTERNAL_REFERENCE | Extra reference column |
| PARENT_JE_HEADER_ID | Defining column of the parent journal entry in the source primary ledger |
| REVERSED_JE_HEADER_ID | Defining column of the journal entry that is reversed by this journal entry |
| ORIGINATING_BAL_SEG_VALUE | Originating balancing segment value |
| INTERCOMPANY_MODE | Intercompany mode for the journal. Valid values are 1 through 4. |
| DR_BAL_SEG_VALUE | Balancing segment value used on the debit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 2. |
| CR_BAL_SEG_VALUE | Balancing segment value used on the credit side of an intercompany journal. This column is meaningful only for intercompany modes 1 and 3. |
| TAX_STATUS_CODE | Journal entry tax status |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| CONVERSION_FLAG | Currency conversion flag |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific functionality |
| BUDGET_VERSION_ID | Budget version defining column |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific functionality |
| BALANCED_JE_FLAG | Balanced journal entry flag |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific functionality |
| BALANCING_SEGMENT_VALUE | Key flexfield structure balancing segment value |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific functionality |
| JE_BATCH_ID | Journal entry batch defining column |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific functionality |
| FROM_RECURRING_HEADER_ID | Recurring batch header defining column |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific functionality |
| USSGL_TRANSACTION_CODE | Government transaction code |
| UNIQUE_DATE | No longer used |
| CONTEXT2 | Descriptive flexfield structure defining column |
| DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| JGZZ_RECON_CONTEXT | Context column for Global Reconciliation Descriptive Flexfield |
| LAST_UPDATED_BY | Standard Who column |
| JGZZ_RECON_REF | Global Reconciliation Descriptive Flexfield segment |
| REFERENCE_DATE | Reference Date |
| EARLIEST_POSTABLE_DATE | Earliest date journal entry header can be posted |
| LOCAL_DOC_SEQUENCE_ID | Sequential numbering sequence defining column for local requirement purposes |
| LOCAL_DOC_SEQUENCE_VALUE | Sequential numbering sequence value for local requirement purposes |
| POSTED_DATE | Date journal entry header was posted |
| DISPLAY_ALC_JOURNAL_FLAG | Display reporting currency journal flag |
| JE_FROM_SLA_FLAG | Journal propagated from subledger flag |
| POSTING_ACCT_SEQ_VERSION_ID | Posting account sequence version defining column |
| ACCRUAL_REV_EFFECTIVE_DATE | Reversed journal entry effective date |
| POSTING_ACCT_SEQ_ASSIGN_ID | Posting account sequence assignment defining column |
| POSTING_ACCT_SEQ_VALUE | Posting account sequence value |
| ACCRUAL_REV_PERIOD_NAME | Reversed journal entry reversal period |
| CLOSE_ACCT_SEQ_VERSION_ID | Close account sequence version defining column |
| CLOSE_ACCT_SEQ_ASSIGN_ID | Close account sequence value |
| ACCRUAL_REV_STATUS | Reversed journal entry status |
| CLOSE_ACCT_SEQ_VALUE | Close account sequence assignment defining column |
| ACCRUAL_REV_JE_HEADER_ID | Reversed journal entry defining column |
| ACCRUAL_REV_CHANGE_SIGN_FLAG | Type of reversal (Change Sign or Switch Dr/Cr) |
| DESCRIPTION | Journal entry description |
| CONTROL_TOTAL | Control total column |
| LEDGER_ID | Ledger defining column |
| RUNNING_TOTAL_DR | Journal entry running total debits, entered currency |
| RUNNING_TOTAL_CR | Journal entry running total credits, entered currency |
| RUNNING_TOTAL_ACCOUNTED_DR | Journal entry running total debits, base currency |
| RUNNING_TOTAL_ACCOUNTED_CR | Journal entry running total credits, base currency |
| JE_CATEGORY | Journal entry category |
| JE_SOURCE | Journal entry source |
| PERIOD_NAME | Accounting period |
| NAME | Journal entry header name |
| CURRENCY_CODE | Currency |
| General Ledger - GL_JE_LINES | Journal entry lines |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID | Journal entry header defining column |
| CREATION_DATE | Standard Who column |
| JGZZ_RECON_STATUS | Global reconciliation descriptive flexfield segment |
| GLOBAL_ATTRIBUTE_CATEGORY | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE1 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE2 | Reserved for country-specific functionality |
| CREATED_BY | Standard Who column |
| GLOBAL_ATTRIBUTE3 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE4 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE5 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE6 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE7 | Reserved for country-specific functionality |
| LAST_UPDATE_LOGIN | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| GLOBAL_ATTRIBUTE8 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE9 | Reserved for country-specific functionality |
| GLOBAL_ATTRIBUTE10 | Reserved for country-specific functionality |
| JGZZ_RECON_STATUS_11I | No Longer Used in R12 |
| JGZZ_RECON_DATE_11I | No Longer Used in R12 |
| JGZZ_RECON_ID_11I | No Longer Used in R12 |
| ENTERED_DR | Journal entry line debit amount in entered currency |
| JGZZ_RECON_REF_11I | No Longer Used in R12 |
| JGZZ_RECON_CONTEXT_11I | No Longer Used in R12 |
| TAXABLE_LINE_FLAG | Taxable line flag for automatic tax calculations |
| TAX_TYPE_CODE | Tax type (Input or Output) for automatic tax calculations |
| TAX_CODE_ID | Tax code defining column for automatic tax calculations |
| ENTERED_CR | Journal entry line credit amount in entered currency |
| TAX_ROUNDING_RULE_CODE | Rounding rule used for automatic tax calculations |
| AMOUNT_INCLUDES_TAX_FLAG | Amount includes tax flag for automatic tax calculations |
| TAX_DOCUMENT_IDENTIFIER | Tax document identifier |
| TAX_DOCUMENT_DATE | Tax document date |
| TAX_CUSTOMER_NAME | Tax customer name |
| ACCOUNTED_DR | Journal entry line debit amount in base currency |
| TAX_CUSTOMER_REFERENCE | Tax customer reference |
| TAX_REGISTRATION_NUMBER | Tax registration number |
| TAX_LINE_FLAG | Automatically generated tax line flag |
| TAX_GROUP_ID | Tax group id for automatic tax calculations |
| ACCOUNTED_CR | Journal entry line credit amount in base currency |
| CO_THIRD_PARTY | Columbian third party |
| CO_PROCESSED_FLAG | Columbian third party processed flag |
| DESCRIPTION | Journal entry line description |
| JE_LINE_NUM | Journal entry line number |
| JGZZ_RECON_CONTEXT | Global reconciliation descriptive flexfield context column |
| LINE_TYPE_CODE | Line type |
| REFERENCE_1 | Journal entry line reference column |
| REFERENCE_2 | Journal entry line reference column |
| REFERENCE_3 | Journal entry line reference column |
| REFERENCE_4 | Journal entry line reference column |
| REFERENCE_5 | Journal entry line reference column |
| LAST_UPDATE_DATE | Standard Who column |
| REFERENCE_6 | Journal entry line reference column |
| REFERENCE_7 | Journal entry line reference column |
| LAST_UPDATED_BY | Standard Who column |
| JGZZ_RECON_DATE | Global reconciliation descriptive flexfield segment |
| REFERENCE_8 | Journal entry line reference column |
| REFERENCE_9 | Journal entry line reference column |
| LEDGER_ID | Ledger defining column |
| REFERENCE_10 | Journal entry line reference column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| ATTRIBUTE8 | Descriptive flexfield segment |
| JGZZ_RECON_ID | Global reconciliation descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ATTRIBUTE16 | Descriptive flexfield segment |
| ATTRIBUTE17 | Descriptive flexfield segment |
| PERIOD_NAME | Accounting period |
| ATTRIBUTE18 | Descriptive flexfield segment |
| ATTRIBUTE19 | Descriptive flexfield segment |
| ATTRIBUTE20 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| CONTEXT2 | Descriptive flexfield context column |
| INVOICE_DATE | Value added tax descriptive flexfield column |
| TAX_CODE | Value added tax descriptive flexfield column |
| INVOICE_IDENTIFIER | Value added tax descriptive flexfield column |
| INVOICE_AMOUNT | Value added tax descriptive flexfield column |
| NO1 | Value added tax descriptive flexfield column |
| EFFECTIVE_DATE | Journal entry line effective date |
| STAT_AMOUNT | Statistical Amount |
| JGZZ_RECON_REF | Global reconciliation descriptive flexfield segment |
| IGNORE_RATE_FLAG | Modify amounts if exchange rate changes |
| CONTEXT3 | Descriptive flexfield context column |
| USSGL_TRANSACTION_CODE | Government transaction code |
| SUBLEDGER_DOC_SEQUENCE_ID | Sequential numbering sequence defining column |
| CONTEXT4 | Descriptive flexfield structure defining column |
| SUBLEDGER_DOC_SEQUENCE_VALUE | Sequential numbering sequence value |
| STATUS | Journal entry line status |
| GL_SL_LINK_ID | Link to associated subledger data |
| GL_SL_LINK_TABLE | Table containing associated subledger data |
| General Ledger - GL_JE_SOURCES_TL | Journal entry sources |
|---|---|
| Column Name | Descritpion |
| JE_SOURCE_NAME | Journal entry source name |
| SOURCE_LANG | Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well. |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| OVERRIDE_EDITS_FLAG | Frozen source |
| USER_JE_SOURCE_NAME | Journal entry source user defined name |
| JOURNAL_REFERENCE_FLAG | Populate GL_IMPORT_REFERENCES with reference information from subledger |
| JOURNAL_APPROVAL_FLAG | Journal approval flag |
| EFFECTIVE_DATE_RULE_CODE | Non-business day rule (Roll Date, Leave Alone, or Fail) |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DESCRIPTION | Journal entry source description |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| IMPORT_USING_KEY_FLAG | Import using journal source key flag |
| JE_SOURCE_KEY | Journal entry source key |
| LANGUAGE | Language |
| General Ledger - GL_AUTOREVERSE_OPTIONS | Reversal criteria for generating automatic journal reversals |
|---|---|
| Column Name | Descritpion |
| AUTOREVERSE_FLAG | Indicates if automatic reversal is enabled |
| AUTOPOST_REVERSAL_FLAG | Indicates if reversals are to be automatically posted |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CRITERIA_SET_ID | Accounting books defining column |
| CREATED_BY | Standard Who column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| REVERSAL_DATE_CODE | Rule used to default the reversal date |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| JE_CATEGORY_NAME | Journal entry category name |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| METHOD_CODE | Reversal method |
| REVERSAL_PERIOD_CODE | Rule used to default the reversal period |
| General Ledger - GL_AUTO_ALLOC_SETS | Autoallocation set definition for step-down or parallel allocations |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_SET_ID | Allocation set defining column |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ALLOCATION_SET_TYPE_CODE | Allocation set type |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield segment |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| PERIOD_SET_NAME | Accounting calendar name |
| ACCOUNTED_PERIOD_TYPE | Accounting period type |
| SECURITY_FLAG | Enable definition access set security flag |
| ALLOCATION_SET_NAME | Allocation set name |
| SET_OF_BOOKS_ID | Accounting sets of books defining column |
| ALLOCATION_CODE | Responsibility used to create this record (GL for General Ledger and PA for Projects) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| ORG_ID | Organization Id for multi org installation. Used only for project autoallocation sets. |
| DESCRIPTION | Allocation set description |
| OWNER | Default contact specified for an Allocation set who will receive notifications when any error occurs in a Step-down allocation set run |
| SET_OF_BOOKS_ID_11I | No Longer Used in R12 |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| General Ledger - GL_AUTO_ALLOC_BATCHES | Assignments of MassAllocation, Mass Budgets, Mass Encumbrances, Recurring Journals or Projects batches to an allocation set |
|---|---|
| Column Name | Descritpion |
| BATCH_ID | Defining column for Massallocation batch,Recurring Journal Batch, or Project batch. |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context |
| BATCH_TYPE_CODE | Batch type (MassAllocations, MassBudgets, MassEncumbrances, Recurring Journals, or Project) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| STEP_NUMBER | Sequence in which batch is to be generated by step-down set. |
| ALLOCATION_SET_ID | Allocation set defining column |
| OWNER | The owner/role specified for a Allocation batch who will receive a notification when any error occurs in Step-down allocations set |
| ALLOCATION_METHOD_CODE | Allocation method used for batch generation. |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| General Ledger - GL_AUTO_ALLOC_BATCH_HISTORY | History of all batches included in an allocation set run |
|---|---|
| Column Name | Descritpion |
| BATCH_ID | Defining column for Massalocation batch, Recurring Journal batch, MassBudget batch, or Project batch. |
| BATCH_TYPE_CODE | Batch Type (Massallocations, MassBudgets, MassEncumbrances, Recurring Journals, or Project Allocations) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| STEP_NUMBER | Sequence in which batch is to be generated for step-down set. |
| REQUEST_ID | Auto allocation concurrent request id |
| OWNER | The owner/role specified for an Allocation batch who will receive notifications when any errors occur in Allocations |
| ALLOCATION_METHOD_CODE | Allocation method used for batch generation. |
| GENERATED_JE_BATCH_ID | Defining column for generated journal batch |
| PA_ALLOCATION_RUN_ID | Defining column for generated project rule id |
| STATUS_CODE | Run status of each step in the allocation set |
| COMPLETE_FLAG | Flag to indicate that step is generated and posted |
| ALL_HEADERS_REVERSED | Flag to indicate that all headers for the generated batch are reversed during rollback |
| General Ledger - GL_AUTO_ALLOC_BAT_HIST_DET | Status of concurrent program submitted for each step in the allocation set |
|---|---|
| Column Name | Descritpion |
| PROGRAM_NAME_CODE | Concurrent program name code |
| PARENT_REQUEST_ID | Auto allocate concurrent request id |
| STEP_NUMBER | Sequence in which steps are generated |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| REQUEST_ID | Defining column for submitted concurrent request |
| RUN_MODE | Normal or Rollback mode |
| STATUS_CODE | Status of concurrent program |
| General Ledger - GL_AUTO_ALLOC_REV_BATCHES | Reverse journal batches generated by AutoAllocation rollback process |
|---|---|
| Column Name | Descritpion |
| REVERSAL_JE_BATCH_ID | Defining column of the reversal batch |
| REQUEST_ID | Reverse Journal concurrent program request id |
| PARENT_REQUEST_ID | Auto allocation concurrent request id |
| JE_BATCH_ID | Defining column for Journal batch for which reversal is generated. |
| JE_HEADER_ID | Defining column for Journal batch for which reversal is generated |
| BATCH_TYPE_CODE | Batch Type (MassAllocations, MassBudgets, MassEncumbrances, Recurring Journals, or Project Allocations) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| REVERSAL_JE_HEADER_ID | Defining column of the reversal journal header. |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| General Ledger - GL_AUTO_ALLOC_SET_HISTORY | History of allocation set runs |
|---|---|
| Column Name | Descritpion |
| ALLOCATION_SET_ID | Allocation set defining column |
| EXPENDITURE_ITEM_DATE | Expenditure item date for project |
| MONITOR_URL | URL address of work flow monitor |
| ACCESS_SET_ID | Access set defining column |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| PERIOD_SET_NAME | Accounting calendar name |
| ACCOUNTED_PERIOD_TYPE | Accounting period type |
| BALANCING_SEGMENT_VALUE | Balancing segment value |
| LEDGER_CURRENCY | Ledger currency |
| ALLOCATION_CODE | Responsibility used to create this record (GL for General Ledger and PA for Projects) |
| ALLOCATION_SET_TYPE_CODE | Set type ( Step-Down or Parallel) |
| SET_OF_BOOKS_ID | Accounting books defining column |
| LEDGER_ID | Ledger defining column |
| ALLOCATION_SET_NAME | Allocation set name |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| REQUEST_ID | Auto Allocation concurrent request id |
| CREATED_BY | Standard Who column |
| ORG_ID | Organization Id for multi org installation. Used only for project allocation sets. |
| DESCRIPTION | Allocation set description |
| OWNER | The owner/role specified for an Allocation set who will receive notifications when any error occurs in Allocations |
| PERIOD_NAME | Accounting period for creating journals |
| BUDGET_VERSION_ID | Defining column for budget to be used for recurring batch. |
| JOURNAL_EFFECTIVE_DATE | Journal effective date for creating journals |
| CALCULATION_EFFECTIVE_DATE | Calculation effective date for retrieving average balances. |
| USAGE_CODE | Code to determine whether to generate a standard or Average journal batch |
| GL_PERIOD_NAME | Accounting period for GL batch |
| PA_PERIOD_NAME | Accounting period for project batch |
| General Ledger - GL_CONCURRENT_SCHEDULES | Oracle General Ledger concurrent schedule definitions |
|---|---|
| Column Name | Descritpion |
| PERIOD_SET_NAME | Accounting calendar defining column |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield segment |
| PERIOD_TYPE | Accounting period type defining column |
| RUN_DAY | The day of the accounting period on which the schedule becomes active |
| RUN_TIME | The time on run_day when the schedule becomes active. |
| ENABLED_FLAG | Enable/Disable schedule |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who Column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| CREATION_DATE | Standard Who Column |
| SCHEDULE_NAME | Name of schedule as defined by the user |
| CREATED_BY | Standard Who Column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segement |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| General Ledger - GL_ELIMINATION_HISTORY | Intercompany elimination history |
|---|---|
| Column Name | Descritpion |
| REQUEST_ID | Intercompany elimination request id |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ELIMINATION_SET_ID | Intercompany elimination set defining column |
| LEDGER_ID | Accounting books defining column |
| SET_OF_BOOKS_ID | Accounting books defining column |
| STATUS_CODE | Elimination status |
| PERIOD_NAME | Elimination period |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| ELIMINATION_RUN_ID | Elimination run process defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| JE_BATCH_ID | Batch id generated by the eliminations program |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| General Ledger - GL_ELIMINATION_JOURNALS | Intercompany elimination journals |
|---|---|
| Column Name | Descritpion |
| JOURNAL_ID | Elimination journal defining column |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| JOURNAL_NAME | Elimination journal name |
| JE_CATEGORY | Journal entry category |
| CURRENCY_CODE | Currency |
| AMOUNT_TYPE | Amount type (YTD, QTD, PTD, etc...) |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| ELIMINATION_SET_ID | Intercompany elimination set defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| General Ledger - GL_ELIMINATION_SETS | Intercompany elimination set definitions |
|---|---|
| Column Name | Descritpion |
| NAME | Elimination set name |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| LEDGER_ID | Accounting books defining column |
| ATTRIBUTE15 | Descriptive flexfield segment |
| SECURITY_FLAG | |
| TRACK_ELIMINATION_STATUS_FLAG | Indicates whether this elimination set should be considered in determining the elimination status |
| SET_OF_BOOKS_ID | Accounting books defining column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| ELIMINATION_SET_ID | Intercompany elimination set defining column |
| START_DATE_ACTIVE | Date before which the elimination set is not active |
| END_DATE_ACTIVE | Date after which the elimination set is not active |
| ELIMINATION_COMPANY | Elimination company |
| LAST_EXECUTED_PERIOD | Last executed period for the elimination set |
| DESCRIPTION | Elimination set description |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| General Ledger - GL_ELIM_ACCOUNTS_MAP | Intercompany elimination account mappings |
|---|---|
| Column Name | Descritpion |
| LINE_NUMBER | Line number for account mapping |
| SOURCE_SEGMENT13 | Source key flexfield segment |
| SOURCE_SEGMENT14 | Source key flexfield segment |
| SOURCE_SEGMENT15 | Source key flexfield segment |
| SOURCE_SEGMENT16 | Source key flexfield segment |
| SOURCE_SEGMENT17 | Source key flexfield segment |
| SOURCE_SEGMENT18 | Source key flexfield segment |
| SOURCE_SEGMENT19 | Source key flexfield segment |
| SOURCE_SEGMENT20 | Source key flexfield segment |
| SOURCE_SEGMENT21 | Source key flexfield segment |
| SOURCE_SEGMENT22 | Source key flexfield segment |
| CREATION_DATE | Standard Who column |
| SOURCE_SEGMENT23 | Source key flexfield segment |
| SOURCE_SEGMENT24 | Source key flexfield segment |
| SOURCE_SEGMENT25 | Source key flexfield segment |
| SOURCE_SEGMENT26 | Source key flexfield segment |
| SOURCE_SEGMENT27 | Source key flexfield segment |
| SOURCE_SEGMENT28 | Source key flexfield segment |
| SOURCE_SEGMENT29 | Source key flexfield segment |
| SOURCE_SEGMENT30 | Source key flexfield segment |
| TARGET_SEGMENT1 | Target key flexfield segment |
| TARGET_SEGMENT2 | Target key flexfield segment |
| CREATED_BY | Standard Who column |
| TARGET_SEGMENT3 | Target key flexfield segment |
| TARGET_SEGMENT4 | Target key flexfield segment |
| TARGET_SEGMENT5 | Target key flexfield segment |
| TARGET_SEGMENT6 | Target key flexfield segment |
| TARGET_SEGMENT7 | Target key flexfield segment |
| TARGET_SEGMENT8 | Target key flexfield segment |
| TARGET_SEGMENT9 | Target key flexfield segment |
| TARGET_SEGMENT10 | Target key flexfield segment |
| TARGET_SEGMENT11 | Target key flexfield segment |
| TARGET_SEGMENT12 | Target key flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| TARGET_SEGMENT13 | Target key flexfield segment |
| TARGET_SEGMENT14 | Target key flexfield segment |
| TARGET_SEGMENT15 | Target key flexfield segment |
| TARGET_SEGMENT16 | Target key flexfield segment |
| TARGET_SEGMENT17 | Target key flexfield segment |
| TARGET_SEGMENT18 | Target key flexfield segment |
| TARGET_SEGMENT19 | Target key flexfield segment |
| TARGET_SEGMENT20 | Target key flexfield segment |
| TARGET_SEGMENT21 | Target key flexfield segment |
| TARGET_SEGMENT22 | Target key flexfield segment |
| LAST_UPDATED_BY | Standard Who column |
| TARGET_SEGMENT23 | Target key flexfield segment |
| TARGET_SEGMENT24 | Target key flexfield segment |
| TARGET_SEGMENT25 | Target key flexfield segment |
| TARGET_SEGMENT26 | Target key flexfield segment |
| TARGET_SEGMENT27 | Target key flexfield segment |
| TARGET_SEGMENT28 | Target key flexfield segment |
| TARGET_SEGMENT29 | Target key flexfield segment |
| TARGET_SEGMENT30 | Target key flexfield segment |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| SOURCE_SEGMENT1 | Source key flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| SOURCE_SEGMENT2 | Source key flexfield segment |
| JOURNAL_ID | Elimination journal defining column |
| SOURCE_SEGMENT3 | Source key flexfield segment |
| SOURCE_SEGMENT4 | Source key flexfield segment |
| SOURCE_SEGMENT5 | Source key flexfield segment |
| SOURCE_SEGMENT6 | Source key flexfield segment |
| SOURCE_SEGMENT7 | Source key flexfield segment |
| SOURCE_SEGMENT8 | Source key flexfield segment |
| SOURCE_SEGMENT9 | Source key flexfield segment |
| SOURCE_SEGMENT10 | Source key flexfield segment |
| SOURCE_SEGMENT11 | Source key flexfield segment |
| SOURCE_SEGMENT12 | Source key flexfield segment |
| General Ledger - GL_ELIM_BAL_OPTIONS | Intercompany elimination balancing options. |
|---|---|
| Column Name | Descritpion |
| BALANCING_OPTION_CODE | Balancing option code |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| CREATION_DATE | Standard Who column |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| NET_DR_DIFFERENCE_CCID | Net debit difference account |
| NET_CR_DIFFERENCE_CCID | Net credit difference account |
| ELIMINATION_SET_ID | Intercompany elimination set defining column |
| THRESHOLD_RULE | Threshold rule |
| THRESHOLD_AMOUNT | Constant threshold amount |
| THRESHOLD_JOURNAL_PERCENT | Threshold journal percentage |
| THRESHOLD_ACCOUNT_PERCENT | Threshold account percentage |
| THRESHOLD_CCID | Threshold account |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| General Ledger - GL_INTERCOMPANY_ACC_SETS | Intercompany transaction processing rules |
|---|---|
| Column Name | Descritpion |
| JE_SOURCE_NAME | Journal entry source |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| JE_CATEGORY_NAME | Journal entry category |
| BALANCE_BY_CODE | Indicate whether to balance by summary or detail |
| SET_OF_BOOKS_ID | Accounting books defining column |
| BAL_SEG_RULE_CODE | Balancing option to use when no clearing company is specified |
| ALWAYS_BALANCE_FLAG | Indicates if intercompany transactions should always be balanced by clearing company |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LEDGER_ID | Accounting books defining column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| DEFAULT_BAL_SEG_VALUE | Default balancing segment value |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| General Ledger - GL_IEA_AUTOGEN_MAP | Automatic account generation mapping rules for the Global Intercompany System |
|---|---|
| Column Name | Descritpion |
| RECEIVER_CHART_OF_ACCT_ID | Key flexfield structure defining column for the receiver's chart of accounts |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| USE_SENDER_CLEAR_RULES_FLAG | Sender clearing account rules enabled flag |
| USE_RECEIVER_CLEAR_RULES_FLAG | Receiver clearing account rules enabled flag |
| USE_RECEIVER_DIST_RULES_FLAG | Receiver distribution account rules enabled flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| SENDER_CHART_OF_ACCT_ID | Key flexfield structure defining column for the sender's chart of accounts |
| LAST_UPDATE_LOGIN | Standard Who column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| General Ledger - GL_IEA_IMPORT_REGISTRY | Global Intercompany System import execution control |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_TYPE_ID | Transaction defining column |
| REQUEST_ID | Concurrent program request defining column |
| GROUP_ID | Interface group defining column |
| General Ledger - GL_IEA_INTERFACE | Transactional data for import into Global Intercompany System |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_TYPE_ID | Transaction type defining column |
| SENDER_SEGMENT7 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT8 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT9 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT10 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT11 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT12 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT13 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT14 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT15 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT16 | Sending subsidiary key flexfield segment |
| TRANSACTION_STATUS_CODE | Transaction status |
| SENDER_SEGMENT17 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT18 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT19 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT20 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT21 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT22 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT23 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT24 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT25 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT26 | Sending subsidiary key flexfield segment |
| CURRENCY_CODE | Transaction currency |
| SENDER_SEGMENT27 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT28 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT29 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT30 | Sending subsidiary key flexfield segment |
| RECEIVER_SEGMENT1 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT2 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT3 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT4 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT5 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT6 | Receiving subsidiary key flexfield segment |
| GL_DATE | Accounting date for the transaction |
| RECEIVER_SEGMENT7 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT8 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT9 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT10 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT11 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT12 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT13 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT14 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT15 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT16 | Receiving subsidiary key flexfield segment |
| SENDER_SUBSIDIARY_ID | Sending subsidiary defining column |
| RECEIVER_SEGMENT17 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT18 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT19 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT20 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT21 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT22 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT23 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT24 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT25 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT26 | Receiving subsidiary key flexfield segment |
| RECEIVER_SUBSIDIARY_ID | Receiving subsidiary defining column |
| RECEIVER_SEGMENT27 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT28 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT29 | Receiving subsidiary key flexfield segment |
| RECEIVER_SEGMENT30 | Receiving subsidiary key flexfield segment |
| LINE_DEBIT | Transaction line debit amount |
| LINE_CREDIT | Transaction line credit amount |
| LAST_MODIFIED_BY | Defining column for user who last modified the row |
| LAST_MODIFICATION_DATE | Last modified date |
| SENDER_CHART_OF_ACCOUNTS_ID | Sending subsidiary Key flexfield structure defining column |
| RECEIVER_CHART_OF_ACCOUNTS_ID | Receiving subsidiary key flexfield structure defining column |
| LINE_TYPE | Line type defining column (clearing or distribution) |
| REQUEST_ID | Concurrent program request ID |
| COMPLETION_STATUS_CODE | Status of row at completion |
| TRANSACTION_NUMBER | Transaction number |
| GROUP_ID | Interface group defining column |
| DESCRIPTION | Intercompany transaction description |
| NOTE | Intercompany transaction note |
| SENDER_CODE_COMBINATION_ID | Sending subsidiary key flexfield defining column |
| RECEIVER_CODE_COMBINATION_ID | Receiving subsidiary key flexfield defining column |
| SENDER_SEGMENT1 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT2 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT3 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT4 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT5 | Sending subsidiary key flexfield segment |
| SENDER_SEGMENT6 | Sending subsidiary key flexfield segment |
| General Ledger - GL_IEA_SEGMENT_MAP | Automatic account generation segment mapping rules for the Global Intercompany System |
|---|---|
| Column Name | Descritpion |
| GENERATE_TYPE_CODE | Indicates if the system generates Sender Clearing Accounts, Receiver Clearing Accounts or Receiver Distribution Accounts |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| SENDER_CHART_OF_ACCT_ID | Key flexfield structure defining column for the sender's chart of accounts |
| RECEIVER_CHART_OF_ACCT_ID | Key flexfield structure defining column for the receiver's chart of accounts |
| TO_APPLICATION_COLUMN_NAME | Segment column name of the target chart of accounts |
| SEGMENT_MAP_TYPE_CODE | Determines the action the system will use to derive the segment values in its target chart of accounts |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| SEGMENT_MAP_ID | Segment map defining column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| FROM_APPLICATION_COLUMN_NAME | Segment column name of the source chart of accounts |
| SINGLE_VALUE | The single detail segment value used when the segment map type is Assign Single Value |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| General Ledger - GL_IEA_SEGMENT_RULE_MAP | Automatic account generation individual segment mapping rules for the Global Intercompany System |
|---|---|
| Column Name | Descritpion |
| TRANSACTION_TYPE_ID | GIS transaction type or -1 which represents Other |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| CONTEXT | Descriptive flexfield context column |
| TO_SUBSIDIARY_ID | Target subsidiary defining column or -1 which represents Other |
| FROM_SUBSIDIARY_ID | Source subsidiary defining column or -1 which represents Other |
| FROM_SEG_VALUE | Source segment value or a value greater than 25 characters long which represents Other |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| SEGMENT_MAP_ID | Segment map rule defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| TO_SEG_VALUE | Target segment value |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| General Ledger - GL_JOURNAL_REPORTS_ITF | Interface table for RXi Oracle General Ledger journal reports. |
|---|---|
| Column Name | Descritpion |
| BATCH_ID | Batch defining column |
| JE_CC_DESC | Cost center segment description |
| JE_SECONDARY_SEG | Secondary segment |
| JE_SECONDARY_DESC | Secondary segment description |
| JE_CONTRA_ACCT | Contra account segment |
| JE_CONTRA_ACCT_DESC | Contra account description |
| HEADER_ID | Journal entry header defining column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| JE_LINE_NUM | Journal entry line number |
| REQUEST_ID | Request defining column of the extract request |
| ORGANIZATION_NAME | Accounting books name |
| FUNCTIONAL_CURRENCY_CODE | Functional currency code |
| BATCH_STATUS | Batch status |
| BATCH_TYPE | Batch type (Actual, Budget, or Encumbrance) |
| BATCH_JOURNAL_TYPE | Journal type (Standard or Average) |
| BATCH_APPROVAL_STATUS | Batch approval status |
| BATCH_BUDGET_CONTROL_STATUS | Budgetary control status |
| EXCHANGE_TYPE | Currency conversion type |
| DOC_SEQUENCE_NAME | Sequential numbering sequence name |
| TAX_STATUS | Journal entry tax status |
| HEADER_ENCUMBRANCE_TYPE | Encumbrance type |
| HEADER_BUDGET_NAME | Budget name |
| SUBLEDGER_DOC_SEQ_NAME | Subledger sequential numbering sequence name |
| TAX_CODE | Tax code |
| TAX_TYPE | Tax type (Input or Output) |
| JE_ACCOUNT | Account |
| JE_ACCOUNT_DESC | Account description |
| JE_BALANCE | Balancing segment value |
| JE_BALANCE_DESC | Balancing segment description |
| JE_NATACCT | Natural account segment value |
| JE_NATACCT_DESC | Natural account segment description |
| JE_CC | Cost center segment value |
| General Ledger - GL_EFC_CHANGED_TRX | Transactions that need to be reprocessed by the Euro as Functional Currency process |
|---|---|
| Column Name | Descritpion |
| EURO_SET_OF_BOOKS_ID | Euro set of books defining column |
| APPLICATION_ID | Application defining column |
| TABLE_NAME | Table name |
| PK_ID | Transaction primary key value |
| PK_ID2 | Transaction primary key value |
| PK_ID3 | Transaction primary key value |
| ACTION_CODE | Action required for reprocessing |
| REFERENCE1 | EFC reference column |
| NCU_SET_OF_BOOKS_ID | NCU set of books defining column |
| REFERENCE2 | EFC reference column |
| REFERENCE3 | EFC reference column |
| REFERENCE4 | EFC reference column |
| REFERENCE5 | EFC reference column |
| General Ledger - GL_EFC_BUDGET_MAPPING | Budget and budget organization mappings for Euro as Functional Currency process |
|---|---|
| Column Name | Descritpion |
| MAPPING_TYPE_CODE | Mapping type code (Budget 'B' or Budget Organization 'O') |
| EURO_ID | Euro budget or budget organization defining column |
| NCU_SET_OF_BOOKS_ID | NCU set of books defining column |
| EURO_SET_OF_BOOKS_ID | Euro set of books defining column |
| LAST_UPDATE_DATE | Standard Who Column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who Column |
| CREATED_BY | Standard Who column |
| NCU_ID | NCU budget or budget organization defining column |
| CREATION_DATE | Standard Who Column |
| General Ledger - GL_EFC_DISABLED_TRIGGERS | Triggers disabled by the Euro as Functional Currency process |
|---|---|
| Column Name | Descritpion |
| TRIGGER_NAME | Disabled trigger name |
| OWNER | Schema that owns the trigger |
| General Ledger - GL_EFC_RUN_HISTORY | Euro as Functional Currency process history |
|---|---|
| Column Name | Descritpion |
| NCU_SET_OF_BOOKS_ID | NCU set of books defining column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATED_BY | Standard Who column |
| EURO_SET_OF_BOOKS_ID | Euro set of books defining column |
| CREATION_DATE | Standard Who column |
| START_PK_ID | Primary key value of first record processed |
| APPLICATION_ID | Application defining column |
| LAST_PROCESSED_PK_ID | Primary key value of the last record in the table to be processed |
| MAX_PK_ID | Primary key value of the last record in the table to be processed |
| TABLE_NAME | Table name |
| ERROR_MESSAGE_NAME | Error message name |
| ERROR_TOKEN1 | Token 1 for error message name |
| RUN_PHASE_CODE | EFC Phase/Step |
| ERROR_TOKEN2 | Token 2 for error message name |
| ERROR_TOKEN3 | Token 3 for error message name |
| RUN_ID | EFC process defining column |
| ORA_ERROR | Oracle errors |
| REFERENCE1 | EFC reference column |
| RUN_STATUS_CODE | EFC run status C-Completed I- In process E-Exception |
| REFERENCE2 | EFC reference column |
| REFERENCE3 | EFC reference column |
| LAST_UPDATE_DATE | Standard Who Column |
| REFERENCE4 | EFC reference column |
| REFERENCE5 | EFC reference column |
| LAST_UPDATED_BY | Standard Who column |
| General Ledger - GL_BALANCES_DELTA | Incremental changes to account balances |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| QUARTER_TO_DATE_DR | Quarter to date debit balance |
| QUARTER_TO_DATE_CR | Quarter to date credit balance |
| PROJECT_TO_DATE_DR | Accumulated project debit balance(life to date balance) |
| PROJECT_TO_DATE_CR | Accumulated project credit balance |
| BEGIN_BALANCE_DR | Beginning debit balance |
| BEGIN_BALANCE_CR | Beginning credit balance |
| PERIOD_NET_DR_BEQ | Period to date debit balance, base currency |
| PERIOD_NET_CR_BEQ | Period to date credit balance, base currency |
| BEGIN_BALANCE_DR_BEQ | Year to date debit balance, base currency |
| BEGIN_BALANCE_CR_BEQ | Year to date credit balance, base currency |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| CURRENCY_CODE | Currency |
| SET_OF_BOOKS_ID | Accounting books defining column |
| PERIOD_NAME | Accounting period |
| ACTUAL_FLAG | Balance type(Actual, Budget, or Encumbrance) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| DELTA_RUN_ID | Posting run defining column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| TRANSLATED_FLAG | Translated balance flag |
| TEMPLATE_ID | Summary template defining column |
| PERIOD_YEAR | Accounting period year |
| PERIOD_NUM | Accounting period number |
| PERIOD_NET_DR | Period net debit balance |
| PERIOD_NET_CR | Period net credit balance |
| General Ledger - GL_BALANCES_DELTA_INTERIM | Interim tracking of incremental account balances |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Accounting books defining column |
| QUARTER_TO_DATE_DR | Quarter to date debit balance |
| QUARTER_TO_DATE_CR | Quarter to date credit balance |
| PROJECT_TO_DATE_DR | Accumulated project debit balance(life to date balance) |
| PROJECT_TO_DATE_CR | Accumulated project credit balance |
| BEGIN_BALANCE_DR | Beginning debit balance |
| BEGIN_BALANCE_CR | Beginning credit balance |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| CURRENCY_CODE | Currency |
| SET_OF_BOOKS_ID | Accounting books defining column |
| PERIOD_NAME | Accounting period |
| ACTUAL_FLAG | Balance type(Actual, Budget, or Encumbrance) |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| DELTA_RUN_ID | Posting run defining column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| TRANSLATED_FLAG | Translated balance flag |
| TEMPLATE_ID | Summary template defining column |
| PERIOD_YEAR | Accounting period year |
| PERIOD_NUM | Accounting period number |
| PERIOD_NET_DR | period net debit balance |
| PERIOD_NET_CR | Period net credit balance |
| General Ledger - GL_EXTRACT_HISTORY | Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract Incremental Balances |
|---|---|
| Column Name | Descritpion |
| EXTRACT_PROGRAM_CODE | Extract program(OFA) |
| PERIOD_NAME | Accounting period |
| ACTUAL_FLAG | Balance type(Actual, Budget, or Encumbrance) |
| SET_OF_BOOKS_ID | Accounting books defining column |
| EXTRACT_LEVEL_CODE | Detail level of extraction |
| BUDGET_VERSION_ID | Budget version defining column(-100 -for no budgets) |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column(-1 -total of all encumbrances, -2 -for all encumbrances, -100 -for no encumbrances) |
| TEMPLATE_ID | Summary template defining column(-1 -for all summary templateds, -100 - for no summary templates) |
| MAX_DELTA_RUN_ID | Posting run defining column |
| LEDGER_ID | Accounting books defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_LEDGER_BSV_GT | |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| FLEX_VALUE | |
| DESCRIPTION |
| General Ledger - GL_LEDGER_LE_BSV_GT | |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| LEGAL_ENTITY_ID | |
| LEGAL_ENTITY_NAME | |
| START_DATE | |
| END_DATE | |
| RELATIONSHIP_ENABLED_FLAG | |
| LEDGER_NAME | |
| LEDGER_SHORT_NAME | |
| LEDGER_CATEGORY_CODE | |
| CHART_OF_ACCOUNTS_ID | |
| BAL_SEG_VALUE_OPTION_CODE | |
| BAL_SEG_VALUE_SET_ID | |
| BAL_SEG_COLUMN_NAME | |
| BAL_SEG_VALUE |
| General Ledger - GL_ACCESS_SETS | Data access set definitions |
|---|---|
| Column Name | Descritpion |
| ACCESS_SET_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| CREATED_BY | |
| CREATION_DATE | |
| SECURED_SEG_VALUE_SET_ID | |
| DEFAULT_LEDGER_ID | |
| DESCRIPTION | |
| CONTEXT | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| NAME | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| SECURITY_SEGMENT_CODE | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ENABLED_FLAG | |
| CHART_OF_ACCOUNTS_ID | |
| PERIOD_SET_NAME | |
| ACCOUNTED_PERIOD_TYPE | |
| AUTOMATICALLY_CREATED_FLAG | |
| LAST_UPDATED_BY |
| General Ledger - GL_ACCESS_SET_ASSIGNMENTS | Flattened data access set privilege assignments |
|---|---|
| Column Name | Descritpion |
| ACCESS_SET_ID | |
| CREATED_BY | |
| START_DATE | |
| END_DATE | |
| LEDGER_ID | |
| SEGMENT_VALUE | |
| ACCESS_PRIVILEGE_CODE | |
| PARENT_RECORD_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CREATION_DATE |
| General Ledger - GL_ACCESS_SET_NORM_ASSIGN | Data access set privilege assignments |
|---|---|
| Column Name | Descritpion |
| ACCESS_SET_ID | |
| CREATION_DATE | |
| CREATED_BY | |
| SEGMENT_VALUE | |
| START_DATE | |
| END_DATE | |
| STATUS_CODE | |
| LINK_ID | |
| REQUEST_ID | |
| CONTEXT | |
| ATTRIBUTE1 | |
| LEDGER_ID | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ALL_SEGMENT_VALUE_FLAG | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| SEGMENT_VALUE_TYPE_CODE | |
| ACCESS_PRIVILEGE_CODE | |
| RECORD_ID | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| General Ledger - GL_BC_PACKETS_HISTS | GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS. |
|---|---|
| Column Name | Descritpion |
| PACKET_ID | Budgetary control packet defining column |
| QUARTER_NUM | Accounting period quarter |
| CURRENCY_CODE | Currency |
| STATUS_CODE | Funds check/reservation status |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| BUDGET_VERSION_ID | Budget version defining column |
| ENCUMBRANCE_TYPE_ID | Encumbrance type defining column |
| TEMPLATE_ID | Summary template defining column |
| ENTERED_DR | Transaction debit amount in entered currency |
| ENTERED_CR | Transaction credit amount in entered currency |
| LEDGER_ID | Ledger defining column |
| ACCOUNTED_DR | Transaction debit amount in functional currency |
| ACCOUNTED_CR | Transaction credit amount in functional currency |
| USSGL_TRANSACTION_CODE | Government transaction code |
| ORIGINATING_ROWID | Row id of originating budgetary or proprietary transaction for a USSGL generated budgetary or proprietary transaction |
| ACCOUNT_SEGMENT_VALUE | Value of key flexfield account segment |
| AUTOMATIC_ENCUMBRANCE_FLAG | Automatically create encumbrance batch |
| FUNDING_BUDGET_VERSION_ID | Budget version defining column of funding budget |
| FUNDS_CHECK_LEVEL_CODE | Funds checking severity level |
| AMOUNT_TYPE | Amount type (Period to date, year to date, etc.) |
| BOUNDARY_CODE | Budgetary control time interval end point |
| JE_SOURCE_NAME | Journal entry source name |
| TOLERANCE_PERCENTAGE | Percentage of funding budget that can be exceeded |
| TOLERANCE_AMOUNT | Allowable amount to exceed funding budget |
| OVERRIDE_AMOUNT | Maximum transaction amount that can be used to override a funds check failure |
| DR_CR_CODE | Debit or credit transaction |
| ACCOUNT_TYPE | Key flexfield combination type (Asset, liability, ..., Budgetary Dr/Cr) |
| ACCOUNT_CATEGORY_CODE | Key flexfield category (Proprietary or budgetary) |
| EFFECT_ON_FUNDS_CODE | Effect of transaction on funds available, increasing or decreasing |
| RESULT_CODE | Result of funds check/reservation |
| BUDGET_POSTED_BALANCE | Posted balance used in funds available calculation |
| ACTUAL_POSTED_BALANCE | Posted balance used in funds available calculation |
| JE_CATEGORY_NAME | Journal entry category name |
| ENCUMBRANCE_POSTED_BALANCE | Posted balance used in funds available calculation |
| BUDGET_APPROVED_BALANCE | Balance approved, but not posted |
| ACTUAL_APPROVED_BALANCE | Balance approved, but not posted |
| ENCUMBRANCE_APPROVED_BALANCE | Balance approved, but not posted |
| BUDGET_PENDING_BALANCE | Balance pending funds check |
| ACTUAL_PENDING_BALANCE | Balance pending funds check |
| ENCUMBRANCE_PENDING_BALANCE | Balance pending funds check |
| REFERENCE1 | Journal entry line reference column |
| REFERENCE2 | Journal entry line reference column |
| REFERENCE3 | Journal entry line reference column |
| CODE_COMBINATION_ID | Key flexfield combination defining column |
| REFERENCE4 | Journal entry line reference column |
| REFERENCE5 | Journal entry line reference column |
| JE_BATCH_NAME | Journal entry batch name |
| JE_BATCH_ID | Journal entry batch defining column |
| JE_HEADER_ID | Journal entry header defining column |
| JE_LINE_NUM | Journal entry line number |
| JE_LINE_DESCRIPTION | Journal entry line description |
| REFERENCE6 | Journal entry line reference column |
| REFERENCE7 | Journal entry line reference column |
| REFERENCE8 | Journal entry line reference column |
| ACTUAL_FLAG | Balance type (Actual, Budget, or Encumbrance) |
| REFERENCE9 | Journal entry line reference column |
| REFERENCE10 | Journal entry line reference column |
| REFERENCE11 | Journal entry line reference column |
| REFERENCE12 | Journal entry line reference column |
| REFERENCE13 | Journal entry line reference column |
| REFERENCE14 | Journal entry line reference column |
| REFERENCE15 | Journal entry line reference column |
| REQUEST_ID | Concurrent request defining column |
| USSGL_PARENT_ID | Identifier for a budgetary transaction containing a transaction code |
| USSGL_LINK_TO_PARENT_ID | Identifier of the originating budgetary transaction |
| EVENT_ID | Business Event identifier |
| PERIOD_NAME | Accounting period |
| AE_HEADER_ID | XLA journal entry header defining column |
| AE_LINE_NUM | XLA journal entry line defining column |
| BC_DATE | Validation Date for account validation |
| SOURCE_DISTRIBUTION_TYPE | Source Distribution Type |
| SOURCE_DISTRIBUTION_ID_CHAR_1 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_2 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_3 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_4 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_CHAR_5 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_1 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_2 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_3 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_4 | Source Reference Column |
| SOURCE_DISTRIBUTION_ID_NUM_5 | Source Reference Column |
| SESSION_ID | Session Id of calling session |
| SERIAL_ID | Serial# of the calling session |
| APPLICATION_ID | Source Application Id |
| ENTITY_ID | Entity Identifier |
| GROUP_ID | Interface group identifying column |
| PERIOD_YEAR | Accounting period year |
| PERIOD_NUM | Accounting period number |
| General Ledger - GL_LEDGER_RELATIONSHIPS | Relationships between ledgers |
|---|---|
| Column Name | Descritpion |
| RELATIONSHIP_ID | Relationship defining column |
| RELATIONSHIP_TYPE_CODE | Relationship level between source and target ledger |
| RELATIONSHIP_ENABLED_FLAG | Enabled flag |
| INHERIT_CREATION_USER_FLAG | Inherit creation flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| GL_JE_CONVERSION_SET_ID | Journal conversion rules identifier |
| SL_COA_MAPPING_ID | Key flexfield structure defining column |
| SOURCE_LEDGER_ID | Ledger identifier where reporting currency conversions are based from transactions/journals/balances |
| AUTOMATIC_POST_FLAG | Automatic posting flag |
| ALC_DEFAULT_CONV_RATE_TYPE | Default conversion rate type for reporting ledger journal |
| ALC_NO_RATE_ACTION_CODE | When no rate exists report error or use last available rate |
| ALC_MAX_DAYS_ROLL_RATE | Maximum roll days allowed for a conversion rate |
| ALC_INHERIT_CONVERSION_TYPE | Inherit conversion rate type from transaction, i.e. do not use the default ALC_DEFAULT_CONV_RATE_TYPE |
| ALC_INIT_CONV_OPTION_CODE | Historical conversion option (Derive, Initialize) |
| ALC_INIT_PERIOD | First accounting period for reporting currency |
| ALC_INIT_DATE | First accounting date for reporting currency |
| ALC_INITIALIZING_RATE_DATE | Rate date used for initializing historical transactions/balances |
| ALC_INITIALIZING_RATE_TYPE | Rate type used for initializing historical transactions/balances |
| TARGET_LEDGER_ID | Destination ledger defining column for conversion of transactions/journals/balances |
| ALC_PERIOD_AVERAGE_RATE_TYPE | Reporting currency period average rate type |
| ALC_PERIOD_END_RATE_TYPE | Reporting currency period end rate type |
| APPLICATION_ID | Application defining column (backward compatible only) |
| ORG_ID | Operating unit defining column (backward compatible only) |
| DISABLE_CONVERSION_DATE | Disable conversion date |
| STATUS_CODE | Status code |
| HIST_CONV_STATUS_CODE | Historical Conversion Status Code |
| SLA_LEDGER_ID | Ledger identifier in the subledger transactions used for creating subledger accounting entries |
| PRIMARY_LEDGER_ID | Ledger identifier of the primary ledger as defined in the accounting configuration |
| TARGET_CURRENCY_CODE | Target ledger currency code |
| TARGET_LEDGER_NAME | Target ledger name |
| TARGET_LEDGER_SHORT_NAME | Target ledger short name |
| TARGET_LEDGER_CATEGORY_CODE | Target ledger category (PRIMARY, SECONDARY, ALC etc) |
| General Ledger - GL_BUDORG_BC_OPTIONS | |
|---|---|
| Column Name | Descritpion |
| RANGE_ID | |
| LAST_UPDATE_DATE | |
| FUNDING_BUDGET_VERSION_ID | |
| FUNDS_CHECK_LEVEL_CODE | |
| AMOUNT_TYPE | |
| BOUNDARY_CODE | |
| CREATED_BY | |
| CREATION_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| General Ledger - GL_JE_INCLUSION_RULES | Journal Inclusion rule |
|---|---|
| Column Name | Descritpion |
| JE_SOURCE_NAME | Journal entry source |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| JE_CATEGORY_NAME | Journal entry category |
| USER_UPDATABLE_FLAG | Indicates whether this is a user updatable rule or not |
| INCLUDE_FLAG | Indicate whether this journal source/category will be included or excluded for processing |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| JE_RULE_SET_ID | Journal inclusion rule set identifier |
| LAST_UPDATED_BY | Standard Who column |
| CONTEXT | Descriptive flexfield context |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| General Ledger - GL_LEDGER_NORM_SEG_VALS | Valid balancing segment values for ledger |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Ledger defining column |
| CREATED_BY | Standard Who column |
| START_DATE | Start date |
| END_DATE | End date |
| STATUS_CODE | Status code |
| REQUEST_ID | Request defining column |
| LEGAL_ENTITY_ID | Legal entity defining column |
| SLA_SEQUENCING_FLAG | Subledger architecture sequencing flag |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| SEGMENT_TYPE_CODE | Segment type defining column |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| SEGMENT_VALUE | Segment value |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| SEGMENT_VALUE_TYPE_CODE | Segment value type |
| RECORD_ID | Record defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_ISPEED_COA_SEGMENTS | Chart of Accounts segments information. |
|---|---|
| Column Name | Descritpion |
| VALUE_SET_NAME | Value Set associated with this segment |
| SEGMENT_NUMBER | Segment number (display sequence) |
| SEGMENT_NAME | Segment name |
| LENGTH | Length of segment (number of characters) |
| USAGE | Segment usage |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| COA_TEMPLATE_ID | Chart of Accounts template defining column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_LEDGER_SEGMENT_VALUES | Flattened valid balancing segment values for ledger |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Ledger defining column |
| END_DATE | End date |
| START_DATE | Start date |
| STATUS_CODE | Status code |
| LEGAL_ENTITY_ID | Legal entity defining column |
| SLA_SEQUENCING_FLAG | Subledger architecture sequencing flag |
| SEGMENT_TYPE_CODE | Segment type defining column |
| SEGMENT_VALUE | Segment value |
| PARENT_RECORD_ID | Parent record defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| General Ledger - GL_ISPEED_COA_TEMPLATES | Chart of Accounts template definition. |
|---|---|
| Column Name | Descritpion |
| COA_NAME | Chart of Accounts name |
| NUMBER_OF_SEGMENTS | Number of segments in this Chart of Accounts |
| DESCRIPTION | Chart of Accounts description |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| COA_TEMPLATE_ID | Chart of Accounts template defining column. |
| General Ledger - GL_LEDGER_SET_ASSIGNMENTS | Flattened ledger set assignments |
|---|---|
| Column Name | Descritpion |
| LEDGER_SET_ID | Ledger set defining column |
| STATUS_CODE | Status code |
| LEDGER_ID | Ledger defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| START_DATE | Start date |
| END_DATE | End date |
| General Ledger - GL_LEDGER_SET_NORM_ASSIGN | Ledger set assignments |
|---|---|
| Column Name | Descritpion |
| LEDGER_SET_ID | Ledger set defining column |
| STATUS_CODE | Status code |
| REQUEST_ID | Request defining column |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| LEDGER_ID | Ledger defining column |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| START_DATE | Start date |
| END_DATE | End date |
| General Ledger - GL_LEDGER_SET_REQUESTS | Ledger set child request status. |
|---|---|
| Column Name | Descritpion |
| PARENT_REQUEST_ID | Parent request defining column |
| CREATED_BY | Standard Who column |
| ERROR_MESSAGE | Error message text |
| CHILD_REQUEST_ID | Child request defining column |
| STATUS_CODE | The current status of the child concurrent request |
| LEDGER_SET_ID | Ledger set defining column |
| LEDGER_ID | Ledger defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_LEGAL_ENTITIES_BSVS | Legal entity balancing segment value assignments. |
|---|---|
| Column Name | Descritpion |
| LEGAL_ENTITY_ID | Legal entity defining column |
| CREATED_BY | Standard Who column |
| FLEX_VALUE_SET_ID | Key flexfield segment value set defining column |
| FLEX_SEGMENT_VALUE | Key flexfield segment value |
| START_DATE | Start date |
| END_DATE | End date |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CREATION_DATE | Standard Who column |
| General Ledger - GL_LEDGERS | Ledger definition |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | Ledger defining column |
| CONFIGURATION_ID | Link to an accounting setup definition |
| CHART_OF_ACCOUNTS_ID | Key flexfield structure defining column |
| CURRENCY_CODE | Currency |
| PERIOD_SET_NAME | Accounting calendar name |
| ACCOUNTED_PERIOD_TYPE | Accounting period type |
| FIRST_LEDGER_PERIOD_NAME | First ledger accounting period name |
| RET_EARN_CODE_COMBINATION_ID | Retained earnings key flexfield defining column |
| SUSPENSE_ALLOWED_FLAG | Suspense posting allowed flag |
| ALLOW_INTERCOMPANY_POST_FLAG | Allow intercompany posting flag |
| TRACK_ROUNDING_IMBALANCE_FLAG | Track rounding imbalances flag |
| NAME | Ledger name |
| ENABLE_AVERAGE_BALANCES_FLAG | Enable average balances flag |
| CUM_TRANS_CODE_COMBINATION_ID | Cumulative translation adjustment key flexfield defining column |
| RES_ENCUMB_CODE_COMBINATION_ID | Reserve for encumbrance key flexfield defining column |
| NET_INCOME_CODE_COMBINATION_ID | Net income key flexfield defining column |
| ROUNDING_CODE_COMBINATION_ID | Track rounding imbalances key flexfield defining column |
| ENABLE_BUDGETARY_CONTROL_FLAG | Enable budgetary control flag |
| REQUIRE_BUDGET_JOURNALS_FLAG | Journal required for budget flag |
| ENABLE_JE_APPROVAL_FLAG | Enable journal entry approval flag |
| ENABLE_AUTOMATIC_TAX_FLAG | Enable automatic tax flag |
| CONSOLIDATION_LEDGER_FLAG | ADB Consolidation ledger flag |
| SHORT_NAME | Ledger short name |
| TRANSLATE_EOD_FLAG | ADB Translate EOD balances flag |
| TRANSLATE_QATD_FLAG | ADB Translate QATD balances flag |
| TRANSLATE_YATD_FLAG | ADB Translate YATD balances flag |
| TRANSACTION_CALENDAR_ID | ADB Transaction calendar defining column |
| DAILY_TRANSLATION_RATE_TYPE | ADB: The rate type to be used for translation of average balances |
| AUTOMATICALLY_CREATED_FLAG | Automatically created flag used for ledger sets |
| BAL_SEG_VALUE_OPTION_CODE | Balancing segment value option |
| BAL_SEG_COLUMN_NAME | Balancing segment column name |
| MGT_SEG_VALUE_OPTION_CODE | Management segment value option |
| MGT_SEG_COLUMN_NAME | Management segment column name |
| DESCRIPTION | Description |
| BAL_SEG_VALUE_SET_ID | Balancing segment value set ID |
| MGT_SEG_VALUE_SET_ID | Management segment value set ID |
| IMPLICIT_ACCESS_SET_ID | Implicit access set ID |
| CRITERIA_SET_ID | Journal reversal criteria set defining column |
| FUTURE_ENTERABLE_PERIODS_LIMIT | Number of future enterable periods |
| LEDGER_ATTRIBUTES | The compiled values of any segment qualifier assigned to the segment value |
| IMPLICIT_LEDGER_SET_ID | Implicit ledger set ID |
| LATEST_OPENED_PERIOD_NAME | Latest opened accounting period name |
| LATEST_ENCUMBRANCE_YEAR | Latest open year for encumbrances |
| PERIOD_AVERAGE_RATE_TYPE | Default balances level period average rate type used for actual translation |
| LEDGER_CATEGORY_CODE | Ledger category (PRIMARY, SECONDARY, ALC etc) |
| PERIOD_END_RATE_TYPE | Default balances level period end rate type used for actual translation |
| BUDGET_PERIOD_AVG_RATE_TYPE | Default balances level period average rate type used for budget translation |
| BUDGET_PERIOD_END_RATE_TYPE | Default balances level period end rate type used for budget translation |
| SLA_ACCOUNTING_METHOD_CODE | Subledger accounting method code |
| SLA_ACCOUNTING_METHOD_TYPE | Subledger accounting method type |
| SLA_DESCRIPTION_LANGUAGE | Subledger accounting description language |
| SLA_ENTERED_CUR_BAL_SUS_CCID | Suspense account used for balancing subledger journal entries by entered currency |
| SLA_SEQUENCING_FLAG | Required for SLA (Yes/No) |
| SLA_BAL_BY_LEDGER_CURR_FLAG | Subledger balance by ledger currency flag |
| SLA_LEDGER_CUR_BAL_SUS_CCID | Suspense account used for balancing subledger journal entries by ledger currency |
| ALC_LEDGER_TYPE_CODE | Reporting currency type (NONE, TARGET, SOURCE) |
| ENABLE_SECONDARY_TRACK_FLAG | Enable secondary tracking for closing and translation flag |
| ENABLE_REVAL_SS_TRACK_FLAG | Enable secondary tracking for revaluation flag |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| OBJECT_TYPE_CODE | Ledger type (ledger or ledger set) |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| LE_LEDGER_TYPE_CODE | Ledger legal type (Legal, management) |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| ENABLE_RECONCILIATION_FLAG | Enable journal reconciliation flag |
| CREATE_JE_FLAG | Create journal flag |
| SLA_LEDGER_CASH_BASIS_FLAG | Subledger cash basis accounting flag |
| COMPLETE_FLAG | Ledger complete flag |
| COMMITMENT_BUDGET_FLAG | Commitment Budget Flag |
| NET_CLOSING_BAL_FLAG | |
| AUTOMATE_SEC_JRNL_REV_FLAG | |
| COMPLETION_STATUS_CODE | Ledger setup status (Not Started, Incomplete, Complete) |
| General Ledger - GL_DEFAS_ACCESS_SETS | Definition access set definitions |
|---|---|
| Column Name | Descritpion |
| DEFINITION_ACCESS_SET_ID | |
| CONTEXT | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| USER_DEFINITION_ACCESS_SET | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| DEFINITION_ACCESS_SET | |
| LAST_UPDATE_DATE | |
| LAST_UPDATE_LOGIN | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| DESCRIPTION |
| General Ledger - GL_DEFAS_RESP_ASSIGN | Assignment of definition access sets to responsibilities |
|---|---|
| Column Name | Descritpion |
| APPLICATION_ID | |
| DEFAULT_VIEW_ACCESS_FLAG | |
| DEFAULT_USE_ACCESS_FLAG | |
| DEFAULT_MODIFY_ACCESS_FLAG | |
| STATUS_CODE | |
| REQUEST_ID | |
| CONTEXT | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| RESPONSIBILITY_ID | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| DEFINITION_ACCESS_SET_ID | |
| ATTRIBUTE15 | |
| SECURITY_GROUP_ID | Security group identifier |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CREATION_DATE | |
| CREATED_BY | |
| DEFAULT_FLAG |
| General Ledger - GL_LEDGER_CONFIGURATIONS | Primary ledgers |
|---|---|
| Column Name | Descritpion |
| CONFIGURATION_ID | Accounting setup defining column |
| LAST_UPDATED_BY | Standard Who column |
| CONTEXT | Descriptive flexfield context column |
| ATTRIBUTE1 | Descriptive flexfield segment |
| ATTRIBUTE2 | Descriptive flexfield segment |
| ATTRIBUTE3 | Descriptive flexfield segment |
| ATTRIBUTE4 | Descriptive flexfield segment |
| ATTRIBUTE5 | Descriptive flexfield segment |
| ATTRIBUTE6 | Descriptive flexfield segment |
| ATTRIBUTE7 | Descriptive flexfield segment |
| ATTRIBUTE8 | Descriptive flexfield segment |
| NAME | Accounting setup name |
| ATTRIBUTE9 | Descriptive flexfield segment |
| ATTRIBUTE10 | Descriptive flexfield segment |
| ATTRIBUTE11 | Descriptive flexfield segment |
| ATTRIBUTE12 | Descriptive flexfield segment |
| ATTRIBUTE13 | Descriptive flexfield segment |
| ATTRIBUTE14 | Descriptive flexfield segment |
| ATTRIBUTE15 | Descriptive flexfield segment |
| DESCRIPTION | Description |
| COMPLETION_STATUS_CODE | Accounting setup status |
| ACCTG_ENVIRONMENT_CODE | Accounting environment type |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| General Ledger - GL_LEDGER_CONFIG_DETAILS | Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup. |
|---|---|
| Column Name | Descritpion |
| CONFIGURATION_ID | Accounting setup defining column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| OBJECT_TYPE_CODE | Object type |
| OBJECT_ID | Object defining column |
| OBJECT_NAME | Object name |
| SETUP_STEP_CODE | Setup step |
| NEXT_ACTION_CODE | Next action |
| STATUS_CODE | Setup step status |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_DEFAS_ASSIGNMENTS | Definition access set privilege assignments |
|---|---|
| Column Name | Descritpion |
| DEFINITION_ACCESS_SET_ID | |
| CREATION_DATE | |
| CREATED_BY | |
| STATUS_CODE | |
| REQUEST_ID | |
| CONTEXT | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| OBJECT_TYPE | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| OBJECT_KEY | |
| VIEW_ACCESS_FLAG | |
| USE_ACCESS_FLAG | |
| MODIFY_ACCESS_FLAG | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN |
| General Ledger - GL_COA_MAPPINGS | Chart of accounts mapping definitions |
|---|---|
| Column Name | Descritpion |
| COA_MAPPING_ID | |
| CREATED_BY | |
| DESCRIPTION | |
| START_DATE_ACTIVE | |
| END_DATE_ACTIVE | |
| TO_COA_ID | |
| FROM_COA_ID | |
| NAME | |
| SECURITY_FLAG | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| LAST_UPDATE_LOGIN | |
| CREATION_DATE |
| General Ledger - GL_FIXED_CONV_RATES | Fixed conversion rates for changes in national currency |
|---|---|
| Column Name | Descritpion |
| OLD_CURRENCY | Old currency |
| REPLACEMENT_CURRENCY | Replacement currency |
| FIXED_CONVERSION_RATE | Fixed conversion rate from the old currency to the replacement currency |
| EFFECTIVE_START_DATE | The fixed rate relationship is valid from this date |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_JE_LINES_RECON | |
|---|---|
| Column Name | Descritpion |
| JE_LINE_NUM | Journal entry line number |
| LEDGER_ID | Ledger defining column |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| JGZZ_RECON_STATUS | Reconcilation status |
| JE_HEADER_ID | Journal entry header defining column |
| JGZZ_RECON_DATE | Reconcilation date |
| JGZZ_RECON_ID | Reconcilation identifier |
| JGZZ_RECON_REF | Reconcilation reference |
| General Ledger - GL_JE_SEGVALS_UPGRADE | |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID |
| General Ledger - GL_JE_SEGMENT_VALUES | Journal entry balancing and management segment values. |
|---|---|
| Column Name | Descritpion |
| JE_HEADER_ID | Journal entry defining column |
| SEGMENT_TYPE_CODE | Segment Type (balancing or management) |
| SEGMENT_VALUE | Segment value |
| CREATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_AUTOREV_CRITERIA_SETS | Journal reversal criteria sets |
|---|---|
| Column Name | Descritpion |
| CRITERIA_SET_ID | |
| ATTRIBUTE2 | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| CRITERIA_SET_NAME | |
| ATTRIBUTE12 | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| CONTEXT | |
| SECURITY_FLAG | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN | |
| CRITERIA_SET_DESC | |
| ATTRIBUTE1 |
| General Ledger - GL_LEDGER_SETS | Ledger set definition |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| CONFIGURATION_ID | |
| CHART_OF_ACCOUNTS_ID | |
| CURRENCY_CODE | |
| PERIOD_SET_NAME | |
| ACCOUNTED_PERIOD_TYPE | |
| FIRST_LEDGER_PERIOD_NAME | |
| RET_EARN_CODE_COMBINATION_ID | |
| SUSPENSE_ALLOWED_FLAG | |
| ALLOW_INTERCOMPANY_POST_FLAG | |
| TRACK_ROUNDING_IMBALANCE_FLAG | |
| NAME | |
| ENABLE_AVERAGE_BALANCES_FLAG | |
| CUM_TRANS_CODE_COMBINATION_ID | |
| RES_ENCUMB_CODE_COMBINATION_ID | |
| NET_INCOME_CODE_COMBINATION_ID | |
| ROUNDING_CODE_COMBINATION_ID | |
| ENABLE_BUDGETARY_CONTROL_FLAG | |
| REQUIRE_BUDGET_JOURNALS_FLAG | |
| ENABLE_JE_APPROVAL_FLAG | |
| ENABLE_AUTOMATIC_TAX_FLAG | |
| CONSOLIDATION_LEDGER_FLAG | |
| SHORT_NAME | |
| TRANSLATE_EOD_FLAG | |
| TRANSLATE_QATD_FLAG | |
| TRANSLATE_YATD_FLAG | |
| TRANSACTION_CALENDAR_ID | |
| DAILY_TRANSLATION_RATE_TYPE | |
| AUTOMATICALLY_CREATED_FLAG | |
| BAL_SEG_VALUE_OPTION_CODE | |
| BAL_SEG_COLUMN_NAME | |
| MGT_SEG_VALUE_OPTION_CODE | |
| MGT_SEG_COLUMN_NAME | |
| DESCRIPTION | |
| BAL_SEG_VALUE_SET_ID | |
| MGT_SEG_VALUE_SET_ID | |
| IMPLICIT_ACCESS_SET_ID | |
| CRITERIA_SET_ID | |
| FUTURE_ENTERABLE_PERIODS_LIMIT | |
| LEDGER_ATTRIBUTES | |
| IMPLICIT_LEDGER_SET_ID | |
| LATEST_OPENED_PERIOD_NAME | |
| LATEST_ENCUMBRANCE_YEAR | |
| PERIOD_AVERAGE_RATE_TYPE | |
| LEDGER_CATEGORY_CODE | |
| PERIOD_END_RATE_TYPE | |
| BUDGET_PERIOD_AVG_RATE_TYPE | |
| BUDGET_PERIOD_END_RATE_TYPE | |
| SLA_ACCOUNTING_METHOD_CODE | |
| SLA_ACCOUNTING_METHOD_TYPE | |
| SLA_DESCRIPTION_LANGUAGE | |
| SLA_ENTERED_CUR_BAL_SUS_CCID | |
| SLA_SEQUENCING_FLAG | |
| SLA_BAL_BY_LEDGER_CURR_FLAG | |
| SLA_LEDGER_CUR_BAL_SUS_CCID | |
| ALC_LEDGER_TYPE_CODE | |
| ENABLE_SECONDARY_TRACK_FLAG | |
| ENABLE_REVAL_SS_TRACK_FLAG | |
| LAST_UPDATE_DATE | |
| LAST_UPDATED_BY | |
| CREATION_DATE | |
| CREATED_BY | |
| LAST_UPDATE_LOGIN | |
| CONTEXT | |
| ATTRIBUTE1 | |
| ATTRIBUTE2 | |
| OBJECT_TYPE_CODE | |
| ATTRIBUTE3 | |
| ATTRIBUTE4 | |
| ATTRIBUTE5 | |
| ATTRIBUTE6 | |
| ATTRIBUTE7 | |
| ATTRIBUTE8 | |
| ATTRIBUTE9 | |
| ATTRIBUTE10 | |
| ATTRIBUTE11 | |
| ATTRIBUTE12 | |
| LE_LEDGER_TYPE_CODE | |
| ATTRIBUTE13 | |
| ATTRIBUTE14 | |
| ATTRIBUTE15 | |
| ENABLE_RECONCILIATION_FLAG | |
| CREATE_JE_FLAG | |
| SLA_LEDGER_CASH_BASIS_FLAG | |
| COMPLETION_STATUS_CODE |
| General Ledger - GL_CROSS_RATE_RULES | Cross Rate Rules |
|---|---|
| Column Name | Descritpion |
| CONVERSION_TYPE | Conversion Type Defining Column |
| PIVOT_CURRENCY | Currency from which to create cross rates rules from. |
| DESCRIPTION | Cross Rate Rule Description |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_CROSS_RATE_RULE_DTLS | Cross Rate Rule Details |
|---|---|
| Column Name | Descritpion |
| CONVERSION_TYPE | Conversion Type Defining Column |
| FROM_CURRENCY | From Currency |
| TO_CURRENCY | To Currency |
| ENABLED_FLAG | Future Use. Flag to indicate if cross rate shoud be generated or not for this combination. |
| LAST_UPDATE_DATE | Standard Who column |
| LAST_UPDATED_BY | Standard Who column |
| CREATION_DATE | Standard Who column |
| CREATED_BY | Standard Who column |
| LAST_UPDATE_LOGIN | Standard Who column |
| General Ledger - GL_DRILL_ACCOUNT_RANGES_GT | |
|---|---|
| Column Name | Descritpion |
| LEDGER_ID | |
| SEGMENT7 | |
| SEGMENT8 | |
| SEGMENT9 | |
| SEGMENT10 | |
| SEGMENT11 | |
| SEGMENT12 | |
| SEGMENT13 | |
| SEGMENT14 | |
| SEGMENT15 | |
| SEGMENT16 | |
| CHART_OF_ACCOUNTS_ID | |
| SEGMENT17 | |
| SEGMENT18 | |
| SEGMENT19 | |
| SEGMENT20 | |
| SEGMENT21 | |
| SEGMENT22 | |
| SEGMENT23 | |
| SEGMENT24 | |
| SEGMENT25 | |
| SEGMENT26 | |
| CODE_COMBINATION_ID | |
| SEGMENT27 | |
| SEGMENT28 | |
| SEGMENT29 | |
| SEGMENT30 | |
| ENABLED_FLAG | |
| SUMMARY_FLAG | |
| SEGMENT1 | |
| SEGMENT2 | |
| SEGMENT3 | |
| SEGMENT4 | |
| SEGMENT5 | |
| SEGMENT6 |
| General Ledger - GL_BUD_DOWNLOAD_GT | |
|---|---|
| Column Name | Descritpion |
| PERIOD1_AMOUNT | |
| PERIOD10_AMOUNT | |
| SEGMENT10_DESC | |
| SEGMENT11_DESC | |
| SEGMENT12_DESC | |
| SEGMENT13_DESC | |
| SEGMENT14_DESC | |
| SEGMENT15_DESC | |
| SEGMENT16_DESC | |
| SEGMENT17_DESC | |
| SEGMENT18_DESC | |
| SEGMENT19_DESC | |
| PERIOD11_AMOUNT | |
| SEGMENT20_DESC | |
| SEGMENT21_DESC | |
| SEGMENT22_DESC | |
| SEGMENT23_DESC | |
| SEGMENT24_DESC | |
| SEGMENT25_DESC | |
| SEGMENT26_DESC | |
| SEGMENT27_DESC | |
| SEGMENT28_DESC | |
| SEGMENT29_DESC | |
| PERIOD12_AMOUNT | |
| SEGMENT30_DESC | |
| CODE_COMBINATION_ID | |
| BNE_READ_ONLY_FLAG | |
| ACTUAL_FLAG | |
| PERIOD13_AMOUNT | |
| PERIOD14_AMOUNT | |
| PERIOD15_AMOUNT | |
| PERIOD16_AMOUNT | |
| PERIOD17_AMOUNT | |
| PERIOD18_AMOUNT | |
| PERIOD19_AMOUNT | |
| PERIOD2_AMOUNT | |
| PERIOD20_AMOUNT | |
| PERIOD21_AMOUNT | |
| PERIOD22_AMOUNT | |
| PERIOD23_AMOUNT | |
| PERIOD24_AMOUNT | |
| PERIOD25_AMOUNT | |
| PERIOD26_AMOUNT | |
| PERIOD27_AMOUNT | |
| PERIOD28_AMOUNT | |
| PERIOD29_AMOUNT | |
| PERIOD3_AMOUNT | |
| PERIOD30_AMOUNT | |
| PERIOD31_AMOUNT | |
| PERIOD32_AMOUNT | |
| PERIOD33_AMOUNT | |
| PERIOD34_AMOUNT | |
| PERIOD35_AMOUNT | |
| PERIOD36_AMOUNT | |
| PERIOD37_AMOUNT | |
| PERIOD38_AMOUNT | |
| PERIOD39_AMOUNT | |
| PERIOD4_AMOUNT | |
| PERIOD40_AMOUNT | |
| PERIOD41_AMOUNT | |
| PERIOD42_AMOUNT | |
| PERIOD43_AMOUNT | |
| PERIOD44_AMOUNT | |
| PERIOD45_AMOUNT | |
| PERIOD46_AMOUNT | |
| PERIOD47_AMOUNT | |
| PERIOD48_AMOUNT | |
| PERIOD49_AMOUNT | |
| PERIOD5_AMOUNT | |
| PERIOD50_AMOUNT | |
| PERIOD51_AMOUNT | |
| PERIOD52_AMOUNT | |
| PERIOD53_AMOUNT | |
| PERIOD54_AMOUNT | |
| PERIOD55_AMOUNT | |
| PERIOD56_AMOUNT | |
| PERIOD57_AMOUNT | |
| PERIOD58_AMOUNT | |
| PERIOD59_AMOUNT | |
| PERIOD6_AMOUNT | |
| PERIOD60_AMOUNT | |
| SEGMENT1 | |
| SEGMENT2 | |
| SEGMENT3 | |
| SEGMENT4 | |
| SEGMENT5 | |
| SEGMENT6 | |
| SEGMENT7 | |
| SEGMENT8 | |
| SEGMENT9 | |
| PERIOD7_AMOUNT | |
| SEGMENT10 | |
| SEGMENT11 | |
| SEGMENT12 | |
| SEGMENT13 | |
| SEGMENT14 | |
| SEGMENT15 | |
| SEGMENT16 | |
| SEGMENT17 | |
| SEGMENT18 | |
| SEGMENT19 | |
| PERIOD8_AMOUNT | |
| SEGMENT20 | |
| SEGMENT21 | |
| SEGMENT22 | |
| SEGMENT23 | |
| SEGMENT24 | |
| SEGMENT25 | |
| SEGMENT26 | |
| SEGMENT27 | |
| SEGMENT28 | |
| SEGMENT29 | |
| PERIOD9_AMOUNT | |
| SEGMENT30 | |
| SEGMENT1_DESC | |
| SEGMENT2_DESC | |
| SEGMENT3_DESC | |
| SEGMENT4_DESC | |
| SEGMENT5_DESC | |
| SEGMENT6_DESC | |
| SEGMENT7_DESC | |
| SEGMENT8_DESC | |
| SEGMENT9_DESC |
| General Ledger - GL_IMP_COA_SEG_VAL_INTERFACE | Interface table to capture data for the import of Chart of Accounts Segment Values. |
|---|---|
| Column Name | Descritpion |
| BATCH_NUMBER | Identifier to identify the set of records to be processed |
| ALLOW_BUDGETING | Allow budgeting segment value qualifier |
| ALLOW_POSTING | Allow posting segment value qualifier |
| ACCOUNT_TYPE | Account Type segment value qualifier |
| RECONCILE | Reconcile segment value qualifier |
| THIRD_PARTY_CONTROL_ACCOUNT | Third Party Control Account segment value qualifier |
| ENABLED_FLAG | Enabled Flag |
| EFFECTIVE_FROM | Effective start date for the segment value |
| EFFECTIVE_TO | Effective end date for the segment value |
| STATUS | Processing status for interface line. Initially populate with value 'N' |
| SEG_VAL_INT_ID | Sequence generated unique identifier for the Chart of Accounts Segment Values. |
| VALUE_SET_NAME | Value set name to which segment value need to be added or updated. |
| FLEX_VALUE | Segment value. |
| FLEX_DESC | Segment value description |
| PARENT_FLEX_VALUE | Parent flexfield value, if the value is being added to a dependent value set. |
| SUMMARY_FLAG | Parent value flag |
| ROLL_UP_GROUP | Rollup group Name, if the value is a parent value. |
| HIERARCHY_LEVEL | Hierarchy level |
| General Ledger - GL_IMP_COA_ERR_INTERFACE | Error message interface table for the Chart of Account Segment Values Import process. |
|---|---|
| Column Name | Descritpion |
| ERR_MESSAGE_ID | Message Id |
| LAST_UPDATE_LOGIN | Standard WHO columns |
| REQUEST_ID | Request identifier of last concurrent program to update this record. |
| PROGRAM_APPLICATION_ID | Application identifier of last concurrent program to update this record. |
| PROGRAM_ID | Program identifier of last concurrent program to update this record. |
| PROGRAM_UPDATE_DATE | Last update date of this record by a concurrent program. |
| INT_TABLE_NAME | Table Name of the interface table, for which the current error message is being logged. |
| INTERFACE_ID | The Interface id, which identifies a unique row in a particular interface table |
| MESSAGE_NUM | Message Number |
| MESSAGE_TEXT | Message Text |
| CREATED_BY | Standard WHO columns |
| CREATION_DATE | Standard WHO columns |
| LAST_UPDATED_BY | Standard WHO columns |
| LAST_UPDATE_DATE | Standard WHO columns |
| General Ledger - GL_IMP_COA_NORM_HIER_INTERFACE | Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values. |
|---|---|
| Column Name | Descritpion |
| BATCH_NUMBER | Identifier to identify the set of records to be processed |
| NORM_HIER_INT_ID | Sequence generated unique identifier for the Child Ranges for Parent Chart of Account Segment Values |
| VALUE_SET_NAME | Value set name to which segment value need to be added or updated |
| PARENT_FLEX_VALUE | Parent segment value for which child ranges are being defined |
| RANGE_ATTRIBUTE | Range attribute for the range. Valid values are 'P' for parent range and 'C' for child range. |
| CHILD_FLEX_VALUE_LOW | The low value of the range of child values. |
| CHILD_FLEX_VALUE_HIGH | The high value of the range of child values |
| STATUS | Processing status for interface line. Initially populate with value 'N'. |
No hay comentarios:
Publicar un comentario