My GL Table Descriptions hand book (I have big hands) part2

General Ledger - GL_STAT_ACCOUNT_UOM	Statistical units of measure
Column Name	Descritpion
ACCOUNT_SEGMENT_VALUE	Account segment value using this statistical unit of measure
UNIT_OF_MEASURE	Statistical unit of measure name
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
DESCRIPTION	Statistical unit of measure 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_STORAGE_PARAMETERS	Interim table storage parameters
Column Name	Descritpion
OBJECT_NAME	Table or index name
NEXT_EXTENT_SIZE_KB	Next extent size in KBytes
MAX_EXTENTS	Maximum number of extents
PCT_INCREASE	Percentage increase of new extent size
PCT_FREE	Percentage of free space reserved for future updates
DESCRIPTION	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
OBJECT_TYPE	Table or index
TABLESPACE_NAME	Tablespace name
INITIAL_EXTENT_SIZE_KB	Initial extent size in KBytes

General Ledger - GL_SUSPENSE_ACCOUNTS	Additional suspense accounts for source/category combinations
Column Name	Descritpion
LEDGER_ID	Ledger 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
JE_SOURCE_NAME	Journal entry source
SET_OF_BOOKS_ID	Accounting books defining column
JE_CATEGORY_NAME	Journal entry category
CODE_COMBINATION_ID	Key flexfield combination 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_SYSTEM_SETUP	System setup information
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
LAST_UPDATE_LOGIN	Standard Who column
INDEXED_SEGMENT	Key flexfield indexed segment
RECORDS_TO_PROCESS	Maximum number of records to process at a time
FLEX_CACHE_SIZE	Number of records to be buffered in memory from the table GL_CODE_COMBINATIONS
ARCHIVE_EASYLINK_FLAG	Journal import archive flag
ROLLBACK_SEGMENT	Rollback segment used by programs maintaining large amounts of data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

General Ledger - GL_ROLLUP_GROUP_SCORES	Rollup group usages
Column Name	Descritpion
SELECTIVITY_SCORE	Number of rows in GL_CODE_COMBINATIONS that fall within the child ranges of the rollup group
ROLLUP_GROUP_ID	Rollup group defining column
APPLICATION_COLUMN_NAME	Key Flexfield segment column
AVG_SCORE_PER_CHILD_RANGE	Average selectivity score for each child range in the rollup group
FLEX_VALUE_SET_ID	Key Flexfield value set defining column
NUMBER_OF_PARENT_VALUES	Number of parent values that belong to the rollup group

General Ledger - GL_SEGMENT_FREQUENCIES	Segment value and period usages
Column Name	Descritpion
STRUCTURE_ID	Not currently used
SEGMENT_NAME	Segment name (either a segment column name, 'PERIOD', or 'PERIODAB')
SEGMENT_VALUE	Segment value or period name
ROWS_THIS_VALUE	Number of rows with this segment value or period name

General Ledger - GL_TRANSACTION_RATE_EXCEPTIONS	No longer used
Column Name	Descritpion
TRANSACTION_TYPE	Type of transaction
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_TABLE	Name of the transaction table
GL_DATE	Date of the transaction in GL_PERIODS
IDENTIFIER1	Source table identifier
REFERENCE1	Reference column for more information
REFERENCE2	Reference column for more information
REFERENCE3	Reference column for more information
REQUEST_ID	Enhanced Who column
PROGRAM_APPLICATION_ID	Enhanced Who column
IDENTIFIER2	Source table identifier
PROGRAM_ID	Enhanced Who column
PROGRAM_UPDATE_DATE	Enhanced Who column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
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
TO_CURRENCY_CODE	Translation currency
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
UPDATE_ALLOWED_FLAG	Flag to allow/inhibit update
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context column
TRANSLATION_RATE	Translation exchange rate
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

General Ledger - GL_USSGL_ACCOUNT_PAIRS	USSGL account pairings
Column Name	Descritpion
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
CHART_OF_ACCOUNTS_ID	Key flexfield 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
USSGL_TRANSACTION_CODE	Government transaction code
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
DR_ACCOUNT_SEGMENT_VALUE	Key flexfield account segment value
CR_ACCOUNT_SEGMENT_VALUE	Key flexfield account segment value

General Ledger - GL_USSGL_TRANSACTION_CODES	USSGL transaction codes
Column Name	Descritpion
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
END_DATE_ACTIVE	Date before which government transaction code is valid
DESCRIPTION	Government transaction code description
ATTRIBUTE1	Descriptive flexfield segment
USSGL_TRANSACTION_CODE	Government transaction code
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
CREATION_DATE	Standard Who column
ASSOC_INTEREST_USSGL_CODE	Interest transaction code
ASSOC_DISCOUNT_USSGL_CODE	Discount transaction code
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
START_DATE_ACTIVE	Date after which government transaction code is valid

General Ledger - GL_WEIGHTED_AVG_DETAILS	No longer used
Column Name	Descritpion
TRANSACTION_TYPE	Type of transaction
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SOURCE_TABLE	Name of transaction table
CODE_COMBINATION_ID	Key flexfield combination defining column
ACCOUNTED_DR	Debit amount in base currency
ACCOUNTED_CR	Credit amount in base currency
TRANSACTION_DETAIL_TYPE	Details of transaction lines
TRANSLATED_DR	Debit amount in translated currency
TRANSLATED_CR	Credit amount in translated currency
TRANSLATION_RATE	Translation exchange rate
TRANSLATION_AMOUNT	Translation amount to use when no rate is provided
REQUEST_ID	Enhanced Who column
PROGRAM_APPLICATION_ID	Enhanced Who column
PROGRAM_ID	Enhanced Who column
PROGRAM_UPDATE_DATE	Enhanced Who column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
IDENTIFIER1	Source table identifier
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
IDENTIFIER2	Source table identifier
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
SET_OF_BOOKS_ID	Accounting books defining column
TO_CURRENCY_CODE	Translation currency
PERIOD_NAME	Accounting period
EXCEPTION_FLAG	Exception flag
AMOUNTS_FILLED_FLAG	Flag to indicate amounts filled

General Ledger - GL_TAX_CODES
Column Name	Descritpion
CONTEXT2	For Descriptive Flexfield Context
INVOICE_AMOUNT	For Descriptive Flexfield
INVOICE_DATE	For Descriptive Flexfield
INVOICE_IDENTIFIER	For Descriptive Flexfield
NO1	For Descriptive Flexfield
TAX_CODE	For Descriptive Flexfield

General Ledger - GL_SYSTEM_USAGES	System feature usage
Column Name	Descritpion
AVERAGE_BALANCES_FLAG	Average balances used in system flag
CONSOLIDATION_LEDGER_FLAG
EFB_UPGRADE_FLAG
CREATION_DATE	Standard Who column
RECONCILIATION_UPG_FLAG	Indicates whether reconcilation data has been upgraded
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

General Ledger - GL_NET_INCOME_ACCOUNTS	Net income accounts
Column Name	Descritpion
LEDGER_ID	Ledger defining column
PROGRAM_APPLICATION_ID	Enhanced Who column
PROGRAM_ID	Enhanced Who column
PROGRAM_UPDATE_DATE	Enhanced Who column
BAL_SEG_VALUE	Balancing segment value for which this account is the net income account
SET_OF_BOOKS_ID	Accounting books defining column
CODE_COMBINATION_ID	Net income account
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_ROW_MULTIPLIERS	Constant row multipliers
Column Name	Descritpion
MULTIPLIER	Multiplier
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

General Ledger - GL_TRANSACTION_CALENDAR	Transaction calendar definitions
Column Name	Descritpion
TRANSACTION_CALENDAR_ID	Transaction calendar defining column
THU_BUSINESS_DAY_FLAG	Indicates whether or not Thursday defaults to a business day
FRI_BUSINESS_DAY_FLAG	Indicates whether or not Friday defaults to a business day
SAT_BUSINESS_DAY_FLAG	Indicates whether or not Saturday defaults to a business day
SUN_BUSINESS_DAY_FLAG	Indicates whether or not Sunday defaults to a business day
NAME	Name of the transaction calendar
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 calendar 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
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
MON_BUSINESS_DAY_FLAG	Indicates whether or not Monday defaults to a business day
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
SECURITY_FLAG
TUE_BUSINESS_DAY_FLAG	Indicates whether or not Tuesday defaults to a business day
WED_BUSINESS_DAY_FLAG	Indicates whether or not Wednesday defaults to a business day

