• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

PriceList Table (128)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

List of prices, cached from an ERP system

Fields

Name Description Type Null
pricelist_id Primary key PK
ERPPriceListKey The key that uniquely identifies this pricelist in the ERP system String(254) ●
QuoteConnectionId (Reserved for future use) The connection to the ERP system used for this pricelist FK QuoteConnection ●
Name Name of this pricelist to use in the user interface. String(254) ●
Description Description of this pricelist , will be used as tool-tip in the user interface. String(254) ●
CurrencyId What is the currency for this pricelist FK Currency ●
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 ●
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 ●
IsActive Is the list active (as opposed to being worked on, suddenly canceled, etc. Bool ●
IsERPCopy If true, then this pricelist is a cache/copy and cannot be edited by users in CRM Bool ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

PriceList table relationship diagram

Indexes

Fields Types Description
pricelist_id PK Clustered, Unique
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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top