SSIS Components for Salesforce

Build 25.0.9434

CommSubscriptionConsent

Schema file for CommSubscriptionConsent.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

OwnerId String False

ID of the user who owns the record.

OwnerIdType String False

Specifies the type of the 'OwnerId' polymorphic field to use in the statement.

OwnerIdExternalFieldName String False

Specifies the external field name of the 'OwnerId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

ConsentGiverId String False

ID of the ConsentGiver associated with this record.

ConsentGiverIdType String False

Specifies the type of the 'ConsentGiverId' polymorphic field to use in the statement.

ConsentGiverIdExternalFieldName String False

Specifies the external field name of the 'ConsentGiverId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

ContactPointId String False

ID of the ContactPoint associated with this record.

ContactPointIdType String False

Specifies the type of the 'ContactPointId' polymorphic field to use in the statement.

ContactPointIdExternalFieldName String False

Specifies the external field name of the 'ContactPointId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

EffectiveFromDate Date False

Date associated with EffectiveFrom.

ConsentCapturedDateTime Datetime False

Field containing ConsentCapturedDateTime information.

ConsentCapturedSource String False

Field containing ConsentCapturedSource information.

CommSubscriptionChannelTypeId String False

CommSubscriptionChannelType.Id

ID of the CommSubscriptionChannelType associated with this record.

PartyRoleId String False

ID of the PartyRole associated with this record.

PartyRoleIdType String False

Specifies the type of the 'PartyRoleId' polymorphic field to use in the statement.

PartyRoleIdExternalFieldName String False

Specifies the external field name of the 'PartyRoleId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

BusinessBrandId String False

BusinessBrand.Id

ID of the BusinessBrand associated with this record.

PrivacyConsentStatus String False

Status of the PrivacyConsent.

DataUsePurposeId String False

DataUsePurpose.Id

ID of the DataUsePurpose associated with this record.

EngagementChannelTypeId String False

EngagementChannelType.Id

ID of the EngagementChannelType associated with this record.

PartyId String True

Individual.Id

ID of the Party associated with this record.

ContactPointValue String False

Field containing ContactPointValue information.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434