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

Keys

# Fields
0 UoMId (UoMId) Clustered: Yes
1 Name (Name)

Table Relations To Other Tables

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

Table Relations From Other Tables

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