Reports Define Column Set

Tags:

gl2 reporting2 create new tag

Transaction Description

Use these forms to define the format and content of columns for Financial Statement Generator (FSG) reports. Usually columns are defined for a time period and a row definition is used for an account assignment. Column sets include headings and subheadings, amount types, format masks, currency assignments, and calculation columns for totals.

When defining a column set, you can:

• Specify account balance types - actual, budget, or encumbrance amounts.
• Create Headings (including relative headings that change depending on the period when you run the report.)
• Define calculations
• Specify formatting by using format masks

New column set may be defined from scratch or by using AutoCopy to copy and then edit an existing column set. The Column Set Builder is a tool to define column sets graphically and can be a real time saver.

Column Set

List of Fields

• Name
• Description
• Override Segment
• Enable Security
• Descriptive Flexfield

Column Set Heading

List of Fields

Columns

List of Fields

• Position
• Sequence
• Format Mask
• Factor
• Balance Control
  • Amount Type
  • Currency
  • Control Value
  • Offset
• Descriptive Flexfield
• Advanced Options
  • Column Name
  • Description
  • Percent of Column
  • Override Value
  • Override Row Calculations
• Display Options
  • Level of Detail
  • Display Column
  • Display Zero
  • Change Sign
  • Change Sign on Variance

Calculations

List of Fields

• Seq
• Operator
• Constant
• Sequence
  • Low
  • High
• Column Name
• Descriptive Flexfield

Account Assignments

List of Fields

• Sign
• Accounts
• Low
• High
• Display
• Summary
• Activity
• Descriptive Flexfield

Exceptions

List of Fields

• Flag
• Description
• Descriptive Flexfield
• Exception Details
• Condition
• Constant
• Descriptive Flexfield

Column Set Builder

List of Fields

• Sequence
• Name
• Amount Type
• Offset
• Left Margin
• Width
• Heading
• Format Mask

More Column Options

List of Fields

• Currency
• Control Value
• Override Value
• Percent of Column
• Override Row Calculations
• Format Options
  • Factor
  • Level of Detail
  • Display Zero
  • Change Sign
  • Change Sign on Variance
• Description

Standard Column Sets

Since other reports may depend on them, don't modify standard column sets as supplied by Oracle. Instead, use AutoCopy to make your own version and then make the change on the copy. It is also a good idea to have a naming convention for the copies that you make so they will be easy to find, but still linked to the original version of the column set.

PTD VARIANCE: actual, budget, variance, and variance percentage for the current period.

QTD VARIANCE: Includes actual, budget, variance, and variance percentage for the current quarter.

PTD, QTD, YTD VARIANCE: actual, budget, variance, and variance percentage for the current period, quarter-to-date, and year-to-date. Amounts are in thousands.

PTD, QTD, YTD ACTUAL: actual current period, quarter-to-date, and year-to-date.

MONTHLY ACTUAL: monthly actuals for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.

MONTHLY BUDGET: monthly budget amounts for each month of the fiscal year plus a year-to-date total. Amounts are in thousands.

QUARTERLY ACTUAL: quarterly actuals for each quarter of the fiscal year plus a year-to-date total.

QUARTERLY BUDGET: quarterly budget amounts for each quarter of the fiscal year plus a year-to-date total.

ROLLING MONTHLY: actual amounts for the current month and the preceding 11 months. Amounts are in thousands.

ROLLING QUARTERLY: actual amounts for the current quarter and the preceding 4 quarters. Amounts are in thousands.

MONTHLY COMPARATIVE YTD: current year-to-date and prior period year-to-date.

QUARTERLY COMPARATIVE YTD: year-to-date balance for the current quarter and the previous three quarters.

ANNUAL COMPARATIVE QTD, YTD: actual amounts for the current quarter, prior year same quarter, variance, and variance percentage. Also includes actual amounts for current year-to-date, prior year-to-date, variance, and variance percentage.

FUNDS AVAILABLE: year-to-date funds available based on posted actuals, budgets, and encumbrances. Also includes total budget for year and the percentage of total budget remaining. You can use this column set to show your obligations for encumbrance reports.

Comments

Links

• Related: GeneralLedger, GLFinancialReporting, Row Set, Column Set,Content Set, Display Group,Display Set,Define Order, Define Report, Define Report Set

This Topic Is Referenced By These Topics:
Related Links: GL12ReportsDefineColumnSet, GL12ReportsDefineContentSet, GL12ReportsDefineDisplayGroup, GL12ReportsDefineDisplaySet, GL12ReportsDefineOrder, GL12ReportsDefineReport, GL12ReportsDefineReportSet, GL12ReportsDefineRowSet, GLFinancialReporting

---

---

Was This Topic Useful to You?

Others rated this topic as shown. Please include your rating.

Choice

Select ...Very UsefulSomewhat UsefulNo OpinionNot Useful

Somewhat Useful (1)

Collaborating Authors and Reviewers: -- DianeMcHugh, JimCrum