Salesforce Docs Portal

cgcloud__Order__c

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

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 must be applied in the product checkout document based on the given template settings.
  • Possible values:
    • 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:
    • 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.
  • Default value: 0
  • Possible values:
    • 0—Initial
    • 1—Calculated
    • 2—Calculation Required, Resettable
    • 3—Calculation Required, Not Resettable
    • 4—Calculation Failed

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 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

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:
    • 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:
    • 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:
    • 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:
    • 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

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:
    • 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_Invoice_ID__C

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

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.
  • Default value: 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:
    • 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:
    • 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:
    • 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:
    • 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.
  • 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

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 an order.
  • Possible values:
    • 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: 
    HYPERLINK("/" &Id, $Label.cgcloud__record_link,
			"_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: 
    TEXT(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:
    • 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: 
    cgcloud__Order_Template__r.cgcloud__Workflow__r.Name

Associated Objects

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.