One sellable/stockable variant of an Item (itemId is required; isDefault marks the item's default variant), carrying its own skuCode, productColor, quantity unit of measure and maximumLotQuantity. This is the grain most transactional lines reference alongside the item: order, quote, opportunity, invoice, shipment, delivery-order, transfer, adjustment, cycle-count, fulfilment, bill, purchase-order, goods-receipt, requisition and field-sales lines all carry a SKU lookup, as do inventory stock and ledger rows, item lots and Assets. Price list rules, discount group rules, tax group rules and scheme conditions/benefits can also target a specific SKU, so pricing and promotions can differ per variant of the same item.
Fields
| Field | Label | Type | Required | What it does |
|---|---|---|---|---|
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
ExternalId | External | Text, unique | ||
Id | Id | Guid | Yes | |
IsDefault | Default | Boolean | ||
ItemId | Item | Lookup → Item | ||
MaximumLotQuantity | Maximum Lot Quantity | Number | ||
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
ProductColor | Product Color | PickList | Values: Red, Blue, Yellow, Orange, Purple, Black, White, Grey. | |
QuantityUnitOfMeasure | Primary UOM | PickList | Values: Each. | |
RecordTypeId | Record Type | Guid, hidden | ||
SKUCode | SKU Code | Text, unique | Yes | |
UIProps | UI Props | Text | ||
UnitOfMeasureOfConversion | UOM Conversion | Number | ||
UpdatedDateTime | Modified Date | DateAndTime | Yes |
Actions
| Action | Label | Type | What it does |
|---|---|---|---|
BulkDelete | Delete | Delete | Delete the selected records. |
Clone | Clone | ServerAction (Clone) | This Button help to clone the item |
Delete | Delete | Delete | Delete |
DeleteInList | Delete | Delete | Delete in a list page |
Edit | Edit | Edit | Edit |
EditInLine | Edit | EditInline | Edit In Page |
EditListHeader | Edit | EditInline | EditListHeader |
EditPopup | Edit | Edit | EditPopup |
New | New | New | New |
NewInLine | New | NewInline | New In Line |
Related entities
- UserAccount — looks up via
ModifiedById - UserAccount — looks up via
CreatedById - UserAccount — looks up via
OwnerId - Item — looks up via
ItemId - InventoryLedger — referenced by via
SKUId - InspectionLine — referenced by via
SKUId - AutoPurchaseOrderLine — referenced by via
SKUId - CycleCountLine — referenced by via
SKUId - ShipmentLine — referenced by via
SKUId - CompensationLine — referenced by via
SKUId - DeliveryOrderLine — referenced by via
SKUId - InvoiceLine — referenced by via
SKUId - DiscountGroupRule — referenced by via
SKUId - ItemRelation — referenced by via
SKUId - OrderLine — referenced by via
SKUId - BillLine — referenced by via
SKUId - PerformanceKPI — referenced by via
SKUId - RequisitionLine — referenced by via
SKUId - ItemGroupMember — referenced by via
SKUId - ItemInventoryAttribute — referenced by via
SKUId - ItemComponent — referenced by via
ComponentSKUId - OpportunityLine — referenced by via
SKUId - ItemMaintenanceSchedule — referenced by via
ItemSKUId - PurchaseOrderLine — referenced by via
SKUId - QuoteLine — referenced by via
SKUId - ItemServiceContract — referenced by via
SKUId - ItemCart — referenced by via
SKUId - ItemLot — referenced by via
SKUId - CreditNoteLine — referenced by via
SKUId - PriceListRule — referenced by via
SKUId - Asset — referenced by via
SKUId - InventoryFulfilmentOrderLine — referenced by via
SKUId - ItemUnitOfMeasure — referenced by via
SKUId - SchemeBenefit — referenced by via
DiscountedSKUId - StoreCategoryItem — referenced by via
SKUId - InventoryFulfilmentAllocationLine — referenced by via
SKUId - ItemAlias — referenced by via
SKUId - ServiceOrderLine — referenced by via
SKUId - GoodsReceiptLine — referenced by via
SKUId - TransferInwardLine — referenced by via
SKUId - ItemLotType — referenced by via
SKUId - InventoryFulfilmentPickingLine — referenced by via
SKUId - InventoryStock — referenced by via
SKUId - IncentiveTarget — referenced by via
SKUId - TransferLine — referenced by via
SKUId - TransferOutwardLine — referenced by via
SKUId - TaxGroupRule — referenced by via
SKUId - ShipmentAssetLine — referenced by via
SKUId - ItemComponent — referenced by via
SKUId - AdjustmentLine — referenced by via
SKUId - Lead — referenced by via
SKUId - SchemeCondition — referenced by via
SKUId
