General Payslip Fields

Database Field

Description

Current Gross

Displays the total gross amount earned by the payee in the pay batch in which the payslip was generated.

Current Gross Plus VAT

Displays the total gross amount plus VAT including VAT adjustments applied to the payee in the pay batch in which the payslip was generated.

Current Gross Deductions

Displays the total amount of deductions deducted from the payee's gross earnings in the pay batch in which the payslip was generated.

Current Net

Displays the total net amount earned by the payee in the pay batch in which the payslip was generated.

Current Net Deductions

Displays the total amount of deductions deducted from the payee's net earnings in the pay period to which the payslip corresponds.

Current Net Plus VAT

Displays the total net amount plus total VAT including VAT adjustments paid to the payee in the pay batch in which the payslip was generated.

Current Non Taxable Allowances

Displays the total amount of non-taxable allowances paid to the payee in the pay batch in which the payslip was generated.

Current Postgraduate Loan

Displays the current postgraduate loan deduction deducted from the payee in the pay batch in which the payslip was generated (Available from version 11.43)

Current Reimbursement

Displays the total amount of reimbursements paid to the payee in the pay batch in which the payslip was generated.

Current Taxable Allowances

Displays the total amount of taxable allowances paid to the payee in the pay batch in which the payslip was generated.

Current Taxable Income

Displays the total amount of taxable income paid to the payee in the pay batch in which the payslip was generated.

Current Total Allowances

Displays the total amount of taxable and non-taxable allowances paid to the payee in the pay batch in which the payslip was generated.

Current Total Deductions

Displays the total of all gross and net deductions deducted from the payee's earnings in the pay batch in which the payslip was generated.

Current Total Tax

Displays the total amount of tax withheld and deducted from the payee's earnings in the pay batch in which the payslip was generated.

Current VAT

Displays the total amount of VAT paid including VAT Adjustment to the payee in the pay batch in which the payslip was generated.

Current VAT Adjustment

Displays the VAT adjustment value made to the payee in the pay batch in which the payslip was generated.

Current VAT Adjustment Description

Displays the reason for the adjustment to VAT.

Current VAT Adjustment Type

Displays the type of adjustment: if the VAT adjustment is negative, the adjustment type is Credit Note. If the adjustment value is positive it will display Invoice. This should only be used if the adjustment is separated onto a separate payslip.

Current VAT Exc Adjustment

Displays the VAT total excluding the VAT Adjustment applied to the payee in the pay batch in which the payslip was generated.

Employee National Insurance Contribution

Displays the employee National Insurance contribution deducted from the payee in the pay batch in which the payslip was generated.

Employer National Insurance Contribution

Displays the employer National Insurance contribution deducted from the payee in the pay batch in which the payslip was generated.

Enquiry Office Address Line 1

Displays the address line 1 of the enquiry office, to whom the payee is linked.

Enquiry Office Address Line 2

Displays the address line 2 of the enquiry office, to whom the payee is linked.

Enquiry Office City

Displays the city of the enquiry office, to whom the payee is linked.

Enquiry Office Code

Displays the office code of the enquiry office, to whom the payee is linked.

Enquiry Office Email

Displays the email of the enquiry office, to whom the payee is linked.

Enquiry Office Name

Displays the Enquiry office name of the enquiry office, to whom the payee is linked.

Enquiry Office Phone

Displays the phone number of the enquiry office, to whom the payee is linked.

Enquiry Office Postcode

Displays the post code of the enquiry office, to whom the payee is linked.

Enquiry Office State

Displays the state of the enquiry office, to whom the payee is linked.

Enquiry Office Suburb

Displays the suburb of the enquiry office, to whom the payee is linked.

Home Office

Displays the agency office by the candidate, to whom the payee is linked, is managed.

Is Tax Basis W1M1

Displays the tax basis of a payee's tax code.

NI Category

Displays the NI category used to calculate the payee's national insurance contribution in the pay batch in which the payslips was generated.

NIable Income

Displays the NIable income of the payee in the pay batch in which the payslips was generated.

Page No

Displays the current page number on the payslip.

Partnership UTR Number

Displays the contractor's partnership unique tax reference (UTR) number.

