Class QuoteVersionTableInfo

Table 'QuoteVersion': There may be multiple Versions of a Quote, with one of them active

Inheritance
Object
TableInfo
QuoteVersionTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("QuoteVersion")]
public class QuoteVersionTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table QuoteVersion in the database dictionary: QuoteVersion

Declaration
public const string DictionaryTableName = "QuoteVersion"
Field Value
Type Description
String

Properties

ApprovedBy

Field 'ApprovedBy' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Id of associate who approved (or rejected approval) for this version

Declaration
public Int32FieldInfo ApprovedBy { get; }
Property Value
Type Description
Int32FieldInfo

ApprovedBy_InnerJoin_Associate

Generated join from the foreign key ApprovedBy in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> ApprovedBy_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

ApprovedRegisteredBy

Field 'ApprovedRegisteredBy' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Id of associate who actually entered the approval; might be different from ApprovedBy (f.x. due to telephone consultation/approval)

Declaration
public Int32FieldInfo ApprovedRegisteredBy { get; }
Property Value
Type Description
Int32FieldInfo

ApprovedRegisteredBy_InnerJoin_Associate

Generated join from the foreign key ApprovedRegisteredBy in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> ApprovedRegisteredBy_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

ApprovedRegisteredDate

Field 'ApprovedRegisteredDate' in table 'QuoteVersion': Dictionary type DateTime, .NET type: DateTime

When was approval granted or rejected

Declaration
public DateTimeFieldInfo ApprovedRegisteredDate { get; }
Property Value
Type Description
DateTimeFieldInfo

ApprovedText

Field 'ApprovedText' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Text with comments on why approval was granted (or rejected)

Declaration
public StringFieldInfo ApprovedText { get; }
Property Value
Type Description
StringFieldInfo

ArchivedState

Field 'ArchivedState' in table 'QuoteVersion': Dictionary type Enum, .NET type: QuoteVersionState

State that this quote version had, right before it was changed to Archived; in this way we can show what happened before the archiving.

Declaration
public QuoteVersionStateFieldInfo ArchivedState { get; }
Property Value
Type Description
QuoteVersionStateFieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DeliveryCountryId

Field 'DeliveryCountryId' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Country of delivery address, typically copied from the contact record

Declaration
public Int32FieldInfo DeliveryCountryId { get; }
Property Value
Type Description
Int32FieldInfo

DeliveryCountryId_InnerJoin_Country

Generated join from the foreign key DeliveryCountryId in this table, to its target table CountryTableInfo.

Declaration
public TargetedInnerJoin<CountryTableInfo> DeliveryCountryId_InnerJoin_Country { get; }
Property Value
Type Description
TargetedInnerJoin<CountryTableInfo>

Description

Field 'Description' in table 'QuoteVersion': Dictionary type String[2048], .NET type: String

Description of Version. Potentially longer text description, typically used in a tooltip. Max 2K.

Declaration
public StringFieldInfo Description { get; }
Property Value
Type Description
StringFieldInfo

DictionaryTableNumber

Table number for table QuoteVersion in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
Int32

ERPDeliveryTermsKey

Field 'ERPDeliveryTermsKey' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

Either a List id to an id from a connector provided list, or, if the connection doesn’t support lists, a text. For instance: ‘FOB’ (‘Free on board’).

Declaration
public StringFieldInfo ERPDeliveryTermsKey { get; }
Property Value
Type Description
StringFieldInfo

ERPDeliveryTypeKey

Field 'ERPDeliveryTypeKey' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

Either a List id to an id from a connector provided list, or, if the connection doesn’t support lists, a text. For instance: ‘Air’.

Declaration
public StringFieldInfo ERPDeliveryTypeKey { get; }
Property Value
Type Description
StringFieldInfo

ERPPaymentTermsKey

Field 'ERPPaymentTermsKey' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

Either a List id to an id from a connector provided list, or, if the connection doesn’t support lists, a text. For instance: ‘Standard 30 days’.

Declaration
public StringFieldInfo ERPPaymentTermsKey { get; }
Property Value
Type Description
StringFieldInfo

ERPPaymentTypeKey

Field 'ERPPaymentTypeKey' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

Either a List id to an id from a connector provided list, or, if the connection doesn’t support lists, a text. For instance: 'Invoice'.

