Order Statuses
Subcategories: Attachments, Notes
The Order Status resource is used to view, create, update, or delete an order status. The order status object is a record of order status results.
Resource Plural Label |
Order Statuses |
Resource Name |
__ORACO__OrderStatusDSD_c |
Get All Order Statuses
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_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 Status 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 Status
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_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 Status
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the Order Status. |
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 Status
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the Order Status. |
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 Status
Request: PUT
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the Order Status. |
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 Status
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderStatusDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
Name | Type | Description |
---|---|---|
Id |
integer |
The unique identifier of the Order Status. |
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 |
FK_LOVVA_For___ORACO__Order_c |
Id |
__ORACO__Order_Id_c |
LOVVA_For___ORACO__Order_c |
RecordName |
__ORACO__Order_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__Status_c |
LookupCode |
__ORACO__Status_c |
LOVVA_For___ORACO__LastRequestStatus_c |
LookupCode |
__ORACO__LastRequestStatus_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 Status 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 of the last user update made from a personal device. This value is different from LAST_UPDATE_DATE if the record was originally updated in a different database (a different mobile database or the server). |
CurrencyCode |
string |
The currency code. 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. 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 an account associated with an order. UI Label: Account |
__ORACO__Account_c |
string |
The name of the 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 |
Line one of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 1 |
__ORACO__BillToAddress2_c |
string |
Line two of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 2 |
__ORACO__BillToAddress3_c |
string |
Line three of the billing address. Properties: The maximum length is 80. UI Label: Bill To Address 3 |
__ORACO__BillToAddress4_c |
string |
Line four 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 to whom the order was billed. UI Label: Bill To Customer ID |
__ORACO__BuyingPartyContactID_c |
integer |
The contact identifier of the buying party for an order. UI Label: Buying Party Contact ID |
__ORACO__BuyingPartyID_c |
integer |
The 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__CanceledDate_c |
date |
The date on which the order was cancelled. UI Label: Canceled Date |
__ORACO__CancelRequestFlag_c |
boolean |
Indicates whether the cancellation of the order was requested. Properties: The maximum length is 10. UI Label: Cancellation Request Flag |
__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 |
Indicates what currency has been used. Properties: The maximum length is 80. UI Label: Currency |
__ORACO__CustomerPONumber_c |
string |
The customer purchase order number of the order. Properties: The maximum length is 80. UI Label: Customer PO Number |
__ORACO__DeliveredDate_c |
date |
The date on which the order was delivered. UI Label: Delivered Date |
__ORACO__Order_Id_c |
integer |
The internal identifier for the associated order request. UI Label: Order |
__ORACO__Order_c |
string |
The name of the associated order request. Properties: The maximum length is 1500. UI Label: Order |
__ORACO__OrderRN_c |
integer |
The revision number of the associated order request. UI Label: Order - Revision Number |
__ORACO__OrderSS_c |
string |
The source system of the associated order request. Properties: The maximum length is 80. UI Label: Order - Source System |
__ORACO__OrderSSN_c |
integer |
The source system number of the associated order request. UI Label: Order - Source System Number |
__ORACO__OrderAmount_c |
number |
The total amount of the order. UI Label: Order Amount |
__ORACO__OrderNumber_c |
string |
The order number of the associated order request. Properties: The maximum length is 80. UI Label: Order Number |
__ORACO__OrderRevisionDate_c |
date |
The date on which the associated order request was revised. UI Label: Order Revision Date |
__ORACO__OrderStatusDate_c |
date |
The date on which the order status was created. UI Label: Order Status 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 identifier of the preferred sold to contact point of the order. UI Label: Preferred Sold To Contact Point ID |
__ORACO__ProcessStatus_c |
string |
Indicates whether the record 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 for fulfillment of the order. UI Label: Promise Date |
__ORACO__RefOrderRN_c |
integer |
The revision number of the reference order for a return order. UI Label: Reference Order - Revision Number |
__ORACO__RefOrderSS_c |
string |
The source application of the reference order for the return 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 Sales and Fusion Service. 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 identifier of the requesting business unit that placed the order. UI Label: Requesting Business Unit ID |
__ORACO__Response_c |
string |
The field that displays the response from ERP for an order. Properties: The maximum length is 80. UI Label: Response |
__ORACO__ReturnReason_c |
string |
The field which captures the reason for returning the order. Properties: The maximum length is 1500. UI Label: Return Reason |
__ORACO__ReturnedDate_c |
date |
The date on which the order was returned. UI Label: Returned Date |
__ORACO__OrderStatusRN_c |
integer |
The revision number of the order status. UI Label: Revision Number |
__ORACO__Route_Id_c |
integer |
The unique identifier of the route associated with the order. UI Label: Route |
__ORACO__Route_c |
string |
The route identifier of the associated route for the order. Properties: The maximum length is 1500. UI Label: Route |
__ORACO__ShipToAddress1_c |
string |
Line one of the shipping address of the order. Properties: The maximum length is 80. UI Label: Ship To Address 1 |
__ORACO__ShipToAddress2_c |
string |
Line two of the shipping address of the order. Properties: The maximum length is 80. UI Label: Ship To Address 2 |
__ORACO__ShipToAddress3_c |
string |
Line three of the shipping address of the order. Properties: The maximum length is 80. UI Label: Ship To Address 3 |
__ORACO__ShipToAddress4_c |
string |
Line four of the shipping address of the order. Properties: The maximum length is 80. UI Label: Ship To Address 4 |
__ORACO__ShipToPartyContactID_c |
integer |
The 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 identification number of the party receiving the shipment. UI Label: Ship To Party ID |
__ORACO__Status_c |
string |
The final status of the order as in ERP. Properties: The maximum length is 1500. UI Label: Status |
__ORACO__LastRequestStatus_c |
string |
The status of the last order request of the associated order. Properties: The maximum length is 1500. UI Label: Last Request Status |
__ORACO__CreatedOn_c |
integer |
The date on which the order status was created. UI Label: Created On |
__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 |