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 |