Declaration
public StringFieldInfo ERPPaymentTypeKey { get; }
Property Value
Type Description
StringFieldInfo

ERPQuoteVersionKey

Field 'ERPQuoteVersionKey' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

Key in the ERP system that uniquely identifies this Version within the ERP system (if available, the field may be empty).

Declaration
public StringFieldInfo ERPQuoteVersionKey { get; }
Property Value
Type Description
StringFieldInfo

ExpirationDate

Field 'ExpirationDate' in table 'QuoteVersion': Dictionary type DateTime, .NET type: DateTime

Last date the quote Version is valid, expiration is at midnight end of this day.

Declaration
public DateTimeFieldInfo ExpirationDate { get; }
Property Value
Type Description
DateTimeFieldInfo

ExtraField1

Field 'extraField1' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public StringFieldInfo ExtraField1 { get; }
Property Value
Type Description
StringFieldInfo

ExtraField2

Field 'extraField2' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public StringFieldInfo ExtraField2 { get; }
Property Value
Type Description
StringFieldInfo

ExtraField3

Field 'extraField3' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public StringFieldInfo ExtraField3 { get; }
Property Value
Type Description
StringFieldInfo

ExtraField4

Field 'extraField4' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public StringFieldInfo ExtraField4 { get; }
Property Value
Type Description
StringFieldInfo

ExtraField5

Field 'extraField5' in table 'QuoteVersion': Dictionary type String[1024], .NET type: String

Optional information added by Quote Connector; usable in the quote document merge process

Declaration
public StringFieldInfo ExtraField5 { get; }
Property Value
Type Description
StringFieldInfo

FollowupId

Field 'FollowupId' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Link to a follow-up activity, created when this quote version was sent to the customer.

Declaration
public Int32FieldInfo FollowupId { get; }
Property Value
Type Description
Int32FieldInfo

FollowupId_InnerJoin_Appointment

Generated join from the foreign key FollowupId in this table, to its target table AppointmentTableInfo.

Declaration
public TargetedInnerJoin<AppointmentTableInfo> FollowupId_InnerJoin_Appointment { get; }
Property Value
Type Description
TargetedInnerJoin<AppointmentTableInfo>

HasOwnDeliveryAddress

Field 'HasOwnDeliveryAddress' in table 'QuoteVersion': Dictionary type Bool, .NET type: Int16

The delivery address is not the same as the contact's Street address

Declaration
public UInt16FieldInfo HasOwnDeliveryAddress { get; }
Property Value
Type Description
UInt16FieldInfo

HasOwnInvoiceAddress

Field 'HasOwnInvoiceAddress' in table 'QuoteVersion': Dictionary type Bool, .NET type: Int16

The quote has an address for Invoicing. This will typically be copied from the company's addresses.

Declaration
public UInt16FieldInfo HasOwnInvoiceAddress { get; }
Property Value
Type Description
UInt16FieldInfo

InvoiceCountryId

Field 'InvoiceCountryId' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Country of invoice address, typically copied from contact record

Declaration
public Int32FieldInfo InvoiceCountryId { get; }
Property Value
Type Description
Int32FieldInfo

InvoiceCountryId_InnerJoin_Country

Generated join from the foreign key InvoiceCountryId in this table, to its target table CountryTableInfo.

Declaration
public TargetedInnerJoin<CountryTableInfo> InvoiceCountryId_InnerJoin_Country { get; }
Property Value
Type Description
TargetedInnerJoin<CountryTableInfo>

LastRecalculated

Field 'LastRecalculated' in table 'QuoteVersion': Dictionary type DateTime, .NET type: DateTime

When this version was last subjected to a total recalculation. This field must be set by the connector, since the connector may choose to ignore a RecalculateVersion call based on policies and possibly the current value of this field. SuperOffice will set this field to 1.1.1760 whenever any change occurs to the quote, to indicate that a recalculation is needed.

Declaration
public DateTimeFieldInfo LastRecalculated { get; }
Property Value
Type Description
DateTimeFieldInfo

LeftOuterJoin_Quote_ActiveQuoteVersionId

Generated left outer join from the primary key QuoteVersionId on this table, to Quote.ActiveQuoteVersionId.

Declaration
public TargetedLeftOuterJoin<QuoteTableInfo> LeftOuterJoin_Quote_ActiveQuoteVersionId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteTableInfo>

LeftOuterJoin_QuoteAlternative_QuoteVersionId

