Name: General Ledger
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

General Ledger

General Ledger
Organization: State of Oklahoma
Last updated: 2025-06-21T18:24:48.693204
Tags: gl

Tables

LEDGER FY25 QTR4

@usgov.state_of_oklahoma_general_ledger.ledger_fy25_qtr4

5.04 MB
356845 rows
36 columns


CREATE TABLE ledger_fy25_qtr4 (
  "agencynbr" BIGINT,
  "agencyname" VARCHAR,
  "ledger" VARCHAR,
  "fiscal_year" DOUBLE,
  "accounting_period" DOUBLE,
  "fund_code" BIGINT,
  "funddescr" VARCHAR,
  "class_fld" VARCHAR,
  "classdescr" VARCHAR,
  "deptid" VARCHAR,
  "deptdescr" VARCHAR,
  "account" BIGINT,
  "acctdescr" VARCHAR,
  "operating_unit" VARCHAR,
  "operunitdescr" VARCHAR,
  "product" VARCHAR,
  "productdescr" VARCHAR,
  "program_code" VARCHAR,
  "pgmdescr" VARCHAR,
  "budget_ref" VARCHAR,
  "chartfield1" VARCHAR,
  "cf1descr" VARCHAR,
  "chartfield2" VARCHAR,
  "cf2descr" VARCHAR,
  "project_id" VARCHAR,
  "projdescr" VARCHAR,
  "posted_total_amt" DOUBLE,
  "activity" VARCHAR,
  "actvdescr" VARCHAR,
  "restype" VARCHAR,
  "resdescr" VARCHAR,
  "rcat" VARCHAR,
  "rcatdescr" VARCHAR,
  "rsubcat" VARCHAR,
  "rsubcatdescr" VARCHAR,
  "rowid" VARCHAR
);