MGCLatticeVendorSettlementEntity

The MGCLatticeVendorSettlementEntity exposes vendor (accounts payable) sub-ledger settlement history from VendSettlement: 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 payables reconciliation and BYOD scenarios. Keyed on the VendSettlement surrogate RecId (export-oriented). It is the accounts payable counterpart of MGCLatticeCustomerSettlementEntity.

• Public collection name: LatticeVendorSettlements
• Primary key: SysRecId

Fields

Name	Type	Mandatory	Description
VendorAccountNumber	VendAccount	No
TransRecId	VendSettleParentRecId	No
TransactionType	LedgerTransType	No
TransactionDate	TransDate	No
DueDate	DueDate	No
ClosedDate	TransDate	No
OffsetRecId	VendTransRefRecId	No
OffsetVoucher	Voucher	No
OffsetAccountNum	VendAccount	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
VendorAccountNumber	VendSettlement	AccountNum
TransRecId	VendSettlement	TransRecId
TransactionType	VendSettlement	TransType
TransactionDate	VendSettlement	TransDate
DueDate	VendSettlement	DueDate
ClosedDate	VendSettlement	ClosedDate
OffsetRecId	VendSettlement	OffsetRecid
OffsetVoucher	VendSettlement	OffsetTransVoucher
OffsetAccountNum	VendSettlement	OffsetAccountNum
OffsetLegalEntityId	VendSettlement	OffsetCompany
SettlementVoucher	VendSettlement	SettlementVoucher
SettledAccountingCurrencyAmount	VendSettlement	SettleAmountMST
SettledTransactionCurrencyAmount	VendSettlement	SettleAmountCur
CanBeReversed	VendSettlement	CanBeReversed
TransactionLegalEntityId	VendSettlement	TransCompany
SysRecId	VendSettlement	RecId