1. Tables and Views for Financials
  2. XLA_DISTRIBUTION_LINKS

XLA_DISTRIBUTION_LINKS

This table contains the link between transactions and subledger journal entry lines.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments Status
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll.
EVENT_ID NUMBER 18 Yes Identifier of the categorization of accounting events that is unique within an application and event class. Active
AE_HEADER_ID NUMBER 18 Yes Subledger journal entry identifier. Active
AE_LINE_NUM NUMBER 38 Yes Subledger journal entry line number. Active
APPLIED_DESCRIPTION_PRIORITY NUMBER 18 Rule priority of the successfully evaluated description rule that was used to create the journal line description.
APPLIED_ACCOUNT_PRIORITIES VARCHAR2 240 Concatenated rule priority of the successfully evaluated account and segment rules that were used to derive the GL account.
SOURCE_DISTRIBUTION_TYPE VARCHAR2 30 Yes Classification of transaction source distribution. Active
SOURCE_DISTRIBUTION_ID_CHAR_1 VARCHAR2 240 Flexible source distribution identifier (Character).
SOURCE_DISTRIBUTION_ID_CHAR_2 VARCHAR2 240 Flexible source distribution identifier (Character).
SOURCE_DISTRIBUTION_ID_CHAR_3 VARCHAR2 240 Flexible source distribution identifier (Character).
SOURCE_DISTRIBUTION_ID_CHAR_4 VARCHAR2 240 Flexible source distribution identifier (Character).
SOURCE_DISTRIBUTION_ID_CHAR_5 VARCHAR2 240 Flexible source distribution identifier (Character).
SOURCE_DISTRIBUTION_ID_NUM_1 NUMBER 38 Transaction source distribution identifier (Number).
SOURCE_DISTRIBUTION_ID_NUM_2 NUMBER 38 Transaction source distribution identifier (Number).
SOURCE_DISTRIBUTION_ID_NUM_3 NUMBER 38 Transaction source distribution identifier (Number).
SOURCE_DISTRIBUTION_ID_NUM_4 NUMBER 38 Transaction source distribution identifier (Number).
SOURCE_DISTRIBUTION_ID_NUM_5 NUMBER 38 Transaction source distribution identifier (Number).
TAX_LINE_REF_ID NUMBER 18 Identifier of detail tax line reference. Active
TAX_SUMMARY_LINE_REF_ID NUMBER 18 Identifier of summary tax line reference. Active
TAX_REC_NREC_DIST_REF_ID NUMBER 18 Detail tax distribution reference. Active
STATISTICAL_AMOUNT NUMBER Amount entered in a journal that is based on the unit of measure. Active
REF_AE_HEADER_ID NUMBER 18 Yes Reversed subledger journal entry header identifier. Active
REF_TEMP_LINE_NUM NUMBER 18 Temporary line number reference. Active
ACCOUNTING_LINE_CODE VARCHAR2 30 Short name of a rule to convert transactional data into a journal entry line. Active
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 1 Type of journal line rule: Debit, Credit, Gain or Loss. Active
MERGE_DUPLICATE_CODE VARCHAR2 1 Yes Indicates how duplicate subledger journal lines are merged. Possible values are: A: Merge all lines. W: All matching debit lines will be merged and all matching credit lines will be merged to produce a single debit, single credit, or both a single debit and credit line. N: Do not merge matching lines. Active
TEMP_LINE_NUM NUMBER 18 Yes Intermediary line number generated by the accounting engine when the entries are in most detail form. Active
REF_EVENT_ID NUMBER 18 In a reversal row, indicates the event identifier from the actual reversed subledger journal entry line. Otherwise, the value is Null. Active
LINE_DEFINITION_OWNER_CODE VARCHAR2 30 Journal lines definition owner code. Active
LINE_DEFINITION_CODE VARCHAR2 30 Short name of a subledger journal entry line definition. Active
EVENT_CLASS_CODE VARCHAR2 30 Unique abbreviated name assigned to an event class and used for reporting or in reference to an option. Active
EVENT_TYPE_CODE VARCHAR2 30 Unique abbreviated name assigned to an event type and used for reporting or in reference to an option. Active
UPG_BATCH_ID NUMBER 18 Unique identifier of upgrade batch. Active
CALCULATE_ACCTD_AMTS_FLAG VARCHAR2 1 Indicates whether the accounted amounts are calculated by Subledger Accounting or passed through transaction objects. Y indicates that accounted amounts are calculated by the accounting program. N indicates that accounted amounts were passed through the extract. Active
CALCULATE_G_L_AMTS_FLAG VARCHAR2 1 Indicates whether the gain or loss amounts are calculated by the accounting engine. Y indicates that gain or loss amounts are calculated by the accounting program. N indicates that gain or loss amounts were passed through the extract. Active
ROUNDING_CLASS_CODE VARCHAR2 30 Accounting class associated to the journal line. It is used as the grouping criteria for rounding. Accounting Program uses this field and the DOCUMENT_ROUNDING_LEVEL together to group lines together to perform rounding. Active
DOCUMENT_ROUNDING_LEVEL VARCHAR2 30 Indicates the document identifier for which the accounting engine must perform the rounding. Accounting Program uses this field and the rounding_class_code together to group lines together to perform rounding. Active
UNROUNDED_ENTERED_DR NUMBER Unrounded entered debit amount for the journal line. Active
UNROUNDED_ENTERED_CR NUMBER Unrounded entered credit amount for the journal line. Active
DOC_ROUNDING_ENTERED_AMT NUMBER Unrounded accounted debit. Active
DOC_ROUNDING_ACCTD_AMT NUMBER Rounding amount for accounted amount calculated by the accounting engine for the document. Active
UNROUNDED_ACCOUNTED_CR NUMBER Unrounded accounted credit for journal entry line. Active
UNROUNDED_ACCOUNTED_DR NUMBER Unrounded accounted debit for journal entry line. Active
APPLIED_TO_APPLICATION_ID NUMBER 18 Applied to application identifier. Active
APPLIED_TO_ENTITY_CODE VARCHAR2 30 Abbreviated name of the applied to entity. Active
APPLIED_TO_ENTITY_ID NUMBER 18 Identifier of applied to entity identifier. Active
APPLIED_TO_SOURCE_ID_NUM_1 NUMBER 18 Applied to transaction identifier numeric 1. Active
APPLIED_TO_SOURCE_ID_NUM_2 NUMBER 18 Applied to transaction identifier numeric 2. Active
APPLIED_TO_SOURCE_ID_NUM_3 NUMBER 18 Applied to transaction identifier numeric 3. Active
APPLIED_TO_SOURCE_ID_NUM_4 NUMBER 18 Applied to transaction identifier numeric 4. Active
APPLIED_TO_SOURCE_ID_CHAR_1 VARCHAR2 30 Applied to transaction identifier character 1. Active
APPLIED_TO_SOURCE_ID_CHAR_2 VARCHAR2 30 Applied to transaction identifier character 2. Active
APPLIED_TO_SOURCE_ID_CHAR_3 VARCHAR2 30 Applied to transaction identifier character 3. Active
APPLIED_TO_SOURCE_ID_CHAR_4 VARCHAR2 30 Applied to transaction identifier character 4.
APPLIED_TO_DISTRIBUTION_TYPE VARCHAR2 30 Value of the applied to distribution type.
APPLIED_TO_DIST_ID_NUM_1 NUMBER 18 Applied to distribution identifier numeric 1. Active
APPLIED_TO_DIST_ID_NUM_2 NUMBER 18 Applied to distribution identifier numeric 2. Active
APPLIED_TO_DIST_ID_NUM_3 NUMBER 18 Applied to distribution identifier numeric 3. Active
APPLIED_TO_DIST_ID_NUM_4 NUMBER 18 Applied to distribution identifier numeric 4. Active
APPLIED_TO_DIST_ID_NUM_5 NUMBER 18 Applied to distribution identifier numeric 5. Active
APPLIED_TO_DIST_ID_CHAR_1 VARCHAR2 30 Applied to distribution identifier character 1. Active
APPLIED_TO_DIST_ID_CHAR_2 VARCHAR2 30 Applied to distribution identifier character 2. Active
APPLIED_TO_DIST_ID_CHAR_3 VARCHAR2 30 Applied to distribution identifier character 3. Active
APPLIED_TO_DIST_ID_CHAR_4 VARCHAR2 30 Applied to distribution identifier character 4. Active
APPLIED_TO_DIST_ID_CHAR_5 VARCHAR2 30 Applied to distribution identifier character 5. Active
ALLOC_TO_APPLICATION_ID NUMBER 18 Application identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_ENTITY_CODE VARCHAR2 30 Entity code of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_NUM_1 NUMBER 18 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_NUM_2 NUMBER 18 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_NUM_3 NUMBER 18 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_NUM_4 NUMBER 18 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_CHAR_1 VARCHAR2 30 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_CHAR_2 VARCHAR2 30 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_CHAR_3 VARCHAR2 30 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_SOURCE_ID_CHAR_4 VARCHAR2 30 System transaction identifier of the entry to which the transaction is being allocated. Active
ALLOC_TO_DISTRIBUTION_TYPE VARCHAR2 30 Distribution type of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_NUM_1 NUMBER 18 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_NUM_2 NUMBER 18 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_NUM_3 NUMBER 18 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_NUM_4 NUMBER 18 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_NUM_5 NUMBER 18 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_CHAR_1 VARCHAR2 30 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_CHAR_2 VARCHAR2 30 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_CHAR_3 VARCHAR2 30 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_CHAR_4 VARCHAR2 30 Distribution identifier of the entity to which the transaction is being allocated. Active
ALLOC_TO_DIST_ID_CHAR_5 VARCHAR2 30 Distribution identifier of the entity to which the transaction is being allocated. Active
GAIN_OR_LOSS_REF VARCHAR2 30 Contains the source value of the Gain or Loss Reference accounting attribute used to add journal lines in gain or loss amount calculation. Active
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
REF_AE_LINE_NUM NUMBER 18 Reference accounting line number.
DATA_SET_ID NUMBER 18 An identifier assigned by budgetary control when consuming products interact with budgetary control
LEGAL_TAX_REPORTING_STATUS VARCHAR2 15 Status for tax legal reporting
MPA_COMPLETE_FLAG VARCHAR2 1 Indicates whether multiperiod accounting is complete for the distribution. Possible values are; Y, multiperiod accounting is complete, and N, multiperiod accounting is not complete.
PERIOD_NAME VARCHAR2 15 Period that contains the accounting entry.
PARTITION_GROUP_CODE VARCHAR2 15 Partition grouping information, when combined with the period, determines the database partition in which this journal link information will be stored.

Indexes

Index Uniqueness Tablespace Columns Status
XLA_DISTRIBUTION_LINKS_N1 Non Unique FUSION_TS_TX_DATA SOURCE_DISTRIBUTION_TYPE, SOURCE_DISTRIBUTION_ID_NUM_1, NVL("SOURCE_DISTRIBUTION_ID_NUM_2",(-99))
XLA_DISTRIBUTION_LINKS_N2 Non Unique FUSION_TS_TX_DATA UPG_BATCH_ID Active
XLA_DISTRIBUTION_LINKS_N3 Non Unique FUSION_TS_TX_DATA AE_HEADER_ID, AE_LINE_NUM
XLA_DISTRIBUTION_LINKS_U1 Unique FUSION_TS_TX_DATA APPLICATION_ID, REF_AE_HEADER_ID, TEMP_LINE_NUM, AE_HEADER_ID