Name: State Of Iowa Consumer Fraud Refund Transactions
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

State Of Iowa Consumer Fraud Refund Transactions

This dataset contains payment transactions recorded in the State of Iowa’s central accounting system for the Consumer Fraud Refunds fund.
Organization: State of Iowa
Last updated: 2023-01-19T23:50:41.385522
Tags: checkbook, consumer-fraud, expenditures, payments, refunds

Tables

Table 1

@usgov.state_of_iowa_state_of_iowa_consumer_fraud_refund_transactions.table_1

17.63 MB
434,321 rows
22 columns

CREATE TABLE table_1 (
  "record_number" BIGINT,
  "fiscal_year" BIGINT,
  "fiscal_year_period" BIGINT,
  "accounting_period" VARCHAR,
  "service" VARCHAR,
  "department" VARCHAR,
  "fund_code" BIGINT,
  "fund_name" VARCHAR,
  "appropriation_code" VARCHAR,
  "appropriation_name" VARCHAR,
  "program" VARCHAR,
  "expense_category" VARCHAR,
  "vendor" VARCHAR,
  "vendor_number" VARCHAR,
  "payment_number" VARCHAR,
  "payment_issue_date" TIMESTAMP,
  "invoice_number" VARCHAR,
  "invoice_line_number" BIGINT,
  "invoice_line_distribution_number" BIGINT,
  "invoice_date" TIMESTAMP,
  "amount" DOUBLE,
  "description" VARCHAR
);