cgcloudOrderc

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

Supported Calls

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

Fields

Field	Details
LastReferencedDate	Type dateTime Properties Filter, Nillable, Sort Description Most recent date on which a user referenced this record.
LastViewedDate	Type dateTime Properties Filter, Nillable, Sort Description Most recent date on which a user viewed this record.
Name	Type string Properties Autonumber, Defaulted on create, Filter, idLookup, Sort Description Unique identification of the record.
OwnerId	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
cgcloud__ASN__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Advanced shipping notice number that the supplier provides for a special delivery.
cgcloud__ATM_Confirmation_Nr__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Contains the confirmation number of the receipt that an Automated Teller Machine (ATM) prints.
cgcloud__Accountable__c	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
cgcloud__Actual_Check_Out_Quantity__c	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.
cgcloud__Actual_Check_Out_Type__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Checkout type (method) that's to be applied in the product checkout document based on the given template settings. Possible values are: `Counting Groups` `Express` `Pallets` `SKU`
cgcloud__Bank_Name__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Contains the name of the bank. Possible values are: `Bank_of_Scotland`—Bank of Scotland `CitiBank`—Citi Bank `IngDiBa` `SantanderBank`—Santander Bank
cgcloud__Bill_Recipient_Account__c	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
cgcloud__Calculation_Schema__c	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
cgcloud__Calculation_Status__c	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Restricted picklist, Sort, Update Description Complex pricing calculation status. Possible values are: `0`—Initial `1`—Calculated `2`—Calculation Required, Resettable `3`—Calculation Required, Not Resettable `4`—Calculation Failed The default value is `0`.
cgcloud__Calculation_Time__c	Type dateTime Properties Create, Filter, Nillable, Sort, Update Description Time of the last complex pricing calculation for this order.
cgcloud__Cancel_Reason__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies a reason for the cancellation of the sales document. Possible values are: `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
cgcloud__Check_Out_Quantity__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Total product checkout quantity for the tour in question as given by the HOST interface.
cgcloud__Check_Out_Type__c	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 are: `Counting Groups` `Express` `Pallets` `SKU`
cgcloud__Currency__c	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 are: `CAD` `CHF` `EUR` `GBP` `JPY` `NOK` `RUB` `USD`
cgcloud__Customer_Order_Id__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Customer-specific ID of the order.
cgcloud__Delivery_Date__c	Type date Properties Create, Filter, Group, Nillable, Sort, Update Description By default: next day. Delivery date calculation is customized frequently.
cgcloud__Delivery_Note__c	Type textarea Properties Create, Nillable, Update Description Delivery note.
cgcloud__Delivery_Recipient__c	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
cgcloud__Delivery_Terms__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Terms of delivery. Possible values are: `ExWarehouse`—Ex Warehouse `FreeOfCharge`—Free Of Charge `FreeOnBoard`—Free On Board `ScaleOfCharge`—Scale Of Charge
cgcloud__Document_Transaction_Type__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies how to manage a sales document. Possible values are: `CashInvoice`—Cash Invoice `CreditInvoice`—Credit Invoice `NonValuatedDeliveryNote`—Non Valuated Delivery Note `ValuatedDeliveryNote`—Valuated Delivery Note
cgcloud__Document_Type__c	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 are: `CashCheckIn`—Cash Check In `CashCheckOut`—Cash Check Out `Delivery` `OrderEntry`—Order Entry `ProductCheckIn`—Product Check In `ProductCheckOut`—Product Check Out `TruckAudit`—Truck Audit
cgcloud__Gross_Total_Value_Receipt__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Total value of the order entry in the order/receipt currency.
cgcloud__Gross_Total_Value__c	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.
cgcloud__Header_Discount_Percentage__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Percentage value of the header discount.
cgcloud__Initiation_Date__c	Type date Properties Create, Defaulted on create, Filter, Group, Nillable, Sort, Update Description Date of initiation of this sales document.
cgcloud__Inventory_Reference_1__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description First reference to the inventory as defined in the order template.
cgcloud__Inventory_Reference_2__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Second reference to the inventory as defined in the order template.
cgcloud__Inventory_Reference_3__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Third reference to the inventory as defined in the order template.
cgcloud__Inventory_Reference_4__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Fourth reference to the inventory as defined in the order template.
cgcloud__Inventory_Reference_5__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Fifth reference to the inventory as defined in the order template.
cgcloud__Invoice_Note__c	Type textarea Properties Create, Nillable, Update Description Invoice note.
cgcloud__Merchandise_Value_Receipt__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Merchandise value (value of goods) in receipt currency, not including header discount.
cgcloud__Mobility_Release__c	Type boolean Properties Create, Defaulted on create, Filter, Group, Sort, Update Description Indicates whether the order was released on Mobility. The default value is `false`.
cgcloud__Order_Account__c	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
cgcloud__Order_Date__c	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.
cgcloud__Order_Id__c	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies the user-readable number that's used for print-outs and customer communication.
cgcloud__Order_Template__c	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
cgcloud__Paid_Amount_Receipt__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.
cgcloud__Paid_Amount__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Paid amount of order.
cgcloud__Payer__c	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
cgcloud__Payment_Method__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Describes the manner of the remuneration. Possible values are: `Cash` `Check`—Cheque `CreditCard`—Credit Card `DebitCard`—Debit Card `Deduction` `Expense` `MoneyOrder`—Money Order `Multiple`
cgcloud__Payment_Reason__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies a reason that leads to modifying the document handling regarding payments. Possible values are: `CalculationFailed`—Calculation Failed `PriceDisagreement`—Price Disagreement `WrongPrice`—Wrong Price
cgcloud__Payment_Terms__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Terms of payment. Possible values are: `2percent`—2 % / 14 `COD`—cash on delivery `net30`—net 30
cgcloud__Payment__c	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 are: `Credit`—Out `Debit`—In
cgcloud__Phase__c	Type picklist Properties Create, Defaulted on create, Filter, Group, Nillable, Sort, Update Description Workflow neutral description of the order entry status. Possible values are: `Approved` `Assigned` `Canceled` `Closed` `Feedback` `ForApproval`—For Approval `HoldBack`—Hold Back `Initial` `Ready` `Released` `SendFax`—Send Fax `Voided` `WorkCompleted`—Work Completed The default value is `Initial`.
cgcloud__Pricing_Date__c	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.
cgcloud__Pricing_Info_1__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Additional pricing information field that stores calculated value at the order level.
cgcloud__Pricing_Info_2__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Additional pricing information field that stores calculated value at the order level.
cgcloud__Pricing_Info_3__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Additional pricing information field that stores calculated value at the order level.
cgcloud__Pricing_Info_4__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Additional pricing information field that stores calculated value at the order level.
cgcloud__Pricing_Info_5__c	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.
cgcloud__Pricing_Info_6__c	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.
cgcloud__Pricing_Info_7__c	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.
cgcloud__Pricing_Info_8__c	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.
cgcloud__Pricing_Info_9__c	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.
cgcloud__Pricing_Info_10__c	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.
cgcloud__Pricing_Information__c	Type textarea Properties Create, Nillable, Update Description Stores the pricing information (found conditions) that are directly related to the order.
cgcloud__Receipt_Currency__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Receipt currency of a order. Possible values are: `CAD` `CHF` `EUR` `GBP` `NOK` `RUB` `USD` `Yen`—JPY
cgcloud__Record_Link__c	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")`
cgcloud__Release_Geolocation__Latitude__s	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.
cgcloud__Release_Geolocation__Longitude__s	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.
cgcloud__Release_Geolocation__c	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.
cgcloud__Release_Platform__c	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)`
cgcloud__Release_Time__c	Type dateTime Properties Create, Filter, Nillable, Sort, Update Description Date and time on which the sales document was released.
cgcloud__Responsible__c	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
cgcloud__Selected_Rewards__c	Type textarea Properties Create, Nillable, Update Description Stores mobility selected rewards and related items or products in JSON format.
cgcloud__Total_Returned_Quantity__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Sum of all returned quantities.
cgcloud__Total_Shipped_Quantity__c	Type double Properties Create, Filter, Nillable, Sort, Update Description Sum of all shipped quantities.
cgcloud__Total_Value__c	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.
cgcloud__Tour__c	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
cgcloud__Value__c	Type double Properties Create, Defaulted on create, Filter, Nillable, Sort, Update Description Value of the order entry in the order or receipt currency.
cgcloud__Visit__c	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
cgcloud__Warehouse__c	Type picklist Properties Create, Filter, Group, Nillable, Sort, Update Description Warehouse from which the customer is to be delivered. Possible values are: `55001`—North West `55002`—South West `55003`—Middle West `55004`—North East `5505`—South East `CE`—Central Europe `NA`—North America
cgcloud__Wholesaler__c	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
cgcloud__Workflow__c	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`

Associated Objects

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.

Consumer Goods Cloud Developer Guide

cgcloud__Order__c

Supported Calls

Fields

Associated Objects

cgcloudOrderc