Section G - Import Fields Available (Allocations)

Modified on Wed, 22 Dec, 2021 at 9:43 AM

Vans (Van Allocations)

Full Description
Database Field
Data Type
Field Length
Inclusion
Pre-Format
Annual amount of cash foregone for Fuel (OpRA)
CASHFGFUEL

Numeric

10

Optional


Annual amount of cash foregone for the Van (OpRA)
CASHFGVAN

Numeric

10

Optional


Available from Date

FROM

Date

8

Compulsory

dd/mm/yyyy

Fuel cost repaid for personal mileage in full

FUELPAID

Character

3

Optional

Y

N

Fuel paid for by Employer

FUELSCALE

Character

3

Optional

Y

N

Made good value
MADEGOOD

Numeric

10

Not used


Mileage

MILEAGE

Numeric

10

Not used

 

Employee N I Number

NI_NUMBER

Character

10

Key field

 

Payroll Number

PAYROLL

Character

20

Key field

 

Payrolled valuePAYROLLEDNumeric
10Optional

Restricted Private Use

RESTRICTED

Character

3

Optional

 

Registration Number

R_NUMBER

Character

10

Key field

 

Shared Discount

SHAREDDISC

Numeric

10

Optional

 

Shared use
SHAREDUSE

Character

3

Optional


Available to Date

TO

Date

8

Compulsory

dd/mm/yyyy

Days Unavailable

UNAVAILBLE

Numeric

3

Optional

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article