| quotealternative_id | Primary key | PK | No |
| ERPQuoteAlternativeKey | Key that identifies this alternative in the ERP system, if it exists there. | String(254) | Yes |
| QuoteVersionId | The version that owns this alternative (the chain is Sale 1->1 Quote 1->+ QuoteVersion 1->+ QuoteAlternative. | FK QuoteVersion | No |
| Name | Name of Alternative. Shown in tab in user interface, intentionally kept short | String(59) | Yes |
| Description | The tool-tip to use in the user interface (on the tab, for instance). | String(2047) | Yes |
| Status | If there was a problem with for instance calculation, this field is set to warning or error. | Enum QuoteStatus | Yes |
| Reason | If there was a problem, this field contains a localized explanation of the problem and possible steps to fix it that the user can be shown. | String(2047) | Yes |
| ERPDiscountPercent | The discount the system calculates based on customer /amount / whatever. Can be overridden by the sales rep in the field ‘DiscountPercent’ or ‘DiscountAmount’. Both the two ‘ERPDiscountPercent’ and ‘ERPDiscountAmount’ shall be filled out. If UserValueOverride is ‘None’, then the ERPDiscountAmount shall be copied into DiscountAmount and ERPDiscountPercent into DiscountPercent. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’. | Double | Yes |
| ERPDiscountAmount | The discount the system calculates based on customer /amount / whatever. Can be overridden by the user in the field ‘DiscountPercent’ or ‘DiscountAmount’. Both the two ‘ERPDiscountPercent’ and ‘ERPDiscountAmount’ shall be filled out. If UserValueOverride is ‘None’, then the ERPDiscountAmount shall be copied into DiscountAmount and ERPDiscountPercent into DiscountPercent. | Double | Yes |
| DiscountPercent | The discount the sales rep specifies, in percent. Both the two ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed. If this field is filled out by the user, it overrides the discount suggested by the connector. If the user has not filled any values, the system will copy the ERP discount percent value into this field. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’. | Double | Yes |
| DiscountAmount | The discount the sales rep specifies, in whatever currency the sale is in. Both the two ‘DiscountPercent’ and ‘DiscountAmount’ shall be filled out, but the UserValueOverride field must be set to the field the user actually changed. If this field is filled out by the user, it overrides the discount suggested by the connector. If the user has not filled any values, the system will copy the ERP discount amount value into this field. | Double | Yes |
| UserValueOverride | Has the pre-calculated (from ERP) price information been overridden, and how. If the user has filled out the discountpercentage field, then the UserValueOverride field is set to OverridePercent. (The DiscountAmount, EarningPercent, EarningAmount and TotalPrice fields are calculated based on the discountPercent.) | Enum ValueOverride | Yes |
| VATInfo | Extra info about VAT that the connector might insert. This field has no business logic in the CRM code, but is available as a merge field in the quote documents. | String(254) | Yes |
| VAT | Tax/VAT - THIS IS AN AMOUNT, available as a merge field in the quote document. The SuperOffice quote connector will calculate this field based on the vat PERCENTAGES on the individual lines; other connectors may implement other algorithms at will. | Double | Yes |
| EarningPercent | The earning on this alternative, in percent of total. The Percentage is given in integer form, i.e. ‘12%’ is represented as ‘12’. | Double | Yes |
| EarningAmount | Earning on this alternative, as an absolute amount | Double | Yes |
| TotalPrice | Sum of the QuoteLines.TotalPrice - AlternativeDiscount or QuoteLines.TotalCost + Earning based on what, if anything, the user has entered last. Shall be calculated by the connector. | Double | Yes |
| extraField1 | Optional information added by Quote Connector; usable in the quote document merge process | String(1023) | Yes |
| extraField2 | Optional information added by Quote Connector; usable in the quote document merge process | String(1023) | Yes |
| extraField3 | Optional information added by Quote Connector; usable in the quote document merge process | String(1023) | Yes |
| extraField4 | Optional information added by Quote Connector; usable in the quote document merge process | String(1023) | Yes |
| extraField5 | Optional information added by Quote Connector; usable in the quote document merge process | String(1023) | 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 |
