Order Requests
Subcategories: Attachments, Notes
The order resource is used to create, view, update, or delete order requests.
|
Resource Plural Label |
Order Requests |
|
Resource Name |
__ORACO__OrderDSD_c |
Get All Order Requests
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c
Request Path Parameters
There are no request path parameters for this task.
Request Query Parameters
Use these finder parameters to query the resource:
| Finder Name | Description |
|---|---|
|
Primary Key |
Finds an Order Request with the specified primary key. Finder Variables:
|
Request Body
There are no elements in the request body for this task.
Response Body
This table summarizes the supported response body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Create an Order Request
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c
Request Path Parameters
There are no request path parameters for this task.
Request Body
This table summarizes the supported request body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Get an Order Request
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Request. |
Request Body
There are no elements in the request body for this task.
Response Body
This table summarizes the supported response body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Update an Order Request
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Request. |
Request Body
This table summarizes the request body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Replace an Order Request
Request: PUT
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Request. |
Request Body
This table summarizes the request body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Response Body
This table summarizes the supported response body content types:
|
Media Type |
application/vnd.oracle.adf.resourcecollection+json |
Delete an Order Request
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Request. |
Request Body
There are no elements in the request body for this task.
Response Body
There are no elements in the response body for this task.
List of Values
This table lists all the list of values of the resource.
| LOV Name | Source Attribute in LOV | Target Attribute in Resource |
|---|---|---|
|
ViewAccessor_CurrencyCode |
CurrencyCode |
CurrencyCode |
|
FK_LOVVA_For___ORACO__Account_c |
OrganizationProfileId |
__ORACO__Account_Id_c |
|
LOVVA_For___ORACO__Account_c |
OrganizationName |
__ORACO__Account_c |
|
LOVVA_For___ORACO__CancelReason_c |
LookupCode |
__ORACO__CancelReason_c |
|
LOVVA_For___ORACO__CancelRequestFlag_c |
value |
__ORACO__CancelRequestFlag_c |
|
LOVVA_For___ORACO__OrderType_c |
LookupCode |
__ORACO__OrderType_c |
|
LOVVA_For___ORACO__ProcessStatus_c |
LookupCode |
__ORACO__ProcessStatus_c |
|
LOVVA_For___ORACO__ReturnReason_c |
LookupCode |
__ORACO__ReturnReason_c |
|
FK_LOVVA_For___ORACO__Route_c |
Id |
__ORACO__Route_Id_c |
|
LOVVA_For___ORACO__Route_c |
RecordName |
__ORACO__Route_c |
|
LOVVA_For___ORACO__UpdateRequestFlag_c |
value |
__ORACO__UpdateRequestFlag_c |
|
FK_LOVVA_For___ORACO__Order_c |
Id |
__ORACO__Order_Id_c |
|
LOVVA_For___ORACO__Order_c |
RecordName |
__ORACO__Order_c |
|
LOVVA_For___ORACO__Source_c |
LookupCode |
__ORACO__Source_c |
|
FK_LOVVA_For___ORACO__LegalEntity_c |
Id |
__ORACO__LegalEntity_Id_c |
|
LOVVA_For___ORACO__LegalEntity_c |
RecordName |
__ORACO__LegalEntity_c |
|
FK_LOVVA_For___ORACO__BusinessUnit_c |
BusinessUnitId |
__ORACO__BusinessUnit_Id_c |
|
LOVVA_For___ORACO__BusinessUnit_c |
Name |
__ORACO__BusinessUnit_c |
Resource Attributes
This table lists all the attributes of the resource.
| Attribute Name | Attribute Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the record. UI Label: Record ID |
|
RowType |
string |
The type of the record. Properties: The maximum length is 80. |
|
RecordName |
string |
The name of the record. Properties: The maximum length is 80. UI Label: Order Request Number |
|
CreatedBy |
string |
The user who created the record. Properties: The maximum length is 32. UI Label: Created By |
|
CreationDate |
datetime |
The date when the record was created. UI Label: Creation Date |
|
LastUpdatedBy |
string |
The user who last updated the record. Properties: The maximum length is 32. UI Label: Last Updated By |
|
LastUpdateDate |
datetime |
The date when the record was last updated. UI Label: Last Update Date |
|
LastUpdateLogin |
string |
The login of the user who last updated the record. Properties: The maximum length is 32. |
|
UserLastUpdateDate |
datetime |
The date and time when the record was last updated from a mobile. |
|
CurrencyCode |
string |
The currency code associated with the record. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. Properties: The maximum length is 15. UI Label: Currency Code |
|
CurcyConvRateType |
string |
The currency conversion rate type. This attribute is used by CRM Extensibility framework. A list of valid values are defined in the lookup ZCA_COMMON_RATE_TYPE. Review and update the profile option using the Setup and Maintenance work area, Manage Currency Profile Options task. Properties: The maximum length is 15. |
|
CorpCurrencyCode |
string |
The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework. A list of accepted values is defined in the lookup ZCA_COMMON_CORPORATE_CURRENCY. Review and update the profile option using the Setup and Maintenance work area, Manage Trading Community Common Lookups task. Properties: The maximum length is 15. |
|
SourceType |
string |
The type of the source object such as Opportunities or Partners as defined in the object metadata. Properties: The maximum length is 0. |
|
__ORACO__Account_Id_c |
integer |
The unique identifier of the account associated with order. UI Label: Account |
|
__ORACO__Account_c |
string |
The name of account associated with the order. Properties: The maximum length is 1500. UI Label: Account |
|
__ORACO__BillToAccountContactID_c |
integer |
The contact identifier of the account to which the order has been billed. UI Label: Bill To Account Contact ID |
|
__ORACO__BillToAddress1_c |
string |
The first line of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 1 |
|
__ORACO__BillToAddress2_c |
string |
The second line of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 2 |
|
__ORACO__BillToAddress3_c |
string |
The third line of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 3 |
|
__ORACO__BillToAddress4_c |
string |
The fourth line of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 4 |
|
__ORACO__BillToCustomerID_c |
integer |
The unique identifier of the customer that the order was billed to. UI Label: Bill To Customer ID |
|
__ORACO__BuyingPartyContactID_c |
integer |
The unique identifier of the contact of the buying party for an order. UI Label: Buying Party Contact ID |
|
__ORACO__BuyingPartyID_c |
integer |
The unique identifier of the buying party for the order. UI Label: Buying Party ID |
|
__ORACO__CancelReason_c |
string |
The reason for canceling the order. Properties: The maximum length is 1500. UI Label: Cancel Reason |
|
__ORACO__CancelRequestFlag_c |
boolean |
Indicates whether the cancellation of the order was requested. Properties: The maximum length is 10. UI Label: Cancellation Requested |
|
__ORACO__Comments_c |
string |
Indicates that comments can be added as required. Properties: The maximum length is 80. UI Label: Comments |
|
__ORACO__Currency_c |
string |
The currency used when placing the order. Properties: The maximum length is 80. UI Label: Currency |
|
__ORACO__CustomerPONumber_c |
string |
The number of the customer purchase order. Properties: The maximum length is 80. UI Label: Customer PO Number |
|
__ORACO__OrderAmount_c |
number |
The total amount of the order. UI Label: Order Amount |
|
__ORACO__OrderRevisionDate_c |
date |
The date when the order was revised. UI Label: Order Revision Date |
|
__ORACO__OrderType_c |
string |
The type of the order. Properties: The maximum length is 1500. UI Label: Order Type |
|
__ORACO__Owner_c |
string |
The name of the owner of the order. Properties: The maximum length is 80. UI Label: Owner |
|
__ORACO__PBillToContactPointID_c |
integer |
The unique identifier of the preferred bill to contact point of the order. UI Label: Preferred Bill To Contact Point ID |
|
__ORACO__PShipToContactPointID_c |
integer |
The unique identifier of the preferred ship to contact point of the order. UI Label: Preferred Ship To Contact Point ID |
|
__ORACO__PSoldToContactPointID_c |
integer |
The unique identifier of the preferred sold to contact point of the order. UI Label: Preferred Sold To Contact Point ID |
|
__ORACO__ProcessStatus_c |
string |
The status of the order. For example, whether the order is ready to be processed or was processed by the downstream application. Properties: The maximum length is 1500. UI Label: Process Status |
|
__ORACO__PromiseDate_c |
date |
The tentative date when the order is expected to be fulfilled. UI Label: Promise Date |
|
__ORACO__RefOrderRN_c |
integer |
The revision Number of the reference order for returning an order. UI Label: Reference Order - Revision Number |
|
__ORACO__RefOrderSS_c |
string |
The source application of the reference order. Properties: The maximum length is 80. UI Label: Reference Order - Source System |
|
__ORACO__RefOrderSSN_c |
integer |
The unique identifier of the reference order in the source application. UI Label: Reference Order - Source System Number |
|
__ORACO__RefOrderNumber_c |
string |
The unique identifier of the reference order in the cloud application. Properties: The maximum length is 80. UI Label: Reference Order Number |
|
__ORACO__RequestedDate_c |
date |
The date requested by the customer for fulfillment of the order. UI Label: Requested Date |
|
__ORACO__RequestingBUID_c |
integer |
The unique identifier of the business unit that placed the order. UI Label: Requesting Business Unit ID |
|
__ORACO__ReturnReason_c |
string |
The reason for returning the order. Properties: The maximum length is 1500. UI Label: Return Reason |
|
__ORACO__OrderRN_c |
integer |
The revision number of the order. UI Label: Revision Number |
|
__ORACO__ShipToAddress1_c |
string |
The first line of the shipping address. Properties: The maximum length is 80. UI Label: Ship To Address 1 |
|
__ORACO__ShipToAddress2_c |
string |
The second line of the shipping address. Properties: The maximum length is 80. UI Label: Ship To Address 2 |
|
__ORACO__ShipToAddress3_c |
string |
The third line of the shipping address. Properties: The maximum length is 80. UI Label: Ship To Address 3 |
|
__ORACO__ShipToAddress4_c |
string |
The fourth line of the shipping address. Properties: The maximum length is 80. UI Label: Ship To Address 4 |
|
__ORACO__ShipToPartyContactID_c |
integer |
The unique identifier of the contact of the party to whom the order is being shipped. UI Label: Ship To Party Contact ID |
|
__ORACO__ShipToPartyID_c |
integer |
The unique identifier of the party to whom the order is being shipped. UI Label: Ship To Party ID |
|
__ORACO__OrderSS_c |
string |
The name of the external source system where the order originated from. Properties: The maximum length is 80. UI Label: Source System |
|
__ORACO__OrderSSN_c |
integer |
The unique identifier of the record in the source application. UI Label: Source System Number |
|
__ORACO__Route_Id_c |
integer |
The unique Identifier of the route associated with the order. UI Label: Route |
|
__ORACO__Route_c |
string |
The name of the route associated with the order. Properties: The maximum length is 1500. UI Label: Route |
|
__ORACO__UpdateRequestFlag_c |
boolean |
Indicates whether an update was requested on the order. Properties: The maximum length is 10. UI Label: Update Requested |
|
__ORACO__Order_Id_c |
integer |
The unique identifier of the order rollup record. UI Label: Order |
|
__ORACO__Order_c |
string |
The order number of the order rollup record. Properties: The maximum length is 1500. UI Label: Order |
|
__ORACO__Source_c |
string |
The originating channel, such as web or mobile, of the order. Properties: The maximum length is 1500. UI Label: Source |
|
__ORACO__AccountName_c |
string |
The name of the account for which an order has been placed. Properties: The maximum length is 80. UI Label: Account Name |
|
__ORACO__CreatedOn_c |
integer |
The date when the order was created. UI Label: Created On |
|
__ORACO__LegalEntity_Id_c |
integer |
The unique Identifier of the legal entity associated with the order. UI Label: Legal Entity |
|
__ORACO__LegalEntity_c |
string |
The name of the legal entity associated with the order. Properties: The maximum length is 1500. UI Label: Legal Entity |
|
__ORACO__BusinessUnit_Id_c |
integer |
The unique identifier of the business unit associated with the order. UI Label: Business Unit |
|
__ORACO__BusinessUnit_c |
string |
The name of the business unit associated with the order. Properties: The maximum length is 1500. UI Label: Business Unit |
|
__ORACO__CreationTime_c |
datetime |
The time at which the order was created. UI Label: Creation Time |
|
__ORACO__AuxiliaryAttribute01_c |
string |
Additional internal fields for development usage. Properties: The maximum length is 80. UI Label: Auxiliary Attribute 01 |
|
__ORACO__AuxiliaryAttribute02_c |
string |
Additional internal fields for development usage. Properties: The maximum length is 80. UI Label: Auxiliary Attribute 02 |
|
__ORACO__AuxiliaryAttribute03_c |
string |
Additional internal fields for development usage. Properties: The maximum length is 80. UI Label: Auxiliary Attribute 03 |
|
__ORACO__AuxiliaryAttribute04_c |
string |
Additional internal fields for development usage. Properties: The maximum length is 80. UI Label: Auxiliary Attribute 04 |
|
__ORACO__AuxiliaryAttribute05_c |
string |
Additional internal fields for development usage. Properties: The maximum length is 80. UI Label: Auxiliary Attribute 05 |
|
__ORACO__AuxiliaryAttribute06_c |
integer |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 06 |
|
__ORACO__AuxiliaryAttribute07_c |
integer |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 07 |
|
__ORACO__AuxiliaryAttribute08_c |
integer |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 08 |
|
__ORACO__AuxiliaryAttribute09_c |
integer |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 09 |
|
__ORACO__AuxiliaryAttribute10_c |
integer |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 10 |
|
__ORACO__AuxiliaryAttribute11_c |
date |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 11 |
|
__ORACO__AuxiliaryAttribute12_c |
date |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 12 |
|
__ORACO__AuxiliaryAttribute13_c |
datetime |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 13 |
|
__ORACO__AuxiliaryAttribute14_c |
datetime |
Additional internal fields for development usage. UI Label: Auxiliary Attribute 14 |