Contact Metadata
GET {{base_url}}/metadata/contact
Use this endpoint to retrieve the Contact 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
{"Contacts":{"Keys":"ContactID","TableName":"Contacts","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Salutation","FieldType":"Dropdown","Caption":"Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"FirstName","FieldType":"String","Caption":"First","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":25},{"FieldName":"MiddleName","FieldType":"String","Caption":"Middle","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"LastName","FieldType":"String","Caption":"Last","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":30},{"FieldName":"Suffix","FieldType":"Dropdown","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"PreferredName","FieldType":"String","Caption":"Preferred","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":60},{"FieldName":"Title","FieldType":"Dropdown","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGContactTitle","LimitToList":false},{"FieldName":"Source","FieldType":"Dropdown","Caption":"Source","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGContactSource","LimitToList":true},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"LimitToList":true},{"FieldName":"ClientID","FieldType":"Client","Caption":"Client","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ClientName","FieldType":"Firm","Caption":"Firm Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"Vendor","FieldType":"Vendor","Caption":"Vendor Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":8},{"FieldName":"VName","FieldType":"String","Caption":"VName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"ContactStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"ContactStatus","LimitToList":true},{"FieldName":"CustomCurrencyCode","FieldType":"Dropdown","Caption":"Custom Currency Code","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"Address1","FieldType":"String","Caption":"Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address3","FieldType":"String","Caption":"Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address4","FieldType":"String","Caption":"Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"Zip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"Phone","FieldType":"Phone","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Fax","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"CellPhone","FieldType":"Phone","Caption":"Mobile","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"HomePhone","FieldType":"Phone","Caption":"Home","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Pager","FieldType":"Phone","Caption":"Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"MailingAddress","FieldType":"Checkbox","Caption":"Mailing Address","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"FirmAddress1","FieldType":"String","Caption":"Firm Business Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"FirmAddress2","FieldType":"String","Caption":"Firm Business Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"FirmAddress3","FieldType":"String","Caption":"Firm Business Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"FirmAddress4","FieldType":"String","Caption":"Firm Business Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"FirmCity","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"FirmState","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"FirmZip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"FirmCountry","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"FirmBusinessPhone","FieldType":"Phone","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FirmBusinessPhoneFormat","FieldType":"String","Caption":"Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FirmBusinessFax","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FirmBusinessFaxFormat","FieldType":"String","Caption":"Fax Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FirmPager","FieldType":"Phone","Caption":"Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FirmDescription","FieldType":"String","Caption":"Firm Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"Memo","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Billing","FieldType":"String","Caption":"Billing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"PrimaryInd","FieldType":"String","Caption":"PrimaryInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Addressee","FieldType":"String","Caption":"Addressee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"CLAddress","FieldType":"String","Caption":"Client Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"VEAddress","FieldType":"String","Caption":"Vendor Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"PhoneFormat","FieldType":"String","Caption":"Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FaxFormat","FieldType":"String","Caption":"Fax Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"CellPhoneFormat","FieldType":"String","Caption":"Cell Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"HomePhoneFormat","FieldType":"String","Caption":"Home Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"PagerFormat","FieldType":"String","Caption":"Pager Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Company","FieldType":"String","Caption":"Company","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"flName","FieldType":"String","Caption":"Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Owner","FieldType":"Employee","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"emOwnerfl","FieldType":"String","Caption":"Owner Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPStartDate","FieldType":"String","Caption":"TopTPStartDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPSubject","FieldType":"String","Caption":"TopTPSubject","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPContactID","FieldType":"String","Caption":"TopTPContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPCreateEmployee","FieldType":"String","Caption":"TopTPCreateEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPCreateUserName","FieldType":"String","Caption":"TopTPCreateUserName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPActivityID","FieldType":"String","Caption":"TopTPActivityID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasPhoto","FieldType":"Numeric","Caption":"HasPhoto","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PhotoModDate","FieldType":"Date","Caption":"PhotoModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProjectDescription","FieldType":"String","Caption":"Project Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"Rating","FieldType":"Dropdown","Caption":"Rating","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGLeadRating","LimitToList":true},{"FieldName":"Market","FieldType":"Dropdown","Caption":"Market","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGClientType","LimitToList":true},{"FieldName":"Website","FieldType":"String","Caption":"Website","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"QualifiedStatus","FieldType":"Dropdown","Caption":"Qualified Status","DefaultValue":"sysQual","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"Codes":{"sysQual":"Qualified","sysNew":"New Lead","sysDisqual":"Disqualified"},"LimitToList":true},{"FieldName":"StatusReason","FieldType":"String","Caption":"Status Reason","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"StatusDate","FieldType":"Date","Caption":"Status Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ProfessionalSuffix","FieldType":"String","Caption":"Professional Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":255},{"FieldName":"SFID","FieldType":"String","Caption":"Salesforce ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"SFLastModifiedDate","FieldType":"Datetime","Caption":"SF Last Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraSync","FieldType":"Checkbox","Caption":"Ajera Sync","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Client","FieldType":"String","Caption":"Firm Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"FirmAddressDescription","FieldType":"String","Caption":"Firm Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"TaxRegistrationNumber","FieldType":"String","Caption":"Tax Reg. #","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"FieldName":"TaxCountryCode","FieldType":"Dropdown","Caption":"Tax Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"Payment","FieldType":"String","Caption":"Payment","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Accounting","FieldType":"String","Caption":"Accounting","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"UpdateCLAddress","FieldType":"String","Caption":"Update Firm Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"FirmMailingAddress","FieldType":"String","Caption":"Firm Mailing Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"QBOID","FieldType":"String","Caption":"QBO Id","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOIsMainContact","FieldType":"Checkbox","Caption":"Is main QBO contact","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QBOLastUpdated","FieldType":"Datetime","Caption":"QBO Mod Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PRName","FieldType":"String","Caption":"Project Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"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":"desc_CustContactImage","FieldType":"String","Caption":"Contact Image Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustContactImage","FieldType":"Contact","Caption":"Contact Image","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"CustJBsfieldfortestingTouchCRM","FieldType":"String","Caption":"JB's field for testing Touch CRM","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"CustSeasonal","FieldType":"Checkbox","Caption":"Seasonal","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustSeasons","FieldType":"String","Caption":"Seasons Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustSeasons","FieldType":"Dropdown","Caption":"Seasons","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"desc_CustContactUDBB","FieldType":"String","Caption":"ContactUDBB Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustContactUDBB","FieldType":"Contact","Caption":"ContactUDBB","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_CustUDIC_testhub","FieldType":"String","Caption":"UDIC_testhub Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustUDIC_testhub","FieldType":"UDIC","Caption":"UDIC_testhub","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":true,"UDICType":"UDIC_testhub"},{"FieldName":"custNewsletter","FieldType":"Checkbox","Caption":"Newsletter","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custTEST1","FieldType":"String","Caption":"TEST1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custCorporateList","FieldType":"Checkbox","Caption":"Corporate List","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custPromotional","FieldType":"Checkbox","Caption":"Promotional","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custMarket","FieldType":"String","Caption":"Market Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custMarket","FieldType":"Dropdown","Caption":"Market","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"custPersonal","FieldType":"Memo","Caption":"Personal","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custBirthDate","FieldType":"Date","Caption":"Birth Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custGolf","FieldType":"Checkbox","Caption":"Golf?","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custSpouseName","FieldType":"String","Caption":"Spouse Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custTennis","FieldType":"Checkbox","Caption":"Tennis?","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true}],"Caption":"Contacts","CustomTableName":"ContactCustomTabFields"},"ContactMoreInfo":{"Keys":"ContactID,Category","TableName":"ContactMoreInfo","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Category","FieldType":"Dropdown","Caption":"Category","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":50,"CodeTable":"CFGContactInfoCat","LimitToList":true},{"FieldName":"CategoryDesc","FieldType":"String","Caption":"CategoryDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Info","FieldType":"String","Caption":"Info","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":"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":"Categories"},"QualifiedContact":{"Keys":"ContactID","TableName":"QualifiedContact","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"QualifiedStatus","FieldType":"String","Caption":"QualifiedStatus","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"StatusDate","FieldType":"Datetime","Caption":"StatusDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false}],"Caption":"QualifiedContact"},"PRContactAssoc":{"Keys":"ContactID,WBS1","TableName":"PRContactAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Number","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":10},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGContactRole","LimitToList":true},{"FieldName":"RoleDescription","FieldType":"String","Caption":"Role Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PrimaryInd","FieldType":"String","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AjeraSync","FieldType":"Checkbox","Caption":"Ajera Sync","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"PRName","FieldType":"String","Caption":"PRName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"PRClientID","FieldType":"Client","Caption":"PRClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PRClientName","FieldType":"String","Caption":"PRClientName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"PRContactID","FieldType":"Contact","Caption":"Primary Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"PRContactName","FieldType":"String","Caption":"PRContactName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"PRStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1,"CodeTable":"CFGProjectStatus","LimitToList":true},{"FieldName":"DefaultType","FieldType":"String","Caption":"DefaultType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"StageDescription","FieldType":"String","Caption":"StageDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20},{"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":"ClientRole","FieldType":"String","Caption":"ClientRole","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"FirmID","FieldType":"Client","Caption":"Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"FirmName","FieldType":"Client","Caption":"Firm Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32}],"Caption":"Associated Projects"},"EMContactAssoc":{"Keys":"Employee,ContactID","TableName":"EMContactAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Relationship","FieldType":"Dropdown","Caption":"Relationship","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGEmployeeRelationship","LimitToList":true},{"FieldName":"RelationshipDesc","FieldType":"String","Caption":"Relationship Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WorkPhone","FieldType":"String","Caption":"WorkPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"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":"Our Team"},"MktCampaignContactAssoc":{"Keys":"CampaignID,ContactID","TableName":"MktCampaignContactAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"CampaignMgrID","FieldType":"Employee","Caption":"Marketing Campaign Manager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":5},{"FieldName":"CampaignMgr","FieldType":"String","Caption":"CampaignMgr","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGCampaignType","LimitToList":true},{"FieldName":"Stage","FieldType":"Dropdown","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGCampaignStatus","LimitToList":true},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGCampaignRecStatus","LimitToList":true},{"FieldName":"CampaignID","FieldType":"Mkt","Caption":"Marketing Campaign","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"LaunchDate","FieldType":"Date","Caption":"Launch Date","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":"Marketing Campaigns"},"ContactToContactAssoc":{"Keys":"FromContactID,ToContactID","TableName":"ContactToContactAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"FromContactID","FieldType":"String","Caption":"FromContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"Contact","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ToContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Relationship","FieldType":"Dropdown","Caption":"Relationship","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":30,"CodeTable":"CFGContactRelationship","LimitToList":true},{"FieldName":"Description","FieldType":"String","Caption":"Relationship Description","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":"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":"Associated Contacts"},"ContactFileLinks":{"Keys":"LinkID,ContactID","TableName":"ContactFileLinks","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LinkID","FieldType":"String","Caption":"LinkID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","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":"ContactID","FieldType":"String","Caption":"ContactID","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":"Contacts","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"},"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":"Activity","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}],"Caption":"Activity"},"CLAddress":{"Keys":"ClientID,Address","TableName":"CLAddress","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"CLAddressID","FieldType":"String","Caption":"Address","DefaultValue":"[UNIQUEID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"PrimaryInd","FieldType":"Checkbox","Caption":"PrimaryInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Billing","FieldType":"Checkbox","Caption":"|Billing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Accounting","FieldType":"Checkbox","Caption":"|Accounting","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Address","FieldType":"String","Caption":"Address Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":20},{"FieldName":"Addressee","FieldType":"String","Caption":"Addressee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address1","FieldType":"String","Caption":"Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address3","FieldType":"String","Caption":"Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"Address4","FieldType":"String","Caption":"Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"Zip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"Phone","FieldType":"Phone","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FAX","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"TaxRegistrationNumber","FieldType":"String","Caption":"Tax Reg. #","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"TaxCountryCode","FieldType":"Dropdown","Caption":"Tax Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"PhoneFormat","FieldType":"String","Caption":"PhoneFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"FaxFormat","FieldType":"String","Caption":"FaxFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":24},{"FieldName":"Payment","FieldType":"Checkbox","Caption":"Payment","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"StateDescription","FieldType":"String","Caption":"StateDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"QBOID","FieldType":"String","Caption":"QBO Reference","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOAddressID","FieldType":"String","Caption":"QBO Reference","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOIsBillingAddr","FieldType":"Checkbox","Caption":"Is QBO Billing Address","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QBOIsShippingAddr","FieldType":"Checkbox","Caption":"Is QBO Shipping Address","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"QBOLastUpdated","FieldType":"Datetime","Caption":"QBO Mod Date","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":"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":"Addresses"},"Contacts_RCE1":{"Keys":"Seq,ContactID","CustomTable":true,"TableName":"Contacts_RCE1","GridID":"custRCE1","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true},{"FieldName":"Seq","FieldType":"String","Caption":"Seq","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"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":"custRCE","FieldType":"String","Caption":"RCE!","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"RCE1"}}