cgcloud__Order__c

Stores the header details of the order entry. This object is available in API version 54.0 and later.

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

• Type: dateTime
• Properties: Filter, Nillable, Sort
• Description: Most recent date on which a user referenced this record.

• Type: dateTime
• Properties: Filter, Nillable, Sort
• Description: Most recent date on which a user viewed this record.

• Type: string
• Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort
• Description: Unique identification of the record.

• Type: reference

• Properties: Create, Defaulted on create, Filter, Group, Sort, Update

• Description: ID of the record owner.

  This is a polymorphic relationship field.

• Relationship Name: Owner

• Relationship Type: Lookup

• Refers To: Group, User

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Advanced shipping notice number that the supplier provides for a special delivery.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Contains the confirmation number of the receipt that an Automated Teller Machine (ATM) prints.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: The system shows the Initiator of the order as the initial accountable.

  This is a relationship field.

• Relationship Name: cgcloud__Accountable__r

• Relationship Type: Lookup

• Refers To: User

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Total product checkout quantity for the tour in question as actually counted by the tour executing user.

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Checkout type (method) that’s must be applied in the product checkout document based on the given template settings.

• Possible values:

  • Counting Groups
  • Express
  • Pallets
  • SKU

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Contains the name of the bank.

• Possible values:

  • Bank_of_Scotland—Bank of Scotland
  • CitiBank—Citi Bank
  • IngDiBa
  • SantanderBank—Santander Bank

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the bill to of the order entry.

  This is a relationship field.

• Relationship Name: cgcloud__Bill_Recipient_Account__r

• Relationship Type: Lookup

• Refers To: Account

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Schema that’s used to calculate the order with complex pricing.

  This is a relationship field.

• Relationship Name: cgcloud__Calculation_Schema__r

• Relationship Type: Lookup

• Refers To: cgcloud__CP_Calculation_Schema__c

• Type: picklist

• Properties: Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update

• Description: Complex pricing calculation status.

• Default value: 0

• Possible values:

  • 0—Initial
  • 1—Calculated
  • 2—Calculation Required, Resettable
  • 3—Calculation Required, Not Resettable
  • 4—Calculation Failed

• Type: dateTime
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Time of the last complex pricing calculation for this order.

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Specifies the reason for the cancellation of the delivery document or order.

• Possible values:

  • CanceledByCall—Canceled by Call
  • CashierNotAvailable—Cashier Not Available
  • CustomerBlocked—Customer is credit blocked
  • DoubleDelivery—Double Delivery
  • Misentry
  • NotEnoughMoney—Not enough money
  • WrongDelivery—Wrong Delivery
  • WrongPricing—Wrong Pricing

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Total product checkout quantity for the tour in question as given by the HOST interface.

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Specifies the currency of the order based on the sales org currency of the order template object. It must have the same picklist values as the sales org currency field.

• Possible values:

  • Counting Groups
  • Express
  • Pallets
  • SKU

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Restricted picklist, Sort, Update

• Description: Specifies the currency of the order based on the sales org currency of the order template object. It must have the same picklist values as the sales org currency field.

• Possible values:

  • CAD
  • CHF
  • EUR
  • GBP
  • JPY
  • NOK
  • RUB
  • USD

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Customer-specific ID of the order.

• Type: date
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: By default: next day. Delivery date calculation is customized frequently.

• Type: textarea
• Properties: Create, Nillable, Update
• Description: Delivery note.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the delivery recipient of the selected account.

  This is a relationship field.

• Relationship Name: cgcloud__Delivery_Recipient__r

• Relationship Type: Lookup

• Refers To: Account

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Terms of delivery.

• Possible values:

  • ExWarehouse—Ex Warehouse
  • FreeOfCharge—Free Of Charge
  • FreeOnBoard—Free On Board
  • ScaleOfCharge—Scale Of Charge

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Specifies how to manage a sales document.

• Possible values:

  • CashInvoice—Delivery Cash Invoice
  • CreditInvoice—Delivery Credit Invoice
  • CashOrder—Cash Order
  • CreditMemo—Credit Memo
  • CreditOrder—Credit Order
  • InvoiceCashInvoice—Cash Invoice
  • InvoiceCreditInvoice—Credit Invoice
  • NoPayment—No Payment
  • NoPaymentOrder—No Payment Order
  • VanSalesCashInvoice—Van Sales Cash Invoice
  • VanSalesNoPaymentInvoice—Van Sales No Payment Invoice
  • NonValuatedDeliveryNote—Non Valuated Delivery Note
  • ValuatedDeliveryNote—Valuated Delivery Note

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Specifies the type of the order document to distinguish DSD and non-DSD order entries.