General Ledger - GL_TRANSACTION_DATES	Business vs. non-business days for transaction calendars
Column Name	Descritpion
TRANSACTION_CALENDAR_ID	Transaction calendar defining column
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
TRANSACTION_DATE	Transaction date
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
DAY_OF_WEEK	Day of week
BUSINESS_DAY_FLAG	Business day 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

General Ledger - GL_TAX_OPTIONS	Setup tax options
Column Name	Descritpion
LEDGER_ID	Accounting books defining column
CALCULATION_LEVEL_CODE	Level at which the tax amount will be rounded (Line or Journal)
ALLOW_ROUNDING_OVERRIDE_FLAG	Determines whether you are allowed to change the rounding rule in the Manual Journal Entry form
INPUT_ROUNDING_RULE_CODE	Default input rounding rule
OUTPUT_ROUNDING_RULE_CODE	Default output rounding rule
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
INPUT_TAX_CODE	Default input tax code
ORG_ID	Organization defining column
INPUT_AMT_INCL_TAX_FLAG	Default value for determining whether an input amount includes tax
OUTPUT_TAX_CODE	Default output tax code
OUTPUT_AMT_INCL_TAX_FLAG	Default value for determining whether an output amount includes tax
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
TAX_CURRENCY_CODE	Currency for tax calculations
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
TAX_PRECISION	Precision for tax calculations
TAX_MAU	Minimum accountable unit for tax calculations

General Ledger - GL_TAX_OPTION_ACCOUNTS	Setup tax options for natural account values
Column Name	Descritpion
LEDGER_ID	Accounting books defining column
AMOUNT_INCLUDES_TAX_FLAG	Default amount includes tax flag
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
ORG_ID	Organization defining column
TAX_CODE	Default tax code associated with this account
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
ACCOUNT_SEGMENT_VALUE	Natural account value
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
TAX_TYPE_CODE	Tax type associated with this account
ALLOW_TAX_CODE_OVERRIDE_FLAG	Determines whether you are allowed to change the tax code for this account in the Manual Journal Entry form

General Ledger - GL_MOVEMERGE_ACCOUNTS	Mass maintenance request account mappings
Column Name	Descritpion
MOVEMERGE_REQUEST_ID	Mass maintenance request 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
LINE_NUMBER	Mass maintenance account line number
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

General Ledger - GL_MOVEMERGE_REQUESTS	Mass maintenance request definitions
Column Name	Descritpion
MOVEMERGE_REQUEST_ID	Mass maintenance request defining column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Mass maintenance request description
CONCURRENT_REQUEST_ID	Concurrent request defining column
LAST_MOVEMERGE_PERIOD	Last period processed by this move/merge request
CONTEXT	Descriptive flexfield context
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
NAME	Mass maintenance request name
ATTRIBUTE6	Descriptive flexfield segment
SET_OF_BOOKS_ID	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
LEDGER_ID	Accounting books defining column
CHART_OF_ACCOUNTS_ID
ORIGINAL_MOVEMERGE_REQUEST_ID
STATUS_CODE	Mass maintenance request status code
REQUEST_TYPE_CODE	Mass maintenance request type code (Mass Creation or Move/Merge)
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_TRANSLATION_STATUSES	Foreign currency translation status of periods
Column Name	Descritpion
LEDGER_ID	Accounting books defining column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
LAST_UPDATE_LOGIN	Standard Who Column
TARGET_BUDGET_VERSION_ID	Target budget version defining column
REQUEST_ID	Enhanced Who column
PROGRAM_APPLICATION_ID	Enhanced Who column
PROGRAM_ID	Enhanced Who column
PROGRAM_UPDATE_DATE	Enhanced Who column
PERIOD_NAME	Translation Period
SET_OF_BOOKS_ID	Accounting books defining column
BAL_SEG_VALUE	Balancing segment value
TARGET_CURRENCY	Translation target currency
AVERAGE_TRANSLATION_FLAG	Translate average balances flag
ACTUAL_FLAG	Balance type (Actual or Budget)
STATUS	Translation status
LAST_RUN_DATE	Date on which translation was last run for this period, set of books, currency, balancing segment value, actual flag, and budget.
CREATION_DATE	Standard Who column

General Ledger - GL_MC_REPORTING_OPTIONS	Multiple reporting currency conversion options by application
Column Name	Descritpion
REPORTING_CURRENCY_CODE	Reporting book currency
APPLICATION_ID	Application defining column
DATE_BASIS	Date rule to convert the translation
ENABLED_FLAG	Flag to indicate if record is active (Y / N)
START_DATE	Date to start maintaining this reporting book
REPORTING_OPTION_ID	Reporting option defining column
ORG_ID	Operating unit defining column
FA_BOOK_TYPE_CODE	Asset book being reported
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
AP_SECONDARY_SET_OF_BOOKS_ID	Secondary reporting set of books for Payables
CONVERSION_TYPE	Conversion type to be used for converting between currencies
PRIMARY_SET_OF_BOOKS_ID	Primary accounting book defining column
INHERIT_CONVERSION_TYPE	Flag which indicates whether to inherit conversion type from the original transaction (Y/N)
END_DATE	Last date to maintain this reporting book
ATTRIBUTE_CATEGORY	Descriptive flexfield 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
REPORTING_SET_OF_BOOKS_ID	Reporting accounting book defining column
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	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
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
PRIMARY_CURRENCY_CODE	Primary book currency
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

General Ledger - GL_MC_CONVERSION_RULES	Multiple reporting currency conversion rules for Oracle General Ledger
Column Name	Descritpion
JE_CATEGORY_NAME	Journal entry category
CONVERSION_RULE	Conversion rule (CONVERT / NOT CONVERT)
DATE_BASIS	Date rule use to convert the transaction
REPORTING_OPTION_ID	Reporting option 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
CONVERSION_TYPE	Conversion type to be used for converting between currencies
INHERIT_CONVERSION_TYPE	Indicates whether to inherit conversion type from the original transaction
ATTRIBUTE_CATEGORY	Descriptive flexfield defining column
ATTRIBUTE1	Descriptive flexfield segment
PRIMARY_SET_OF_BOOKS_ID	Primary accounting book 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
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
REPORTING_SET_OF_BOOKS_ID	Reporting accounting book defining column
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
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
JE_SOURCE_NAME	Journal entry source

General Ledger - GL_LOOKUPS_OLD	General Ledger lookups
Column Name	Descritpion
LOOKUP_TYPE	Lookup type name
CONTEXT	Descriptive flex context
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LOOKUP_CODE	Lookup code name
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE15	Descriptive flexfield segment
MEANING	User-visible lookup code meaning
DESCRIPTION	Lookup code description
ENABLED_FLAG	Lookup code enabled flag
START_DATE_ACTIVE	Date that lookup code becomes enabled
END_DATE_ACTIVE	Date that lookup code becomes disabled

General Ledger - GL_PERIODS	Calendar period definitions
Column Name	Descritpion
PERIOD_SET_NAME	Accounting calendar name
QUARTER_START_DATE	Date on which the quarter containing this accounting period starts
PERIOD_TYPE	Accounting period type
PERIOD_YEAR	Accounting period year
PERIOD_NUM	Accounting period number
QUARTER_NUM	Quarter number of accounting period
ENTERED_PERIOD_NAME	User entered accounting period name
ADJUSTMENT_PERIOD_FLAG	Calendar period adjustment status
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PERIOD_NAME	System generated accounting period name
DESCRIPTION	Accounting period description
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
CONTEXT	Descriptive flexfield context column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
START_DATE	Date on which accounting period begins
END_DATE	Date on which accounting period ends
YEAR_START_DATE	Date on which the year containing this accounting period starts

General Ledger - GL_PERIOD_SETS	Calendar definitions
Column Name	Descritpion
PERIOD_SET_NAME	Accounting calendar name
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context column
PERIOD_SET_ID	Oracle Internal use only - reserved for future use
LAST_UPDATE_DATE	Standard Who column
SECURITY_FLAG
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Accounting calendar description
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment

