This dataset has the following 45 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
AccountStatus | accountstatus | text | Active Inactive view top 100 |
AccountType | accounttype | text | Expense Balance Sheet Revenue view top 100 |
Actual | actual | number | 150.00 200.00 300.00 1000.00 2000.00 view top 100 |
CharacterCode | charactercode | text | 54 53 57 00 56 view top 100 |
CharacterCodeDescription | charactercodedescription | text | Supplies & Materials Purchased Services Other Expense Undefined Utilties view top 100 |
Date | date | calendar_date | 2022-06-30T00:00:00.000 2023-06-30T00:00:00.000 2021-06-30T00:00:00.000 2023-10-27T00:00:00.000 2023-01-27T00:00:00.000 view top 100 |
Department | department | text | view top 100 |
DepartmentGroup | departmentgroup | text | view top 100 |
Description | description | text | P-Card invoice for statement c SENSITIVE INFORMATION Cafeteria Supplies DPS, Cafeteria Supplies Books view top 100 |
Entity | entity | text | City view top 100 |
EntryType | entrytype | text | D C view top 100 |
FiscalPeriod | fiscalperiod | number | 12 4 9 5 6 view top 100 |
FiscalYear | fiscalyear | number | 2022 2021 2023 2024 2025 view top 100 |
FullAccount | fullaccount | text | 1501-300-300-315-000-0000-00-5700-542000- 9999-000-000-000-000-0000-00-0000-103002- 1000-400-466-315-470-4220-05-5700-543000- 1000-600-610-000-000-0000-00-5700-558040- 1000-400-466-315-470-4110-05-5700-545000- view top 100 |
FunctionDescription | functiondescription | text | view top 100 |
FunctionGroup | functiongroup | text | Education Public Works & Facilities Town-wide General Government Culture & Recreation view top 100 |
Fund | fund | text | General Fund School Lunch Revolving Pooled Cash SPED Reimbursement (Circuit B) Early Childhood Tuition Revolv view top 100 |
FundCode | fundcode | text | 1000 1501 9999 2213 1506 view top 100 |
FundGroup | fundgroup | text | view top 100 |
InvoiceId | invoiceid | text | 122857 106930 133848 101925 133851 view top 100 |
InvoiceStatus | invoicestatus | text | Paid Void Approved view top 100 |
Object | object | text | Office Supplies Educational Supplies Other Expense Facilities/Maint Supplies Custodial Supplies view top 100 |
ObjectCode | objectcode | text | 542000 551020 579000 543000 545000 view top 100 |
Organization | organization | text | Sch Lunch Exp DPW Exp TwnFac Exp General Bal Sheet Library Exp view top 100 |
OrganizationCode | organizationcode | text | 15015700 14205700 14655700 1000 16105700 view top 100 |
PaymentCheckNumber | paymentchecknumber | text | 0 36721 36877 48619 47699 view top 100 |
Project | project | text | UNKNOWN FY 22 FY 23 FY 21 FY 24 view top 100 |
ProjectCode | projectcode | text | 2022 2023 2021 2024 2020 view top 100 |
Segment2 | segment2 | text | Schools Public Works & Facilities Undefined General Government Culture & Recreation view top 100 |
Segment2Code | segment2code | text | 300 400 000 100 600 view top 100 |
Segment3 | segment3 | text | Schools Facilities-School Undefined Public Works Facilities-Town view top 100 |
Segment3Code | segment3code | text | 300 466 000 420 465 view top 100 |
Segment4 | segment4 | text | Undefined Systemwide High School School Administration Middle School view top 100 |
Segment4Code | segment4code | text | 000 315 304 301 305 view top 100 |
Segment5 | segment5 | text | Undefined Operations Special Education Principal Office Administration view top 100 |
Segment5Code | segment5code | text | 000 470 355 120 572 view top 100 |
Segment6 | segment6 | text | Undefined General Supplies Building Maintenance Utility Custodial Services view top 100 |
Segment6Code | segment6code | text | 0000 2430 4220 4130 4110 view top 100 |
Segment7 | segment7 | text | Undefined Supplies & Materials Contract Services Other Expenditures Salaries Other view top 100 |
Segment7Code | segment7code | text | 00 05 04 06 03 view top 100 |
Segment8 | segment8 | text | Expenditures Undefined Salary & Wages Capital Outlay Excise Taxes view top 100 |
Segment8Code | segment8code | text | 5700 0000 5100 5800 4150 view top 100 |
UniqueId | uniqueid | text | 38572-546195-4864-4727-5697-118033 38572-546196-4864-4727-5697-118034 38572-546197-4887-4727-5697-118035 38572-546198-4887-4727-5697-118036 38572-546199-4887-4727-5697-118037 view top 100 |
VendorId | vendorid | text | 911006 1573 911005 1055 1646 view top 100 |
VendorName | vendorname | text | PCARD VENDORS UNNAMED VENDOR WB MASON COMPANY INC TOWN MISC REFUNDS DEDHAM WESTWOOD WATER DISTRICT view top 100 |