Name: State Of Iowa - DOT Clearing Account Fund Transactions
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

State Of Iowa - DOT Clearing Account Fund Transactions

This dataset contains payment transactions recorded in the State of Iowa’s central accounting system for the DOT Clearing Account Fund.
Organization: State of Iowa
Last updated: 2023-01-19T23:58:21.667288
Tags: checkbook, clearing-account, dot, expenditures, payments

Tables

Table 1

@usgov.state_of_iowa_state_of_iowa_dot_clearing_account_fund__b4a61fa8.table_1

11.17 MB
239,092 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" BIGINT,
  "payment_number" VARCHAR,
  "payment_issue_date" TIMESTAMP,
  "invoice_number" VARCHAR,
  "invoice_line_number" BIGINT,
  "invoice_line_distribution_number" BIGINT,
  "invoice_date" TIMESTAMP,
  "amount" BIGINT,
  "description" VARCHAR
);