Diagrams


Table

CRM Productpricelevel

DynamicsDocs.comCRM Productpricelevel«Table 5347»CRM ProductpricelevelPriceLevelIdProductPriceLevelId [PK]UoMIdUoMScheduleIdDiscountTypeIdProductIdPercentageAmountCreatedOnQuantitySellingCode; [NoControl,Whole,...RoundingPolicyCode; [,None,Up,Down,ToN...ModifiedOnPricingMethodCode; [CurrencyAmount,Per...RoundingOptionCode; [,Endsin,Multipleo...RoundingOptionAmountVersionNumberCreatedByModifiedByDiscountTypeIdNameProductIdNamePriceLevelIdNameUoMIdNameUoMScheduleIdNameCreatedByNameModifiedByNameOrganizationIdExchangeRateTransactionCurrencyIdOverriddenCreatedOnImportSequenceNumberAmount_Base...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5362»CRM UomscheduleUoMScheduleId [PK]OrganizationIdNameDescriptionCreatedOnCreatedByModifiedOnModifiedByVersionNumberCreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberBaseUoMNameOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameStateCode; [Active,Inactive]StatusCode; [,Active,Inactive]«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«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<PriceLevelId><UoMId><UoMScheduleId><DiscountTypeId><ProductId><TransactionCurrencyId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><TransactionCurrencyId><PriceLevelId><BaseUoM><UoMScheduleId><DefaultUoMId><DefaultUoMScheduleId><TransactionCurrencyId><TransactionCurrencyId><ParentProductId><TransactionCurrencyId>

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

Fields

# Name Type
1 PriceLevelId GUID
2 ProductPriceLevelId GUID
3 UoMId GUID
4 UoMScheduleId GUID
5 DiscountTypeId GUID
6 ProductId GUID
7 Percentage Decimal
8 Amount Decimal
9 CreatedOn DateTime
10 QuantitySellingCode Option
11 RoundingPolicyCode Option
12 ModifiedOn DateTime
13 PricingMethodCode Option
14 RoundingOptionCode Option
15 RoundingOptionAmount Decimal
16 VersionNumber BigInteger
17 CreatedBy GUID
18 ModifiedBy GUID
19 DiscountTypeIdName Text100 FlowField
20 ProductIdName Text100 FlowField
21 PriceLevelIdName Text100 FlowField
22 UoMIdName Text100 FlowField
23 UoMScheduleIdName Text200 FlowField
24 CreatedByName Text200 FlowField
25 ModifiedByName Text200 FlowField
26 OrganizationId GUID
27 ExchangeRate Decimal
28 TransactionCurrencyId GUID
29 OverriddenCreatedOn Date
30 ImportSequenceNumber Integer
31 Amount_Base Decimal
32 TransactionCurrencyIdName Text100 FlowField
33 RoundingOptionAmount_Base Decimal
34 CreatedOnBehalfBy GUID
35 CreatedOnBehalfByName Text200 FlowField
36 ModifiedOnBehalfBy GUID
37 ModifiedOnBehalfByName Text200 FlowField
38 ProcessId GUID
39 StageId GUID
40 ProductNumber Text100
41 TraversedPath Text250

Keys

# Fields
0 ProductPriceLevelId Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
DiscountTypeId CRM Discounttype DiscountTypeId 1..n
PriceLevelId CRM Pricelevel PriceLevelId 1..n
ProductId CRM Product ProductId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n
UoMId CRM Uom UoMId 1..n
UoMScheduleId CRM Uomschedule UoMScheduleId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n