xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
Auto DMSConsumer Goods DMSSales Force Automation (SFA) FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Item Relation — entity reference
REFERENCE · Last reviewed

Item Relation — entity reference

One allowed pairing of a parent item with a related item. The set of relations for a parent item is the list of items a service order for an asset of that item accepts: when a service order line is added or its item is changed, the line's item must be the Related Item of one of the relations whose Item is the item of the order's asset, or the save is refused with "The selected item is not eligible or not mapped for this asset." The restriction is opt-in: an order with no asset, an asset with no item, or a parent item with no relations is not checked. Labour and part lines are both checked. Existing lines are not re-checked when the asset or the relations change. No other document reads item relations, and the shipped line Item picker is not narrowed by them. Item Relation is in no shipped app; an administrator adds it to an app to maintain it. Records are named from the IR series.

Fields

FieldLabelTypeRequiredWhat it does
CoordinatesCoordinatesTextFree text kept for reference, for example the part's position on an exploded diagram. Shown on the record page only; no process reads it.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
ExternalIdExternalTextAn identifier from an outside system, for imports and integrations. Not shown on any shipped form and not read by any process.
IdIdGuidYes
ItemIdItemLookup → ItemYesThe parent item, normally the model that assets are registered against. Service order lines for an asset of this item may only use the related items listed against it. Required; not shown on the shipped record page, so it can't be changed after saving with the shipped forms.
ItemLotTypeIdItem Lot TypeLookup → ItemLotTypeNot shown on any shipped form and not read by any process.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYesThe relation's number, set automatically on save from the Item Relation Settings document-name setting (series IR, date DDMMYYYY, six-digit counter, hyphen separated).
OwnerIdOwnerLookup → UserAccountYes
PricePriceCurrencyA reference price for the related item. No process reads it; service order lines are priced from price lists.
QuantityQuantityDecimalA reference quantity, for example how many of the related item a typical service uses. No process reads it, and it is not copied onto service order lines.
RecordTypeIdRecord TypeGuid, hidden
RelatedItemIdRelated ItemLookup → ItemThe item allowed with the parent item, such as a part or labour item for that model. A relation without a related item is ignored. The picker lists all items.
SKUIdSKULookup → SKUA variant of the item, kept for reference only. No process reads it.
SubscriptionKeySubscription KeyGuid, hiddenYes
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
CloneCloneServerAction (Clone)Create a copy of this record
DeleteEntityDeleteDeleteDeleteEntity
DeleteHeaderDeleteDeleteDeleteHeader
DeleteListRowDeleteDeleteDelete List Row
EditEntityEditEditEditEntity
EditInLineEntityEditEditInlineEditInLineEntity
EditInLineHeaderEditEditInline, inactiveEditInLineHeader
EditListRowEditEdit, inactiveEditListRow
NewNewNewNew
  • Item — looks up via RelatedItemId
  • SKU — looks up via SKUId
  • Item — looks up via ItemId
  • ItemLotType — looks up via ItemLotTypeId