General Ledger - GL_PERIOD_STATUSES	Calendar period statuses
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
ELIMINATION_CONFIRMED_FLAG	Elimination confirmed flag
CHRONOLOGICAL_SEQ_STATUS_CODE	Chronological sequence maintenance status
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
LEDGER_ID
MIGRATION_STATUS_CODE	Migration status
TRACK_BC_YTD_FLAG	Track budgetary debit/credit accounts as balance sheet accounts
PERIOD_NAME	Accounting period name
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CLOSING_STATUS	Accounting period status
START_DATE	Date on which accounting period begins
END_DATE	Date on which accounting period ends
YEAR_START_DATE	Date on which the year containing this accounting period starts
APPLICATION_ID	Application defining column
QUARTER_NUM	Quarter number
QUARTER_START_DATE	Date on which the quarter containing this accounting period starts
PERIOD_TYPE	Accounting period type
PERIOD_YEAR	Accounting period year
EFFECTIVE_PERIOD_NUM	Denormalized period number (period_year*10000 + period_num)
PERIOD_NUM	Accounting period number
ADJUSTMENT_PERIOD_FLAG	Calendar adjustment period flag
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

General Ledger - GL_PERIOD_TYPES	Calendar period types
Column Name	Descritpion
PERIOD_TYPE	Accounting period type name
DESCRIPTION	Accounting period type 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
LAST_UPDATE_DATE	Standard Who column
PERIOD_TYPE_ID	Oracle Internal use only - reserved for future use
LAST_UPDATED_BY	Standard Who column
NUMBER_PER_FISCAL_YEAR	Number of periods per fiscal year
YEAR_TYPE_IN_NAME	Year type (Calendar or Fiscal)
USER_PERIOD_TYPE	Calendar period type user defined name
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

General Ledger - GL_POSTING_INTERIM	Posting interim balances
Column Name	Descritpion
CODE_COMBINATION_ID	Key flexfield combination defining column
ACTUAL_FLAG	Balance type lookup (Actual, Budget, or Encumbrance)
ENCUMBRANCE_TYPE_ID	Encumbrance type defining column
BUDGET_VERSION_ID	Budget version defining column
TEMPLATE_ID	Summary template defining column
TRANSLATED_FLAG	Translated balance status flag
INCREMENTAL_FLAG	Incremental amounts flag
PERIOD_NET_DR	Period net debit amount
PERIOD_NET_CR	Period net credit amount
QUARTER_TO_DATE_DR	Quarter-to-date debit amount
QUARTER_TO_DATE_CR	Quarter-to-date credit amount
PERIOD_NAME	Accounting period
PROJECT_TO_DATE_DR	Project-to-date debit amount
PROJECT_TO_DATE_CR	Project-to-date credit amount
BEGIN_BALANCE_DR	Begin balance debit amount
BEGIN_BALANCE_CR	Begin balance credit amount
PERIOD_NET_DR_BEQ	Period net debit amount in base currency
PERIOD_NET_CR_BEQ	Period net credit amount in base currency
BEGIN_BALANCE_DR_BEQ	Begin balance debit amount in base currency
BEGIN_BALANCE_CR_BEQ	Begin balance credit amount in base currency
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment
SET_OF_BOOKS_ID	Accounting books defining column
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
SEGMENT11	Key flexfield segment
SEGMENT12	Key flexfield segment
CURRENCY_CODE	Currency
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
SEGMENT21	Key flexfield segment
SEGMENT22	Key flexfield segment
PERIOD_YEAR	Accounting period year
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_NUM	Accounting period number
PERIOD_TYPE	Accounting period type
ACCOUNT_TYPE	Account type lookup (Asset, Liability, etc)
BAL_SEG_VALUE	Balancing segment value

General Ledger - GL_RECURRING_BATCHES	Recurring journal entry and budget formula batches
Column Name	Descritpion
RECURRING_BATCH_ID	Recurring journal batch defining column
LAST_UPDATE_LOGIN	Standard Who column
BUDGET_IN_FORMULA_FLAG	Budget balances used in recurring journal entry formulas flag
DESCRIPTION	Recurring journal batch description
PERIOD_TYPE	Accounting period type
LAST_EXECUTED_PERIOD_NAME	Period in which this batch last executed
LAST_EXECUTED_DATE	Date on which this batch last executed
LAST_EXEC_JOURNAL_DATE	Journal effective date for which this batch was last executed
LAST_UPDATE_DATE	Standard Who column
SET_OF_BOOKS_ID	Accounting books defining column
LAST_EXEC_CALCULATION_DATE	Calculation effective date for which this batch was last executed
LAST_EXEC_BUDGET_VERSION_ID	Budget for which this batch was last executed
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
SECURITY_FLAG	Reserved for future use
LEDGER_ID	Accounting books defining column
RECURRING_BATCH_TYPE	Reserved for future use
CHART_OF_ACCOUNTS_ID	Reserved for future use
NAME	Recurring journal batch name
PERIOD_SET_NAME	Reserved for future use
ACCOUNTED_PERIOD_TYPE	Reserved for future use
BUDGET_FLAG	Recurring budget journal batch flag
ALLOCATION_FLAG	No longer used(default = 'Y')
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

General Ledger - GL_RECURRING_HEADERS	Recurring journal entry and budget formula headers
Column Name	Descritpion
RECURRING_HEADER_ID	Recurring header defining column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
RECURRING_BATCH_ID	Recurring batch defining column
PERIOD_TYPE	Accounting period type
LAST_EXECUTED_PERIOD_NAME	Period that this recurring journal entry was last executed
LAST_EXECUTED_DATE	Date that this recurring journal entry was last executed
START_DATE_ACTIVE	Date that recurring journal entry becomes valid
END_DATE_ACTIVE	Date that recurring journal entry becomes invalid
ATTRIBUTE1	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE2	Descriptive flexfield segment
SET_OF_BOOKS_ID	Accounting books 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
CONTEXT	Descriptive flexfield context
LAST_UPDATED_BY	Standard Who column
CURRENCY_CONVERSION_TYPE
LEDGER_ID	Accounting books defining column
NAME	Recurring header name
JE_CATEGORY_NAME	Journal entry category name
ENABLED_FLAG	Not currently used
ALLOCATION_FLAG	No longer used
CURRENCY_CODE	Currency

General Ledger - GL_RECURRING_LINES	Recurring journal entry and recurring budget formula target lines
Column Name	Descritpion
RECURRING_HEADER_ID	Recurring journal header defining column
DESCRIPTION	Recurring journal entry line description
ENTERED_DR	User-entered debit amount
ENTERED_CR	User-entered credit amount
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
RECURRING_LINE_NUM	Recurring journal line number
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CODE_COMBINATION_ID	Key flexfield combination defining column
ENTERED_CURRENCY_CODE	Recurring formula's target line currency
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

