Order Line Item Field Reference

The Order Line Item object is intended to store details about related catalog and price book, general information about promotions, discounts, and totals for each CT Product in the order.

If you use CT Orders module for CT Mobile app, launch full synchronization after adding new fields to the Order Line Item Layout.

Fields with Checkbox and Date types are not supported.

Formula fields requiring recalculation during order management are not supported.

Object API name: orders__OrderLineItem__c

Field	API Name	Type	Description
Catalog	orders__CatalogId__c	Lookup(Catalog)	Stores the linked Catalog record.
Catalog Line Item	orders__CatalogLineItemId__c	Lookup(Catalog Line Item)	Stores the linked Catalog Line Item record that is a product from the selected catalog.
External Id	orders__ExternalId__c	Text(255) (External ID) (Unique Case Sensitive)	In the case of using pre-configured orders from the related ERP.
Freebie Condition	orders__FreebieConditionId__c	Lookup(Freebie Condition)	Stores the linked Freebie Condition record.
Freebie Level	orders__FreebieLevelId__c	Lookup(Freebie Level)	Stores the linked Freebie Level record.
Freebie Type	orders__FreebieTypeId__c	Lookup(Freebie Type)	Stores the linked Freebie Type record.
List Price	orders__ListPrice__c	Currency(15, 3)	Stores a price from the linked CT Price Book record for a product.
Log Id	orders__LogId__c	Text(255) (External ID) (Unique Case Sensitive)	This record ID is used to send the order structure to the Web Service. The record ID is written once (or updated if the field was empty) and does not change again.
Order	orders__OrderId__c	Master-Detail(CT Order)	The unique Order Id.
Parent Order Line Item	orders__ParentId__c	Lookup(Order Line Item)	Filled out with the linked Catalog Line Item record that is a bundle including the selected product.
Price Book	orders__PriceBookId__c	Lookup(CT Price Book)	Stores the linked CT Price Book record.
Price Book Line Item	orders__PriceBookLineItemId__c	Lookup(CT Price Book Line Item)	Stores the linked CT Price Book Line Item record with the list price from the selected CT Price Book.
Product	orders__Product2Id__c	Lookup(Product2)	This is a default lookup to the standard Product record in case of working with the CG Cloud solution.
Product	orders__ProductId__c	Lookup(CT Product)	This is a custom lookup to store a custom product identifier. Please create this field in case of using the custom CT Product or Pharma Product.
Product Component	orders__ProductComponentId__c	Lookup(Product Component)	Stores the linked Product Component record that is a bundle added in the order.
Promotion	orders__PromotionId__c	Lookup(Promotion)	Stores the linked Promotion record.
Promotion Line Item	orders__PromotionLineItemId__c	Lookup(Promotion Line Item)	Stores the linked Promotion Line Item record that is a promo product in the order.
Quantity	orders__Quantity__c	Number(18, 0)	Number of products in the order. This field is used for Order and Delivery mapping. You can reuse the package Quantity field if the Currency (16,2) format is suitable for your organization. You can also create a custom Quantity field with the required measurement specifications.
Reference Id	orders__RefereneId__c	Text(255) (External ID) (Unique Case Sensitive)	The Reference Id field is responsible for the deduplication logic and stores the pair of record Id and user Id. For more information, refer to Order Change Manager. If the record has not yet been transferred from CT Mobile, the field contains the mobile temporary record Id and the user identifier. For example, a06-AF3AA67B-EA24-4DAB-9C8A-9B70357DAB830055J000001L7aTQAS, where a06-AF3AA67B-EA24-4DAB-9C8A-9B70357DAB83 is the temporary record Id and 0055J000001L7aTQAS is the user identifier. If the record was transferred to Salesforce, the field contains the Salesforce record Id and the user identifier. For example, a0g5w00000EQJi1AAH0055J000001L7aTQAS, where a0g5w00000EQJi1AAH is the Salesforce record Id and 0055J000001L7aTQAS is the user identifier.
Total Discount	orders__TotalDiscount__c	Currency(15, 3)	The overall discount for all CT Products and Deliveries for the order.
Total Price	orders__TotalPrice__c	Currency(15, 3)	The overall price for all CT Products and Deliveries with a discount for the order.
Unit Price	orders__UnitPrice__c	Currency(15, 3)	The price for a single CT Product with a discount for the order.

