Skip to main content

MGCLatticeOpportunityEntity

The MGCLatticeOpportunityEntity exposes Sales and marketing opportunities (smmOpportunityTable) for data management import/export and OData. It is a lean, single-table writable projection keyed by the opportunity number (OpportunityId). Writing through the entity runs the standard table business logic (number-sequence assignment, prospect business-relation creation, CRM transaction log and cross-company sharing). The party is named by its party number (PartyNumber, mandatory) and the owner by personnel number; both are resolved to the record ids the table stores. Boundary: this entity serves F&O-native opportunity records only. Dual-write / Dataverse synchronization of opportunities is out of scope and is not implemented here.

  • Public collection name: LatticeOpportunities
  • Primary key: OpportunityId

Fields​

NameTypeMandatoryDescription
OpportunityIdsmmOpportunityIdNo
SubjectsmmOpportunitySubjectNo
PartyNumberDirPartyNumberYes
StatussmmOpportunityStatusNo
SalesProcessNamesmmOpportunitySalesProcessNo
ProbabilityIdsmmQuotationProbabilityIdNo
EstimatedRevenuesmmOpportunityEstimatedRevenueNo
OwnerPersonnelNumberHcmPersonnelNumberIdNo
OpenedDatesmmOpportunityOpenedDateNo
PrognosisIdsmmQuotationPrognosisIdNo
SalesUnitIdsmmSalesUnitIdNo
ClosedDatesmmOpportunityClosedDateNo

Mappings​

Entity fieldData sourceField
OpportunityIdsmmOpportunityTableOpportunityId
SubjectsmmOpportunityTableSubject
PartyNumberDirPartyTablePartyNumber
StatussmmOpportunityTableStatus
SalesProcessNamesmmOpportunityTableProcessName
ProbabilityIdsmmOpportunityTableProbabilityId
EstimatedRevenuesmmOpportunityTableEstimatedRevenue
OwnerPersonnelNumberHcmWorkerPersonnelNumber
OpenedDatesmmOpportunityTableOpenedDate
PrognosisIdsmmOpportunityTablePrognosisId
SalesUnitIdsmmOpportunityTableSalesUnitId
ClosedDatesmmOpportunityTableClosedDate