General Ledger - GL_RECURRING_LINE_CALC_RULES	Recurring journal entry and budget formula lines
Column Name	Descritpion
RECURRING_HEADER_ID	Recurring journal header defining column
AMOUNT	Constant amount in formula line
ENTERED_CURRENCY	Reserved for future use
LEDGER_ID
PERIOD_TO_DATE_FLAG	No longer used
ACTUAL_FLAG	Account balance flag (Actual, Budget, or Encumbrance)
CURRENCY_CODE_11I	No Longer Used in R12
RELATIVE_PERIOD_CODE	Relative period lookup
AMOUNT_TYPE	Amount type to use for formula step
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
RECURRING_LINE_NUM	Recurring journal line number
ATTRIBUTE3	Descriptive flexfield segment
CURRENCY_CODE	Currency
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context column
ASSIGNED_CODE_COMBINATION	Key flexfield structure defining column for recurring journal entry line
TEMPLATE_ID	Summary template defining column
RULE_NUM	Recurring journal formula step number
SEGMENT1	Key flexfield structure defining column
SEGMENT2	Key flexfield structure defining column
SEGMENT3	Key flexfield structure defining column
SEGMENT4	Key flexfield structure defining column
SEGMENT5	Key flexfield structure defining column
LAST_UPDATE_DATE	Standard Who column
SEGMENT6	Key flexfield structure defining column
SEGMENT7	Key flexfield structure defining column
SEGMENT8	Key flexfield structure defining column
SEGMENT9	Key flexfield structure defining column
SEGMENT10	Key flexfield structure defining column
LAST_UPDATED_BY	Standard Who column
SEGMENT11	Key flexfield structure defining column
SEGMENT12	Key flexfield structure defining column
SEGMENT13	Key flexfield structure defining column
SEGMENT14	Key flexfield structure defining column
SEGMENT15	Key flexfield structure defining column
OPERATOR	Mathematical operator for this line
SEGMENT16	Key flexfield structure defining column
SEGMENT17	Key flexfield structure defining column
SEGMENT18	Key flexfield structure defining column
SEGMENT19	Key flexfield structure defining column
SEGMENT20	Key flexfield structure defining column
CREATION_DATE	Standard Who column
SEGMENT21	Key flexfield structure defining column
SEGMENT22	Key flexfield structure defining column
SEGMENT23	Key flexfield structure defining column
SEGMENT24	Key flexfield structure defining column
SEGMENT25	Key flexfield structure defining column
CREATED_BY	Standard Who column
SEGMENT26	Key flexfield structure defining column
SEGMENT27	Key flexfield structure defining column
SEGMENT28	Key flexfield structure defining column
SEGMENT29	Key flexfield structure defining column
SEGMENT30	Key flexfield structure defining column
LAST_UPDATE_LOGIN	Standard Who column
LEDGER_CURRENCY	Reserved for future use
CURRENCY_TYPE	Reserved for future use

General Ledger - GL_REVALUATION	Revaluation default gain/loss account
Column Name	Descritpion
CODE_COMBINATION_ID	Key flexfield combination defining column
SET_OF_BOOKS_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_REVALUATION_ACCOUNTS	Revaluation account ranges
Column Name	Descritpion
REVALUATION_RUN_ID	Revaluation run process defining 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
SEGMENT4_HIGH	Key flexfield segment high range column
LAST_UPDATE_DATE	Standard Who 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
SEGMENT9_HIGH	Key flexfield segment high range column
LAST_UPDATED_BY	Standard Who 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
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
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
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
SEGMENT29_HIGH	Key flexfield segment high range column
SEGMENT30_LOW	Key flexfield segment low range column
SEGMENT30_HIGH	Key flexfield segment high range column
SET_OF_BOOKS_ID	Accounting books defining column
CREATION_DATE	Standard Who column

General Ledger - GL_MC_BOOK_ASSIGNMENTS	Assignments of reporting sets of books to primary sets of books
Column Name	Descritpion
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
PRIMARY_SET_OF_BOOKS_ID	Primary set of books defining column
FIRST_MRC_DATE	First accounting date for MRC
FIRST_MRC_PERIOD	First accounting period for MRC
CONVERSION_OPTION_CODE	Determines conversion option for initializing transactions and balances in this reporting book
EFC_BOOK_FLAG	Flag which indicates reporting set of book selected for EFC
PRE_EFC_SELECTED_FLAG	Flag which indicates primary/reporting set of books selected for Pre-EFC processes.
EFC_SELECTED_FLAG	Flag which indicates primary/reporting set of books selected for the EFC process.
REPORTING_SET_OF_BOOKS_ID	Reporting set of books defining column
EFC_COMPLETED_FLAG	Determines if EFC process has been completed.
EFC_RUN_ID	Identifer for the Pre-EFC/EFC processes'C '- Completed'I' - In process'E'- Exception
INIT_CONVERSION_TYPE	Currency conversion type to use for initializing MRC balances
INIT_CONVERSION_DATE	Currency conversion date to use for initializing MRC balances

General Ledger - GL_MC_UPGRADE_HISTORY	History of upgrade for each application and reporting set of books
Column Name	Descritpion
PERIOD_NAME	Accounting period
CONVERSION_STATUS	Status code to indicate if the table is converted
ROUNDING_STATUS	Status code to indicate if the records are rounded
UPGRADE_RUN_ID	Upgrade run defining column, every table converted in the same run will have the same UPGRADE_RUN_ID
REQUEST_ID	Concurrent request defining column
PRIMARY_SET_OF_BOOKS_ID	Primary accounting book 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
LAST_PROCESSED_ID1	First defining column for the last record that was updated in the transaction table
LAST_PROCESSED_ID2	Second defining column for the last record that was updated in the transaction table
REPORTING_SET_OF_BOOKS_ID	Reporting accounting book defining column
APPLICATION_ID	Application defining column
TABLE_NAME	Converted table name

General Ledger - GL_MC_UPGRADE_RATES	Exchange rates used for the multiple reporting currency upgrade programs
Column Name	Descritpion
NUMERATOR_RATE	Numerator that is used to calculate the conversion rate
CONVERSION_RATE	Currency conversion rate
PRECISION	Maximum number of digits to the right of the decimal point
MINIMUM_ACCOUNTABLE_UNIT	Minimum accountable unit for the currency
UPGRADE_RUN_ID	Upgrade run defining column
FROM_CURRENCY	From currency code
TO_CURRENCY	To currency code
DENOMINATOR_RATE	Denominator that is used to calculate the conversion rate

General Ledger - GL_OASIS_FIN_ITEMS	Financial items
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Financial item description
CONTEXT	Descriptive flexfield context
ATTRIBUTE1	Descriptive flexfield segment
FIN_ITEM_ID	Financial item 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
NAME	Financial item name
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

General Ledger - GL_OASIS_FIN_ASSIGNMENTS	Natural account value mappings for financial items
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
SET_OF_BOOKS_ID	Set of books defining 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
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
FIN_ITEM_ID	Financial item defining column
ACCOUNT_SEGMENT_VALUE	Natural account segment value
SUMMARY_FLAG	Summary flag

General Ledger - GL_OASIS_SUMMARY_DATA	Summarized financial data needed for Business Intelligence System reports
Column Name	Descritpion
ACTUAL_FLAG	Balance type
DRILLDOWN_SEGVAL1	Primary drilldown segment value ('-1' if there is no value)
DRILLDOWN_SEGVAL2	Secondary drilldown segment value ('-1' if there is no value)
RELATIVE_PERIOD_POS	Denormalized relative period position
PERIOD_NAME	Period name
SET_OF_BOOKS_ID	Set of books defining column
PERIOD_NUM	Period number
PERIOD_YEAR	Period year
QUARTER_NUM	Quarter number
DRILLDOWN_SEGDESC1	Primary drilldown segment description
DRILLDOWN_SEGDESC2	Secondary drilldown segment description
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
PERIOD_TO_DATE	Period-to-date amount
FIN_ITEM_ID	Financial item defining column
QUARTER_TO_DATE	Quarter-to-date amount
YEAR_TO_DATE	Year-to-date amount
DRILLDOWN_SEGNUM1	Primary drilldown segment number (-1 if there is no value)
DRILLDOWN_SEGNUM2	Secondary drilldown segment number (-1 if there is no value)

General Ledger - GL_SHARES_ACTIVITY	Stock split or dividend
Column Name	Descritpion
LEDGER_ID	Accounting books defining column
SPLIT_RATIO_TO	Stock split ratio to
DIVIDEND_PERCENT	Stock dividend percentage
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
ACTIVITY_DATE	Date on which the activity occurred
ATTRIBUTE8	Descriptive flexfield segment
SET_OF_BOOKS_ID	Accounting books defining column
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ACTIVITY_TYPE_CODE	Activity type (Split or Dividend)
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
SPLIT_RATIO_FROM	Stock split ratio from

General Ledger - GL_SHARES_OUTSTANDING	Number of shares outstanding
Column Name	Descritpion
LEDGER_ID	Accounting books defining column
Q1_NUMBER_OF_SHARES	Number of shares outstanding in quarter 1
Q2_NUMBER_OF_SHARES	Number of shares outstanding in quarter 2
Q3_NUMBER_OF_SHARES	Number of shares outstanding in quarter 3
Q4_NUMBER_OF_SHARES	Number of shares outstanding in quarter 4
CONTEXT	Descriptive flexfield context column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
FISCAL_YEAR	Fiscal year
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
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
SHARE_MEASURE_CODE	Share measurement method (Basic or Diluted)
ATTRIBUTE15	Descriptive flexfield segment
MEASURE_TYPE_CODE	Measurement type (Actual or Planned)
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

