Data from the journal entry lines endpoint is returned in CSV format. Below is a list of columns in the file, along with examples.
| Column | Example | Notes |
|---|---|---|
| activity_id | AC001234 | |
| activity_name | COUN 410 Introduction to Counseling | |
| award_id | AWD-000001 | |
| award_name | FUND FOR WI SCHOLARS | |
| budget_date | 2025-04-05 00:00:00 | |
| company | UWMSN | |
| cost_center_id | ||
| cost_center_name | UWEAU | CHAN | Chancellor | |
| credit_amount | 123.45 | |
| customer_name | University of Minnesota | |
| customer_id | ARMSNAR-0000672 | Different campuses have different formats |
| debit_amount | 123.45 | |
| external_reference_id | 123456789 | Usually an ID from an external or third party system – format varies |
| function_id | FN0001 | |
| function_name | Institutional Support | |
| fund_id | FD0001 | |
| fund_name | Balancing Fund | |
| gift_id | GF000000001 | |
| gift_name | UWRVF | SASE | Admissions Foundation Gifts | |
| grant_id | GR000000001 | |
| grant_name | UWSTO | Wisconsin Economic Development Corporation Partnership Agreement | |
| interworktag_affiliate | FD0001 Balancing Fund | |
| interworktag_affiliate_id | FD0001 | |
| interworktag_affiliate_name | Balancing Fund | |
| journal_entry_wid | fedcba9876543210abcdef0123456789 | |
| journal_line_number | 0 | |
| journal_line_wid | a1b2c3d4e5f678901234567890abcdef | |
| ledger_account | 6000:Travel | |
| ledger_account_id | 6000 | |
| ledger_account_name | Travel | |
| location | Babcock – Madison | |
| memo | P-Card, itemized. | |
| object_class | Sponsored Programs: 2500 Domestic Travel | |
| program_id | PG000000001 | |
| program_name | UWRVF | FINC | Accounting Services | |
| project_id | PJ000000001 | |
| project_name | UWSYS | CAP | T-18-001 Upham Woods Visitor Center | |
| revenue_category_id | RC00001 | |
| revenue_category_name | MSEP Undergrad – Summer | |
| spend_category_id | SC00001 | |
| spend_category_name | Conversion – Outstanding Checks | |
| supplier_name | YALE UNIVERSITY | |
| supplier_id | 12345678 | |
| tax_applicability | Taxable | |
| tax_rate | WI Eau Claire County Sales Tax: Wisconsin Department of Revenue (0.5%) | |
| transaction_date | 2025-04-05 00:00:00 |