Mercury Schemas · Mercury Customer Portal

Views:

Click to jump to a schema, then browse by Display Name or use Ctrl+F to find a specific entry.

Contact schema - Client schema - Vacancy schema - Placement schema - Fee schema

Contact schema

Entity	Contact

Logical Name	Schema Name	Display Name
stageid	StageId	(Deprecated) Process Stage
traversedpath	TraversedPath	(Deprecated) Traversed Path
adx_identity_accessfailedcount	adx_identity_accessfailedcount	Access Failed Count
accountid	AccountId	Account
mercury_accountinglegalentity	mercury_accountinglegalentity	Accounting legal entity
mercury_activecontracttempplacements	mercury_activecontracttempplacements	Active Contract Temp Placements
mercury_activecontracttempplacements_date	mercury_activecontracttempplacements_Date	Active Contract Temp Placements (Last Updated On)
mercury_activecontracttempplacements_state	mercury_activecontracttempplacements_State	Active Contract Temp Placements (State)
mercury_activeinterviews	mercury_activeinterviews	Active Interviews
mercury_activeinterviews_date	mercury_activeinterviews_Date	Active Interviews (Last Updated On)
mercury_activeinterviews_state	mercury_activeinterviews_State	Active Interviews (State)
mercury_activeoffers	mercury_activeoffers	Active Offers
mercury_activeoffers_date	mercury_activeoffers_Date	Active Offers (Last Updated On)
mercury_activeoffers_state	mercury_activeoffers_State	Active Offers (State)
mercury_activepermanentplacements	mercury_activepermanentplacements	Active Permanent Placements
mercury_activepermanentplacements_date	mercury_activepermanentplacements_Date	Active Permanent Placements (Last Updated On)
mercury_activepermanentplacements_state	mercury_activepermanentplacements_State	Active Permanent Placements (State)
mercury_activevacancies	mercury_activevacancies	Active Vacancies
mercury_activevacancies_date	mercury_activevacancies_Date	Active Vacancies (Last Updated On)
mercury_activevacancies_state	mercury_activevacancies_State	Active Vacancies (State)
address1_fax	Address1_Fax	Address 1: Fax
address1_freighttermscode	Address1_FreightTermsCode	Address 1: Freight Terms
address1_addressid	Address1_AddressId	Address 1: ID
address1_telephone1	Address1_Telephone1	Address 1: Phone
address1_postofficebox	Address1_PostOfficeBox	Address 1: Post Office Box
address1_primarycontactname	Address1_PrimaryContactName	Address 1: Primary Contact Name
address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method
address1_telephone2	Address1_Telephone2	Address 1: Telephone 2
address1_telephone3	Address1_Telephone3	Address 1: Telephone 3
address1_upszone	Address1_UPSZone	Address 1: UPS Zone
address1_utcoffset	Address1_UTCOffset	Address 1: UTC Offset
address2_fax	Address2_Fax	Address 2: Fax
address2_freighttermscode	Address2_FreightTermsCode	Address 2: Freight Terms
address2_addressid	Address2_AddressId	Address 2: ID
address2_postofficebox	Address2_PostOfficeBox	Address 2: Post Office Box
address2_primarycontactname	Address2_PrimaryContactName	Address 2: Primary Contact Name
address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method
address2_telephone1	Address2_Telephone1	Address 2: Telephone 1
address2_telephone2	Address2_Telephone2	Address 2: Telephone 2
address2_telephone3	Address2_Telephone3	Address 2: Telephone 3
address2_upszone	Address2_UPSZone	Address 2: UPS Zone
address2_utcoffset	Address2_UTCOffset	Address 2: UTC Offset
address3_fax	Address3_Fax	Address 3: Fax
address3_freighttermscode	Address3_FreightTermsCode	Address 3: Freight Terms
address3_addressid	Address3_AddressId	Address 3: ID
address3_postofficebox	Address3_PostOfficeBox	Address 3: Post Office Box
address3_primarycontactname	Address3_PrimaryContactName	Address 3: Primary Contact Name
address3_shippingmethodcode	Address3_ShippingMethodCode	Address 3: Shipping Method
address3_telephone1	Address3_Telephone1	Address 3: Telephone1
address3_telephone2	Address3_Telephone2	Address 3: Telephone2
address3_telephone3	Address3_Telephone3	Address 3: Telephone3
address3_upszone	Address3_UPSZone	Address 3: UPS Zone
address3_utcoffset	Address3_UTCOffset	Address 3: UTC Offset
recruit_addresscascaderowversion	recruit_addresscascaderowversion	Address Cascade Row Version
recruit_work_addrescountry	recruit_work_addresCountry	Address Country
crimson_addresslookup	crimson_AddressLookup	Address Lookup
crimson_addressurl	crimson_AddressUrl	Address Url
cdi_age	cdi_age	Age
aging30	Aging30	Aging 30
aging30_base	Aging30_Base	Aging 30 (Base)
aging60	Aging60	Aging 60
aging60_base	Aging60_Base	Aging 60 (Base)
aging90	Aging90	Aging 90
aging90_base	Aging90_Base	Aging 90 (Base)
recruit_alltags	recruit_alltags	All candidate tags
mercury_alltags	mercury_alltags	All tags
cdi_allowtextmessages	cdi_allowtextmessages	Allow Text Messages
anniversary	Anniversary	Anniversary
annualincome	AnnualIncome	Annual Income
annualincome_base	AnnualIncome_Base	Annual Income (Base)
recruit_anonymised	recruit_Anonymised	Anonymised?
recruit_appliedforvacancies	recruit_appliedforvacancies	Applied For Vacancies
recruit_approvervalidated	recruit_ApproverValidated	Approver Validated
recruit_assignmentowner	recruit_assignmentowner	Assignment owner
assistantname	AssistantName	Assistant
mercury_assistantid	mercury_AssistantId	Assistant (Lookup)
assistantphone	AssistantPhone	Assistant Phone
isautocreate	IsAutoCreate	Auto-created
recruit_autonumber	recruit_autonumber	Autonumber
recruit_availability	recruit_availability	Availability
isbackofficecustomer	IsBackofficeCustomer	Back Office Customer
birthdate	BirthDate	Birthday
donotemail	DoNotEMail	Block Emails
recruit_donotsms	recruit_donotsms	Block SMS
recruit_booleanuserfield1	recruit_booleanuserfield1	Boolean User Field 1
recruit_booleanuserfield2	recruit_booleanuserfield2	Boolean User Field 2
recruit_booleanuserfield3	recruit_booleanuserfield3	Boolean User Field 3
recruit_booleanuserfield4	recruit_booleanuserfield4	Boolean User Field 4
recruit_booleanuserfield5	recruit_booleanuserfield5	Boolean User Field 5
recruit_broadbeanid	recruit_broadbeanid	Broadbean Id
businesscard	BusinessCard	Business Card
business2	Business2	Business Phone 2
businesscardattributes	BusinessCardAttributes	BusinessCardAttributes
callback	Callback	Callback Number
recruit_candidateactivitytypes	recruit_candidateactivitytypes	Candidate Activity Types
recruit_candidatecompanyid	recruit_candidatecompanyid	Candidate Company
recruit_candidatecontactstatus	recruit_candidatecontactstatus	Candidate contact status
recruit_candidatecrimsonid	recruit_candidatecrimsonid	Candidate ID
recruit_candidateportalrole	recruit_candidateportalrole	Candidate Portal Role
recruit_candidateselfsummary	recruit_candidateselfsummary	Candidate Self Summary
recruit_candidatesubgridoptionset	recruit_candidatesubgridoptionset	Candidate Subgrid optionset
recruit_candidatetagcontrol0	recruit_candidatetagcontrol0	Candidate Tag Control 0
recruit_candidatetagcontrol1	recruit_candidatetagcontrol1	Candidate Tag Control 1
recruit_candidatetagcontrol2	recruit_candidatetagcontrol2	Candidate Tag Control 2
recruit_candidatetagcontrol3	recruit_candidatetagcontrol3	Candidate Tag Control 3
recruit_candidatetagcontrol4	recruit_candidatetagcontrol4	Candidate Tag Control 4
recruit_candidatetagcontrolids	recruit_candidatetagcontrolids	Candidate Tag Control Ids
recruit_candidatevalidated	recruit_CandidateValidated	Candidate Validated
childrensnames	ChildrensNames	Children's Names
crimson_christmascard	crimson_ChristmasCard	Christmas Card
recruit_cientactivities	recruit_cientactivities	Client Activities
recruit_clientcontactoptionset	recruit_ClientContactOptionset	Client Contact Optionset
recruit_clientcontactstatus	recruit_clientcontactstatus	Client contact status
recruit_clientcontacttagcontrol0	recruit_clientcontacttagcontrol0	Client Contact Tag Control 0
recruit_clientcontacttagcontrol1	recruit_clientcontacttagcontrol1	Client Contact Tag Control 1
recruit_clientcontacttagcontrol2	recruit_clientcontacttagcontrol2	Client Contact Tag Control 2
recruit_clientcontacttagcontrol3	recruit_clientcontacttagcontrol3	Client Contact Tag Control 3
recruit_clientcontacttagcontrol4	recruit_clientcontacttagcontrol4	Client Contact Tag Control 4
recruit_clientcontacttagcontrolids	recruit_clientcontacttagcontrolids	Client Contact Tag Control Ids
recruit_clientcontactvalidated	recruit_ClientContactValidated	Client Contact Validated
mercury_clientportalaccessmode	mercury_clientportalaccessmode	Client Portal Access Mode
mercury_clientportaladmin	mercury_clientportaladmin	Client Portal Admin
recruit_clientportalrole	recruit_ClientPortalRole	Client Portal Role
recruit_clientrelationshipowner	recruit_clientrelationshipowner	Client relationship owner
recruit_comments	recruit_comments	Comments
company	Company	Company Phone
mercury_complete	mercury_Complete	Complete %
adx_confirmremovepassword	adx_ConfirmRemovePassword	Confirm Remove Password
contactid	ContactId	Contact
crimson_contactid	crimson_contactId	Contact (Lookup)
crimson_contactmarketingcomms	crimson_ContactMarketingComms	Contact Marketing Comms
recruit_contactpreference	recruit_contactpreference	Contact Preference
crimson_contractowner	crimson_ContractOwner	Contract Owner
recruit_workpref_contractor	recruit_workpref_Contractor	Contractor
address3_composite	Address3_Composite	Correspondence address
address3_addresstypecode	Address3_AddressTypeCode	Correspondence address: Address Type
address3_city	Address3_City	Correspondence address: City
recruit_address3_country	recruit_address3_country	Correspondence address: Country
address3_country	Address3_Country	Correspondence address: Country [text]
address3_county	Address3_County	Correspondence address: County
address3_latitude	Address3_Latitude	Correspondence address: Latitude
address3_longitude	Address3_Longitude	Correspondence address: Longitude
address3_name	Address3_Name	Correspondence address: Name
address3_postalcode	Address3_PostalCode	Correspondence address: Post code
recruit_address3_stateorprovince	recruit_address3_stateorprovince	Correspondence address: State
address3_stateorprovince	Address3_StateOrProvince	Correspondence address: State/Province [text]
address3_line1	Address3_Line1	Correspondence address: Street 1
address3_line2	Address3_Line2	Correspondence address: Street 2
address3_line3	Address3_Line3	Correspondence address: Street 3
recruit_countryoforigin	recruit_countryoforigin	Country of Origin
createdby	CreatedBy	Created By
createdonbehalfby	CreatedOnBehalfBy	Created By (Delegate)
createdbyexternalparty	CreatedByExternalParty	Created By (External Party)
adx_createdbyipaddress	Adx_CreatedByIPAddress	Created By IP Address
adx_createdbyusername	Adx_CreatedByUsername	Created By Username
createdon	CreatedOn	Created On
creditonhold	CreditOnHold	Credit Hold
creditlimit	CreditLimit	Credit Limit
creditlimit_base	CreditLimit_Base	Credit Limit (Base)
transactioncurrencyid	TransactionCurrencyId	Currency
parentcustomerid	ParentCustomerId	Current Client
recruit_currentplacement	recruit_currentplacement	Current Placement
recruit_contractcurrentrate	recruit_contractcurrentrate	Current Rate (Contract)
recruit_currentratecontractcurrency	recruit_currentratecontractcurrency	Current Rate (Contract) Currency
recruit_currentratecontractcurrency_base	recruit_currentratecontractcurrency_Base	Current Rate (Contract) Currency (Base)
recruit_tempcurrentrate	recruit_tempcurrentrate	Current Rate (Temp)
recruit_currentratetempcurrency	recruit_currentratetempcurrency	Current Rate (Temp) Currency
recruit_currentratetempcurrency_base	recruit_currentratetempcurrency_Base	Current Rate (Temp) Currency (Base)
recruit_currentsalary	recruit_currentsalary	Current Salary
recruit_currentsalary_base	recruit_currentsalary_Base	Current Salary (Base)
customersizecode	CustomerSizeCode	Customer Size
recruit_lastcv	recruit_LastCV	CV Last Edited
recruit_lastcvupdate	recruit_LastCVUpdate	CV Last Received
recruit_cvpreviewurl	recruit_cvpreviewurl	CV PreviewUrl
recruit_cvreference	recruit_cvreference	CV Reference
recruit_cvurl	recruit_cvurl	CV Url
mercury_dataremovaldue	mercury_dataremovaldue	Data Removal Due
mercury_dataremovalrequested	mercury_dataremovalrequested	Data Removal Requested
mercury_dataremoved	mercury_dataremoved	Data Removed
mercury_datarequestdue	mercury_datarequestdue	Data Request Due
mercury_datarequestprovided	mercury_datarequestprovided	Data Request Provided
mercury_datarequestreceived	mercury_datarequestreceived	Data Request Received
crimson_dob	crimson_DOB	Date Of Birth
recruit_dateuserfield1	recruit_dateuserfield1	Date User Field 1
recruit_dateuserfield2	recruit_dateuserfield2	Date User Field 2
recruit_dateuserfield3	recruit_dateuserfield3	Date User Field 3
recruit_dateuserfield4	recruit_dateuserfield4	Date User Field 4
recruit_dateuserfield5	recruit_dateuserfield5	Date User Field 5
recruit_datetimeuserfield1	recruit_datetimeuserfield1	Datetime User Field 1
recruit_datetimeuserfield2	recruit_datetimeuserfield2	Datetime User Field 2
recruit_datetimeuserfield3	recruit_datetimeuserfield3	Datetime User Field 3
recruit_datetimeuserfield4	recruit_datetimeuserfield4	Datetime User Field 4
recruit_datetimeuserfield5	recruit_datetimeuserfield5	Datetime User Field 5
crimson_ddi	crimson_DDI	DDI
msdyn_decisioninfluencetag	msdyn_decisioninfluencetag	Decision influence labels
recruit_defaultbankaccountid	recruit_defaultbankaccountid	Default Bank Account
department	Department	Department
description	Description	Description
msdyn_disablewebtracking	msdyn_disablewebtracking	Disable Web Tracking
mercury_discipline	mercury_discipline	Discipline
donotbulkpostalmail	DoNotBulkPostalMail	Do not allow Bulk Mails
donotfax	DoNotFax	Do not allow Faxes
donotpostalmail	DoNotPostalMail	Do not allow Mails
donotphone	DoNotPhone	Do not allow Phone Calls
recruit_donotbulkemailcandidate	recruit_donotbulkemailcandidate	Do not allow Sales Emails (candidate)
donotbulkemail	DoNotBulkEMail	Do not allow Sales Emails (client)
recruit_documentlocationwascreated	recruit_documentlocationwascreated	Document location was created
recruit_drivinglicence	recruit_DrivingLicence	Driving Licence
educationcode	EducationCode	Education
adx_identity_emailaddress1confirmed	adx_identity_emailaddress1confirmed	Email Confirmed
mercury_emaillimitdefinition	mercury_emaillimitdefinition	Email limit definition
mercury_emaillimittracker	mercury_emaillimittracker	Email limit tracker
spousesname	SpousesName	Emergency Contact Name
recruit_emergencyphonenumber	recruit_emergencyphonenumber	Emergency Phone Number
employeeid	EmployeeId	Employee
entityimage	EntityImage	Entity Image
entityimageid	EntityImageId	Entity Image Id
recruit_ethnicity	recruit_ethnicity	Ethnicity
recruit_ethnicityuk	recruit_ethnicityuk	Ethnicity UK
recruit_euresidentyn	recruit_EUResidentYN	EU Resident
recruit_euworkpermitexpiry	recruit_EUWorkPermitExpiry	EU Work Permit Expiry
recruit_euworkpermityn	recruit_EUWorkPermitYN	EU Work Permit YN
exchangerate	ExchangeRate	Exchange Rate
recruit_expratec	recruit_ExpRateC	Exp Rate High (C/T)
recruit_expratec_base	recruit_expratec_Base	Exp Rate High (C/T) (Base)
recruit_expratelowc	recruit_expratelowc	Exp Rate Low (C/T)
recruit_expratelowc_base	recruit_expratelowc_Base	Exp Rate Low (C/T) (Base)
recruit_expsalaryhighp	recruit_expsalaryhighp	Exp Salary High (P)
recruit_expsalaryhighp_base	recruit_expsalaryhighp_Base	Exp Salary High (P) (Base)
recruit_expsalaryp	recruit_ExpSalaryP	Exp Salary Low (P)
recruit_expsalaryp_base	recruit_expsalaryp_Base	Exp Salary Low (P) (Base)
mercury_externalsystemkey	mercury_externalsystemkey	External System Key
recruit_externalsystemkeycandidate	recruit_externalsystemkeycandidate	External system key (candidate)
externaluseridentifier	ExternalUserIdentifier	External User Identifier
cdi_facebook	cdi_facebook	Facebook
crimson_familydetails	crimson_FamilyDetails	Family Details
firstname	FirstName	First Name
followemail	FollowEmail	Follow Email Activity
recruit_forcelinkedinsync	recruit_forcelinkedinsync	Force LinkedIn Sync
ftpsiteurl	FtpSiteUrl	FTP Site
fullname	FullName	Full Name
msdyn_gdproptout	msdyn_gdproptout	GDPR Optout
gendercode	GenderCode	Gender
recruit_geocodingresult	recruit_geocodingresult	Geocoding result
recruit_geocodingresultaddress1	recruit_geocodingresultaddress1	Geocoding result (address1)
recruit_geocodingstatus	recruit_geocodingstatus	Geocoding status
recruit_geocodingstatusaddress1	recruit_geocodingstatusaddress1	Geocoding status (address1)
governmentid	GovernmentId	Government
cdi_grade	cdi_grade	Grade
haschildrencode	HasChildrenCode	Has Children
recruit_hash	recruit_hash	Hash
crimson_hobbyboxing	crimson_HobbyBoxing	Hobby Boxing
crimson_hobbycars	crimson_HobbyCars	Hobby Cars
crimson_hobbyfootball	crimson_HobbyFootball	Hobby Football
crimson_hobbygolf	crimson_HobbyGolf	Hobby Golf
crimson_hobbyhorseracing	crimson_HobbyHorseRacing	Hobby Horse Racing
crimson_hobbyrugby	crimson_HobbyRugby	Hobby Rugby
address2_composite	Address2_Composite	Home address
address2_addresstypecode	Address2_AddressTypeCode	Home address: Address Type
address2_city	Address2_City	Home address: City
recruit_address2_country	recruit_address2_country	Home address: Country
address2_country	Address2_Country	Home address: Country [text]
address2_county	Address2_County	Home address: County
address2_latitude	Address2_Latitude	Home address: Latitude
address2_longitude	Address2_Longitude	Home address: Longitude
address2_name	Address2_Name	Home address: Name
address2_postalcode	Address2_PostalCode	Home address: Post code
recruit_address2_state	recruit_address2_state	Home address: State
address2_stateorprovince	Address2_StateOrProvince	Home address: State/Province [text]
address2_line1	Address2_Line1	Home address: Street 1
address2_line2	Address2_Line2	Home address: Street 2
address2_line3	Address2_Line3	Home address: Street 3
recruit_faxhome	recruit_faxhome	Home fax
home2	Home2	Home Phone 2
cdi_identifiedon	cdi_identifiedon	Identified On
cdi_image	cdi_image	Image
importsequencenumber	ImportSequenceNumber	Import Sequence Number
mercury_importednote	mercury_ImportedNote	Imported Note
recruit_importednotecandidate	recruit_importednotecandidate	Imported note (candidate)
mercury_importedrecordid	mercury_ImportedRecordId	Imported Record Id
recruit_importedrecordidcandidate	recruit_importedrecordidcandidate	Imported record ID (candidate)
recruit_indextrigger2	recruit_indextrigger2	Index trigger 2
cdi_ip	cdi_ip	IP
recruit_iprofileid	recruit_iprofileId	iprofile Id
msdyn_isassistantinorgchart	msdyn_isassistantinorgchart	Is Assistant
recruit_iscandidatecontact	recruit_iscandidatecontact	Is Candidate Contact?
recruit_isclientcontact	recruit_isclientcontact	Is Client Contact?
msdyn_isminor	msdyn_isminor	Is Minor
msdyn_isminorwithparentalconsent	msdyn_isminorwithparentalconsent	Is Minor with Parental Consent
jobtitle	JobTitle	Job Title
recruit_knownas	recruit_knownas	Known As
msdyn_contactkpiid	msdyn_contactkpiid	KPI
recruit_lastapplicationdate	recruit_lastapplicationdate	Last Application Date
mercury_lastcalled	mercury_lastcalled	Last Called
recruit_lastcalledasclient	recruit_lastcalledasclient	Last Called As Client
mercury_lastcalledby	mercury_lastcalledby	Last Called By
recruit_lastcalledbyasclient	recruit_lastcalledbyasclient	Last Called By As Client
mercury_lastcontacted	mercury_LastContacted	Last Contacted
recruit_lastcontactedasclient	recruit_lastcontactedasclient	Last Contacted As Client
mercury_lastcontactedby	mercury_LastContactedBy	Last Contacted By
recruit_lastcontactedbyasclient	recruit_lastcontactedbyasclient	Last Contacted By As Client
lastusedincampaign	LastUsedInCampaign	Last Date Included in Campaign
mercury_lastemailed	mercury_lastemailed	Last Emailed
recruit_lastemailedasclient	recruit_lastemailedasclient	Last Emailed As Client
mercury_lastemailedby	mercury_lastemailedby	Last Emailed By
recruit_lastemailedbyasclient	recruit_lastemailedbyasclient	Last Emailed By As Client
recruit_lastindexablechange	recruit_lastindexablechange	Last Indexable Change
recruit_lastlogindate	recruit_lastlogindate	Last Login Date
recruit_lastmodifiedui	recruit_lastmodifiedui	Last Modified UI
lastname	LastName	Last Name
lastonholdtime	LastOnHoldTime	Last On Hold Time
recruit_lastsalesemailcandidate	recruit_lastsalesemailcandidate	Last Sales Email Candidate
recruit_lastsalesemailclient	recruit_lastsalesemailclient	Last Sales Email Client
slainvokedid	SLAInvokedId	Last SLA applied
adx_identity_lastsuccessfullogin	adx_identity_lastsuccessfullogin	Last Successful Login
recruit_currentemployer	recruit_CurrentEmployer	Latest Employer
recruit_currentpackage	recruit_currentpackage	Latest Package
recruit_candidatesource	recruit_candidatesource	Latest Source
cdi_latitude	cdi_latitude	Latitude
leadsourcecode	LeadSourceCode	Lead Source
recruit_linkedviastubprofile	recruit_linkedviastubprofile	Linked Via Stub Profile
cdi_linkedin	cdi_linkedin	LinkedIn
recruit_linkedinclosedcandidate	recruit_linkedinclosedcandidate	LinkedIn Closed Candidate
recruit_linkedindataissue	recruit_linkedindataissue	LinkedIn Data Issue
recruit_linkedinid	recruit_linkedinid	LinkedIn Id
mercury_linkedinprofileurl	mercury_linkedInprofileURL	LinkedIn profile URL
recruit_linkedinreference	recruit_linkedinreference	LinkedIn Reference
adx_identity_locallogindisabled	adx_identity_locallogindisabled	Local Login Disabled
recruit_lockedout	recruit_lockedout	Locked out
adx_identity_lockoutenabled	adx_identity_lockoutenabled	Lockout Enabled
adx_identity_lockoutenddate	adx_identity_lockoutenddate	Lockout End Date
recruit_loginattempts	recruit_loginattempts	Login attempts
adx_identity_logonenabled	adx_identity_logonenabled	Login Enabled
cdi_longitude	cdi_Longitude	Longitude
managername	ManagerName	Manager
crimson_managerid	crimson_ManagerId	Manager (Lookup)
managerphone	ManagerPhone	Manager Phone
msa_managingpartnerid	msa_managingpartnerid	Managing Partner
familystatuscode	FamilyStatusCode	Marital Status
marketingonly	MarketingOnly	Marketing Only
masterid	MasterId	Master ID
merged	Merged	Merged
middlename	MiddleName	Middle Name
adx_identity_mobilephoneconfirmed	adx_identity_mobilephoneconfirmed	Mobile Phone Confirmed
modifiedby	ModifiedBy	Modified By
modifiedonbehalfby	ModifiedOnBehalfBy	Modified By (Delegate)
modifiedbyexternalparty	ModifiedByExternalParty	Modified By (External Party)
adx_modifiedbyipaddress	Adx_ModifiedByIPAddress	Modified By IP Address
adx_modifiedbyusername	Adx_ModifiedByUsername	Modified By Username
modifiedon	ModifiedOn	Modified On
recruit_nationalityid	recruit_nationalityid	Nationality
recruit_nationality	recruit_nationality	Nationality (free text)
recruit_needsindexing	recruit_needsindexing	Needs Indexing
recruit_needspasswordreset	recruit_needspasswordreset	Needs Password Reset
recruit_needspasswordreset_candidate	recruit_needspasswordreset_candidate	Needs Password Reset (Candidate)
adx_identity_newpassword	adx_identity_newpassword	New Password Input
crimson_newslettersubscription	crimson_NewsletterSubscription	Newsletter Subscription
recruit_nextcalldate	recruit_NextCallDate	Next Call Date
recruit_nireference	recruit_nireference	NI Reference
nickname	NickName	Nickname
numberofchildren	NumberOfChildren	No. of Children
recruit_normalisedphone	recruit_normalisedPhone	Normalised Phone
msdyn_orgchangestatus	msdyn_orgchangestatus	Not at Company Flag
recruit_noticeperiod	recruit_NoticePeriod	Notice Period
recruit_noticeperiodperiod	recruit_noticeperiodperiod	Notice Period Period
recruit_numericuserfield1	recruit_numericuserfield1	Numeric User Field 1
recruit_numericuserfield2	recruit_numericuserfield2	Numeric User Field 2
recruit_numericuserfield3	recruit_numericuserfield3	Numeric User Field 3
recruit_numericuserfield4	recruit_numericuserfield4	Numeric User Field 4
recruit_numericuserfield5	recruit_numericuserfield5	Numeric User Field 5
recruit_offlimitscascaderowversion	recruit_offlimitscascaderowversion	Off Limits Cascade Row Version
recruit_offlimitsexpirydate	recruit_offlimitsexpirydate	Off Limits Expiry Date
recruit_dnhh	recruit_dnhh	Off Limits Reason (Candidate)
mercury_dnhh	mercury_dnhh	Off Limits Reason (Client Contact)
onholdtime	OnHoldTime	On Hold Time (Minutes)
adx_organizationname	Adx_OrganizationName	Organization Name
recruit_originalsource	recruit_originalsource	Original Source
originatingleadid	OriginatingLeadId	Originating Lead
recruit_othercontacts	recruit_othercontacts	Other contacts
emailaddress3	EMailAddress3	Other email
recruit_faxother	recruit_faxother	Other fax
recruit_mobileother	recruit_mobileother	Other mobile
telephone3	Telephone3	Other phone
recruit_othertags	recruit_othertags	Other Tags
ownerid	OwnerId	Owner
owningbusinessunit	OwningBusinessUnit	Owning Business Unit
recruit_owningconsultant	recruit_owningconsultant	Owning Consultant
owningteam	OwningTeam	Owning Team
owninguser	OwningUser	Owning User
pager	Pager	Pager
parentcontactid	ParentContactId	Parent Contact
parentcustomeridtype	ParentCustomerIdType	Parent Customer Type
participatesinworkflow	ParticipatesInWorkflow	Participates in Workflow
cdi_partitionkey	cdi_partitionkey	Partition Key
adx_identity_passwordhash	adx_identity_passwordhash	Password Hash
mercury_passwordlastchanged	mercury_PasswordLastChanged	Password Last Changed
recruit_passwordlastchanged	recruit_passwordlastchanged	Password Last Changed (Candidate)
recruit_passwordsalt	recruit_passwordsalt	Password salt
paymenttermscode	PaymentTermsCode	Payment Terms
recruit_temprateper	recruit_temprateper	Per
recruit_contractrateper2	recruit_contractrateper2	Per (Contract)
recruit_workpref_permanent	recruit_workpref_Permanent	Permanent
crimson_permanentowner	crimson_PermanentOwner	Permanent Owner
emailaddress2	EMailAddress2	Personal email
recruit_mobilehome	recruit_mobilehome	Personal mobile
telephone2	Telephone2	Personal phone
recruit_placeability	recruit_placeability	Placeability
recruit_portalchangepasswordonlogin	recruit_portalchangepasswordonlogin	Portal Change Password on Login (Candidate)
recruit_portalencryptedpassword	recruit_portalencryptedpassword	Portal Encrypted Password (Candidate)
mercury_portalencryptedpassword	mercury_PortalEncryptedPassword	Portal Encrypted Password (Client)
recruit_portalpassword	recruit_portalpassword	Portal Password (Candidate)
mercury_portalpassword	mercury_portalpassword	Portal Password (Client)
msdyn_portaltermsagreementdate	msdyn_portaltermsagreementdate	Portal Terms Agreement Date
recruit_portalusername	recruit_portalusername	Portal Username (Candidate)
mercury_portalusername	mercury_portalusername	Portal Username (Client)
preferredappointmentdaycode	PreferredAppointmentDayCode	Preferred Day
preferredequipmentid	PreferredEquipmentId	Preferred Facility/Equipment
mspp_userpreferredlcid	mspp_userpreferredlcid	Preferred Language
recruit_language	recruit_language	Preferred Language
adx_preferredlcid	adx_preferredlcid	Preferred LCID (Deprecated)
preferredcontactmethodcode	PreferredContactMethodCode	Preferred Method of Contact
preferredserviceid	PreferredServiceId	Preferred Service
preferredappointmenttimecode	PreferredAppointmentTimeCode	Preferred Time
preferredsystemuserid	PreferredSystemUserId	Preferred User
defaultpricelevelid	DefaultPriceLevelId	Price List
processid	ProcessId	Process
adx_profilealert	adx_profilealert	Profile Alert
adx_profilealertdate	adx_profilealertdate	Profile Alert Date
adx_profilealertinstructions	adx_profilealertinstructions	Profile Alert Instructions
adx_profileisanonymous	Adx_ProfileIsAnonymous	Profile Is Anonymous
adx_profilelastactivity	Adx_ProfileLastActivity	Profile Last Activity
adx_profilemodifiedon	adx_profilemodifiedon	Profile Modified On
adx_publicprofilecopy	adx_PublicProfileCopy	Public Profile Copy
overriddencreatedon	OverriddenCreatedOn	Record Created On
customertypecode	CustomerTypeCode	Relationship Type
recruit_religion	recruit_religion	Religion
accountrolecode	AccountRoleCode	Role
recruit_rolessought	recruit_rolessought	Roles sought
cdi_rowkey	cdi_rowkey	Row Key
salutation	Salutation	Salutation
cdi_score	cdi_score	Score
adx_identity_securitystamp	adx_identity_securitystamp	Security Stamp
msdyn_segmentid	msdyn_segmentid	Segment Id
recruit_selfbill	recruit_selfbill	Self bill?
donotsendmm	DoNotSendMM	Send Marketing Materials
mercury_sendtoexternalsystem	mercury_sendtoexternalsystem	Send to external system
recruit_sentiment	recruit_sentiment	Sentiment
recruit_sharepointtrigger	recruit_sharepointtrigger	SharePoint trigger
shippingmethodcode	ShippingMethodCode	Shipping Method
recruit_candidateshortliststatus	recruit_candidateshortliststatus	Shortlist Status
recruit_situation	recruit_situation	Situation
slaid	SLAId	SLA
cdi_social	cdi_social	Social
recruit_socialprofile	recruit_socialprofile	Social Profile
crimson_source	crimson_Source	Source
recruit_sourcespool	recruit_SourceSpool	Source Spool
recruit_startyear	recruit_startyear	Start year
recruit_startyeartext	recruit_startyeartext	Start year (text)
statecode	StateCode	Status
statuscode	StatusCode	Status Reason
subscriptionid	SubscriptionId	Subscription
mercury_subsector	mercury_subsector	Subsector
suffix	Suffix	Suffix
mercury_suppresslinkedcandidatesync	mercury_SuppressLinkedCandidateSync	Suppress Linked Candidate Sync
mercury_tagsdirty	mercury_tagsdirty	Tags dirty?
recruit_taxreference	recruit_taxreference	Tax Reference
teamsfollowed	TeamsFollowed	TeamsFollowed
recruit_workpref_temp	recruit_workpref_temp	Temporary
recruit_temporarycvid	recruit_TemporaryCVid	Temporary CV id
recruit_temporaryhrxmlid	recruit_temporaryhrxmlid	Temporary HRXML id
mercury_temporaryowner	mercury_TemporaryOwner	Temporary Owner
territorycode	TerritoryCode	Territory
recruit_textcvurl	recruit_textcvurl	Text CV URL
timespentbymeonemailandmeetings	TimeSpentByMeOnEmailAndMeetings	Time Spent by me
adx_timezone	Adx_TimeZone	Time Zone
timezoneruleversionnumber	TimeZoneRuleVersionNumber	Time Zone Rule Version Number
recruit_title	recruit_title	Title
recruit_toptags	recruit_toptags	Top Tags
mercury_totalcontracttempplacements	mercury_totalcontracttempplacements	Total Contract Temp Placements
mercury_totalcontracttempplacements_date	mercury_totalcontracttempplacements_Date	Total Contract Temp Placements (Last Updated On)
mercury_totalcontracttempplacements_state	mercury_totalcontracttempplacements_State	Total Contract Temp Placements (State)
mercury_totalinterviews	mercury_totalinterviews	Total Interviews
mercury_totalinterviews_date	mercury_totalinterviews_Date	Total Interviews (Last Updated On)
mercury_totalinterviews_state	mercury_totalinterviews_State	Total Interviews (State)
mercury_totaloffers	mercury_totaloffers	Total Offers
mercury_totaloffers_date	mercury_totaloffers_Date	Total Offers (Last Updated On)
mercury_totaloffers_state	mercury_totaloffers_State	Total Offers (State)
mercury_totalpermanentplacements	mercury_totalpermanentplacements	Total Permanent Placements
mercury_totalpermanentplacements_date	mercury_totalpermanentplacements_Date	Total Permanent Placements (Last Updated On)
mercury_totalpermanentplacements_state	mercury_totalpermanentplacements_State	Total Permanent Placements (State)
cdi_totalscore	cdi_totalscore	Total Score
mercury_totalvacancies	mercury_totalvacancies	Total Vacancies
mercury_totalvacancies_date	mercury_totalvacancies_Date	Total Vacancies (Last Updated On)
mercury_totalvacancies_state	mercury_totalvacancies_State	Total Vacancies (State)
cdi_twitter	cdi_twitter	Twitter
mercury_twitterprofileurl	mercury_twitterprofileURL	Twitter profile URL
adx_identity_twofactorenabled	adx_identity_twofactorenabled	Two Factor Enabled
mercury_userfield1	mercury_UserField1	User Field 1
recruit_userfield10	recruit_userfield10	User field 10
mercury_userfield2	mercury_UserField2	User Field 2
mercury_userfield3	mercury_UserField3	User Field 3
mercury_userfield4	mercury_UserField4	User Field 4
mercury_userfield5	mercury_UserField5	User Field 5
recruit_userfield6	recruit_userfield6	User field 6
recruit_userfield7	recruit_userfield7	User field 7
recruit_userfield8	recruit_userfield8	User field 8
recruit_userfield9	recruit_userfield9	User field 9
adx_identity_username	adx_identity_username	User Name
utcconversiontimezonecode	UTCConversionTimeZoneCode	UTC Conversion Time Zone Code
versionnumber	VersionNumber	Version Number
recruit_videocallid	recruit_videocallid	Video Call ID
recruit_videocalltype2	recruit_videocalltype2	Video Call Type
recruit_viewas	recruit_ViewAs	View As
mercury_visibleonclientportal	mercury_visibleonclientportal	Visible on Client Portal
recruit_visibleonportal	recruit_visibleonportal	Visible on Portal
cdi_visitorkey	cdi_visitorkey	Visitor Key
crimson_voyagercode	crimson_VoyagerCode	Voyager Code
websiteurl	WebSiteUrl	Website
recruit_willrelocate	recruit_willrelocate	Will relocate
address1_composite	Address1_Composite	Work address
address1_name	Address1_Name	Work address: Address Name
address1_addresstypecode	Address1_AddressTypeCode	Work address: Address Type
crimson_addressid	crimson_addressid	Work address: addressid
address1_city	Address1_City	Work address: City
recruit_address1_country	recruit_address1_country	Work address: Country
address1_country	Address1_Country	Work address: Country [text]
address1_county	Address1_County	Work address: County
address1_latitude	Address1_Latitude	Work address: Latitude
address1_longitude	Address1_Longitude	Work address: Longitude
address1_postalcode	Address1_PostalCode	Work address: Post code
recruit_address1_stateorprovince	recruit_address1_stateorprovince	Work address: State
address1_stateorprovince	Address1_StateOrProvince	Work address: State/Province [text]
address1_line1	Address1_Line1	Work address: Street 1
address1_line2	Address1_Line2	Work address: Street 2
address1_line3	Address1_Line3	Work address: Street 3
recruit_workarea	recruit_WorkArea	Work Area
emailaddress1	EMailAddress1	Work email
fax	Fax	Work fax
mobilephone	MobilePhone	Work mobile
telephone1	Telephone1	Work phone
recruit_contactautonumber	recruit_contactautonumber	X DNU Contact Autonumber Stub
recruit_correspondenceaddresscountrylookup	recruit_correspondenceaddresscountrylookup	X DNU Correspondence Address Country
recruit_correspondenceaddressstatelookup	recruit_correspondenceaddressstatelookup	X DNU Correspondence Address State LU
recruit_homeaddresscountrylookup	recruit_homeaddresscountrylookup	X DNU Country
recruit_currentclient	recruit_currentclient	X DNU Current Client
mercury_skypeid	mercury_skypeid	X DNU Skype ID
mercury_state	mercury_State	X DNU State
recruit_homeaddressstatelookup	recruit_homeaddressstatelookup	X DNU State LU
recruit_videocalltype	recruit_videocalltype	X DNU Video Call Type
yomifirstname	YomiFirstName	Yomi First Name
yomifullname	YomiFullName	Yomi Full Name
yomilastname	YomiLastName	Yomi Last Name
yomimiddlename	YomiMiddleName	Yomi Middle Name