General Ledger - GL_SETS_OF_BOOKS	Set of books definitions
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
RET_EARN_CODE_COMBINATION_ID	Retained earnings key flexfield defining column
PERIOD_SET_NAME	Accounting calendar name
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	Rounding imbalances key flexfield defining column
TRANSACTION_CALENDAR_ID	Transaction Calendar defining column
DAILY_TRANSLATION_RATE_TYPE	The rate type to be used for translation of average balances
EARLIEST_UNTRANS_PERIOD_NAME	No longer used
DESCRIPTION	Accounting books description
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
CONTEXT	Descriptive flexfield context
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
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
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
ACCOUNTED_PERIOD_TYPE	Accounting period type
NAME	Accounting books name
SUSPENSE_ALLOWED_FLAG	Suspense posting allowed flag
ALLOW_INTERCOMPANY_POST_FLAG	Allow intercompany posting
TRACK_ROUNDING_IMBALANCE_FLAG	Track rounding imbalances flag
ENABLE_AVERAGE_BALANCES_FLAG	Enable average balances flag
SHORT_NAME	Accounting books short name
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_SOB_FLAG	Consolidation set of books flag
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
TRANSLATE_EOD_FLAG	Translate EOD balances flag
TRANSLATE_QATD_FLAG	Translated QATD balances flag
TRANSLATE_YATD_FLAG	Translate YATD balances flag
MRC_SOB_TYPE_CODE	MRC set of books type (Parent, Reporting, None)
ALLOW_POSTING_WARNING_FLAG	No longer used - (defaults to 'N')
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CURRENCY_CODE	Currency
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FUTURE_ENTERABLE_PERIODS_LIMIT	Number of future enterable periods
LATEST_OPENED_PERIOD_NAME	Latest opened accounting period
LATEST_ENCUMBRANCE_YEAR	Latest open year for encumbrances

General Ledger - GL_SUMMARY_INTERIM	Temporary table for Summarization
Column Name	Descritpion
SOURCE_FLEX_VALUE	Child segment value
TARGET_FLEX_VALUE	Parent segment value

General Ledger - GL_SUMMARY_TEMPLATES	Summary account templates
Column Name	Descritpion
TEMPLATE_ID	Summary template defining column
MAX_CODE_COMBINATION_ID	Key flexfield combination defining column for maximum detail flexfield
START_ACTUALS_PERIOD_NAME	Start period name
AMOUNT_TYPE	No longer used in R12
BOUNDARY_CODE	No longer used in R12
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
DR_CR_CODE	No longer used in R12
LAST_UPDATE_LOGIN	Standard Who column
FUNDING_BUDGET_VERSION_ID	No longer used in R12
SEGMENT1_TYPE	Summary segment type column
LEDGER_ID	Accounting books defining column
SEGMENT2_TYPE	Summary segment type column
SET_OF_BOOKS_ID	Accounting books defining column
SEGMENT3_TYPE	Summary segment type column
SEGMENT4_TYPE	Summary segment type column
SEGMENT5_TYPE	Summary segment type column
SEGMENT6_TYPE	Summary segment type column
SEGMENT7_TYPE	Summary segment type column
SEGMENT8_TYPE	Summary segment type column
SEGMENT9_TYPE	Summary segment type column
SEGMENT10_TYPE	Summary segment type column
SEGMENT11_TYPE	Summary segment type column
STATUS	Status column used internally by summarization program
SEGMENT12_TYPE	Summary segment type column
SEGMENT13_TYPE	Summary segment type column
SEGMENT14_TYPE	Summary segment type column
SEGMENT15_TYPE	Summary segment type column
SEGMENT16_TYPE	Summary segment type column
SEGMENT17_TYPE	Summary segment type column
SEGMENT18_TYPE	Summary segment type column
SEGMENT19_TYPE	Summary segment type column
SEGMENT20_TYPE	Summary segment type column
SEGMENT21_TYPE	Summary segment type column
LAST_UPDATE_DATE	Standard Who column
SEGMENT22_TYPE	Summary segment type column
SEGMENT23_TYPE	Summary segment type column
SEGMENT24_TYPE	Summary segment type column
SEGMENT25_TYPE	Summary segment type column
SEGMENT26_TYPE	Summary segment type column
SEGMENT27_TYPE	Summary segment type column
SEGMENT28_TYPE	Summary segment type column
SEGMENT29_TYPE	Summary segment type column
SEGMENT30_TYPE	Summary segment type column
DESCRIPTION	Summary template description
LAST_UPDATED_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 segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
TEMPLATE_NAME	Summary template name
CONCATENATED_DESCRIPTION	Summary template concatenated segments
ACCOUNT_CATEGORY_CODE	Account category
FUNDS_CHECK_LEVEL_CODE	No longer used in R12

General Ledger - GL_TEMPORARY_COMBINATIONS	Newly created account combinations
Column Name	Descritpion
REQUEST_ID	Summarization concurrent request 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
SEGMENT14	Key flexfield segment
LAST_UPDATE_DATE	Standard Who column
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
LAST_UPDATED_BY	Standard Who column
SEGMENT25	Key flexfield segment
SEGMENT26	Key flexfield segment
SEGMENT27	Key flexfield segment
SEGMENT28	Key flexfield segment
SEGMENT29	Key flexfield segment
SEGMENT30	Key flexfield segment
DESCRIPTION	Summary account combination description
TEMPLATE_ID	Summary template defining column
ALLOCATION_CREATE_FLAG	No longer used
START_DATE_ACTIVE	Date on which account becomes enabled
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
END_DATE_ACTIVE	Date on which account becomes disabled
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
ACCOUNT_TYPE	Account type lookup (Asset, Liability. etc)
ATTRIBUTE10	Descriptive flexfield segment
CONTEXT	Descriptive flexfield context
CODE_COMBINATION_ID	Key flexfield combination defining column
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment

General Ledger - GL_TRANSLATION_INTERIM	Foreign currency translated interim balances
Column Name	Descritpion
CODE_COMBINATION_ID	Key flexfield combination defining column
ACTUAL_FLAG	Balance type lookup (Actual, Budget, or Encumbrance)
INCREMENTAL_FLAG	Incremental amounts flag
PERIOD_NET_DR	Period net debit amount
PERIOD_NET_CR	Period net credit amount
QUARTER_TO_DATE_DR	Quarter-to-date debit amount
QUARTER_TO_DATE_CR	Quarter-to-date credit amount
PROJECT_TO_DATE_DR	Project-to-date debit amount
PROJECT_TO_DATE_CR	Project-to-date credit amount
BEGIN_BALANCE_DR	Begin balance debit amount
BEGIN_BALANCE_CR	Begin balance credit amount
PERIOD_NAME	Accounting period
PERIOD_NET_DR_BEQ	Period net debit amount in base currency
PERIOD_NET_CR_BEQ	Period net credit amount in base currency
BEGIN_BALANCE_DR_BEQ	Begin balance debit amount in base currency
BEGIN_BALANCE_CR_BEQ	Begin balance in credit amount in base currency
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment
SEGMENT5	Key flexfield segment
SEGMENT6	Key flexfield segment
SET_OF_BOOKS_ID	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
SEGMENT16	Key flexfield segment
CURRENCY_CODE	Currency
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
SEGMENT26	Key flexfield segment
PERIOD_YEAR	Accounting period year
SEGMENT27	Key flexfield segment
SEGMENT28	Key flexfield segment
SEGMENT29	Key flexfield segment
SEGMENT30	Key flexfield segment
TEMPLATE_ID	Summary template defining column
PERIOD_NUM	Accounting period number
PERIOD_TYPE	Accounting period type
ACCOUNT_TYPE	Account type lookup (Asset, Liability, etc)
BAL_SEG_VALUE	Balancing segment value

