lunes, 5 de mayo de 2014

My Application Report Generator Table Descriptions hand book (I have big hands)

Application Report Generator - RG_LOOKUPS_OLD Standard lookup codes
Column Name Descritpion
LOOKUP_TYPE Lookup type name
START_DATE_ACTIVE Date that lookup code becomes enabled
END_DATE_ACTIVE Date that lookup code becomes disabled
DESCRIPTION Lookup code description
LOOKUP_CODE Lookup code name
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
MEANING User-visible lookup code meaning
ENABLED_FLAG Lookup code enabled flag
Application Report Generator - RG_REPORTS Report definitions
Column Name Descritpion
APPLICATION_ID Application defining column
NAME Name for this report
COLUMN_SET_ID Defining column for the column set for this report
ROW_SET_ID Defining column for the row set for this report
ROUNDING_OPTION Report rounding method
OUTPUT_OPTION Output option
REPORT_TITLE Report title
REPORT_DISPLAY_SET_ID Defining column for the optional report display set for this report
REPORT_ID Report defining column
CONTENT_SET_ID Defining column for the optional content set for this report
ROW_ORDER_ID Defining column for the optional row order for this report
PARAMETER_SET_ID Parameter set for running this report
UNIT_OF_MEASURE_ID_11I Obsolete
ID_FLEX_CODE_11I Obsolete
STRUCTURE_ID Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I Obsolete
PERIOD_SET_NAME No longer used
MINIMUM_DISPLAY_LEVEL Level of detail to run this predefined report at
DESCRIPTION Description of the report
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
LAST_UPDATE_DATE Standard Who column
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
ID_FLEX_CODE GLLE
SEGMENT_OVERRIDE Values of the segments to override at runtime
LAST_UPDATED_BY Standard Who column
UNIT_OF_MEASURE_ID Currency
SECURITY_FLAG Security flag
LAST_UPDATE_LOGIN Standard Who column
OVERRIDE_ALC_LEDGER_CURRENCY Override reporting ledger currency
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
Application Report Generator - RG_REPORT_AXES Row and column definitions
Column Name Descritpion
APPLICATION_ID Application defining column
AXIS_NAME Name of this column or row
AMOUNT_ID Amount foreign key
STANDARD_AXIS_ID Amount type for this column or row
WIDTH No longer used
POSITION Position of column (columns only)
AXIS_SET_ID Axis set defining column for the column set or row set
STRUCTURE_ID No longer used
UNIT_OF_MEASURE_ID Currency
PARAMETER_NUM Control value to tie this column or row to a budget, encumbrance, or currency
PERIOD_OFFSET Number of periods or days this row or column value should be offset from the runtime period or day
DESCRIPTION Description of the column or row
DISPLAY_FLAG Display flag indicating whether this row or column should be displayed on the report
BEFORE_AXIS_STRING Character to print on report before this row
AFTER_AXIS_STRING Character to print on report after this row
NUMBER_CHARACTERS_INDENTED Number of characters to indent when printing this row
PAGE_BREAK_AFTER_FLAG Flag to indicate whether to insert a page break after this row
AXIS_SEQ Sequence number for this column or row
PAGE_BREAK_BEFORE_FLAG Flag to indicate whether to insert a page break before this row
NUMBER_LINES_SKIPPED_BEFORE Number of lines to skip before displaying this row
NUMBER_LINES_SKIPPED_AFTER Number of lines to skip after displaying this row
DISPLAY_LEVEL Level of detail for this row or column
DISPLAY_ZERO_AMOUNT_FLAG Flag indicating whether to display zeros for row or column
CHANGE_SIGN_FLAG Flag to change sign of all the row or column values displayed on the report
CHANGE_VARIANCE_SIGN_FLAG Flag to change sign on row or column variances displayed
DISPLAY_UNITS Units to display the row or column values on the report (thousands, hundreds, etc.)
DISPLAY_FORMAT Format string of row or column values indicating number of characters and position of decimal point (eg. 999.99)
LAST_UPDATE_DATE Standard Who column
CALCULATION_PRECEDENCE_FLAG Flag to indicate whether row or column calculation overrides
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
LAST_UPDATED_BY Standard Who 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
LAST_UPDATE_LOGIN Standard Who column
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
PERCENTAGE_DIVISOR_SEQ Sequence for percentage divisor
CREATION_DATE Standard Who column
TRANSACTION_FLAG No longer used
FORMAT_BEFORE_TEXT Character to print in report before the format mask
FORMAT_AFTER_TEXT Character to print in report after the format mask
FORMAT_MASK_WIDTH Width of the display format
DISPLAY_PRECISION The precision to display the row or column values on the report
CREATED_BY Standard Who column
SEGMENT_OVERRIDE_VALUE Value of segment override
ELEMENT_ID Oracle Internal use only - reserved for future use
AXIS_TYPE Not currently used
OVERRIDE_ALC_LEDGER_CURRENCY Override reporting ledger currency
Application Report Generator - RG_REPORT_AXIS_CONTENTS Assignments of account ranges to rows and columns
Column Name Descritpion
APPLICATION_ID Application defining column
SIGN Sign for this flexfield range to indicate whether to add or subtract this range
SEGMENT26_HIGH Key Flexfield range segment
SEGMENT26_TYPE Key Flexfield segment type
SEGMENT27_LOW Key Flexfield range segment
SEGMENT27_HIGH Key Flexfield range segment
SEGMENT27_TYPE Key Flexfield segment type
SEGMENT28_LOW Key Flexfield range segment
SEGMENT28_HIGH Key Flexfield range segment
SEGMENT28_TYPE Key Flexfield segment type
SEGMENT29_LOW Key Flexfield range segment
SEGMENT29_HIGH Key Flexfield range segment
DR_CR_NET_CODE Activity type (eg. debit, credit)
SEGMENT29_TYPE Key Flexfield segment type
SEGMENT30_LOW Key Flexfield range segment
SEGMENT30_HIGH Key Flexfield range segment
SEGMENT30_TYPE Key Flexfield segment type
CONTEXT Descriptive flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
LEDGER_ID Ledger defining column associated with this flexfield
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
SEGMENT1_LOW Key Flexfield range segment
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
SEGMENT1_HIGH Key Flexfield range segment
SEGMENT_ATTRIBUTE1_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_HIGH Reporting Attribute Segment (Public Sector Financials)
AXIS_SET_ID Defining column of the column set or row set these flexfield details refer to
SEGMENT_ATTRIBUTE20_TYPE Reporting Attribute Segment (Public Sector Financials)
SET_OF_BOOKS_ID Defining column for the accounting books associated with this flexfield
SEGMENT_ATTRIBUTE21_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT1_TYPE Key Flexfield segment type
SEGMENT_ATTRIBUTE40_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT2_LOW Key Flexfield range segment
LEDGER_SEGMENT_TYPE Ledger segment type
ALC_LEDGER_CURRENCY Reporting ledger currency
SEGMENT2_HIGH Key Flexfield range segment
SEGMENT2_TYPE Key Flexfield segment type
AXIS_SEQ Sequence number of the column or row these flexfield details refer to
SEGMENT3_LOW Key Flexfield range segment
SEGMENT3_HIGH Key Flexfield range segment
SEGMENT3_TYPE Key Flexfield segment type
SEGMENT4_LOW Key Flexfield range segment
SEGMENT4_HIGH Key Flexfield range segment
SEGMENT4_TYPE Key Flexfield segment type
SEGMENT5_LOW Key Flexfield range segment
SEGMENT5_HIGH Key Flexfield range segment
SEGMENT5_TYPE Key Flexfield segment type
SEGMENT6_LOW Key Flexfield range segment
LAST_UPDATE_DATE Standard Who column
SEGMENT6_HIGH Key Flexfield range segment
SEGMENT6_TYPE Key Flexfield segment type
SEGMENT7_LOW Key Flexfield range segment
SEGMENT7_HIGH Key Flexfield range segment
SEGMENT7_TYPE Key Flexfield segment type
SEGMENT8_LOW Key Flexfield range segment
SEGMENT8_HIGH Key Flexfield range segment
SEGMENT8_TYPE Key Flexfield segment type
SEGMENT9_LOW Key Flexfield range segment
SEGMENT9_HIGH Key Flexfield range segment
LAST_UPDATED_BY Standard Who column
SEGMENT9_TYPE Key Flexfield segment type
SEGMENT10_LOW Key Flexfield range segment
SEGMENT10_HIGH Key Flexfield range segment
SEGMENT10_TYPE Key Flexfield segment type
SEGMENT11_LOW Key Flexfield range segment
SEGMENT11_HIGH Key Flexfield range segment
SEGMENT11_TYPE Key Flexfield segment type
SEGMENT12_LOW Key Flexfield range segment
SEGMENT12_HIGH Key Flexfield range segment
SEGMENT12_TYPE Key Flexfield segment type
LAST_UPDATE_LOGIN Standard Who column
SEGMENT13_LOW Key Flexfield range segment
SEGMENT13_HIGH Key Flexfield range segment
SEGMENT13_TYPE Key Flexfield segment type
SEGMENT14_LOW Key Flexfield range segment
SEGMENT14_HIGH Key Flexfield range segment
SEGMENT14_TYPE Key Flexfield segment type
SEGMENT15_LOW Key Flexfield range segment
SEGMENT15_HIGH Key Flexfield range segment
SEGMENT15_TYPE Key Flexfield segment type
SEGMENT16_LOW Key Flexfield range segment
CREATION_DATE Standard Who column
SEGMENT16_HIGH Key Flexfield range segment
SEGMENT16_TYPE Key Flexfield segment type
SEGMENT17_LOW Key Flexfield range segment
SEGMENT17_HIGH Key Flexfield range segment
SEGMENT17_TYPE Key Flexfield segment type
SEGMENT18_LOW Key Flexfield range segment
SEGMENT18_HIGH Key Flexfield range segment
SEGMENT18_TYPE Key Flexfield segment type
SEGMENT19_LOW Key Flexfield range segment
SEGMENT19_HIGH Key Flexfield range segment
CREATED_BY Standard Who column
SEGMENT19_TYPE Key Flexfield segment type
SEGMENT20_LOW Key Flexfield range segment
SEGMENT20_HIGH Key Flexfield range segment
SEGMENT20_TYPE Key Flexfield segment type
SEGMENT21_LOW Key Flexfield range segment
SEGMENT21_HIGH Key Flexfield range segment
SEGMENT21_TYPE Key Flexfield segment type
SEGMENT22_LOW Key Flexfield range segment
SEGMENT22_HIGH Key Flexfield range segment
SEGMENT22_TYPE Key Flexfield segment type
RANGE_MODE Summary flag to indicate whether this flexfield range specifies summary values
SEGMENT23_LOW Key Flexfield range segment
SEGMENT23_HIGH Key Flexfield range segment
SEGMENT23_TYPE Key Flexfield segment type
SEGMENT24_LOW Key Flexfield range segment
SEGMENT24_HIGH Key Flexfield range segment
SEGMENT24_TYPE Key Flexfield segment type
SEGMENT25_LOW Key Flexfield range segment
SEGMENT25_HIGH Key Flexfield range segment
SEGMENT25_TYPE Key Flexfield segment type
SEGMENT26_LOW Key Flexfield range segment
Application Report Generator - RG_REPORT_AXIS_SETS Row and column set definitions
Column Name Descritpion
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
NAME Row set or column set name
AXIS_SET_TYPE Row set or column set
APPLICATION_ID Application defining column
DISPLAY_IN_LIST_FLAG No longer used
PERIOD_SET_NAME No longer used
DESCRIPTION Row set or column set description
COLUMN_SET_HEADER Column set header
ROW_SET_TITLE No longer used
SEGMENT_NAME Override segment
ID_FLEX_CODE_11I Obsolete
STRUCTURE_ID Key flexfield structure defining column
CONTEXT Descriptive flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
AXIS_SET_ID Row set or column set 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
LAST_UPDATE_DATE Standard Who column
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
TAXONOMY_ID Oracle Internal use only - reserved for future use
ID_FLEX_CODE GLLE
LAST_UPDATED_BY Standard Who column
SECURITY_FLAG Security flag
SEEDED_NAME Seeded name
Application Report Generator - RG_REPORT_CALCULATIONS Calculations defined for rows and columns
Column Name Descritpion
APPLICATION_ID Application defining column
OPERATOR Operator to use in the calculation
AXIS_SEQ_LOW Sequence number range low to perform calculation with
AXIS_SEQ_HIGH Sequence number range high to perform calculation with
AXIS_NAME_LOW Name of column or row to perform calculation with
AXIS_NAME_HIGH Name of column or row to perform calculation with (same as axis_name_low)
CONSTANT Constant value to perform calculation with
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
AXIS_SET_ID Defining column for the column set or row set these calculations belong to
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
AXIS_SEQ Sequence number of the column or row these calculations belong to
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
CALCULATION_SEQ Sequence number of the calculation step
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
Application Report Generator - RG_REPORT_CONTENT_OVERRIDES Assignments of account ranges to content sets
Column Name Descritpion
APPLICATION_ID Application defining column
SEGMENT27_HIGH Key Flexfield range segment
SEGMENT27_TYPE Key Flexfield segment type
SEGMENT28_LOW Key Flexfield range segment
SEGMENT28_HIGH Key Flexfield range segment
SEGMENT28_TYPE Key Flexfield segment type
SEGMENT29_LOW Key Flexfield range segment
SEGMENT29_HIGH Key Flexfield range segment
SEGMENT29_TYPE Key Flexfield segment type
SEGMENT30_LOW Key Flexfield range segment
SEGMENT30_HIGH Key Flexfield range segment
SEGMENT30_TYPE Key Flexfield segment type
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
SEGMENT_ATTRIBUTE1_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE1_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE2_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE3_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE4_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE5_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE6_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE7_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE8_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE9_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE10_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE11_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE12_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE13_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE14_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE15_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE16_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE17_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE18_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE19_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE20_HIGH Reporting Attribute Segment (Public Sector Financials)
CONTENT_SET_ID Defining column for the content set these flexfield ranges belong to
SEGMENT_ATTRIBUTE20_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE21_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE22_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE23_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT1_LOW Key Flexfield range segment
SEGMENT_ATTRIBUTE24_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE24_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE25_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE26_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT1_HIGH Key Flexfield range segment
SEGMENT_ATTRIBUTE27_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE27_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE28_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE29_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE30_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT1_TYPE Key Flexfield segment type
SEGMENT_ATTRIBUTE30_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE31_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE32_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE33_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT2_LOW Key Flexfield range segment
SEGMENT_ATTRIBUTE34_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE34_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE35_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE36_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT2_HIGH Key Flexfield range segment
SEGMENT_ATTRIBUTE37_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE37_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE38_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE39_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE40_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT2_TYPE Key Flexfield segment type
SEGMENT_ATTRIBUTE40_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE41_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_LOW Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_HIGH Reporting Attribute Segment (Public Sector Financials)
SEGMENT_ATTRIBUTE42_TYPE Reporting Attribute Segment (Public Sector Financials)
SEGMENT3_LOW Key Flexfield range segment
LEDGER_SEGMENT_TYPE Ledger segment type
LEDGER_ID Ledger defining column
SEGMENT3_HIGH Key Flexfield range segment
ALC_LEDGER_CURRENCY Reporting ledger currency
SEGMENT3_TYPE Key Flexfield segment type
LAST_UPDATE_DATE Standard Who column
SEGMENT4_LOW Key Flexfield range segment
SEGMENT4_HIGH Key Flexfield range segment
SEGMENT4_TYPE Key Flexfield segment type
SEGMENT5_LOW Key Flexfield range segment
SEGMENT5_HIGH Key Flexfield range segment
SEGMENT5_TYPE Key Flexfield segment type
SEGMENT6_LOW Key Flexfield range segment
SEGMENT6_HIGH Key Flexfield range segment
SEGMENT6_TYPE Key Flexfield segment type
SEGMENT7_LOW Key Flexfield range segment
LAST_UPDATED_BY Standard Who column
SEGMENT7_HIGH Key Flexfield range segment
SEGMENT7_TYPE Key Flexfield segment type
SEGMENT8_LOW Key Flexfield range segment
SEGMENT8_HIGH Key Flexfield range segment
SEGMENT8_TYPE Key Flexfield segment type
SEGMENT9_LOW Key Flexfield range segment
SEGMENT9_HIGH Key Flexfield range segment
SEGMENT9_TYPE Key Flexfield segment type
SEGMENT10_LOW Key Flexfield range segment
SEGMENT10_HIGH Key Flexfield range segment
LAST_UPDATE_LOGIN Standard Who column
SEGMENT10_TYPE Key Flexfield segment type
SEGMENT11_LOW Key Flexfield range segment
SEGMENT11_HIGH Key Flexfield range segment
SEGMENT11_TYPE Key Flexfield segment type
SEGMENT12_LOW Key Flexfield range segment
SEGMENT12_HIGH Key Flexfield range segment
SEGMENT12_TYPE Key Flexfield segment type
SEGMENT13_LOW Key Flexfield range segment
SEGMENT13_HIGH Key Flexfield range segment
SEGMENT13_TYPE Key Flexfield segment type
CREATION_DATE Standard Who column
SEGMENT14_LOW Key Flexfield range segment
SEGMENT14_HIGH Key Flexfield range segment
SEGMENT14_TYPE Key Flexfield segment type
SEGMENT15_LOW Key Flexfield range segment
SEGMENT15_HIGH Key Flexfield range segment
SEGMENT15_TYPE Key Flexfield segment type
SEGMENT16_LOW Key Flexfield range segment
SEGMENT16_HIGH Key Flexfield range segment
SEGMENT16_TYPE Key Flexfield segment type
SEGMENT17_LOW Key Flexfield range segment
CREATED_BY Standard Who column
SEGMENT17_HIGH Key Flexfield range segment
SEGMENT17_TYPE Key Flexfield segment type
SEGMENT18_LOW Key Flexfield range segment
SEGMENT18_HIGH Key Flexfield range segment
SEGMENT18_TYPE Key Flexfield segment type
SEGMENT19_LOW Key Flexfield range segment
SEGMENT19_HIGH Key Flexfield range segment
SEGMENT19_TYPE Key Flexfield segment type
SEGMENT20_LOW Key Flexfield range segment
SEGMENT20_HIGH Key Flexfield range segment
OVERRIDE_SEQ Sequence number for this flexfield range
SEGMENT20_TYPE Key Flexfield segment type
SEGMENT21_LOW Key Flexfield range segment
SEGMENT21_HIGH Key Flexfield range segment
SEGMENT21_TYPE Key Flexfield segment type
SEGMENT22_LOW Key Flexfield range segment
SEGMENT22_HIGH Key Flexfield range segment
SEGMENT22_TYPE Key Flexfield segment type
SEGMENT23_LOW Key Flexfield range segment
SEGMENT23_HIGH Key Flexfield range segment
SEGMENT23_TYPE Key Flexfield segment type
RANGE_MODE Summary flag indicating whether summary values are in the flexfield range
SEGMENT24_LOW Key Flexfield range segment
SEGMENT24_HIGH Key Flexfield range segment
SEGMENT24_TYPE Key Flexfield segment type
SEGMENT25_LOW Key Flexfield range segment
SEGMENT25_HIGH Key Flexfield range segment
SEGMENT25_TYPE Key Flexfield segment type
SEGMENT26_LOW Key Flexfield range segment
SEGMENT26_HIGH Key Flexfield range segment
SEGMENT26_TYPE Key Flexfield segment type
SEGMENT27_LOW Key Flexfield range segment
Application Report Generator - RG_REPORT_CONTENT_SETS Content set definitions
Column Name Descritpion
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
NAME Content set name
REPORT_RUN_TYPE Report run type (parallel or sequential)
ID_FLEX_CODE_11I GL# or GLAT
APPLICATION_ID Application defining column
STRUCTURE_ID Key Flexfield structure defining column
DESCRIPTION Content set description
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
CONTENT_SET_ID Content set defining column
ATTRIBUTE8 Descriptive Flexfield segment
ATTRIBUTE9 Descriptive Flexfield segment
ATTRIBUTE10 Descriptive Flexfield segment
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
SECURITY_FLAG Security flag
LAST_UPDATE_DATE Standard Who column
ID_FLEX_CODE GLLE
LAST_UPDATED_BY Standard Who column
Application Report Generator - RG_REPORT_EXCEPTIONS Exception conditions for columns
Column Name Descritpion
APPLICATION_ID Application defining column
CONDITION Condition for this exception (>, <, <=, etc.)
CONSTANT Constant value to compare column value against
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
AXIS_SET_ID Defining column for the column set the exception refers to
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
AXIS_SEQ Sequence number of the column the exception is defined on
EXCEPTION_ID Exception 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
Application Report Generator - RG_REPORT_EXCEPTION_FLAGS Symbols used to indicate exceptions
Column Name Descritpion
APPLICATION_ID Application defining column
FLAG Flag to use on the report to mark records meeting the exception
DESCRIPTION Description of the exception that uses this flag
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
AXIS_SET_ID Defining column for the column set this exception refers to
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
AXIS_SEQ Sequence number of the column this exception is defined on
ATTRIBUTE15 Descriptive Flexfield segment
EXCEPTION_ID Exception 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
Application Report Generator - RG_REPORT_PARAMETERS Assignments of budgets, encumbrances, and currencies to reports
Column Name Descritpion
PARAMETER_SET_ID Parameter set defining column
UNIT_OF_MEASURE_ID_11I No Longer Used in R12
CURRENCY_TYPE_11I Obsolete
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
LAST_UPDATE_DATE Standard Who column
ATTRIBUTE8 Descriptive Flexfield segment
UNIT_OF_MEASURE_ID Currency
ATTRIBUTE9 Descriptive Flexfield segment
ATTRIBUTE10 Descriptive Flexfield segment
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
LAST_UPDATED_BY Standard Who column
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
ENTERED_CURRENCY Entered currency
LAST_UPDATE_LOGIN Standard Who column
LEDGER_CURRENCY Ledger functional currency
CURRENCY_TYPE Currency
CREATION_DATE Standard Who column
PERIOD_NUM Period number
FISCAL_YEAR_OFFSET Fiscal year offset
CREATED_BY Standard Who column
PARAMETER_NUM Control value when defining rows or columns
DATA_TYPE Indicates budget, encumbrance and currency data
PARAMETER_ID Indicates budget or encumbrance id
Application Report Generator - RG_REPORT_REQUESTS Report request tracking and assignments of reports to report sets
Column Name Descritpion
APPLICATION_ID Application defining column
ACCOUNTING_DATE Accounting date for which report is to be run
REPORT_ID Report defining column
SEQUENCE Report sequence in the report set
FORM_SUBMISSION_FLAG Flag used to indicate whether the request has been submitted by the form
CONCURRENT_REQUEST_ID System generated id used to monitor job using concurrent manager
REPORT_SET_ID Report set defining column
REPORT_REQUEST_ID Primary key for table
CONTENT_SET_ID Content set defining column
SET_OF_BOOKS_ID Accounting books defining column
ROW_ORDER_ID Row order defining column
EXCEPTIONS_FLAG Display only exception rows flag
ROUNDING_OPTION Rounding method
LEDGER_ID Ledger defining column
REPORT_DISPLAY_SET_ID Report display set defining column
ID_FLEX_CODE_11I Obsolete
STRUCTURE_ID Key Flexfield structure defining column
SEGMENT_OVERRIDE_11I Obsolete
PERIOD_NAME Period for which report is to be run
LAST_UPDATE_DATE Standard Who column
UNIT_OF_MEASURE_ID_11I Obsolete
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
LAST_UPDATED_BY Standard Who column
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
RUNTIME_OPTION_CONTEXT RG_RUNTIME_OPTION descriptive flexfield structure defining column
OUTPUT_OPTION Output option
LAST_UPDATE_LOGIN Standard Who column
ID_FLEX_CODE GLLE
SEGMENT_OVERRIDE Segment override value
CREATION_DATE Standard Who column
UNIT_OF_MEASURE_ID Currency
ALC_LEDGER_CURRENCY Reporting ledger currency
CREATED_BY Standard Who column
OVERRIDE_ALC_LEDGER_CURRENCY Override reporting ledger currency
Application Report Generator - RG_REPORT_SETS Report set definitions
Column Name Descritpion
APPLICATION_ID Application defining column
PERIOD_TYPE No longer used
PERIOD_NAME No longer used
STRUCTURE_ID Key Flexfield structure defining column
DESCRIPTION Description of the report set
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
REPORT_SET_ID Report set 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
LAST_UPDATE_DATE Standard Who column
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
UNIT_OF_MEASURE_ID Default currency of the report set
LAST_UPDATED_BY Standard Who column
SECURITY_FLAG Security flag
ID_FLEX_CODE GLLE
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
NAME Name of report set
ID_FLEX_CODE_11I Obsolete
Application Report Generator - RG_REPORT_STANDARD_AXES Amount types used in rows and columns
Column Name Descritpion
APPLICATION_ID Application defining column
DISPLAY_IN_STANDARD_LIST_FLAG Indicated whether to display in quickpick
PRECEDENCE_LEVEL Determine which precedence level this amount type should use in calculation
DATABASE_COLUMN Indicates column in the data storage table to find the standard axis
SIMPLE_WHERE_NAME Query for this standard axis
PERIOD_QUERY Query to find the period name
STANDARD_AXIS1_ID First amount type that used to create this one
AXIS1_OPERATOR Operator used in first amount type
STANDARD_AXIS2_ID Second amount type that use to create this one
AXIS2_OPERATOR Operator used in second amount type
CONSTANT Constant used for calculation
STANDARD_AXIS_ID Standard axis defining column
DESCRIPTION Description of the standard axis
VARIANCE_FLAG Determine whether amount type is variance
SIGN_FLAG No longer used
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
STANDARD_AXIS_NAME Name of standard axis
CLASS Class of standard axis, calculated or primitive
Application Report Generator - RG_REPORT_SUB_REQUEST_RUNS Sub request information for parallel content sets
Column Name Descritpion
SUB_REQUEST_RUN_ID Sub request report defining column
REQUEST_ID Enhanced Who column
OVERRIDE_SEG_NUMBER Override segment number
OVERRIDE_SEG_NAME Override segment name
OVERRIDE_SEG_VALUE Override segment value
OVERRIDE_CONTENT_SEQ Sequence of the override content set
PARENT_REQUEST_ID Concurrent request defining column of the parent request
PRINT_WIDTH Report width for printing
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
PROGRAM_APPLICATION_ID Enhanced Who column
PROGRAM_ID Enhanced Who column
PROGRAM_UPDATE_DATE Enhanced Who column
Application Report Generator - RG_ROW_ORDERS Row order definitions
Column Name Descritpion
APPLICATION_ID Application defining column
ID_FLEX_CODE_11I Obsolete
STRUCTURE_ID Key Flexfield structure defining column
DESCRIPTION Description of the row order
COLUMN_NUMBER The sequence number of the column used to rank your report
COLUMN_NAME The name of the column used to rank the report. Denormalized from RG_REPORT_AXES
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ROW_ORDER_ID Row order defining column
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_UPDATE_DATE Standard Who column
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
SECURITY_FLAG Reserved for future use
LAST_UPDATED_BY Standard Who column
ID_FLEX_CODE Reserved for future use
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
NAME Name of this row order
ROW_RANK_TYPE Indicates whether report information is ranked in ascending or descending order
Application Report Generator - RG_ROW_SEGMENT_SEQUENCES Assignments of segments to row orders
Column Name Descritpion
APPLICATION_ID Application defining column
SEG_ORDER_TYPE Indicates whether the segments are ordered alphabetically or by the column ranking
SEG_DISPLAY_TYPE Indicates whether the flexfield segment value and/or description is displayed
STRUCTURE_ID Key Flexfield structure defining column
SEGMENT_NAME The name of the segment used for sequencing. Denormalized from FND_ID_FLEX_SEGMENTS
SEGMENT_WIDTH The number of characters that display on the report for a flexfield segment
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ROW_ORDER_ID Row order defining column
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
ROW_SEGMENT_SEQUENCE_ID Primary key for table
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
APPLICATION_COLUMN_NAME Key Flexfield segment 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
SEGMENT_SEQUENCE The sequence that the flexfield segment appears on the report
Application Report Generator - RG_SIMPLE_WHERE_CLAUSES Query information for specific amount types
Column Name Descritpion
SIMPLE_WHERE_NAME Name of where clause used to load seeded amount types
WHERE_COLUMN Name of column this where clause is defined on
WHERE_VALUE Value of the where column that the where clause is created with
Application Report Generator - RG_TABLE_SIZES Sizes of selected Oracle General Ledger tables
Column Name Descritpion
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
TABLE_ID Table defining column
NUMBER_ROWS Number of records in this table
Application Report Generator - RG_REPORT_DISPLAYS Assignments of report display groups to report display sets
Column Name Descritpion
REPORT_DISPLAY_ID Report display group defining column
ROW_GROUP_ID Row display group defining column
COLUMN_GROUP_ID Column display group defining column
DESCRIPTION Report display descriptions
CONTEXT 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
REPORT_DISPLAY_SET_ID Report display set 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
SEQUENCE Display sequence in the display set
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
DISPLAY_FLAG Flag to determine whether the value will be displayed
Application Report Generator - RG_REPORT_DISPLAY_GROUPS Report display group definitions
Column Name Descritpion
REPORT_DISPLAY_GROUP_ID Display group defining column
DESCRIPTION Report display group description
ROW_SET_ID Row set defining column
COLUMN_SET_ID Column set 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
NAME Report display group name
ATTRIBUTE7 Descriptive flexfield segment
ATTRIBUTE8 Descriptive flexfield segment
ATTRIBUTE9 Descriptive flexfield segment
ATTRIBUTE10 Descriptive flexfield segment
ATTRIBUTE11 Descriptive flexfield segment
ATTRIBUTE12 Descriptive flexfield segment
ATTRIBUTE13 Descriptive flexfield segment
ATTRIBUTE14 Descriptive flexfield segment
ATTRIBUTE15 Descriptive flexfield segment
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
FROM_SEQUENCE Starting axis sequence
TO_SEQUENCE Ending axis sequence
Application Report Generator - RG_REPORT_DISPLAY_SETS Report display set definitions
Column Name Descritpion
REPORT_DISPLAY_SET_ID Display set defining column
DESCRIPTION Report display set description
CONTEXT Descriptive flexfield context
ATTRIBUTE1 Descriptive flexfield segment
ATTRIBUTE2 Descriptive flexfield segment
ATTRIBUTE3 Descriptive flexfield segment
ATTRIBUTE4 Descriptive flexfield segment
ATTRIBUTE5 Descriptive flexfield segment
ATTRIBUTE6 Descriptive flexfield segment
ATTRIBUTE7 Descriptive flexfield segment
ATTRIBUTE8 Descriptive flexfield segment
NAME Report display set name
ATTRIBUTE9 Descriptive flexfield segment
ATTRIBUTE10 Descriptive flexfield segment
ATTRIBUTE11 Descriptive flexfield segment
ATTRIBUTE12 Descriptive flexfield segment
ATTRIBUTE13 Descriptive flexfield segment
ATTRIBUTE14 Descriptive flexfield segment
ATTRIBUTE15 Descriptive flexfield segment
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
ROW_SET_ID Row set defining column
COLUMN_SET_ID Column set defining column
Application Report Generator - RG_DSS_DIMENSIONS Financial Analyzer dimensions
Column Name Descritpion
VALUE_PREFIX Prefix of dimension values
DIMENSION_ID Dimension defining column
ROW_LABEL Value used for row label (Value, Description, or Both)
NAME Dimension name
COLUMN_LABEL Value used for column label (Value, Description, or Both)
SELECTOR_LABEL Value used for selector label (Value, Description, or Both)
LEVEL_CODE Dimension level (Summary or Detail)
DIMENSION_TYPE Dimension Type (Primitive, Single Segment, Multiple Segments, or Time)
DIMENSION_BY_CURRENCY Not currently used
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
ID_FLEX_CODE Key flexfield code
OBJECT_NAME Unique name of the dimension used by Financial Analyzer
ID_FLEX_NUM Key flexfield structure number
DESCRIPTION Dimension description
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
OBJECT_PREFIX Dimension's identifying prefix
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
Application Report Generator - RG_DSS_HIERARCHIES Financial Analyzer hierarchies
Column Name Descritpion
ID_FLEX_NUM Key flexfield structure number
DIMENSION_ID Base dimension defining column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
HIERARCHY_ID Hierarchy defining column
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
DESCRIPTION Hierarchy description
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
NAME Hierarchy name
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
ID_FLEX_CODE Key flexfield code
Application Report Generator - RG_DSS_HIERARCHY_DETAILS Financial Analyzer hierarchy segment mappings
Column Name Descritpion
HIERARCHY_ID Hierarchy defining column
SEQUENCE Hierarchy detail sequence
APPLICATION_COLUMN_NAME Name of the column containing the segment
ROOT_NODE Topmost parent node of the hierarchy
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
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
Application Report Generator - RG_DSS_VARIABLES Financial Analyzer financial data items
Column Name Descritpion
CURRENCY_TYPE Currency type (Foreign Entered, Foreign Translated, Functional Only, Statistical Only, Functional and Statistical)
SEGMENT18_TYPE Segment type column
SEGMENT19_TYPE Segment type column
SEGMENT20_TYPE Segment type column
SEGMENT21_TYPE Segment type column
SEGMENT22_TYPE Segment type column
SEGMENT23_TYPE Segment type column
SEGMENT24_TYPE Segment type column
SEGMENT25_TYPE Segment type column
SEGMENT26_TYPE Segment type column
SEGMENT27_TYPE Segment type column
LEVEL_CODE Financial data item level (Summary or Detail)
SEGMENT28_TYPE Segment type column
SEGMENT29_TYPE Segment type column
SEGMENT30_TYPE Segment type 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
STATUS_CODE Financial data item status
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
OBJECT_NAME Financial data item name in Financial Analyzer
COLUMN_LABEL Column, row, and selector label used in Financial Analyzer
VARIABLE_ID Financial data item defining column
ID_FLEX_CODE Key flexfield code
SET_OF_BOOKS_ID Set of books defining column
ID_FLEX_NUM Key flexfield structure number
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CURRENCY_CODE Currency code
BUDGET_VERSION_ID Budget version defining column
NAME Financial data item name
ENCUMBRANCE_TYPE_ID Encumbrance type defining column
LEDGER_ID Set of books defining column
DESCRIPTION Financial data item description
SEGMENT1_TYPE Segment type column
SEGMENT2_TYPE Segment type column
SEGMENT3_TYPE Segment type column
SEGMENT4_TYPE Segment type column
SEGMENT5_TYPE Segment type column
SEGMENT6_TYPE Segment type column
SEGMENT7_TYPE Segment type column
BALANCE_TYPE Balance Type
SEGMENT8_TYPE Segment type column
SEGMENT9_TYPE Segment type column
SEGMENT10_TYPE Segment type column
SEGMENT11_TYPE Segment type column
SEGMENT12_TYPE Segment type column
SEGMENT13_TYPE Segment type column
SEGMENT14_TYPE Segment type column
SEGMENT15_TYPE Segment type column
SEGMENT16_TYPE Segment type column
SEGMENT17_TYPE Segment type column
Application Report Generator - RG_DSS_SYSTEMS Financial Analyzer financial data sets
Column Name Descritpion
ID_FLEX_NUM Key flexfield structure number
PERIOD_SET_NAME Calendar 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
SYSTEM_ID Financial data set defining column
CREATED_BY Standard Who column
CONTEXT Descriptive flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
NAME Financial data set name
ATTRIBUTE9 Descriptive Flexfield segment
ATTRIBUTE10 Descriptive Flexfield segment
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
FREEZE_FLAG Flag to freeze the system
SAVE_INCREMENTAL_DATA_FLAG Flag to save incremental balances
ID_FLEX_CODE Key flexfield code
Application Report Generator - RG_DSS_SYSTEM_VARIABLES Assignments of financial data items to financial data sets
Column Name Descritpion
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
CONTEXT Descriptive Flexfield context
SYSTEM_ID Financial data set defining column
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
ATTRIBUTE9 Descriptive Flexfield segment
ATTRIBUTE10 Descriptive Flexfield segment
VARIABLE_ID Financial data item defining column
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
SYSTEM_VARIABLE_ID Assignment defining column
LAST_UPDATE_DATE Standard Who column
Application Report Generator - RG_DSS_SEG_RANGE_SETS Filters
Column Name Descritpion
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
RANGE_SET_ID Filter defining column
DESCRIPTION Filter description
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
NAME Filter name
ATTRIBUTE9 Descriptive Flexfield segment
ATTRIBUTE10 Descriptive Flexfield segment
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
APPLICATION_COLUMN_NAME Name of the column containing the segment used by the filter
ID_FLEX_CODE Key flexfield code
ID_FLEX_NUM Key flexfield structure number
Application Report Generator - RG_DSS_SEG_RANGES Segment ranges for filters
Column Name Descritpion
SEGMENT_HIGH High value of the range
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
RANGE_SET_ID Filter defining column
CREATED_BY Standard Who column
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
RANGE_ID Range defining column
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
INCLUDE_FLAG Include or Exclude segment ranges
SEGMENT_LOW Low value of the range
Application Report Generator - RG_DSS_DIM_SEGMENTS Financial Analyzer dimension segment mappings
Column Name Descritpion
ID_FLEX_NUM Key flexfield structure number
MAX_DESC_SIZE Maximum size of segment description used by Financial Analyzer
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
DIMENSION_ID Dimension defining column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
RANGE_SET_ID Filter defining column
ACCOUNT_TYPE Account type (Asset, Liability, Owner's Equity, Revenue, Expense, or All)
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
SEQUENCE Sequence in which the segment appears in the dimension
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
APPLICATION_COLUMN_NAME Name of the column containing the segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
ID_FLEX_CODE Key flexfield code
Application Report Generator - RG_DSS_VAR_DIMENSIONS Financial Analyzer financial data item dimensions
Column Name Descritpion
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
CONTEXT Descriptive Flexfield context
VARIABLE_ID Variable 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
SEQUENCE Assignment sequence
ATTRIBUTE11 Descriptive Flexfield segment
ATTRIBUTE12 Descriptive Flexfield segment
ATTRIBUTE13 Descriptive Flexfield segment
ATTRIBUTE14 Descriptive Flexfield segment
ATTRIBUTE15 Descriptive Flexfield segment
DIMENSION_ID Dimension defining column
LAST_UPDATE_DATE Standard Who column
Application Report Generator - RG_DSS_VAR_SELECTIONS Financial Analyzer financial data item selections
Column Name Descritpion
SELECTION_ID Selection defining column
RANGE_SET_ID Filter defining column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
VARIABLE_ID Variable defining column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
APPLICATION_COLUMN_NAME Name of the column containing the 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
ID_FLEX_CODE Key flexfield code
ID_FLEX_NUM Key flexfield structure number
Application Report Generator - RG_DSS_REQUESTS Financial Analyzer extract/load request tracking
Column Name Descritpion
CONCURRENT_REQUEST_ID Concurrent request identifier of the extraction run
STATUS_FLAG Status of the extraction request (Extracting, New, Loading, Loaded, Cancel, Launched, Error)
LEVEL_CODE Extraction level (Summary or Detail)
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
CREATION_DATE Standard Who column
SET_OF_BOOKS_ID Accounting books defining column
CREATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
FILE_SPEC Location of the extraction file
EXTRACTION_START_DATE Start time of the extraction process
EXTRACTION_END_DATE End time of the extraction process
LOAD_START_DATE Start time of the load process
LOAD_END_DATE End time of the load process
PROGRAM_TYPE Program type (Segment, Balances, Hierarchy, Currency, Rates, or Calendar)
CHART_OF_ACCOUNTS_ID Key flexfield structure number
LEDGER_ID Accounting books defining column
FROM_PERIOD From period
TO_PERIOD To period
BALANCE_TYPE Balance Type
BUDGET_VERSION_ID Budget version defining column
ENCUMBRANCE_TYPE_ID Encumbrance defining column (-1 - total of all encumbrances, -2 - for all encumbrances)
TEMPLATE_ID Summary template defining column (-1 - for all summary templates)
DAY_OF_PERIOD Day of period to be used (-1 - for last day in each period)
HIERARCHY_ID Hierarchy defining column
REQUEST_ID The request identifier of the current extract or load request
PERIOD_YEAR Accounting period year
Application Report Generator - RG_DATABASE_LINKS Database link definitions
Column Name Descritpion
DATABASE_LINK_ID Database Link defining column
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
NAME Database Link name
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
DESCRIPTION Database Link description
CONNECT_STRING Connect string for destination database
DOMAIN_NAME Domain name for destination database
APPS_USERNAME Apps account username for destination database
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
Application Report Generator - RG_DSS_SYSTEM_SEG_ORDER Financial Analyzer financial data set segment sort order
Column Name Descritpion
SYSTEM_ID Financial data set defining column
LAST_UPDATE_LOGIN Standard Who column
CONTEXT Descriptive Flexfield context
ATTRIBUTE1 Descriptive Flexfield segment
ATTRIBUTE2 Descriptive Flexfield segment
ATTRIBUTE3 Descriptive Flexfield segment
ATTRIBUTE4 Descriptive Flexfield segment
ATTRIBUTE5 Descriptive Flexfield segment
ATTRIBUTE6 Descriptive Flexfield segment
ATTRIBUTE7 Descriptive Flexfield segment
ATTRIBUTE8 Descriptive Flexfield segment
SEQUENCE Position of column in the sort order
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
APPLICATION_COLUMN_NAME Name of column that contains the segment
ID_FLEX_CODE Key flexfield code
ID_FLEX_NUM Key flexfield structure number
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
Application Report Generator - RG_DSS_VAR_TEMPLATES Financial Analyzer financial data item summary templates
Column Name Descritpion
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
LAST_UPDATED_BY Standard Who column
ATTRIBUTE10 Descriptive flexfield segment
ATTRIBUTE11 Descriptive flexfield segment
ATTRIBUTE12 Descriptive flexfield segment
ATTRIBUTE13 Descriptive flexfield segment
ATTRIBUTE14 Descriptive flexfield segment
ATTRIBUTE15 Descriptive flexfield segment
LAST_UPDATE_LOGIN Standard Who column
SEGMENT1_TYPE Summary type flexfield segment
VARIABLE_ID Financial Data Item defining column
SEGMENT2_TYPE Summary type flexfield segment
SEGMENT3_TYPE Summary type flexfield segment
SEGMENT4_TYPE Summary type flexfield segment
SEGMENT5_TYPE Summary type flexfield segment
SEGMENT6_TYPE Summary type flexfield segment
SEGMENT7_TYPE Summary type flexfield segment
SEGMENT8_TYPE Summary type flexfield segment
SEGMENT9_TYPE Summary type flexfield segment
SEGMENT10_TYPE Summary type flexfield segment
TEMPLATE_ID Summary Template defining column
SEGMENT11_TYPE Summary type flexfield segment
SEGMENT12_TYPE Summary type flexfield segment
SEGMENT13_TYPE Summary type flexfield segment
SEGMENT14_TYPE Summary type flexfield segment
SEGMENT15_TYPE Summary type flexfield segment
SEGMENT16_TYPE Summary type flexfield segment
SEGMENT17_TYPE Summary type flexfield segment
SEGMENT18_TYPE Summary type flexfield segment
SEGMENT19_TYPE Summary type flexfield segment
SEGMENT20_TYPE Summary type flexfield segment
CREATION_DATE Standard Who column
SEGMENT21_TYPE Summary type flexfield segment
SEGMENT22_TYPE Summary type flexfield segment
SEGMENT23_TYPE Summary type flexfield segment
SEGMENT24_TYPE Summary type flexfield segment
SEGMENT25_TYPE Summary type flexfield segment
SEGMENT26_TYPE Summary type flexfield segment
SEGMENT27_TYPE Summary type flexfield segment
SEGMENT28_TYPE Summary type flexfield segment
SEGMENT29_TYPE Summary type flexfield segment
CREATED_BY Standard Who column
SEGMENT30_TYPE Summary type flexfield segment
CONTEXT Descriptive flexfield context
ATTRIBUTE1 Descriptive flexfield segment
ATTRIBUTE2 Descriptive flexfield segment
Application Report Generator - RG_REPORT_SET_REQUESTS RG_REPORT_SET_REQUESTS tracks submission of report sets. It stores the report set that was submitted, the it was submitted, and who it was submitted by. If the report set was submitted using the Multiple Report Sets tab in the Run Financi
Column Name Descritpion
REPORT_SET_ID Report set defining column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATED_BY Standard Who column
CREATION_DATE Standard Who column
PERIOD_NAME Period name
ACCOUNTING_DATE Accounting date
UNIT_OF_MEASURE_ID Currency
REPORT_SET_REQUEST_ID Report set request defining column
Application Report Generator - RG_REPORT_SET_REQ_DETAILS RG_REPORT_SET_REQ_DETAILS tracks the individual reports that were run for each report set submission. There will be one row in this table for each report run as part of a report set submission.
Column Name Descritpion
SEQUENCE Report sequence in the report set
REPORT_ID Report defining column
CONCURRENT_REQUEST_ID Report concurrent request id
REPORT_SEQUENCE
REPORT_SET_REQUEST_ID Report set request defining column
Application Report Generator - RG_XBRL_ELEMENTS
Column Name Descritpion
TAXONOMY_ID Taxonomy defining column
ELEMENT_IDENTIFIER Taxonomy element identifier
ELEMENT_NAME Taxonomy element name
ELEMENT_TYPE Taxonomy element type
ELEMENT_GROUP Taxonomy element group
ELEMENT_DESCR Taxonomy element description
ELEMENT_LABEL Taxonomy element label
PARENT_ID Element parent defining column
ELEMENT_ID Element defining column - Primary Key
PARENT_IDENTIFIER Taxonomy element parent identifier
HAS_CHILD_FLAG Indicates whether element has a child
HAS_PARENT_FLAG Indicates whether element has a parent
HIERARCHY_LEVEL Element hierarchy level
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
Application Report Generator - RG_XBRL_TAXONOMIES
Column Name Descritpion
TAXONOMY_ALIAS Taxonomy alias including version
TAXONOMY_NAME Taxonomy name
TAXONOMY_DESCR Taxonomy description
TAXONOMY_URL Taxonomy Universal Resource Locator
CREATION_DATE Standard Who column
CREATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATED_BY Standard Who column
TAXONOMY_ID Taxonomy defining column - Primary Key
LAST_UPDATE_LOGIN Standard Who column
TAXONOMY_IMPORT_FLAG Indicated whether taxonomy imports other taxonomies.
Application Report Generator - RG_XBRL_MAP_ELEMENTS Elements mapped to taxonomy
Column Name Descritpion
TAXONOMY_ID Taxonomy defining column
ELEMENT_ID Element defining column
ENABLED_FLAG Indicated whether element is enabled
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
Application Report Generator - RG_REPORT_STANDARD_AXES_B Amount types used in rows and columns
Column Name Descritpion
APPLICATION_ID Application defining column
DISPLAY_IN_STANDARD_LIST_FLAG Indicated whether to display in quick pick or not
PRECEDENCE_LEVEL Determine which precedence level this amount type should use in calculation
DATABASE_COLUMN Indicates column in the data storage table to find the standard axis
SIMPLE_WHERE_NAME Query for this standard axis
PERIOD_QUERY Query to find the period name
STANDARD_AXIS1_ID First amount type that used to create this one
AXIS1_OPERATOR Operator used in first amount type
STANDARD_AXIS2_ID Second amount type that use to create this one
AXIS2_OPERATOR Operator used in second amount type
CONSTANT Constant used for calculation
STANDARD_AXIS_ID Standard axis defining column
VARIANCE_FLAG Determine whether amount type is variance
SIGN_FLAG No longer used
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
CLASS Class of standard axis, calculated or primitive
Application Report Generator - RG_REPORT_STANDARD_AXES_TL Translations for RG_REPORT_STANDARD_AXES
Column Name Descritpion
LANGUAGE Language
SOURCE_LANG The language the text will mirror. If text is not yet translated into LANGUAGE, than any changes to the text in the source language row will be reflected here as well.
STANDARD_AXIS_NAME Name of standard axis
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
STANDARD_AXIS_ID Standard axis defining column
DESCRIPTION Description of standard axis
Application Report Generator - RG_REPORT_REQUEST_LOBS RG_REPORT_REQUEST_LOBS stores the XML output associated with each Financial Statement Generator request that is run in XML mode. The XML output is used for drilldown purposes
Column Name Descritpion
REQUEST_ID Concurrent reuest defining column
REPORT_DATA XML output
LAST_UPDATED_BY Standard Who column
LAST_UPDATE_DATE Standard Who column
LAST_UPDATE_LOGIN Standard Who column
CREATED_BY Standard Who column
CREATION_DATE Standard Who column

No hay comentarios:

Publicar un comentario