MGCLatticeCustomerSettlementEntity

The MGCLatticeCustomerSettlementEntity exposes customer (accounts receivable) sub-ledger settlement history from CustSettlement: which transaction (TransRecId) was settled against which offset transaction (OffsetRecId / OffsetVoucher), on what date, and for what amount in accounting and transaction currency. Read-only and DMF/OData enabled with a lean, explicitly projected field set for high-volume receivables reconciliation and BYOD scenarios. Keyed on the CustSettlement surrogate RecId (export-oriented). It is the accounts receivable half of the settlement-history entity pair.

• Public collection name: LatticeCustomerSettlements
• Primary key: SysRecId

Fields

Name	Type	Mandatory	Description
CustomerAccount	CustAccount	No
TransRecId	CustSettleParentRecID	No
TransactionType	LedgerTransType	No
TransactionDate	TransDate	No
DueDate	DueDate	No
ClosedDate	TransDate	No
OffsetRecId	CustTransRefRecId	No
OffsetVoucher	Voucher	No
OffsetAccountNum	CustAccount	No
OffsetLegalEntityId	CompanyId	No
SettlementVoucher	Voucher	No
SettledAccountingCurrencyAmount	AmountMST	No
SettledTransactionCurrencyAmount	AmountCur	No
CanBeReversed	NoYesId	No
TransactionLegalEntityId	CompanyId	No
SysRecId	RefRecId	No

Mappings

Entity field	Data source	Field
CustomerAccount	CustSettlement	AccountNum
TransRecId	CustSettlement	TransRecId
TransactionType	CustSettlement	TransType
TransactionDate	CustSettlement	TransDate
DueDate	CustSettlement	DueDate
ClosedDate	CustSettlement	ClosedDate
OffsetRecId	CustSettlement	OffsetRecid
OffsetVoucher	CustSettlement	OffsetTransVoucher
OffsetAccountNum	CustSettlement	OffsetAccountNum
OffsetLegalEntityId	CustSettlement	OffsetCompany
SettlementVoucher	CustSettlement	SettlementVoucher
SettledAccountingCurrencyAmount	CustSettlement	SettleAmountMST
SettledTransactionCurrencyAmount	CustSettlement	SettleAmountCur
CanBeReversed	CustSettlement	CanBeReversed
TransactionLegalEntityId	CustSettlement	TransCompany
SysRecId	CustSettlement	RecId