Field

API Name

Type

Description

Catalog

orders__CatalogId__c

Lookup(Catalog)

Stores the linked Catalog record.

Catalog Line Item

orders__CatalogLineItemId__c

Lookup(Catalog Line Item)

Stores the linked Catalog Line Item record that is a product from the selected catalog.

External Id

orders__ExternalId__c

Text(255) (External ID) (Unique Case Sensitive)

In the case of using pre-configured orders from the related ERP.

Freebie Condition

orders__FreebieConditionId__c

Lookup(Freebie Condition)

Stores the linked Freebie Condition record.

Freebie Level

orders__FreebieLevelId__c

Lookup(Freebie Level)

Stores the linked Freebie Level record.

Freebie Type

orders__FreebieTypeId__c

Lookup(Freebie Type)

Stores the linked Freebie Type record.

List Price

orders__ListPrice__c

Currency(15, 3)

Stores a price from the linked CT Price Book record for a product.

Log Id

orders__LogId__c

Text(255) (External ID) (Unique Case Sensitive)

This record ID is used to send the order structure to the Web Service. The record ID is written once (or updated if the field was empty) and does not change again.

Order

orders__OrderId__c

Master-Detail(CT Order)

The unique Order Id.

Parent Order Line Item

orders__ParentId__c

Lookup(Order Line Item)

Filled out with the linked Catalog Line Item record that is a bundle including the selected product.

Price Book

orders__PriceBookId__c

Lookup(CT Price Book)

Stores the linked CT Price Book record.

Price Book Line Item

orders__PriceBookLineItemId__c

Lookup(CT Price Book Line Item)

Stores the linked CT Price Book Line Item record with the list price from the selected CT Price Book.

Product

orders__Product2Id__c

Lookup(Product2)

This is a default lookup to the standard Product record in case of working with the CG Cloud solution.

Product

orders__ProductId__c

Lookup(CT Product)

This is a custom lookup to store a custom product identifier.

Please create this field in case of using the custom CT Product or Pharma Product.

Product Component

orders__ProductComponentId__c

Lookup(Product Component)

Stores the linked Product Component record that is a bundle added in the order.

Promotion

orders__PromotionId__c

Lookup(Promotion)

Stores the linked Promotion record.

Promotion Line Item

orders__PromotionLineItemId__c

Lookup(Promotion Line Item)

Stores the linked Promotion Line Item record that is a promo product in the order.

Quantity

orders__Quantity__c

Number(18, 0)

Number of products in the order.

This field is used for Order and Delivery mapping. You can reuse the package Quantity field if the Currency (16,2) format is suitable for your organization. You can also create a custom Quantity field with the required measurement specifications.

Reference Id

orders__RefereneId__c

Text(255) (External ID) (Unique Case Sensitive)

The Reference Id field is responsible for the deduplication logic and stores the pair of record Id and user Id. For more information, refer to Order Change Manager.

If the record has not yet been transferred from CT Mobile, the field contains the mobile temporary record Id and the user identifier.

For example, a06-AF3AA67B-EA24-4DAB-9C8A-9B70357DAB830055J000001L7aTQAS, where a06-AF3AA67B-EA24-4DAB-9C8A-9B70357DAB83 is the temporary record Id and 0055J000001L7aTQAS is the user identifier.
If the record was transferred to Salesforce, the field contains the Salesforce record Id and the user identifier.

For example, a0g5w00000EQJi1AAH0055J000001L7aTQAS, where a0g5w00000EQJi1AAH is the Salesforce record Id and 0055J000001L7aTQAS is the user identifier.

Total Discount

orders__TotalDiscount__c

Currency(15, 3)

The overall discount for all CT Products and Deliveries for the order.

Total Price

orders__TotalPrice__c

Currency(15, 3)

The overall price for all CT Products and Deliveries with a discount for the order.

Unit Price

orders__UnitPrice__c

Currency(15, 3)

The price for a single CT Product with a discount for the order.