# creating-transaction-lists

> Claude/Codex skill by [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars · Updated 2026-10-23

Execution skill. Use when creating a transaction list, and whenever you aggregate rows from a transaction list into a metric — including a list that already exists in the application.

## Install

```sh
git clone https://github.com/gopigment/ai-plugins /tmp/ai-plugins && ln -s /tmp/ai-plugins/skills/creating-transaction-lists ~/.claude/skills/creating-transaction-lists
```

## From README

Creating Transaction Lists Recognize What a Transaction List Is A transaction list stores high-volume, row-based event data. Each row is one transaction or event. Items do not need to be unique (many rows can share the same product or date). Pigment auto-generates unique row IDs — source data does not need one. Represents granular events: orders, GL entries, bookings, movements, invoices. Cannot be used in a metric's structure — only referenced in formulas. Transaction lists hold transactional data; dimension lists hold metadata (products, accounts, employees). For deciding whether data belongs in a metric or a transaction list, see skill:creating-metrics-and-tables. Aggregate Transaction Lists into Metrics Transaction list data reaches metrics through aggregation: Date properties must map to calendar dimensions through a stored property, never through an inline conversion.

## Links

- HTML page: https://omgskills.com/library/gopigment/ai-plugins/skills/creating-transaction-lists/
- GitHub: https://github.com/gopigment/ai-plugins
- Author: [@gopigment](https://omgskills.com/library/gopigment/index.md)

## More from this repo

- [aggregating-view-data](https://omgskills.com/library/gopigment/ai-plugins/skills/aggregating-view-data/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [architecting-multi-application-solutions](https://omgskills.com/library/gopigment/ai-plugins/skills/architecting-multi-application-solutions/index.md) — Planning skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars
- [auditing-a-pigment-application](https://omgskills.com/library/gopigment/ai-plugins/skills/auditing-a-pigment-application/index.md) — Execution skill.
   - [@gopigment](https://omgskills.com/library/gopigment/index.md) · 23 stars