Diagrams

Table

CRM Post

DynamicsDocs.comCRM Post«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5363»CRM OrganizationOrganizationId [PK]NameUserGroupIdPrivilegeUserGroupIdRecurrenceExpansionJobBatchSizRecurrenceExpansionJobBatchIntFiscalPeriodTypeFiscalCalendarStartDateFormatCode; []TimeFormatCode; []CurrencySymbolWeekStartDayCode; []DateSeparatorFullNameConventionCode; [LastNameFirst...NegativeFormatCode; [Brackets,Dash,Das...NumberFormatIsDisabledDisabledReasonKbPrefixCurrentKbNumberCasePrefixCurrentCaseNumberContractPrefixCurrentContractNumberQuotePrefixCurrentQuoteNumberOrderPrefixCurrentOrderNumberInvoicePrefixCurrentInvoiceNumberUniqueSpecifierLength...«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 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«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 5349»CRM IncidentIncidentId [PK]OwningBusinessUnitContractIdOwningUserActualServiceUnitsCaseOriginCode; [,Phone,Email,Web,Face...BilledServiceUnitsCaseTypeCode; [,Question,Problem,Reque...ProductSerialNumberTitleProductIdContractServiceLevelCode; [,Gold,Silve...AccountIdDescriptionContactIdIsDecrementingCreatedOnTicketNumberPriorityCode; [High,Normal,Low]CustomerSatisfactionCode; [,VerySatisf...IncidentStageCode; [DefaultValue]ModifiedOnCreatedByFollowupByModifiedByVersionNumberStateCode; [Active,Resolved,Canceled]SeverityCode; [DefaultValue]StatusCode; [,ProblemSolved,Informatio...ResponsibleContactIdAccountIdName...«Table 5350»CRM IncidentresolutionModifiedOnActualStartCreatedByActualDurationMinutesIsWorkflowCreatedScheduledEndCategoryIsBilledActivityId [PK]StateCode; [Open,Completed,Canceled]DescriptionStatusCode; [,Open,Closed,Canceled]OwnerIdTimeSpentSubjectCreatedOnModifiedByScheduledStartScheduledDurationMinutesVersionNumberActualEndOwningBusinessUnitIncidentIdSubcategoryOwningUserCreatedByNameIncidentIdNameModifiedByNameOwnerIdType; [,systemuser,team]ImportSequenceNumberTimeZoneRuleVersionNumber...«Table 5351»CRM QuoteQuoteId [PK]OwningBusinessUnitOwningUserPriceLevelIdOpportunityIdAccountIdContactIdQuoteNumberRevisionNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightEffectiveFromTotalTaxTotalDiscountAmountEffectiveToExpiresOnClosedOnRequestDeliveryByShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOnModifiedBy...«Table 5352»CRM QuotedetailQuoteDetailId [PK]QuoteIdSalesRepIdLineItemNumberUoMIdProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionShipTo_NameIsPriceOverriddenTaxShipTo_Line1CreatedOnShipTo_Line2CreatedByModifiedByShipTo_Line3ShipTo_CityModifiedOnShipTo_StateOrProvinceShipTo_CountryShipTo_PostalCodeWillCall...«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 5354»CRM SalesorderdetailSalesOrderDetailId [PK]SalesOrderIdSalesRepIdIsProductOverriddenIsCopiedQuantityShippedLineItemNumberQuantityBackorderedUoMIdQuantityCancelledProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionIsPriceOverriddenShipTo_NameTaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«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 5356»CRM InvoicedetailInvoiceDetailId [PK]SalesRepIdIsProductOverriddenLineItemNumberIsCopiedInvoiceIdQuantityBackorderedUoMIdProductIdActualDeliveryOnQuantityManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountQuantityCancelledShippingTrackingNumberExtendedAmountDescriptionIsPriceOverriddenShipTo_NamePricingErrorCode; [None,DetailError,Mi...TaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5357»CRM ContractContractId [PK]OwningBusinessUnitContractServiceLevelCode; [Gold,Silver...ServiceAddressBillToAddressOwningUserContactIdAccountIdBillingAccountIdContractNumberBillingContactIdActiveOnExpiresOnCancelOnTitleContractLanguageBillingStartOnEffectivityCalendarBillingEndOnBillingFrequencyCode; [Monthly,Bimonth...CreatedByCreatedOnModifiedByAllotmentTypeCode; [,NumberofCases,Tim...UseDiscountAsPercentageModifiedOnTotalPriceVersionNumberTotalDiscountStateCode; [Draft,Invoiced,Active,OnHo...NetPrice...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5360»CRM CustomeraddressParentIdCustomerAddressId [PK]AddressNumberAddressTypeCode; [,BillTo,ShipTo,Prima...NamePrimaryContactNameLine1Line2Line3CityStateOrProvinceCountyCountryPostOfficeBoxPostalCodeUTCOffsetFreightTermsCode; [,FOB,NoCharge]UPSZoneLatitudeTelephone1LongitudeShippingMethodCode; [,Airborne,DHL,Fed...Telephone2Telephone3FaxVersionNumberCreatedByCreatedOnModifiedByModifiedOnCreatedByName...«Table 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5362»CRM UomscheduleUoMScheduleId [PK]OrganizationIdNameDescriptionCreatedOnCreatedByModifiedOnModifiedByVersionNumberCreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberBaseUoMNameOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameStateCode; [Active,Inactive]StatusCode; [,Active,Inactive]«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5365»CRM DiscountDiscountId [PK]DiscountTypeIdLowQuantityHighQuantityPercentageAmountStatusCode; []CreatedOnCreatedByModifiedByModifiedOnDiscountTypeIdNameIsAmountTypeCreatedByNameModifiedByNameVersionNumberOrganizationIdOverriddenCreatedOnTransactionCurrencyIdExchangeRateImportSequenceNumberAmount_BaseTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5366»CRM DiscounttypeDiscountTypeId [PK]OrganizationIdNameDescriptionIsAmountTypeStateCode; [Active,Inactive]CreatedOnCreatedByModifiedByModifiedOnVersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameOverriddenCreatedOnTransactionCurrencyIdImportSequenceNumberTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName<OrganizationId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwningBusinessU><RegardingObjectId><RegardingObjectId><BusinessUnitId><TransactionCurrencyId><SalesRepId><SalesRepId><SalesRepId><AdministratorId><BaseCurrencyId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><OrganizationId><DefaultPriceLevelId><OwningBusinessUnit><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><AccountId><CustomerId><ParentAccountId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><CustomerId><AccountId><BillingAccountId><CustomerId><BillingCustomerId><ParentId><DefaultPriceLevelId><OwningBusinessUnit><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><ContactId><CustomerId><ParentContactId><ContactId><ResponsibleContactId><CustomerId><PrimaryContactId><ContactId><CustomerId><ContactId><CustomerId><ContactId><CustomerId><ContactId><BillingContactId><CustomerId><BillingCustomerId><ParentId><PriceLevelId><OwningBusinessUnit><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><OpportunityId><OpportunityId><OpportunityId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><TransactionCurrencyId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><PriceLevelId><UoMId><UoMScheduleId><DiscountTypeId><ProductId><DefaultUoMScheduleId><DefaultUoMId><ParentProductId><ProductId><ProductId><ProductId><ProductId><OwningBusinessUnit><ContractId><OwnerId><OwningTeam><ExistingCase><MasterId><ParentCaseId><IncidentId><OwnerId><OwningTeam><OwningBusinessUnit><OwningBusinessUnit><OwnerId><OwningTeam><QuoteId><QuoteId><UoMId><OwnerId><OwningBusinessUnit><OwnerId><OwningTeam><SalesOrderId><SalesOrderId><UoMId><OwnerId><OwningBusinessUnit><OwnerId><OwningTeam><InvoiceId><UoMId><OwnerId><OwningBusinessUnit><ServiceAddress><BillToAddress><OriginatingContract><OwnerId><OwningTeam><BusinessUnitId><OwnerId><OwningBusinessUnit><BaseUoM><UoMScheduleId><ParentBusinessUnitId><DiscountTypeId>

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

Fields

# Name Type
1 CreatedBy GUID
2 CreatedByName Text200 FlowField
3 CreatedOn DateTime
4 CreatedOnBehalfBy GUID
5 CreatedOnBehalfByName Text200 FlowField
6 OrganizationId GUID
7 OrganizationIdName Text160 FlowField
8 PostId GUID
9 RegardingObjectId GUID
10 RegardingObjectTypeCode Option
11 Source Option
12 Text Text250
13 TimeZoneRuleVersionNumber Integer
14 Type Option
15 UTCConversionTimeZoneCode Integer
16 RegardingObjectOwnerId GUID
17 RegardingObjectOwnerIdType Option
18 RegardingObjectOwningBusinessU GUID
19 ModifiedBy GUID
20 ModifiedByName Text200 FlowField
21 ModifiedOnBehalfBy GUID
22 ModifiedOnBehalfByName Text200 FlowField
23 ModifiedOn DateTime

Keys

# Fields
0 PostId Clustered: Yes
1 Text

Table Relations To Other Tables

Field Related Table Related Field
RegardingObjectId CRM Account AccountId 1..n
RegardingObjectOwningBusinessU CRM Businessunit BusinessUnitId 1..n
RegardingObjectId CRM Contact ContactId 1..n
RegardingObjectId CRM Contract ContractId 1..n
RegardingObjectId CRM Customeraddress CustomerAddressId 1..n
RegardingObjectId CRM Discount DiscountId 1..n
RegardingObjectId CRM Discounttype DiscountTypeId 1..n
RegardingObjectId CRM Incident IncidentId 1..n
RegardingObjectId CRM Incidentresolution ActivityId 1..n
RegardingObjectId CRM Invoice InvoiceId 1..n
RegardingObjectId CRM Invoicedetail InvoiceDetailId 1..n
RegardingObjectId CRM Opportunity OpportunityId 1..n
RegardingObjectId CRM Organization OrganizationId 1..n
RegardingObjectId CRM Post PostId 1..n
RegardingObjectId CRM Pricelevel PriceLevelId 1..n
RegardingObjectId CRM Product ProductId 1..n
RegardingObjectId CRM Productpricelevel ProductPriceLevelId 1..n
RegardingObjectId CRM Quote QuoteId 1..n
RegardingObjectId CRM Quotedetail QuoteDetailId 1..n
RegardingObjectId CRM Salesorder SalesOrderId 1..n
RegardingObjectId CRM Salesorderdetail SalesOrderDetailId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
RegardingObjectOwnerId CRM Team TeamId 1..n
RegardingObjectId CRM Transactioncurrency TransactionCurrencyId 1..n
RegardingObjectId CRM Uom UoMId 1..n
RegardingObjectId CRM Uomschedule UoMScheduleId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n