4. Core Mapping

If you have InTime Core and Bullhorn integration this page details the mappings provided for your system.

Bullhorn API Field (Field Mappings)	Bullhorn Label	InTime field
* means mandatory
Placement		Placement
ID *		Ref Code (prefixed with “BH-”)
Job / Vacancy *
Candidate *	Candidate	Worker
reportTo *	Manager / Timesheet Authoriser	Manager
customText1 *	Company to Invoice	Client
billingUserID	Billing Contact	Sales Invoice Contact override
vendorClientCorporationID	Umbrella Company	Placement Provider
dateBegin *	Start Date	Start Date
dateAdded	Date Added	Placed Date
dateEnd	Scheduled End	End Date
billingFrequency	Timesheet Duration	Timesheet Duration
employmentType *	Employment	determines placement type e.g. Perm /contract
employeeType	Employee Type	Worker Type (PAYE/LTD/Umbrella) if match found. *If this field is blank the Candidate.employeeType field is used.
placementCommissions		Consultant Commissions
Fee	Placement Fee (%)	Used to determine fee for perm placements (salary x fee)
Salary	Salary High	Used to determine fee for perm placements (salary x fee)
salaryUnit	Pay Unit	Time period & duration for all rates Hourly/Fixed. If field value contains "day" or "daily", InTIME sets all rates to fixed else it sets them to hourly.
hoursPerDay	Hours Per Day	Duration of all rates in minutes if salaryUnit field value contains "day" or "daily".
clientBillRate	Bill Rate	Rate 1 charge
payRate	Pay Rate	Rate 1 pay
clientOvertimeRate	Overtime Bill Rate	Rate 2 charge
overtimeRate	Overtime Pay Rate	Rate 2 pay
customBillRateN		Rate N charge
customPayRateN		Rate N pay
comments	Comments	Comments
customText2	Alternative Manager 1	Alternative Manager
customText3	Alternative Manager 2	Alternative Manager
customText4	Approval Route	Approval Routes for timesheets and chargeable expenses. (If employmentType = Perm auto approval is selected for timesheets)
customText5	Email Approval	Email Approval enabled for timesheets and expenses
customText6	QR Approval	QR Approval enabled
customText7	Expenses Allowed	"Default" Expense Template Selected

Job (Vacancy)		Placement
Title *	Title	Job Title
userID *	Owner	Consultant
hoursPerWeek	Contracted Hours Per Week	Contracted hours

PlacementCommissions
userID	Commissions Tab (internal Only)	Commission Consultant
commissionPercentage		Commission percentage

ClientCorporation (Company)		Client
name *	Company Name	Client Name
ID *		Ref Code (prefixed with “BH-”)
Phone	Main Phone	Main Contact phone
address.address1	Address	Main Address line 1
address.address2		Main Address line 2
address.city	City	Main Address Town
address.state	County	Main Address County
address.zip	Post Code	Main Address PostCode
address.Country	Country	Main Address.Country
billingPhone	Billing Phone	Invoice Contact phone
billingContact	Billing Contact	Invoice Contact First name
billingAddress.address1	Billing Address	Invoice Address line 1
billingAddress.address.address2		Invoice Address.line 2
billingAddress.address.city	Billing City	Invoice Address Town
billingAddress.address.state	Billing County	Invoice Address County
billingAddress.address.zip	Billing Post Code	Invoice Address PostCode
customText1	Accounts Ref	Accounts Ref
customText2	Company Number	Company Number
customText3	VAT Reg No	Company Sales Tax Number
customText4	VAT Code	VAT Code
customText5	Invoice Email	Invoice Email Address (Invoices sent by email if populated)
customText10	Currency	Default Currency
customText11	Invoice Consolidation	Invoice Consolidation
customText12	Terms Type	Invoicing Terms Type
customFloat1	Terms Days	Invoicing Terms Days

ClientContact (Contact)		Manager
clientCorporationID *	Current Company	Client
ID *		Ref Code (prefixed with “BH-”)
Email *	Primary Email	Email
firstName *	Contact Name	Firstname
lastName *	Contact Name	Lastname
namePrefix	Name Prefix	Title
phone	Primary Phone	Phone
address.address1	Work Address	Street 1
address.address2		Street 2
address.city	Work City	Town
address.state	Work State	County
address.zip	Work Zip	PostCode
address.Country	Country	Country
division	Department	Department

