Readme
Updated 1 day ago
‧ Indexed 5 hours ago
Open Expenditures - Ledger
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Expense Category | expense_category | expense_category | Text | |
| Program | program | program | Text | |
| Payment ID | payment_id | payment_id | Text | |
| Payment Method | payment_method | payment_method | Text | |
| Fiscal Year Period | fiscal_year_period | fiscal_year_period | Number | |
| Payment Status | payment_status | payment_status | Text | |
| Fiscal Year | fiscal_year | fiscal_year | Number | |
| Department | department | department | Text | |
| Fund Type | fund_type | fund_type | Text | |
| Service | service | service | Text | |
| Org Code | org_code | org_code | Text | |
| Project Name | project_name | project_name | Text | |
| Project Code | project_code | project_code | Text | |
| Object Description | object_description | object_description | Text | |
| PO Number | po_num | po_num | Text | |
| Description | description | description | Text | |
| Amount | amount | amount | Number | |
| Vendor | vendor | vendor | Text | |
| Fund | fund | fund | Text | |
| Object Code | object_code | object_code | Text | |
| Payment Date | payment_date | payment_date | Calendar date | |
| Invoice Distribution Line | invoice_distribution_line | invoice_distribution_line | Number | |
| Org Description | org_description | org_description | Text | |
| Fund Code | fund_code | fund_code | Text | |
| Contract Number | contract_num | contract_num | Text | |
| Invoice Date | invoice_date | invoice_date | Calendar date | |
| Invoice Line | invoice_line | invoice_line | Number | |
| Invoice ID | invoice_id | invoice_id | Text | |
| Vendor ZIP | vendor_zip | vendor_zip | Text | |
| Vendor ID | vendor_id | vendor_id | Text |