Route Inventory Transactions
Subcategories: Attachments, Notes
The route inventory transaction resource is used to view, create, update, or delete the route inventory transactions.
|
Resource Plural Label |
Route Inventory Transactions |
|
Resource Name |
__ORACO__RouteInvTransDSD_c |
Get All Route Inventory Transactions
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_c
Request Query Parameters
Use these finder parameters to query the resource:
| Finder Name | Description |
|---|---|
|
Primary Key |
Finds a route inventory transaction 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 a Route Inventory Transaction
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_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 a Route Inventory Transaction
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_c
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the route inventory transaction. |
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 a Route Inventory Transaction
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the route inventory transaction. |
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 a Route Inventory Transaction
Request: PUT
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the route inventory transaction. |
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 a Route Inventory Transaction
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__RouteInvTransDSD_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the route inventory transaction. |
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__Product_c |
InventoryItemId |
__ORACO__Product_Id_c |
|
LOVVA_For___ORACO__Product_c |
Name |
__ORACO__Product_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__TransactionType_c |
LookupCode |
__ORACO__TransactionType_c |
Resource Attributes
This table lists all the attributes of the resource.
| Attribute Name | Attribute Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the route inventory transaction. UI Label: Record ID |
|
RowType |
string |
The type field for the categorization of the records. Properties: The maximum length is 80. |
|
RecordName |
string |
The name of the route inventory transaction. Properties: The maximum length is 80. UI Label: Route Inventory Transaction Number |
|
CreatedBy |
string |
The user who created the route inventory transaction. 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 (i.e. a different mobile database or the server). |
|
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 for which the route inventory transaction is generated. UI Label: Account |
|
__ORACO__Account_c |
string |
The name of the account for which the route inventory transaction is generated. Properties: The maximum length is 1500. UI Label: Account |
|
__ORACO__OrderLineLN_c |
integer |
The line number of the order line related to the inventory transaction. UI Label: Order Line - Line Number |
|
__ORACO__OrderLineRevisionNumber_c |
integer |
Deprecated. UI Label: Order Line - Revision Number (Duplicate) |
|
__ORACO__OrderLineRN_c |
integer |
The revision number of the order line related to the inventory transaction. UI Label: Order Line - Revision Number |
|
__ORACO__OrderLineSS_c |
string |
The application where the order line associated to the inventory transaction originated from. Properties: The maximum length is 80. UI Label: Order Line - Source System |
|
__ORACO__OrderLineSSN_c |
integer |
The unique identifier in the source application of the order line related to the inventory transaction. UI Label: Order Line - Source System Number |
|
__ORACO__OrderLineNumber_c |
string |
The unique identifier of the order line related to the inventory transaction. Properties: The maximum length is 80. UI Label: Order Line Number |
|
__ORACO__OrderNumber_c |
string |
The unique identifier of the order related to the inventory transaction. Properties: The maximum length is 80. UI Label: Order Number |
|
__ORACO__OrganizationID_c |
integer |
The organization identifier of the inventory transaction. UI Label: Organization ID |
|
__ORACO__Product_Id_c |
integer |
The unique identifier of the product associated with a route inventory transaction. UI Label: Product |
|
__ORACO__Product_c |
string |
The name of the product associated with a route inventory transaction. Properties: The maximum length is 1500. UI Label: Product |
|
__ORACO__ReturnReason_c |
string |
The reason for returning an order. Properties: The maximum length is 1500. UI Label: Return Reason |
|
__ORACO__Route_Id_c |
integer |
The unique identifier of the route associated with the inventory transaction. UI Label: Route |
|
__ORACO__Route_c |
string |
The name of the route associated with the inventory transaction. Properties: The maximum length is 1500. UI Label: Route |
|
__ORACO__SellableQuantity_c |
integer |
The total count of products in the route inventory that are in the sellable condition. UI Label: Sellable Quantity |
|
__ORACO__ShipmentLineLN_c |
integer |
The line number of a shipment line related to the inventory transaction. UI Label: Shipment Line - Line Number |
|
__ORACO__ShipmentLineSS_c |
string |
The application where the shipment line related to the inventory transaction originated from. Properties: The maximum length is 80. UI Label: Shipment Line - Source System |
|
__ORACO__ShipmentLineSSN_c |
integer |
The unique identifier in the source application of the shipment line related to the inventory transaction. UI Label: Shipment Line - Source System Number |
|
__ORACO__ShipmentLineNumber_c |
string |
The unique identifier of the shipment line related to the inventory transaction. Properties: The maximum length is 80. UI Label: Shipment Line Number |
|
__ORACO__ShipmentNumber_c |
string |
The unique identifier of the shipment related to the inventory transaction. Properties: The maximum length is 80. UI Label: Shipment Number |
|
__ORACO__RouteInvTransSS_c |
string |
The application where the inventory transaction originated from. Properties: The maximum length is 80. UI Label: Source System |
|
__ORACO__RouteInvTransSSN_c |
integer |
The unique identifier of the route inventory transaction in the source application. UI Label: Source System Number |
|
__ORACO__TransactionDate_c |
date |
The date when the route inventory transaction occurred. UI Label: Transaction Date |
|
__ORACO__TransactionQuantity_c |
integer |
The quantity of the route inventory transaction. UI Label: Transaction Quantity |
|
__ORACO__TransactionType_c |
string |
The type of the route inventory transaction. Properties: The maximum length is 1500. UI Label: Transaction Type |
|
__ORACO__TransferDCID_c |
integer |
The unique identifier of the distribution center related to the route inventory transaction of type transfer. UI Label: Transfer Distribution Center ID |
|
__ORACO__TransferRouteID_c |
integer |
The unique identifier of the route associated with an inventory transaction of type transfer. UI Label: Transfer Route ID |
|
__ORACO__UOM_c |
string |
The unit of measurement used to measure the quantity of the product. Properties: The maximum length is 80. UI Label: UOM |
|
__ORACO__UOMCode_c |
string |
The code indicating the unit of measurement used for the product. Properties: The maximum length is 80. UI Label: UOM Code |
|
__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 |