This dataset has the following 47 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
UniqueId | uniqueid | text | 15492-472387-1136-382-382-49716 18108-553271-4962-238-238-60151 18098-552591-3938-323-323-60196 22573-684059-5156-559-559-73636 22272-662395-1898-1164-1164-71898 view top 100 |
Entity | entity | text | City view top 100 |
CharacterCode | charactercode | text | 80 81 22 26 82 view top 100 |
CharacterCodeDescription | charactercodedescription | text | Purchased Services Materials & Supplies Salaries & Benefits Other Current Liab. Other Operating Exp view top 100 |
ObjectCode | objectcode | text | 523012 523045 523027 521064 531054 view top 100 |
Object | object | text | Electric Services Water Services R&M Landscape Other Prof & Tech Services Repair Supplies view top 100 |
OrganizationCode | organizationcode | text | 604 1013131 210 101 8106712 view top 100 |
Organization | organization | text | Buildings and Grounds Parks & Parkways State Gas Tax General Fund IWA Production view top 100 |
ProjectCode | projectcode | text | view top 100 |
Project | project | text | UNKNOWN view top 100 |
FullAccount | fullaccount | text | 210-00-00-0000-000-523012- 101-50-31-3131-000-523045- 604-00-00-0000-000-523045- 101-50-31-3131-000-523027- 604-00-00-0000-000-531054- view top 100 |
FundCode | fundcode | text | 101 604 810 240 210 view top 100 |
Fund | fund | text | General Fund Buildings and Grounds Indio Water Authority -Ops Landscape Maint. Districts State Gas Tax view top 100 |
Segment2Code | segment2code | text | 00 50 20 10 40 view top 100 |
Segment2 | segment2 | text | Undefined Recreation & Culture Public Safety General Government Highways & Streets view top 100 |
Segment3Code | segment3code | text | 00 31 42 11 21 view top 100 |
Segment3 | segment3 | text | Undefined Public Works Police Department Administration Community Development view top 100 |
Segment4Code | segment4code | text | 0000 3131 6712 4211 6713 view top 100 |
Segment4 | segment4 | text | Undefined Parks & Parkways Water Production Police Administration Water Transmission Distrib view top 100 |
Segment5Code | segment5code | text | 000 view top 100 |
Segment5 | segment5 | text | Undefined view top 100 |
Segment6Code | segment6code | text | -1 view top 100 |
Segment6 | segment6 | text | UNKNOWN view top 100 |
Segment7Code | segment7code | text | -1 view top 100 |
Segment7 | segment7 | text | UNKNOWN view top 100 |
Segment8Code | segment8code | text | -1 view top 100 |
Segment8 | segment8 | text | UNKNOWN view top 100 |
AccountType | accounttype | text | Expense Balance Sheet Revenue view top 100 |
AccountStatus | accountstatus | text | Active view top 100 |
FiscalYear | fiscalyear | number | 2023 2022 2021 2024 view top 100 |
FiscalPeriod | fiscalperiod | number | 12 9 3 7 4 view top 100 |
Date | date | calendar_date | 2022-06-30T00:00:00.000 2021-06-30T00:00:00.000 2023-06-30T00:00:00.000 2023-02-09T00:00:00.000 2023-06-15T00:00:00.000 view top 100 |
VendorId | vendorid | text | 403 564 4470 101 4897 view top 100 |
InvoiceId | invoiceid | text | 7427 10417 78553 73661 71865 view top 100 |
Description | description | text | LANDSCAPE MAINTENANCE SERVICES ELECTRIC SVCS WATER SVCS CREDIT WATER REFUND TREE MAINTENANCE view top 100 |
EntryType | entrytype | text | D C view top 100 |
VendorName | vendorname | text | IMPERIAL IRRIGATION DISTRICT INDIO WATER AUTHORITY EXCEL LANDSCAPE, INC. HOME DEPOT CREDIT SERVICES PRUDENTIAL OVERALL SUPPLY view top 100 |
InvoiceStatus | invoicestatus | text | Paid Void Approved view top 100 |
PaymentCheckNumber | paymentchecknumber | text | 0 236200 232584 225004 230748 view top 100 |
Actual | actual | number | 100.00 150.00 200.00 12.34 300.00 view top 100 |
Department | department | text | view top 100 |
DepartmentGroup | departmentgroup | text | view top 100 |
FunctionDescription | functiondescription | text | view top 100 |
FunctionGroup | functiongroup | text | view top 100 |
FundGroup | fundgroup | text | view top 100 |
VendorType | vendortype | text | SERVICE EMPLOYEE CONSTRUCTION SUPPLIES view top 100 |
Employee | employee | checkbox | false view top 100 |