- state_of_iowa_consumer_fraud_refund_transactions0 Objects| |SELECT":id", -- Socrata column ID"payment_date", -- Date payment was made to the vendor"payment_id", -- Unique code for the payment based on a concatenation of the doc code, dept number, doc ID, vendor line number and commodity line number from the accounting system"accounting_period", -- Accounting periods as reflected in the State's accounting system. Reflects hold-over periods for payments made after year end."fiscal_year_period", -- Reflects twelve periods with July being period 1 and June being period 12. Hold-over payments are reflected in period 12."invoice_id", -- Invoice number provided by the vendor where available. If invoice is not available, same as payment number."vendor_id", -- Lists number assigned to vendor. Data removed for confidentiality purposes will be noted as "RESTRICTED" and the vendor number for state employees have been altered to remove the portion of the vendor number based on their Social Security Number."fiscal_year", -- Identifies the fiscal year (July 1 - June 30, numbered for the calendar year it ends) the payment was assigned. The fiscal year includes a hold-over period for payments made after year end for good and services received on or before June 30."amount", -- Amount of payment to the vendor"description", -- A description of the type of expenditure such as travel, supplies, utilities, equipment, etc"invoice_date", -- Date of invoice where available, otherwise same as payment date."invoice_distribution_line", -- Placeholder number"rec_no", -- This is the journal record number which is a unique ID for the record."vendor", -- Name of vendor receiving the payment. Some data will be noted as "RESTRICTED" if removed from data for confidentiality purposes."service", -- Service reference functions in the state budget, which represent groups of agencies that make expenditures for similar programs and purposes."appropriation_code", -- The code designating the legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation."fund_name", -- The source of funds used to make the payment"fund_code", -- The code designating the source of funds used to make the paymentFailed
Error: TypeError: Failed to fetch
Splitgraph has been acquired by EDB!