SSIS Components for Salesforce

Build 25.0.9434

OrderItemsRest

Schema file for OrderItemsRest.

Columns

Name Type ReadOnly References Description
Id [KEY] String False

Unique identifier for the record.

Product2Id String False

ID of the Product associated with this record.

IsDeleted Bool False

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

PricebookEntryId String False

ID of the PricebookEntry associated with this record.

OriginalOrderItemId String False

ID of the OriginalOrderItem associated with this record.

AvailableQuantity Double False

Field containing AvailableQuantity information.

Quantity Double False

Quantity of the product.

CurrencyIsoCode String False

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

UnitPrice Decimal False

Price per unit for the product.

ListPrice Decimal False

List price for the product.

TotalPrice Decimal False

Total price for the line item.

ServiceDate Date False

Date associated with Service.

EndDate Date False

End date for the record or activity.

Description String False

Text description of the record.

TotalLineAmount Decimal False

Field containing TotalLineAmount information.

RelatedOrderItemId String False

ID of the RelatedOrderItem associated with this record.

Type String False

Type of account or classification.

TypeCode String False

Field containing TypeCode information.

CreatedDate Datetime False

Date and time when the record was created.

CreatedById String False

ID of the user who created the record.

LastModifiedDate Datetime False

Date and time when the record was last modified.

LastModifiedById String False

ID of the user who last modified the record.

SystemModstamp Datetime False

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

OrderId [KEY] String False

ID of the Order associated with this record.

OrderOwnerId String False

ID of the OrderOwner associated with this record.

OrderContractId String False

ID of the OrderContract associated with this record.

OrderAccountId String False

ID of the OrderAccount associated with this record.

OrderPricebook2Id String False

ID of the OrderPricebook2 associated with this record.

OrderOriginalOrderId String False

ID of the OrderOriginalOrder associated with this record.

OrderEffectiveDate Date False

Date associated with OrderEffective.

OrderEndDate Date False

Date associated with OrderEnd.

OrderIsReductionOrder Bool False

Field containing OrderIsReductionOrder information.

OrderStatus String False

Status of the Order.

OrderDescription String False

Field containing OrderDescription information.

OrderCustomerAuthorizedById String False

ID of the OrderCustomerAuthorizedBy associated with this record.

OrderCustomerAuthorizedDate Date False

Date associated with OrderCustomerAuthorized.

OrderCompanyAuthorizedById String False

ID of the OrderCompanyAuthorizedBy associated with this record.

OrderCompanyAuthorizedDate Date False

Date associated with OrderCompanyAuthorized.

OrderType String False

Type classification for Order.

OrderBillingStreet String False

Street address for OrderBilling purposes.

OrderBillingCity String False

City for OrderBilling address.

OrderBillingState String False

State or province for OrderBilling address.

OrderBillingPostalCode String False

Postal code for OrderBilling address.

OrderBillingCountry String False

Country for OrderBilling address.

OrderBillingLatitude Double False

Latitude coordinate for OrderBilling address geolocation.

OrderBillingLongitude Double False

Longitude coordinate for OrderBilling address geolocation.

OrderBillingGeocodeAccuracy String False

Accuracy level of the geocode for the OrderBilling address.

OrderBillingAddress String False

Field containing OrderBillingAddress information.

OrderShippingStreet String False

Street address for OrderShipping purposes.

OrderShippingCity String False

City for OrderShipping address.

OrderShippingState String False

State or province for OrderShipping address.

OrderShippingPostalCode String False

Postal code for OrderShipping address.

OrderShippingCountry String False

Country for OrderShipping address.

OrderShippingLatitude Double False

Latitude coordinate for OrderShipping address geolocation.

OrderShippingLongitude Double False

Longitude coordinate for OrderShipping address geolocation.

OrderShippingGeocodeAccuracy String False

Accuracy level of the geocode for the OrderShipping address.

OrderShippingAddress String False

Field containing OrderShippingAddress information.

OrderName String False

Field containing OrderName information.

OrderPoDate Date False

Date associated with OrderPo.

OrderPoNumber String False

OrderPo identification number.

OrderReferenceNumber String False

OrderReference identification number.

OrderBillToContactId String False

ID of the OrderBillToContact associated with this record.

OrderShipToContactId String False

ID of the OrderShipToContact associated with this record.

OrderActivatedDate Datetime False

Date associated with OrderActivated.

OrderActivatedById String False

ID of the OrderActivatedBy associated with this record.

OrderStatusCode String False

Field containing OrderStatusCode information.

OrderCurrencyIsoCode String False

Field containing OrderCurrencyIsoCode information.

OrderRelatedOrderId String False

ID of the OrderRelatedOrder associated with this record.

OrderNumber String False

Order identification number.

OrderTotalAmount Decimal False

Field containing OrderTotalAmount information.

OrderRelatedOrderType String False

Type classification for OrderRelatedOrder.

OrderCreatedDate Datetime False

Date associated with OrderCreated.

OrderCreatedById String False

ID of the OrderCreatedBy associated with this record.

OrderLastModifiedDate Datetime False

Date associated with OrderLastModified.

OrderLastModifiedById String False

ID of the OrderLastModifiedBy associated with this record.

OrderIsDeleted Bool False

Field containing OrderIsDeleted information.

OrderSystemModstamp Datetime False

Field containing OrderSystemModstamp information.

OrderLastViewedDate Datetime False

Date associated with OrderLastViewed.

OrderLastReferencedDate Datetime False

Date associated with OrderLastReferenced.

OrderExternalId String False

ID of the OrderExternal associated with this record.

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