Pay Batch Number

Displays the pay batch number that uniquely identifies the pay batch in which the payslip was generated.

Pay Company Accounts Office Reference Number

Displays the accounts office reference number of the pay company.

Pay Company Address 1

Displays Address Line 1 of the mailing address of the pay company that issues the payslip.

Pay Company Address 2

Displays Address Line 2 field of the mailing address of the pay company that issues the payslip.

Pay Company Address 3

Displays the suburb, state and postcode of the mailing address of the pay company that issues the payslip.

Pay Company Country

Displays the mailing address country of the pay company that issues the payslip.

Pay Company Email

Displays the email address of the pay company that issues the payslip.

Pay Company HMRC Office Number

Displays the Office Number of the pay company's HMRC PAYE Reference.

Pay Company Message

Displays the contents of the Payslip Message field on the Payslip Details tab of the Pay Company record of the pay company that issues the payslip.

Pay Company Name

Displays the name of the pay company that issues the payslip.

Pay Company PAYE Reference Number

Displays the PAYE Reference number of the pay company.

Pay Company Phone

Displays the telephone number of the pay company that issues the payslip.

Pay Company Post Code

Displays the postcode for the mailing address of the pay company that issues the payslip.

Pay Company State

Displays the state for the mailing address of the pay company that issues the payslip.

Pay Company Suburb

Displays the suburb for the mailing address of the pay company that issues the payslip.

Pay Company Trade Name

Displays the trading name of the pay company that issues the payslip.

Pay Company UTR Number

Displays the UTR Number of the pay company.

Pay Period End Date

Displays the pay period end date associated with the pay batch in which the payslip was generated.

Pay Period Start Date

Displays the pay period start date associated with the pay batch in which the payslip was generated.

Payee Address 1

Displays Address Line 1 of the payee's mailing address.

Payee Address 2

Displays Address Line 2 of the payee's mailing address.

Payee Business Name

Displays the Business Name/Trading Name of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Address Line 1

Displays Address Line 1 of the payee's company address.  Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Address Line 2

Displays Address Line 2 of the payee's company address. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Country

Displays the country in which the payee's company is located. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Name

Displays the name of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Post Code

Displays the postcode for the address of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company State

Displays the state for the address of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Suburb

Displays the suburb for the address of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Company Verification No.

Displays the payee's CIS verification number.

Payee Country

Displays the country for the address of the payee's company. Applies to payees who are independent contractors only (tax type of Contractor).

Payee Message

Displays the contents of the Payslip Message field on the Employment/Payslip Details tab of the Payee record.

Payee Name

Displays the payee first name and surname.

Payee Number

Displays the ID that uniquely identifies the payee.

Payee Post Code

Displays the postcode in which the payee's mailing address is located.

Payee State

Displays the state in which the payee's mailing address is located.

Payee Suburb

Displays the suburb in which the payee's mailing address is located.

Payment Date

Displays the payment date of the pay batch in which the payslip was generated.

Payslip Number

Displays the unique number of the payslip which is used for contractor self bill invoice where a unique reference number is required.

Student Loan

Displays the current student loan deducted from the payee in the pay batch for which the payslip was generated.

Tax Code

Displays the tax code used to calculate tax for the payee in the pay batch for which the payslip was generated.

Tax Code With Regime

Displays the tax code and the regime used to calculate tax for the payee in the pay batch for which the payslip was generated.

Tax Period

Displays the tax period with which the pay batch is associated with.

Tax Year

Displays the tax year with which the pay batch is associated with.

Supplier Company Address Line 1

Displays Address Line 1 of the payee's company address.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Address Line 2

Displays Address Line 2 of the payee's company address.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Address Line 3

Displays Address Line 3 of the payee's company address.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company City

Displays the city of the payee's company address.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Contact Email

Displays the Supplier company's contact email.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Contact Name

Displays the Supplier company's contact name.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Contact Phone Number

Displays the Supplier company's contract phone number.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company Country

Displays the Supplier company's country.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

Supplier Company

Displays the Supplier company's business name.  Applies to payees who are supplied workers (tax type of Contractor and payee type Umbrella or 3rd Tier Agency).

UTR Number

