Sold to / Bill to / Ship to flags on the company

CRM 9.0
Tools 8.50

Add a new company
BO_ROLE will have roles 2 and 40
If you mark the company to be 'sold to' then an additional role
42 would also be created.

Once you add a contact to the above company following relationships would be created:
Relationship Type 74 is the contact for Sold to organization(Role 42)
Relationship Type 75 is the 'Primary contact' for Sold to organization(Role 42)

9 and 10 for Primary contact and contact for the company(Role 2)

Once you add an address for the above company:
BO_CM will have 1 row with appropriate CM_PURPOSE_TYPE and CM_TYPE
CM will have 1 row with appropriate CM_PURPOSE_TYPE and CM_TYPE

BO_CM_USE will have 2 rows with same PROFILE_CM_SEQ but different Roles 2 and 42 with appropriate PRIMARY_IND


The similar rows would be present when you select 'Bill to' and 'Ship to' flags on the company.