Archived Subledger Journal Distribution Links
The Archived Subledger Journal Distribution Links view object contains the archived subledger journal distribution links.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaDistributionLinkExtractPVO
Primary Keys : ApplicationId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccountingLineCode | The code representing the rule to convert transactional data into a journal entry line. |
| AccountingLineTypeCode | Indicates whether the journal line rule is seeded. A list of accepted values is defined in the lookup type XLA_OWNER_TYPE. |
| AeHeaderId | The unique identifier of the subledger journal entry header. |
| AeLineNum | The unique identifier of the subledger journal entry line. |
| AllocToApplicationId | The unique identifier of the application to which the transaction is allocated. |
| AllocToDistIdChar1 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdChar2 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdChar3 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdChar4 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdChar5 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdNum1 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdNum2 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdNum3 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdNum4 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistIdNum5 | The unique identifier of the entity distribution to which the transaction is allocated. |
| AllocToDistributionType | The type of entity distribution to which the transaction is allocated. The value is determined by the respective subledger. |
| AllocToEntityCode | The entity code of the entry to which the transaction is allocated. Entity codes are defined in XLA_ENTITY_TYPES_B. |
| AllocToSourceIdChar1 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdChar2 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdChar3 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdChar4 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdNum1 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdNum2 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdNum3 | The system transaction identifier of the entry to which the transaction is allocated. |
| AllocToSourceIdNum4 | The system transaction identifier of the entry to which the transaction is allocated. |
| ApplicationId | The unique identifier of the functional area within the software suite of the product. |
| AppliedToApplicationId | The unique identifier of the application to which the transaction is applied using the business flow feature. |
| AppliedToDistIdChar1 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdChar2 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdChar3 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdChar4 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdChar5 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdNum1 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdNum2 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdNum3 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdNum4 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistIdNum5 | The unique identifier of the distribution to which the transaction is applied using the business flow feature. |
| AppliedToDistributionType | The type of distribution to which the transaction is applied using the business flow feature. The value is determined by the respective subledger. |
| AppliedToEntityCode | 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. |
| AppliedToEntityId | The unique identifier of the entity to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdChar1 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdChar2 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdChar3 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdChar4 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdNum1 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdNum2 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdNum3 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| AppliedToSourceIdNum4 | The unique identifier of the system transaction to which the transaction is applied using the business flow feature. |
| CalculateAcctdAmtsFlag | Indicates whether the accounted amounts are calculated by Subledger Accounting or passed through transaction objects. Valid values are values Y and N. If Y, the accounted amounts are calculated by the accounting program. If N, the accounted amounts were passed through the extract. |
| CalculateGLAmtsFlag | Indicates whether the gain or loss amounts are calculated by the accounting engine. Valid values Y and N. If Y, the gain or loss amounts are calculated by the accounting program. If N, the gain or loss amounts were passed through the extract. |
| CreatedBy | The user who created the subledger journal distribution link. |
| CreationDate | The date and time when the subledger journal distribution link was created. |
| DocRoundingAcctdAmt | The rounding amount in the ledger currency calculated by the accounting engine for the document. |
| DocRoundingEnteredAmt | The rounding amount in the entered currency calculated by the accounting engine for the document. |
| DocumentRoundingLevel | 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. |
| EventClassCode | The code that identifies an event class and used for reporting or as a reference to an option. |
| EventId | The unique identifier of accounting events that are unique within an application and event class. |
| EventTypeCode | The code that identifies an event type and used for reporting or as a reference to an option. A list of accepted values is defined in the XLA_ENTITY_TYPES_B table. |
| GainOrLossRef | The source value of the gain or loss reference accounting attribute used to add journal lines in the gain or loss amount calculation. |
| LastUpdateDate | The date when the subledger journal distribution link row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the subledger journal distribution link. |
| LastUpdatedBy | The user who last updated the subledger journal distribution link. |
| LegalTaxReportingStatus | The status used for legal tax reporting. |
| LineDefinitionCode | The short name of the journal entry rule set that generates accounting for this distribution. |
| LineDefinitionOwnerCode | 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. |
| MergeDuplicateCode | Indicates how duplicate subledger journal lines are merged. Valid values are A,W, and N. If A, it merges all lines. If 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. If N, matching lines aren't merged. |
| MpaCompleteFlag | Indicates whether multipored accounting is complete for the distribution. Valid values are Y and N. If Y, the multipored accounting is complete. If N, the multipored accounting is'nt complete. |
| ObjectVersionNumber | The number of times the subledger journal distribution link row has been updated. |
| RefAeHeaderId | The unique identifier of the reversed subledger journal entry header. |
| RefAeLineNum | The temporary line number reference of the reversed journal entry line. |
| RefEventId | The unique identifier of an event in a reversal row from the actual reversed subledger journal entry line. |
| RefTempLineNum | The temporary line number reference. |
| RoundingClassCode | The code representing the accounting class associated with the journal line 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. |
| SourceDistributionIdChar1 | The transaction source distribution identifier in the text format. |
| SourceDistributionIdChar2 | The transaction source distribution identifier in the text format. |
| SourceDistributionIdChar3 | The transaction source distribution identifier in the text format. |
| SourceDistributionIdChar4 | The transaction source distribution identifier in the text format. |
| SourceDistributionIdChar5 | The transaction source distribution identifier in the text format. |
| SourceDistributionIdNum1 | The transaction source distribution identifier in the numeric format. |
| SourceDistributionIdNum2 | The transaction source distribution identifier in the numeric format. |
| SourceDistributionIdNum3 | The transaction source distribution identifier in the numeric format. |
| SourceDistributionIdNum4 | The transaction source distribution identifier in the numeric format. |
| SourceDistributionIdNum5 | The transaction source distribution identifier in the numeric format. |
| SourceDistributionType | The classification of the transaction source distribution. The value is determined by the respective subledger. |
| StatisticalAmount | The amount entered in a journal that's based on the unit of measure. |
| TaxLineRefId | The unique identifier of the detail tax line reference. |
| TaxRecNrecDistRefId | The unique identifier of the detail tax distribution reference. |
| TaxSummaryLineRefId | The unique identifier of the summary tax line reference. |
| TempLineNum | The temporary line number generated by the accounting engine when entries are in the most detailed form. |
| UnroundedAccountedCr | The unrounded journal line credit amount in the ledger currency. |
| UnroundedAccountedDr | The unrounded journal line debit amount in the ledger currency. |
| UnroundedEnteredCr | The unrounded journal line credit amount in the entered currency. |
| UnroundedEnteredDr | The unrounded journal line debit amount in the entered currency. |