February 2020 Purchase Card Transactions
Under the Code of Recommended Practice for Local Authorities on Data Transparency, councils are encouraged to publish all corporate purchase card transactions.
We already publish details of all our relevant expenditure of more than £500 within our Payments to Suppliers page, and will continue to do so. However, in the spirit of the Code, the Council started publishing all purchase card transactions, regardless of value, from the April 2014 card statement. The information will be published monthly.
As with our payments to suppliers, we aim to be as transparent as we can, but in some cases we will need to respect information that could be seen as commercially sensitive or where the payment relates to vulnerable young people or adults. In these cases information is withheld as it is personal data. For further information about personal data, please see birmingham.gov.uk/foi.
If you require further information about any of the payments, please contact foi.mailbox@birmingham.gov.uk setting out the details of the payment and what additional information you require. Such request will be handled under the Freedom of Information Act 2000, and the Council aims to be able to provide a response to your query within 20 working days.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| TRANS DATE | timestamp | ||
| TRANS TAX DESC | text | ||
| ORIGINAL GROSS AMT | numeric | ||
| ORIGINAL CUR | text | ||
| TRANS REFERENCE | numeric | ||
| BILLING GROSS AMT | numeric | ||
| QUOTED STRING | text | ||
| TAX EVIDENCE Y/N | text | ||
| TRANS TAX RATE | numeric | ||
| TRANS TAX AMT | numeric | ||
| TRANS POST DATE | timestamp | ||
| TRANS ORIGINAL NET AMT | numeric | ||
| TRANS DISCOUNT | numeric | ||
| VAT/TAX | text | ||
| DOMESTIC PURCHASE Y/N | text | ||
| MERCHANT NAME | text | ||
| MERCHANT TAX REG NO | text | ||
| MCC CODE | numeric | ||
| FIRST NAME | text | ||
| SURNAME | text | ||
| CARD NUMBER | text | ||
| BILLING CUR CODE | text | ||
| TRANS CAC CODE 1 | text | ||
| TRANS CAC DESC 1 | text | ||
| TRANS CAC CODE 2 | text | ||
| TRANS CAC DESC 2 | text | ||
| TRANS CAC CODE 3 | text | ||
| Directorate | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | April 22, 2020 |
| Metadata last updated | April 22, 2020 |
| Created | April 22, 2020 |
| Format | XLS |
| License | UK Open Government Licence (OGL) |
| Datastore active | True |
| Has views | True |
| Id | e5b82004-5665-41f7-9bc6-07a4f1128ac7 |
| On same domain | True |
| Package id | 7ad90c2a-cd7b-4d9b-8ef0-12e50ace4ff9 |
| State | active |
| Url type | upload |