Archived Journal Lines Reconciliation
The Archived Journal Lines Reconciliation view object contains reconciled transactions for those accounts where Clearing Accounts Reconciliation is enabled.
Data Store Key : FscmTopModelAM.FinExtractAM.FinArchiveBiccExtractAM.ArchiveGlLineReconExtractPVO
Primary Keys : JeHeaderId
Initial Extract Date : CreationDate
Incremental Extract Date :
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| CreatedBy | The user who created the journal line reconciliation. |
| CreationDate | The date and time when the journal line reconciliation was created. |
| JeHeaderId | The unique identifier of the journal entry header. This attribute is a part of the composite key of the Journal Line view object. |
| JeLineNum | The identifier of the journal entry line. This is a foreign key to the Journal Line view object. |
| JgzzReconDate | The date when the related journal lines were reconciled. The underlying journal lines for a distinct reconciliation identifier shares the same reconciliation date. |
| JgzzReconId | A unique number automatically generated by the application after the related clearing account journal lines have been successfully reconciled. |
| JgzzReconRef | An unique reference value entered or populated in related clearing account journal lines. |
| JgzzReconStatus | The reconciliation status associated with the clearing accounts journal lines. Possible values are Reconciled and Unreconciled. |
| LastUpdateDate | The date when the journal line reconciliation row was last updated. |
| LastUpdateLogin | The session login associated with the user who last updated the journal line reconciliation. |
| LastUpdatedBy | The user who last updated the journal line reconciliation row. |
| LedgerId | The unique identifier of the ledger of the journal line reconciliation. This is a foreign key of the Ledgers view object. |
| ObjectVersionNumber | The number of times the journal entry line reconciliation row has been updated. |
| PartitionGroupCode | The code that identifies the partition group. The partition grouping information, when combined with the period, determines the database partition where the journal line will be stored. |
| PeriodName | The name of the accounting period. |
| ReconRuleId | The unique identifier of the reconciliation rule that's used to reconcile the journal line. |