General Ledger - GL_TRANSLATION_RATES	Foreign currency translation rates
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
EOP_RATE_DENOMINATOR	Denominator of the end of period exchange rate
AVG_RATE_NUMERATOR	Numerator of the period average exchange rate
AVG_RATE_DENOMINATOR	Denominator of the peroid average exchange rate
EOP_RATE	End of period exchange rate
UPDATE_FLAG	Rate out of date flag
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
PERIOD_NAME	Accounting period
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
TO_CURRENCY_CODE	Translation target currency
ACTUAL_FLAG	Transaction balance type (Actual or Budget)
AVG_RATE	Accounting period average exchange rate
EOP_RATE_NUMERATOR	Numerator of the end of period exchange rate

General Ledger - GL_TRANSLATION_TRACKING	Foreign currency translation history
Column Name	Descritpion
ACTUAL_FLAG	Transaction balance type (Actual or Budget)
TARGET_BUDGET_VERSION_ID	Target budget version defining column
EARLIEST_EVER_PERIOD_NAME	Earliest ever translated period name
EARLIEST_EVER_PERIOD_NUM	Earliest ever translated period number
EARLIEST_EVER_PERIOD_YEAR	Earliest ever translated period year
EARLIEST_NEVER_PERIOD_NAME	Earliest never translated period name
EARLIEST_NEVER_PERIOD_NUM	Earliest never translated period number
EARLIEST_NEVER_PERIOD_YEAR	Earliest never translated period year
SET_OF_BOOKS_ID	Accounting books defining column
FIRST_OUTDATED_PERIOD_NAME	Name of earliest period with obsolete translation records.
FIRST_OUTDATED_EFF_PERIOD_NUM	Number of earliest period with obsolete translation records.
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LEDGER_ID	Accounting books defining column
TARGET_CURRENCY	Translation target currency
AVERAGE_TRANSLATION_FLAG	Translate average balances flag
BAL_SEG_VALUE	Balancing segment value

General Ledger - GL_SEGVAL_INHERIT_HISTORY	Segment value inheritance history
Column Name	Descritpion
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
LAST_RUN_DATE	Date and time on which the Segment Value Inheritance program was last run for this chart of accounts
REQUEST_ID	Enhanced Who column
PROGRAM_APPLICATION_ID	Enhanced Who column
CREATION_DATE	Standard Who column
PROGRAM_ID	Enhanced Who column
PROGRAM_UPDATE_DATE	Enhanced Who column
CREATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

General Ledger - GL_RX_TRIAL_BALANCE_ITF	Interface table for country-specific trial balance reports
Column Name	Descritpion
PERIOD_NAME	Current period name
PERIOD_NET_DR	Debit movement for current period
PERIOD_NET_CR	Credit movement for current period
YEAR_TO_DATE_BALANCE_DR	Year-to-date debit balance
YEAR_TO_DATE_BALANCE_CR	Year-to-date credit balance
YEAR_TO_DATE_NET_DIFFERENCE_DR	Net year-to-date debit balance
YEAR_TO_DATE_NET_DIFFERENCE_CR	Net year-to-date credit balance
LEDGER_ID	Set of books defining column
LEDGER_NAME	Set of books name
SET_OF_BOOKS_ID	Set of books defining column
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
CURRENCY_CODE	Currency
BALANCING_SEGMENT	Balancing Segment value
ACCOUNT_SEGMENT	Natural account segment value
SET_OF_BOOKS_NAME	Set of books name
BALANCING_DESCRIPTION	Balancing segment value description
REQUEST_ID	Concurrent request defining column
ACCOUNT_DESCRIPTION	Natural account segment value description
SUMMARY_FLAG	Summary data indicator
BEGIN_YEAR_BALANCE_DR	Beginning of fiscal year debit balance
BEGIN_YEAR_BALANCE_CR	Beginning of fiscal year credit balance
BEGIN_ADJ_PERIOD_NET_DR	Debit movement for beginning adjustment period
BEGIN_ADJ_PERIOD_NET_CR	Credit movement for beginning adjustment period
PRIOR_PERIODS_NET_DR	Debit movement for previous regular periods
PRIOR_PERIODS_NET_CR	Credit movement for previous regular periods
BEGIN_PERIOD_BALANCE_DR	Beginning of current period debit balance
BEGIN_PERIOD_BALANCE_CR	Beginning of current period credit balance

General Ledger - GL_OASIS_FIN_METRICS	The new table stores the summarized financial metrics.
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column.
REPORT_PARAMETERS	Parameters for the report associated with this metric
QUARTER1_VALUE	Value of the metric for quarter 1
QUARTER2_VALUE	Value of the metric for quarter 2
QUARTER3_VALUE	Value for the metric for quarter 3
QUARTER4_VALUE	Value of the metric for quarter 4
FIN_METRIC_CODE	Indicates the desired financial metric.
YEAR_VALUE	YTD value of the metric
EFFECTIVE_PERIOD_NUM	Effective period number of the current period ( the one the program was run for)
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
REPORT_NAME	Name of the report associated with this metric

General Ledger - GL_REVALUATIONS	Revaluation definitions
Column Name	Descritpion
REVALUATION_ID	Revaluation defining column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FROM_CURRENCY_CODE	Currency to be revalued when only a single currency is to be revalued
CONVERSION_RATE_TYPE	Currency conversion type to be used to revalue balances when daily rates are used
REVALUATION_RATE	User defined revaluation rate to be used to revalue balances when one-time rate is used
GAIN_SEGMENT1	Unrealized loss account key flexfield segment
LOSS_SEGMENT1	Unrealized loss account key flexfield segment
GAIN_SEGMENT2	Unrealized loss account key flexfield segment
LOSS_SEGMENT2	Unrealized loss account key flexfield segment
NAME	Revaluation name
GAIN_SEGMENT3	Unrealized loss account key flexfield segment
SET_OF_BOOKS_ID	Accounting books defining column
LOSS_SEGMENT3	Unrealized loss account key flexfield segment
GAIN_SEGMENT4	Unrealized loss account key flexfield segment
LOSS_SEGMENT4	Unrealized loss account key flexfield segment
GAIN_SEGMENT5	Unrealized loss account key flexfield segment
LOSS_SEGMENT5	Unrealized loss account key flexfield segment
GAIN_SEGMENT6	Unrealized loss account key flexfield segment
LOSS_SEGMENT6	Unrealized loss account key flexfield segment
GAIN_SEGMENT7	Unrealized loss account key flexfield segment
LOSS_SEGMENT7	Unrealized loss account key flexfield segment
SET_OF_BOOKS_ID_11I	No Longer Used in R12
GAIN_SEGMENT8	Unrealized loss account key flexfield segment
LOSS_SEGMENT8	Unrealized loss account key flexfield segment
GAIN_SEGMENT9	Unrealized loss account key flexfield segment
LOSS_SEGMENT9	Unrealized loss account key flexfield segment
GAIN_SEGMENT10	Unrealized loss account key flexfield segment
LOSS_SEGMENT10	Unrealized loss account key flexfield segment
GAIN_SEGMENT11	Unrealized loss account key flexfield segment
LOSS_SEGMENT11	Unrealized loss account key flexfield segment
GAIN_SEGMENT12	Unrealized loss account key flexfield segment
LOSS_SEGMENT12	Unrealized loss account key flexfield segment
FROM_CURRENCY_OPTION_CODE	Determines the currency or currencies to be revalued
GAIN_SEGMENT13	Unrealized loss account key flexfield segment
LOSS_SEGMENT13	Unrealized loss account key flexfield segment
GAIN_SEGMENT14	Unrealized loss account key flexfield segment
LOSS_SEGMENT14	Unrealized loss account key flexfield segment
GAIN_SEGMENT15	Unrealized loss account key flexfield segment
LOSS_SEGMENT15	Unrealized loss account key flexfield segment
GAIN_SEGMENT16	Unrealized loss account key flexfield segment
LOSS_SEGMENT16	Unrealized loss account key flexfield segment
GAIN_SEGMENT17	Unrealized loss account key flexfield segment
LOSS_SEGMENT17	Unrealized loss account key flexfield segment
RANGE_MODE_FLAG	Method by which ranges are obtained
GAIN_SEGMENT18	Unrealized loss account key flexfield segment
LOSS_SEGMENT18	Unrealized loss account key flexfield segment
GAIN_SEGMENT19	Unrealized loss account key flexfield segment
LOSS_SEGMENT19	Unrealized loss account key flexfield segment
GAIN_SEGMENT20	Unrealized loss account key flexfield segment
LOSS_SEGMENT20	Unrealized loss account key flexfield segment
GAIN_SEGMENT21	Unrealized loss account key flexfield segment
LOSS_SEGMENT21	Unrealized loss account key flexfield segment
GAIN_SEGMENT22	Unrealized loss account key flexfield segment
LOSS_SEGMENT22	Unrealized loss account key flexfield segment
CONVERSION_RATE_OPTION_CODE	Determines the type of currency conversion rates to be used to revalue balances (Period, Daily, or One-time)
GAIN_SEGMENT23	Unrealized loss account key flexfield segment
LOSS_SEGMENT23	Unrealized loss account key flexfield segment
GAIN_SEGMENT24	Unrealized loss account key flexfield segment
LOSS_SEGMENT24	Unrealized loss account key flexfield segment
GAIN_SEGMENT25	Unrealized loss account key flexfield segment
LOSS_SEGMENT25	Unrealized loss account key flexfield segment
GAIN_SEGMENT26	Unrealized loss account key flexfield segment
LOSS_SEGMENT26	Unrealized loss account key flexfield segment
GAIN_SEGMENT27	Unrealized loss account key flexfield segment
LOSS_SEGMENT27	Unrealized loss account key flexfield segment
AUTOMATIC_POST_FLAG	Indicates if revaluation journal batches should automatically be posted
GAIN_SEGMENT28	Unrealized loss account key flexfield segment
LOSS_SEGMENT28	Unrealized loss account key flexfield segment
GAIN_SEGMENT29	Unrealized loss account key flexfield segment
LOSS_SEGMENT29	Unrealized loss account key flexfield segment
GAIN_SEGMENT30	Unrealized loss account key flexfield segment
LOSS_SEGMENT30	Unrealized loss account key flexfield segment
DESCRIPTION	Revaluation description
CONTEXT	Descriptive flexfield context column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who 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
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CHART_OF_ACCOUNTS_ID
FROM_PRIMARY_CURRENCY_FLAG	Reserved for future use
SECURITY_FLAG

