Diagrams

Table

CRM Pricelevel

DynamicsDocs.comCRM Pricelevel«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5341»CRM AccountAccountId [PK]AccountCategoryCode; [,PreferredCustom...DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...CustomerTypeCode; [,Competitor,Consult...AccountRatingCode; [DefaultValue]IndustryCode; [,Accounting,Agriculture...TerritoryCode; [DefaultValue]AccountClassificationCode; [DefaultVal...BusinessTypeCode; [DefaultValue]OwningBusinessUnitTraversedPathOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]PrimaryContactIdParticipatesInWorkflowNameAccountNumberRevenueNumberOfEmployeesDescriptionSICOwnershipCode; [,Public,Private,Subsid...MarketCapSharesOutstandingTickerSymbolStockExchangeWebSiteURLFtpSiteURL...«Table 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«Table 5343»CRM OpportunityOpportunityId [PK]PriceLevelIdOpportunityRatingCode; [Hot,Warm,Cold]PriorityCode; [DefaultValue]ContactIdAccountIdNameStepIdDescriptionEstimatedValueStepNameSalesStageCode; [DefaultValue]ParticipatesInWorkflowPricingErrorCode; [None,DetailError,Mi...EstimatedCloseDateCloseProbabilityActualValueActualCloseDateOwningUserOwningBusinessUnitCreatedOnCreatedByModifiedOnModifiedByVersionNumberStateCode; [Open,Won,Lost]StatusCode; [,InProgress,OnHold,Won,Ca...IsRevenueSystemCalculatedContactIdNameAccountIdNamePriceLevelIdName...«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 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5353»CRM SalesorderSalesOrderId [PK]OpportunityIdQuoteIdPriorityCode; [DefaultValue]SubmitStatusOwningUserSubmitDateOwningBusinessUnitSubmitStatusDescriptionPriceLevelIdLastBackofficeSubmitAccountIdContactIdOrderNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountRequestDeliveryByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOn...«Table 5355»CRM InvoiceInvoiceId [PK]OpportunityIdPriorityCode; [DefaultValue]SalesOrderIdOwningUserOwningBusinessUnitLastBackofficeSubmitPriceLevelIdAccountIdContactIdInvoiceNumberNameDescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountCreatedByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...CreatedOnModifiedByModifiedOnStateCode; [Active,Closed<deprecated>,...StatusCode; [,New,PartiallyShipped,Bil...ShipTo_NameVersionNumber...«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«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<OrganizationId><TransactionCurrencyId><DefaultPriceLevelId><DefaultPriceLevelId><PriceLevelId><RegardingObjectId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><TransactionCurrencyId><AccountId><CustomerId><ParentAccountId><RegardingObjectId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><ParentContactId><MasterId><ParentCustomerId><TransactionCurrencyId><ContactId><CustomerId><ParentContactId><RegardingObjectId><ContactId><CustomerId><ContactId><CustomerId><ContactId><CustomerId><TransactionCurrencyId><RegardingObjectId><OpportunityId><OpportunityId><OpportunityId><OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><ProductId><TransactionCurrencyId><OrganizationId><TransactionCurrencyId><ParentProductId><TransactionCurrencyId><QuoteId><TransactionCurrencyId><SalesOrderId><TransactionCurrencyId><BaseCurrencyId><OrganizationId><TransactionCurrencyId>

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

Fields

# Name Type
1 PriceLevelId (PriceLevelId) GUID
2 OrganizationId (OrganizationId) GUID
3 Name (Name) Text100
4 Description (Description) BLOB [Memo]
5 ShippingMethodCode (ShippingMethodCode) Option
6 BeginDate (BeginDate) Date
7 PaymentMethodCode (PaymentMethodCode) Option
8 FreightTermsCode (FreightTermsCode) Option
9 EndDate (EndDate) Date
10 CreatedBy (CreatedBy) GUID
11 CreatedOn (CreatedOn) DateTime
12 ModifiedBy (ModifiedBy) GUID
13 ModifiedOn (ModifiedOn) DateTime
14 StateCode (StateCode) Option
15 VersionNumber (VersionNumber) BigInteger
16 StatusCode (StatusCode) Option
17 CreatedByName (CreatedByName) Text200 FlowField
18 ModifiedByName (ModifiedByName) Text200 FlowField
19 OrganizationIdName (OrganizationIdName) Text160 FlowField
20 ImportSequenceNumber (ImportSequenceNumber) Integer
21 TransactionCurrencyId (TransactionCurrencyId) GUID
22 OverriddenCreatedOn (OverriddenCreatedOn) Date
23 TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) Integer
24 UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) Integer
25 TransactionCurrencyIdName (TransactionCurrencyIdName) Text100 FlowField
26 CreatedOnBehalfBy (CreatedOnBehalfBy) GUID
27 CreatedOnBehalfByName (CreatedOnBehalfByName) Text200 FlowField
28 ModifiedOnBehalfBy (ModifiedOnBehalfBy) GUID
29 ModifiedOnBehalfByName (ModifiedOnBehalfByName) Text200 FlowField
30 ExchangeRate (ExchangeRate) Decimal

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
OrganizationId (OrganizationId) CRM Organization OrganizationId (OrganizationId) 1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy) CRM Systemuser SystemUserId (SystemUserId) 1..n
TransactionCurrencyId (TransactionCurrencyId) CRM Transactioncurrency TransactionCurrencyId (TransactionCurrencyId) 1..n

Table Relations From Other Tables

From Table From Field
CRM Account DefaultPriceLevelId (DefaultPriceLevelId) 1..n
CRM Contact DefaultPriceLevelId (DefaultPriceLevelId) 1..n
CRM Invoice PriceLevelId (PriceLevelId) 1..n
CRM Opportunity PriceLevelId (PriceLevelId) 1..n
CRM Post RegardingObjectId (RegardingObjectId) 1..n
CRM Product PriceLevelId (PriceLevelId) 1..n
CRM Productpricelevel PriceLevelId (PriceLevelId) 1..n
CRM Quote PriceLevelId (PriceLevelId) 1..n
CRM Salesorder PriceLevelId (PriceLevelId) 1..n