MGCLatticeTrialBalanceEntity
The MGCLatticeTrialBalanceEntity exposes TRUE trial-balance figures (opening / debit / credit / closing) from the standard pre-materialized snapshot tables LedgerTrialBalanceSnapshotData (root) joined to LedgerTrialBalanceSnapshotHeader, at focus-dimension + fiscal-period grain. Read-only and DMF-enabled (staging MGCLatticeTrialBalanceStaging) so the data can be staged for BYOD / batch export. IMPORTANT: this entity returns rows only AFTER the standard Trial balance snapshot batch has been generated for the requested ledger / focus hierarchy / fiscal year / posting layer scope. It reads materialized snapshot rows, NOT live ledger aggregation.
- Public collection name:
LatticeTrialBalances - Primary key:
SysRecId
Fields
| Name | Type | Mandatory | Description |
|---|---|---|---|
SysRecId | RefRecId | No | |
SnapshotHeaderRecId | LedgerTrialBalanceSnapshotHeaderRecId | No | |
AccountingDate | TransDate | No | |
FiscalPeriodRecId | FiscalCalendarPeriodRecId | No | |
PostingLayer | CurrentOperationsTax | No | |
PeriodTransactionType | FiscalPeriodType | No | |
LedgerDimensionDisplayValue | DimensionDisplayValue | No | |
DimensionSortValue | DimensionSortValue | No | |
MainAccountCategory | AccountCategory | No | |
OpeningBalance | AmountMSTLong | No | |
DebitAmount | AmountMSTLong | No | |
CreditAmount | AmountMSTLong | No | |
ClosingBalance | AmountMSTLong | No | |
NetChange | AmountMSTLong | No | |
ClosingAdjustments | AmountMSTLong | No | |
DimensionDisplayValue1 | DimensionValue | No | |
DimensionDisplayValue2 | DimensionValue | No | |
DimensionDisplayValue3 | DimensionValue | No | |
DimensionDisplayValue4 | DimensionValue | No | |
DimensionDisplayValue5 | DimensionValue | No | |
DimensionDisplayValue6 | DimensionValue | No | |
DimensionDisplayValue7 | DimensionValue | No | |
DimensionDisplayValue8 | DimensionValue | No | |
DimensionDisplayValue9 | DimensionValue | No | |
DimensionDisplayValue10 | DimensionValue | No | |
DimensionDisplayValue11 | DimensionValue | No | |
LedgerRecId | LedgerRecId | No | |
FiscalCalendarYearRecId | FiscalCalendarYearRecId | No | |
DimensionHierarchyId | DimensionHierarchyId | No | |
ExternalTrackingId | SysGuid | No | |
SnapshotStatus | LedgerTrialBalanceSnapshotStatus | No | |
LedgerName | LedgerName | No | |
FiscalYearName | FiscalYearName | No | |
FiscalPeriodName | PeriodName | No | |
FiscalPeriodType | FiscalPeriodType | No | |
FiscalPeriodStartDate | FiscalPeriodStart | No | |
FiscalPeriodEndDate | FiscalPeriodEnd | No |
Mappings
| Entity field | Data source | Field |
|---|---|---|
SysRecId | LedgerTrialBalanceSnapshotData | RecId |
SnapshotHeaderRecId | LedgerTrialBalanceSnapshotData | SnapshotHeader |
AccountingDate | LedgerTrialBalanceSnapshotData | AccountingDate |
FiscalPeriodRecId | LedgerTrialBalanceSnapshotData | FiscalCalendarPeriodRecId |
PostingLayer | LedgerTrialBalanceSnapshotData | PostingLayer |
PeriodTransactionType | LedgerTrialBalanceSnapshotData | TransactionType |
LedgerDimensionDisplayValue | LedgerTrialBalanceSnapshotData | PrimaryFocusDescription |
DimensionSortValue | LedgerTrialBalanceSnapshotData | PrimaryFocus |
MainAccountCategory | LedgerTrialBalanceSnapshotData | MainAccountCategory |
OpeningBalance | LedgerTrialBalanceSnapshotData | OpeningBalance |
DebitAmount | LedgerTrialBalanceSnapshotData | AmountDebit |
CreditAmount | LedgerTrialBalanceSnapshotData | AmountCredit |
ClosingBalance | LedgerTrialBalanceSnapshotData | EndingBalance |
NetChange | LedgerTrialBalanceSnapshotData | NetChange |
ClosingAdjustments | LedgerTrialBalanceSnapshotData | ClosingAdjustments |
DimensionDisplayValue1 | LedgerTrialBalanceSnapshotData | DimValue1 |
DimensionDisplayValue2 | LedgerTrialBalanceSnapshotData | DimValue2 |
DimensionDisplayValue3 | LedgerTrialBalanceSnapshotData | DimValue3 |
DimensionDisplayValue4 | LedgerTrialBalanceSnapshotData | DimValue4 |
DimensionDisplayValue5 | LedgerTrialBalanceSnapshotData | DimValue5 |
DimensionDisplayValue6 | LedgerTrialBalanceSnapshotData | DimValue6 |
DimensionDisplayValue7 | LedgerTrialBalanceSnapshotData | DimValue7 |
DimensionDisplayValue8 | LedgerTrialBalanceSnapshotData | DimValue8 |
DimensionDisplayValue9 | LedgerTrialBalanceSnapshotData | DimValue9 |
DimensionDisplayValue10 | LedgerTrialBalanceSnapshotData | DimValue10 |
DimensionDisplayValue11 | LedgerTrialBalanceSnapshotData | DimValue11 |
LedgerRecId | LedgerTrialBalanceSnapshotHeader | LedgerRecId |
FiscalCalendarYearRecId | LedgerTrialBalanceSnapshotHeader | FiscalCalendarYearRecId |
DimensionHierarchyId | LedgerTrialBalanceSnapshotHeader | DimensionHierarchyId |
ExternalTrackingId | LedgerTrialBalanceSnapshotHeader | ExternalTrackingId |
SnapshotStatus | LedgerTrialBalanceSnapshotHeader | Status |
LedgerName | Ledger | Name |
FiscalYearName | FiscalCalendarYear | Name |
FiscalPeriodName | FiscalCalendarPeriod | Name |
FiscalPeriodType | FiscalCalendarPeriod | Type |
FiscalPeriodStartDate | FiscalCalendarPeriod | StartDate |
FiscalPeriodEndDate | FiscalCalendarPeriod | EndDate |