Delivery Line Item Mapping Field Settings

The Delivery Line Item Mapping record type is intended for storing Delivery Line Item fields that are used in discount calculations.

This setting is required for order creation.

By default, the Quantity field specifies an integer number of products and prices are rounded to 2 decimal places in price fields, for example, in the Total Price field, on the Order, Order Line Item, Delivery, and Delivery Line Item objects.

If you want to calculate quantity in other units, such as ml, or change the rounding rules for prices, create custom Quantity and price fields on the above objects and specify these fields in the appropriate settings:

Otherwise, specify the standard fields, e.g., orders__Quantity__c.


Object record type API name: DeliveryLineItemMapping


Field API Name Type Description

List Price Field

orders__ListPriceField__c

Text(255)

The API name of a field on Price Book Line Item that stores a product price from the specific 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.

Quantity Field

orders__QuantityField__c

Text(255)

The field API name of a field on Delivery Line Item to store the number of products per order delivery.

Sales Organization

orders__SalesOrganizationId__c

Lookup(Sales Organization)

The business unit for which settings are configured.

  • If specified, the setting will be applied to a particular Sales Organization.

  • If blank, the setting can be applied to all sales organizations.

Total Discount Field

orders__TotalDiscountField__c

Text(255)

The API name of a field on Delivery Line Item that stores the total discount for a product. Calculation formula: (ListPrice * quantity) - (UnitPtice * quantity).

Total Price Field

orders__TotalPriceField__c

Text(255)

The API name of a field on Delivery Line Item that stores the total price with discount for a product. Calculation formula: UnitPrice * quantity.

Unit Price Field

orders__UnitPriceField__c

Text(255)

The API name of the field on Delivery Line Item that stores a price for one product with a discount.

``