Data from the journal entries endpoint is returned in CSV format. Below is a list of columns in the file, along with examples.
Column | Example | Notes |
---|---|---|
accounting_date | 2024-12-01 00:00:00 | |
company | UWMSN | |
created_on | 2025-03-28 00:00:00 | |
journal_number | JRN0000001745 | |
journal_source | General Ledger Conversion | |
journal_status | Posted | |
ledger | Actuals | |
ledger_period | 2025-12-01 00:00:00 | |
operational_transaction | Award Revenue Recognition: UWMSN University of Wisconsin Madison on 12/31/2024 | |
originated_by | Bucky Badger | |
journal_line | a1b2c3d4e5f678901234567890abcdef | |
last_updated_ts | ||
award | AWD-000001: Ice Drilling Program | |
cost_center | CC000001 UWEAU | CHAN | Chancellor | |
credit_amount | 123.45 | |
debit_amount | 123.45 | |
function | FN0000 Student Services | |
fund | FD0001 Balancing Fund | |
gift | GF000000001 UWRVF | SASE | Admissions Foundation Gifts | |
grant | GR000000001 UWRVF | Peer Mentor Program – Fund for Wisconsin Scholars (FFWS) | |
interworktag_affiliate | FD0001 Balancing Fund | |
ledger_account | 6000:Travel | |
program | PG000000001 UWRVF | FINC | Accounting Services | |
project | PJ000000001 UWLAC | SOE | FY20 Startup | |
revenue_category | RC00037 – Federal Grants & Contracts (Sponsored Research) | |
spend_category | SC00130 – Equipment – Computer | |
supplier_as_worktag | STAPLES INC | |
transaction_date | 2025-01-01 08:00:00 |