Deal associations can be used to insert or delete individual associations with Deals.
Table Specific Information
Deal associations represent Company and Contact associations made with existing deals that may be modified.
When selecting deal associations, they can only be filtered by the Id. For example:
SELECT * FROM DealAssociations WHERE DealId = 12345
New associations may be inserted by specifying the DealId, AssociationId, and the AssociationType during an INSERT statement. For example:
INSERT INTO DealAssociations (DealId, AssociationId, AssociationType) VALUES (12345, 6789, 'COMPANY')
Associations may be removed by specifying the DealId, AssociationId, and the AssociationType during a DELETE statement. For example:
DELETE FROM DealAssociations WHERE DealId = 12345 AND AssociationId = 6789 AND AssociationType = 'COMPANY'
The Id of the deal.
The Id of the associated entity.
The type of association such as Company, or Contact.