PriceList Table (128)
•
Environment: onsite, online
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 |
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.