Client schema

Entity	Client

Logical Name	Schema Name	Display Name
stageid	StageId	(Deprecated) Process Stage
traversedpath	TraversedPath	(Deprecated) Traversed Path
accountid	AccountId	Account
accountratingcode	AccountRatingCode	Account Rating
cdi_accountscore	cdi_accountscore	Account Score
mercury_accountinglegalentity	mercury_accountinglegalentity	Accounting legal entity
crimson_accountscontact	crimson_AccountsContact	Accounts Contact
mercury_additionalinformation1	mercury_additionalinformation1	Additional information 1
mercury_additionalinformation2	mercury_additionalinformation2	Additional information 2
mercury_additionalinformation3	mercury_additionalinformation3	Additional information 3
address1_composite	Address1_Composite	Address 1
mercury_address1statelookup	mercury_address1statelookup	Address 1 State LU
address1_addresstypecode	Address1_AddressTypeCode	Address 1: Address Type
address1_city	Address1_City	Address 1: City
mercury_address1country	mercury_address1country	Address 1: Country
address1_county	Address1_County	Address 1: County text
address1_fax	Address1_Fax	Address 1: Fax
address1_freighttermscode	Address1_FreightTermsCode	Address 1: Freight Terms
address1_addressid	Address1_AddressId	Address 1: ID
address1_name	Address1_Name	Address 1: Name
address1_postofficebox	Address1_PostOfficeBox	Address 1: Post Office Box
address1_primarycontactname	Address1_PrimaryContactName	Address 1: Primary Contact Name
address1_shippingmethodcode	Address1_ShippingMethodCode	Address 1: Shipping Method
address1_telephone2	Address1_Telephone2	Address 1: Telephone 2
address1_telephone3	Address1_Telephone3	Address 1: Telephone 3
address1_upszone	Address1_UPSZone	Address 1: UPS Zone
address1_utcoffset	Address1_UTCOffset	Address 1: UTC Offset
address1_postalcode	Address1_PostalCode	Address 1: ZIP/Postal Code
address2_composite	Address2_Composite	Address 2
mercury_address2statelookup	mercury_address2statelookup	Address 2 State LU
address2_addresstypecode	Address2_AddressTypeCode	Address 2: Address Type
address2_city	Address2_City	Address 2: City
mercury_address2country	mercury_address2country	Address 2: Country
address2_country	Address2_Country	Address 2: Country text
address2_county	Address2_County	Address 2: County
address2_fax	Address2_Fax	Address 2: Fax
address2_freighttermscode	Address2_FreightTermsCode	Address 2: Freight Terms
address2_addressid	Address2_AddressId	Address 2: ID
address2_latitude	Address2_Latitude	Address 2: Latitude
address2_longitude	Address2_Longitude	Address 2: Longitude
address2_name	Address2_Name	Address 2: Name
address2_postofficebox	Address2_PostOfficeBox	Address 2: Post Office Box
address2_primarycontactname	Address2_PrimaryContactName	Address 2: Primary Contact Name
address2_shippingmethodcode	Address2_ShippingMethodCode	Address 2: Shipping Method
address2_stateorprovince	Address2_StateOrProvince	Address 2: State/Province
address2_line1	Address2_Line1	Address 2: Street 1
address2_line2	Address2_Line2	Address 2: Street 2
address2_line3	Address2_Line3	Address 2: Street 3
address2_telephone1	Address2_Telephone1	Address 2: Telephone 1
address2_telephone2	Address2_Telephone2	Address 2: Telephone 2
address2_telephone3	Address2_Telephone3	Address 2: Telephone 3
address2_upszone	Address2_UPSZone	Address 2: UPS Zone
address2_utcoffset	Address2_UTCOffset	Address 2: UTC Offset
address2_postalcode	Address2_PostalCode	Address 2: ZIP/Postal Code
address1_telephone1	Address1_Telephone1	Address Phone
mercury_alltags	mercury_alltags	All tags
cdi_allowtextmessages	cdi_allowtextmessages	Allow Text Messages
revenue	Revenue	Annual Revenue
revenue_base	Revenue_Base	Annual Revenue (Base)
recruit_approvalstatus	recruit_approvalstatus	Approval Status
crimson_attributes	crimson_Attributes	Attributes
recruit_booleanuserfield1	recruit_booleanuserfield1	Boolean User Field 1
recruit_booleanuserfield2	recruit_booleanuserfield2	Boolean User Field 2
recruit_booleanuserfield3	recruit_booleanuserfield3	Boolean User Field 3
recruit_booleanuserfield4	recruit_booleanuserfield4	Boolean User Field 4
recruit_booleanuserfield5	recruit_booleanuserfield5	Boolean User Field 5
businesstypecode	BusinessTypeCode	Business Type
crimson_careerswebsite	crimson_CareersWebsite	Careers Website
accountcategorycode	AccountCategoryCode	Category
crimson_checkedby	crimson_CheckedBy	Checked By
accountclassificationcode	AccountClassificationCode	Classification
recruit_clientactivities	recruit_ClientActivities	Client Activities
mercury_category	mercury_Category	Client Category
recruit_clientid	recruit_clientid	Client ID
mercury_clientknownas	mercury_ClientKnownAs	Client Known As
name	Name	Client Name
recruit_clienton	recruit_clienton	Client On
mercury_clientproject	mercury_clientproject	Client project
mercury_clientspecificlabel01	mercury_clientspecificlabel01	Client Specific Label 01
mercury_clientspecificlabel02	mercury_clientspecificlabel02	Client Specific Label 02
mercury_clientspecificlabel03	mercury_clientspecificlabel03	Client Specific Label 03
mercury_clientspecificlabel04	mercury_clientspecificlabel04	Client Specific Label 04
mercury_clientspecificlabel05	mercury_clientspecificlabel05	Client Specific Label 05
mercury_clientspecificlabel06	mercury_clientspecificlabel06	Client Specific Label 06
mercury_clientspecificlabel07	mercury_clientspecificlabel07	Client Specific Label 07
mercury_clientspecificlabel08	mercury_clientspecificlabel08	Client Specific Label 08
crimson_clientstatus	crimson_ClientStatus	Client Status
customertypecode	CustomerTypeCode	Client Type
recruit_clientvalidated	recruit_ClientValidated	Client Validated
recruit_clientcontactsubgrids	recruit_clientcontactsubgrids	clientcontactsubgrids
mercury_comments	mercury_comments	Comments
accountnumber	AccountNumber	Company Registration Number
crimson_contractowningconsultant	crimson_contractowningconsultant	Contract Consultant
address1_country	Address1_Country	Country text
mercury_createtimesheets	mercury_createtimesheets	Create timesheets?
createdby	CreatedBy	Created By
createdonbehalfby	CreatedOnBehalfBy	Created By (Delegate)
createdbyexternalparty	CreatedByExternalParty	Created By (External Party)
createdon	CreatedOn	Created On
recruit_creditcheckcomments	recruit_creditcheckcomments	Credit Check Comments
crimson_creditcheckdate	crimson_CreditCheckDate	Credit Check Date
creditonhold	CreditOnHold	Credit Hold
creditlimit	CreditLimit	Credit Limit
creditlimit_base	CreditLimit_Base	Credit Limit (Base)
crimson_creditrating	crimson_CreditRating	Credit Rating
transactioncurrencyid	TransactionCurrencyId	Currency
recruit_currentteam	recruit_currentteam	Current Team
customersizecode	CustomerSizeCode	Customer Size
crimson_dateclientisdeemedprevious	crimson_dateclientisdeemedprevious	Date client is deemed previous
recruit_dateuserfield1	recruit_dateuserfield1	Date User Field 1
recruit_dateuserfield2	recruit_dateuserfield2	Date User Field 2
recruit_dateuserfield3	recruit_dateuserfield3	Date User Field 3
recruit_dateuserfield4	recruit_dateuserfield4	Date User Field 4
recruit_dateuserfield5	recruit_dateuserfield5	Date User Field 5
recruit_datetimeuserfield1	recruit_datetimeuserfield1	Datetime User Field 1
recruit_datetimeuserfield2	recruit_datetimeuserfield2	Datetime User Field 2
recruit_datetimeuserfield3	recruit_datetimeuserfield3	Datetime User Field 3
recruit_datetimeuserfield4	recruit_datetimeuserfield4	Datetime User Field 4
recruit_datetimeuserfield5	recruit_datetimeuserfield5	Datetime User Field 5
entityimage	EntityImage	Default Image
description	Description	Description
mercury_discipline	mercury_discipline	Discipline
donotbulkemail	DoNotBulkEMail	Do not allow Bulk Emails
donotbulkpostalmail	DoNotBulkPostalMail	Do not allow Bulk Mails
donotemail	DoNotEMail	Do not allow Emails
donotfax	DoNotFax	Do not allow Faxes
donotpostalmail	DoNotPostalMail	Do not allow Mails
donotphone	DoNotPhone	Do not allow Phone Calls
mercury_documentlocationwascreated	mercury_documentlocationwascreated	Document location was created
emailaddress1	EMailAddress1	Email
emailaddress2	EMailAddress2	Email Address 2
emailaddress3	EMailAddress3	Email Address 3
mercury_emaillimitdefinition	mercury_emaillimitdefinition	Email limit definition
mercury_emaillimittracker	mercury_emaillimittracker	Email limit tracker
entityimageid	EntityImageId	Entity Image Id
exchangerate	ExchangeRate	Exchange Rate
recruit_expectedemailstructure	recruit_expectedemailstructure	Expected Email Structure
mercury_externalsystemkey	mercury_externalsystemkey	External System Key
mercury_externalsystemkey2	mercury_externalsystemkey2	External System Key 2
fax	Fax	Fax
mercury_financeledgercode	mercury_FinanceLedgerCode	Finance Account Ref
followemail	FollowEmail	Follow Email Activity
ftpsiteurl	FtpSiteURL	FTP Site
msdyn_gdproptout	msdyn_gdproptout	GDPR Optout
importsequencenumber	ImportSequenceNumber	Import Sequence Number
mercury_importednote	mercury_ImportedNote	Imported Note
mercury_importedrecordid	mercury_ImportedRecordId	Imported Record Id
industrycode	IndustryCode	Industry
mercury_invoiceinstructions	mercury_invoiceinstructions	Invoice Instructions
recruit_isparent	recruit_isparent	Is Parent?
recruit_jobsandcandidatesselector	recruit_JobsandCandidatesSelector	Jobs and Candidates Selector
recruit_keyaccountuser	recruit_keyaccountuser	Key Account User
msdyn_accountkpiid	msdyn_accountkpiid	KPI
recruit_lastapproved	recruit_lastapproved	Last Approved
mercury_lastcalled	mercury_lastcalled	Last Called
mercury_lastcalledby	mercury_lastcalledby	Last Called By
mercury_lastcontacted	mercury_LastContacted	Last Contacted
mercury_lastcontactedby	mercury_LastContactedBy	Last Contacted By
lastusedincampaign	LastUsedInCampaign	Last Date Included in Campaign
mercury_lastemailed	mercury_lastemailed	Last Emailed
mercury_lastemailedby	mercury_lastemailedby	Last Emailed By
lastonholdtime	LastOnHoldTime	Last On Hold Time
recruit_lastpendingapproval	recruit_lastpendingapproval	Last Pending Approval
recruit_lastrejected	recruit_lastrejected	Last Rejected
slainvokedid	SLAInvokedId	Last SLA applied
address1_latitude	Address1_Latitude	Latitude
address1_longitude	Address1_Longitude	Longitude
telephone1	Telephone1	Main Phone
msa_managingpartnerid	msa_managingpartnerid	Managing Partner
marketcap	MarketCap	Market Capitalization
marketcap_base	MarketCap_Base	Market Capitalization (Base)
marketingonly	MarketingOnly	Marketing Only
masterid	MasterId	Master ID
merged	Merged	Merged
modifiedby	ModifiedBy	Modified By
modifiedonbehalfby	ModifiedOnBehalfBy	Modified By (Delegate)
modifiedbyexternalparty	ModifiedByExternalParty	Modified By (External Party)
modifiedon	ModifiedOn	Modified On
numberofemployees	NumberOfEmployees	Number of Employees
recruit_numericuserfield1	recruit_numericuserfield1	Numeric User Field 1
recruit_numericuserfield2	recruit_numericuserfield2	Numeric User Field 2
recruit_numericuserfield3	recruit_numericuserfield3	Numeric User Field 3
recruit_numericuserfield4	recruit_numericuserfield4	Numeric User Field 4
recruit_numericuserfield5	recruit_numericuserfield5	Numeric User Field 5
mercury_offlimitsdescription	mercury_OffLimitsDescription	Off Limits Description
mercury_offlimitsexpirydate	mercury_offlimitsexpirydate	Off Limits Expiry Date
mercury_donotheadhuntreason	mercury_donotheadhuntreason	Off Limits reason
onholdtime	OnHoldTime	On Hold Time (Minutes)
opendeals	OpenDeals	Open Deals
opendeals_date	OpenDeals_Date	Open Deals (Last Updated On)
opendeals_state	OpenDeals_State	Open Deals (State)
openrevenue	OpenRevenue	Open Revenue
openrevenue_base	OpenRevenue_Base	Open Revenue (Base)
openrevenue_date	OpenRevenue_Date	Open Revenue (Last Updated On)
openrevenue_state	OpenRevenue_State	Open Revenue (State)
mercury_initialteam	mercury_InitialTeam	Original Team
originatingleadid	OriginatingLeadId	Originating Lead
telephone2	Telephone2	Other Phone
ownerid	OwnerId	Owner
ownershipcode	OwnershipCode	Ownership
owningbusinessunit	OwningBusinessUnit	Owning Business Unit
owningteam	OwningTeam	Owning Team
owninguser	OwningUser	Owning User
parentaccountid	ParentAccountId	Parent Account
participatesinworkflow	ParticipatesInWorkflow	Participates in Workflow
paymenttermscode	PaymentTermsCode	Payment Term
mercury_paymentterms	mercury_paymentterms	Payment Terms
crimson_permanentowningconsultant	crimson_permanentowningconsultant	Permanent Consultant
preferredappointmentdaycode	PreferredAppointmentDayCode	Preferred Day
preferredequipmentid	PreferredEquipmentId	Preferred Facility/Equipment
preferredcontactmethodcode	PreferredContactMethodCode	Preferred Method of Contact
preferredserviceid	PreferredServiceId	Preferred Service
preferredappointmenttimecode	PreferredAppointmentTimeCode	Preferred Time
preferredsystemuserid	PreferredSystemUserId	Preferred User
defaultpricelevelid	DefaultPriceLevelId	Price List
primarycontactid	PrimaryContactId	Primary Contact
primarysatoriid	PrimarySatoriId	Primary Satori ID
primarytwitterid	PrimaryTwitterId	Primary Twitter ID
processid	ProcessId	Process
recruit_prospectclienton	recruit_prospectclienton	Prospect Client On
overriddencreatedon	OverriddenCreatedOn	Record Created On
mercury_registrationcountry	mercury_registrationcountry	Registration country
mercury_reportingbusinessunit	mercury_reportingbusinessunit	Reporting business unit
mercury_reportingregion	mercury_reportingregion	Reporting region
recruit_rulesofengagement	recruit_rulesofengagement	Rules of Engagement
msdyn_salesaccelerationinsightid	msdyn_salesaccelerationinsightid	Sales Acceleration Insights ID
msdyn_segmentid	msdyn_segmentid	Segment Id
mercury_selfbill	mercury_selfbill	Self bill?
donotsendmm	DoNotSendMM	Send Marketing Materials
mercury_sendtoexternalsystem	mercury_sendtoexternalsystem	Send to external system
crimson_servicetagconsultancy	crimson_ServiceTagConsultancy	Service Tag Consultancy
crimson_servicetagcontract	crimson_ServiceTagContract	Service Tag Contract
crimson_servicetagflair	crimson_ServiceTagFlair	Service Tag Flair
crimson_servicetagmanagedservices	crimson_ServiceTagManagedServices	Service Tag Managed Services
crimson_servicetagpermanent	crimson_ServiceTagPermanent	Service Tag Permanent
mercury_sharepointtrigger	mercury_sharepointtrigger	SharePoint trigger
sharesoutstanding	SharesOutstanding	Shares Outstanding
shippingmethodcode	ShippingMethodCode	Shipping Method
sic	SIC	SIC Code
slaid	SLAId	SLA
recruit_standardclassification	recruit_standardclassification	Standard Classification
address1_stateorprovince	Address1_StateOrProvince	State/Province
statecode	StateCode	Status
statuscode	StatusCode	Status Reason
stockexchange	StockExchange	Stock Exchange
address1_line1	Address1_Line1	Street 1
address1_line2	Address1_Line2	Street 2
address1_line3	Address1_Line3	Street 3
mercury_subsector	mercury_subsector	Subsector
recruit_suspectclienton	recruit_suspectclienton	Suspect Client On
mercury_tagsdirty	mercury_tagsdirty	Tags dirty?
mercury_taxcode	mercury_TaxCode	Tax Code
teamsfollowed	TeamsFollowed	TeamsFollowed
telephone3	Telephone3	Telephone 3
crimson_temporaryowningconsultant	crimson_temporaryowningconsultant	Temporary Consultant
territoryid	TerritoryId	Territory
territorycode	TerritoryCode	Territory Code
tickersymbol	TickerSymbol	Ticker Symbol
timespentbymeonemailandmeetings	TimeSpentByMeOnEmailAndMeetings	Time Spent by me
timezoneruleversionnumber	TimeZoneRuleVersionNumber	Time Zone Rule Version Number
mercury_timesheetsignoff	mercury_timesheetsignoff	Timesheet signoff
mercury_tradingcountry	mercury_tradingcountry	Trading country
mercury_userfield1	mercury_UserField1	User Field 1
mercury_userfield2	mercury_UserField2	User Field 2
mercury_userfield3	mercury_UserField3	User Field 3
mercury_userfield4	mercury_UserField4	User Field 4
mercury_userfield5	mercury_UserField5	User Field 5
utcconversiontimezonecode	UTCConversionTimeZoneCode	UTC Conversion Time Zone Code
crimson_vatregistrationno	crimson_VatRegistrationNo	VAT Registration
versionnumber	VersionNumber	Version Number
crimson_voyagercode	crimson_VoyagerCode	Voyager Code
websiteurl	WebSiteURL	Website
recruit_workitemcounter	recruit_workitemcounter	Work Item Counter
recruit_workitemcounter2	recruit_workitemcounter2	Work Item Counter 2

