Diagrams


Table

CRM Salesorder

DynamicsDocs.comCRM Salesorder«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 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«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 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 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 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«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 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OpportunityId><QuoteId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><RegardingObjectId><SalesOrderId><SalesOrderId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectOwningBusinessU><SalesRepId><TransactionCurrencyId><OwnerId><OpportunityId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><PriceLevelId><ContactId><CustomerId><ParentContactId><AccountId><CustomerId><ParentAccountId><OwningBusinessUnit><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><OpportunityId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><BusinessUnitId><TransactionCurrencyId><AdministratorId><ParentBusinessUnitId><TransactionCurrencyId><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><TransactionCurrencyId><DefaultPriceLevelId><DefaultPriceLevelId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId>

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

Fields

# Name Type
1 SalesOrderId GUID
2 OpportunityId GUID
3 QuoteId GUID
4 PriorityCode Option
5 SubmitStatus Integer
6 OwningUser GUID
7 SubmitDate Date
8 OwningBusinessUnit GUID
9 SubmitStatusDescription BLOB [Memo]
10 PriceLevelId GUID
11 LastBackofficeSubmit Date
12 AccountId GUID
13 ContactId GUID
14 OrderNumber Text100
15 Name Text250
16 PricingErrorCode Option
17 Description BLOB [Memo]
18 DiscountAmount Decimal
19 FreightAmount Decimal
20 TotalAmount Decimal
21 TotalLineItemAmount Decimal
22 TotalLineItemDiscountAmount Decimal
23 TotalAmountLessFreight Decimal
24 TotalDiscountAmount Decimal
25 RequestDeliveryBy Date
26 TotalTax Decimal
27 ShippingMethodCode Option
28 PaymentTermsCode Option
29 FreightTermsCode Option
30 CreatedBy GUID
31 CreatedOn DateTime
32 ModifiedBy GUID
33 ModifiedOn DateTime
34 StateCode Option
35 StatusCode Option
36 ShipTo_Name Text200
37 VersionNumber BigInteger
38 ShipTo_Line1 Text250
39 ShipTo_Line2 Text250
40 ShipTo_Line3 Text250
41 ShipTo_City Text80
42 ShipTo_StateOrProvince Text50
43 ShipTo_Country Text80
44 ShipTo_PostalCode Text20
45 WillCall Boolean
46 ShipTo_Telephone Text50
47 BillTo_Name Text200
48 ShipTo_FreightTermsCode Option
49 ShipTo_Fax Text50
50 BillTo_Line1 Text250
51 BillTo_Line2 Text250
52 BillTo_Line3 Text250
53 BillTo_City Text80
54 BillTo_StateOrProvince Text50
55 BillTo_Country Text80
56 BillTo_PostalCode Text20
57 BillTo_Telephone Text50
58 BillTo_Fax Text50
59 DiscountPercentage Decimal
60 ContactIdName Text160 FlowField
61 AccountIdName Text160 FlowField
62 OpportunityIdName Text250 FlowField
63 QuoteIdName Text250 FlowField
64 PriceLevelIdName Text100 FlowField
65 CreatedByName Text200 FlowField
66 ModifiedByName Text200 FlowField
67 CustomerId GUID
68 CustomerIdType Option
69 OwnerId GUID
70 OwnerIdType Option
71 BillTo_ContactName Text150
72 BillTo_AddressId GUID
73 ShipTo_AddressId GUID
74 IsPriceLocked Boolean
75 DateFulfilled Date
76 ShipTo_ContactName Text150
77 UTCConversionTimeZoneCode Integer
78 TransactionCurrencyId GUID
79 TimeZoneRuleVersionNumber Integer
80 ImportSequenceNumber Integer
81 ExchangeRate Decimal
82 OverriddenCreatedOn Date
83 TotalLineItemAmount_Base Decimal
84 TotalDiscountAmount_Base Decimal
85 TotalAmountLessFreight_Base Decimal
86 TotalAmount_Base Decimal
87 TransactionCurrencyIdName Text100 FlowField
88 DiscountAmount_Base Decimal
89 FreightAmount_Base Decimal
90 TotalLineItemDiscountAmount_Ba Decimal
91 TotalTax_Base Decimal
92 CreatedOnBehalfBy GUID
93 CreatedOnBehalfByName Text200 FlowField
94 ModifiedOnBehalfBy GUID
95 ModifiedOnBehalfByName Text200 FlowField
96 OwningTeam GUID
97 BillTo_Composite BLOB [Memo]
98 ShipTo_Composite BLOB [Memo]
99 ProcessId GUID
100 StageId GUID
101 EntityImageId GUID
102 TraversedPath Text250

Keys

# Fields
0 SalesOrderId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
CustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
CustomerId CRM Contact ContactId 1..n
OpportunityId CRM Opportunity OpportunityId 1..n
PriceLevelId CRM Pricelevel PriceLevelId 1..n
QuoteId CRM Quote QuoteId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwningTeam CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Invoice SalesOrderId 1..n
CRM Post RegardingObjectId 1..n
CRM Salesorderdetail SalesOrderId 1..n