﻿_id	Field Name	Field Type	Description	Notes
1	Account ID	Varchar(10)	Account code; 6 digits	Reference to classification of expense or revenue transaction
2	Account Name	Varchar(50)	Account description	Reference to classification of expense or revenue transaction
3	Agency ID	Varchar(5)	Agency code, 5 digit number	Ex. 00060; Business Unit represents an agency (see Agency Name note)
4	Agency Name	Varchar(40)	Name of agency	References a state agency under the Executive branch, a separately elected official, or the divisions within the Legislative and Judicial branches of government.  Agency may references a subdivision of an agency; Ex. Department of Corrections has several facilities that are classified in the state's accounting system as an agency.  
5	Amount	Decimal(28,3)	Line Amount	""
6	Fiscal Year	Varchar(4)	Fiscal year of transaction	The state operates on a fiscal year beginning July 1 and ending June 30
7	Function of Government	Varchar(70)	Function of government	The State of Indiana functions of government include Education, Health and Human Services, Public Safety, General Government, Construction, Economic Development, Conservation and Environment, Distributions, and Transportations
8	Fund ID	Varchar(5)	Fund code, 5 digit number	Ex. 71660; References operating funds under a legal fund
9	Fund Name	Varchar(40)	Fund description	Ex. IND OFC OF TECHNOLOGY; References operating funds under legal fund
10	Funding Source	Varchar(70)	Funding source description	Ex. General Fund (G), Federal Fund (F); Source of funding
11	Journal Agency ID	Varchar(5)	Agency code, 5 digit number	Refers to the agency reporting the ledger entry.  Ex. 00060; Business Unit represents an agency (see Agency note)
12	Journal Date	Date	Date the transaction posted to the ledger	""
13	Journal ID	Varchar(10)	Reference number to ledger transaction	""
14	Last Updated	TIMESTAMP	Date of latest data extraction from source data	""
15	Legal Fund ID	Varchar(20)	Legal Fund Code; 4 digits	Ex. 1000; References money set aside for a particular purpose
16	Legal Fund Name	Varchar(70)	Legal Fund Description	Ex. General Fund, State Highway Fund; References money set aside for a particular purpose
17	Revenue Category	Varchar(71)	Classification of revenue by source	Ex. Sales & Rental Revenue and Grant Revenue
18	Source	Varchar(25)	Data location	Ex. PeopleSoft Financials, the state's financial operating system; PeopleSoft HR, the state's human resource operating system; HEA 1001, the Budget Bill, or other sources. 
19	Vendor ID	Varchar(10)	Vendor's identification number	""
20	Vendor Name	Varchar(50)	Name of vendor	"Expenditures to state vendors will reference the vendor name.  All other general ledger transactions will reference the journal type.  

General Ledger Transaction - Adjustments, Allocations, or Transfers within the General Ledger
Agency Payments - Payments include Department of Revenue Refunds, Welfare Recipients, and Child Support 
Accounts Receivable Transaction - Includes Accounts Receivable and direct cash deposit transactions
Employee Expense Transaction - Employee reimbursement
Payroll Transaction - Payroll expenditures "
