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
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें