Table showing the designation splits for each opportunity – these appear as a multi-valued window for each opportunity and allow the opportunity to be linked to multiple designations
| Column | Comment |
|---|---|
| OPPORTUNITYFACTID | |
| OPPORTUNITYDESIGNATIONSYSTEMID | |
| OPPORTUNITYSTATUS | |
| DESIGNATIONNAME | |
| DESIGNATIONLOOKUPID | |
| DESIGNATIONDIMID | |
| AMOUNT | |
| USECODE | |
| CATEGORY | |
| TYPE | |
| FUNDINGMETHOD |