item
Represents inventory and service items, including commercial attributes, contract defaults, measurement details, replenishment settings, and sales and purchasing configuration.
Columns
| Name | Type | ReadOnly | Description |
| auditCreatedBy | String | True |
The user who created the item. |
| auditCreatedDateTime | Datetime | True |
The date and time when the item was created. |
| auditModifiedBy | String | True |
The user who last modified the item. |
| auditModifiedDateTime | Datetime | True |
The date and time when the item was last modified. |
| commercialBrand | String | False |
The brand name associated with this item for commercial purposes. |
| commercialCatalogReference | String | False |
The catalog reference number for this item. |
| commercialCategory | String | False |
The commercial category assigned to this item. |
| commercialColor | String | False |
The color attribute for this item used in commercial contexts. |
| commercialIsGiftCard | Bool | False |
Indicates whether this item is a gift card. |
| commercialIsWebEnabled | Bool | False |
Indicates whether this item is enabled for web sales. |
| commercialSize1 | String | False |
The primary size attribute for this item. |
| commercialSize2 | String | False |
The secondary size attribute for this item. |
| commercialStyle | String | False |
The style attribute for this item used in commercial contexts. |
| commercialSubBrand | String | False |
The sub-brand associated with this item. |
| commercialSubCategory | String | False |
The commercial sub-category assigned to this item. |
| commercialWebLongDescription | String | False |
The long description of this item displayed on the web. |
| commercialWebName | String | False |
The name of this item as displayed on the web. |
| commercialWebShortDiscription | String | False |
The short description of this item displayed on the web. |
| contractDefaultDefaultContractDeferralStatus | String | False |
The default contract deferral status for this item when used on a contract line. |
| contractDefaultDefaultContractDeliveryStatus | String | False |
The default contract delivery status for this item when used on a contract line. |
| contractDefaultIsDefaultBundle | Bool | False |
Indicates whether this item is marked as a default bundle on contracts. |
| contractTermIsProratedPricingAllowed | Bool | False |
Indicates whether prorated pricing is allowed for this item on contract lines. |
| contractTermIsStartDateAndEndDateEnabled | Bool | False |
Indicates whether start and end dates are enabled for this item on contract lines. |
| contractTermNumberOfPeriods | Int | False |
The default number of contract periods for this item. |
| contractTermPeriodsMeasuredIn | String | False |
The unit in which contract periods are measured for this item, such as months or years. |
| costMethod | String | False |
The cost method used to value this item, such as standard or average. |
| dateLastReceived | Date | True |
The date on which this item was last received into inventory. |
| dateLastSold | Date | True |
The date on which this item was last sold. |
| defaultConversionType | String | False |
The default unit of measure conversion type for this item. |
| enableFulfillment | Bool | False |
Indicates whether fulfillment is enabled for this item. |
| entity_Href | String | True |
The URL of the entity associated with this item. |
| entity_Id | String | True |
The Id of the entity associated with this item. |
| entity_Key | String | True |
The system-assigned key of the entity associated with this item. |
| entity_Name | String | True |
The name of the entity associated with this item. |
| extendedDescription | String | False |
The extended description of the item. |
| href | String | True |
The URL of the item resource. |
| id | String | False |
The unique identifier of the item record. |
| inventoryAutoPrintLabel | Bool | False |
Indicates whether labels are automatically printed when this item is received into inventory. |
| inventoryShippingWeight | Decimal | False |
The shipping weight of this item used for inventory and freight calculations. |
| isEnabledForContracts | Bool | False |
Indicates whether this item is enabled for use on contracts. |
| isItemEnabledForMRR | Bool | False |
Indicates whether this item is enabled for monthly recurring revenue calculations. |
| isSuppliesItem | Bool | False |
Indicates whether this item is classified as a supplies item. |
| itemDetailsCondition | String | False |
The physical condition of the item, such as new or refurbished. |
| itemDetailsEngineeringAlert | String | False |
The engineering alert message associated with this item. |
| itemDetailsInternationalArticleNumber | Int | False |
The International Article Number (EAN) assigned to this item. |
| itemDetailsIsApprovedByEngineering | Bool | False |
Indicates whether this item has been approved by engineering. |
| itemDetailsIsApprovedByQualityControl | Bool | False |
Indicates whether this item has been approved by quality control. |
| itemDetailsIsApprovedBySales | Bool | False |
Indicates whether this item has been approved by sales. |
| itemDetailsIsCompliantItem | Bool | False |
Indicates whether this item meets compliance requirements. |
| itemDetailsIsRestrictedItem | Bool | False |
Indicates whether this item is subject to sales or distribution restrictions. |
| itemDetailsIsSafetyItem | Bool | False |
Indicates whether this item is classified as a safety item. |
| itemDetailsPrimaryCountryOfOrigin | String | False |
The primary country of origin for this item. |
| itemDetailsSpecification1 | String | False |
The first technical specification for this item. |
| itemDetailsSpecification2 | String | False |
The second technical specification for this item. |
| itemDetailsSpecification3 | String | False |
The third technical specification for this item. |
| itemDetailsUniversalProductCode | Int | False |
The Universal Product Code (UPC) assigned to this item. |
| itemType | String | False |
The type of item, such as inventory, non-inventory, or service. |
| key [KEY] | String | True |
The system-assigned key that uniquely identifies the item record. |
| kitRevenuePosting | String | False |
The revenue posting method for this item when used as a kit, such as component level or kit level. |
| kitRevenuePrinting | String | False |
The printing method for kit revenue lines, such as component level or kit level. |
| landedCostEnableLandedCost | Bool | False |
Indicates whether landed cost tracking is enabled for this item. |
| measurementsArea | Decimal | False |
The area measurement of this item. |
| measurementsDensity | Decimal | False |
The density measurement of this item. |
| measurementsDensityUnitOfMeasure | String | False |
The unit of measure used for the density of this item. |
| measurementsDurometerUnitOfMeasure | String | False |
The unit of measure used for the durometer hardness of this item. |
| measurementsHeight | Decimal | False |
The height measurement of this item. |
| measurementsInnerDiameter | Decimal | False |
The inner diameter measurement of this item. |
| measurementsLength | Decimal | False |
The length measurement of this item. |
| measurementsMaximumThickness | Decimal | False |
The maximum thickness measurement of this item. |
| measurementsMinimumThickness | Decimal | False |
The minimum thickness measurement of this item. |
| measurementsNetWeight | Decimal | False |
The net weight of this item. |
| measurementsOuterDiameter | Decimal | False |
The outer diameter measurement of this item. |
| measurementsThickness | Decimal | False |
The thickness measurement of this item. |
| measurementsVolume | Decimal | False |
The volume measurement of this item. |
| measurementsWidth | Decimal | False |
The width measurement of this item. |
| name | String | False |
The name of the item. |
| notes | String | False |
Additional notes about the item. |
| poDescription | String | False |
The description of this item as it appears on purchase orders. |
| precisionInventoryPrecision | Int | False |
The number of decimal places used when recording inventory quantities for this item. |
| precisionPurchasingPrecision | Int | False |
The number of decimal places used when recording purchasing quantities for this item. |
| precisionSalesPrecision | Int | False |
The number of decimal places used when recording sales quantities for this item. |
| precisionUpc | String | False |
The UPC precision configuration for this item. |
| productLine_Href | String | True |
The URL of the product line associated with this item. |
| productLine_Id | String | False |
The Id of the product line associated with this item. |
| productLine_Key | String | False |
The system-assigned key of the product line associated with this item. |
| purchasingStandardCost | Decimal | False |
The standard purchasing cost for this item. |
| quantityAllocated | String | True |
The quantity of this item currently allocated to sales orders or other commitments. |
| quantityInTransit | String | True |
The quantity of this item currently in transit between warehouses. |
| quantityOnHand | String | True |
The total quantity of this item currently on hand across all warehouses. |
| quantityOnHold | String | True |
The quantity of this item currently on hold. |
| quantityOnOrder | String | True |
The quantity of this item currently on open purchase orders. |
| quantityReserved | String | True |
The quantity of this item reserved for specific orders or purposes. |
| quantityUncommitted | String | True |
The quantity of this item that is available and not committed to any order. |
| replenishmentEnableReplenishment | Bool | False |
Indicates whether automatic replenishment is enabled for this item. |
| replenishmentForecastDemandInLeadTime | Int | False |
The forecasted demand quantity for this item during the lead time period. |
| replenishmentMaximumOrderQuantity | Int | False |
The maximum order quantity allowed when replenishing this item. |
| replenishmentReorderPoint | Int | False |
The inventory level at which a replenishment order is triggered for this item. |
| replenishmentReorderQuantity | Int | False |
The quantity to order when replenishing this item. |
| replenishmentReplenishmentMethod | String | False |
The method used to replenish this item, such as reorder point or min/max. |
| replenishmentSafetyStock | Int | False |
The minimum safety stock quantity to maintain for this item. |
| replenishmentUnitOfMeasureDefault | String | False |
The default unit of measure used when replenishing this item. |
| salesAllowMultipleTaxGroups | Bool | False |
Indicates whether multiple tax groups can be applied to this item on sales transactions. |
| salesBasePrice | Decimal | False |
The base sales price for this item. |
| salesIsAvailableForBuyToOrder | Bool | False |
Indicates whether this item is available for buy-to-order sales transactions. |
| salesIsAvailableForDropShip | Bool | False |
Indicates whether this item is available for drop-ship sales transactions. |
| salesIsTaxable | Bool | False |
Indicates whether this item is taxable on sales transactions. |
| soDescription | String | False |
The description of this item as it appears on sales orders. |
| status | String | False |
The current status of the item, such as active or inactive. |
| substituteItemId | String | False |
The Id of the substitute item to use when this item is unavailable. |
| trackingEnableBins | Bool | False |
Indicates whether bin tracking is enabled for this item. |
| trackingEnableExpiration | Bool | False |
Indicates whether expiration date tracking is enabled for this item. |
| trackingEnableLotCategory | Bool | False |
Indicates whether lot category tracking is enabled for this item. |
| trackingEnableSerialNo | Bool | False |
Indicates whether serial number tracking is enabled for this item. |
| trackingLotCategory | String | False |
The lot category used for tracking batches of this item. |
| trackingSerialMask | String | False |
The serial number mask pattern used to generate serial numbers for this item. |
| unitOfMeasureGroup_Href | String | True |
The URL of the unit of measure group associated with this item. |
| unitOfMeasureGroup_Id | String | False |
The Id of the unit of measure group associated with this item. |
| unitOfMeasureGroup_Key | String | False |
The system-assigned key of the unit of measure group associated with this item. |
| vsoeCategory | String | False |
The Vendor-Specific Objective Evidence (VSOE) category assigned to this item. |
| vsoeDefaultDeferralStatus | String | False |
The default deferral status used for VSOE revenue recognition on this item. |
| vsoeDefaultDeliveryStatus | String | False |
The default delivery status used for VSOE revenue recognition on this item. |
| ListAggregate_ItemCrossReference | String | False |
The aggregate list of cross-reference records associated with this item. |
| ListAggregate_ItemLandedCost | String | False |
The aggregate list of landed cost records associated with this item. |
| ListAggregate_ItemTaxMap | String | False |
The aggregate list of tax group mappings associated with this item. |
| ListAggregate_ItemVendor | String | False |
The aggregate list of vendor records associated with this item. |
| ListAggregate_KitComponents | String | False |
The aggregate list of kit component records associated with this item. |
| ListAggregate_WarehouseInfo | String | False |
The aggregate list of warehouse inventory information associated with this item. |