Unit (UoM) table/entity reference
Note
Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.
Unit of measure.
Added by: Product Management Solution
Messages
| Message | Web API Operation | SDK class or method |
|---|---|---|
| Create | POST /uoms See Create |
CreateRequest or Create |
| Delete | DELETE /uoms(uomid) See Delete |
DeleteRequest or Delete |
| Retrieve | GET /uoms(uomid) See Retrieve |
RetrieveRequest or Retrieve |
| RetrieveMultiple | GET /uoms See Query Data |
RetrieveMultipleRequest or RetrieveMultiple |
| Update | PATCH /uoms(uomid) See Update |
UpdateRequest or Update |
Properties
| Property | Value |
|---|---|
| CollectionSchemaName | UoMs |
| DisplayCollectionName | Units |
| DisplayName | Unit |
| EntitySetName | uoms |
| IsBPFEntity | False |
| LogicalCollectionName | uoms |
| LogicalName | uom |
| OwnershipType | None |
| PrimaryIdAttribute | uomid |
| PrimaryNameAttribute | name |
| SchemaName | UoM |
Writable columns/attributes
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
- BaseUoM
- ImportSequenceNumber
- Name
- OverriddenCreatedOn
- Quantity
- TimeZoneRuleVersionNumber
- UoMId
- UoMScheduleId
- UTCConversionTimeZoneCode
BaseUoM
| Property | Value |
|---|---|
| Description | Choose the base or primary unit on which the unit is based. |
| DisplayName | Base Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | baseuom |
| RequiredLevel | ApplicationRequired |
| Targets | uom |
| Type | Lookup |
ImportSequenceNumber
| Property | Value |
|---|---|
| Description | Sequence number of the import that created this record. |
| DisplayName | Import Sequence Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | importsequencenumber |
| MaxValue | 2147483647 |
| MinValue | -2147483648 |
| RequiredLevel | None |
| Type | Integer |
Name
| Property | Value |
|---|---|
| Description | Type a descriptive title or name for the unit of measure. |
| DisplayName | Name |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | name |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
OverriddenCreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time that the record was migrated. |
| DisplayName | Record Created On |
| Format | DateOnly |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | overriddencreatedon |
| RequiredLevel | None |
| Type | DateTime |
Quantity
| Property | Value |
|---|---|
| Description | Unit quantity for the product. |
| DisplayName | Quantity |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | quantity |
| MaxValue | 10000000000 |
| MinValue | 0 |
| Precision | 5 |
| RequiredLevel | ApplicationRequired |
| Type | Decimal |
TimeZoneRuleVersionNumber
| Property | Value |
|---|---|
| Description | For internal use only. |
| DisplayName | Time Zone Rule Version Number |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | timezoneruleversionnumber |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
UoMId
| Property | Value |
|---|---|
| Description | Unique identifier of the unit. |
| DisplayName | Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | uomid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
UoMScheduleId
| Property | Value |
|---|---|
| Description | Choose the ID of the unit group that the unit is associated with. |
| DisplayName | Unit Schedule |
| IsValidForForm | False |
| IsValidForRead | True |
| IsValidForUpdate | False |
| LogicalName | uomscheduleid |
| RequiredLevel | SystemRequired |
| Targets | uomschedule |
| Type | Lookup |
UTCConversionTimeZoneCode
| Property | Value |
|---|---|
| Description | Time zone code that was in use when the record was created. |
| DisplayName | UTC Conversion Time Zone Code |
| Format | None |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | utcconversiontimezonecode |
| MaxValue | 2147483647 |
| MinValue | -1 |
| RequiredLevel | None |
| Type | Integer |
Read-only columns/attributes
These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.
- BaseUoMName
- CreatedBy
- CreatedByExternalParty
- CreatedByExternalPartyName
- CreatedByExternalPartyYomiName
- CreatedByName
- CreatedByYomiName
- CreatedOn
- CreatedOnBehalfBy
- CreatedOnBehalfByName
- CreatedOnBehalfByYomiName
- IsScheduleBaseUoM
- ModifiedBy
- ModifiedByExternalParty
- ModifiedByExternalPartyName
- ModifiedByExternalPartyYomiName
- ModifiedByName
- ModifiedByYomiName
- ModifiedOn
- ModifiedOnBehalfBy
- ModifiedOnBehalfByName
- ModifiedOnBehalfByYomiName
- OrganizationId
- UoMScheduleIdName
- VersionNumber
BaseUoMName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | baseuomname |
| MaxLength | 100 |
| RequiredLevel | SystemRequired |
| Type | String |
CreatedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who created the unit. |
| DisplayName | Created By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who created the record. |
| DisplayName | Created By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | createdbyexternalparty |
| RequiredLevel | None |
| Targets | externalparty |
| Type | Lookup |
CreatedByExternalPartyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyexternalpartyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByExternalPartyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyexternalpartyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the unit was created. |
| DisplayName | Created On |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdon |
| RequiredLevel | None |
| Type | DateTime |
CreatedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who created the uom. |
| DisplayName | Created By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
CreatedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
CreatedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | createdonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
IsScheduleBaseUoM
| Property | Value |
|---|---|
| Description | Tells whether the unit is the base unit for the associated unit group. |
| DisplayName | Is Schedule Base Unit |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | isschedulebaseuom |
| RequiredLevel | None |
| Type | Boolean |
IsScheduleBaseUoM Choices/Options
| Value | Label | Description |
|---|---|---|
| 1 | Yes | |
| 0 | No |
DefaultValue: 0
ModifiedBy
| Property | Value |
|---|---|
| Description | Unique identifier of the user who last modified the unit. |
| DisplayName | Modified By |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedByExternalParty
| Property | Value |
|---|---|
| Description | Shows the external party who modified the record. |
| DisplayName | Modified By (External Party) |
| IsValidForForm | True |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalparty |
| RequiredLevel | None |
| Targets | externalparty |
| Type | Lookup |
ModifiedByExternalPartyName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalpartyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByExternalPartyYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyexternalpartyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOn
| Property | Value |
|---|---|
| DateTimeBehavior | UserLocal |
| Description | Date and time when the unit was last modified. |
| DisplayName | Modified On |
| Format | DateAndTime |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedon |
| RequiredLevel | None |
| Type | DateTime |
ModifiedOnBehalfBy
| Property | Value |
|---|---|
| Description | Unique identifier of the delegate user who last modified the uom. |
| DisplayName | Modified By (Delegate) |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfby |
| RequiredLevel | None |
| Targets | systemuser |
| Type | Lookup |
ModifiedOnBehalfByName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyname |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
ModifiedOnBehalfByYomiName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | modifiedonbehalfbyyominame |
| MaxLength | 100 |
| RequiredLevel | None |
| Type | String |
OrganizationId
| Property | Value |
|---|---|
| Description | Unique identifier of the organization associated with the unit of measure. |
| DisplayName | Organization |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | organizationid |
| RequiredLevel | SystemRequired |
| Type | Uniqueidentifier |
UoMScheduleIdName
| Property | Value |
|---|---|
| Description | |
| DisplayName | |
| FormatName | Text |
| IsLocalizable | False |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | uomscheduleidname |
| MaxLength | 200 |
| RequiredLevel | None |
| Type | String |
VersionNumber
| Property | Value |
|---|---|
| Description | Version Number |
| DisplayName | Version Number |
| IsValidForForm | False |
| IsValidForRead | True |
| LogicalName | versionnumber |
| MaxValue | 9223372036854775807 |
| MinValue | -9223372036854775808 |
| RequiredLevel | None |
| Type | BigInt |
One-To-Many Relationships
Listed by SchemaName.
- unit_of_measurement_base_unit
- unit_of_measurement_products
- unit_of_measurement_productassociation
- unit_of_measurement_product_price_levels
- unit_of_measurement_invoice_details
- unit_of_measurement_opportunity_products
- unit_of_measurement_order_details
- unit_of_measurement_quote_details
unit_of_measurement_base_unit
Same as the unit_of_measurement_base_unit many-to-one relationship for the uom table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | uom |
| ReferencingAttribute | baseuom |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_base_unit |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Cascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_products
Same as the unit_of_measurement_products many-to-one relationship for the product table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | product |
| ReferencingAttribute | defaultuomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_products |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_productassociation
Same as the unit_of_measurement_productassociation many-to-one relationship for the productassociation table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | productassociation |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_productassociation |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_product_price_levels
Same as the unit_of_measurement_product_price_levels many-to-one relationship for the productpricelevel table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | productpricelevel |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_product_price_levels |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_invoice_details
Added by: Sales Solution
Same as the unit_of_measurement_invoice_details many-to-one relationship for the invoicedetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | invoicedetail |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_invoice_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_opportunity_products
Added by: Sales Solution
Same as the unit_of_measurement_opportunity_products many-to-one relationship for the opportunityproduct table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | opportunityproduct |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_opportunity_products |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_order_details
Added by: Sales Solution
Same as the unit_of_measurement_order_details many-to-one relationship for the salesorderdetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | salesorderdetail |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_order_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
unit_of_measurement_quote_details
Added by: Sales Solution
Same as the unit_of_measurement_quote_details many-to-one relationship for the quotedetail table/entity.
| Property | Value |
|---|---|
| ReferencingEntity | quotedetail |
| ReferencingAttribute | uomid |
| IsHierarchical | False |
| IsCustomizable | False |
| ReferencedEntityNavigationPropertyName | unit_of_measurement_quote_details |
| AssociatedMenuConfiguration | Behavior: DoNotDisplay Group: Details Label: Order: |
| CascadeConfiguration | Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade Share: NoCascade Unshare: NoCascade |
Many-To-One Relationships
Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.
unit_of_measurement_base_unit
See the unit_of_measurement_base_unit one-to-many relationship for the uom table/entity.
unit_of_measure_schedule_conversions
See the unit_of_measure_schedule_conversions one-to-many relationship for the uomschedule table/entity.
See also
Feedback
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under: https://aka.ms/ContentUserFeedback.
Indsend og få vist feedback om