1. Tables and Views for Financials
  2. XLA_MPA_DISTRIBUTIONS

XLA_MPA_DISTRIBUTIONS

This table keeps track the MPA accounting progress and the running recognized amounts for an event, transaction MPA distribution, MPA class and ledger combination.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments Status
EVENT_ID NUMBER 18 Yes Accounting event identifier.
APPLICATION_ID NUMBER 18 Yes Subledger application identifier for which the multiperiod accounting transaction is created.
LEDGER_ID NUMBER 18 Yes Ledger identifier. This can be a primary, secondary or ALC ledger.
AE_HEADER_ID NUMBER 18 Yes Subledger journal header identifier of the accrual entry. Active
AE_LINE_NUM NUMBER 18 Yes Subledger journal line number of the accrual entry. Active
TEMP_LINE_NUM NUMBER 18 Yes Intermediary line number for the subledger journal of the accrual entry. Active
SOURCE_DISTRIBUTION_TYPE VARCHAR2 30 Yes Classification of transaction source distribution. Active
SOURCE_DISTRIBUTION_ID_CHAR_1 VARCHAR2 240 Transaction source distribution identifier in character data type.
SOURCE_DISTRIBUTION_ID_CHAR_2 VARCHAR2 240 Transaction source distribution identifier in character data type.
SOURCE_DISTRIBUTION_ID_CHAR_3 VARCHAR2 240 Transaction source distribution identifier in character data type.
SOURCE_DISTRIBUTION_ID_CHAR_4 VARCHAR2 240 Transaction source distribution identifier in character data type.
SOURCE_DISTRIBUTION_ID_CHAR_5 VARCHAR2 240 Transaction source distribution identifier in character data type.
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER 38 Transaction source distribution identifier in numeric data type.
SOURCE_DISTRIBUTION_ID_NUM_2 NUMBER 38 Transaction source distribution identifier in numeric data type.
SOURCE_DISTRIBUTION_ID_NUM_3 NUMBER 38 Transaction source distribution identifier in numeric data type.
SOURCE_DISTRIBUTION_ID_NUM_4 NUMBER 38 Transaction source distribution identifier in numeric data type.
SOURCE_DISTRIBUTION_ID_NUM_5 NUMBER 38 Transaction source distribution identifier in numeric data type.
MULTIPERIOD_CLASS_CODE VARCHAR2 30 Yes Multiperiod class for this distribution.
LAST_GL_DATE DATE Accounting date of the last multiperiod journal entry with Final status.
NEXT_GL_EFF_PERIOD_NUM NUMBER 18 Yes The denormalized period number of the accounting period for the next multiperiod journal entry of the distribution, ledger, and multiperiod accounting class. Defaults to the first open period of the ledger when the multiperiod accounting distribution row is first created.
PROC_STATUS_CODE VARCHAR2 30 Yes Stores the processing status of the last accounting entry for the multiperiod distribution.
STATUS_CODE VARCHAR2 30 Yes Multiperiod distribution recognition or reversal status. Possible values are U (Final status journal has not been created yet), P (Final status journal has been created but amount is not fully recognized yet), R(reversed), and F (entire amount has been fully recognized).
FULLY_PROCESSED_FLAG VARCHAR2 1 Yes It is used to determine whether additional multiperiod journals need to be created in the future. Once the distribution has been fully recognized or reversed, it is updated from N to Y.
CURRENCY_CODE VARCHAR2 15 Yes Transaction currency of the distribution
UNROUNDED_ENTERED_DR NUMBER Total debit amount in transaction currency to be recognized.
UNROUNDED_ENTERED_CR NUMBER Total credit amount in transaction currency to be recognized.
UNROUNDED_ACCOUNTED_DR NUMBER Total debit amount in ledger currency to be recognized.
UNROUNDED_ACCOUNTED_CR NUMBER Total credit amount in ledger currency to be recognized.
REC_ENTERED_DR NUMBER Debit amount in entered currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status.
REC_ENTERED_CR NUMBER Credit amount in entered currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status.
REC_ACCOUNTED_DR NUMBER Debit amount in ledger currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status.
REC_ACCOUNTED_CR NUMBER Credit amount in ledger currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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.
PARTITION_GROUP_CODE VARCHAR2 15 Partition grouping information, when combined with the period, determines the database partition in which this multi-period accounting information will be stored.
ACCRUAL_PERIOD_NAME VARCHAR2 15 Accounting period of the accrual entry.

Indexes

Index Uniqueness Tablespace Columns
XLA_MPA_DISTRIBUTIONS_N1 Non Unique FUSION_TS_TX_DATA APPLICATION_ID, LEDGER_ID, FULLY_PROCESSED_FLAG, NEXT_GL_EFF_PERIOD_NUM
XLA_MPA_DISTRIBUTIONS_N2 Non Unique FUSION_TS_TX_DATA SOURCE_DISTRIBUTION_TYPE, NVL("SOURCE_DISTRIBUTION_ID_NUM_1",(-99)), NVL("SOURCE_DISTRIBUTION_ID_NUM_2",(-99)), NVL("SOURCE_DISTRIBUTION_ID_NUM_3",(-99)), NVL("SOURCE_DISTRIBUTION_ID_NUM_4",(-99)), NVL("SOURCE_DISTRIBUTION_ID_NUM_5",(-99)), NVL("SOURCE_DISTRIBUTION_ID_CHAR_1",' '), NVL("SOURCE_DISTRIBUTION_ID_CHAR_2",' '), NVL("SOURCE_DISTRIBUTION_ID_CHAR_3",' '), NVL("SOURCE_DISTRIBUTION_ID_CHAR_4",' '), NVL("SOURCE_DISTRIBUTION_ID_CHAR_5",' ')
XLA_MPA_DISTRIBUTIONS_U1 Unique FUSION_TS_TX_DATA APPLICATION_ID, EVENT_ID, AE_HEADER_ID, AE_LINE_NUM, TEMP_LINE_NUM