API Catalog

Create an Inventory Item

06 Jan 2025
3 Minutes to read

Print
Dark
Light

Create an Inventory Item

Updated on 06 Jan 2025
3 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Post

/ci-rest-api/rest/1/ciitem

Create Inventory Items

UI Location: ASSET MANAGEMENT - Inventory - Setup - Item Master

Security

HTTP

Type basic

Basic authentication

Header parameters

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourceItem+json

Body parameters

object

Example{ "CiitemCompCode": "001", "CiitemItemCode": "1262", "CiitemBbPriceOrPctCode": "C", "CiitemWriAccCode": "50700", "CiitemRevAccCode": "40015", "CiitemInvAccCode": "17010", "CiitemSuspAccCode": "17040", "CiitemVarAccCode": "50720", "CiitemItemClassCode": "29", "CiitemCostUpdateLevelCode": "I", "CiitemCostMethCode": "AVG", "CiitemSellPriceOrPctCode": "C", "CiitemAdjAccCode": "50711", "CiitemWmCode": "EA", "CiitemSerialFlag": "N", "CiitemMsAvailableFlag": "N", "CiitemAutoBuildCmpFlag": "N", "CiitemUsageCode": "N", "CiitemAltWmAllowFlag": "N", "CiitemLotCtrlFlag": "N", "CiitemVUuid": "" }

CiitemInvAccCode

string Required

Inventory account. Reference to the ACCOUNT table.

💻 UI Fieldname: Inventory Account

Max length16

CiitemWriAccCode

string Required

Write-off account. Reference to the ACCOUNT table.

💻 UI Fieldname: Write Off Account

Max length16

CiitemCompCode

string Required

Key value 1; Company code

💻 UI Fieldname: Company

Max length8

CiitemCostUpdateLevelCode

string Required

If using the Average Cost method of inventory valuation, specify whether to update the average cost of this inventory item by the total inventory (‘I’), or by the inventory within a specified location (‘L’).

💻 UI Fieldname: Average Cost Update Level

Max length1

CiitemRevAccCode

string Required

Revenue account. Reference to the ACCOUNT table.

💻 UI Fieldname: Internal Issue Revenue Account

Max length16

CiitemAutoBuildCmpFlag

string Required

Auto build cmp Flag

💻 UI Fieldname: Auto-Build Composite

Max length1

CiitemSerialFlag

string Required

‘Y’ if the item is serialized, ‘N’ if not.

💻 UI Fieldname: Serialized

Max length1

CiitemAdjAccCode

string Required

Adjustment account. Reference to the ACCOUNT table.

💻 UI Fieldname: Adjustment Account

Max length16

CiitemVarAccCode

string Required

Variance account. Reference to the ACCOUNT table.

💻 UI Fieldname: Variance Account

Max length16

CiitemMsAvailableFlag

string Required

item available flag

💻 UI Fieldname: Available For MS System

Max length1

CiitemVUuid

string Required

Unique Row ID, leave empty

💻 UI Fieldname: CiitemVUuid

Max length64

CiitemCostMethCode

string Required

One of AVG (average cost), SF (standard FIFO), F (modified FIFO) and STD (standard cost). The validation program does not check but this should be the same value as in the item’s class.

💻 UI Fieldname: CiitemCostMethCode

Max length3

CiitemLotCtrlFlag

string Required

‘Y’ or ‘N’. Set this to ‘N’ unless CIITEM_SERIAL_FLAG = ‘Y’ and CIITEM_COST_METH_CODE = ’F’

💻 UI Fieldname: CiitemLotCtrlFlag

Max length1

CiitemSuspAccCode

string Required

Suspense account. Reference to the ACCOUNT table.

💻 UI Fieldname: Suspense Account

Max length16

CiitemItemClassCode

string Required

Key value 3; Reference (with CIITEM_COMP_CODE) to a class defined in the CICLASS table.

💻 UI Fieldname: Class Code

Max length4

CiitemUsageCode

string Required

Not used. Set this to ‘N’

💻 UI Fieldname: CiitemUsageCode

Max length1

CiitemWmCode

string Required

Reference to a weight/measure code defined in WGTMES_TABLE

💻 UI Fieldname: WM

Max length2

CiitemBbPriceOrPctCode

string Required

‘P’ if the buyback price is entered explicitly. ‘C’ if it calculated as a percentage of the cost price.

💻 UI Fieldname: Buy Back

Max length1

CiitemItemCode

string Required

Key value 2; Inventory item code or number. If the fixed length flag is set in the control file, this code must be of the length specified in the control file.

💻 UI Fieldname: Item Code

Max length16

CiitemSellPriceOrPctCode

string Required

‘P’ if the selling price is entered explicitly, ‘C’ if it calculated as a percentage of the cost price.

💻 UI Fieldname: Issue At

Max length1

CiitemAltWmAllowFlag

string Required

