Subledger Journal Distribution Links
The subledger journal distribution links view object contains the relationship between transactions and subledger journal entry lines. Each row of this object stores the associated subledger journal entry header identifier, line number, account information, and related debits or credits. The combination of JournalEntryDistributionApplicationId, JournalEntryDistributionRefAeHeaderId, JournalEntryDistributionTempLineNum, and JournalEntryDistributionAeHeaderId forms the unique identifier of the Subledger Journal Distribution Links view object.
Data Store Key : FscmTopModelAM.FinExtractAM.XlaBiccExtractAM.SubledgerJournalDistributionExtractPVO
Primary Keys : JournalEntryDistributionRefAeHeaderId, JournalEntryDistributionApplicationId, JournalEntryDistributionTempLineNum, JournalEntryDistributionAeHeaderId
Initial Extract Date : JournalEntryDistributionCreationDate
Incremental Extract Date : JournalEntryDistributionLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
JournalEntryDistributionAccountingLineCode | The short name of a rule to convert transactional data into a journal entry line. |
JournalEntryDistributionAccountingLineTypeCode | Indicates whether the journal line rule is seeded. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
JournalEntryDistributionAeHeaderId | The unique identifier of the subledger journal entry header. This attribute is a part of the composite key of the Subledger Journal Distribution Links view object. This attribute a foreign key of the Subledger Journal Entry Headers view object. |
JournalEntryDistributionAeLineNum | The identifier of the subledger journal entry line. This attribute is a part of the composite key of the Subledger Journal Distribution Links view object. This is a foreign key of the Subledger Journal Entry Lines view object. |
JournalEntryDistributionAllocToApplicationId | The application identifier of the entry to which the transaction is being allocated. This is a primary key of the Applications view object. |
JournalEntryDistributionAllocToDistIdChar1 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdChar2 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdChar3 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdChar4 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdChar5 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdNum1 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdNum2 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdNum3 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdNum4 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistIdNum5 | The distribution identifier of the entity to which the transaction is being allocated. |
JournalEntryDistributionAllocToDistributionType | The type of distribution of the entity to which the transaction is being allocated. The value is determined by the respective subledger. |
JournalEntryDistributionAllocToEntityCode | The entity code of the entry to which the transaction is being allocated. Entity codes are defined in xla_entity_types_b. |
JournalEntryDistributionAllocToSourceIdChar1 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdChar2 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdChar3 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdChar4 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdNum1 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdNum2 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdNum3 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionAllocToSourceIdNum4 | The system transaction identifier of the entry to which the transaction is being allocated. |
JournalEntryDistributionApplicationId | The identifier of a functional area within a software suite of products. This attribute is a part of the composite key of the Subledger Journal Distribution Links view object. This is a foreign key of the Applications view object. |
JournalEntryDistributionAppliedToApplicationId | The application identifier of the entry to which the transaction is applied using the business flow feature. This is a foreign key of the Applications view object. |
JournalEntryDistributionAppliedToDistIdChar1 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdChar2 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdChar3 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdChar4 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdChar5 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdNum1 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdNum2 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdNum3 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdNum4 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistIdNum5 | The distribution identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToDistributionType | The type of distribution of the entry to which the transaction is applied using the business flow feature. The value is determined by the respective subledger. |
JournalEntryDistributionAppliedToEntityCode | The entity code of the entry to which the transaction is applied using the business flow feature. Entity codes are defined in xla_entity_types_b. |
JournalEntryDistributionAppliedToEntityId | The entity identifier of the entry to which the transaction is applied using the business flow feature. This is a primary key of the events view object. |
JournalEntryDistributionAppliedToSourceIdChar1 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdChar2 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdChar3 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdChar4 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdNum1 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdNum2 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdNum3 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionAppliedToSourceIdNum4 | The system transaction identifier of the entry to which the transaction is applied using the business flow feature. |
JournalEntryDistributionCalculateAcctdAmtsFlag | Indicates whether the accounted amounts are calculated by Subledger Accounting or passed through transaction objects. It has two values Y and N. Y indicates that accounted amounts are calculated by the accounting program. N indicates that accounted amounts were passed through the extract. |
JournalEntryDistributionCalculateGLAmtsFlag | Indicates whether the gain or loss amounts are calculated by the accounting engine. It has two values Y and N. 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. |
JournalEntryDistributionCreatedBy | The user who created the subledger journal distribution link. |
JournalEntryDistributionCreationDate | The date and time when the subledger journal distribution link was created. |
JournalEntryDistributionDocRoundingAcctdAmt | The rounding amount in the ledger currency calculated by the accounting engine for the document. |
JournalEntryDistributionDocRoundingEnteredAmt | The rounding amount in the entered currency calculated by the accounting engine for the document. |
JournalEntryDistributionDocumentRoundingLevel | The document identifier for which the accounting engine performs the rounding. The Create Accounting process uses JournalEntryDistributionDocumentRoundingLevel and JournalEntryDistributionRoundingClassCode to group lines together to perform the rounding. |
JournalEntryDistributionEventClassCode | The unique abbreviated name assigned to an event class and used for reporting or in reference to an option. |
JournalEntryDistributionEventId | Identifier of the categorization of accounting events that's unique within an application and event class. This a foreign key of the Events view object. |
JournalEntryDistributionEventTypeCode | The unique abbreviated name assigned to an event type and used for reporting or in reference to an option. A list of accepted values are defined in the xla_entity_types_b table. |
JournalEntryDistributionGainOrLossRef | The source value of the Gain or Loss Reference accounting attribute. It's used to add journal lines in the gain or loss amount calculation. |
JournalEntryDistributionLastUpdateDate | The date when the subledger journal distribution link row was last updated. |
JournalEntryDistributionLastUpdateLogin | The session login associated with the user who last updated the subledger journal distribution link. |
JournalEntryDistributionLastUpdatedBy | The user who last updated the subledger journal distribution link. |
JournalEntryDistributionLineDefinitionCode | The short name of the journal entry rule set that generates accounting for this distribution. |
JournalEntryDistributionLineDefinitionOwnerCode | Indicates whether the seeded journal entry rule set is used to generate accounting for this distribution. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
JournalEntryDistributionMergeDuplicateCode | Indicates how duplicate subledger journal lines are merged. Possible values are A,W, and N. A indicates merge all lines. W indicates 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 indicates don't merge matching lines. |
JournalEntryDistributionObjectVersionNumber | The number of times the subledger journal distribution link row has been updated. |
JournalEntryDistributionRefAeHeaderId | The unique identifier of the reversed subledger journal entry header. |
JournalEntryDistributionRefAeLineNum | The temporary line number reference of the reversed journal entry line. |
JournalEntryDistributionRefEventId | Indicates the event identifier in a reversal row from the actual reversed subledger journal entry line. |
JournalEntryDistributionRefTempLineNum | The temporary line number reference. |
JournalEntryDistributionRoundingClassCode | Indicates the accounting class associated with the journal line. It's used as the grouping criteria for rounding. The Create Accounting Process uses JournalEntryDistributionRoundingClassCode and JournalEntryDistributionDocumentRoundingLevel to group lines together to perform the rounding. A list of accepted values is defined in the lookup type XLA_ACCOUNTING_CLASS. |
JournalEntryDistributionSourceDistributionIdChar1 | The transaction source distribution identifier in the text format. |
JournalEntryDistributionSourceDistributionIdChar2 | The transaction source distribution identifier in the text format. |
JournalEntryDistributionSourceDistributionIdChar3 | The transaction source distribution identifier in the text format. |
JournalEntryDistributionSourceDistributionIdChar4 | The transaction source distribution identifier in the text format. |
JournalEntryDistributionSourceDistributionIdChar5 | The transaction source distribution identifier in the text format. |
JournalEntryDistributionSourceDistributionIdNum1 | The transaction source distribution identifier in the numeric format. |
JournalEntryDistributionSourceDistributionIdNum2 | The transaction source distribution identifier in the numeric format. |
JournalEntryDistributionSourceDistributionIdNum3 | The transaction source distribution identifier in the numeric format. |
JournalEntryDistributionSourceDistributionIdNum4 | The transaction source distribution identifier in the numeric format. |
JournalEntryDistributionSourceDistributionIdNum5 | The transaction source distribution identifier in the numeric format. |
JournalEntryDistributionSourceDistributionType | The classification of transaction source distribution. The value is determined by the respective subledger. |
JournalEntryDistributionStatisticalAmount | The amount entered in a journal that's based on the unit of measure. |
JournalEntryDistributionTaxLineRefId | The identifier of detail tax line reference. |
JournalEntryDistributionTaxRecNrecDistRefId | Indicates the detail tax distribution reference. |
JournalEntryDistributionTaxSummaryLineRefId | The identifier of summary tax line reference. |
JournalEntryDistributionTempLineNum | The temporary line number generated by the accounting engine when entries are in the most detailed form. |
JournalEntryDistributionUnroundedAccountedCr | The unrounded journal line credit amount in the ledger currency. |
JournalEntryDistributionUnroundedAccountedDr | The unrounded journal line debit amount in the ledger currency. |
JournalEntryDistributionUnroundedEnteredCr | The unrounded journal line credit amount in the entered currency. |
JournalEntryDistributionUnroundedEnteredDr | The unrounded journal line debit amount in the entered currency. |
JournalEntryDistributionUpgBatchId | The unique identifier of the upgrade batch. |