Firm Metadata

GET {{base_url}}/metadata/firm

Use this endpoint to retrieve the Firm 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

The type of content supported by the API endpoint. | | Authorization | string | | Required.

The type of authorization supported by the API endpoint. |

RESPONSES

status: OK

{"Clendor":{"Keys":"ClientID","TableName":"Clendor","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Client","FieldType":"String","Caption":"Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Market","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGClientType","LimitToList":true},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"CodeTable":"CFGClientStatus","LimitToList":true},{"FieldName":"ExportInd","FieldType":"Checkbox","Caption":"ExportInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClientInd","FieldType":"Checkbox","Caption":"Client","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"VendorInd","FieldType":"Checkbox","Caption":"Vendor","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Vendor","FieldType":"String","Caption":"Linked|Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"VName","FieldType":"String","Caption":"VName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CurrentStatus","FieldType":"Dropdown","Caption":"Relationship","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50,"CodeTable":"CFGClientCurrentStatus","LimitToList":true},{"FieldName":"ParentID","FieldType":"Client","Caption":"Parent","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ParentLevel1","FieldType":"String","Caption":"ParentLevel1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ParentLevel2","FieldType":"String","Caption":"ParentLevel2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ParentLevel3","FieldType":"String","Caption":"ParentLevel3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ParentLevel4","FieldType":"String","Caption":"ParentLevel4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ParentName","FieldType":"String","Caption":"ParentName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"HasHierarchy","FieldType":"Checkbox","Caption":"HasHierarchy","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"CustomCurrencyCode","FieldType":"Dropdown","Caption":"User Defined Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"ClientID","FieldType":"Client","Caption":"Name","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WebSite","FieldType":"String","Caption":"Web Site","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":250},{"FieldName":"Memo","FieldType":"Memo","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DisadvBusiness","FieldType":"Checkbox","Caption":"Disadvantaged Business","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DisabledVetOwnedSmallBusiness","FieldType":"Checkbox","Caption":"Service Disabled Veteran Owned","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"HBCU","FieldType":"Checkbox","Caption":"HBCU or Minority Institution","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"MinorityBusiness","FieldType":"Checkbox","Caption":"Minority Owned","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SmallBusiness","FieldType":"Checkbox","Caption":"Small Business","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"VetOwnedSmallBusiness","FieldType":"Checkbox","Caption":"Veteran Owned","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"WomanOwned","FieldType":"Checkbox","Caption":"Woman Owned","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AlaskaNative","FieldType":"Checkbox","Caption":"Alaska Native","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SpecialtyType","FieldType":"Dropdown","Caption":"Specialty Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CodeTable":"CFGPrimarySpecialty","LimitToList":true},{"FieldName":"Specialty","FieldType":"String","Caption":"Specialty","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"PriorWork","FieldType":"Checkbox","Caption":"Prior Work","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Recommend","FieldType":"Checkbox","Caption":"Recommend","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"GovernmentAgency","FieldType":"Checkbox","Caption":"Government Agency","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Competitor","FieldType":"Checkbox","Caption":"Competitor","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AnnualRevenue","FieldType":"Currency","Caption":"Annual Revenue","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Employees","FieldType":"Numeric","Caption":"Employee Count","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"MaxValue":2147483647},{"FieldName":"HUBZone","FieldType":"Checkbox","Caption":"HUB Zone","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"EightA","FieldType":"Checkbox","Caption":"8(a)","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"SocioEconomicStatus","FieldType":"String","Caption":"SocioEconomicStatus","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false},{"FieldName":"IQID","FieldType":"String","Caption":"GovWin IQ ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"SFID","FieldType":"String","Caption":"Salesforce ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"SFLastModifiedDate","FieldType":"Datetime","Caption":"SFLastModifiedDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Incumbent","FieldType":"Checkbox","Caption":"Incumbent","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"AjeraSync","FieldType":"Checkbox","Caption":"AjeraSync","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TLSyncModDate","FieldType":"Datetime","Caption":"TLSyncModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"TLInternalKey","FieldType":"String","Caption":"TLInternalKey","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Owner","FieldType":"Employee","Caption":"Owner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":5},{"FieldName":"SortName","FieldType":"String","Caption":"SortName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":40},{"FieldName":"Category","FieldType":"Dropdown","Caption":"Vendor Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"CodeTable":"CFGVendorType","LimitToList":true},{"FieldName":"AvailableForCRM","FieldType":"Checkbox","Caption":"CRM Users","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReadyForApproval","FieldType":"Checkbox","Caption":"Accounting Users","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReadyForProcessing","FieldType":"Checkbox","Caption":"Approved for use in processing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ReadyForProcessingForCompany","FieldType":"Checkbox","Caption":"Approved for use in processing in [Company]","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"FedID","FieldType":"String","Caption":"Federal ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"TypeOfTIN","FieldType":"Dropdown","Caption":"Type of TIN","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"1":"FEIN","2":"SSN, ITIN, ATIN"},"LimitToList":true},{"FieldName":"RecentWBSName","FieldType":"String","Caption":"Most Recent Project Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecentWBS1","FieldType":"String","Caption":"Most Recent Project ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecentPRRole","FieldType":"String","Caption":"Most Recent Project Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RecentPRRoleDescription","FieldType":"String","Caption":"Most Recent Project Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPStartDate","FieldType":"Datetime","Caption":"Last Activity Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPSubject","FieldType":"String","Caption":"Last Activity Subject","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPContactID","FieldType":"String","Caption":"Last Activity ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPCreateEmployee","FieldType":"String","Caption":"Last Activity Created by Employee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPCreateUserName","FieldType":"String","Caption":"Last Activity Created by User","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TopTPActivityID","FieldType":"String","Caption":"TopTPActivityID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwner","FieldType":"String","Caption":"emOwner","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwnerfl","FieldType":"String","Caption":"emOwnerfl","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwnerPhone","FieldType":"String","Caption":"emOwnerPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwnerEmail","FieldType":"String","Caption":"emOwnerEmail","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwnerTitle","FieldType":"String","Caption":"emOwnerTitle","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emOwnerLocation","FieldType":"String","Caption":"emOwnerLocation","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"emParentfl","FieldType":"String","Caption":"emParentfl","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HasPhoto","FieldType":"Numeric","Caption":"HasPhoto","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PhotoModDate","FieldType":"Datetime","Caption":"PhotoModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryAddress1","FieldType":"String","Caption":"Primary Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryAddress2","FieldType":"String","Caption":"Primary Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryAddress3","FieldType":"String","Caption":"Primary Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryAddress4","FieldType":"String","Caption":"Primary Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryCity","FieldType":"String","Caption":"Primary City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryState","FieldType":"Dropdown","Caption":"Primary State","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"PrimaryZip","FieldType":"String","Caption":"Primary Zip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryCountry","FieldType":"Dropdown","Caption":"Primary Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"PrimaryPhone","FieldType":"String","Caption":"PrimaryPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryFax","FieldType":"String","Caption":"PrimaryFax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PrimaryEmail","FieldType":"String","Caption":"PrimaryEmail","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingAddress1","FieldType":"String","Caption":"BillingAddress1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingAddress2","FieldType":"String","Caption":"BillingAddress2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingAddress3","FieldType":"String","Caption":"BillingAddress3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingAddress4","FieldType":"String","Caption":"BillingAddress4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingCity","FieldType":"String","Caption":"BillingCity","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingState","FieldType":"Dropdown","Caption":"BillingState","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"LimitToList":true},{"FieldName":"BillingZip","FieldType":"String","Caption":"BillingZip","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingCountry","FieldType":"Dropdown","Caption":"BillingCountry","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"BillingPhone","FieldType":"String","Caption":"BillingPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingFax","FieldType":"String","Caption":"BillingFax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingEmail","FieldType":"String","Caption":"BillingEmail","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentAddress1","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentAddress2","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentAddress3","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentAddress4","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentCity","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentState","FieldType":"String","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentZip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentCountry","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"PaymentPhone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentFax","FieldType":"String","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaymentEmail","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"QBOID","FieldType":"String","Caption":"QBO Reference","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":18},{"FieldName":"QBOLastUpdated","FieldType":"Datetime","Caption":"QBO Mod Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"CostAmount","FieldType":"Currency","Caption":"CostAmount","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Invoice","FieldType":"String","Caption":"Invoice","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"InvoiceUnpaid","FieldType":"String","Caption":"Invoice Unpaid","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OutstandingAR","FieldType":"Dropdown","Caption":"Outstanding AR","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"Codes":{"Y":"Yes","N":"No"},"LimitToList":true},{"FieldName":"RecordType","FieldType":"String","Caption":"Firm Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Org","FieldType":"Org","Caption":"Organization","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":11},{"FieldName":"OrgName","FieldType":"String","Caption":"OrgName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Org1","FieldType":"Org","Caption":"Org1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org1Name","FieldType":"Org","Caption":"Org1Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org2","FieldType":"Org","Caption":"Org2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org2Name","FieldType":"Org","Caption":"Org2Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org3","FieldType":"Org","Caption":"Org3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org3Name","FieldType":"Org","Caption":"Org3Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org4","FieldType":"Org","Caption":"Org4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org4Name","FieldType":"Org","Caption":"Org4Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org5","FieldType":"Org","Caption":"Org5","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"FieldName":"Org5Name","FieldType":"Org","Caption":"Org5Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":11},{"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_CustUDIC_NewFirmUDF","FieldType":"String","Caption":"New Firm UDF Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"CustUDIC_NewFirmUDF","FieldType":"UDIC","Caption":"New Firm UDF","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"UDICType":"UDIC_NewFirmUDF"},{"FieldName":"desc_custClientType","FieldType":"String","Caption":"Client Type Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custClientType","FieldType":"Dropdown","Caption":"Client Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"LimitToList":true},{"FieldName":"custNotes","FieldType":"Memo","Caption":"Notes","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custCheckBox","FieldType":"Checkbox","Caption":"Check Box","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custCUR","FieldType":"Currency","Caption":"CUR","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custLEAD","FieldType":"String","Caption":"LEAD Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custLEAD","FieldType":"Contact","Caption":"LEAD","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custDate","FieldType":"Date","Caption":"Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custORG","FieldType":"String","Caption":"ORG Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custORG","FieldType":"Org","Caption":"ORG","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":11},{"FieldName":"desc_custClientManager","FieldType":"String","Caption":"Client Manager Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custClientManager","FieldType":"Employee","Caption":"Client Manager","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":true,"MaxLength":5},{"FieldName":"custtest","FieldType":"Memo","Caption":"test","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"custRIGHT","FieldType":"String","Caption":"RIGHT","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custLEFT","FieldType":"String","Caption":"LEFT","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"Firm","CustomTableName":"ClientCustomTabFields"},"CLAddress":{"Keys":"ClientID,CLAddressID","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"},"ClendorProjectAssoc":{"Keys":"ClientID,WBS1,WBS2,WBS3","TableName":"ClendorProjectAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Number","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":"PrimaryInd","FieldType":"Checkbox","Caption":"Primary","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"Role","FieldType":"Dropdown","Caption":"Role","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGClientRole","LimitToList":true},{"FieldName":"RoleName","FieldType":"String","Caption":"RoleName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Address","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"RoleDescription","FieldType":"String","Caption":"RoleDescription","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"ClientConfidential","FieldType":"String","Caption":"ClientConfidential","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"ClientInd","FieldType":"Checkbox","Caption":"Client","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"VendorInd","FieldType":"Checkbox","Caption":"Vendor","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":"String","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":"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":"Stage","FieldType":"String","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PRStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1,"CodeTable":"CFGProjectStatus","LimitToList":true},{"FieldName":"DefaultType","FieldType":"String","Caption":"DefaultType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"PRProjectCurrencyCode","FieldType":"Dropdown","Caption":"Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"CostAmount","FieldType":"Currency","Caption":"Cost","DefaultValue":"0","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":"Projects"},"MktCampaignClientAssoc":{"Keys":"ClientID,ContactID,CampaignID","TableName":"MktCampaignClientAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"Contact","FieldType":"String","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"CampaignMgr","FieldType":"String","Caption":"CampaignMgr","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Stage","FieldType":"String","Caption":"Stage","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Status","FieldType":"String","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"CampaignID","FieldType":"String","Caption":"CampaignID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"ContactID","FieldType":"String","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"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"},"EMClientAssoc":{"Keys":"ClientID,Employee","TableName":"EMClientAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Employee","FieldType":"Employee","Caption":"Employee","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":5},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"Name","FieldType":"String","Caption":"Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":33},{"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":"HomeCompany","FieldType":"String","Caption":"HomeCompany","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LastName","FieldType":"String","Caption":"LastName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FirstName","FieldType":"String","Caption":"FirstName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MiddleName","FieldType":"String","Caption":"MiddleName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingPool","FieldType":"String","Caption":"BillingPool","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Address1","FieldType":"String","Caption":"Address1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Address2","FieldType":"String","Caption":"Address2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Address3","FieldType":"String","Caption":"Address3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"State","FieldType":"String","Caption":"State","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ZIP","FieldType":"String","Caption":"ZIP","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Country","FieldType":"String","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HomePhone","FieldType":"String","Caption":"HomePhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Fax","FieldType":"String","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EMail","FieldType":"String","Caption":"EMail","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TKAdminLevel","FieldType":"String","Caption":"TKAdminLevel","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TKAdminEdit","FieldType":"String","Caption":"TKAdminEdit","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EKAdminLevel","FieldType":"String","Caption":"EKAdminLevel","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EKAdminEdit","FieldType":"String","Caption":"EKAdminEdit","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Memo","FieldType":"String","Caption":"Memo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmployeePhoto","FieldType":"String","Caption":"EmployeePhoto","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Salutation","FieldType":"String","Caption":"Salutation","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Suffix","FieldType":"String","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Title","FieldType":"String","Caption":"Title","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ExportInd","FieldType":"String","Caption":"ExportInd","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WorkPhone","FieldType":"String","Caption":"WorkPhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MobilePhone","FieldType":"String","Caption":"MobilePhone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AvailableForCRM","FieldType":"String","Caption":"AvailableForCRM","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadyForApproval","FieldType":"String","Caption":"ReadyForApproval","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PreferredName","FieldType":"String","Caption":"PreferredName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HomePhoneFormat","FieldType":"String","Caption":"HomePhoneFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"FaxFormat","FieldType":"String","Caption":"FaxFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"WorkPhoneFormat","FieldType":"String","Caption":"WorkPhoneFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"MobilePhoneFormat","FieldType":"String","Caption":"MobilePhoneFormat","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Language","FieldType":"String","Caption":"Language","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TargetRatio","FieldType":"String","Caption":"TargetRatio","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"UtilizationRatio","FieldType":"String","Caption":"UtilizationRatio","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ConsultantInd","FieldType":"String","Caption":"ConsultantInd","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClientVendorInd","FieldType":"String","Caption":"ClientVendorInd","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Vendor","FieldType":"String","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TalentUserID","FieldType":"String","Caption":"TalentUserID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Location","FieldType":"String","Caption":"Location","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TLInternalKey","FieldType":"String","Caption":"TLInternalKey","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProfessionalSuffix","FieldType":"String","Caption":"ProfessionalSuffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TalentModDate","FieldType":"String","Caption":"TalentModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TLSyncModDate","FieldType":"String","Caption":"TLSyncModDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmployeeCompany","FieldType":"String","Caption":"EmployeeCompany","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JobCostRate","FieldType":"String","Caption":"JobCostRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JobCostType","FieldType":"String","Caption":"JobCostType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JCOvtPct","FieldType":"String","Caption":"JCOvtPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HoursPerDay","FieldType":"String","Caption":"HoursPerDay","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"HireDate","FieldType":"String","Caption":"HireDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RaiseDate","FieldType":"String","Caption":"RaiseDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Status","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":false,"CodeTable":"CFGEmployeeStatus","LimitToList":true},{"FieldName":"Type","FieldType":"String","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Org","FieldType":"String","Caption":"Org","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Region","FieldType":"String","Caption":"Region","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"BillingCategory","FieldType":"String","Caption":"BillingCategory","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TKGroup","FieldType":"String","Caption":"TKGroup","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EKGroup","FieldType":"String","Caption":"EKGroup","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PayRate","FieldType":"String","Caption":"PayRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PayType","FieldType":"String","Caption":"PayType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PayOvtPct","FieldType":"String","Caption":"PayOvtPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaySpecialOvtPct","FieldType":"String","Caption":"PaySpecialOvtPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ADPFileNumber","FieldType":"String","Caption":"ADPFileNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ADPCompanyCode","FieldType":"String","Caption":"ADPCompanyCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ADPRateCode","FieldType":"String","Caption":"ADPRateCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvCostRate","FieldType":"String","Caption":"ProvCostRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvBillRate","FieldType":"String","Caption":"ProvBillRate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvCostOTPct","FieldType":"String","Caption":"ProvCostOTPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvBillOTPct","FieldType":"String","Caption":"ProvBillOTPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultLC1","FieldType":"String","Caption":"DefaultLC1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultLC2","FieldType":"String","Caption":"DefaultLC2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultLC3","FieldType":"String","Caption":"DefaultLC3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultLC4","FieldType":"String","Caption":"DefaultLC4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultLC5","FieldType":"String","Caption":"DefaultLC5","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ChangeDefaultLC","FieldType":"String","Caption":"ChangeDefaultLC","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TerminationDate","FieldType":"String","Caption":"TerminationDate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"UseTotalHrsAsStd","FieldType":"String","Caption":"UseTotalHrsAsStd","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"JCSpecialOvtPct","FieldType":"String","Caption":"JCSpecialOvtPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvCostSpecialOTPct","FieldType":"String","Caption":"ProvCostSpecialOTPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProvBillSpecialOTPct","FieldType":"String","Caption":"ProvBillSpecialOTPct","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"YearsOtherFirms","FieldType":"String","Caption":"YearsOtherFirms","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Supervisor","FieldType":"String","Caption":"Supervisor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ReadyForProcessing","FieldType":"String","Caption":"ReadyForProcessing","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CheckHours","FieldType":"String","Caption":"CheckHours","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Locale","FieldType":"String","Caption":"Locale","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"LocaleMethod","FieldType":"String","Caption":"LocaleMethod","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OtherPay","FieldType":"String","Caption":"OtherPay","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OtherPay2","FieldType":"String","Caption":"OtherPay2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OtherPay3","FieldType":"String","Caption":"OtherPay3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OtherPay4","FieldType":"String","Caption":"OtherPay4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OtherPay5","FieldType":"String","Caption":"OtherPay5","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CostRateMeth","FieldType":"String","Caption":"CostRateMeth","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"CostRateTableNo","FieldType":"String","Caption":"CostRateTableNo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PayRateMeth","FieldType":"String","Caption":"PayRateMeth","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PayRateTableNo","FieldType":"String","Caption":"PayRateTableNo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PriorYearsFirm","FieldType":"String","Caption":"PriorYearsFirm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaychexCode1","FieldType":"String","Caption":"PaychexCode1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaychexCode2","FieldType":"String","Caption":"PaychexCode2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaychexCode3","FieldType":"String","Caption":"PaychexCode3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"IncludeLocalJurisOnly","FieldType":"String","Caption":"IncludeLocalJurisOnly","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AllowChargeUnits","FieldType":"String","Caption":"AllowChargeUnits","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RequireStartEndTime","FieldType":"String","Caption":"RequireStartEndTime","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"AllowBreakTime","FieldType":"String","Caption":"AllowBreakTime","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultBreakStartDateTime","FieldType":"String","Caption":"DefaultBreakStartDateTime","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DefaultBreakEndDateTime","FieldType":"String","Caption":"DefaultBreakEndDateTime","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"PaychexRateNumber","FieldType":"String","Caption":"PaychexRateNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmailPayrollRemittance","FieldType":"String","Caption":"EmailPayrollRemittance","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmailExpenseRemittance","FieldType":"String","Caption":"EmailExpenseRemittance","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"OccupationalCode","FieldType":"String","Caption":"OccupationalCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"GeographicCode","FieldType":"String","Caption":"GeographicCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"StatutoryEmployee","FieldType":"String","Caption":"StatutoryEmployee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"RetirementPlan","FieldType":"String","Caption":"RetirementPlan","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ThirdPartySickPay","FieldType":"String","Caption":"ThirdPartySickPay","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClieOpTransactionType","FieldType":"String","Caption":"ClieOpTransactionType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClieOp","FieldType":"String","Caption":"ClieOp","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClieOpAccount","FieldType":"String","Caption":"ClieOpAccount","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ClieOpAccountType","FieldType":"String","Caption":"ClieOpAccountType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SEPAIBAN","FieldType":"String","Caption":"SEPAIBAN","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"SEPABIC","FieldType":"String","Caption":"SEPABIC","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"TaxRegistrationNumber","FieldType":"String","Caption":"TaxRegistrationNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"DisableTSRevAudit","FieldType":"String","Caption":"DisableTSRevAudit","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"EmployeeName","FieldType":"String","Caption":"EmployeeName","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"},"ClientToClientAssoc":{"Keys":"FromClientID,ToClientID","TableName":"ClientToClientAssoc","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"FromClientID","FieldType":"String","Caption":"FromClientID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ToClientID","FieldType":"Client","Caption":"Firm","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ToClientName","FieldType":"String","Caption":"ToClientName","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":"CFGClientRelationship","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 Firms"},"VEAccounting":{"Keys":"Vendor,Company","TableName":"VEAccounting","GridID":"X","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"Vendor","FieldType":"String","Caption":"Vendor","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20},{"FieldName":"Company","FieldType":"Company","Caption":"Companyxxxxx","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":14},{"FieldName":"PayTerms","FieldType":"Dropdown","Caption":"Payment Terms","DefaultValue":"PWP","Hidden":false,"Required":false,"Updateable":true,"MaxLength":4,"Codes":{"Hold":"Hold","Next":"Next","PWP":"PWP"},"LimitToList":true},{"FieldName":"PayTermsDesc","FieldType":"String","Caption":"PayTermsDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"RegAccount","FieldType":"Account","Caption":"Regular Account","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":6},{"FieldName":"OHAccount","FieldType":"Account","Caption":"Indirect Account","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":6},{"FieldName":"DiscPct","FieldType":"Numeric","Caption":"Discount Percent","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DiscPeriod","FieldType":"Numeric","Caption":"DiscPeriod","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"DiscCode","FieldType":"Dropdown","Caption":"DiscCode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGAPDiscount","LimitToList":true},{"FieldName":"DiscCodeDesc","FieldType":"String","Caption":"DiscCodeDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"ThisYear1099","FieldType":"Currency","Caption":"ThisYear1099","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"LastYear1099","FieldType":"Currency","Caption":"LastYear1099","DefaultValue":"0","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"Req1099","FieldType":"Checkbox","Caption":"1099 Required","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"CheckPerVoucher","FieldType":"Checkbox","Caption":"CheckPerVoucher","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"AccountNumber","FieldType":"String","Caption":"AccountNumber","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":25},{"FieldName":"Memo","FieldType":"String","Caption":"Memo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"MemoPrintOnCheck","FieldType":"String","Caption":"MemoPrintOnCheck","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"EFTBankID","FieldType":"String","Caption":"Bank ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"EFTAccount","FieldType":"String","Caption":"Account Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"EFTAccountType","FieldType":"Dropdown","Caption":"Account Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"7":"Seven Digit","C":"Checking","S":"Savings","O":"Ordinary"},"LimitToList":true},{"FieldName":"EFTStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"A":"Add","W":"Wait","Y":"Active"},"LimitToList":true},{"FieldName":"EFTAddenda","FieldType":"Checkbox","Caption":"Addenda","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"EFTRemittance","FieldType":"Dropdown","Caption":"Remittance","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1,"Codes":{"E":"Email","Y":"Printed"},"LimitToList":true},{"FieldName":"POTemplate","FieldType":"Dropdown","Caption":"POTemplate","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":80,"Codes":{"ABC":"ABC","TEST":"TEST"},"LimitToList":true},{"FieldName":"MatchMethod","FieldType":"String","Caption":"MatchMethod","DefaultValue":"3","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"DefaultTaxCode","FieldType":"Dropdown","Caption":"Default Tax Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGBillTaxes","LimitToList":true},{"FieldName":"DefaultTaxCodeDesc","FieldType":"String","Caption":"DefaultTaxCodeDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"DefaultExpenseCode","FieldType":"Dropdown","Caption":"Default Expense Code","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGAPExpenseCode","LimitToList":true},{"FieldName":"DefaultExpenseCodeDesc","FieldType":"String","Caption":"DefaultExpenseCodeDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"BankName","FieldType":"String","Caption":"Bank Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"BankAddr1","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"BankAddr2","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"BankAddr3","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"BankAddr4","FieldType":"String","Caption":"Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":50},{"FieldName":"BankCity","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":30},{"FieldName":"BankState","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"BankZip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10},{"FieldName":"BankCountry","FieldType":"String","Caption":"Bank Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":2},{"FieldName":"BankIDType","FieldType":"Dropdown","Caption":"Bank ID Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGBankIDType","LimitToList":true},{"FieldName":"BankIDTypeDesc","FieldType":"String","Caption":"BankIDTypeDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"EFTEmail","FieldType":"String","Caption":"EFT Email","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true},{"FieldName":"BankID","FieldType":"String","Caption":"Bank ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"BankAccountIDType","FieldType":"Dropdown","Caption":"Account ID Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":10,"CodeTable":"CFGBankAccountIDType","LimitToList":true},{"FieldName":"BankAccountIDTypeDesc","FieldType":"String","Caption":"BankAccountIDTypeDesc","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"BankAccountID","FieldType":"String","Caption":"Account ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"EFTClieOp","FieldType":"Checkbox","Caption":"EFTClieOp","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"MaxLength":1},{"FieldName":"EFTTransactionType","FieldType":"String","Caption":"EFTTransactionType","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":100},{"FieldName":"SEPAIBAN","FieldType":"String","Caption":"IBAN","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"SEPABIC","FieldType":"String","Caption":"BIC","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":35},{"FieldName":"PurchasingContactID","FieldType":"Contact","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"PurchasingctName","FieldType":"String","Caption":"PurchasingctName","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ElectronicPaymentMethodID","FieldType":"Dropdown","Caption":"Electronic Payment Method","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"MaxLength":20,"Codes":{"nacha":"NACHA","sepa":"SEPA","clieop":"CLIEOP"},"LimitToList":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":"Vendor Accounting"},"ClientFileLinks":{"Keys":"LinkID,ClientID","TableName":"ClientFileLinks","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"LinkID","FieldType":"String","Caption":"LinkID","DefaultValue":"[GUID]","Hidden":false,"Required":false,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"ClientID","FieldType":"String","Caption":"ClientID","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":"Firms","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"},"Contacts":{"Keys":"ContactID","TableName":"Contacts","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ContactID","FieldType":"Contact","Caption":"ContactID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Salutation","FieldType":"Dropdown","Caption":"Prefix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGPrefix","LimitToList":true},{"FieldName":"FirstName","FieldType":"String","Caption":"First","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":25},{"FieldName":"MiddleName","FieldType":"String","Caption":"Middle","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"LastName","FieldType":"String","Caption":"Last","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"Suffix","FieldType":"Dropdown","Caption":"Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":20,"CodeTable":"CFGSuffix","LimitToList":true},{"FieldName":"PreferredName","FieldType":"String","Caption":"Preferred","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"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":false,"MaxLength":50,"CodeTable":"CFGContactSource","LimitToList":true},{"FieldName":"Type","FieldType":"Dropdown","Caption":"Type","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"LimitToList":true},{"FieldName":"ClientID","FieldType":"String","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":false,"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":false,"MaxLength":10,"CodeTable":"ContactStatus","LimitToList":true},{"FieldName":"CustomCurrencyCode","FieldType":"Dropdown","Caption":"User Defined Currency","DefaultValue":"[FUNCTIONALCURRENCYCODE]","Hidden":false,"Required":false,"Updateable":false,"MaxLength":3,"CodeTable":"FW_CFGCurrency","LimitToList":true},{"FieldName":"Address1","FieldType":"String","Caption":"Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Address2","FieldType":"String","Caption":"Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Address3","FieldType":"String","Caption":"Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"Address4","FieldType":"String","Caption":"Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"City","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"State","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"Zip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"Country","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"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":false,"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":false,"MaxLength":24},{"FieldName":"Pager","FieldType":"Phone","Caption":"Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"MailingAddress","FieldType":"Checkbox","Caption":"Mailing Address","DefaultValue":"Y","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"FirmAddress1","FieldType":"String","Caption":"Firm Business Address 1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"FirmAddress2","FieldType":"String","Caption":"Firm Business Address 2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"FirmAddress3","FieldType":"String","Caption":"Firm Business Address 3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"FirmAddress4","FieldType":"String","Caption":"Firm Business Address 4","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":50},{"FieldName":"FirmCity","FieldType":"String","Caption":"City","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":30},{"FieldName":"FirmState","FieldType":"Dropdown","Caption":"State/Province","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGStates","LimitToList":true},{"FieldName":"FirmZip","FieldType":"String","Caption":"Zip/Postcode","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"FirmCountry","FieldType":"Dropdown","Caption":"Country","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"FW_CFGCountry","LimitToList":true},{"FieldName":"FirmBusinessPhone","FieldType":"Phone","Caption":"Phone","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"FirmBusinessPhoneFormat","FieldType":"String","Caption":"Phone Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"FirmBusinessFax","FieldType":"Phone","Caption":"Fax","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"FirmBusinessFaxFormat","FieldType":"String","Caption":"Fax Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"FirmPager","FieldType":"Phone","Caption":"Pager","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"FirmDescription","FieldType":"String","Caption":"Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":100},{"FieldName":"Memo","FieldType":"String","Caption":"Memo","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"Billing","FieldType":"String","Caption":"Billing","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"PrimaryInd","FieldType":"String","Caption":"PrimaryInd","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"Addressee","FieldType":"String","Caption":"Addressee","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"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":false,"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":false,"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":false,"MaxLength":24},{"FieldName":"PagerFormat","FieldType":"String","Caption":"Pager Format","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"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":false,"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":false,"MaxLength":255},{"FieldName":"Rating","FieldType":"Dropdown","Caption":"Rating","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGLeadRating","LimitToList":true},{"FieldName":"Market","FieldType":"Dropdown","Caption":"Market","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"CFGClientType","LimitToList":true},{"FieldName":"Website","FieldType":"String","Caption":"Website","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"QualifiedStatus","FieldType":"Dropdown","Caption":"Qualified Status","DefaultValue":"sysQual","Hidden":false,"Required":false,"Updateable":false,"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":false,"MaxLength":10},{"FieldName":"StatusDate","FieldType":"Date","Caption":"Status Date","DefaultValue":"[TODAY]","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ProfessionalSuffix","FieldType":"String","Caption":"Professional Suffix","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"SFID","FieldType":"String","Caption":"Salesforce ID","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":18},{"FieldName":"SFLastModifiedDate","FieldType":"Datetime","Caption":"SF Last Modified Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"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":false,"MaxLength":1},{"FieldName":"FirmMailingAddress","FieldType":"String","Caption":"Firm Mailing Address","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":1},{"FieldName":"QBOID","FieldType":"String","Caption":"QBO Id","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":18},{"FieldName":"QBOIsMainContact","FieldType":"Checkbox","Caption":"Is main QBO contact","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"QBOLastUpdated","FieldType":"Datetime","Caption":"QBO Mod Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"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}],"Caption":"Contacts"},"ClientAlias":{"Keys":"PKey","TableName":"ClientAlias","GridID":null,"Hidden":false,"Updateable":true,"Fields":[{"FieldName":"PKey","FieldType":"String","Caption":"PKey","DefaultValue":"[GUID]","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":32},{"FieldName":"Alias","FieldType":"String","Caption":"Alias","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"MaxLength":100},{"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":"Aliases"},"PRContactAssoc":{"Keys":"ContactID,WBS1","TableName":"PRContactAssoc","GridID":null,"Hidden":false,"Updateable":false,"Fields":[{"FieldName":"ContactID","FieldType":"String","Caption":"Contact","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"flName","FieldType":"String","Caption":"Full Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false},{"FieldName":"ContactStatus","FieldType":"Dropdown","Caption":"Status","DefaultValue":"A","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10,"CodeTable":"ContactStatus","LimitToList":true},{"FieldName":"ClientID","FieldType":"Client","Caption":"Firm","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"ClientName","FieldType":"Client","Caption":"Firm Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":32},{"FieldName":"WBS1","FieldType":"WBS1","Caption":"Project Number","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":10},{"FieldName":"PRName","FieldType":"String","Caption":"Project Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"MaxLength":40},{"FieldName":"Email","FieldType":"String","Caption":"Email","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":255},{"FieldName":"Title","FieldType":"Dropdown","Caption":"Title","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":50,"LimitToList":true},{"FieldName":"Phone","FieldType":"String","Caption":"Phone","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":24},{"FieldName":"CellPhone","FieldType":"Dropdown","Caption":"Mobile","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":24,"LimitToList":true},{"FieldName":"CLAddress","FieldType":"String","Caption":"Client Location","DefaultValue":"","Hidden":true,"Required":false,"Updateable":false,"MaxLength":20}],"Caption":"Associated Projects"},"Clients_RCE1":{"Keys":"Seq,ClientID","CustomTable":true,"TableName":"Clients_RCE1","GridID":"custRCE1","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"cust1","FieldType":"String","Caption":"1","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"cust3","FieldType":"String","Caption":"3","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"cust2","FieldType":"String","Caption":"2","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"RCE1"},"Clients_RCE3":{"Keys":"Seq,ClientID","CustomTable":true,"TableName":"Clients_RCE3","GridID":"custRCE3","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"custjdlkfsdfk","FieldType":"String","Caption":"jdlkfsdfk","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"RCE3"},"Clients_RCE2":{"Keys":"Seq,ClientID","CustomTable":true,"TableName":"Clients_RCE2","GridID":"custRCE2","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"custsdfsdfdsfs","FieldType":"String","Caption":"sdfsdfdsfs","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255}],"Caption":"RCE2"},"Vendors_OutsideExperience":{"Keys":"Seq,ClientID","CustomTable":true,"TableName":"Vendors_OutsideExperience","GridID":"custOutsideExperience","Hidden":false,"Updateable":true,"Fields":[{"FieldName":"ClientID","FieldType":"String","Caption":"ClientID","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":"custProjectName","FieldType":"String","Caption":"Project Name","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true,"MaxLength":255},{"FieldName":"custCompletionDate","FieldType":"Date","Caption":"Completion Date","DefaultValue":"","Hidden":false,"Required":false,"Updateable":true,"CustomField":true},{"FieldName":"desc_custClient","FieldType":"String","Caption":"Client Description","DefaultValue":"","Hidden":false,"Required":false,"Updateable":false,"CustomField":true},{"FieldName":"custClient","FieldType":"Firm","Caption":"Client","DefaultValue":"","Hidden":false,"Required":true,"Updateable":true,"CustomField":true,"MaxLength":32},{"FieldName":"custActualEst","FieldType":"Checkbox","Caption":"Actual/Est.","DefaultValue":"N","Hidden":false,"Required":false,"Updateable":true,"CustomField":true}],"Caption":"Outside Experience"}}