---
title: "transaction_columns (openspending.nl)"
description: "Transaction Columns"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/openspendingnl/OpenSpendingNl.OpenSpendingNl.transaction_columns
original: https://documentation.invantive.eu/en/datamodels/openspendingnl/OpenSpendingNl.OpenSpendingNl.transaction_columns
updated: 2026-11-01T16:21:14Z
license: https://documentation.invantive.eu/en/
---

# transaction_columns: openspending.nl Transaction Columns

`read only` `REST`

- Catalog: `OpenSpendingNl`
- Schema: `OpenSpendingNl`
- Primary Keys: `id`
- Label: Transaction Columns

Can only retrieve data.

## API Source

- Endpoint: `/transactions/columns/?limit=1000`

## Table Columns

The columns of the table `transaction_columns` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `created_at` | `datetime` | itgen_osnl_created_at | [ ] | filters on the platform, writable |  |
| `document_byline` | `varchar2` | itgen_osnl_document_byline | [ ] | filters on the platform, writable, `document.byline` |  |
| `document_created_at` | `datetime` | itgen_osnl_document_created_at | [ ] | filters on the platform, writable, `document.created_at` |  |
| `document_doc_type` | `varchar2` | itgen_osnl_document_doc_type | [ ] | filters on the platform, writable, `document.doc_type` |  |
| `document_document` | `varchar2` | itgen_osnl_document_document | [ ] | filters on the platform, writable, `document.document` |  |
| `document_government_aggregation` | `varchar2` | itgen_osnl_document_government_aggregation | [ ] | filters on the platform, writable, `document.government.aggregation` |  |
| `document_government_code` | `varchar2` | itgen_osnl_document_government_code | [ ] | filters on the platform, writable, `document.government.code` |  |
| `document_government_country` | `varchar2` | itgen_osnl_document_government_country | [ ] | filters on the platform, writable, `document.government.country` |  |
| `document_government_created_at` | `datetime` | itgen_osnl_document_government_created_at | [ ] | filters on the platform, writable, `document.government.created_at` |  |
| `document_government_display_kind` | `varchar2` | itgen_osnl_document_government_display_kind | [ ] | filters on the platform, writable, `document.government.display_kind` |  |
| `document_government_id` | `int32` | itgen_osnl_document_government_id | [ ] | filters on the platform, writable, `document.government.id` |  |
| `document_government_intro` | `varchar2` | itgen_osnl_document_government_intro | [ ] | filters on the platform, writable, `document.government.intro` |  |
| `document_government_kind` | `varchar2` | itgen_osnl_document_government_kind | [ ] | filters on the platform, writable, `document.government.kind` |  |
| `document_government_latitude` | `double` | itgen_osnl_document_government_latitude | [ ] | filters on the platform, writable, `document.government.lat` |  |
| `document_government_location` | `varchar2` | itgen_osnl_document_government_location | [ ] | filters on the platform, writable, `document.government.location` |  |
| `document_government_longitude` | `double` | itgen_osnl_document_government_longitude | [ ] | filters on the platform, writable, `document.government.lon` |  |
| `document_government_metrics` | `varchar2` | itgen_osnl_document_government_metrics | [ ] | filters on the platform, writable, `document.government.metrics` |  |
| `document_government_name` | `varchar2` | itgen_osnl_document_government_name | [ ] | filters on the platform, writable, `document.government.name` |  |
| `document_government_resource_uri` | `varchar2` | itgen_osnl_document_government_resource_uri | [ ] | filters on the platform, writable, `document.government.resource_uri` |  |
| `document_government_slug` | `varchar2` | itgen_osnl_document_government_slug | [ ] | filters on the platform, writable, `document.government.slug` |  |
| `document_government_state` | `varchar2` | itgen_osnl_document_government_state | [ ] | filters on the platform, writable, `document.government.state` |  |
| `document_government_updated_at` | `varchar2` | itgen_osnl_document_government_updated_at | [ ] | filters on the platform, writable, `document.government.updated_at` |  |
| `document_government_website` | `varchar2` | itgen_osnl_document_government_website | [ ] | filters on the platform, writable, `document.government.website` |  |
| `document_id` | `int32` | itgen_osnl_document_id | [ ] | filters on the platform, writable, `document.id` |  |
| `document_index_name` | `varchar2` | itgen_osnl_document_index_name | [ ] | filters on the platform, writable, `document.index_name` |  |
| `document_kind` | `varchar2` | itgen_osnl_document_kind | [ ] | filters on the platform, writable, `document.kind` |  |
| `document_parsed_at` | `datetime` | itgen_osnl_document_parsed_at | [ ] | filters on the platform, writable, `document.parsed_at` |  |
| `document_resource_uri` | `varchar2` | itgen_osnl_document_resource_uri | [ ] | filters on the platform, writable, `document.resource_uri` |  |
| `document_title` | `varchar2` | itgen_osnl_document_title | [ ] | filters on the platform, writable, `document.title` |  |
| `document_updated_at` | `datetime` | itgen_osnl_document_updated_at | [ ] | filters on the platform, writable, `document.updated_at` |  |
| `document_year` | `varchar2` | itgen_osnl_document_year | [ ] | filters on the platform, writable, `document.year` |  |
| `id` | `int32` | itgen_osnl_id | [ ] | filters on the platform, writable |  |
| `key` | `varchar2` | itgen_osnl_key | [ ] | filters on the platform, writable |  |
| `label` | `varchar2` | itgen_osnl_label | [ ] | filters on the platform, writable |  |
| `resource_uri` | `varchar2` | itgen_osnl_resource_uri | [ ] | filters on the platform, writable |  |
| `updated_at` | `datetime` | itgen_osnl_updated_at | [ ] | filters on the platform, writable |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [OpenSpending](/en/release-notes/drivers?driver=openspending)

