Skip to main content

MGCLatticeFixedAssetTransactionEntity

The MGCLatticeFixedAssetTransactionEntity exposes per-book fixed asset transactions from AssetTrans (acquisition, depreciation, disposal, revaluation, and so on) with the posting layer resolved from the value model (AssetBookTable). Read-only, minimal projection for high-volume ledger feeds.

  • Public collection name: LatticeFixedAssetTransactions
  • Primary key: SysRecId

Fields​

NameTypeMandatoryDescription
AssetIdAssetIdNo
BookIdAssetBookIdNo
AssetTransTypeAssetTransTypeNo
TransactionDateAssetTransDateNo
VoucherVoucherNo
PostingLayerCurrentOperationsTaxNo
TransactionTextLedgerJournalTransTxtNo
AccountingCurrencyAmountAssetAmountNo
AmountCurrencyAmountCurNo
CurrencyCodeCurrencyCodeNo
QuantityAssetConsumptionNo
SysRecIdRefRecIdNo

Mappings​

Entity fieldData sourceField
AssetIdAssetTransAssetId
BookIdAssetTransBookId
AssetTransTypeAssetTransTransType
TransactionDateAssetTransTransDate
VoucherAssetTransVoucher
PostingLayerAssetBookTableCurrentOperationsTax
TransactionTextAssetTransTxt
AccountingCurrencyAmountAssetTransAmountMST
AmountCurrencyAssetTransAmountCur
CurrencyCodeAssetTransCurrencyCode
QuantityAssetTransConsumptionQty
SysRecIdAssetTransRecId