ShipmentType table - SuperOffice

ShipmentType Table (512)

Shipment type list table. Classification of a mailing, allowing recipients to subscribe to lists

Fields

Name	Description	Type	Nullable
ShipmentType_id	Primary key	PK	No
name	The list item	String(4000)	No
tooltip	The tooltip for the list item	String(4000)	Yes
rank	Rank order	UShort	Yes
deleted	0 -> record is active 1 -> record is ‘deleted’ and should not be shown in lists	UShort	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

ShipmentType table relationship diagram

Indexes

Fields	Types	Description

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
email_flow	A set of properties related to the email workflow.
s_shipment	Contains info about one shipment. The addresses are stored in s_shipment_addr
ShipmentTypeReservation	ShipmentTypes a person has reserved against. Note that the absense of a record here implies acceptance of a mailings of this type

Replication Flags

Replicate changes DOWN from central to satellites and travellers.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.

Security Flags

No access control via user’s Role.

Related topics

ShipmentTypeReservation table shipmenttype s_shipment table What's new in version 10.3.7.452 What's new in version 10.3.8.2017 What's new in version 10.3.9.718

⌘I