Skip to main content

MGCLatticeVendorSummaryUpdateParametersEntity

The MGCLatticeVendorSummaryUpdateParametersEntity exposes the vendor / accounts-payable Summary update (auto-summary consolidation) settings held in PurchJournalAutoSummary for data management import/export and OData. Each row records, per vendor account (or per purchase order) and per document type, whether the document is summary-updated. Importing updates the existing row that matches the table's natural key (account + module type + purchase order id + document type) so a mass update refreshes settings in place rather than creating duplicates.

  • Public collection name: LatticeVendorSummaryUpdateParameters
  • Primary key: VendorAccountNumber, ModuleType, PurchaseOrderNumber, DocumentType

Fields​

NameTypeMandatoryDescription
VendorAccountNumberVendAccountNo
ModuleTypeModuleVendPurchNo
PurchaseOrderNumberPurchIdBaseNo
DocumentTypeDocumentStatusNo
SummaryUpdatePurchAutoSummaryNo

Mappings​

Entity fieldData sourceField
VendorAccountNumberPurchJournalAutoSummaryVendAccount
ModuleTypePurchJournalAutoSummaryModuleType
PurchaseOrderNumberPurchJournalAutoSummaryPurchId
DocumentTypePurchJournalAutoSummaryDocumentStatus
SummaryUpdatePurchJournalAutoSummaryAutoSummary