Activity Metadata
GET {{base_url}}/metadata/activity
Use this endpoint to retrieve the Activity metadata.
The metadata describes the fields in each table of the database for the record and describes whether or not the table is a custom table and whether or not it has a grid ID. Each field describes whether or not the field is required, the data type, the default value, whether or not it is updateable, and other useful minimums, limits, and maximum details.
For more information, see Metadata Reference.
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Content-Type | string | Required. |
The type of content supported by the API endpoint. |
| Authorization | string | | Required.
The type of authorization supported by the API endpoint. |
RESPONSES
status: OK
{"Activity":{"Keys":"ActivityID","TableName":"Activity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"Firm","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Primary Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"WBS2","FieldType":"WBS2","Caption":"WBS2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"WBS3","FieldType":"WBS3","Caption":"WBS3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"CreateEmployee","FieldType":"Employee","Caption":"Create Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"CampaignID","FieldType":"Mkt","Caption":"Marketing Campaign","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CompletionInd","FieldType":"Checkbox","Caption":"Completed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"isTask","FieldType":"Checkbox","Caption":"Is task item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"isCalendar","FieldType":"Checkbox","Caption":"Is calendar item","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":15,"CodeTable":"CFGActivityType","LimitToList":true},{"FieldName":"acType","FieldType":"String","Caption":"acType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":15},{"FieldName":"TypeName","FieldType":"String","Caption":"Type Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Subject","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"StartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StartDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InstanceStartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Priority","FieldType":"Dropdown","Caption":"Priority","DefaultValue":"Medium","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"High":"High","Medium":"Medium","Low":"Low"},"LimitToList":true},{"FieldName":"PriorityDesc","FieldType":"Dropdown","Caption":"PriorityDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"LimitToList":true},{"FieldName":"EndDate","FieldType":"Datetime","Caption":"End Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EndDateObj","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Duration","FieldType":"Numeric","Caption":"Duration","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PrivateInd","FieldType":"Checkbox","Caption":"Private","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderInd","FieldType":"String","Caption":"Reminder","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ReminderUnit","FieldType":"Numeric","Caption":"ReminderUnit","DefaultValue":"15","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReminderMinHrDay","FieldType":"String","Caption":"ReminderMinHrDay","DefaultValue":"Minutes","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"ReminderDate","FieldType":"Datetime","Caption":"Reminder Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ShowTimeAs","FieldType":"Dropdown","Caption":"Show Time As","DefaultValue":"Busy","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"Codes":{"Busy":"Busy","Free":"Free","Outoftheoffice":"Out of the office","Tentative":"Tentative"},"LimitToList":true},{"FieldName":"AllDayEventInd","FieldType":"Checkbox","Caption":"All Day Event","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"LeadID","FieldType":"String","Caption":"LeadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Owner","FieldType":"Employee","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"OwnerName","FieldType":"String","Caption":"OwnerName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"ClientName","FieldType":"String","Caption":"ClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ContactName","FieldType":"String","Caption":"ContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":45},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"VendorName","FieldType":"String","Caption":"VendorName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactIDForVendor","FieldType":"Contact","Caption":"Vendor Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ContactNameForVendor","FieldType":"String","Caption":"ContactNameForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactPhoneForVendor","FieldType":"String","Caption":"ContactPhoneForVendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"VendorContactName","FieldType":"String","Caption":"VendorContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjName","FieldType":"String","Caption":"ProjName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":80},{"FieldName":"MktName","FieldType":"String","Caption":"MktName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Location","FieldType":"String","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Notes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"HasNotes","FieldType":"String","Caption":"HasNotes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"RP","FieldType":"String","Caption":"RP","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrenceInd","FieldType":"Checkbox","Caption":"Repeats","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrType","FieldType":"String","Caption":"Repeats","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"RecurrDailyFreq","FieldType":"Numeric","Caption":"Days","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrDailyWeekDay","FieldType":"String","Caption":"Repeat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrWeeklySun","FieldType":"String","Caption":"Sun","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyMon","FieldType":"String","Caption":"Mon","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyTue","FieldType":"String","Caption":"Tue","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyWed","FieldType":"String","Caption":"Wed","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyThu","FieldType":"String","Caption":"Thu","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklyFri","FieldType":"String","Caption":"Fri","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrWeeklySat","FieldType":"String","Caption":"Sat","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrMonthlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrMonthlyOccurFreq","FieldType":"Numeric","Caption":" ","DefaultValue":"1","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndType","FieldType":"String","Caption":"Ends","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"RecurrStartDate","FieldType":"Date","Caption":"Recurrence Starts","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrEndDate","FieldType":"Date","Caption":"Recurrence Ends","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TaskCompletionDate","FieldType":"Date","Caption":"Task Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrID","FieldType":"String","Caption":"RecurrID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"OutlookType","FieldType":"String","Caption":"OutlookType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecurrYearlyOccurInd","FieldType":"String","Caption":" ","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccur","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurDay","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"RecurrYearlyOccurMonth","FieldType":"Numeric","Caption":" ","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"MaxOccurences","FieldType":"Numeric","Caption":"MaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"UpdateID","FieldType":"String","Caption":"UpdateID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadID","FieldType":"String","Caption":"ReadID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryClient","FieldType":"Client","Caption":"Primary Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Attendees","FieldType":"Contact","Caption":"Attendees","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Associations","FieldType":"Firm","Caption":"Associations","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"EndDateSort","FieldType":"String","Caption":"EndDateSort","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EndDateFilter","FieldType":"String","Caption":"EndDateFilter","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConversationID","FieldType":"String","Caption":"Conversation ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateUserName","FieldType":"User","Caption":"CreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUserName","FieldType":"User","Caption":"ModUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SingleOccurrenceDateTime","FieldType":"Datetime","Caption":"Single occurrence date time ","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ActivityTypeFlag","FieldType":"String","Caption":"Activity type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ParentMaxOccurences","FieldType":"Numeric","Caption":"ParentMaxOccurences","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrStartDate","FieldType":"Date","Caption":"ParentRecurrStartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndDate","FieldType":"Date","Caption":"ParentRecurrEndDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrEndType","FieldType":"String","Caption":"ParentRecurrEndType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ParentRecurrType","FieldType":"String","Caption":"ParentRecurrType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OccurrenceDate","FieldType":"Datetime","Caption":"OccurrenceDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ExceptionType","FieldType":"String","Caption":"ExceptionType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TimeZoneOffset","FieldType":"Numeric","Caption":"TimeZoneOffset","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"desc_CustNewActivitiesUDF","FieldType":"String","Caption":"New Activities UDF Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustNewActivitiesUDF","FieldType":"UDIC","Caption":"New Activities UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"UDICType":"UDIC_testhub"},{"FieldName":"custTestQuery","FieldType":"String","Caption":"Text not Translated","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custTEst1","FieldType":"String","Caption":"Text not Translated","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custUserdefinedfieldjb","FieldType":"String","Caption":"Text not Translated","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"Activity","CustomTableName":"ActivityCustomTabFields"},"ActivityEmployeeContacts":{"Keys":"ActivityID,ContactID","TableName":"ActivityEmployeeContacts","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"RecordID","FieldType":"Contact","Caption":"RecordID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Phone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CellPhone","FieldType":"String","Caption":"CellPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Owner","FieldType":"Checkbox","Caption":"Owner","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LastFirst","FieldType":"String","Caption":"LastFirst","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FirstLast","FieldType":"String","Caption":"FirstLast","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecordType","FieldType":"String","Caption":"RecordType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClientID","FieldType":"Firm","Caption":"Contact Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ContactHasPhoto","FieldType":"String","Caption":"ContactHasPhoto","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactPhotoModDate","FieldType":"Datetime","Caption":"ContactPhotoModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Attendees"},"EMActivity":{"Keys":"ActivityID,Employee","TableName":"EMActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"Owner","FieldType":"String","Caption":"Owner","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FullName","FieldType":"String","Caption":"Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WorkPhone","FieldType":"String","Caption":"WorkPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FirstLast","FieldType":"String","Caption":"FirstLast","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LastFirst","FieldType":"String","Caption":"LastFirst","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Employee"},"ContactActivity":{"Keys":"ActivityID,ContactID","TableName":"ContactActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"PrimaryInd","FieldType":"String","Caption":"PrimaryInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Phone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CellPhone","FieldType":"String","Caption":"CellPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Company","FieldType":"String","Caption":"Company","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FirstLast","FieldType":"String","Caption":"FirstLast","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LastFirst","FieldType":"String","Caption":"LastFirst","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactHasPhoto","FieldType":"String","Caption":"ContactHasPhoto","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"ContactPhotoModDate","FieldType":"Datetime","Caption":"ContactPhotoModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"ContactActivity"},"CLActivity":{"Keys":"ActivityID,ClientID","TableName":"CLActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"Client","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"FirmName","FieldType":"Firm","Caption":"Firms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Firms"},"ActivityFileLinks":{"Keys":"LinkID,ActivityID","TableName":"ActivityFileLinks","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LinkID","FieldType":"String","Caption":"LinkID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Description","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"FilePath","FieldType":"String","Caption":"File Path","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":255},{"FieldName":"Graphic","FieldType":"Checkbox","Caption":"Graphic","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Links"},"FW_ATTACHMENTS":{"Keys":"PKey,FileID","TableName":"FW_ATTACHMENTS","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"FileID","FieldType":"String","Caption":"FileID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":36},{"FieldName":"Key1","FieldType":"String","Caption":"Key1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Key2","FieldType":"String","Caption":"Key2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Key3","FieldType":"String","Caption":"Key3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CategoryCode","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":15,"CodeTable":"FW_CFGAttachmentCategory","LimitToList":true},{"FieldName":"CategoryDescription","FieldType":"String","Caption":"Category Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"FileName","FieldType":"String","Caption":"File Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":250},{"FieldName":"FileDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":500},{"FieldName":"FileSize","FieldType":"Numeric","Caption":"File Size","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Application","FieldType":"String","Caption":"Application","DefaultValue":"Activity","Hidden":false,"Required":false,"Updateable":true,"MaxLength":250},{"FieldName":"ContentType","FieldType":"String","Caption":"Content Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":200},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Files"},"RecurrActivityException":{"Keys":"ActivityID,StartDate","TableName":"RecurrActivityException","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"StartDate","FieldType":"Datetime","Caption":"Start Date","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"TranType","FieldType":"String","Caption":"ExceptionType","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"RecurrActivityException"},"UDIC_MyNewHubActivity":{"Keys":"ActivityID,UDIC_UID","CustomTable":true,"TableName":"UDIC_MyNewHubActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"UDIC_UID","FieldType":"UDIC","Caption":"My New Hub Creations","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32,"UDICType":"UDIC_MyNewHub"},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Number","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"My New Hub Creations"},"UDIC_SheilaHubActivity":{"Keys":"ActivityID,UDIC_UID","CustomTable":true,"TableName":"UDIC_SheilaHubActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"UDIC_UID","FieldType":"UDIC","Caption":"Sheila Hubs","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32,"UDICType":"UDIC_SheilaHub"},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Number","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Sheila Hubs"},"UDIC_SheilasFieldSecurityActivity":{"Keys":"ActivityID,UDIC_UID","CustomTable":true,"TableName":"UDIC_SheilasFieldSecurityActivity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"UDIC_UID","FieldType":"UDIC","Caption":"Sheila's Field Security Hubs","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32,"UDICType":"UDIC_SheilasFieldSecurity"},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Number","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Sheila's Field Security Hubs"},"UDIC_Test1Activity":{"Keys":"ActivityID,UDIC_UID","CustomTable":true,"TableName":"UDIC_Test1Activity","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ActivityID","FieldType":"String","Caption":"ActivityID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"UDIC_UID","FieldType":"UDIC","Caption":"Test 1 ssss","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32,"UDICType":"UDIC_Test1"},{"FieldName":"CreateUser","FieldType":"User","Caption":"Created by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ModUser","FieldType":"User","Caption":"Modified by","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"CreateDate","FieldType":"Datetime","Caption":"Create date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ModDate","FieldType":"Datetime","Caption":"Modify date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Number","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"Test 1 ssss"}}