Inventories
Subcategories: Attachments, Notes
The inventory resource is used to view, create, update, or delete an inventory.
|
Resource Plural Label |
Inventories |
|
Resource Name |
__ORACO__Inventory_c |
Get All Inventories
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_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 Inventory 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 Inventory
Request: POST
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_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 Inventory
Request: GET
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Inventory. |
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 Inventory
Request: PATCH
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Inventory. |
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 Inventory
Request: PUT
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_c/{Id}
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Inventory. |
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 inventory
Request: DELETE
URI: /crmRestApi/resources/11.13.18.05/__ORACO__Inventory_c/{Id}/child/Note
Request Path Parameters
This table summarizes the request path parameters:
| Name | Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the Inventory. |
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__Product_c |
InventoryItemId |
__ORACO__Product_Id1_c |
|
LOVVA_For___ORACO__Product_c |
Description |
__ORACO__Product_c |
|
FK_LOVVA_For___ORACO__SalesProduct_c |
InventoryItemId |
__ORACO__SalesProduct_Id_c |
|
LOVVA_For___ORACO__SalesProduct_c |
Name |
__ORACO__SalesProduct_c |
Resource Attributes
This table lists all the attributes of the resource.
| Attribute Name | Attribute Type | Description |
|---|---|---|
|
Id |
integer |
The unique identifier of the inventory. UI Label: Record ID |
|
RowType |
string |
The type of the inventory. Properties: The maximum length is 80. |
|
RecordName |
string |
The unique identifier of the inventory item. Properties: The maximum length is 80. UI Label: Inventory ID |
|
CreatedBy |
string |
The user who created the inventory. Properties: The maximum length is 32. UI Label: Created By |
|
CreationDate |
datetime |
The date when the inventory was created. UI Label: Creation Date |
|
LastUpdatedBy |
string |
The user who last updated the inventory. Properties: The maximum length is 32. UI Label: Last Updated By |
|
LastUpdateDate |
datetime |
The date when the inventory was last updated. UI Label: Last Update Date |
|
LastUpdateLogin |
string |
The login of the user who last updated the inventory. Properties: The maximum length is 32. |
|
CpdrfVerSor |
integer |
A system-generated read-only attribute used by the application framework. |
|
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). |
|
CpdrfLastUpd |
string |
A system-generated read-only attribute used by the application framework. Properties: The maximum length is 15. |
|
CpdrfVerPillar |
integer |
A system-generated read-only attribute used by the application framework. |
|
JobDefinitionPackage |
string |
A system-generated read-only attribute used by the application framework. Enterprise Service Scheduler: The name of the package running the job that created or last updated the row. Properties: The maximum length is 900. |
|
RequestId |
integer |
The request identifier of the job that created or last updated the row. |
|
JobDefinitionName |
string |
The short name the job that created or last updated the row. Properties: The maximum length is 100. |
|
CurrencyCode |
string |
The currency code associated with the inventory. 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 |
|
CurcyConvRateType |
string |
The currency conversion rate type associated with the inventory. 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 of the inventory. 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. |
|
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. |
|
AttachmentEntityName |
string |
The name of the object or table that is associated with the attachments for this object. Properties: The maximum length is 0. |
|
PKProxy |
string |
A system-generated read-only attribute used by the application framework. Properties: The maximum length is 18. |
|
IsOwner |
string |
A system-generated read-only attribute used by the application framework. Properties: The maximum length is 0. |
|
__ORACO__inventoryDate_c |
date |
The date when the inventory was created. UI Label: inventory Date |
|
__ORACO__Facing_c |
integer |
The quantity of product that is turned towards the front edge of a shelf. This must be less than the shelf stock quantity. UI Label: Facing |
|
__ORACO__Location_c |
string |
The location of the product. Properties: The maximum length is 1000. UI Label: Location |
|
__ORACO__Product_Id1_c |
integer |
The unique identifier of the product. UI Label: Product |
|
__ORACO__Product_Id2_c |
integer |
The alternate identifier of the product. This value is not visible in the UI. UI Label: __ORACO__Product_Id2_c |
|
__ORACO__Product_c |
string |
The name of the product. Properties: The maximum length is 1500. UI Label: Product |
|
__ORACO__ShelfStock_c |
integer |
The quantity of product that is stocked in the shelf. This must be less than the Facing quantity. UI Label: Shelf Stock |
|
__ORACO__UnitPrice_c |
string |
The unit price of an item. Properties: The maximum length is 0. UI Label: Unit Price |
|
__ORACO__UOM_c |
string |
The standard of measuring the quantity of the items in the inventory. Properties: The maximum length is 0. UI Label: UOM |
|
Organization_Id___ORACO__Account_Inventory |
integer |
The unique identifier of the account. |
|
__ORACO__SalesProduct_Id_c |
integer |
The unique identifier of a product. UI Label: Product |
|
__ORACO__SalesProduct_c |
string |
The name of the associated Product. Properties: The maximum length is 1500. UI Label: Product |
|
__ORACO__UOMValue_c |
string |
The unit of measure associated with the product. Properties: The maximum length is 80. UI Label: UOM |