Section C - Vouchers and credit cards
Importing benefit information is usually 'additive' (ie, you update what is already there). It is important to remember that if you have 'blank' columns, the system will map the column and overwrite existing data with 'blank' data if it can. Although this is useful for removing content, we would advise not having banks columns unless it is intentional.
If you are importing based on payroll number of NI number, those fields are mandatory and can't be ignored.
Full Description | Database Field | Data Type | Field Length | Inclusion | Pre-Format |
---|---|---|---|---|---|
Value Of Benefit | CASHEQV | Numeric | 10 | Compulsory |
|
Annual amount of cash foregone (OpRA) | CASHFGONE | Numeric | 10 | Optional | |
Benefit Date | DATE | Date | 8 | Optional | dd/mm/yyyy |
Description of Benefit | DESCRIPTIO | Character | 50 | Compulsory |
|
Amount Made Good | MADEGOOD | Numeric | 10 | Optional |
|
NI Number | NI_NUMBER | Character | 10 | Key field |
|
Additional description | NOTES | Character | 50 | Optional |
|
Payroll Number | PAYROLL | Character | 20 | Key field |
|
Payrolled benefit | PAYROLLED | Numeric | 10 | Optional |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article