Candidate		Worker
ID *		Ref Code (prefixed with “BH-”)
email *	Personal Email	Email
firstName *	Candidate Name	Firstname
lastName *	Candidate Name	Lastname
namePrefix	Candidate Name	Title
phone	Home Phone	Phone
address.address1	Address	Street 1
address.address2		Street 2
address.city	City	Town
address.state	County	County
address.zip	Post Code	Post Code
address.countryID	Country	Country
dateOfBirth	Date Of Birth	Date Of Birth
gender	Gender	Gender
employeeType	Employee Type	Worker Type (PAYE/LTD) if match found. *Only used if the Placement.employeeType field is blank.
customEncryptedText1	Bank Account Number	Bank Account Number
customEncryptedText2	Sort Code	Bank Account Sort Code
customEncryptedText3	National Insurance Number	National Insurance Number
customText10	Bank Account Name	Bank Account Name
customText7	Engagement Type	Engagement Type
customText6	Accounts Ref	Accounts Ref
customText9	Building Society Ref	Bank Building Society Ref
customText13	Currency	Currency
customText8	NI Table Letter
customText1	LTD Company Name	LTD Company Name
customText2	Compay Reg No (LTD)	LTD Company No
customText3	Compay VAT Reg No (LTD)	LTD Company VAT No
customText4	VAT Code	VAT Code
customText5	Self Billing (LTD)	Worker is Self Billing
secondaryAddress1	LTD Company Address	LTD Company Address 1
secondaryAddress2		LTD Company Address 2
secondaryCity	City	LTD Company Address Town
secondaryState	County	LTD Company Address County
secondaryZip	Post Code	LTD Company Address Post Code
secondaryCountryID	Country	LTD Company Address Country
		LTD Company Email - defaults to Primary email
		LTD Company Contact Firstname - defaults to Worker First Name
		LTD Company Contact Lastname - defaults to Worker Last Name
		Default to Deliver invioces by email

CorporateUser		Consultant
ID *		Ref Code (prefixed with “BH-”)
email *	Primary Email	Email
firstName *	First Name	Firstname
lastName *	First Name	Lastname
namePrefix	Title	Title
phone	Phone	Phone
address.address1	Address	Street 1
address.address2		Street 2
address.city	City	Town
address.state	County	County
address.zip	Post Code	PostCode
address.countryID	Country	Country
primaryDepartment	Department	Department

ClientCorporation (Company)		Ltd Company Provider (Umbrella)
name *	Company Name	Company Name
ID *		Ref Code (prefixed with “BH-”)
Phone	Main Phone	Main Contact phone
address.address1	Address	Main Address line 1
address.address2		Main Address line 2
address.city	City	Main Address Town
address.state	County	Main Address County
address.zip	Post Code	Main Address PostCode
address.Country	Country	Main Address.Country
billingPhone	Billing Phone	Invoice Contact phone
billingContact	Billing Contact	Invoice Contact First name
billingAddress.address1	Billing Address	Invoice Address line 1
billingAddress.address.address2		Invoice Address.line 2
billingAddress.address.city	Billing City	Invoice Address Town
billingAddress.address.state	Billing County	Invoice Address County
billingAddress.address.zip	Billing Post Code	Invoice Address PostCode
customText1	Accounts Ref	Accounts Ref
customText2	Company Number	Company Number
customText3	VAT Reg No	Company Sales Tax Number
customText4	VAT Code	VAT Code
customText5	Invoice Email	Invoice Email Address (Invoices sent by email if populated)
customText6	Umbrella Bank Account Name	Bank Account Name
customText7	Umbrella Bank Account Number	Bank Account Number
customText8	Umbrella Sort Code	Bank Account Sort Code
customText9	Umbrella Self Billing	Provider is Self Billing
customText10	Currency	Default Currency
customText11	Invoice Consolidation	Invoice Consolidation
customText12	Terms Type	Invoicing Terms Type
customFloat1	Terms Days	Invoicing Terms Days