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 | |
| award_id | AWD-000001 | |
| budget_date | 2025-04-05 00:00:00 | |
| company | UWMSN | |
| cost_center_id | CC123456 | |
| 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 | |
| fund_id | FD0001 | |
| gift_id | GF000000001 | |
| grant_id | GR000000001 | |
| interworktag_affiliate | FD0001 Balancing Fund | |
| journal_entry_wid | fedcba9876543210abcdef0123456789 | |
| journal_line_number | 0 | |
| journal_line_wid | a1b2c3d4e5f678901234567890abcdef | |
| ledger_account | 6000:Travel | |
| location | Babcock – Madison | |
| memo | P-Card, itemized. | |
| object_class | Sponsored Programs: 2500 Domestic Travel | |
| program_id | PG000000001 | |
| project_id | PJ000000001 | |
| revenue_category_id | RC00001 | |
| spend_category_id | SC00001 | |
| 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 |