Class SShipmentAddrTableInfo

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

Inheritance
System.Object
TableInfo
SShipmentAddrTableInfo
Implements
System.ICloneable
Inherited Members
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.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
System.String

Properties

Address

Field 'address' in table 's_shipment_addr': Dictionary type String[256], .NET type: System.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: System.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: System.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: System.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: System.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: System.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: System.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

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
System.Int32

FormSubmissionId

Field 'form_submission_id' in table 's_shipment_addr': Dictionary type FK, .NET type: System.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: System.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: System.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: System.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: System.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: System.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: System.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: System.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: System.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)