Displays the unique tax reference number. Applies to payees who have the tax type of Contractor.

VAT Registration Number

Displays the VAT registration number. Applies to payees who have the tax type of contractor and are VAT registered.

VAT Total

This value is used for Supplier based payslips to show the total VAT including VAT Adjustments for all payees within the payslip generated for the period.

YTD Benefit In Kind Amount

Displays the tax year to date value of benefit in kind pay codes calculated for the payee up to the tax period associated with the payslip.

YTD Employee National Insurance Contribution

Displays the tax year to date employee national insurance contribution deducted from the payee up to the tax period associated with the payslip.

YTD Employer National Insurance Contribution

Displays the tax year to date employer national insurance contribution determined up to the tax period associated with the payslip.

YTD Gross

Displays the tax year to date gross earnings paid to the payee up to the tax period associated with the payslip.

YTD Gross Deductions

Displays the tax year to date gross deductions deducted from the payee up to the tax period associated with the payslip.

YTD Net

Displays the tax year to date net paid to the payee up to the tax period associated with the payslip.

YTD Net Deductions

Displays the tax year to date net deductions deducted from the payee up to the tax period associated with the payslip.

YTD Net Plus VAT

Displays the tax year to date net plus VAT including VAT Adjustments paid to the payee up to the tax period associated with the payslip.

YTD NIable Earnings

Displays the tax year to date niable earnings calculated for the payee up to the tax period associated with the payslip.

YTD Non Taxable Allowances

Displays the tax year to date non taxable allowances paid to the payee up to the tax period associated with the payslip.

YTD Postgraduate Loan

Display the tax year to date Postgraduate loan deductions deducted from the payee up to the tax period associated with the payslip. (Available from version 11.43)

YTD Reimbursement

Displays the tax year to date reimbursements paid to the payee up to the tax period associated with the payslip.

YTD Student Loan

Displays the tax year to date student loan deducted from the payee up to the tax period associated with the payslip.

YTD Taxable Allowances

Displays the tax year to date taxable allowances paid to the payee up to the tax period associated with the payslip.

YTD Taxable Income

Displays the tax year to date taxable pay paid to the payee up to the tax period associated with the payslip.

YTD Total Allowances

Displays the tax year to date non taxable allowances plus taxable allowances paid to the payee up to the tax period associated with the payslip.

YTD Total Deductions

Displays the tax year to date gross and net deductions deducted from the payee up to the tax period associated with the payslip.

YTD Total Tax

Displays the tax year to date tax deducted from the payee up to the tax period associated with the payslip.

YTD VAT

Displays the tax year to date VAT plus VAT Adjustments paid to the payee up to the tax period associated with the payslip.

YTD VAT Adjustment

Display the VAT adjustment year to date paid to the payee up to the tax period associated with the payslip.

Business Type

Displays the contractor's company business type.

Candidate Number

Displays system-generated ID that uniquely identifies the candidate to which a payee is linked.

Company Registration Number

Displays the contractor's company registration number.

Current Benefit in Kind

Displays the payee's total value of pay codes that has the type of Benefit in Kind for the pay batch.

Current CIS Materials

Displays the total reimbursement value where the reimbursement pay code is flagged as 'Materials'

Current Date

Displays the date on which the payslips was generated.

Current Date Time

Displays the date and time at which the payslip was generated.

Payee Details

Payslip Header

Payee Payment Currency

Exchange Rate

Exchange Rate Effective Date

Current Net Amount Currency

Current Net Plus VAT Amount Currency

The payee's currency used to convert the net pay in the pay batch.

The exchange rate used in the pay batch.

The effective date of the exchange rate used in the pay batch.

The converted net pay amount.

The net play plus the VAT amount including VAT Adjustments currency conversion.

Payment Details

BIC

IBAN

Amount in Payment Currency

Net Pay

Exchange Rate

Exchange Rate Effective Date

Payee Currency Code

Currency Net Amount Currency

Current Net Plus VAT Amount Currency

The exchange rate used in the pay batch.

The effective date of the exchange rate used in the pay batch.

The payee's currency used to convert the net pay in the pay batch.

The converted net pay amount.

The net play plus the VAT including VAT adjustments amount currency conversion.