• Possible values:

  • CashCheckIn—Cash Check In
  • CashCheckOut—Cash Check Out
  • Delivery
  • OrderEntry—Order Entry
  • ProductCheckIn—Product Check In
  • ProductCheckOut—Product Check Out
  • TruckAudit—Truck Audit

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Total value of the order entry in the order/receipt currency.

• Type: double
• Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
• Description: Gross total value (domestic currency) of the sales document including relevant sales taxes. The system calculates its value based on the respective sales document item template settings.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Percentage value of the header discount.

• Type: date
• Properties: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
• Description: Date of initiation of this sales document.

• Type: date
• Properties: Create, Nillable, Update
• Description: Unique invoice identifier.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: First reference to the inventory as defined in the order template.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Second reference to the inventory as defined in the order template.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Third reference to the inventory as defined in the order template.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Fourth reference to the inventory as defined in the order template.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Fifth reference to the inventory as defined in the order template.

• Type: textarea
• Properties: Create, Nillable, Update
• Description: Invoice note.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Merchandise value (value of goods) in receipt currency, not including header discount.

• Type: boolean
• Properties: Create, Defaulted on create, Filter, Group, Sort, Update
• Description: Indicates whether the order was released on Mobility.
• Default value: false

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Lookup field to capture the customer for which the order is created.

  This is a relationship field.

• Relationship Name: cgcloud__Order_Account__r

• Relationship Type: Lookup

• Refers To: Account

• Type: date
• Properties: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update
• Description: Day on which the customer committed to the sales document. For order entries, this is the order date.

• Type: string
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Specifies the user-readable number that’s used for print-outs and customer communication.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the Order Template for Order Entry.

  This is a relationship field.

• Relationship Name: cgcloud__Order_Template__r

• Relationship Type: Lookup

• Refers To: cgcloud__Order_Template__c

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Paid amount of the order entry in domestic currency. The paid amount is a gross value.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Paid amount of order.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the payer of the order.

  This is a relationship field.

• Relationship Name: cgcloud__Payer__r

• Relationship Type: Lookup

• Refers To: Account

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Describes the manner of the remuneration.

• Possible values:

  • Cash
  • Check—Cheque
  • CreditCard—Credit Card
  • DebitCard—Debit Card
  • Deduction
  • Expense
  • MoneyOrder—Money Order
  • Multiple

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Specifies a reason that leads to modifying the document handling regarding payments.

• Possible values:

  • CalculationFailed—Calculation Failed
  • PriceDisagreement—Price Disagreement
  • WrongPrice—Wrong Price

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Terms of payment.

• Possible values:

  • 2percent—2 % / 14
  • COD—cash on delivery
  • net30—net 30

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Represents the sign of the absolute paid amount: either inpayment (+, debit) or outpayment (-, credit).

• Possible values:

  • Credit—Out
  • Debit—In

• Type: picklist

• Properties: Create, Defaulted on create, Filter, Group, Nillable, Sort, Update

• Description: Workflow neutral description of the order entry status.

• Default value: Initial

• Possible values:

  • Approved
  • Assigned
  • Canceled
  • Closed
  • Feedback
  • ForApproval—For Approval
  • HoldBack—Hold Back
  • Initial
  • Ready
  • Released
  • SendFax—Send Fax
  • Voided
  • WorkCompleted—Work Completed

• Type: date
• Properties: Create, Filter, Group, Nillable, Sort, Update
• Description: Enables tracking of the conditions that were used. By default: current day. It can be changed if the order was taken on paper first and was then added to the system after a price change.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Additional pricing information field that stores calculated value at the order level.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Additional pricing information field that stores calculated value at the order level.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Additional pricing information field that stores calculated value at the order level.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Additional pricing information field that stores calculated value at the order level.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: double

• Properties: Create, Filter, Nillable, Sort, Update

• Description: Additional pricing information field that stores calculated value at the order level.

  This field is available in API version 55.0 and later.

• Type: textarea
• Properties: Create, Nillable, Update
• Description: Stores the pricing information (found conditions) that are directly related to the order.

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Receipt currency of an order.

• Possible values:

  • CAD
  • CHF
  • EUR
  • GBP
  • NOK
  • RUB
  • USD
  • Yen—JPY

