August 2021 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 STATUS | text | ||
| SPLIT Y/N | text | ||
| LINE ITEM Y/N | text | ||
| TRANS REFERENCE | numeric | ||
| BILLING GROSS AMT | numeric | ||
| QUOTED STRING | text | ||
| TRANS COMMENT | text | ||
| TAX ERROR NO | numeric | ||
| TAX EVIDENCE Y/N | text | ||
| TRANS TAX RATE | numeric | ||
| TRANS TAX AMT | numeric | ||
| TRANS POST DATE | timestamp | ||
| TRANS ORIGINAL NET AMT | numeric | ||
| TRANS DISCOUNT | text | ||
| DISPUTE Y/N | text | ||
| COUNTRY CODE | numeric | ||
| TRANS STATE | text | ||
| EXCHANGE RATE | numeric | ||
| DCAL TRANS CODE | numeric | ||
| NO OF MILES | text | ||
| TARGET COUNTRY | numeric | ||
| VAT/TAX | text | ||
| DOMESTIC PURCHASE Y/N | text | ||
| TRANS PERSONAL Y/N | text | ||
| TRANS CLIENT BILLABLE Y/N | text | ||
| RECEIPT CODE DESCRIPTION | text | ||
| TRANS EXPENSABLE Y/N | text | ||
| TRANS REIMBURSABLE 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 | ||
| TRANS CAC DESC 3 | text | ||
| Directorate | text | ||
| TRANS CAC CODE 4 | text | ||
| TRANS CAC DESC 4 | text | ||
| TRANS CAC CODE 5 | text | ||
| TRANS CAC DESC 5 | text | ||
| TRANS CAC CODE 6 | text | ||
| TRANS CAC DESC 6 | text | ||
| TRANS CAC CODE 7 | text | ||
| TRANS CAC DESC 7 | text | ||
| TRANS CAC CODE 8 | text | ||
| TRANS CAC DESC 8 | text | ||
| TRANS CAC CODE 9 | text | ||
| TRANS CAC DESC 9 | text | ||
| TRANS CAC CODE 10 | text | ||
| TRANS CAC DESC 10 | text | ||
| TRANS CAC CODE 11 | text | ||
| TRANS CAC DESC 11 | text | ||
| TRANS CAC CODE 12 | text | ||
| TRANS CAC DESC 12 | text | ||
| TRANS ACCOUNT KEY | text | ||
| TRANS ACCOUNT KEY DESC | text | ||
| CLAIM NO | text | ||
| CLAIM NAME | text | ||
| TRANS EXPENSE CATEGORY | text | ||
| SPLIT EXPENSE CATEGORY | text | ||
| Split Unit Cost | text | ||
| Split Quantity | text |
Additional Information
| Field | Value |
|---|---|
| Data last updated | October 5, 2021 |
| Metadata last updated | October 5, 2021 |
| Created | October 5, 2021 |
| Format | XLS |
| License | UK Open Government Licence (OGL) |
| Datastore active | True |
| Has views | True |
| Id | 5073639e-1c5c-48d3-b19f-b8453a6c1bbd |
| On same domain | True |
| Package id | 09d22f5b-8630-438b-b178-1062b0b751f5 |
| State | active |
| Url type | upload |