1. Tables and Views for Financials
  2. XLA_EVENT_TYPE_SOURCES

XLA_EVENT_TYPE_SOURCES

This table contains sources used by an event type in context of the application accounting definition it is assigned to.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Columns

Name Datatype Length Precision Not-null Comments
APPLICATION_ID NUMBER 18 Identifier of a functional area within a software suite of products. For example: Financials, or Payroll.
JERS_CODE VARCHAR2 30 Code of the journal entry rule set.
JERS_TYPE_CODE VARCHAR2 1 Code of the type of the journal entry rule set. The possible values are: C: owned and defined by the user. S: owned and predefined by Oracle.
AMB_CONTEXT_CODE VARCHAR2 30 Accounting method builder context.
PRODUCT_RULE_TYPE_CODE VARCHAR2 1 Indicates whether product rules are seeded.
PRODUCT_RULE_CODE VARCHAR2 30 Short name of a product rule that contains effective accounting rules that are valid for a specific assignment date.
ENTITY_CODE VARCHAR2 30 Unique abbreviated name assigned to an entity and used for reporting or in reference to an option.
EVENT_CLASS_CODE VARCHAR2 30 Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.
EVENT_TYPE_CODE VARCHAR2 30 Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
SOURCE_ORIGIN_CODE VARCHAR2 1 Indicates whether the subledger source or formula is predefined.
SOURCE_APPLICATION_ID NUMBER 18 Identifier of source application.
SOURCE_TYPE_CODE VARCHAR2 1 Indicates whether the source is seeded.
SOURCE_CODE VARCHAR2 30 Short name of the transaction information that is used to create journal entries.
SOURCE_LEVEL_CODE VARCHAR2 30 Indicates whether it is a header level source or line level source.
SOURCE_DATA_TYPE_CODE VARCHAR2 30 Abbreviated name that indicates the data type of the source. For examples, N (Numeric), C (Character), or D (Date).
EXTRACT_OBJECT_NAME VARCHAR2 30 Transaction object that provides the source.
EXTRACT_OBJECT_TYPE_CODE VARCHAR2 30 Short name of a transaction object type.
COLUMN_DATATYPE_CODE VARCHAR2 30 Data type of the column in a transaction object
COLUMN_WIDTH NUMBER 18 Width of the column in transaction object.
REFERENCE_OBJECT_FLAG VARCHAR2 1 Indicates whether the source is from reference object.
ALWAYS_POPULATED_FLAG VARCHAR2 1 Indicates if source will always return a value.
JOIN_CONDITION VARCHAR2 2000 Condition that joins the transaction and reference objects.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
EDITION_NAME VARCHAR2 128 Yes Identifier of the currently active event type sources.

Indexes

Index Uniqueness Tablespace Columns
XLA_EVENT_TYPE_SOURCES_N1 Non Unique Default APPLICATION_ID, AMB_CONTEXT_CODE, JERS_TYPE_CODE, JERS_CODE, EVENT_CLASS_CODE, EVENT_TYPE_CODE, EDITION_NAME