Diagrams


Table

CRM Uom

DynamicsDocs.comCRM Uom«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5347»CRM ProductpricelevelPriceLevelIdProductPriceLevelId [PK]UoMIdUoMScheduleIdDiscountTypeIdProductIdPercentageAmountCreatedOnQuantitySellingCode; [NoControl,Whole,...RoundingPolicyCode; [,None,Up,Down,ToN...ModifiedOnPricingMethodCode; [CurrencyAmount,Per...RoundingOptionCode; [,Endsin,Multipleo...RoundingOptionAmountVersionNumberCreatedByModifiedByDiscountTypeIdNameProductIdNamePriceLevelIdNameUoMIdNameUoMScheduleIdNameCreatedByNameModifiedByNameOrganizationIdExchangeRateTransactionCurrencyIdOverriddenCreatedOnImportSequenceNumberAmount_Base...«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5352»CRM QuotedetailQuoteDetailId [PK]QuoteIdSalesRepIdLineItemNumberUoMIdProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionShipTo_NameIsPriceOverriddenTaxShipTo_Line1CreatedOnShipTo_Line2CreatedByModifiedByShipTo_Line3ShipTo_CityModifiedOnShipTo_StateOrProvinceShipTo_CountryShipTo_PostalCodeWillCall...«Table 5354»CRM SalesorderdetailSalesOrderDetailId [PK]SalesOrderIdSalesRepIdIsProductOverriddenIsCopiedQuantityShippedLineItemNumberQuantityBackorderedUoMIdQuantityCancelledProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionIsPriceOverriddenShipTo_NameTaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5356»CRM InvoicedetailInvoiceDetailId [PK]SalesRepIdIsProductOverriddenLineItemNumberIsCopiedInvoiceIdQuantityBackorderedUoMIdProductIdActualDeliveryOnQuantityManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountQuantityCancelledShippingTrackingNumberExtendedAmountDescriptionIsPriceOverriddenShipTo_NamePricingErrorCode; [None,DetailError,Mi...TaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5362»CRM UomscheduleUoMScheduleId [PK]OrganizationIdNameDescriptionCreatedOnCreatedByModifiedOnModifiedByVersionNumberCreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberBaseUoMNameOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameStateCode; [Active,Inactive]StatusCode; [,Active,Inactive]«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...<BaseUoM><UoMScheduleId><RegardingObjectId><UoMId><DefaultUoMId><UoMId><UoMId><UoMId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><UoMScheduleId><ProductId><DefaultUoMScheduleId><ParentProductId><ProductId><ProductId><ProductId><SalesRepId><SalesRepId><SalesRepId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 UoMId GUID
2 BaseUoM GUID
3 Name Text100
4 UoMScheduleId GUID
5 Quantity Decimal
6 CreatedOn DateTime
7 CreatedBy GUID
8 ModifiedBy GUID
9 ModifiedOn DateTime
10 IsScheduleBaseUoM Boolean
11 BaseUoMName Text100 FlowField
12 CreatedByName Text200 FlowField
13 ModifiedByName Text200 FlowField
14 VersionNumber BigInteger
15 OrganizationId GUID
16 ImportSequenceNumber Integer
17 OverriddenCreatedOn Date
18 CreatedOnBehalfBy GUID
19 CreatedOnBehalfByName Text200 FlowField
20 ModifiedOnBehalfBy GUID
21 ModifiedOnBehalfByName Text200 FlowField

Keys

# Fields
0 UoMId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
BaseUoM CRM Uom UoMId 1..n
UoMScheduleId CRM Uomschedule UoMScheduleId 1..n

Table Relations From Other Tables

From Table From Field
CRM Invoicedetail UoMId 1..n
CRM Post RegardingObjectId 1..n
CRM Product DefaultUoMId 1..n
CRM Productpricelevel UoMId 1..n
CRM Quotedetail UoMId 1..n
CRM Salesorderdetail UoMId 1..n
CRM Uom BaseUoM 1..n