﻿_id	FIELD_NAME	FIELD_TYPE	DESCRIPTION	NOTES
1	Agency ID	VARCHAR(5)	Agency code, 5 digit number	Ex. 00060; Business Unit represents an agency (see Agency Name note)
2	Agency Name	VARCHAR(5000)	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.  
3	Ledger	VARCHAR(5000)	Ledger	References the state's General Ledger.
4	Fiscal Year	DECIMAL(28,0)	Fiscal Year of Transaction	The state operates on a fiscal year beginning July 1 and ending June 30.
5	Accounting Period	DECIMAL(28,0)	Accounting Period/Fiscal Year Period	"References the fiscal year period to which the balance belongs.
0 = Beginning Balance Period
1 = July
2 = August
3 = September
4 = October
5 = November
6 = December
7 = January
8 = February
9 = March
10 = April
11 = May
12 = June"
6	Account ID	VARCHAR(10)	Account code; 6 digits	Reference to classification of cash transactions
7	Account Name	VARCHAR(5000)	Account description	Reference to classification of cash transactions
8	Fund ID	VARCHAR(5)	Fund code, 5 digit number	Ex. 46710; References operating funds under a legal fund
9	Fund Name	VARCHAR(5000)	Fund description	Ex. Access Indiana; References operating funds under legal fund
10	CF_ATTRIBUTE	VARCHAR(15)	Charterfield Attribute Number	Ex. Legal_Fund; Identifies the legal fund associated with the operating fund
11	Legal Fund ID	VARCHAR(5000)	Legal Fund code; 4 digits	Ex. 1000; References money set aside for a particular purpose
12	Legal Fund Name	VARCHAR(60)	Legal Fund description	Ex. General Fund, State Highway Fund; References money set aside for a particular purpose
13	MTD Amount	DECIMAL(28,7)	Month to date accumulated Amount	""
14	YTD Amount	DECIMAL(28,7)	Fiscal Year to date accumulated Amount	""
15	Balance Date	TIMESTAMP	Date of latest period balance	""
