Table changes from 7.5 to 8.0
•
Environment: onsite
•
Version: 8
• 3 minutes to read
New tables
Favorites
| Field |
Type |
Description |
id |
int |
Primary key |
table_id |
short |
SuperOffice table reference |
record_id |
int |
Record in the referenced table |
associate_id |
int |
The user who has marked this favorited |
extra_info[255] |
nvarchar |
Optional extra information |
registered |
DateTime |
Registered datetime |
registered_by |
int |
Registered by whom |
New fields on existing tables
Traveltransactionlog
| Field |
Type |
Description |
Flags |
ushort |
extra information about the operation, as a bit-masked enum |
Application_Id |
|
mainly online, used to track the execution context (who did this?) |
UdListDefinition
| Field |
Type |
Description |
RequiredLicense |
string 255 |
contains names of licenses needed for this list to become visible |
PrefDesc
| Field |
Type |
Description |
RequiredLicense |
string 255 |
contains names of licenses needed for this preference to become visible |
SearchCriteria
| Field |
Type |
Description |
DisplayName |
string 255 |
Display name when these criteria are a saved filter |
Ticket
| Field |
Type |
Description |
Ticket_type |
|
supports new functionality for requests |
Hierarchy
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
Element_Profile
| Field |
Type |
Description |
Filter_Field |
string 255 |
supports new filtering functionality in Service product |
Filter_Value |
string 255 |
supports new filtering functionality in Service product |
S_Shipment
| Field |
Type |
Description |
selection_id |
|
set if this shipment should be related to a selection |
project_id |
|
set if this shipment should be related to a project |
generated_document_id |
|
ID of the merged document that is the result of the shipment |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
S_Message
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
S_Link
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
S_Picture_Folder
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
S_Picture_Entry
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
S_Shipment_Addr
| Field |
Type |
Description |
Bounce_Reason |
string 1k |
reason text received from mailing system |
ResourceOverride
| Field |
Type |
Description |
| Registered date/associate |
|
|
| Updated date/associate |
|
|
| UpdatedCount |
|
|
Fields on existing tables with increased length
QuoteVersion
- Description and Reason now have 2k characters each
- ExtraField1 - 5 now have 1k characters each
QuoteAlternative
- Description and Reason now have 2k characters each
- ExtraField1 - 5 now have 1k characters each
QuoteLineFa
- ExtraField1 - 5 now have 1k characters each
Product
- Description now has 2k characters
- ExtraField1 - 5 now have 1k characters each
Mail_In_Uidl
- uidl is now 2k characters
Tables that support new functionality in Service
Ticket_TypeTicket_Relation_TypeTicket_Relation_ActionTicket_Relation
These tables support new functionality in Service, where you can define request types, relations between requests of certain types, and actions to be taken.