SSIS Components for Salesforce

Build 26.0.9770

SfdcPartnerSbscrOfferItem

Represents an individual item included within a partner subscription offer.

Columns

Name Type References Description
Id [KEY] String Unique identifier of the record.
IsDeleted Bool Indicates whether the record has been moved to the Recycle Bin (true) or not (false).
Name String Name of the record.
CurrencyIsoCode String ISO code for the currency in which the record's currency fields are expressed.
CreatedById String

User.Id

ID of the user who created the record.
LastModifiedDate Datetime Date and time when the record was last modified.
LastModifiedById String

User.Id

ID of the user who last modified the record.
LastViewedDate Datetime Date and time when the record was last viewed by a user.
LastReferencedDate Datetime Date and time when the record was last referenced, such as through a lookup.
PartnerSubscriberOfferId String

SfdcPartnerSbscrOffer.Id

ID of the subscription offer that this item belongs to.
PartnerProvisionProductName String Name of the product to be provisioned for the partner.
Quantity Int Quantity of the product included on this offer item.
CustomerUnitPricePerMonth Decimal Monthly unit price charged to the customer for this offer item.
LineItemPeriodTotal Decimal Total amount for this line item over the billing period.
LineItemTotal Decimal Total amount for this line item.
ServiceStartDate Date Date on which the subscribed service for this item begins.
SystemModstamp Datetime Date and time when the record was last modified by a user or by an automated process.
CreatedDate Datetime Date and time when the record was created.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
SOQL String 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 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 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.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770