General Ledger - GL_REVAL_ACCOUNT_RANGES	Revaluation account ranges
Column Name	Descritpion
REVALUATION_ID	Revaluation 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
EXPAND_BALANCING_FLAG	Indicates if Revaluation should expand the parent value for the balancing segment within the specified account range
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
SEGMENT11_LOW	Key flexfield segment low range column
EXPAND_NATURAL_ACCOUNT_FLAG	Indicates if Revaluation should expand the parent value for the natural account segment within the specified account range
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_UPDATE_DATE	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
LAST_UPDATED_BY	Standard Who 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
CONTEXT	Descriptive flexfield context column
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 segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
SEGMENT1_LOW	Key flexfield segment low range column

General Ledger - GL_OASIS_FIN_ITEMS_11I	Financial items
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
DESCRIPTION	Financial item description
CONTEXT	Descriptive flexfield context
ATTRIBUTE1	Descriptive flexfield segment
FIN_ITEM_ID	Financial item 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
NAME	Financial item name
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

General Ledger - GL_OASIS_FIN_ASSIGNMENTS_11I	Natural account value mappings for financial items
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
SET_OF_BOOKS_ID	Set of books defining 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
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
FIN_ITEM_ID	Financial item defining column
ACCOUNT_SEGMENT_VALUE	Natural account segment value
SUMMARY_FLAG	Summary flag

General Ledger - GL_OASIS_FIN_METRICS_11I	Summarized financial metrics
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
REPORT_PARAMETERS	Parameters for the report associated with this metric
QUARTER1_VALUE	Value of the metric for quarter 1
QUARTER2_VALUE	Value of the metric for quarter 2
QUARTER3_VALUE	Value of the metric for quarter 3
QUARTER4_VALUE	Value of the metric for quarter 4
FIN_METRIC_CODE	Indicates the desired financial metric
YEAR_VALUE	Year-to-date value of the metric
EFFECTIVE_PERIOD_NUM	Effective period number of the current period (the one the program was run for)
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
REPORT_NAME	Name of the report associated with this metric

General Ledger - GL_LE_VALUE_SETS	Legal entity value set assignments.
Column Name	Descritpion
LEGAL_ENTITY_ID	Legal entity defining column
FLEX_VALUE_SET_ID	Key flexfield segment value set 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_MGT_SEG_UPGRADE	Management segment upgrade unprocessed journal batches.
Column Name	Descritpion
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
JE_BATCH_ID	Journal entry batch 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

General Ledger - GL_MGT_SEG_UPGRADE_H	History of management segment upgrade.
Column Name	Descritpion
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
LAST_UPDATE_LOGIN	Standard Who column
MGT_SEG_COLUMN_NAME	Management segment column name
ASSIGN_COMPLETE_FLAG	Assignment complete flag
MAX_PROCESSED_BATCH_ID	Maximum processed batch defining column
MAX_BATCH_ID	Maximum journal entry batch defining column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	Standard Who column

General Ledger - GL_SETS_OF_BOOKS_11I	Set of books definitions
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
ENABLE_SECONDARY_TRACK_FLAG	Oracle Internal use only - reserved for future use
ENABLE_REVAL_SS_TRACK_FLAG	Oracle Internal use only - reserved for future use
RET_EARN_CODE_COMBINATION_ID	Retained earnings key flexfield defining column
PERIOD_SET_NAME	Accounting calendar name
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	Rounding imbalances key flexfield defining column
TRANSACTION_CALENDAR_ID	Transaction Calendar defining column
DAILY_TRANSLATION_RATE_TYPE	The rate type to be used for translation of average balances
TRACK_ENTERED_FUNC_CURR_FLAG	Oracle Internal use only - reserved for future use
EARLIEST_UNTRANS_PERIOD_NAME	No longer used
DESCRIPTION	Accounting books description
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
CONTEXT	Descriptive flexfield context
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
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
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
BAL_SEG_COLUMN_NAME	Reserved for future use
ACCOUNTED_PERIOD_TYPE	Accounting period type
NAME	Accounting books name
SUSPENSE_ALLOWED_FLAG	Suspense posting allowed flag
ALLOW_INTERCOMPANY_POST_FLAG	Allow intercompany posting
TRACK_ROUNDING_IMBALANCE_FLAG	Track rounding imbalances flag
ENABLE_AVERAGE_BALANCES_FLAG	Enable average balances flag
SHORT_NAME	Accounting books short name
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_SOB_FLAG	Consolidation set of books flag
CHART_OF_ACCOUNTS_ID	Key flexfield structure defining column
TRANSLATE_EOD_FLAG	Translate EOD balances flag
TRANSLATE_QATD_FLAG	Translated QATD balances flag
TRANSLATE_YATD_FLAG	Translate YATD balances flag
MRC_SOB_TYPE_CODE	MRC set of books type (Parent, Reporting, None)
ALLOW_POSTING_WARNING_FLAG	No longer used - (defaults to 'N')
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CURRENCY_CODE	Currency
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
FUTURE_ENTERABLE_PERIODS_LIMIT	Number of future enterable periods
LATEST_OPENED_PERIOD_NAME	Latest opened accounting period
LATEST_ENCUMBRANCE_YEAR	Latest open year for encumbrances

General Ledger - GL_SEG_VAL_HIERARCHIES
Column Name	Descritpion
FLEX_VALUE_SET_ID
STATUS_CODE
PARENT_FLEX_VALUE
CHILD_FLEX_VALUE
SUMMARY_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

General Ledger - GL_SEG_VAL_NORM_HIERARCHY
Column Name	Descritpion
FLEX_VALUE_SET_ID
STATUS_CODE
PARENT_FLEX_VALUE
CHILD_FLEX_VALUE
SUMMARY_FLAG
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