Vacancy schema

Entity	Vacancy

Logical Name	Schema Name	Display Name
mercury_totalplaced	mercury_totalplaced	# Accepted
mercury_totalplaced_date	mercury_totalplaced_Date	# Accepted (Last Updated On)
mercury_totalplaced_state	mercury_totalplaced_State	# Accepted (State)
mercury_senttoclient	mercury_senttoclient	# Candidate Calls
mercury_senttoclient_date	mercury_senttoclient_Date	# Candidate Calls (Last Updated On)
mercury_senttoclient_state	mercury_senttoclient_State	# Candidate Calls (State)
mercury_totalinterviewed	mercury_totalinterviewed	# Interviewed
mercury_totalinterviewed_date	mercury_totalinterviewed_Date	# Interviewed (Last Updated On)
mercury_totalinterviewed_state	mercury_totalinterviewed_State	# Interviewed (State)
mercury_totalrejectedafterinterview	mercury_totalrejectedafterinterview	# Not Yet Accepted
mercury_totalrejectedwithoutinterview	mercury_totalrejectedwithoutinterview	# Not Yet Interviewed
mercury_notyetoffered	mercury_notyetoffered	# Not Yet Offered
mercury_totalrejectedunsubmitted	mercury_totalrejectedunsubmitted	# Not Yet Submitted
mercury_numberofpositionsfilled	mercury_numberofpositionsfilled	# Number of positions filled
mercury_numberofpositionsfilled_date	mercury_numberofpositionsfilled_Date	# Number of positions filled (Last Updated On)
mercury_numberofpositionsfilled_state	mercury_numberofpositionsfilled_State	# Number of positions filled (State)
mercury_totaloffered	mercury_totaloffered	# Offered
mercury_totaloffered_date	mercury_totaloffered_Date	# Offered (Last Updated On)
mercury_totaloffered_state	mercury_totaloffered_State	# Offered (State)
mercury_totalpotentialcandidates	mercury_totalpotentialcandidates	# Potential Candidates
mercury_totalpotentialcandidates_date	mercury_totalpotentialcandidates_Date	# Potential Candidates (Last Updated On)
mercury_totalpotentialcandidates_state	mercury_totalpotentialcandidates_State	# Potential Candidates (State)
mercury_totalrejectedbeforeshortlist	mercury_totalrejectedbeforeshortlist	# Rejected Before Shortlist
mercury_totalshortlisted	mercury_totalshortlisted	# Selected
mercury_totalshortlisted_date	mercury_totalshortlisted_Date	# Selected (Last Updated On)
mercury_totalshortlisted_state	mercury_totalshortlisted_State	# Selected (State)
mercury_totalsubmitted	mercury_totalsubmitted	# Submitted
mercury_totalsubmitted_date	mercury_totalsubmitted_Date	# Submitted (Last Updated On)
mercury_totalsubmitted_state	mercury_totalsubmitted_State	# Submitted (State)
mercury_percentageaccepted	mercury_percentageaccepted	% Accepted
mercury_percentageinterviewed	mercury_percentageinterviewed	% Interviewed
mercury_percentageoffered	mercury_percentageoffered	% Offered
mercury_percentagesubmitted	mercury_percentagesubmitted	% Submitted
crimson_addresscity	crimson_AddressCity	Address City
crimson_addressid	crimson_AddressID	Address ID
crimson_addresslookup	crimson_AddressLookup	Address Lookup
crimson_addressname	crimson_AddressName	Address Name
crimson_addresspostcode	crimson_AddressPostcode	Address Postcode
mercury_addressstreet1	mercury_addressstreet1	Address Street 1
recruit_addressstreet2	recruit_addressstreet2	addressstreet2
recruit_adverttext2	recruit_adverttext2	Advert Text 2
recruit_adverttext3	recruit_adverttext3	Advert Text 3
recruit_advertiseonwebsite	recruit_advertiseonwebsite	Advertise on Website
mercury_aggregatefees_base	mercury_aggregatefees_Base	Aggregate fees (Base)
mercury_agreementid	mercury_AgreementId	Agreement
recruit_alltags	recruit_alltags	All tags
recruit_approvalstatus	recruit_approvalstatus	Approval Status
recruit_assignedapprover	recruit_assignedapprover	Assigned Approver
mercury_benefitsnotes	mercury_benefitsnotes	Benefits Notes
crimson_bonus	crimson_Bonus	Bonus
crimson_bonus_base	crimson_bonus_Base	Bonus (Base)
crimson_bonusshares	crimson_BonusShares	Bonus/Shares
recruit_booleanuserfield1	recruit_booleanuserfield1	Boolean User Field 1
recruit_booleanuserfield2	recruit_booleanuserfield2	Boolean User Field 2
recruit_booleanuserfield3	recruit_booleanuserfield3	Boolean User Field 3
recruit_booleanuserfield4	recruit_booleanuserfield4	Boolean User Field 4
recruit_booleanuserfield5	recruit_booleanuserfield5	Boolean User Field 5
mercury_charge_mc	mercury_charge_mc	Charge
mercury_charge_mc_currency	mercury_charge_mc_currency	Charge Currency
mercury_charge_mc_normalised	mercury_charge_mc_normalised	Charge Normalised
mercury_charge_mc_normalised_base	mercury_charge_mc_normalised_Base	Charge Normalised (Base)
crimson_clientid	crimson_clientid	Client
crimson_clientemail	crimson_ClientEmail	Client Email
crimson_clientmobile	crimson_ClientMobile	Client Mobile
crimson_clientphone	crimson_ClientPhone	Client Phone
mercury_clientref	mercury_ClientRef	Client Ref
crimson_clientsitelookup	crimson_ClientSiteLookup	Client Site Lookup
recruit_commissionvac0	recruit_commissionvac0	Commission 0
recruit_commission0gp	recruit_Commission0GP	Commission 0 GP
recruit_commission0gp_base	recruit_commission0gp_Base	Commission 0 GP (Base)
recruit_commission1	recruit_commission1	Commission 1
recruit_commission1gp	recruit_commission1GP	Commission 1 GP
recruit_commission1gp_base	recruit_commission1gp_Base	Commission 1 GP (Base)
recruit_commission2	recruit_commission2	Commission 2
recruit_commission2gp	recruit_commission2GP	Commission 2 GP
recruit_commission2gp_base	recruit_commission2gp_Base	Commission 2 GP (Base)
recruit_commission3	recruit_commission3	Commission 3
recruit_commission3gp	recruit_commission3GP	Commission 3 GP
recruit_commission3gp_base	recruit_commission3gp_Base	Commission 3 GP (Base)
recruit_commissionconsultant0	recruit_commissionconsultant0	Commission Consultant 0
recruit_commissionconsultant1	recruit_commissionconsultant1	Commission Consultant 1
recruit_commissionconsultant2	recruit_commissionconsultant2	Commission Consultant 2
recruit_commissionconsultant3	recruit_commissionconsultant3	Commission Consultant 3
recruit_commissionflatrate0vac	recruit_commissionflatrate0vac	Commission Flat Rate 0
recruit_commissionflatrate0vac_base	recruit_commissionflatrate0vac_Base	Commission Flat Rate 0 (Base)
recruit_commissionflatrate1vac	recruit_commissionflatrate1vac	Commission Flat Rate 1
recruit_commissionflatrate1vac_base	recruit_commissionflatrate1vac_Base	Commission Flat Rate 1 (Base)
recruit_commissionflatrate2vac	recruit_commissionflatrate2vac	Commission Flat Rate 2
recruit_commissionflatrate2vac_base	recruit_commissionflatrate2vac_Base	Commission Flat Rate 2 (Base)
recruit_commissionflatrate3vac	recruit_commissionflatrate3vac	Commission Flat Rate 3
recruit_commissionflatrate3vac_base	recruit_commissionflatrate3vac_Base	Commission Flat Rate 3 (Base)
recruit_commissionrate0	recruit_commissionrate0	Commission Rate 0
recruit_commissionrate1	recruit_commissionrate1	Commission Rate 1
recruit_commissionrate2	recruit_commissionrate2	Commission Rate 2
recruit_commissionrate3	recruit_commissionrate3	Commission Rate 3
recruit_commissiontotal	recruit_commissiontotal	Commission Total
new_companycar	new_CompanyCar	Company Car
ownerid	OwnerId	Consultant
crimson_contactbonusfrequency	crimson_ContactBonusFrequency	Contact Bonus Frequency
crimson_contractduration	crimson_ContractDuration	Contract Duration (Weeks)
crimson_contractrate	crimson_ContractRate	Contract Rate
crimson_contractrate_base	crimson_contractrate_Base	Contract Rate (Base)
crimson_contracttimesheetinterval	crimson_ContractTimesheetInterval	Contract Timesheet Interval
mercury_info	mercury_info	Converted From
recruit_country	recruit_country	country
createdby	CreatedBy	Created By
createdonbehalfby	CreatedOnBehalfBy	Created By (Delegate)
createdon	CreatedOn	Created On
transactioncurrencyid	TransactionCurrencyId	Currency
mercury_currentdatetime	mercury_CurrentDateTime	Current Date Time
mercury_cvsrequired	mercury_CVsRequired	CVs Required
recruit_dateuserfield1	recruit_dateuserfield1	Date User Field 1
recruit_dateuserfield2	recruit_dateuserfield2	Date User Field 2
recruit_dateuserfield3	recruit_dateuserfield3	Date User Field 3
recruit_dateuserfield4	recruit_dateuserfield4	Date User Field 4
recruit_dateuserfield5	recruit_dateuserfield5	Date User Field 5
recruit_datetimeuserfield1	recruit_datetimeuserfield1	Datetime User Field 1
recruit_datetimeuserfield2	recruit_datetimeuserfield2	Datetime User Field 2
recruit_datetimeuserfield3	recruit_datetimeuserfield3	Datetime User Field 3
recruit_datetimeuserfield4	recruit_datetimeuserfield4	Datetime User Field 4
recruit_datetimeuserfield5	recruit_datetimeuserfield5	Datetime User Field 5
crimson_daysperweek	crimson_daysperweek	Days Per Week
crimson_deliveryownerid	crimson_DeliveryOwnerId	Delivery Owner
recruit_desirabletagcontrol0	recruit_desirabletagcontrol0	Desirable Tag Control 0
recruit_desirabletagcontrol1	recruit_desirabletagcontrol1	Desirable Tag Control 1
recruit_desirabletagcontrol2	recruit_desirabletagcontrol2	Desirable Tag Control 2
recruit_desirabletagcontrol3	recruit_desirabletagcontrol3	Desirable Tag Control 3
recruit_desirabletagcontrol4	recruit_desirabletagcontrol4	Desirable Tag Control 4
recruit_desirabletagcontrolids	recruit_desirabletagcontrolids	Desirable Tag Control Ids
mercury_discipline	mercury_discipline	Discipline
mercury_emaildescription	mercury_emaildescription	Email description
mercury_endclient	mercury_endclient	End Client
mercury_endcontact	mercury_endcontact	End Contact
exchangerate	ExchangeRate	Exchange Rate
mercury_exclusive	mercury_Exclusive	Exclusive?
recruit_exclusivitylength	recruit_exclusivitylength	Exclusivity Days
recruit_exclusivityreviewdate	recruit_exclusivityreviewdate	Exclusivity Review Date
mercury_permanentfeepercent	mercury_PermanentFeePercent	Fee %
recruit_permanentfeepercentbasedon	recruit_permanentfeepercentbasedon	Fee % Based On
mercury_feebasedon2	mercury_feebasedon2	Fee Based On
mercury_feestructure	mercury_feestructure	Fee structure
crimson_temporaryfixedfee	crimson_temporaryfixedfee	Fixed Fee
crimson_frequency	crimson_frequency	Frequency
mercury_ftcfee	mercury_FTCFee	FTC Fee
mercury_ftcfee_base	mercury_ftcfee_Base	FTC Fee (Base)
recruit_ftctenureinweeks	recruit_FTCTenureinweeks	FTC Tenure in weeks
mercury_furtheststatus	mercury_furtheststatus	Furthest status
mercury_grossprofit_mc	mercury_grossprofit_mc	Gross Profit
mercury_grossprofit_mc_currency	mercury_grossprofit_mc_currency	Gross Profit Currency
mercury_grossprofit_mc_normalised	mercury_grossprofit_mc_normalised	Gross Profit Normalised
mercury_grossprofit_mc_normalised_base	mercury_grossprofit_mc_normalised_Base	Gross Profit Normalised (Base)
crimson_clientcontact	crimson_ClientContact	Hiring Manager
crimson_holidays	crimson_Holidays	Holiday Days
crimson_hoursperweek	crimson_hoursperweek	Hours
importsequencenumber	ImportSequenceNumber	Import Sequence Number
mercury_importednote	mercury_ImportedNote	Imported Note
mercury_importedrecordid	mercury_ImportedRecordId	Imported Record Id
mercury_inheritancestatus	mercury_InheritanceStatus	Inheritance Status
mercury_initialteam	mercury_InitialTeam	Initial Team
crimson_jobsummaryemail	crimson_JobSummaryEmail	Internal description
recruit_interviewquestions	recruit_interviewquestions	Interview Questions
recruit_isftc	recruit_IsFTC	Is FTC?
crimson_jobduration	crimson_JobDuration	Job Duration (Weeks)
recruit_jobpostingoperationtype	recruit_jobpostingoperationtype	Job Posting Operation Type
crimson_jobsummary	crimson_JobSummary	Job Summary (Job Board)
crimson_jobtitle	crimson_JobTitle	Job Title
recruit_keyaccountuser	recruit_keyaccountuser	Key Account User
recruit_lastapproved	recruit_lastapproved	Last Approved
recruit_lastapprovedbyclientcontact	recruit_lastapprovedbyclientcontact	Last Approved By Client Contact
recruit_lastapprovedon	recruit_lastapprovedon	Last Approved On
recruit_lastpendingapproval	recruit_lastpendingapproval	Last Pending Approval
recruit_lastrejected	recruit_lastrejected	Last Rejected
mercury_sourceuser	mercury_sourceuser	Lead From
recruit_linkedindataissue	recruit_linkedindataissue	LinkedIn Data Issue
recruit_linkedindefaultadvertdescription	recruit_linkedindefaultadvertdescription	LinkedIn Default Advert Description
recruit_linkedinreference	recruit_linkedinreference	LinkedIn Reference
recruit_linkedintriggersync	recruit_linkedintriggersync	LinkedIn Trigger Sync
mercury_location	mercury_location	Location
recruit_mandatorytagcontrol0	recruit_mandatorytagcontrol0	Mandatory Tag Control 0
recruit_mandatorytagcontrol1	recruit_mandatorytagcontrol1	Mandatory Tag Control 1
recruit_mandatorytagcontrol2	recruit_mandatorytagcontrol2	Mandatory Tag Control 2
recruit_mandatorytagcontrol3	recruit_mandatorytagcontrol3	Mandatory Tag Control 3
recruit_mandatorytagcontrol4	recruit_mandatorytagcontrol4	Mandatory Tag Control 4
recruit_mandatorytagcontrolids	recruit_mandatorytagcontrolids	Mandatory Tag Control Ids
mercury_marginpercent	mercury_MarginPercent	Margin %
mercury_marginvalue_mc	mercury_marginvalue_mc	Margin Value
mercury_marginvalue_mc_currency	mercury_marginvalue_mc_currency	Margin Value Currency
mercury_marginvalue_mc_normalised	mercury_marginvalue_mc_normalised	Margin Value Normalised
mercury_marginvalue_mc_normalised_base	mercury_marginvalue_mc_normalised_Base	Margin Value Normalised (Base)
mercury_markuppercent	mercury_MarkupPercent	Markup %
new_medicalinsurance	new_MedicalInsurance	Medical Insurance
modifiedby	ModifiedBy	Modified By
modifiedonbehalfby	ModifiedOnBehalfBy	Modified By (Delegate)
modifiedon	ModifiedOn	Modified On
mercury_mostrecentcascade	mercury_mostrecentcascade	Most recent cascade
mercury_multicurrencyxml	mercury_MultiCurrencyXml	Multi Currency Xml
crimson_name	crimson_name	Name
mercury_numberofdays	mercury_NumberofDays	Number of Days
mercury_numberofhours	mercury_NumberofHours	Number of Hours
mercury_numberofmonths	mercury_NumberofMonths	Number of Months
new_numberofpositions	new_Numberofpositions	Number of positions
mercury_numberofpositionsremaining	mercury_numberofpositionsremaining	Number of positions remaining
mercury_numberofweeks	mercury_NumberofWeeks	Number of Weeks
recruit_numericuserfield1	recruit_numericuserfield1	Numeric User Field 1
recruit_numericuserfield2	recruit_numericuserfield2	Numeric User Field 2
recruit_numericuserfield3	recruit_numericuserfield3	Numeric User Field 3
recruit_numericuserfield4	recruit_numericuserfield4	Numeric User Field 4
recruit_numericuserfield5	recruit_numericuserfield5	Numeric User Field 5
owningbusinessunit	OwningBusinessUnit	Owning Business Unit
owningteam	OwningTeam	Owning Team
owninguser	OwningUser	Owning User
mercury_pay_mc	mercury_pay_mc	Pay
mercury_pay_mc_currency	mercury_pay_mc_currency	Pay Currency
mercury_pay_mc_normalised	mercury_pay_mc_normalised	Pay Normalised
mercury_pay_mc_normalised_base	mercury_pay_mc_normalised_Base	Pay Normalised (Base)
new_pensionscheme	new_PensionScheme	Pension Scheme
crimson_contractrateper	crimson_ContractRatePer	Per
mercury_permanentfee_mc	mercury_permanentfee_mc	Permanent Fee
mercury_permanentfee_mc_currency	mercury_permanentfee_mc_currency	Permanent Fee Currency
mercury_permanentfee_mc_normalised	mercury_permanentfee_mc_normalised	Permanent Fee Normalised
mercury_permanentfee_mc_normalised_base	mercury_permanentfee_mc_normalised_Base	Permanent Fee Normalised (Base)
mercury_permanentpackagevalue_mc	mercury_permanentpackagevalue_mc	Permanent Package Value
mercury_permanentpackagevalue_mc_currency	mercury_permanentpackagevalue_mc_currency	Permanent Package Value Currency
mercury_permanentpackagevalue_mc_normalised	mercury_permanentpackagevalue_mc_normalised	Permanent Package Value Normalised
mercury_permanentpackagevalue_mc_normalised_base	mercury_permanentpackagevalue_mc_normalised_Base	Permanent Package Value Normalised (Base)
mercury_permanentsalary_mc	mercury_permanentsalary_mc	Permanent Salary
mercury_permanentsalary_mc_currency	mercury_permanentsalary_mc_currency	Permanent Salary Currency
mercury_permanentsalary_mc_normalised	mercury_permanentsalary_mc_normalised	Permanent Salary Normalised
mercury_permanentsalary_mc_normalised_base	mercury_permanentsalary_mc_normalised_Base	Permanent Salary Normalised (Base)
mercury_permanentsalaryto	mercury_permanentsalaryto	Permanent Salary To
mercury_priority	mercury_priority	Priority
crimson_probabilityestimate	crimson_ProbabilityEstimate	Probability
crimson_probability	crimson_Probability	Probability (%)
processid	processid	Process Id
crimson_profit	crimson_Profit	Profit
crimson_profit_base	crimson_profit_Base	Profit (Base)
recruit_project	recruit_project	Project
recruit_publiconlinkedin	recruit_publiconlinkedin	Public on LinkedIn?
recruit_publishedpostingurl	recruit_publishedpostingurl	Published Posting URL
recruit_qualificationqa	recruit_QualificationQA	Qualification Q&A
overriddencreatedon	OverriddenCreatedOn	Record Created On
mercury_recruitmenttype	mercury_recruitmenttype	Recruitment type
mercury_regnostatus	mercury_RegNostatus	Reg. No. status
recruit_rejectionreason	recruit_rejectionreason	Rejection Reason
recruit_retained	recruit_retained	Retained?
crimson_reviewdate	crimson_ReviewDate	Review Date
mercury_salesvalue_mc	mercury_salesvalue_mc	Sales Value
mercury_salesvalue_mc_currency	mercury_salesvalue_mc_currency	Sales Value Currency
mercury_salesvalue_mc_normalised	mercury_salesvalue_mc_normalised	Sales Value Normalised
mercury_salesvalue_mc_normalised_base	mercury_salesvalue_mc_normalised_Base	Sales Value Normalised (Base)
mercury_sourcereferenceid	mercury_sourcereferenceId	Source Reference
crimson_speculative	crimson_Speculative	Speculative
stageid	stageid	Stage Id
mercury_aggregatefees	mercury_aggregatefees	Staged fees
mercury_aggregatefees_date	mercury_aggregatefees_Date	Staged fees (Last Updated On)
mercury_aggregatefees_state	mercury_aggregatefees_State	Staged fees (State)
recruit_standardclassification	recruit_standardclassification	Standard Classification
recruit_standardratetype	recruit_standardratetype	Standard Rate Type
crimson_startdate	crimson_Startdate	Start date
recruit_addressstate	recruit_addressstate	State
statecode	statecode	Status
statuscode	statuscode	Status Reason
mercury_subsector	mercury_subsector	Subsector
recruit_summary	recruit_summary	Summary
recruit_tagsdirty	recruit_tagsdirty	Tags dirty?
recruit_taxableas	recruit_taxableas	Taxable As
mercury_tempcandidatepay_mc	mercury_tempcandidatepay_mc	Temp Candidate Pay
mercury_tempcandidatepay_mc_currency	mercury_tempcandidatepay_mc_currency	Temp Candidate Pay Currency
mercury_tempcandidatepay_mc_normalised	mercury_tempcandidatepay_mc_normalised	Temp Candidate Pay Normalised
mercury_tempcandidatepay_mc_normalised_base	mercury_tempcandidatepay_mc_normalised_Base	Temp Candidate Pay Normalised (Base)
mercury_tempdeductionpercent	mercury_tempdeductionpercent	Temp Deduction %
mercury_tempdeductions_mc	mercury_tempdeductions_mc	Temp Deductions
mercury_tempdeductions_mc_currency	mercury_tempdeductions_mc_currency	Temp Deductions Currency
mercury_tempdeductions_mc_normalised	mercury_tempdeductions_mc_normalised	Temp Deductions Normalised
mercury_tempdeductions_mc_normalised_base	mercury_tempdeductions_mc_normalised_Base	Temp Deductions Normalised (Base)
timezoneruleversionnumber	TimeZoneRuleVersionNumber	Time Zone Rule Version Number
mercury_to	mercury_To	To
mercury_to_base	mercury_to_Base	To (Base)
mercury_totalestimatedpay_mc	mercury_totalestimatedpay_mc	Total Estimated Pay
mercury_totalestimatedpay_mc_currency	mercury_totalestimatedpay_mc_currency	Total Estimated Pay Currency
mercury_totalestimatedpay_mc_normalised	mercury_totalestimatedpay_mc_normalised	Total Estimated Pay Normalised
mercury_totalestimatedpay_mc_normalised_base	mercury_totalestimatedpay_mc_normalised_Base	Total Estimated Pay Normalised (Base)
new_training	new_Training	Training
traversedpath	traversedpath	Traversed Path
crimson_typeofposition	crimson_TypeofPosition	Type of Position
mercury_userfield1	mercury_UserField1	User Field 1
mercury_userfield2	mercury_UserField2	User Field 2
mercury_userfield3	mercury_UserField3	User Field 3
mercury_userfield4	mercury_UserField4	User Field 4
mercury_userfield5	mercury_UserField5	User Field 5
utcconversiontimezonecode	UTCConversionTimeZoneCode	UTC Conversion Time Zone Code
crimson_vacancyid	crimson_vacancyId	Vacancy
crimson_vacancyautonumber	crimson_vacancyautonumber	Vacancy Autonumber Stub
recruit_vacancygrids	recruit_VacancyGrids	Vacancy Grids
crimson_vacancyrefno	crimson_vacancyrefno	Vacancy Ref
crimson_vacancyrevenue	crimson_Vacancyrevenue	Vacancy revenue
crimson_vacancyrevenue_base	crimson_vacancyrevenue_Base	Vacancy revenue (Base)
recruit_vacancysource	recruit_vacancysource	Vacancy Source
mercury_vacancytype	mercury_vacancytype	Vacancy type
versionnumber	VersionNumber	Version Number
mercury_visibleonportal	mercury_visibleonportal	Visible on portal
crimson_location	crimson_Location	x DNU Location
mercury_lostreason	mercury_lostreason	X DNU Lost reason
mercury_retained	mercury_retained	X DNU Retained?

