Diagrams


Table

CRM Product

DynamicsDocs.comCRM Product«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«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 5349»CRM IncidentIncidentId [PK]OwningBusinessUnitContractIdOwningUserActualServiceUnitsCaseOriginCode; [,Phone,Email,Web,Face...BilledServiceUnitsCaseTypeCode; [,Question,Problem,Reque...ProductSerialNumberTitleProductIdContractServiceLevelCode; [,Gold,Silve...AccountIdDescriptionContactIdIsDecrementingCreatedOnTicketNumberPriorityCode; [High,Normal,Low]CustomerSatisfactionCode; [,VerySatisf...IncidentStageCode; [DefaultValue]ModifiedOnCreatedByFollowupByModifiedByVersionNumberStateCode; [Active,Resolved,Canceled]SeverityCode; [DefaultValue]StatusCode; [,ProblemSolved,Informatio...ResponsibleContactIdAccountIdName...«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 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<DefaultUoMScheduleId><OrganizationId><DefaultUoMId><PriceLevelId><TransactionCurrencyId><ParentProductId><RegardingObjectId><ProductId><ProductId><ProductId><ProductId><ProductId><OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><PriceLevelId><UoMId><UoMScheduleId><TransactionCurrencyId><TransactionCurrencyId><ExistingCase><MasterId><ParentCaseId><SalesRepId><UoMId><TransactionCurrencyId><SalesRepId><UoMId><TransactionCurrencyId><SalesRepId><UoMId><TransactionCurrencyId><OrganizationId><UoMScheduleId><BaseCurrencyId><OrganizationId><OrganizationId><BaseUoM><TransactionCurrencyId><TransactionCurrencyId>

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

Fields

# Name Type
1 ProductId GUID
2 DefaultUoMScheduleId GUID
3 OrganizationId GUID
4 Name Text100
5 DefaultUoMId GUID
6 PriceLevelId GUID
7 Description BLOB [Memo]
8 ProductTypeCode Option
9 ProductUrl Text250 [URL]
10 Price Decimal
11 IsKit Boolean
12 ProductNumber Text100
13 Size Text200
14 CurrentCost Decimal
15 StockVolume Decimal
16 StandardCost Decimal
17 StockWeight Decimal
18 QuantityDecimal Integer
19 QuantityOnHand Decimal
20 IsStockItem Boolean
21 SupplierName Text100
22 VendorName Text100
23 VendorPartNumber Text100
24 CreatedOn DateTime
25 ModifiedOn DateTime
26 CreatedBy GUID
27 StateCode Option
28 ModifiedBy GUID
29 StatusCode Option
30 VersionNumber BigInteger
31 DefaultUoMIdName Text100 FlowField
32 DefaultUoMScheduleIdName Text200 FlowField
33 PriceLevelIdName Text100 FlowField
34 CreatedByName Text200 FlowField
35 ModifiedByName Text200 FlowField
36 OrganizationIdName Text160 FlowField
37 OverriddenCreatedOn Date
38 TransactionCurrencyId GUID
39 ExchangeRate Decimal
40 UTCConversionTimeZoneCode Integer
41 ImportSequenceNumber Integer
42 TimeZoneRuleVersionNumber Integer
43 TransactionCurrencyIdName Text100 FlowField
44 CurrentCost_Base Decimal
45 Price_Base Decimal
46 StandardCost_Base Decimal
47 CreatedOnBehalfBy GUID
48 CreatedOnBehalfByName Text200 FlowField
49 ModifiedOnBehalfBy GUID
50 ModifiedOnBehalfByName Text200 FlowField
51 EntityImageId GUID
52 ProcessId GUID
53 StageId GUID
54 ParentProductId GUID
55 ParentProductIdName Text100 FlowField
56 ProductStructure Option
57 VendorID Text100
58 TraversedPath Text250
59 ValidFromDate Date
60 ValidToDate Date
61 HierarchyPath Text250

Keys

# Fields
0 ProductId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
OrganizationId CRM Organization OrganizationId 1..n
PriceLevelId CRM Pricelevel PriceLevelId 1..n
ParentProductId CRM Product ProductId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n
DefaultUoMId CRM Uom UoMId 1..n
DefaultUoMScheduleId CRM Uomschedule UoMScheduleId 1..n

Table Relations From Other Tables

From Table From Field
CRM Incident ProductId 1..n
CRM Invoicedetail ProductId 1..n
CRM Post RegardingObjectId 1..n
CRM Product ParentProductId 1..n
CRM Productpricelevel ProductId 1..n
CRM Quotedetail ProductId 1..n
CRM Salesorderdetail ProductId 1..n