...
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 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 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. |
Umbrella Company Address Line 1 | Displays Address Line 1 of the payee's company address. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Address Line 2 | Displays Address Line 2 of the payee's company address. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Address Line 3 | Displays Address Line 3 of the payee's company address. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company City | Displays the city of the payee's company address. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Contact Email | Displays the umbrella company's contact email. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Contact Name | Displays the umbrella company's contact name. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Contact Phone Number | Displays the umbrella company's contract phone number. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company Country | Displays the umbrella company's country. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
Umbrella Company | Displays the umbrella company's business name. Applies to payees who are umbrella workers (tax type of Contractor and payee type Umbrella). |
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. |
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 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 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. |
...