ADO.NET Provider for Salesforce

Build 25.0.9434

OrderItemSummary

Schema file for OrderItemSummary.

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.

Name String False

Name of the record.

CurrencyIsoCode String True

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.

OrderSummaryId String True

OrderSummary.Id

ID of the OrderSummary associated with this record.

OriginalOrderItemId String True

OrderItem.Id

ID of the OriginalOrderItem associated with this record.

OrderDeliveryGroupSummaryId String True

OrderDeliveryGroupSummary.Id

ID of the OrderDeliveryGroupSummary associated with this record.

AssetId String True

Asset.Id

ID of the Asset associated with this record.

Product2Id String True

Product2.Id

ID of the Product associated with this record.

ProductCode String True

Field containing ProductCode information.

StockKeepingUnit String True

Field containing StockKeepingUnit information.

LineNumber Int True

Line identification number.

Type String True

Type of account or classification.

TypeCode String True

Field containing TypeCode information.

ReservedAtLocationId String False

ID of the ReservedAtLocation associated with this record.

ReservedAtLocationIdType String False

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

ReservedAtLocationIdExternalFieldName String False

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

Quantity Double True

Quantity of the product.

ListPrice Decimal True

List price for the product.

UnitPrice Decimal True

Price per unit for the product.

QuantityAllocated Double True

Field containing QuantityAllocated information.

QuantityReshipped Double True

Field containing QuantityReshipped information.

QuantityCanceled Double True

Field containing QuantityCanceled information.

QuantityOrdered Double True

Field containing QuantityOrdered information.

Status String True

Status of the record.

QuantityFulfilled Double True

Field containing QuantityFulfilled information.

QuantityReturned Double True

Field containing QuantityReturned information.

TotalLineAmount Decimal True

Field containing TotalLineAmount information.

ServiceDate Date True

Date associated with Service.

EndDate Date True

End date for the record or activity.

Description String False

Text description of the record.

QuantityReturnInitiated Double True

Field containing QuantityReturnInitiated information.

PricebookEntryId String True

PricebookEntry.Id

ID of the PricebookEntry associated with this record.

EarliestEstimatedDeliveryDate Date False

Date associated with EarliestEstimatedDelivery.

LatestEstimatedDeliveryDate Date False

Date associated with LatestEstimatedDelivery.

EarliestEstimatedDeliveryTime Time False

Field containing EarliestEstimatedDeliveryTime information.

LatestEstimatedDeliveryTime Time False

Field containing LatestEstimatedDeliveryTime information.

EstimatedDeliveryReference String False

Field containing EstimatedDeliveryReference information.

EstimatedDeliveryTimeZone String False

Field containing EstimatedDeliveryTimeZone information.

GrossUnitPrice Decimal True

Field containing GrossUnitPrice information.

QuantityShipped Double False

Field containing QuantityShipped information.

MainOrderItemSummaryId String True

OrderItemSummary.Id

ID of the MainOrderItemSummary associated with this record.

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