The procedure to generate payment card export files is as follows:
2. The content of the file is summarised in the table below
2. For each associated account, the Generated By and Date Generated payment card fields are automatically populated with the name of the end user generating the export file and current system date respectively. Field |
Description |
Organisation Name |
The name of the housing organisation. |
Company |
The company linked to each payment card account. |
Account Reference |
The unique reference number for the account. |
Payment Reference |
The unique reference number assigned to the payment card. |
Account Type |
The categorisation of the account e.g. Rental, Residential, Non Residential, Sundry, Licence, etc. |
Head of Group Title & First Name |
The title and forename of the contact identified as head of the group for the account. |
Head of Group Surname |
The surname of the contact identified as head of the group for the account. |
Contact group names |
A list of all members in the group. |
Asset Address |
The full postal address of the associated asset. |
Asset Number Or Name |
The BS7666 dwelling field of the asset address. |
Asset Street |
The BS7666 street field of the asset address. |
Asset Locality |
The BS7666 locality field of the asset address. |
Asset Town |
The BS7666 town field of the asset address. |
Asset County |
The BS7666 county field of the asset address. |
Asset Post Code |
The post code of the asset. |
Contact Group Address |
The full postal address of the contact group. |
Contact Group Address Number or Name |
The BS7666 dwelling field of the contact group address. |
Contact Address Group Street |
The BS7666 street field of the contact group address. |
Contact Group Address Locality |
The BS7666 locality field of the contact group address. |
Contact Group Address Town |
The BS7666 town field of the contact group address. |
Contact Group Address County |
The BS7666 county field of the contact group address. |
Contact Group Address PostCode |
The post code of the contact group address. |
Note
1 The date format is YYYYMMDD; the time format is HH:MM:SS.
2 The standard file format is CSV (Comma Separated Variable).
See related topics...