SSIS Components for Salesforce

Build 26.0.9770

OrderItemSummaryChange

Tracks a change made to an order item summary during order fulfillment.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

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

OrderItemSummaryChangeNumber String True

OrderItemSummaryChange identification number.

CurrencyIsoCode String True

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

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.

OrderItemSummaryId String True

OrderItemSummary.Id

ID of the OrderItemSummary associated with this record.

ChangeOrderItemId String True

OrderItem.Id

ID of the ChangeOrderItem associated with this record.

OrderSummaryId String True

OrderSummary.Id

ID of the OrderSummary associated with this record.

Reason String True

Field containing Reason information.

ChangeType String True

Type classification for Change.

IsPreFulfillment Bool True

Indicates whether the record has the PreFulfillment characteristic.

ReasonText String True

Field containing ReasonText information.

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.

CreatedDate Datetime True

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