OrderItemSummary
Represents a summarized view of an order item used 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. | |
| 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 |
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. | |
| Quantity | Double | True |
Quantity of the product. | |
| ListPrice | Decimal | True |
List price for the product. | |
| UnitPrice | Decimal | True |
Price per unit for the product. | |
| TotalPrice | Decimal | True |
Total price of the order item summary. | |
| AdjustedLineAmount | Decimal | True |
Line amount after adjustments have been applied. | |
| TotalAdjustedLineTaxAmount | Decimal | True |
Total tax amount on the line after adjustments have been applied. | |
| 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. | |
| TotalTaxAmount | Decimal | True |
Total tax amount for the order item summary. | |
| TotalAdjustmentAmount | Decimal | True |
Total adjustment amount applied to the order item summary. | |
| TotalAdjustmentTaxAmount | Decimal | True |
Total tax amount attributable to adjustments on the order item summary. | |
| TotalLineAmount | Decimal | True |
Field containing TotalLineAmount information. | |
| TotalLineTaxAmount | Decimal | True |
Total tax amount for the order item line. | |
| TotalLineAdjustmentAmount | Decimal | True |
Total adjustment amount applied to the order item line. | |
| TotalLineAdjustmentTaxAmount | Decimal | True |
Total tax amount attributable to adjustments on the order item line. | |
| TotalAdjustmentDistAmount | Decimal | True |
Total adjustment amount distributed to the order item summary. | |
| TotalAdjustmentDistTaxAmount | Decimal | True |
Total tax amount on adjustments distributed to the order item summary. | |
| 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 |
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. | |
| QuantityNetOrdered | Double | True |
Net quantity ordered after cancellations and returns. | |
| QuantityAvailableToCancel | Double | True |
Quantity available to be canceled. | |
| QuantityAvailableToReturn | Double | True |
Quantity available to be returned. | |
| QuantityAvailableToFulfill | Double | True |
Quantity available to be fulfilled. | |
| QuantityAvailableToReship | Double | True |
Quantity available to be reshipped. | |
| GrossUnitPrice | Decimal | True |
Field containing GrossUnitPrice information. | |
| TotalAdjustmentAmtWithTax | Decimal | True |
Total adjustment amount, including tax, applied to the order item summary. | |
| AdjustedLineAmtWithTax | Decimal | True |
Line amount, including tax, after adjustments have been applied. | |
| TotalLineAdjustmentAmtWithTax | Decimal | True |
Total adjustment amount, including tax, applied to the order item line. | |
| TotalAdjustmentDistAmtWithTax | Decimal | True |
Total adjustment amount, including tax, distributed to the order item summary. | |
| TotalAmtWithTax | Decimal | True |
Total amount of the order item summary, including tax. | |
| TotalLineAmountWithTax | Decimal | True |
Total amount of the order item line, including tax. | |
| QuantityShipped | Double | False |
Field containing QuantityShipped information. | |
| MainOrderItemSummaryId | String | True |
ID of the MainOrderItemSummary associated with this record. | |
| 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. |
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 |
| ReservedAtLocationIdType | String |
Specifies the type of the 'ReservedAtLocationId' polymorphic field to use in the statement. |
| ReservedAtLocationIdExternalFieldName | String |
Specifies the external field name of the 'ReservedAtLocationId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement |
| 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. |