• Type: string

• Properties: Filter, Nillable, Sort

• Description: Link to the Detail page of the Order record.

  This is a calculated field.

• Formula:

  1HYPERLINK("/" &Id, $Label.cgcloud__record_link,
  2			"_self")

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Geolocation (latitude) that’s to be fulfilled by mobility devices, and is not displayed on the order UI.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Geolocation (longitude) that’s to be fulfilled by mobility devices, and is not displayed on the order UI.

• Type: location
• Properties: Nillable
• Description: Geolocation (latitude and longitude) that’s to be fulfilled by mobility devices, and is not displayed on the order UI.

• Type: string

• Properties: Filter, Nillable, Sort

• Description: Platform that can be used to release the order.

  This is a calculated field.

• Formula:

  1TEXT(cgcloud__Order_Template__r.cgcloud__Release_Platform__c)

• Type: dateTime
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Date and time on which the sales document was released.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the responsible user.

  This is a relationship field.

• Relationship Name: cgcloud__Responsible__r

• Relationship Type: Lookup

• Refers To: User

• Type: textarea
• Properties: Create, Nillable, Update
• Description: Stores mobility selected rewards and related items or products in JSON format.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Sum of all returned quantities.

• Type: double
• Properties: Create, Filter, Nillable, Sort, Update
• Description: Sum of all shipped quantities.

• Type: double
• Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
• Description: Total value (domestic currency) of the order including item discounts, without sales taxes.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: This field looks up to Tour.

  This is a relationship field.

• Relationship Name: cgcloud__Tour__r

• Relationship Type: Lookup

• Refers To: cgcloud__Tour__c

• Type: double
• Properties: Create, Defaulted on create, Filter, Nillable, Sort, Update
• Description: Value of the order entry in the order or receipt currency.

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the call in which the sales document is created.

  This is a relationship field.

• Relationship Name: cgcloud__Visit__r

• Relationship Type: Lookup

• Refers To: Visit

• Type: picklist

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Warehouse from which the customer is to be delivered.

• Possible values:

  • 55001—North West
  • 55002—South West
  • 55003—Middle West
  • 55004—North East
  • 5505—South East
  • CE—Central Europe
  • NA—North America

• Type: reference

• Properties: Create, Filter, Group, Nillable, Sort, Update

• Description: Reference to the wholesaler of the account.

  This is a relationship field.

• Relationship Name: cgcloud__Wholesaler__r

• Relationship Type: Lookup

• Refers To: Account

• Type: string

• Properties: Filter, Nillable, Sort

• Description: ID of the referenced workflow.

  This is a calculated field.

• Formula:

  1cgcloud__Order_Template__r.cgcloud__Workflow__r.Name

This object has these associated objects. If the API version isn’t specified, they are available in the same API versions as this object. Otherwise, they are available in the specified API version and later.

• cgcloud__Order__cChangeEvent: Change events are available for the object.
• cgcloud__Order__cFeed: Feed tracking is available for the object.
• cgcloud__Order__cHistory: History is available for the tracked fields of the object.
• cgcloud__Order__cOwnerSharingRule: Sharing rules are available for the object.
• cgcloud__Order__cShare: Sharing is available for the object.

j

Get Started with Consumer Goods Cloud

Retail Execution

Standard Objects for Retail Execution

Associated Objects for Retail Execution

Custom Objects for Retail Execution

cgcloud__Account_Receivable__c

cgcloud__Account_Sales_Data__c

cgcloud__Account_Specific_Product_Condition__c

cgcloud__Account_Task__c

cgcloud__Account_Task_Template__c

cgcloud__Account_Visit_Setting__c

cgcloud__Asset_Audit__c

cgcloud__Asset_Template__c

cgcloud__Approval_Code__c

cgcloud__Batch_Last_Successful_Run__c

cgcloud__Batch_Process_Configuration__c

cgcloud__Color_Schema__c

cgcloud__BO_API__c

cgcloud__BO_API_Entity__c

cgcloud__BO_API_Output_Entity__c

cgcloud__BO_API_Step_Input_Structure__c

cgcloud__BO_API_Transaction_Log__c

cgcloud__BO_API_Workflow__c

cgcloud__BO_API_Workflow_Entity__c

cgcloud__BO_API_Workflow_Step__c

cgcloud__BO_API_Workflow_Workflow_Step__c

cgcloud__Consider_Default_SalesOrg__c

cgcloud__CP_Calculation_Schema__c