Placement schema

Entity	Placement

Logical Name	Schema Name	Display Name
mercury_complianceevidenceoutstanding	mercury_ComplianceEvidenceOutstanding	# Compliance Evidence Outstanding
mercury_complianceevidenceoutstanding_date	mercury_ComplianceEvidenceOutstanding_Date	# Compliance Evidence Outstanding (Last Updated On)
mercury_complianceevidenceoutstanding_state	mercury_ComplianceEvidenceOutstanding_State	# Compliance Evidence Outstanding (State)
mercury_complianceevidenceassociated	mercury_complianceevidenceassociated	# of Compliance Evidence Associated
mercury_complianceevidenceassociated_date	mercury_complianceevidenceassociated_Date	# of Compliance Evidence Associated (Last Updated On)
mercury_complianceevidenceassociated_state	mercury_complianceevidenceassociated_State	# of Compliance Evidence Associated (State)
mercury_ofonboardingitemsassociated	mercury_ofonboardingitemsassociated	# of Onboarding Items Associated
mercury_ofonboardingitemsassociated_date	mercury_ofonboardingitemsassociated_Date	# of Onboarding Items Associated (Last Updated On)
mercury_ofonboardingitemsassociated_state	mercury_ofonboardingitemsassociated_State	# of Onboarding Items Associated (State)
mercury_complianton	mercury_complianton	100% Compliant On
mercury_onboardedon	mercury_onboardedon	100% Onboarded On
mercury_accountinglegalentity	mercury_accountinglegalentity	Accounting Legal Entity
crimson_actualenddate	crimson_ActualEndDate	Actual End Date
recruit_addpipl	recruit_addpipl	Add PI/PL?
recruit_addtransactions	recruit_AddTransactions	Add Transactions
recruit_addwcni	recruit_addwcni	Add WC/NI?
recruit_agencydeductions	recruit_agencydeductions	Agency deductions
mercury_agreementid	mercury_AgreementId	Agreement
crimson_analysiscode	crimson_AnalysisCode	Analysis Code
mercury_approvaliscomplete	mercury_approvaliscomplete	Approval is complete?
mercury_approvalstatus	mercury_approvalstatus	Approval status
mercury_approver1	mercury_approver1	Approver 1
mercury_approver2	mercury_approver2	Approver 2
mercury_approver3	mercury_approver3	Approver 3
mercury_assignmentowner	mercury_assignmentowner	Assignment Owner
crimson_autonumber	crimson_autonumber	Auto Number
mercury_availableonportal	mercury_availableonportal	Available on portal
recruit_booleanuserfield1	recruit_booleanuserfield1	Boolean User Field 1
recruit_booleanuserfield2	recruit_booleanuserfield2	Boolean User Field 2
recruit_booleanuserfield3	recruit_booleanuserfield3	Boolean User Field 3
recruit_booleanuserfield4	recruit_booleanuserfield4	Boolean User Field 4
recruit_booleanuserfield5	recruit_booleanuserfield5	Boolean User Field 5
recruit_candidatecontact	recruit_candidatecontact	Candidate (contact)
mercury_candidateacceptance	mercury_candidateacceptance	Candidate acceptance
mercury_candidateacceptancedate	mercury_candidateacceptancedate	Candidate acceptance date
crimson_candidateaddress1	crimson_CandidateAddress1	Candidate Address 1
crimson_candidateaddress2	crimson_CandidateAddress2	Candidate Address 2
crimson_candidateaddress3	crimson_CandidateAddress3	Candidate Address 3
crimson_candidateaddresscountry	crimson_CandidateAddressCountry	Candidate Address Country
mercury_candidateaddresscountrylookup	mercury_candidateaddresscountrylookup	Candidate Address Country Lookup
crimson_candidateaddresscounty	crimson_CandidateAddressCounty	Candidate Address County
recruit_candidateaddressid	recruit_candidateaddressid	Candidate address ID
crimson_candidateaddressname	crimson_CandidateAddressName	Candidate Address Name
crimson_candidateaddresspostcode	crimson_CandidateAddressPostcode	Candidate Address Postcode
mercury_candidateaddressstatelookup	mercury_candidateaddressstatelookup	Candidate Address State LU
crimson_candidateaddresstowncity	crimson_CandidateAddressTownCity	Candidate Address Town/City
crimson_candidateaddresstypecode	crimson_CandidateAddressTypeCode	Candidate Address Type Code
crimson_candidatecompany	crimson_CandidateCompany	Candidate Company
crimson_candidatecorrespondenceaddress1	crimson_CandidateCorrespondenceAddress1	Candidate Correspondence Address 1
crimson_candidatecorrespondenceaddress2	crimson_CandidateCorrespondenceAddress2	Candidate Correspondence Address 2
crimson_candidatecorrespondenceaddress3	crimson_CandidateCorrespondenceAddress3	Candidate Correspondence Address 3
crimson_candidatecorrespondenceaddresscitytown	crimson_CandidateCorrespondenceAddressCityTown	Candidate Correspondence Address City/Town
crimson_candidatecorrespondenceaddresscountry	crimson_CandidateCorrespondenceAddressCountry	Candidate Correspondence Address Country
mercury_candidatecorrespondenceaddresscountrylook	mercury_candidatecorrespondenceaddresscountrylook	Candidate Correspondence Address Country Lookup
crimson_candidatecorrespondenceaddresscounty	crimson_CandidateCorrespondenceAddressCounty	Candidate Correspondence Address County
crimson_candidatecorrespondenceaddressname	crimson_CandidateCorrespondenceAddressName	Candidate Correspondence Address Name
crimson_candidatecorrespondenceaddresspostcode	crimson_CandidateCorrespondenceAddressPostCode	Candidate Correspondence Address PostCode
mercury_correspondenceaddressstatelookup	mercury_correspondenceaddressstatelookup	Candidate Correspondence Address State LU
crimson_candidatecorrespondenceaddresstypecode	crimson_CandidateCorrespondenceAddressTypeCode	Candidate Correspondence Address Type Code
crimson_candidatepaperworkissued	crimson_CandidatePaperworkIssued	Candidate Paperwork Issued
crimson_candidatepaperworkreceived	crimson_CandidatePaperworkReceived	Candidate Paperwork Received
crimson_candidatepaperworkto	crimson_Candidatepaperworkto	Candidate Paperwork To
mercury_candidaterejectiondate	mercury_candidaterejectiondate	Candidate rejection date
crimson_candidatetemplatepack	crimson_CandidateTemplatePack	Candidate Template Pack
crimson_candidatecontract	crimson_CandidateContract	CandidateContract
crimson_candidateletter	crimson_CandidateLetter	CandidateLetter
crimson_candidateschedule	crimson_CandidateSchedule	CandidateSchedule
mercury_charge_mc	mercury_charge_mc	Charge
mercury_charge_mc_currency	mercury_charge_mc_currency	Charge Currency
mercury_charge_mc_normalised	mercury_charge_mc_normalised	Charge Normalised
mercury_charge_mc_normalised_base	mercury_charge_mc_normalised_Base	Charge Normalised (Base)
crimson_clientaddress1	crimson_ClientAddress1	Client Address 1
crimson_clientaddress2	crimson_ClientAddress2	Client Address 2
crimson_clientaddress3	crimson_ClientAddress3	Client Address 3
crimson_clientaddresscountry	crimson_ClientAddressCountry	Client Address Country
mercury_clientaddresscountrylookup	mercury_clientaddresscountrylookup	Client Address Country Lookup
crimson_clientaddresscounty	crimson_ClientAddressCounty	Client Address County
recruit_clientaddressid	recruit_clientaddressid	Client address ID
crimson_clientaddressname	crimson_ClientAddressName	Client Address Name
crimson_clientaddresspostcode	crimson_ClientAddressPostCode	Client Address PostCode
mercury_clientaddressstatelookup	mercury_clientaddressstatelookup	Client Address State LU
crimson_clientaddresstowncity	crimson_ClientAddressTownCity	Client Address Town/City
crimson_clientcontact	crimson_clientcontact	Client Contact
recruit_invoiceaddressclient	recruit_invoiceaddressclient	Client Invoice Client
crimson_clientname	crimson_clientname	Client Name
crimson_clientpaperworkissued	crimson_ClientPaperworkIssued	Client Paperwork Issued
crimson_clientpaperworkreceived	crimson_ClientPaperworkReceived	Client Paperwork Received
crimson_clientpaperworkto	crimson_Clientpaperworkto	Client Paperwork To
mercury_clientproject	mercury_clientproject	Client project
mercury_clientrelationshipowner	mercury_clientrelationshipowner	Client Relationship Owner
crimson_clientsiteaddress1	crimson_ClientSiteAddress1	Client Site Address 1
crimson_clientsiteaddress2	crimson_ClientSiteAddress2	Client Site Address 2
crimson_clientsiteaddress3	crimson_ClientSiteAddress3	Client Site Address 3
recruit_clientsiteaddressid	recruit_clientsiteaddressid	Client site address ID
crimson_clientsiteaddressname	crimson_ClientSiteAddressName	Client Site Address Name
mercury_clientsitestatelookup	mercury_clientsitestatelookup	Client Site Address State LU
crimson_clientsiteaddresstypecode	crimson_ClientSiteAddressTypeCode	Client Site Address Type Code
crimson_clientsitecountry	crimson_ClientSiteCountry	Client Site Country
mercury_clientsitecountrylookup	mercury_clientsitecountrylookup	Client Site Country Lookup
crimson_clientsitecounty	crimson_ClientSiteCounty	Client Site County
crimson_clientsitepostcode	crimson_ClientSitePostCode	Client Site PostCode
crimson_clientsitetowncity	crimson_ClientSiteTownCity	Client Site Town / City
mercury_clientspecificvalue01	mercury_clientspecificvalue01	Client Specific Value 01
mercury_clientspecificvalue02	mercury_clientspecificvalue02	Client Specific Value 02
mercury_clientspecificvalue03	mercury_clientspecificvalue03	Client Specific Value 03
mercury_clientspecificvalue04	mercury_clientspecificvalue04	Client Specific Value 04
mercury_clientspecificvalue05	mercury_clientspecificvalue05	Client Specific Value 05
mercury_clientspecificvalue06	mercury_clientspecificvalue06	Client Specific Value 06
mercury_clientspecificvalue07	mercury_clientspecificvalue07	Client Specific Value 07
mercury_clientspecificvalue08	mercury_clientspecificvalue08	Client Specific Value 08
crimson_clienttemplatepack	crimson_ClientTemplatePack	Client Template Pack
crimson_clientcontract	crimson_ClientContract	ClientContract
crimson_clientletter	crimson_ClientLetter	ClientLetter
crimson_clientschedule	crimson_ClientSchedule	ClientSchedule
crimson_comments	crimson_Comments	Comments
crimson_commission	crimson_Commission	Commission 0
mercury_commission0gp	mercury_Commission0GP	Commission 0 GP
mercury_commission0gp_base	mercury_commission0gp_Base	Commission 0 GP (Base)
crimson_commission1	crimson_Commission1	Commission 1
mercury_commission1gp	mercury_Commission1GP	Commission 1 GP
mercury_commission1gp_base	mercury_commission1gp_Base	Commission 1 GP (Base)
crimson_commission2	crimson_Commission2	Commission 2
mercury_commission2gp	mercury_Commission2GP	Commission 2 GP
mercury_commission2gp_base	mercury_commission2gp_Base	Commission 2 GP (Base)
crimson_commission3	crimson_Commission3	Commission 3
mercury_commission3gp	mercury_Commission3GP	Commission 3 GP
mercury_commission3gp_base	mercury_commission3gp_Base	Commission 3 GP (Base)
crimson_commissionconsultant	crimson_CommissionConsultant	Commission Consultant 0
crimson_commissionconsultant1	crimson_CommissionConsultant1	Commission Consultant 1
crimson_commissionconsultant2	crimson_CommissionConsultant2	Commission Consultant 2
crimson_commissionconsultant3	crimson_CommissionConsultant3	Commission Consultant 3
recruit_commissionflatrate0	recruit_commissionflatrate0	Commission Flat Rate 0
recruit_commissionflatrate0_base	recruit_commissionflatrate0_Base	Commission Flat Rate 0 (Base)
recruit_commissionflatrate1	recruit_commissionflatrate1	Commission Flat Rate 1
recruit_commissionflatrate1_base	recruit_commissionflatrate1_Base	Commission Flat Rate 1 (Base)
recruit_commissionflatrate2	recruit_commissionflatrate2	Commission Flat Rate 2
recruit_commissionflatrate2_base	recruit_commissionflatrate2_Base	Commission Flat Rate 2 (Base)
recruit_commissionflatrate3	recruit_commissionflatrate3	Commission Flat Rate 3
recruit_commissionflatrate3_base	recruit_commissionflatrate3_Base	Commission Flat Rate 3 (Base)
mercury_commissionrate	mercury_commissionrate	Commission Rate 0
mercury_commissionrate1	mercury_commissionrate1	Commission Rate 1
mercury_commissionrate2	mercury_commissionrate2	Commission Rate 2
mercury_commissionrate3	mercury_commissionrate3	Commission Rate 3
crimson_commissiontotal	crimson_CommissionTotal	Commission Total
crimson_companyequipment	crimson_CompanyEquipment	Company Equipment
mercury_compliancecomplete	mercury_compliancecomplete	Compliance % complete
mercury_compliancy	mercury_Compliancy	Compliancy
mercury_compliantoncreate	mercury_compliantoncreate	Compliant on Create
crimson_consultant	crimson_consultant	Consultant
crimson_contractbonus	crimson_ContractBonus	Contract Bonus
crimson_contractbonus_base	crimson_contractbonus_Base	Contract Bonus (Base)
crimson_contractbonusdescription	crimson_ContractBonusDescription	Contract Bonus Description
crimson_contractbonusfrequency	crimson_ContractBonusFrequency	Contract Bonus Frequency
crimson_contractbonustimesheetinterval	crimson_ContractBonusTimesheetInterval	Contract Bonus Timesheet Interval
crimson_standardcontractfrequency	crimson_StandardContractFrequency	Contract Frequency
crimson_contractholidaypay	crimson_ContractHolidayPay	Contract Holiday Pay
crimson_contractholidaypay_base	crimson_contractholidaypay_Base	Contract Holiday Pay (Base)
crimson_contractstandardpay	crimson_ContractStandardPay	Contract Standard Pay
mercury_contractorrelationship_userid	mercury_contractorrelationship_userid	Contractor Relationship Owner
recruit_convertedplacementid	recruit_convertedplacementid	Converted Placement
recruit_clientaddresssclient	recruit_clientaddresssclient	Correspondence Client
recruit_costanddeductionstatus	recruit_costanddeductionstatus	Cost and deduction status
mercury_costcentreid	mercury_CostCentreId	Cost Centre
recruit_createexpenses	recruit_createexpenses	Create Expenses?
crimson_createplacementid	crimson_createplacementid	Create Placement
mercury_createtimesheets	mercury_createtimesheets	Create timesheets?
createdby	CreatedBy	Created By
createdonbehalfby	CreatedOnBehalfBy	Created By (Delegate)
createdon	CreatedOn	Created On
mercury_createdviacloning	mercury_createdviacloning	Created via cloning
crimson_creditchecked	crimson_CreditChecked	Credit Checked
crimson_creditcheckeddate	crimson_CreditCheckedDate	Credit Checked Date
transactioncurrencyid	TransactionCurrencyId	Currency
mercury_currentdate	mercury_CurrentDate	Current Date Time
recruit_dateuserfield1	recruit_dateuserfield1	Date User Field 1
recruit_dateuserfield2	recruit_dateuserfield2	Date User Field 2
recruit_dateuserfield3	recruit_dateuserfield3	Date User Field 3
recruit_dateuserfield4	recruit_dateuserfield4	Date User Field 4
recruit_dateuserfield5	recruit_dateuserfield5	Date User Field 5
recruit_datetimeuserfield1	recruit_datetimeuserfield1	Datetime User Field 1
recruit_datetimeuserfield2	recruit_datetimeuserfield2	Datetime User Field 2
recruit_datetimeuserfield3	recruit_datetimeuserfield3	Datetime User Field 3
recruit_datetimeuserfield4	recruit_datetimeuserfield4	Datetime User Field 4
recruit_datetimeuserfield5	recruit_datetimeuserfield5	Datetime User Field 5
crimson_daysperweek	crimson_DaysPerWeek	Days Per Week
crimson_deliverables	crimson_Deliverables	Deliverables
crimson_departmentteam	crimson_departmentteam	Department/Team
mercury_discipline	mercury_discipline	Discipline
crimson_division	crimson_Division	Division
mercury_documentlocationwascreated	mercury_documentlocationwascreated	Document location was created
crimson_eaaoptout	crimson_EAAOptOut	EAA Opt Out
crimson_eaaoptoutdate	crimson_EAAOptOutDate	EAA Opt Out Date
emailaddress	EmailAddress	E-mail Address
recruit_endclient	recruit_endclient	End Client
recruit_endcontact	recruit_endcontact	End Contact
mercury_enddatereached	mercury_enddatereached	End date reached?
crimson_enddatetext	crimson_enddatetext	End Date Text
mercury_endsoondate	mercury_endsoondate	End soon date
mercury_engagementid	mercury_EngagementId	Engagement
recruit_epcwicount	recruit_epcwicount	EPC WI count
exchangerate	ExchangeRate	Exchange Rate
recruit_exemptfromworkinghours	recruit_exemptfromworkinghours	Exempt from Working Hours?
recruit_expensetemplate	recruit_expensetemplate	Expense template
mercury_extendedplacementid	mercury_ExtendedPlacementId	Extended Placement
crimson_extension	crimson_Extension	Extension
mercury_externalsystemkey	mercury_externalsystemkey	External System Key
mercury_feebasedon2	mercury_feebasedon2	Fee Based On
mercury_finalapprovalcomplete	mercury_finalapprovalcomplete	Final approval complete?
mercury_finalised	mercury_Finalised	Finalised
mercury_clientref	mercury_ClientRef	Finance Account Ref
recruit_fixedtermcontract	recruit_fixedtermcontract	Fixed Term Contract
crimson_frequency	crimson_Frequency	Frequency
mercury_grossprofit_mc	mercury_grossprofit_mc	Gross Profit
mercury_grossprofit_mc_currency	mercury_grossprofit_mc_currency	Gross Profit Currency
mercury_grossprofit_mc_normalised	mercury_grossprofit_mc_normalised	Gross Profit Normalised
mercury_grossprofit_mc_normalised_base	mercury_grossprofit_mc_normalised_Base	Gross Profit Normalised (Base)
mercury_hardenddate	mercury_hardenddate	Hard end date
recruit_ushomebased	recruit_ushomebased	Home Based
crimson_standardhours	crimson_StandardHours	Hours
mercury_hoursperweek	mercury_HoursPerWeek	Hours Per Week
crimson_idlogged	crimson_IDLogged	ID Logged
crimson_idloggeddate	crimson_IDLoggedDate	ID Logged Date
importsequencenumber	ImportSequenceNumber	Import Sequence Number
mercury_importednote	mercury_ImportedNote	Imported Note
mercury_importedrecordid	mercury_ImportedRecordId	Imported Record Id
mercury_incrementrevision	mercury_IncrementRevision	Increment Revision #?
mercury_inheritancestatus	mercury_InheritanceStatus	Inheritance Status
mercury_initialteam	mercury_InitialTeam	Initial Team
crimson_invoiceaddress1	crimson_InvoiceAddress1	Invoice Address 1
crimson_invoiceaddress2	crimson_InvoiceAddress2	Invoice Address 2
crimson_invoiceaddress3	crimson_InvoiceAddress3	Invoice Address 3
crimson_invoiceaddresscountry	crimson_InvoiceAddressCountry	Invoice Address Country
mercury_invoiceaddresscountrylookup	mercury_invoiceaddresscountrylookup	Invoice Address Country Lookup
crimson_invoiceaddresscounty	crimson_InvoiceAddressCounty	Invoice Address County
recruit_invoiceaddressid	recruit_invoiceaddressid	Invoice address ID
crimson_invoiceaddressname	crimson_InvoiceAddressName	Invoice Address Name
crimson_invoiceaddresspostcode	crimson_InvoiceAddressPostCode	Invoice Address PostCode
mercury_invoiceaddressstatelookup	mercury_invoiceaddressstatelookup	Invoice Address State LU
crimson_invoiceaddresstowncity	crimson_InvoiceAddressTownCity	Invoice Address Town/City
crimson_invoiceaddresstypecode	crimson_InvoiceAddressTypeCode	Invoice Address Type Code
new_invoicecontact	new_Invoicecontact	Invoice contact
mercury_ipaddress	mercury_ipaddress	IP Address
recruit_isconfirmedstart	recruit_isconfirmedstart	Is Confirmed Start
recruit_isfullepcrecalcpending	recruit_isfullepcrecalcpending	Is full EPC recalc pending?
mercury_ismarginonly	mercury_IsMarginOnly	Is Margin Only
recruit_isconverttopermanentclicked	recruit_isconverttopermanentclicked	IsConvertToPermanentClicked
recruit_issuepaperwork	recruit_issuepaperwork	Issue Paperwork
crimson_name	crimson_name	Job Title
mercury_lastforceinherittriggeredon	mercury_LastForceInheritTriggeredOn	Last Force Inherit Triggered On
mercury_legalreview	mercury_legalreview	Legal review
recruit_likelytoextend	recruit_likelytoextend	Likely to Extend
mercury_marginpercent	mercury_MarginPercent	Margin %
mercury_marginvalue_mc	mercury_marginvalue_mc	Margin Value
mercury_marginvalue_mc_currency	mercury_marginvalue_mc_currency	Margin Value Currency
mercury_marginvalue_mc_normalised	mercury_marginvalue_mc_normalised	Margin Value Normalised
mercury_marginvalue_mc_normalised_base	mercury_marginvalue_mc_normalised_Base	Margin Value Normalised (Base)
mercury_markuppercent	mercury_MarkupPercent	Markup %
crimson_milestones	crimson_Milestones	Milestones
modifiedby	ModifiedBy	Modified By
modifiedonbehalfby	ModifiedOnBehalfBy	Modified By (Delegate)
modifiedon	ModifiedOn	Modified On
mercury_mostrecentinherit	mercury_mostrecentinherit	Most recent inherit
mercury_multicurrencyxml	mercury_multicurrencyxml	Multi Currency Xml
crimson_noticecandidateweek	crimson_NoticeCandidateweek	Notice Candidate
crimson_noticeclientweek	crimson_NoticeClientweek	Notice Client
mercury_numberofdays	mercury_NumberofDays	Number of Days
mercury_numberofhours	mercury_NumberofHours	Number of Hours
mercury_numberofmonths	mercury_NumberofMonths	Number of Months
crimson_numberofweeks	crimson_NumberofWeeks	Number of Weeks
recruit_numericuserfield1	recruit_numericuserfield1	Numeric User Field 1
recruit_numericuserfield2	recruit_numericuserfield2	Numeric User Field 2
recruit_numericuserfield3	recruit_numericuserfield3	Numeric User Field 3
recruit_numericuserfield4	recruit_numericuserfield4	Numeric User Field 4
recruit_numericuserfield5	recruit_numericuserfield5	Numeric User Field 5
mercury_offboardingcomplete	mercury_offboardingcomplete	Offboarding % complete
mercury_offboardingiscomplete	mercury_offboardingiscomplete	Offboarding is complete?
mercury_offboardingstatus	mercury_offboardingstatus	Offboarding status
mercury_onboardedoncreate	mercury_onboardedoncreate	Onboarded on Create
mercury_onboardingcomplete	mercury_onboardingcomplete	Onboarding % complete
mercury_onboardingiscomplete	mercury_onboardingiscomplete	Onboarding is complete?
mercury_onboardingstatus	mercury_onboardingstatus	Onboarding status
recruit_oncosts_mc	recruit_oncosts_mc	On-costs
recruit_oncostspercent	recruit_oncostspercent	On-costs %
recruit_oncosts_mc_currency	recruit_oncosts_mc_currency	On-costs Currency
recruit_oncosts_mc_normalised	recruit_oncosts_mc_normalised	On-costs Normalised
recruit_oncosts_mc_normalised_base	recruit_oncosts_mc_normalised_Base	On-costs Normalised (Base)
mercury_onshoreoffshore2	mercury_onshoreoffshore2	Onshore/Offshore
crimson_enddate	crimson_EndDate	Original End Date
ownerid	OwnerId	Owner
owningbusinessunit	OwningBusinessUnit	Owning Business Unit
owningteam	OwningTeam	Owning Team
owninguser	OwningUser	Owning User
crimson_paperworkcontactid	crimson_PaperworkcontactId	Paperwork contact
mercury_paperworkiscomplete	mercury_paperworkiscomplete	Paperwork is complete?
mercury_papeworkissuedby	mercury_papeworkissuedby	Paperwork Issued By
mercury_paperworkissuedon	mercury_paperworkissuedon	Paperwork Issued On
crimson_paperworkstatus	crimson_PaperworkStatus	Paperwork Status
mercury_parentplacementid	mercury_ParentPlacementId	Parent Placement
mercury_parentplacementstatussyncdate	mercury_ParentPlacementStatusSyncDate	Parent Placement Status Sync Date
mercury_pay_mc	mercury_pay_mc	Pay
mercury_pay_mc_currency	mercury_pay_mc_currency	Pay Currency
crimson_payinterval	crimson_PayInterval	Pay Interval
mercury_pay_mc_normalised	mercury_pay_mc_normalised	Pay Normalised
mercury_pay_mc_normalised_base	mercury_pay_mc_normalised_Base	Pay Normalised (Base)
recruit_payplusoncosts_mc	recruit_payplusoncosts_mc	Pay With On-costs
recruit_payplusoncosts_mc_currency	recruit_payplusoncosts_mc_currency	Pay With On-costs Currency
recruit_payplusoncosts_mc_normalised	recruit_payplusoncosts_mc_normalised	Pay With On-costs Normalised
recruit_payplusoncosts_mc_normalised_base	recruit_payplusoncosts_mc_normalised_Base	Pay With On-costs Normalised (Base)
mercury_payablelegalentity	mercury_payablelegalentity	Payable Legal Entity
mercury_payrollno	mercury_payrollno	Payroll No.
recruit_payrolltaxexempt	recruit_payrolltaxexempt	Payroll Tax Exempt?
crimson_permanentbenefitsdescription	crimson_PermanentBenefitsDescription	Permanent Benefits Description
crimson_permanentenddate	crimson_PermanentEndDate	Permanent End Date
mercury_permanentfee_mc	mercury_permanentfee_mc	Permanent Fee
crimson_permanentfeepercent	crimson_PermanentFeePercent	Permanent Fee %
mercury_permanentfee_mc_currency	mercury_permanentfee_mc_currency	Permanent Fee Currency
mercury_permanentfee_mc_normalised	mercury_permanentfee_mc_normalised	Permanent Fee Normalised
mercury_permanentfee_mc_normalised_base	mercury_permanentfee_mc_normalised_Base	Permanent Fee Normalised (Base)
mercury_permanentpackagevalue_mc	mercury_permanentpackagevalue_mc	Permanent Package Value
mercury_permanentpackagevalue_mc_currency	mercury_permanentpackagevalue_mc_currency	Permanent Package Value Currency
mercury_permanentpackagevalue_mc_normalised	mercury_permanentpackagevalue_mc_normalised	Permanent Package Value Normalised
mercury_permanentpackagevalue_mc_normalised_base	mercury_permanentpackagevalue_mc_normalised_Base	Permanent Package Value Normalised (Base)
mercury_permanentsalary_mc	mercury_permanentsalary_mc	Permanent Salary
mercury_permanentsalary_mc_currency	mercury_permanentsalary_mc_currency	Permanent Salary Currency
mercury_permanentsalary_mc_normalised	mercury_permanentsalary_mc_normalised	Permanent Salary Normalised
mercury_permanentsalary_mc_normalised_base	mercury_permanentsalary_mc_normalised_Base	Permanent Salary Normalised (Base)
crimson_permanentstartdate	crimson_PermanentStartDate	Permanent Start Date
crimson_placementid	crimson_placementId	Placement
mercury_placementfinalisedby	mercury_placementfinalisedby	Placement Finalised By
mercury_placementfinalisedon	mercury_placementfinalisedon	Placement Finalised On
mercury_placementlastapprovedby	mercury_PlacementLastApprovedBy	Placement Last Approved By
mercury_placementlastapprovedon	mercury_placementlastapprovedon	Placement Last Approved On
crimson_placementstatus	crimson_PlacementStatus	Placement Status
recruit_placementvalidated	recruit_PlacementValidated	Placement Validated
recruit_placementvalidation	recruit_placementvalidation	Placement Validation
crimson_placementidcode	crimson_PlacementIDCode	PlacementID
mercury_purchaseorderrequired	mercury_purchaseorderrequired	PO required?
mercury_preventcascadeinherit	mercury_PreventCascadeInherit	Prevent Cascade/Inherit?
mercury_preventcompliancestatusclone	mercury_PreventComplianceStatusClone	Prevent Compliance Status Clone?
mercury_preventplacementbenefitsclone	mercury_PreventPlacementBenefitsClone	Prevent Placement Benefits Clone?
mercury_preventplacementcostcentreclone	mercury_PreventPlacementCostCentreClone	Prevent Placement Cost Centre Clone?
mercury_preventplacementexpenserulesclone	mercury_PreventPlacementExpenseRulesClone	Prevent Placement Expense Rules Clone?
mercury_preventplacementratesclone	mercury_PreventPlacementRatesClone	Prevent Placement Rates Clone?
crimson_primaryauthoriserid	crimson_PrimaryauthoriserId	Primary Authoriser
processid	processid	Process Id
crimson_profindemnitycertreceived	crimson_ProfIndemnitycertreceived	Prof Indemnity cert received
recruit_project	recruit_project	Project
crimson_publicliabilitycertreceived	crimson_PublicLiabilitycertreceived	Public Liability cert received
recruit_rebateamount	recruit_rebateamount	Rebate Amount
recruit_rebateamount_base	recruit_rebateamount_Base	Rebate Amount (Base)
recruit_rebateuntil	recruit_rebateuntil	Rebate Until
recruit_rebateweeks	recruit_rebateweeks	Rebate Weeks
recruit_rebated	recruit_rebated	Rebated
recruit_rebatedon	recruit_rebatedon	Rebated On
overriddencreatedon	OverriddenCreatedOn	Record Created On
recruit_commission3gp	recruit_commission3GP	Recruit Commission 3 GP
recruit_commission3gp_base	recruit_commission3gp_Base	Recruit Commission 3 GP (Base)
mercury_recruitmenttype	mercury_recruitmenttype	Recruitment type
crimson_referencereceived	crimson_ReferenceReceived	Reference Received
crimson_referencereceiveddate	crimson_ReferenceReceivedDate	Reference Received Date
crimson_registeredaddresscity	crimson_RegisteredAddressCity	Registered Address City
crimson_registeredaddresscountry	crimson_RegisteredAddressCountry	Registered Address Country
mercury_registeredaddresscountrylookup	mercury_registeredaddresscountrylookup	Registered Address Country Lookup
crimson_registeredaddresscounty	crimson_RegisteredAddressCounty	Registered Address County
crimson_registeredaddressname	crimson_RegisteredAddressName	Registered Address Name
crimson_registeredaddresspostcode	crimson_RegisteredAddressPostCode	Registered Address PostCode
mercury_registeredaddressstatelookup	mercury_registeredaddressstatelookup	Registered Address State LU
crimson_registeredaddressstreet1	crimson_RegisteredAddressStreet1	Registered Address Street 1
crimson_registeredaddressstreet2	crimson_RegisteredAddressStreet2	Registered Address Street 2
crimson_registeredaddressstreet3	crimson_RegisteredAddressStreet3	Registered Address Street 3
crimson_registeredaddresstowncity	crimson_RegisteredAddressTownCity	Registered Address Town/City
crimson_registeredaddresstypecode	crimson_RegisteredAddressTypeCode	Registered Address Type Code
crimson_reportdates	crimson_ReportDates	Report Dates
mercury_reportingbusinessunit	mercury_reportingbusinessunit	Reporting business unit
mercury_reportingregion	mercury_reportingregion	Reporting region
crimson_reports	crimson_Reports	Reports
crimson_requirements	crimson_Requirements	Requirements
mercury_residencystatus	mercury_residencystatus	Residency status
crimson_revision	crimson_Revision	Revision
recruit_runningstatus	recruit_runningstatus	Running Status
mercury_salesvalue_mc	mercury_salesvalue_mc	Sales Value
mercury_salesvalue_mc_currency	mercury_salesvalue_mc_currency	Sales Value Currency
mercury_salesvalue_mc_normalised	mercury_salesvalue_mc_normalised	Sales Value Normalised
mercury_salesvalue_mc_normalised_base	mercury_salesvalue_mc_normalised_Base	Sales Value Normalised (Base)
crimson_secondaryauthoriserid	crimson_SecondaryauthoriserId	Second Authoriser
mercury_sendtoexternalsystem	mercury_sendtoexternalsystem	Send to external system
mercury_sentiment	mercury_sentiment	Sentiment
mercury_sharepointtrigger	mercury_sharepointtrigger	SharePoint trigger
mercury_shortlistmethod	mercury_ShortlistMethod	Shortlist Method
mercury_shortlistsource	mercury_ShortlistSource	Shortlist Source
mercury_showfinaliseterms	mercury_ShowFinaliseTerms	Show Finalise Terms
recruit_clientsiteclient	recruit_clientsiteclient	Site Client
crimson_specialinstructions	crimson_SpecialInstructions	Special Instructions
crimson_specialinstructionsclient	crimson_specialinstructionsclient	Special Instructions Client
stageid	stageid	Stage Id
recruit_standardclassification	recruit_standardclassification	Standard Classification
mercury_standardrateid	mercury_StandardRateId	Standard Placement Rate
mercury_standardratetypeid	mercury_StandardRateTypeId	Standard Rate Type
crimson_startdate	crimson_StartDate	Start Date
crimson_startdatetext	crimson_startdatetext	start date text
recruit_startingsoondate	recruit_startingsoondate	Starting Soon Date
statecode	statecode	Status
statuscode	statuscode	Status Reason
mercury_subsector	mercury_subsector	Subsector
recruit_taxexempt	recruit_taxexempt	Tax Exempt
recruit_taxableas	recruit_taxableas	Taxable As
mercury_tempcandidatepay_mc	mercury_tempcandidatepay_mc	Temp Candidate Pay
mercury_tempcandidatepay_mc_currency	mercury_tempcandidatepay_mc_currency	Temp Candidate Pay Currency
mercury_tempcandidatepay_mc_normalised	mercury_tempcandidatepay_mc_normalised	Temp Candidate Pay Normalised
mercury_tempcandidatepay_mc_normalised_base	mercury_tempcandidatepay_mc_normalised_Base	Temp Candidate Pay Normalised (Base)
mercury_tempdeductionpercent	mercury_tempdeductionpercent	Temp Deduction %
mercury_tempdeductions_mc	mercury_tempdeductions_mc	Temp Deductions
mercury_tempdeductions_mc_currency	mercury_tempdeductions_mc_currency	Temp Deductions Currency
mercury_tempdeductions_mc_normalised	mercury_tempdeductions_mc_normalised	Temp Deductions Normalised
mercury_tempdeductions_mc_normalised_base	mercury_tempdeductions_mc_normalised_Base	Temp Deductions Normalised (Base)
timezoneruleversionnumber	TimeZoneRuleVersionNumber	Time Zone Rule Version Number
crimson_timesheetinterval	crimson_TimesheetInterval	Timesheet Interval
mercury_timesheettemplate2	mercury_timesheettemplate2	Timesheet template
recruit_totalcosts	recruit_totalcosts	Total Costs
recruit_totalcosts_base	recruit_totalcosts_Base	Total Costs (Base)
recruit_totalcosts_date	recruit_totalcosts_Date	Total Costs (Last Updated On)
recruit_totalcosts_state	recruit_totalcosts_State	Total Costs (State)
recruit_totaldeductions_mc	recruit_totaldeductions_mc	Total Deductions
recruit_totaldeductions_mc_currency	recruit_totaldeductions_mc_currency	Total Deductions Currency
recruit_totaldeductions_mc_normalised	recruit_totaldeductions_mc_normalised	Total Deductions Normalised
recruit_totaldeductions_mc_normalised_base	recruit_totaldeductions_mc_normalised_Base	Total Deductions Normalised (Base)
mercury_totalestimatedpay_mc	mercury_totalestimatedpay_mc	Total Estimated Pay
mercury_totalestimatedpay_mc_currency	mercury_totalestimatedpay_mc_currency	Total Estimated Pay Currency
mercury_totalestimatedpay_mc_normalised	mercury_totalestimatedpay_mc_normalised	Total Estimated Pay Normalised
mercury_totalestimatedpay_mc_normalised_base	mercury_totalestimatedpay_mc_normalised_Base	Total Estimated Pay Normalised (Base)
recruit_totalnonreimbursablecosts	recruit_totalnonreimbursablecosts	Total Non Reimbursable Costs
recruit_totalnonreimbursablecosts_base	recruit_totalnonreimbursablecosts_Base	Total Non Reimbursable Costs (Base)
recruit_totalnonreimbursablecosts_date	recruit_totalnonreimbursablecosts_Date	Total Non Reimbursable Costs (Last Updated On)
recruit_totalnonreimbursablecosts_state	recruit_totalnonreimbursablecosts_State	Total Non Reimbursable Costs (State)
recruit_totaloncosts_mc	recruit_totaloncosts_mc	Total On-costs
recruit_totaloncosts_mc_currency	recruit_totaloncosts_mc_currency	Total On-costs Currency
recruit_totaloncosts_mc_normalised	recruit_totaloncosts_mc_normalised	Total On-costs Normalised
recruit_totaloncosts_mc_normalised_base	recruit_totaloncosts_mc_normalised_Base	Total On-costs Normalised (Base)
recruit_totalpayplusoncosts_mc	recruit_totalpayplusoncosts_mc	Total Pay With On-costs
recruit_totalpayplusoncosts_mc_currency	recruit_totalpayplusoncosts_mc_currency	Total Pay With On-costs Currency
recruit_totalpayplusoncosts_mc_normalised	recruit_totalpayplusoncosts_mc_normalised	Total Pay With On-costs Normalised
recruit_totalpayplusoncosts_mc_normalised_base	recruit_totalpayplusoncosts_mc_normalised_Base	Total Pay With On-costs Normalised (Base)
recruit_totalreimbursablecosts	recruit_totalreimbursablecosts	Total Reimbursable Costs
recruit_totalreimbursablecosts_base	recruit_totalreimbursablecosts_Base	Total Reimbursable Costs (Base)
recruit_totalreimbursablecosts_date	recruit_totalreimbursablecosts_Date	Total Reimbursable Costs (Last Updated On)
recruit_totalreimbursablecosts_state	recruit_totalreimbursablecosts_State	Total Reimbursable Costs (State)
mercury_transitionblockingreason	mercury_transitionblockingreason	Transition blocking reason
recruit_transitionblockingsettocascadeorinheriton	recruit_transitionblockingsettocascadeorinheriton	Transition blocking set to cascade or inherit on
traversedpath	traversedpath	Traversed Path
recruit_truegrossprofit	recruit_truegrossprofit	True Gross Profit
recruit_truegrossprofitcurrency	recruit_truegrossprofitcurrency	True Gross Profit Currency
recruit_truegrossprofitnormalised2	recruit_truegrossprofitnormalised2	True Gross Profit Normalised
recruit_truegrossprofitnormalised2_base	recruit_truegrossprofitnormalised2_Base	True Gross Profit Normalised (Base)
recruit_trueweeklygrossprofit	recruit_trueweeklygrossprofit	True Weekly Gross Profit
recruit_trueweeklygrossprofitcurrency	recruit_trueweeklygrossprofitcurrency	True Weekly Gross Profit Currency
recruit_trueweeklygrossprofitnormalised2	recruit_trueweeklygrossprofitnormalised2	True Weekly Gross Profit Normalised
recruit_trueweeklygrossprofitnormalised2_base	recruit_trueweeklygrossprofitnormalised2_Base	True Weekly Gross Profit Normalised (Base)
crimson_type	crimson_Type	Type
mercury_userfield1	mercury_UserField1	User Field 1
mercury_userfield2	mercury_UserField2	User Field 2
mercury_userfield3	mercury_UserField3	User Field 3
mercury_userfield4	mercury_UserField4	User Field 4
mercury_userfield5	mercury_UserField5	User Field 5
utcconversiontimezonecode	UTCConversionTimeZoneCode	UTC Conversion Time Zone Code
crimson_vacancy	crimson_vacancy	Vacancy
versionnumber	VersionNumber	Version Number
crimson_warrantyperiod	crimson_WarrantyPeriod	Warranty Period
recruit_weeklymarginvalue_mc	recruit_weeklymarginvalue_mc	Weekly Margin Value
recruit_weeklymarginvalue_mc_currency	recruit_weeklymarginvalue_mc_currency	Weekly Margin Value Currency
recruit_weeklymarginvalue_mc_normalised	recruit_weeklymarginvalue_mc_normalised	Weekly Margin Value Normalised
recruit_weeklymarginvalue_mc_normalised_base	recruit_weeklymarginvalue_mc_normalised_Base	Weekly Margin Value Normalised (Base)
mercury_workpattern	mercury_workpattern	Work pattern
mercury_onshoreoffshore	mercury_onshoreoffshore	X DNU Onshore/offshore

