Trade creditors standing data
Requirements
- Data should only be submitted via the Data File Upload (DFU) facility. This is now the only acceptable method to supply data. If another submission method is used our policy is to inform the Director of Finance that data has been put at risk unnecessarily.
- Standing data should be current at the date of extraction and should exclude dormant or suspended creditors.
| Field name | Data format | Comments |
| Creditor reference | Character | This is the unique identifier for an individual creditor. This can be in the form of a numeric or alpha numeric string. |
| Site ID | Character | If Creditors can have more than one address these should be separately identifiable via this Site ID1 |
| Creditor name | Character | |
| Address 1 | Character | If the address is held in a single field, use the Address 1 field. |
| Address 2 | Character | |
| Address 3 | Character | |
| Address 4 | Character | |
| Postcode | Character | |
| Telephone number | Character | This may or may not have the area/STD code. It should be output as a character field so the leading zeros are not lost. |
| VAT registration number | Character | |
| Bank sort code | Character | 6 numeric characters in groups of 2 which may be separated by hyphens, e.g., 20-45-23. |
| Bank account number | Character | Usually 8 numeric characters. |
| Building Society Roll number or reference | Character | Building societies have a roll number or reference which indicates the individual account where payments are disbursed to after being paid into a single holding account. This should be blank for normal bank accounts. |
| Creditor type2 | Character | For example, ’0 = trade creditor, 1 = benefits, 2 = payroll, 3 = factor, 4 = grants, 5 = temporary/one-off, etc. Then provide a key to the codes used. If this type of identifier is not available from the system it would be to your advantage to populate this field to enable you to filter the output more easily and focus resources on what you may deem to be the most worthwhile matches. |
1 – If a Site ID is provided in the standing data file, it should also be included on the payments history file so that there is a unique linking field between the two datasets. This will make it possible to establish cumulative payments to individual trade creditor sites (which are attached to the standing data) and to attach the trade creditor names to each transaction on the payments history file.
2 – This field only needs to be populated if you are unable to submit trade creditors data on its own.
Downloads
2012/13 NFI trade creditors standing data detailed data specification