‘Y’ if alternate unit conversions are enabled. ‘N’ if not.

💻 UI Fieldname: Average Cost Update Level

Max length1

Responses

201

Created

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourceitem+json

{
  "CiitemAccumDeprAccCode": null,
  "CiitemAccumDeprAccName": null,
  "CiitemAdjAccCode": "50711",
  "CiitemAdjAccName": null,
  "CiitemAffilRevAccCode": null,
  "CiitemAffilRevAccName": null,
  "CiitemAllowNegQtyFlag": null,
  "CiitemAltWmAllowFlag": "N",
  "CiitemAutoBuildCmpFlag": "N",
  "CiitemBbPriceOrPctCode": "C",
  "CiitemBbPriceOrPctName": null,
  "CiitemBuybackPriceAmt": null,
  "CiitemClassName": null,
  "CiitemCmpFlag": null,
  "CiitemCompCode": "001",
  "CiitemCompName": null,
  "CiitemCostMethCode": "AVG",
  "CiitemCostMethName": null,
  "CiitemCostUpdateLevelCode": "I",
  "CiitemCostUpdateLevelName": null,
  "CiitemCreditJcCatCode": null,
  "CiitemCreditJcCatName": null,
  "CiitemCrtDate": null,
  "CiitemCrtUserCode": null,
  "CiitemCustRevAccCode": null,
  "CiitemCustRevAccName": null,
  "CiitemDefaultItemTypeCode": null,
  "CiitemDefaultLocCode": null,
  "CiitemDeprExpAccCode": null,
  "CiitemDeprExpAccName": null,
  "CiitemEmCostComponCode": null,
  "CiitemEmCostComponName": null,
  "CiitemImageFilename": null,
  "CiitemInvAccCode": "17010",
  "CiitemInvAccName": null,
  "CiitemInventoryItemCode": null,
  "CiitemInventoryItemName": null,
  "CiitemItemClassCode": "29",
  "CiitemItemCode": "1262",
  "CiitemItemDesc": null,
  "CiitemItemFixedLengthFlag": null,
  "CiitemItemLengthValue": null,
  "CiitemItemName": null,
  "CiitemIuCreateDate": null,
  "CiitemIuUpdateDate": null,
  "CiitemLastModifyDate": null,
  "CiitemLastModifyUserCode": null,
  "CiitemLotCtrlFlag": "N",
  "CiitemMarketPriceAmt": null,
  "CiitemMaxOnhandQty": null,
  "CiitemMaxOrderQty": null,
  "CiitemMinOnhandQty": null,
  "CiitemMinOrderQty": null,
  "CiitemMsAvailableFlag": "N",
  "CiitemMsptCode": null,
  "CiitemMszpcCode": null,
  "CiitemPartialDasmblFlag": null,
  "CiitemProdFlag": null,
  "CiitemRestockPriceAmt": null,
  "CiitemRevAccCode": "40015",
  "CiitemRevAccName": null,
  "CiitemRtrnFlag": null,
  "CiitemSalesProductFlag": null,
  "CiitemSalesTax1Code": null,
  "CiitemSalesTax1Name": null,
  "CiitemSalesTax2Code": null,
  "CiitemSalesTax2Name": null,
  "CiitemSalesTax3Code": null,
  "CiitemSalesTax3Name": null,
  "CiitemSellPriceAmt": null,
  "CiitemSellPriceOrPctCode": "C",
  "CiitemSellPriceOrPctName": null,
  "CiitemSerialFlag": "N",
  "CiitemSoldAtCostAccCode": null,
  "CiitemSoldAtCostAccName": null,
  "CiitemStdOnhandQty": null,
  "CiitemStdOrderQty": null,
  "CiitemSuspAccCode": "17040",
  "CiitemSuspAccName": null,
  "CiitemTax1Code": null,
  "CiitemTax1Name": null,
  "CiitemTax2Code": null,
  "CiitemTax2Name": null,
  "CiitemTax3Code": null,
  "CiitemTax3Name": null,
  "CiitemUsageCode": "N",
  "CiitemUsageName": null,
  "CiitemVUuid": "F29114ACA41A1C56E05316821FACAC2F",
  "CiitemVarAccCode": "50720",
  "CiitemVarAccName": null,
  "CiitemVelocityCode": null,
  "CiitemWmCode": "EA",
  "CiitemWmName": null,
  "CiitemWriAccCode": "50700",
  "CiitemWriAccName": null,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciitem/F29114ACA41A1C56E05316821FACAC2F",
      "name": "ciitem",
      "kind": "item"
    },
    {
      "rel": "canonical",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/ci-rest-api/rest/1/ciitem/F29114ACA41A1C56E05316821FACAC2F",
      "name": "ciitem",
      "kind": "item"
    }
  ]
}

object

What's Next

Retrieve Inventory Items By Code

Create an Inventory Item

Create Inventory Items

What's Next

Contact Us