cgcloud__CP_Calculation_Schema_Determination__c

cgcloud__CP_Calculation_Schema_Step__c

cgcloud__CP_Key_Attribute__c

cgcloud__CP_Key_Type__c

cgcloud__CP_Pricing_Condition__c

cgcloud__CP_Pricing_Condition_Scale_Stage__c

cgcloud__CP_Pricing_Condition_Stage__c

cgcloud__CP_Pricing_Condition_Template__c

cgcloud__CP_Search_Strategy__c

cgcloud__CP_Search_Strategy_Step__c

cgcloud__Data_Type__c

cgcloud__Data_Type_Option__c

cgcloud__Field_Sales_Activity__c

cgcloud__Flatten_Org_Unit_Hierarchy__c

cgcloud__Historic_Product__c

cgcloud__Inventory__c

cgcloud__Inventory_Control_Template__c

cgcloud__Inventory_Transaction__c

cgcloud__Inventory_Transaction_Template__c

cgcloud__Job_Definition_List__c

cgcloud__Job_Definition_List_Account__c

cgcloud__Job_Definition_List_Account_Set__c

cgcloud__Job_Definition_List_Product__c

cgcloud__Job_Definition_List_Template__c

cgcloud__Job_Definition_Template__c

cgcloud__Job_DL_Job_Definition_Template__c

cgcloud__Job_DL_Template_Def_Template__c

cgcloud__Job_List__c

cgcloud__Job_Template__c

cgcloud__Listing_Classification__c

cgcloud__Listing_Module__c

cgcloud__Mobile_Link__c

cgcloud__Order__c

cgcloud__Order_Item__c

cgcloud__Order_Item_Inventory_Transaction__c

cgcloud__Order_Item_Order_Template_Association__c

cgcloud__Order_Item_Rule__c

cgcloud__Order_Item_Template__c

cgcloud__Order_Payment__c

cgcloud__Order_Payment_Inventory_Transaction__c

cgcloud__Order_Payment_Template__c

cgcloud__Order_Template__c

cgcloud__Order_Template_Order_Payment_Template__c

cgcloud__Order_Template_Product_Selector_Group__c

cgcloud__Org_Unit__c

cgcloud__Org_Unit_Hierarchy__c

cgcloud__Org_Unit_User__c

cgcloud__Organization_Setting__c

cgcloud__Package_Setting__c

cgcloud__Picklist_Toggle_Addon__c

cgcloud__POS__c

cgcloud__POS_Template__c

cgcloud__Product_Condition__c

cgcloud__Product_Listing_Module__c

cgcloud__Product_Assortment_Order_Template__c

cgcloud__Product_Assortment_Store__c

cgcloud__Promotion_Hurdle__c

cgcloud__Promotion_Hurdle_Expression__c

cgcloud__Promotion_Reward__c

cgcloud__Promotion_Reward_Group__c

cgcloud__Promotion_Reward_Product__c

cgcloud__Promotion_Sales_Folder__c

cgcloud__Promotion_Store__c

cgcloud__Sales_Folder__c

cgcloud__Sales_Folder_Sell_Sheet__c

cgcloud__Sales_Folder_Template__c

cgcloud__Sell_Sheet__c

cgcloud__Signature__c

cgcloud__Signature_Attribute__c

cgcloud__Signature_Flow_Step__c

cgcloud__Signature_Template__c

cgcloud__Substitution__c

cgcloud__System_Number__c

cgcloud__System_Number_Last__c

cgcloud__System_Number_Segment__c

cgcloud__Trip_List__c

cgcloud__Trip_List_Account__c

cgcloud__Unit_of_Measure__c

cgcloud__User_Accountable__c

cgcloud__User_Document__c

cgcloud__User_Document_Activity__c

cgcloud__User_Document_Template__c

cgcloud__User_Document_Template_Activity__c

cgcloud__Visit_Job__c

cgcloud__Visit_Template__c

cgcloud__Warehouse__c

cgcloud__Warehouse_Product__c

cgcloud__Warehouse_User__c

cgcloud__Workflow__c

cgcloud__Workflow_State_Transition__c

Standard DLO to DMO Mappings

Retail Execution Standard Metadata APIs

Retail Order Customization

Sync Management

Direct Store Delivery

Einstein Visit and Activity Recommendation

Trade Promotion Management

Custom Objects for Retail Execution and Trade Promotion Management

Standard and Custom Objects for Future Use

API End-of-Life Policy

Previous Versions