Diagrams


Table

CRM Salesorderdetail

DynamicsDocs.comCRM Salesorderdetail«Table 5354»CRM SalesorderdetailSalesOrderDetailId [PK]SalesOrderIdSalesRepIdIsProductOverriddenIsCopiedQuantityShippedLineItemNumberQuantityBackorderedUoMIdQuantityCancelledProductIdRequestDeliveryByQuantityPricingErrorCode; [None,DetailError,Mi...ManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountExtendedAmountDescriptionIsPriceOverriddenShipTo_NameTaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«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 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...<SalesOrderId><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 SalesOrderDetailId GUID
2 SalesOrderId GUID
3 SalesRepId GUID
4 IsProductOverridden Boolean
5 IsCopied Boolean
6 QuantityShipped Decimal
7 LineItemNumber Integer
8 QuantityBackordered Decimal
9 UoMId GUID
10 QuantityCancelled Decimal
11 ProductId GUID
12 RequestDeliveryBy Date
13 Quantity Decimal
14 PricingErrorCode Option
15 ManualDiscountAmount Decimal
16 ProductDescription Text250
17 VolumeDiscountAmount Decimal
18 PricePerUnit Decimal
19 BaseAmount Decimal
20 ExtendedAmount Decimal
21 Description BLOB [Memo]
22 IsPriceOverridden Boolean
23 ShipTo_Name Text200
24 Tax Decimal
25 CreatedOn DateTime
26 ShipTo_Line1 Text250
27 CreatedBy GUID
28 ModifiedBy GUID
29 ShipTo_Line2 Text250
30 ShipTo_Line3 Text250
31 ModifiedOn DateTime
32 ShipTo_City Text80
33 ShipTo_StateOrProvince Text50
34 ShipTo_Country Text80
35 ShipTo_PostalCode Text20
36 WillCall Boolean
37 ShipTo_Telephone Text50
38 ShipTo_Fax Text50
39 ShipTo_FreightTermsCode Option
40 ProductIdName Text100 FlowField
41 UoMIdName Text100 FlowField
42 SalesRepIdName Text200 FlowField
43 SalesOrderStateCode Option
44 CreatedByName Text200 FlowField
45 ModifiedByName Text200 FlowField
46 ShipTo_ContactName Text150
47 VersionNumber BigInteger
48 OwningBusinessUnit GUID
49 OwningUser GUID
50 SalesOrderIsPriceLocked Boolean
51 ShipTo_AddressId GUID
52 TimeZoneRuleVersionNumber Integer
53 ImportSequenceNumber Integer
54 UTCConversionTimeZoneCode Integer
55 ExchangeRate Decimal
56 OverriddenCreatedOn Date
57 TransactionCurrencyId GUID
58 BaseAmount_Base Decimal
59 PricePerUnit_Base Decimal
60 TransactionCurrencyIdName Text100 FlowField
61 VolumeDiscountAmount_Base Decimal
62 ExtendedAmount_Base Decimal
63 Tax_Base Decimal
64 ManualDiscountAmount_Base Decimal
65 OwnerId GUID
66 OwnerIdType Option
67 CreatedOnBehalfBy GUID
68 CreatedOnBehalfByName Text200 FlowField
69 ModifiedOnBehalfBy GUID
70 ModifiedOnBehalfByName Text200 FlowField
71 SequenceNumber Integer
72 ParentBundleId GUID
73 ProductTypeCode Option
74 PropertyConfigurationStatus Option
75 ProductAssociationId GUID

Keys

# Fields
0 SalesOrderDetailId Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
ProductId CRM Product ProductId 1..n
SalesOrderId CRM Salesorder SalesOrderId 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