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