Generated left outer join from the primary key QuoteVersionId on this table, to QuoteAlternative.QuoteVersionId.

Declaration
public TargetedLeftOuterJoin<QuoteAlternativeTableInfo> LeftOuterJoin_QuoteAlternative_QuoteVersionId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteAlternativeTableInfo>

LeftOuterJoin_QuoteVersionAttachment_QuoteVersionId

Generated left outer join from the primary key QuoteVersionId on this table, to QuoteVersionAttachment.QuoteVersionId.

Declaration
public TargetedLeftOuterJoin<QuoteVersionAttachmentTableInfo> LeftOuterJoin_QuoteVersionAttachment_QuoteVersionId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<QuoteVersionAttachmentTableInfo>

LikelyQuoteAlternativeId

Field 'LikelyQuoteAlternativeId' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

The alternative that is considered most likely to be accepted. Used to calculate probable income.

Declaration
public Int32FieldInfo LikelyQuoteAlternativeId { get; }
Property Value
Type Description
Int32FieldInfo

LikelyQuoteAlternativeId_InnerJoin_QuoteAlternative

Generated join from the foreign key LikelyQuoteAlternativeId in this table, to its target table QuoteAlternativeTableInfo.

Declaration
public TargetedInnerJoin<QuoteAlternativeTableInfo> LikelyQuoteAlternativeId_InnerJoin_QuoteAlternative { get; }
Property Value
Type Description
TargetedInnerJoin<QuoteAlternativeTableInfo>

Number

Field 'Number' in table 'QuoteVersion': Dictionary type String[255], .NET type: String

A quote number that the user (or ERP connector) can fill out.

Declaration
public StringFieldInfo Number { get; }
Property Value
Type Description
StringFieldInfo

QuoteId

Field 'QuoteId' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Foreign key to CRM quote (the conceptual parent). Owning Quote of this Quote Version.

Declaration
public Int32FieldInfo QuoteId { get; }
Property Value
Type Description
Int32FieldInfo

QuoteId_InnerJoin_Quote

Generated join from the foreign key QuoteId in this table, to its target table QuoteTableInfo.

Declaration
public TargetedInnerJoin<QuoteTableInfo> QuoteId_InnerJoin_Quote { get; }
Property Value
Type Description
TargetedInnerJoin<QuoteTableInfo>

QuoteVersionId

Field 'quoteversion_id' in table 'QuoteVersion': Dictionary type PK, .NET type: Int32

Primary key

Declaration
public Int32FieldInfo QuoteVersionId { get; }
Property Value
Type Description
Int32FieldInfo

Rank

Field 'Rank' in table 'QuoteVersion': Dictionary type Int, .NET type: Int32

Rank/Version number, starts at 1

Declaration
public Int32FieldInfo Rank { get; }
Property Value
Type Description
Int32FieldInfo

Reason

Field 'Reason' in table 'QuoteVersion': Dictionary type String[2048], .NET type: String

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.

Declaration
public StringFieldInfo Reason { get; }
Property Value
Type Description
StringFieldInfo

Registered

Field 'registered' in table 'QuoteVersion': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Registered by whom

Declaration
public Int32FieldInfo RegisteredAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

SentDate

Field 'SentDate' in table 'QuoteVersion': Dictionary type DateTime, .NET type: DateTime

The date the version was sent to the customer.

Declaration
public DateTimeFieldInfo SentDate { get; }
Property Value
Type Description
DateTimeFieldInfo

State

Field 'State' in table 'QuoteVersion': Dictionary type Enum, .NET type: QuoteVersionState

Current state of this quote version.

Declaration
public QuoteVersionStateFieldInfo State { get; }
Property Value
Type Description
QuoteVersionStateFieldInfo

Status

Field 'Status' in table 'QuoteVersion': Dictionary type Enum, .NET type: QuoteStatus

If there was a problem with for instance calculation, this field is set to warning or error.

Declaration
public QuoteStatusFieldInfo Status { get; }
Property Value
Type Description
QuoteStatusFieldInfo

Updated

Field 'updated' in table 'QuoteVersion': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'QuoteVersion': Dictionary type FK, .NET type: Int32

Last updated by whom

Declaration
public Int32FieldInfo UpdatedAssociateId { get; }
Property Value
Type Description
Int32FieldInfo

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'QuoteVersion': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)