Class SShipmentAddrTableInfo

Table 's_shipment_addr': Addresses that are ready to be sent in a shipment.

Inheritance

Object

TableInfo

SShipmentAddrTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Object.Equals(Object)

Object.Equals(Object, Object)

Object.ReferenceEquals(Object, Object)

Object.GetHashCode()

Object.GetType()

Object.MemberwiseClone()

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("s_shipment_addr")]
public class SShipmentAddrTableInfo : 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 SShipmentAddr in the database dictionary: s_shipment_addr

Declaration

public const string DictionaryTableName = "s_shipment_addr"

Field Value

Type	Description
String

Properties

Address

Field 'address' in table 's_shipment_addr': Dictionary type String[256], .NET type: String

The email address

Declaration

public StringFieldInfo Address { get; }

Property Value

Type	Description
StringFieldInfo

BounceCode

Field 'bounce_code' in table 's_shipment_addr': Dictionary type Int, .NET type: Int32

If this recipient bounced and we have a bounce code, this field will contain the code

Declaration

public Int32FieldInfo BounceCode { get; }

Property Value

Type	Description
Int32FieldInfo

BounceReason

Field 'bounce_reason' in table 's_shipment_addr': Dictionary type String[1024], .NET type: String

Reason text received from mailing system

Declaration

public StringFieldInfo BounceReason { get; }

Property Value

Type	Description
StringFieldInfo

BounceReasontag

Field 'bounce_reasontag' in table 's_shipment_addr': Dictionary type String[4001], .NET type: String

If this recipient bounced and we have a bounce reason, this field will contain the reason

Declaration

public StringFieldInfo BounceReasontag { get; }

Property Value

Type	Description
StringFieldInfo

Cleaned

Field 'cleaned' in table 's_shipment_addr': Dictionary type Bool, .NET type: Int16

Used for indicating that a bounced recipient row has been cleaned, and now will not be presented again in the cleaning list

Declaration

public UInt16FieldInfo Cleaned { get; }

Property Value

Type	Description
UInt16FieldInfo

ContactId

Field 'contact_id' in table 's_shipment_addr': Dictionary type FK, .NET type: Int32

Id of contact bound to shipment address

Declaration

public Int32FieldInfo ContactId { get; }

Property Value

Type	Description
Int32FieldInfo

ContactId_InnerJoin_Contact

Generated join from the foreign key ContactId in this table, to its target table ContactTableInfo.

Declaration

public TargetedInnerJoin<ContactTableInfo> ContactId_InnerJoin_Contact { get; }

Property Value

Type	Description
TargetedInnerJoin<ContactTableInfo>

CustomerId

Field 'customer_id' in table 's_shipment_addr': Dictionary type FK, .NET type: Int32

Id of the customer if this entry is created by a dynamic list

Declaration

public Int32FieldInfo CustomerId { get; }

Property Value

Type	Description
Int32FieldInfo

CustomerId_InnerJoin_Person

Generated join from the foreign key CustomerId in this table, to its target table PersonTableInfo.

Declaration

public TargetedInnerJoin<PersonTableInfo> CustomerId_InnerJoin_Person { get; }

Property Value

Type	Description
TargetedInnerJoin<PersonTableInfo>

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

DictionaryTableNumber

Table number for table SShipmentAddr 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

FormSubmissionId

Field 'form_submission_id' in table 's_shipment_addr': Dictionary type FK, .NET type: Int32

If this mailing recipient is created from a form submission, this will contain a reference to that submission

Declaration

public Int32FieldInfo FormSubmissionId { get; }

Property Value

Type	Description
Int32FieldInfo

FormSubmissionId_InnerJoin_FormSubmission

Generated join from the foreign key FormSubmissionId in this table, to its target table FormSubmissionTableInfo.

Declaration

public TargetedInnerJoin<FormSubmissionTableInfo> FormSubmissionId_InnerJoin_FormSubmission { get; }

Property Value

Type	Description
TargetedInnerJoin<FormSubmissionTableInfo>

LeftOuterJoin_FormSubmission_ResponseShipmentAddrId

Generated left outer join from the primary key SShipmentAddrId on this table, to FormSubmission.ResponseShipmentAddrId.

Declaration

public TargetedLeftOuterJoin<FormSubmissionTableInfo> LeftOuterJoin_FormSubmission_ResponseShipmentAddrId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<FormSubmissionTableInfo>

Name

Field 'name' in table 's_shipment_addr': Dictionary type String[256], .NET type: String

The name of the recipient

Declaration

public StringFieldInfo Name { get; }

Property Value

Type	Description
StringFieldInfo

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

SenderNr

Field 'sender_nr' in table 's_shipment_addr': Dictionary type Int, .NET type: Int32

Used for multiple ejSenders. This field indicate which ejSender process this belongs to

Declaration

public Int32FieldInfo SenderNr { get; }

Property Value

Type	Description
Int32FieldInfo

SendingTime

Field 'sending_time' in table 's_shipment_addr': Dictionary type DateTime, .NET type: DateTime

Estimated or actual sent time (depends on status)

Declaration

public DateTimeFieldInfo SendingTime { get; }

Property Value

Type	Description
DateTimeFieldInfo

ShipmentId

Field 'shipment_id' in table 's_shipment_addr': Dictionary type FK, .NET type: Int32

Which shipment this address belongs to

Declaration

public Int32FieldInfo ShipmentId { get; }

Property Value

Type	Description
Int32FieldInfo

ShipmentId_InnerJoin_SShipment

Generated join from the foreign key ShipmentId in this table, to its target table SShipmentTableInfo.

Declaration

public TargetedInnerJoin<SShipmentTableInfo> ShipmentId_InnerJoin_SShipment { get; }

Property Value

Type	Description
TargetedInnerJoin<SShipmentTableInfo>

SShipmentAddrId

Field 'id' in table 's_shipment_addr': Dictionary type PK, .NET type: Int32

Primary key

Declaration

public Int32FieldInfo SShipmentAddrId { get; }

Property Value

Type	Description
Int32FieldInfo

Status

Field 'status' in table 's_shipment_addr': Dictionary type Enum, .NET type: ShipmentAddrStatus

Status for sending to this particular recipient

Declaration

public ShipmentAddrStatusFieldInfo Status { get; }

Property Value

Type	Description
ShipmentAddrStatusFieldInfo

TicketId

Field 'ticket_id' in table 's_shipment_addr': Dictionary type FK, .NET type: Int32

Id of the ticket if this entry is created by a ticketSelection list

Declaration

public Int32FieldInfo TicketId { get; }

Property Value

Type	Description
Int32FieldInfo

TicketId_InnerJoin_Ticket

Generated join from the foreign key TicketId in this table, to its target table TicketTableInfo.

Declaration

public TargetedInnerJoin<TicketTableInfo> TicketId_InnerJoin_Ticket { get; }

Property Value

Type	Description
TargetedInnerJoin<TicketTableInfo>

Timestamp

Field 'timestamp' in table 's_shipment_addr': Dictionary type Int, .NET type: Int32

A stamp set when this address it taken by ejSender to prevent two ejSenders to take one address.

Declaration

public Int32FieldInfo Timestamp { get; }

Property Value

Type	Description
Int32FieldInfo

Type

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

Indicates if this is an email or a sms

Declaration

public Int32FieldInfo Type { get; }

Property Value

Type	Description
Int32FieldInfo

Implements

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)