DynamicsDocs.com

Diagrams

Table

CRM Product

Fields |
Keys |
Relations To |
Relations From

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

Fields

#	Name	Type
1	ProductId	GUID	ExternalName: productid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the product.
2	DefaultUoMScheduleId	GUID	ExternalName: defaultuomscheduleid ExternalType: Lookup Description: Default unit group for the product. TableRelation: "CRM Uomschedule".UoMScheduleId
3	OrganizationId	GUID	ExternalName: organizationid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the organization associated with the product. TableRelation: "CRM Organization".OrganizationId
4	Name	Text100	ExternalName: name ExternalType: String Description: Name of the product.
5	DefaultUoMId	GUID	ExternalName: defaultuomid ExternalType: Lookup Description: Default unit for the product. TableRelation: "CRM Uom".UoMId
6	PriceLevelId	GUID	ExternalName: pricelevelid ExternalType: Lookup ExternalAccess: Modify Description: Select the default price list for the product. TableRelation: "CRM Pricelevel".PriceLevelId
7	Description	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Description of the product.
8	ProductTypeCode	Option	[SalesInventory,MiscellaneousCharges,Services,FlatFees] OptionOrdinalValues: [1;2;3;4] InitValue: SalesInventory ExternalName: producttypecode ExternalType: Picklist Description: Type of product.
9	ProductUrl	Text250 [URL]	ExternalName: producturl ExternalType: String Description: URL for the Website associated with the product.
10	Price	Decimal	ExternalName: price ExternalType: Money Description: List price of the product.
11	IsKit	Boolean	ExternalName: iskit ExternalType: Boolean Description: Information that specifies whether the product is a kit.
12	ProductNumber	Text100	ExternalName: productnumber ExternalType: String Description: User-defined product ID.
13	Size	Text200	ExternalName: size ExternalType: String Description: Product size.
14	CurrentCost	Decimal	ExternalName: currentcost ExternalType: Money Description: Current cost for the product item. Used in price calculations.
15	StockVolume	Decimal	ExternalName: stockvolume ExternalType: Decimal Description: Stock volume of the product.
16	StandardCost	Decimal	ExternalName: standardcost ExternalType: Money Description: Standard cost of the product.
17	StockWeight	Decimal	ExternalName: stockweight ExternalType: Decimal Description: Stock weight of the product.
18	QuantityDecimal	Integer	MaxValue: 5 ExternalName: quantitydecimal ExternalType: Integer Description: Number of decimal places that can be used in monetary amounts for the product.
19	QuantityOnHand	Decimal	ExternalName: quantityonhand ExternalType: Decimal Description: Quantity of the product in stock.
20	IsStockItem	Boolean	ExternalName: isstockitem ExternalType: Boolean Description: Information about whether the product is a stock item.
21	SupplierName	Text100	ExternalName: suppliername ExternalType: String Description: Name of the product's supplier.
22	VendorName	Text100	ExternalName: vendorname ExternalType: String Description: Name of the product vendor.
23	VendorPartNumber	Text100	ExternalName: vendorpartnumber ExternalType: String Description: Unique part identifier in vendor catalog of this product.
24	CreatedOn	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the product was created.
25	ModifiedOn	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the product was last modified.
26	CreatedBy	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the product. TableRelation: "CRM Systemuser".SystemUserId
27	StateCode	Option	[Active,Retired,Draft,UnderRevision] OptionOrdinalValues: [0;1;2;3] InitValue: Draft ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Status of the product.
28	ModifiedBy	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the product. TableRelation: "CRM Systemuser".SystemUserId
29	StatusCode	Option	[ ,Active,Retired,Draft,UnderRevision] OptionOrdinalValues: [-1;1;2;0;3] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Reason for the status of the product.
30	VersionNumber	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the product.
31	DefaultUoMIdName	Text100	ExternalName: defaultuomidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Uom".Name WHERE (UoMId=FIELD(DefaultUoMId)))	FlowField
32	DefaultUoMScheduleIdName	Text200	ExternalName: defaultuomscheduleidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Uomschedule".Name WHERE (UoMScheduleId=FIELD(DefaultUoMScheduleId)))	FlowField
33	PriceLevelIdName	Text100	ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(PriceLevelId)))	FlowField
34	CreatedByName	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
35	ModifiedByName	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
36	OrganizationIdName	Text160	ExternalName: organizationidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Organization".Name WHERE (OrganizationId=FIELD(OrganizationId)))	FlowField
37	OverriddenCreatedOn	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
38	TransactionCurrencyId	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup Description: Unique identifier of the currency associated with the product. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
39	ExchangeRate	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Exchange rate for the currency associated with the product with respect to the base currency.
40	UTCConversionTimeZoneCode	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
41	ImportSequenceNumber	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
42	TimeZoneRuleVersionNumber	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
43	TransactionCurrencyIdName	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
44	CurrentCost_Base	Decimal	ExternalName: currentcost_base ExternalType: Money ExternalAccess: Read Description: Base currency equivalent of the current cost for the product item.
45	Price_Base	Decimal	ExternalName: price_base ExternalType: Money ExternalAccess: Read Description: Base currency equivalent of the list price of the product
46	StandardCost_Base	Decimal	ExternalName: standardcost_base ExternalType: Money ExternalAccess: Read Description: Base currency equivalent of the standard cost of the product.
47	CreatedOnBehalfBy	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who created the product. TableRelation: "CRM Systemuser".SystemUserId
48	CreatedOnBehalfByName	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
49	ModifiedOnBehalfBy	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the delegate user who last modified the product. TableRelation: "CRM Systemuser".SystemUserId
50	ModifiedOnBehalfByName	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
51	EntityImageId	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.
52	ProcessId	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.
53	StageId	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
54	ParentProductId	GUID	ExternalName: parentproductid ExternalType: Lookup ExternalAccess: Insert Description: Specifies the parent product family hierarchy. TableRelation: "CRM Product".ProductId
55	ParentProductIdName	Text100	ExternalName: parentproductidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Product".Name WHERE (ProductId=FIELD(ParentProductId)))	FlowField
56	ProductStructure	Option	[Product,ProductFamily,ProductBundle] OptionOrdinalValues: [1;2;3] InitValue: Product ExternalName: productstructure ExternalType: Picklist ExternalAccess: Insert Description: Product Structure.
57	VendorID	Text100	ExternalName: vendorid ExternalType: String Description: Unique identifier of vendor supplying the product.
58	TraversedPath	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.
59	ValidFromDate	Date	ExternalName: validfromdate ExternalType: DateTime Description: Date from which this product is valid.
60	ValidToDate	Date	ExternalName: validtodate ExternalType: DateTime Description: Date to which this product is valid.
61	HierarchyPath	Text250	ExternalName: hierarchypath ExternalType: String ExternalAccess: Read Description: Hierarchy path of the product.

