Warehouse table: OpportunityRequirements

The OpportunityRequirements warehouse table corresponds to the A422_OpportunityRequirement view in the CRM database.

Opportunity requirement records are joined to parent records by the OpportunityGUID. They can also be joined to PersonOrg records by the PersonOrgGUID.

This table is available in version Stage IIa and up.

 

This table is made available to clients via the Advanced Export.

 

 

ColumnCRM viewCRM columnNotesStandard Export nameType
OpportunityRequirementGUIDA422_OpportunityRequirementa422_opportunityrequirementidprimary key uniqueidentifier
OpportunityGUIDA422_OpportunityRequirementa422_opportunityid uniqueidentifier
ActivityCategoryA422_OpportunityRequirementa422_rel_activitycategoryidname nvarchar(100)
ActivityCategoryGUIDA422_OpportunityRequirementa422_rel_activitycategoryid uniqueidentifier
ActivityValueA422_OpportunityRequirementa422_rel_activityvalueidname nvarchar(100)
ActivityValueGUIDA422_OpportunityRequirementa422_rel_activityvalueid uniqueidentifier
CompletionDateUTCA422_OpportunityRequirementa422_completion datetime
WaivedA422_OpportunityRequirementa422_waived bit
OrganizationNameA422_OpportunityRequirementa422_organizationname nvarchar(100)
PersonOrgGUIDA422_OpportunityRequirementa422_personorgid uniqueidentifier
createdbyA422_OpportunityRequirementcreatedby uniqueidentifier
createdbynameA422_OpportunityRequirementcreatedbyname nvarchar(160)
createdonutcA422_OpportunityRequirementcreatedonutc datetime
modifiedbyA422_OpportunityRequirementmodifiedby uniqueidentifier
modifiedbynameA422_OpportunityRequirementmodifiedbyname nvarchar(160)
modifiedonutcA422_OpportunityRequirementmodifiedonutc datetime
statecodeA422_OpportunityRequirementstatecode int
statecodenameFilteredA422_OpportunityRequirementstatecodename nvarchar(255)
statuscodeA422_OpportunityRequirementstatuscode int
statuscodenameFilteredA422_OpportunityRequirementstatuscodename nvarchar(255)

 

Comments