CRM Product

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

Keys

#	Fields
0	ProductId (ProductId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

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

Table Relations From Other Tables

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