Keys

#	Fields
0	ProductId		Clustered: Yes
1	Name

Table Relations To Other Tables

Field	Related Table	Related Field
OrganizationId	CRM Organization	OrganizationId	TableRelation: "CRM Organization".OrganizationId	1..n
PriceLevelId	CRM Pricelevel	PriceLevelId	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
ParentProductId	CRM Product	ProductId	TableRelation: "CRM Product".ProductId	1..n
ModifiedOnBehalfBy	CRM Systemuser	SystemUserId	TableRelation: "CRM Systemuser".SystemUserId	1..n
TransactionCurrencyId	CRM Transactioncurrency	TransactionCurrencyId	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n
DefaultUoMId	CRM Uom	UoMId	TableRelation: "CRM Uom".UoMId	1..n
DefaultUoMScheduleId	CRM Uomschedule	UoMScheduleId	TableRelation: "CRM Uomschedule".UoMScheduleId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Incident	ProductId	TableRelation: "CRM Product".ProductId	1..n
CRM Invoicedetail	ProductId	TableRelation: "CRM Product".ProductId	1..n
CRM Post	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
CRM Product	ParentProductId	TableRelation: "CRM Product".ProductId	1..n
CRM Productpricelevel	ProductId	TableRelation: "CRM Product".ProductId	1..n
CRM Quotedetail	ProductId	TableRelation: "CRM Product".ProductId	1..n
CRM Salesorderdetail	ProductId	TableRelation: "CRM Product".ProductId	1..n