Journal Lines Reconciliation
The journal lines reconciliation view object contains reconciled transactions for those accounts where Clearing Accounts Reconciliation is enabled.
Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.JournalReconLineExtractPVO
Primary Keys : GlJeLinesReconJeHeaderId, GlJeLinesReconJeLineNum
Initial Extract Date : GlJeLinesReconCreationDate
Incremental Extract Date : GlJeLinesReconLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| GlJeLinesReconCreatedBy | The user who created the journal line reconciliation. |
| GlJeLinesReconCreationDate | The date and time when the journal line reconciliation was created. |
| GlJeLinesReconJeHeaderId | The unique identifier of the journal entry header. This attribute is a part of the composite key of the Journal Line view object. |
| GlJeLinesReconJeLineNum | The identifier of the journal entry line. This is a foreign key to the Journal Line view object. |
| GlJeLinesReconJgzzReconDate | The date when the related journal lines were reconciled. The underlying journal lines for a distinct reconciliation ID share the same reconciliation date. |
| GlJeLinesReconJgzzReconId | A unique number automatically generated by the application after the related clearing account journal lines have been successfully reconciled. |
| GlJeLinesReconJgzzReconRef | An identifiable unique reference value entered or populated in related clearing account journal lines. |
| GlJeLinesReconJgzzReconStatus | The reconciliation status associated with the clearing accounts journal lines. Possible values are Reconciled and Unreconciled. |
| GlJeLinesReconLastUpdateDate | The date when the journal line reconciliation row was last updated. |
| GlJeLinesReconLastUpdateLogin | The session login associated with the user who last updated the journal line reconciliation. |
| GlJeLinesReconLastUpdatedBy | The user who last updated the journal line reconciliation row. |
| GlJeLinesReconLedgerId | The unique identifier of the ledger of the journal line reconciliation. This is a foreign key of the Ledgers view object. |
| GlJeLinesReconObjectVersionNumber | The number of times the journal entry line reconciliation row has been updated. |
| GlJeLinesReconReconRuleId | The reconciliation rule identifier that's used to reconcile the journal line. |