Column keywords for Bulk Invoice CSV Load.

Column level keywords define the column usage for each data row and can only follow the keyword <DEFN>. Each column keyword must only occur once, if present.

Note: You only need to enter either the <EMPID>, <OTHERID> or <NINO> column keywords. Only one of these keywords is required to identify the off-payroll worker.

Column Keywords Description

<EMPID>

The employee number, to which subsequent data in the spreadsheet row applies.

Must be a valid employee number.

It can appear in any column of the definition row, but it is recommended it appears in the first column for spreadsheet clarity.

Optional.

<OTHERID>

Other identifier. Could be a vendor ID, for example.

Must be a valid other ID.

Optional.

<NINO>

National Insurance number.

Must be a valid NI number.

Alpha numeric format.

Optional.

<INVOICENO>

Invoice number.

Alpha numeric format.

Mandatory.

<INVOICEDATE>

Invoice date.

Format DD/MM/YYYY.

Mandatory.

<PEID>

Pay element ID.

Must exist in the OFFPAY pay element category.

Mandatory.

<GROSSAMT>

Gross amount.

Format <9999999.99>.

Mandatory.

<VATAMT>

Value added tax (VAT) amount.

Format <9999999.99>.

Optional.