Diagrams


Table

CRM Discount

DynamicsDocs.comCRM Discount«Table 5365»CRM DiscountDiscountId [PK]DiscountTypeIdLowQuantityHighQuantityPercentageAmountStatusCode; []CreatedOnCreatedByModifiedByModifiedOnDiscountTypeIdNameIsAmountTypeCreatedByNameModifiedByNameVersionNumberOrganizationIdOverriddenCreatedOnTransactionCurrencyIdExchangeRateImportSequenceNumberAmount_BaseTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«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<DiscountTypeId><TransactionCurrencyId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><TransactionCurrencyId><TransactionCurrencyId>

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

Fields

# Name Type
1 DiscountId GUID
2 DiscountTypeId GUID
3 LowQuantity Decimal
4 HighQuantity Decimal
5 Percentage Decimal
6 Amount Decimal
7 StatusCode Option
8 CreatedOn DateTime
9 CreatedBy GUID
10 ModifiedBy GUID
11 ModifiedOn DateTime
12 DiscountTypeIdName Text100 FlowField
13 IsAmountType Boolean
14 CreatedByName Text200 FlowField
15 ModifiedByName Text200 FlowField
16 VersionNumber BigInteger
17 OrganizationId GUID
18 OverriddenCreatedOn Date
19 TransactionCurrencyId GUID
20 ExchangeRate Decimal
21 ImportSequenceNumber Integer
22 Amount_Base Decimal
23 TransactionCurrencyIdName Text100 FlowField
24 CreatedOnBehalfBy GUID
25 CreatedOnBehalfByName Text200 FlowField
26 ModifiedOnBehalfBy GUID
27 ModifiedOnBehalfByName Text200 FlowField

Keys

# Fields
0 DiscountId Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
DiscountTypeId CRM Discounttype DiscountTypeId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n