Outbound OneToMany and ManyToOne formats

Outbound OneToMany and ManyToOne formats can be used define outbound template-based relationships.

Specialized data encoding is required to define the IDO value for outbound BOD field mappings to describe relationships with three or more levels of indirection.

MappingType IDO Property Template relationship
ManyToOne CRMSalesOrder.CRMAccount ~AccountID relationName="ManyToOne:CRMSalesOrder.AccountID~CRMAccount.ID"
ManyToOne CRMSalesOrder.ID~CRMSalesOrderPerson.SalesOrderID.PersonID~CRMPerson ~PersonID relationName=”ManyToOne:CRMSalesOrderPerson.SalesOrderID.PersonID~CRMPerson.PersonID”
ManyToOne CRMSalesOrder.ID~CRMSalesOrderItem.SalesOrderID.ProductID~CRMProduct ~ProductID relationName="ManyToOne:CRMSalesOrder.ID~CRMSalesOrderItem.SalesOrderID.ProductID~CRMProduct.ID"

Mapping Type: ManyToOne

Entity: CRMSalesORder.CRMAccount

Property: ~AccountID

  • CRMSalesOrder is the main entity or IDO.
  • CRMAccount is a related item based on (CRMSalesOrder.AccountID = CRMAccount.ID)

Mapping Type: ManyToOne

Entity: CRMSalesOrder.ID~CRMSalesOrderPerson.SalesOrderID.PersonID~CRMPerson

Property: ~PersonID

  • CRMSalesOrder is the main entity or IDO.
  • CRMSalesOrderPerson is a child-related data set based on (CRMSalesOrder.ID = CRMSalesOrderPerson.SalesOrderID)
  • RMPerson is a related item based on (CRMSalesOrderPerson.PersonID=CRMPerson.PersonID)

Mapping Type: ManyToOne

Entity: CRMSalesOrder.ID~CRMSalesOrderItem.SalesOrderID.ProductID~CRMProduct

Property: ~ProductID

  • CRMSalesOrder is the main entity or IDO.
  • CRMSalesOrderItem is a child-related data set based on (CRMSalesOrder.ID = CRMSalesOrderItem.SalesOrderID)
  • CRMProduct is a related item based on (CRMSalesOrderItem.ProductID = CRMProduct.ProductID)
Related topics