Diagrams


Table

CRM Quotedetail

DynamicsDocs.comCRM Quotedetail«Table 5352»CRM QuotedetailQuoteDetailId [PK]QuoteIdSalesRepIdLineItemNumberUoMIdProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionShipTo_NameIsPriceOverriddenTaxShipTo_Line1CreatedOnShipTo_Line2CreatedByModifiedByShipTo_Line3ShipTo_CityModifiedOnShipTo_StateOrProvinceShipTo_CountryShipTo_PostalCodeWillCall...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...<QuoteId><SalesRepId><UoMId><ProductId><TransactionCurrencyId><OwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId><AdministratorId><BaseUoM><DefaultUoMId><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 QuoteDetailId GUID
2 QuoteId GUID
3 SalesRepId GUID
4 LineItemNumber Integer
5 UoMId GUID
6 ProductId GUID
7 RequestDeliveryBy Date
8 Quantity Decimal
9 PricingErrorCode Option
10 ManualDiscountAmount Decimal
11 ProductDescription Text250
12 VolumeDiscountAmount Decimal
13 PricePerUnit Decimal
14 BaseAmount Decimal
15 ExtendedAmount Decimal
16 Description BLOB [Memo]
17 ShipTo_Name Text200
18 IsPriceOverridden Boolean
19 Tax Decimal
20 ShipTo_Line1 Text250
21 CreatedOn DateTime
22 ShipTo_Line2 Text250
23 CreatedBy GUID
24 ModifiedBy GUID
25 ShipTo_Line3 Text250
26 ShipTo_City Text80
27 ModifiedOn DateTime
28 ShipTo_StateOrProvince Text50
29 ShipTo_Country Text80
30 ShipTo_PostalCode Text20
31 WillCall Boolean
32 IsProductOverridden Boolean
33 ShipTo_Telephone Text50
34 ShipTo_Fax Text50
35 ShipTo_FreightTermsCode Option
36 ProductIdName Text100 FlowField
37 UoMIdName Text100 FlowField
38 SalesRepIdName Text200 FlowField
39 QuoteStateCode Option
40 CreatedByName Text200 FlowField
41 ModifiedByName Text200 FlowField
42 OwningUser GUID
43 ShipTo_AddressId GUID
44 ShipTo_ContactName Text150
45 OwningBusinessUnit GUID
46 VersionNumber BigInteger
47 ImportSequenceNumber Integer
48 UTCConversionTimeZoneCode Integer
49 OverriddenCreatedOn Date
50 TransactionCurrencyId GUID
51 ExchangeRate Decimal
52 TimeZoneRuleVersionNumber Integer
53 Tax_Base Decimal
54 ExtendedAmount_Base Decimal
55 PricePerUnit_Base Decimal
56 TransactionCurrencyIdName Text100 FlowField
57 BaseAmount_Base Decimal
58 ManualDiscountAmount_Base Decimal
59 VolumeDiscountAmount_Base Decimal
60 OwnerId GUID
61 OwnerIdType Option
62 CreatedOnBehalfBy GUID
63 CreatedOnBehalfByName Text200 FlowField
64 ModifiedOnBehalfBy GUID
65 ModifiedOnBehalfByName Text200 FlowField
66 SequenceNumber Integer
67 PropertyConfigurationStatus Option
68 ProductAssociationId GUID
69 ParentBundleId GUID
70 ProductTypeCode Option

Keys

# Fields
0 QuoteDetailId Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
ProductId CRM Product ProductId 1..n
QuoteId CRM Quote QuoteId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwnerId CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n
UoMId CRM Uom UoMId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n