Quote Table (34)
Quote root level, at most one per Sale, always connected to one Sale
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| quote_id | Primary key | PK | |
| SaleId | The foreign key to the corresponding sale | FK sale | ● |
| QuoteConnectionId | The connection in the CRM system to where this quote came from. Identifies the ERP connection used for this quote. Each quote is bound to one and only one connection. | FK QuoteConnection | ● |
| ERPQuoteKey | Foreign key of quote (if available). The key in the ERP system that identifies this sale’s Quote (as opposed to the later Order information) | String(254) | ● |
| ERPOrderKey | The key in the ERP system that identifies this sale’s Order, as transferred and possibly later edited in the ERP system. Only filled out if there exists a corresponding order representation of the quote in the ERP system. | String(254) | ● |
| ActiveQuoteVersionId | The primary key of the Quote Version that is currently active. (The active version will always be the latest version.) | FK QuoteVersion | ● |
| AcceptedQuoteAlternativeId | The primary key of the Quote Alternative which was finally accepted by the customer. Set when the user is marking a quote as accepted. | FK QuoteAlternative | ● |
| UseValuesFromQuote | If true, then the Earning, Earning_Percent and Amount fields are populated from the QuoteVersion.QuoteAlternative (current revision, most-likely alternative). | Bool | ● |
| DocumentId | The ID of the main Quote Document | FK document | ● |
| PreferredEmailCulture | When emails are sent (offer or confirmation), a language can be chosen in the GUI; this field saves the most recent choice and can be used to default the next such choice. Default-default is user’s current language | String(19) | ● |
| PoNumber | Customer’s Purchase order number | String(127) | ● |
| OrderComment | A comment that is intended for the Invoice, Order, Packing list and similar stages - AFTER the quote has become an order and goes to ERP for processing | String(2046) | ● |
| 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 |
|---|---|---|
| quote_id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| document | Documents, this table is an extension of the Appointment table. There is always a corresponding appointment record; the relation between appointment and document is navigable in both directions. A document-type appointment record always has a corresponding document record and a record in VisibleFor specifying who may see this. |
| QuoteAlternative | Quote Version is made up of one or more Alternatives. One of 1..n possible alternatives in a Quote Version. The reason we have alternatives is that a quote can say to a customer, “we can solve you problem in two (or more) different ways, with different technology and sideeffects (and price)”. An Alternative may have discounts on the total amount. The Alternative tracks whether the user on the order level entered the Discount , Earning amount or the TotalPrice fields so that the discount and earning and total can be re-calculated correctly when Quote Lines are added or changed. |
| QuoteConnection | Primary key in the CRM database. Definition of a connection to an external system, for the Quote system. |
| QuoteVersion | There may be multiple Versions of a Quote, with one of them active |
| sale | Sales For every Sale record edited through the SuperOffice GUI, a copy of the current version of the record will be saved in the SaleHist table. This also applies to editing done through the SaleModel COM interface, but not to editing done through the OLE DB Provider or other channels. |
Replication Flags
- Area Management controlled table. Contents replicated to satellites and traveller databases.
- Copy to satellite and travel prototypes.
Security Flags
- Sentry controls access to items in this table using user’s Role and data rights matrix.