Archived Subledger Multiperiod Distributions
The Archived Subledger Multiperiod Distributions view object contains the archived subledger multiperiod distributions.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveXlaMpaDistributionExtractPVO
Primary Keys : AeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AccrualPeriodName | The accounting period name of the accrual entry. |
| AeHeaderId | The unique identifier of the accrual subledger journal entry header. |
| AeLineNum | The journal line number of the accrual subledger journal entry. |
| ApplicationId | The unique identifier of the subledger application for which the multiperiod accounting transaction is created. |
| CreatedBy | The user who created the row. |
| CreationDate | The date and time when the row was created. |
| CurrencyCode | The code representing the transaction currency for the distribution. |
| EventId | The unique identifier of the accounting event. |
| FullyProcessedFlag | Indicates whether additional multiperiod journals need to be created in the future. Once the distribution has been fully recognized or reversed, it's updated from N to Y. |
| JobDefinitionName | The name of the job that created or last updated the row. |
| JobDefinitionPackage | The package name of the job that created or last updated the row. |
| LastGlDate | The accounting date of the last multiperiod journal entry with Final status. |
| LastUpdateDate | The date and time when the row was last updated. |
| LastUpdateLogin | The session login associated to the user who last updated the row. |
| LastUpdatedBy | The user who last updated the row. |
| LedgerId | The unique identifier of the ledger. |
| MultiperiodClassCode | The multiperiod class for this distribution. |
| NextGlEffPeriodNum | 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. |
| ObjectVersionNumber | The number of times the multiperiod distribution row has been updated. |
| ProcStatusCode | The code representing the processing status of the last accounting entry for the multiperiod distribution. |
| RecAccountedCr | The credit amount in ledger currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status. |
| RecAccountedDr | The debit amount in ledger currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status. |
| RecEnteredCr | The credit amount in entered currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status. |
| RecEnteredDr | The debit amount in entered currency already recognized for the distribution. This is updated when multiperiod journal entry is created in final status. |
| RequestId | The unique identifier of the job request that created or last updated the row. |
| SourceDistributionIdChar1 | The unique identifier of the transaction source distribution in character data type. |
| SourceDistributionIdChar2 | The unique identifier of the transaction source distribution in character data type. |
| SourceDistributionIdChar3 | The unique identifier of the transaction source distribution in character data type. |
| SourceDistributionIdChar4 | The unique identifier of the transaction source distribution in character data type. |
| SourceDistributionIdChar5 | The unique identifier of the transaction source distribution in character data type. |
| SourceDistributionIdNum1 | The unique identifier of the transaction source distribution in numeric data type. |
| SourceDistributionIdNum2 | The unique identifier of the transaction source distribution in numeric data type. |
| SourceDistributionIdNum3 | The unique identifier of the transaction source distribution in numeric data type. |
| SourceDistributionIdNum4 | The unique identifier of the transaction source distribution in numeric data type. |
| SourceDistributionIdNum5 | The unique identifier of the transaction source distribution in numeric data type. |
| SourceDistributionType | The classification of transaction source distribution. |
| StatusCode | The code representing the status of the multiperiod distribution recognition or reversal. Valid values are U, P, R, and F. The value U indicates that final status journal hasn't been created yet, the value P indicates that final status journal has been created but the amount isn't fully recognized yet, the value R indicates that the amount is reversed, and the value F indicates that the entire amount has been fully recognized. |
| TempLineNum | The intermediary line number for the subledger journal of the accrual entry. |
| UnroundedAccountedCr | The total unrounded credit amount in ledger currency to be recognized. |
| UnroundedAccountedDr | The total unrounded debit amount in ledger currency to be recognized. |
| UnroundedEnteredCr | The total unrounded credit amount in transaction currency to be recognized. |
| UnroundedEnteredDr | The total unrounded debit amount in transaction currency to be recognized. |