Fee schema

Entity	Fee

Logical Name	Schema Name	Display Name
recruit_addressid	recruit_addressid	Address ID
recruit_agreement	recruit_agreement	Agreement
mercury_amount	mercury_amount	Amount
mercury_amount_base	mercury_amount_Base	Amount (Base)
recruit_city	recruit_city	City
mercury_client	mercury_client	Client
mercury_comments	mercury_comments	Comments
recruit_commission0	recruit_commission0	Commission 0
recruit_commission0gp	recruit_commission0gp	Commission 0 GP
recruit_commission0gp_base	recruit_commission0gp_Base	Commission 0 GP (Base)
recruit_commission1	recruit_commission1	Commission 1
recruit_commission1gp	recruit_commission1gp	Commission 1 GP
recruit_commission1gp_base	recruit_commission1gp_Base	Commission 1 GP (Base)
recruit_commission2	recruit_commission2	Commission 2
recruit_commission2gp	recruit_commission2gp	Commission 2 GP
recruit_commission2gp_base	recruit_commission2gp_Base	Commission 2 GP (Base)
recruit_commission3	recruit_commission3	Commission 3
recruit_commission3gp	recruit_commission3gp	Commission 3 GP
recruit_commission3gp_base	recruit_commission3gp_Base	Commission 3 GP (Base)
recruit_commissionconsultant0	recruit_commissionconsultant0	Commission Consultant 0
recruit_commissionconsultant1	recruit_commissionconsultant1	Commission Consultant 1
recruit_commissionconsultant2	recruit_commissionconsultant2	Commission Consultant 2
recruit_commissionconsultant3	recruit_commissionconsultant3	Commission Consultant 3
recruit_commissionflatrate0	recruit_commissionflatrate0	Commission Flat Rate 0
recruit_commissionflatrate0_base	recruit_commissionflatrate0_Base	Commission Flat Rate 0 (Base)
recruit_commissionflatrate1	recruit_commissionflatrate1	Commission Flat Rate 1
recruit_commissionflatrate1_base	recruit_commissionflatrate1_Base	Commission Flat Rate 1 (Base)
recruit_commissionflatrate2	recruit_commissionflatrate2	Commission Flat Rate 2
recruit_commissionflatrate2_base	recruit_commissionflatrate2_Base	Commission Flat Rate 2 (Base)
recruit_commissionflatrate3	recruit_commissionflatrate3	Commission Flat Rate 3
recruit_commissionflatrate3_base	recruit_commissionflatrate3_Base	Commission Flat Rate 3 (Base)
recruit_commissiontotal	recruit_commissiontotal	Commission Total
mercury_consultant	mercury_consultant	Consultant
mercury_contact	mercury_contact	Contact
recruit_country	recruit_country	Country
recruit_county	recruit_county	County
createdby	CreatedBy	Created By
createdonbehalfby	CreatedOnBehalfBy	Created By (Delegate)
createdon	CreatedOn	Created On
transactioncurrencyid	TransactionCurrencyId	Currency
mercury_date	mercury_date	Date
recruit_deferredby	recruit_deferredby	Deferred By
recruit_deferredon	recruit_deferredon	Deferred On
recruit_enddate	recruit_enddate	End Date
exchangerate	ExchangeRate	Exchange Rate
mercury_feeid	mercury_feeId	Fee
recruit_feecalculation	recruit_feecalculation	Fee calculation
recruit_feeid	recruit_feeid	Fee ID
mercury_name	mercury_name	Fee Name
recruit_financestatus	recruit_financestatus	Finance Status
importsequencenumber	ImportSequenceNumber	Import Sequence Number
mercury_importednote	mercury_ImportedNote	Imported Note
mercury_importedrecordid	mercury_ImportedRecordId	Imported Record Id
recruit_name	recruit_name	Invoice Address Name
recruit_countrytext	recruit_countrytext	Invoice address: Country [text]
statuscode	statuscode	Issue Status
recruit_issuedby	recruit_issuedby	Issued By
recruit_issuedon	recruit_issuedon	Issued On
modifiedby	ModifiedBy	Modified By
modifiedonbehalfby	ModifiedOnBehalfBy	Modified By (Delegate)
modifiedon	ModifiedOn	Modified On
recruit_numberofweeks	recruit_numberofweeks	Number of Weeks
recruit_occurrences	recruit_occurrences	Occurrence
organizationid	OrganizationId	Organization Id
mercury_placement	mercury_placement	Placement
recruit_postalcode	recruit_postalcode	Post Code
recruit_project	recruit_project	Project
recruit_feepurchaseorder	recruit_feepurchaseorder	Purchase Order
recruit_recognisedby	recruit_recognisedby	Recognised By
recruit_recognisedon	recruit_RecognisedOn	Recognised On
overriddencreatedon	OverriddenCreatedOn	Record Created On
recruit_recurringfrequencys	recruit_recurringFrequencys	Recurring Frequency
mercury_refno	mercury_refno	Ref No.
recruit_reimbursable	recruit_reimbursable	Reimbursable?
recruit_settledon	recruit_settledon	Settled On
recruit_startdate	recruit_StartDate	Start Date
recruit_state	recruit_state	State
statecode	statecode	Status
recruit_street1	recruit_street1	Street 1
recruit_street2	recruit_street2	Street 2
recruit_street3	recruit_street3	Street 3
timezoneruleversionnumber	TimeZoneRuleVersionNumber	Time Zone Rule Version Number
recruit_tobeissuedby	recruit_tobeissuedby	To be Issued By
recruit_tobeissuedon	recruit_tobeissuedon	To be Issued On
recruit_totalweekly2	recruit_totalweekly2	Total Costs
recruit_totalweekly2_base	recruit_totalweekly2_Base	Total Weekly (Base)
recruit_transactiontype	recruit_transactiontype	Transaction Type
recruit_types	recruit_types	Type
utcconversiontimezonecode	UTCConversionTimeZoneCode	UTC Conversion Time Zone Code
mercury_vacancy	mercury_vacancy	Vacancy
recruit_vacancystage	recruit_vacancystage	Vacancy stage
versionnumber	VersionNumber	Version Number
recruit_weeklycosts	recruit_WeeklyCosts	Weekly Costs
recruit_weeklycosts_base	recruit_weeklycosts_Base	Weekly Costs (Base)

Keywords: mercury schemas