PriceList table - SuperOffice

PriceList Table (128)

List of prices, cached from an ERP system

Fields

Name	Description	Type	Nullable
pricelist_id	Primary key	PK	No
ERPPriceListKey	The key that uniquely identifies this pricelist in the ERP system	String(254)	Yes
QuoteConnectionId	(Reserved for future use) The connection to the ERP system used for this pricelist	FK QuoteConnection	Yes
Name	Name of this pricelist to use in the user interface.	String(254)	Yes
Description	Description of this pricelist , will be used as tool-tip in the user interface.	String(254)	Yes
CurrencyId	What is the currency for this pricelist	FK Currency	Yes
ValidFrom	The date (inclusive) the pricelist start to be valid. This can be DateTime.MinValue to signal that it doesn’t have a specific start date.	DateTime	Yes
ValidTo	The date (inclusive) the pricelist ends to be valid. This can be DateTime.MaxValue to signal that it doesn’t have a specific end date.	DateTime	Yes
IsActive	Is the list active (as opposed to being worked on, suddenly canceled, etc.	Bool	Yes
IsERPCopy	If true, then this pricelist is a cache/copy and cannot be edited by users in CRM	Bool	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No

PriceList table relationship diagram

Indexes

Fields	Types	Description
CurrencyId	FK	Index
ValidFrom, ValidTo, IsActive, IsERPCopy	DateTime, DateTime, Bool, Bool	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
Currency	Currency list table
Product	One Product, member of one price list
QuoteConnection	Primary key in the CRM database. Definition of a connection to an external system, for the Quote system.

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

pricelist PriceList IProductRegisterCache Put Price List Post Price List Default Price List

⌘I