CRM Productpricelevel

Diagrams

Table

CRM Productpricelevel

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	PriceLevelId (PriceLevelId)	GUID	ExternalName: pricelevelid ExternalType: Lookup ExternalAccess: Insert Description: Unique identifier of the price level associated with this price list. TableRelation: "CRM Pricelevel".PriceLevelId
2	ProductPriceLevelId (ProductPriceLevelId)	GUID	ExternalName: productpricelevelid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the price list.
3	UoMId (UoMId)	GUID	ExternalName: uomid ExternalType: Lookup Description: Unique identifier of the unit for the price list. TableRelation: "CRM Uom".UoMId
4	UoMScheduleId (UoMScheduleId)	GUID	ExternalName: uomscheduleid ExternalType: Lookup Description: Unique identifier of the unit schedule for the price list. TableRelation: "CRM Uomschedule".UoMScheduleId
5	DiscountTypeId (DiscountTypeId)	GUID	ExternalName: discounttypeid ExternalType: Lookup Description: Unique identifier of the discount list associated with the price list. TableRelation: "CRM Discounttype".DiscountTypeId
6	ProductId (ProductId)	GUID	ExternalName: productid ExternalType: Lookup Description: Product associated with the price list. TableRelation: "CRM Product".ProductId
7	Percentage (Percentage)	Decimal	ExternalName: percentage ExternalType: Decimal Description: Percentage for the price list.
8	Amount (Amount)	Decimal	ExternalName: amount ExternalType: Money Description: Monetary amount for the price list.
9	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the price list was created.
10	QuantitySellingCode (QuantitySellingCode)	Option	[NoControl,Whole,WholeandFractional] OptionOrdinalValues: [1;2;3] InitValue: NoControl ExternalName: quantitysellingcode ExternalType: Picklist Description: Quantity of the product that must be sold for a given price level.
11	RoundingPolicyCode (RoundingPolicyCode)	Option	[ ,None,Up,Down,ToNearest] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: roundingpolicycode ExternalType: Picklist Description: Policy for rounding the price list.
12	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Date and time when the price list was last modified.
13	PricingMethodCode (PricingMethodCode)	Option	[CurrencyAmount,PercentofList,PercentMarkup-CurrentCost,PercentMargin-CurrentCost,PercentMarkup-StandardCost,PercentMargin-StandardCost] OptionOrdinalValues: [1;2;3;4;5;6] InitValue: CurrencyAmount ExternalName: pricingmethodcode ExternalType: Picklist Description: Pricing method applied to the price list.
14	RoundingOptionCode (RoundingOptionCode)	Option	[ ,Endsin,Multipleof] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: roundingoptioncode ExternalType: Picklist Description: Option for rounding the price list.
15	RoundingOptionAmount (RoundingOptionAmount)	Decimal	ExternalName: roundingoptionamount ExternalType: Money Description: Rounding option amount for the price list.
16	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the price list.
17	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who created the price list. TableRelation: "CRM Systemuser".SystemUserId
18	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who last modified the price list. TableRelation: "CRM Systemuser".SystemUserId
19	DiscountTypeIdName (DiscountTypeIdName)	Text100	ExternalName: discounttypeidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Discounttype".Name WHERE (DiscountTypeId=FIELD(DiscountTypeId)))	FlowField
20	ProductIdName (ProductIdName)	Text100	ExternalName: productidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Product".Name WHERE (ProductId=FIELD(ProductId)))	FlowField
21	PriceLevelIdName (PriceLevelIdName)	Text100	ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(PriceLevelId)))	FlowField
22	UoMIdName (UoMIdName)	Text100	ExternalName: uomidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Uom".Name WHERE (UoMId=FIELD(UoMId)))	FlowField
23	UoMScheduleIdName (UoMScheduleIdName)	Text200	ExternalName: uomscheduleidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Uomschedule".Name WHERE (UoMScheduleId=FIELD(UoMScheduleId)))	FlowField
24	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
25	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
26	OrganizationId (OrganizationId)	GUID	ExternalName: organizationid ExternalType: Uniqueidentifier ExternalAccess: Read Description: Unique identifier of the organization associated with the price list.
27	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.
28	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup ExternalAccess: Modify Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
29	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
30	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
31	Amount_Base (Amount_Base)	Decimal	ExternalName: amount_base ExternalType: Money ExternalAccess: Read Description: Shows the Amount field converted to the system's default base currency, if specified as a fixed amount. The calculation uses the exchange rate specified in the Currencies area.
32	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
33	RoundingOptionAmount_Base (RoundingOptionAmount_Base)	Decimal	ExternalName: roundingoptionamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Rounding Amount field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
34	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
35	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
36	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
37	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
38	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Unique identifier of the Process.
39	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
40	ProductNumber (ProductNumber)	Text100	ExternalName: productnumber ExternalType: String ExternalAccess: Read Description: User-defined product number.
41	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.

Keys

#	Fields
0	ProductPriceLevelId (ProductPriceLevelId)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
DiscountTypeId (DiscountTypeId)	CRM Discounttype	DiscountTypeId (DiscountTypeId)	TableRelation: "CRM Discounttype".DiscountTypeId	1..n
PriceLevelId (PriceLevelId)	CRM Pricelevel	PriceLevelId (PriceLevelId)	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
ProductId (ProductId)	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
UoMId (UoMId)	CRM Uom	UoMId (UoMId)	TableRelation: "CRM Uom".UoMId	1..n
UoMScheduleId (UoMScheduleId)	CRM Uomschedule	UoMScheduleId (UoMScheduleId)	TableRelation: "CRM Uomschedule".UoMScheduleId	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