Field order of the luRelationship lookup table

Organisations upgrading to Version 70 from an earlier version of Synergetic will automatically have the FieldOrderCSV configuration setting pre-configured for the luRelationship lookup table. See FieldOrderCSV configuration setting.

The FieldOrderCSV configuration setting for the luRelationship lookup table will be populated as follows:

Key

Value

1

LookUpTable

2

dbo.luRelationship

3

FieldOrderCSV

4
5
TypeSTR
ValueCode,Description,GenerationGap,RevRelationshipMale,RevRelationshipFemale,RevRelationshipOther,RelationshipSpouse,SynergyMeaning,GenerationGapSort,
SetRelationsDefaultEmail,SetRelationsDefaultSMS,SetRelationshipDefaultPortalApproval,ModifiedDate,ModifiedUser,SetCentrallyFlag
DefaultCode,Description,GenerationGap,RevRelationshipMale,RevRelationshipFemale,RevRelationshipOther,RelationshipSpouse,SynergyMeaning,GenerationGapSort,
SetRelationsDefaultEmail,SetRelationsDefaultSMS,SetRelationshipDefaultPortalApproval,ModifiedDate,ModifiedUser,SetCentrallyFlag