quote Table (34)
• 3 minutes to read
• 3 minutes to read
|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_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|
- Area Management controlled table. Contents replicated to satellites and traveller databases.
- Copy to satellite and travel prototypes.
- Sentry controls access to items in this table using user's Role and data rights matrix.