Diagrams

Table

CRM Discounttype

DynamicsDocs.comCRM Discounttype«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«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 5365»CRM DiscountDiscountId [PK]DiscountTypeIdLowQuantityHighQuantityPercentageAmountStatusCode; []CreatedOnCreatedByModifiedByModifiedOnDiscountTypeIdNameIsAmountTypeCreatedByNameModifiedByNameVersionNumberOrganizationIdOverriddenCreatedOnTransactionCurrencyIdExchangeRateImportSequenceNumberAmount_BaseTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«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><RegardingObjectId><DiscountTypeId><DiscountTypeId><OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><TransactionCurrencyId><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 DiscountTypeId (DiscountTypeId) GUID
2 OrganizationId (OrganizationId) GUID
3 Name (Name) Text100
4 Description (Description) BLOB [Memo]
5 IsAmountType (IsAmountType) Boolean
6 StateCode (StateCode) Option
7 CreatedOn (CreatedOn) DateTime
8 CreatedBy (CreatedBy) GUID
9 ModifiedBy (ModifiedBy) GUID
10 ModifiedOn (ModifiedOn) DateTime
11 VersionNumber (VersionNumber) BigInteger
12 StatusCode (StatusCode) Option
13 CreatedByName (CreatedByName) Text200 FlowField
14 ModifiedByName (ModifiedByName) Text200 FlowField
15 OrganizationIdName (OrganizationIdName) Text160 FlowField
16 OverriddenCreatedOn (OverriddenCreatedOn) Date
17 TransactionCurrencyId (TransactionCurrencyId) GUID
18 ImportSequenceNumber (ImportSequenceNumber) Integer
19 TransactionCurrencyIdName (TransactionCurrencyIdName) Text100 FlowField
20 CreatedOnBehalfBy (CreatedOnBehalfBy) GUID
21 CreatedOnBehalfByName (CreatedOnBehalfByName) Text200 FlowField
22 ModifiedOnBehalfBy (ModifiedOnBehalfBy) GUID
23 ModifiedOnBehalfByName (ModifiedOnBehalfByName) Text200 FlowField

Keys

# Fields
0 DiscountTypeId (DiscountTypeId) 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 Discount DiscountTypeId (DiscountTypeId) 1..n
CRM Post RegardingObjectId (RegardingObjectId) 1..n
CRM Productpricelevel DiscountTypeId (DiscountTypeId) 1..n