Order Line Rollups
Subcategories: Attachments, Notes
The Order Line Rollup resource is used to view, create, update, and delete Order Line Rollups.
|
Resource Plural Label |
Order Line Rollups |
|
Resource Name |
__ORACO__OrderLineRollup_c |
Get All Order Line Rollups
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_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 Line Rollup 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 Line Rollup
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_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 Line Rollup
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Line Rollup. |
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 Line Rollup
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Line Rollup. |
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 Line Rollup
Request: PUT
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Line Rollup. |
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 Line Rollup
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__OrderLineRollup_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Order Line Rollup. |
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 |
|
FK_LOVVA_For___ORACO__Order_c |
Id |
__ORACO__Order_Id_c |
|
LOVVA_For___ORACO__Order_c |
RecordName |
__ORACO__Order_c |
|
FK_LOVVA_For___ORACO__Product_c |
InventoryItemId |
__ORACO__Product_Id_c |
|
LOVVA_For___ORACO__Product_c |
Name |
__ORACO__Product_c |
|
LOVVA_For___ORACO__ProductCondition_c |
LookupCode |
__ORACO__ProductCondition_c |
|
FK_LOVVA_For___ORACO__Promotion_c |
Id |
__ORACO__Promotion_Id_c |
|
LOVVA_For___ORACO__Promotion_c |
RecordName |
__ORACO__Promotion_c |
|
LOVVA_For___ORACO__ReturnReason_c |
LookupCode |
__ORACO__ReturnReason_c |
|
LOVVA_For___ORACO__Status_c |
LookupCode |
__ORACO__Status_c |
|
LOVVA_For___ORACO__LastRequestStatus_c |
LookupCode |
__ORACO__LastRequestStatus_c |
|
LOVVA_For___ORACO__Source_c |
LookupCode |
__ORACO__Source_c |
|
LOVVA_For___ORACO__UpdateRequestFlag_c |
value |
__ORACO__UpdateRequestFlag_c |
|
FK_LOVVA_For___ORACO__ComboGroup_c |
Id |
__ORACO__ComboGroup_Id_c |
|
LOVVA_For___ORACO__ComboGroup_c |
__ORACO__Name_c |
__ORACO__ComboGroup_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 Line 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 the account associated with the order line. UI Label: Account |
|
__ORACO__Account_c |
string |
The name of the account associated with the order line. Properties: The maximum length is 1500. UI Label: Account |
|
__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__CustomerPOLNumber_c |
string |
The customer purchase order number of the order. Properties: The maximum length is 80. UI Label: Customer PO Line Number |
|
__ORACO__Discount_c |
number |
The discount percentage applied to the order line. UI Label: Discount |
|
__ORACO__TotalDiscount_c |
number |
The total discount applied to the order line. UI Label: Total Discount |
|
__ORACO__DiscountedPrice_c |
number |
The discounted price for the order line product. UI Label: Price |
|
__ORACO__OrderLineLN_c |
integer |
The line number of the order line. UI Label: Line Number |
|
__ORACO__OrderLRevisionDate_c |
date |
The date on which the order line was revised. UI Label: Order Line Revision Date |
|
__ORACO__Order_Id_c |
integer |
The unique identifier of the order request of the parent order of an order line. UI Label: Order |
|
__ORACO__Order_c |
string |
The order request number of the parent order of an order line. Properties: The maximum length is 1500. UI Label: Order |
|
__ORACO__Product_Id_c |
integer |
The unique identifier of the product of the order line. UI Label: Product |
|
__ORACO__Product_c |
string |
The name of the product of the order line. Properties: The maximum length is 1500. UI Label: Product |
|
__ORACO__ProductCondition_c |
string |
The condition of the order line product. Properties: The maximum length is 1500. UI Label: Product Condition |
|
__ORACO__Promotion_Id_c |
integer |
The unique identifier of the promotion applied to the associated order line. UI Label: Promotion |
|
__ORACO__Promotion_c |
string |
The record name of the promotion applied to the associated order line. Properties: The maximum length is 1500. UI Label: Promotion |
|
__ORACO__Quantity_c |
integer |
The quantity of the order line product. UI Label: Quantity |
|
__ORACO__QuantDelAtCreate_c |
integer |
The quantity of the order line product delivered for an ad hoc order. UI Label: Quantity Delivered at Creation |
|
__ORACO__RefOrderLineLN_c |
integer |
The line number of the reference order line for a return order. UI Label: Reference Order Line - Line Number |
|
__ORACO__RefOrderLineRN_c |
integer |
The revision number of the reference order line. UI Label: Reference Order Line - Revision Number |
|
__ORACO__RefOrderLineSS_c |
string |
The source application of the reference order line for the return order. Properties: The maximum length is 80. UI Label: Reference Order Line - Source System |
|
__ORACO__RefOrderLineSSN_c |
integer |
The unique identifier of the reference order line in the source application. UI Label: Reference Order Line - Source System Number |
|
__ORACO__RefOrderLineNumber_c |
string |
The unique identifier of the reference order line in Sales and Fusion Service. Properties: The maximum length is 80. UI Label: Reference Order Line Number |
|
__ORACO__RequestedDate_c |
date |
The customer requested date for the fulfillment of the order line. UI Label: Requested Date |
|
__ORACO__Response_c |
string |
The response from ERP for the order line. Properties: The maximum length is 80. UI Label: Response |
|
__ORACO__ReturnReason_c |
string |
The reason for returning an order for an order line. Properties: The maximum length is 1500. UI Label: Return Reason |
|
__ORACO__OrderLineRN_c |
integer |
The revision number of the order line. UI Label: Revision Number |
|
__ORACO__OrderLineSS_c |
string |
The application from which the order line originated. Properties: The maximum length is 80. UI Label: Source System |
|
__ORACO__OrderLineSSN_c |
integer |
The unique identifier of the order record in the source application. UI Label: Source System Number |
|
__ORACO__TotalPrice_c |
number |
The total amount of the order line. UI Label: Total |
|
__ORACO__UnitPrice_c |
number |
The list price for the order line product. UI Label: List Price |
|
__ORACO__UOM_c |
string |
The standard of measuring the quantity of the product in the order line. Properties: The maximum length is 80. UI Label: UOM |
|
__ORACO__UOMCode_c |
string |
The code of the unit of measure of the product in the order line. Properties: The maximum length is 80. UI Label: UOM Code |
|
__ORACO__DeliveredDate_c |
date |
The fulfilled delivery date of the order line. UI Label: Delivered Date |
|
__ORACO__DeliveredQuantity_c |
integer |
The count of the order line that was delivered. UI Label: Delivered Quantity |
|
__ORACO__Status_c |
string |
The status of the order request from ERP. Properties: The maximum length is 1500. UI Label: Status |
|
__ORACO__LastRequestStatus_c |
string |
The status of the last request made for the order line. Properties: The maximum length is 1500. UI Label: Last Request Status |
|
__ORACO__ShipmentLineLN_c |
integer |
The line number of the shipment line related to the order line. UI Label: Shipment Line - Line Number |
|
__ORACO__ShipmentLineSS_c |
string |
The application from which the related shipment line originated. Properties: The maximum length is 80. UI Label: Shipment Line - Source System |
|
__ORACO__ShipmentLineSSN_c |
integer |
The unique identifier of the related shipment line in the source application. UI Label: Shipment Line - Source System Number |
|
__ORACO__ShipmentLineNumber_c |
string |
The unique identifier of the related shipment line. Properties: The maximum length is 80. UI Label: Shipment Line Number |
|
__ORACO__OrderNumber_c |
string |
The unique identifier of the parent order of the order line. Properties: The maximum length is 80. UI Label: Order Number |
|
__ORACO__OrderLineDate_c |
date |
The date on which the order line was created. UI Label: Order Line Date |
|
__ORACO__Source_c |
string |
The originating channel of the order line, such as web or mobile. Properties: The maximum length is 1500. UI Label: Source |
|
__ORACO__UpdateRequestFlag_c |
boolean |
The option to request an update of the order line. Properties: The maximum length is 10. UI Label: Update Requested |
|
__ORACO__ProductName_c |
string |
The name of the product used in the order line. Properties: The maximum length is 240. UI Label: Product Name |
|
__ORACO__ComboSelectionQuantity_c |
integer |
The product quantity selected for the combo group of the dynamic combo promotion to which the order line request belongs. This is only needed for an order line request that is part of a dynamic combo promotion. UI Label: Combo Selection Quantity |
|
__ORACO__ComboQuantity_c |
integer |
The quantity of the combo for the fixed or dynamic combo promotion to which the order line request belongs. This is only needed for an order line request that is part of a fixed or dynamic combo promotion. UI Label: Combo Quantity |
|
__ORACO__DiscountedQuantity_c |
integer |
The quantity for which discount is given. UI Label: Discounted Quantity |
|
__ORACO__ComboGroup_Id_c |
integer |
The unique identifier of the combination group associated with the promotion for the product. UI Label: Combo Group |
|
__ORACO__ComboGroup_c |
string |
The name of the combination group associated with the promotion for the product. Properties: The maximum length is 1500. UI Label: Combo Group |
|
__ORACO__PromotionName_c |
string |
The name of the promotion. Properties: The maximum length is 80. UI Label: Promotion Name |
|
__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 |