MGCLatticeGeneralLedgerEntryEntity
The MGCLatticeGeneralLedgerEntryEntity exposes posted general ledger entries from GeneralJournalAccountEntry (posted voucher line) joined to GeneralJournalEntry (voucher / accounting date / journal number), the MainAccount (main account number) and DimensionAttributeValueCombination (ledger dimension display value). It is a public, read-only, lean projection intended for OData / BYOD reporting and data-management export consumers that cannot use the non-public standard GeneralJournalAccountEntryEntity.
- Public collection name:
LatticeGeneralLedgerEntries
- Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|
SubledgerVoucher | Voucher | No | |
AccountingDate | TransDate | No | |
JournalNumber | GeneralJournalEntryJournalNumber | No | |
LegalEntityId | SelectableDataArea | No | The legal entity that owns the ledger the entry was posted to. |
PostingType | LedgerPostingType | No | |
MainAccountId | MainAccountNum | No | |
LedgerDimensionDisplayValue | DimensionDisplayValue | No | |
Text | TransactionTextLarge | No | |
TransactionCurrencyCode | CurrencyCode | No | |
TransactionCurrencyAmount | AmountCur | No | |
AccountingCurrencyAmount | AmountMSTDebCred | No | |
ReportingCurrencyAmount | AmountMSTSecondary | No | |
SysRecId | RefRecId | No | |
Mappings
| Entity field | Data source | Field |
|---|
SubledgerVoucher | GeneralJournalEntry | SubledgerVoucher |
AccountingDate | GeneralJournalEntry | AccountingDate |
JournalNumber | GeneralJournalEntry | JournalNumber |
LegalEntityId | CompanyInfo | DataArea |
PostingType | GeneralJournalAccountEntry | PostingType |
MainAccountId | MainAccount | MainAccountId |
LedgerDimensionDisplayValue | DimensionAttributeValueCombination | DisplayValue |
Text | GeneralJournalAccountEntry | Text |
TransactionCurrencyCode | GeneralJournalAccountEntry | TransactionCurrencyCode |
TransactionCurrencyAmount | GeneralJournalAccountEntry | TransactionCurrencyAmount |
AccountingCurrencyAmount | GeneralJournalAccountEntry | AccountingCurrencyAmount |
ReportingCurrencyAmount | GeneralJournalAccountEntry | ReportingCurrencyAmount |
SysRecId | GeneralJournalAccountEntry | RecId |