CRM Salesorderdetail

Diagrams

Table

CRM Salesorderdetail

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

Fields

#	Name	Type
1	SalesOrderDetailId (SalesOrderDetailId)	GUID	ExternalName: salesorderdetailid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the product specified in the order.
2	SalesOrderId (SalesOrderId)	GUID	ExternalName: salesorderid ExternalType: Lookup Description: Shows the order for the product. The ID is used to link product pricing and other details to the total amounts and other information on the order. TableRelation: "CRM Salesorder".SalesOrderId
3	SalesRepId (SalesRepId)	GUID	ExternalName: salesrepid ExternalType: Lookup Description: Choose the user responsible for the sale of the order product. TableRelation: "CRM Systemuser".SystemUserId
4	IsProductOverridden (IsProductOverridden)	Boolean	ExternalName: isproductoverridden ExternalType: Boolean ExternalAccess: Insert Description: Select whether the product exists in the Microsoft Dynamics CRM product catalog or is a write-in product specific to the order.
5	IsCopied (IsCopied)	Boolean	ExternalName: iscopied ExternalType: Boolean Description: Select whether the invoice line item is copied from another item or data source.
6	QuantityShipped (QuantityShipped)	Decimal	ExternalName: quantityshipped ExternalType: Decimal Description: Type the amount or quantity of the product that was shipped for the order.
7	LineItemNumber (LineItemNumber)	Integer	MaxValue: 1000000000 ExternalName: lineitemnumber ExternalType: Integer Description: Type the line item number for the order product to easily identify the product in the order and make sure it's listed in the correct sequence.
8	QuantityBackordered (QuantityBackordered)	Decimal	ExternalName: quantitybackordered ExternalType: Decimal Description: Type the amount or quantity of the product that is back ordered for the order.
9	UoMId (UoMId)	GUID	ExternalName: uomid ExternalType: Lookup Description: Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. TableRelation: "CRM Uom".UoMId
10	QuantityCancelled (QuantityCancelled)	Decimal	ExternalName: quantitycancelled ExternalType: Decimal Description: Type the amount or quantity of the product that was canceled.
11	ProductId (ProductId)	GUID	ExternalName: productid ExternalType: Lookup Description: Choose the product to include on the order to link the product's pricing and other information to the parent order. TableRelation: "CRM Product".ProductId
12	RequestDeliveryBy (RequestDeliveryBy)	Date	ExternalName: requestdeliveryby ExternalType: DateTime Description: Enter the delivery date requested by the customer for the order product.
13	Quantity (Quantity)	Decimal	ExternalName: quantity ExternalType: Decimal Description: Type the amount or quantity of the product ordered by the customer.
14	PricingErrorCode (PricingErrorCode)	Option	[None,DetailError,MissingPriceLevel,InactivePriceLevel,MissingQuantity,MissingUnitPrice,MissingProduct,InvalidProduct,MissingPricingCode,InvalidPricingCode,MissingUOM,ProductNotInPriceLevel,MissingPriceLevelAmount,MissingPriceLevelPercentage,MissingPrice,MissingCurrentCost,MissingStandardCost,InvalidPriceLevelAmount,InvalidPriceLevelPercentage,InvalidPrice,InvalidCurrentCost,InvalidStandardCost,InvalidRoundingPolicy,InvalidRoundingOption,InvalidRoundingAmount,PriceCalculationError,InvalidDiscountType,DiscountTypeInvalidState,InvalidDiscount,InvalidQuantity,InvalidPricingPrecision,MissingProductDefaultUOM,MissingProductUOMSchedule,InactiveDiscountType,InvalidPriceLevelCurrency,PriceAttributeOutOfRange,BaseCurrencyAttributeOverflow,BaseCurrencyAttributeUnderflow] OptionOrdinalValues: [0;1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37] InitValue: None ExternalName: pricingerrorcode ExternalType: Picklist Description: Select the type of pricing error, such as a missing or invalid product, or missing quantity.
15	ManualDiscountAmount (ManualDiscountAmount)	Decimal	ExternalName: manualdiscountamount ExternalType: Money Description: Type the manual discount amount for the order product to deduct any negotiated or other savings from the product total on the order.
16	ProductDescription (ProductDescription)	Text250	ExternalName: productdescription ExternalType: String Description: Type a name or description to identify the type of write-in product included in the order.
17	VolumeDiscountAmount (VolumeDiscountAmount)	Decimal	ExternalName: volumediscountamount ExternalType: Money ExternalAccess: Read Description: Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area.
18	PricePerUnit (PricePerUnit)	Decimal	ExternalName: priceperunit ExternalType: Money Description: Type the price per unit of the order product. The default is the value in the price list specified on the order for existing products.
19	BaseAmount (BaseAmount)	Decimal	ExternalName: baseamount ExternalType: Money ExternalAccess: Modify Description: Shows the total price of the order product, based on the price per unit, volume discount, and quantity.
20	ExtendedAmount (ExtendedAmount)	Decimal	ExternalName: extendedamount ExternalType: Money ExternalAccess: Modify Description: Shows the total amount due for the order product, based on the sum of the unit price, quantity, discounts, and tax.
21	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information to describe the order product, such as manufacturing details or acceptable substitutions.
22	IsPriceOverridden (IsPriceOverridden)	Boolean	ExternalName: ispriceoverridden ExternalType: Boolean Description: Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the order product.
23	ShipTo_Name (ShipTo_Name)	Text200	ExternalName: shipto_name ExternalType: String Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address.
24	Tax (Tax)	Decimal	ExternalName: tax ExternalType: Money Description: Type the tax amount for the order product.
25	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
26	ShipTo_Line1 (ShipTo_Line1)	Text250	ExternalName: shipto_line1 ExternalType: String Description: Type the first line of the customer's shipping address.
27	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
28	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
29	ShipTo_Line2 (ShipTo_Line2)	Text250	ExternalName: shipto_line2 ExternalType: String Description: Type the second line of the customer's shipping address.
30	ShipTo_Line3 (ShipTo_Line3)	Text250	ExternalName: shipto_line3 ExternalType: String Description: Type the third line of the shipping address.
31	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
32	ShipTo_City (ShipTo_City)	Text80	ExternalName: shipto_city ExternalType: String Description: Type the city for the customer's shipping address.
33	ShipTo_StateOrProvince (ShipTo_StateOrProvince)	Text50	ExternalName: shipto_stateorprovince ExternalType: String Description: Type the state or province for the shipping address.
34	ShipTo_Country (ShipTo_Country)	Text80	ExternalName: shipto_country ExternalType: String Description: Type the country or region for the customer's shipping address.
35	ShipTo_PostalCode (ShipTo_PostalCode)	Text20	ExternalName: shipto_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the shipping address.
36	WillCall (WillCall)	Boolean	ExternalName: willcall ExternalType: Boolean Description: Select whether the order product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions.
37	ShipTo_Telephone (ShipTo_Telephone)	Text50	ExternalName: shipto_telephone ExternalType: String Description: Type the phone number for the customer's shipping address.
38	ShipTo_Fax (ShipTo_Fax)	Text50	ExternalName: shipto_fax ExternalType: String Description: Type the fax number for the customer's shipping address.
39	ShipTo_FreightTermsCode (ShipTo_FreightTermsCode)	Option	[ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: shipto_freighttermscode ExternalType: Picklist Description: Select the freight terms to make sure shipping orders are processed correctly.
40	ProductIdName (ProductIdName)	Text100	ExternalName: productidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Product".Name WHERE (ProductId=FIELD(ProductId)))	FlowField
41	UoMIdName (UoMIdName)	Text100	ExternalName: uomidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Uom".Name WHERE (UoMId=FIELD(UoMId)))	FlowField
42	SalesRepIdName (SalesRepIdName)	Text200	ExternalName: salesrepidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(SalesRepId)))	FlowField
43	SalesOrderStateCode (SalesOrderStateCode)	Option	[ ] OptionOrdinalValues: -1 InitValue: [ ] ExternalName: salesorderstatecode ExternalType: Picklist ExternalAccess: Read Description: Shows the status of the order that the order detail is associated with.
44	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
45	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
46	ShipTo_ContactName (ShipTo_ContactName)	Text150	ExternalName: shipto_contactname ExternalType: String Description: Type the primary contact name at the customer's shipping address.
47	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the sales order detail.
48	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Uniqueidentifier ExternalAccess: Read Description: Unique identifier of the business unit that owns the order product.
49	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Uniqueidentifier ExternalAccess: Read Description: Unique identifier of the user who owns the order product.
50	SalesOrderIsPriceLocked (SalesOrderIsPriceLocked)	Boolean	ExternalName: salesorderispricelocked ExternalType: Boolean ExternalAccess: Read Description: Tells whether product pricing is locked for the order.
51	ShipTo_AddressId (ShipTo_AddressId)	GUID	ExternalName: shipto_addressid ExternalType: Uniqueidentifier Description: Unique identifier of the shipping address.
52	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
53	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
54	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
55	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
56	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
57	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup ExternalAccess: Read Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
58	BaseAmount_Base (BaseAmount_Base)	Decimal	ExternalName: baseamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area.
59	PricePerUnit_Base (PricePerUnit_Base)	Decimal	ExternalName: priceperunit_base ExternalType: Money ExternalAccess: Read Description: Shows the Price Per Unit field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
60	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
61	VolumeDiscountAmount_Base (VolumeDiscountAmount_Base)	Decimal	ExternalName: volumediscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Volume Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
62	ExtendedAmount_Base (ExtendedAmount_Base)	Decimal	ExternalName: extendedamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Extended Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area.
63	Tax_Base (Tax_Base)	Decimal	ExternalName: tax_base ExternalType: Money ExternalAccess: Read Description: Shows the Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
64	ManualDiscountAmount_Base (ManualDiscountAmount_Base)	Decimal	ExternalName: manualdiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Manual Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
65	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner ExternalAccess: Read Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
66	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName ExternalAccess: Read
67	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
68	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
69	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
70	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
71	SequenceNumber (SequenceNumber)	Integer	ExternalName: sequencenumber ExternalType: Integer Description: Shows the ID of the data that maintains the sequence.
72	ParentBundleId (ParentBundleId)	GUID	ExternalName: parentbundleid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Choose the parent bundle associated with this product
73	ProductTypeCode (ProductTypeCode)	Option	[Product,Bundle,RequiredBundleProduct,OptionalBundleProduct] OptionOrdinalValues: [1;2;3;4] InitValue: Product ExternalName: producttypecode ExternalType: Picklist ExternalAccess: Insert Description: Product Type
74	PropertyConfigurationStatus (PropertyConfigurationStatus)	Option	[Edit,Rectify,NotConfigured] OptionOrdinalValues: [0;1;2] InitValue: NotConfigured ExternalName: propertyconfigurationstatus ExternalType: Picklist Description: Status of the property configuration.
75	ProductAssociationId (ProductAssociationId)	GUID	ExternalName: productassociationid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the product line item association with bundle in the sales order

Keys

#	Fields
0	SalesOrderDetailId (SalesOrderDetailId)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
ProductId (ProductId)	CRM Product	ProductId (ProductId)	TableRelation: "CRM Product".ProductId	1..n
SalesOrderId (SalesOrderId)	CRM Salesorder	SalesOrderId (SalesOrderId)	TableRelation: "CRM Salesorder".SalesOrderId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwnerId (OwnerId)	CRM Team	TeamId (TeamId)	TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n
UoMId (UoMId)	CRM Uom	UoMId (UoMId)	TableRelation: "CRM Uom".UoMId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n