1. Tables and Views for Financials
  2. XLA_ANALYTICAL_HDRS_B_

XLA_ANALYTICAL_HDRS_B_

This table contains the header information for the analytical criteria. Since some analytical criteria are delivered as seeded data by the product teams, the name and the description are subjected to translation, so there are two tables for the analytical criteria.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

XLA_ANALYTICAL_HDRS_B_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, ANALYTICAL_CRITERION_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
SUPPORTING_REFERENCE_ID NUMBER 18 Supporting reference unique identifier.
AMB_CONTEXT_CODE VARCHAR2 30 Accounting methods builder context. Active
APPLICATION_ID NUMBER 18 Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ANALYTICAL_CRITERION_CODE VARCHAR2 30 Yes Supporting reference short name. Active
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 1 An abbreviated name that indicates the owner of a supporting reference. Possible values are C: defined by the user, S: predefined by Oracle. Active
SUPP_REF_ORDER NUMBER 2 Order of the supporting reference
BALANCING_FLAG VARCHAR2 1 Indicates whether balance will be maintained for the specific supporting reference Active
DISPLAY_ORDER NUMBER Not currently used. Active
ENABLED_FLAG VARCHAR2 1 Indicates whether the supporting reference is enabled. Active
YEAR_END_CARRY_FORWARD_CODE VARCHAR2 30 If the BALANCING_FLAG = Y it must have one of the following values, otherwise it must be null. A: The supporting reference balances are always carried forward to the next fiscal year. N: The supporting reference balances are never carried forward to the next fiscal year. B: The supporting reference balances are conditionally carried forward to the next fiscal year, depending on the account type. Active
UPDATED_FLAG VARCHAR2 1 Indicate if the application accounting definition is updated since last exported Active
VERSION_NUM NUMBER Version number generated automatically at the time of export Active
UPDATED_IN_ESSBASE VARCHAR2 1 Indicates If the specific dimension is created for the supporting reference in ESSBASE.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns Status
XLA_ANALYTICAL_HDRS_BN1_ Non Unique Default ANALYTICAL_CRITERION_CODE, LAST_UPDATE_DATE
XLA_ANALYTICAL_HDRS_B_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, ANALYTICAL_CRITERION_CODE Active