General Ledger - GL_SYSTEM_SETUP_11I	System setup information
Column Name	Descritpion
SET_OF_BOOKS_ID	Ledger defining column
LAST_UPDATE_LOGIN	Standard Who column
INDEXED_SEGMENT	Key flexfield indexed segment
RECORDS_TO_PROCESS	Maximum number of records to process at a time
FLEX_CACHE_SIZE	Number of records to be buffered in memory from the table GL_CODE_COMBINATIONS
ARCHIVE_EASYLINK_FLAG	Journal import archive flag
ROLLBACK_SEGMENT	Rollback segment used by programs maintaining large amounts of data
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column

General Ledger - GL_MC_REPORTING_OPTIONS_11I	Multiple reporting currency conversion options by application/operating unit/asset book
Column Name	Descritpion
REPORTING_CURRENCY_CODE	Reporting book currency
APPLICATION_ID	Application defining column
DATE_BASIS	Date rule to convert the translation
ENABLED_FLAG	Flag to indicate if record is active (Y / N)
START_DATE	Date to start maintaining this reporting book
REPORTING_OPTION_ID	Reporting option defining column
ORG_ID	Operating unit defining column
FA_BOOK_TYPE_CODE	Asset book being reported
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
AP_SECONDARY_SET_OF_BOOKS_ID	Secondary reporting set of books for Payables
CONVERSION_TYPE	Conversion type to be used for converting between currencies
PRIMARY_SET_OF_BOOKS_ID	Primary accounting book defining column
INHERIT_CONVERSION_TYPE	Flag which indicates whether to inherit conversion type from the original transaction (Y/N)
END_DATE	Last date to maintain this reporting book
ATTRIBUTE_CATEGORY	Descriptive flexfield 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
REPORTING_SET_OF_BOOKS_ID	Reporting accounting book defining column
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	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
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
PRIMARY_CURRENCY_CODE	Primary book currency
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

General Ledger - GL_MC_CONVERSION_RULES_11I	Multiple reporting currency conversion rules for Oracle General Ledger
Column Name	Descritpion
JE_CATEGORY_NAME	Journal entry category
CONVERSION_RULE	Conversion rule (CONVERT / NOT CONVERT)
DATE_BASIS	Date rule use to convert the transaction
REPORTING_OPTION_ID	Reporting option 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
CONVERSION_TYPE	Conversion type to be used for converting between currencies
INHERIT_CONVERSION_TYPE	Indicates whether to inherit conversion type from the original transaction
ATTRIBUTE_CATEGORY	Descriptive flexfield defining column
ATTRIBUTE1	Descriptive flexfield segment
PRIMARY_SET_OF_BOOKS_ID	Primary accounting book 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
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
REPORTING_SET_OF_BOOKS_ID	Reporting accounting book defining column
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
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
JE_SOURCE_NAME	Journal entry source

General Ledger - GL_MC_BOOK_ASSIGNMENTS_11I	Assignments of reporting sets of books to primary sets of books
Column Name	Descritpion
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
PRIMARY_SET_OF_BOOKS_ID	Primary set of books defining column
FIRST_MRC_DATE	First accounting date for MRC
FIRST_MRC_PERIOD	First accounting period for MRC
CONVERSION_OPTION_CODE	Determines conversion option for initializing transactions and balances in this reporting book
EFC_BOOK_FLAG	Flag which indicates reporting set of book selected for EFC
PRE_EFC_SELECTED_FLAG	Flag which indicates primary/reporting set of books selected for Pre-EFC processes.
EFC_SELECTED_FLAG	Flag which indicates primary/reporting set of books selected for the EFC process.
REPORTING_SET_OF_BOOKS_ID	Reporting set of books defining column
EFC_COMPLETED_FLAG	Determines if EFC process has been completed.
EFC_RUN_ID	Identifier for the Pre-EFC/EFC processes
INIT_CONVERSION_TYPE	Currency conversion type to use for initializing MRC balances
INIT_CONVERSION_DATE	Currency conversion date to use for initializing MRC balances

General Ledger - GL_UPGRADE_STATUS
Column Name	Descritpion
MAX_BATCH_ID
MAX_HEADER_ID

General Ledger - GL_UPDATE_RECOVERY_H	Updated columns history for update recovery
Column Name	Descritpion
OBJECT_NAME
LAST_UPDATE_LOGIN
COLUMN_NAME
PREUPDATE_COLUMN_VALUE
PRIMARY_KEY_VALUE
UPDATE_SCRIPT_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY

General Ledger - GL_TRACK_DELTA_BALANCES	GL_TRACK_DELTA_BALANCES stores information about requests to track incremental balances using the GL_BALANCES_DELTA table.
Column Name	Descritpion
LEDGER_ID	Set of books identifier
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
PROGRAM_CODE	Program that requested incremental balance tracking (FEM)
PERIOD_NAME	Accounting period for which the delta balances should be tracked
ACTUAL_FLAG	Balance type (Actual, Budget or Encumbrance)
EXTRACT_LEVEL_CODE	Level of extraction (Detail or Summary)
CURRENCY_TYPE_CODE	Currency type of extraction (Entered, Translated or Both)
ENABLED_FLAG	Enabled Flag (Yes or No)
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column

General Ledger - GL_SUMMARY_HIERARCHIES	Child segment value ranges for summary templates
Column Name	Descritpion
SEGMENT_POS	Segment position which the range belongs to
FLEX_VALUE_SET_ID	Flexfield value set defining column
PARENT_FLEX_VALUE	Parent value to which the range belongs
CHILD_FLEX_VALUE_LOW	Low value of the range of child values
CHILD_FLEX_VALUE_HIGH	High value of the range of child values
STATUS_CODE	Status column used internally by summarization program
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
TEMPLATE_ID	Summary template defining column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

General Ledger - GL_SUMMARY_HIERARCHY_INT	Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates
Column Name	Descritpion
SEGMENT_POS	Segment position which the range belongs to
FLEX_VALUE_SET_ID	Flexfield value set defining column
PARENT_FLEX_VALUE	New parent value to which the range belongs
CHILD_FLEX_VALUE_LOW	Low value of the range of child values
CHILD_FLEX_VALUE_HIGH	High value of the range of child values
STATUS_CODE	Status column used internally by summarization program
LOW_INCL_FLAG	Flag indicating if the low end of the range should be included when processing
HIGH_INCL_FLAG	Flag indicating if the high end of the range should be included when processing
TEMPLATE_ID	Summary template 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
OLD_PARENT_FLEX_VALUE	Old parent value to which the range used to belong

General Ledger - GL_SUMMARY_BC_OPTIONS
Column Name	Descritpion
TEMPLATE_ID
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
FUNDING_BUDGET_VERSION_ID
FUNDS_CHECK_LEVEL_CODE
DR_CR_CODE
AMOUNT_TYPE
BOUNDARY_CODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY

General Ledger - GL_TRANSLATION_RATES_11I	Foreign currency translation rates
Column Name	Descritpion
SET_OF_BOOKS_ID	Accounting books defining column
EOP_RATE_DENOMINATOR	Denominator of the end of period exchange rate
AVG_RATE_NUMERATOR	Numerator of the period average exchange rate
AVG_RATE_DENOMINATOR	Denominator of the peroid average exchange rate
EOP_RATE	End of period exchange rate
UPDATE_FLAG	Rate out of date flag
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
PERIOD_NAME	Accounting period
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
TO_CURRENCY_CODE	Translation target currency
ACTUAL_FLAG	Transaction balance type (Actual or Budget)
AVG_RATE	Accounting period average exchange rate
EOP_RATE_NUMERATOR	Numerator of the end of period exchange rate

General Ledger - GL_REPORT_INTERFACE
Column Name	Descritpion
NATURAL_ACCOUNT_NUM
BALANCING_ACCOUNT_NUM
CCID
JE_SOURCE
LGR1_AMOUNT
LGR2_AMOUNT
BALANCE
COMBINATION

General Ledger - GL_RECON_BALANCE
Column Name	Descritpion
SUM_LGR1_BEGIN_BALANCE
SUM_LGR2_BEGIN_BALANCE
SUM_LGR1_PERIOD_NET
SUM_LGR2_PERIOD_NET
NATURAL_ACCOUNT_NUM
BALANCING_ACCOUNT_NUM
CCID
COMBINATION