Urban Futures Expenditures

controllerdata.lacity.org | Last Updated 10 Jan 2017

Financial Data for the Checkbook Explorer since Fiscal Year 2012.

Tags: checkbook, echeckbook, expenditures, vendors, agencies

This dataset has the following 62 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
ID NUMBERid_numbernumber
FISCAL YEARfiscal_yearnumber
DEPARTMENT NAMEdepartment_nametext
VENDOR NAMEvendor_nametext
TRANSACTION DATEtransaction_datecalendar_date
DOLLAR AMOUNTdollar_amountnumber
AUTHORITYauthoritytext
BUSINESS TAX REGISTRATION CERTIFICATEbtrctext
GOVERNMENT ACTIVITYgovernment_activitytext
FUND GROUP NAMEfund_group_nametext
FUND TYPEfund_typetext
FUND NAMEfund_nametext
FUNDfundtext
ACCOUNT NAMEaccount_nametext
ACCOUNT CODEaccount_codetext
TRANSACTION IDtransaction_idtext
EXPENDITURE TYPEexpenditure_typetext
SETTLEMENT/JUDGMENTsettlement_judgmenttext
FISCAL MONTH NUMBERfiscal_month_numbernumber
FISCAL YEAR-MONTHfiscal_year_monthtext
FISCAL YEAR-QUARTERfiscal_year_quartertext
CALENDAR MONTH NUMBERcalendar_month_numbernumber
CALENDAR MONTH/YEARcalendar_month_yeartext
CALENDAR MONTHcalendar_monthtext
DATA SOURCEdata_sourcetext
AUTHORITY NAMEauthority_nametext
AUTHORITY LINKauthority_linkurl
DEPARTMENT NUMBERdepartment_numbertext
PROGRAMprogramtextExpense based on Program Activity
VENDOR IDvendor_idtext
ZIPziptext
PAYMENT METHODpayment_methodtext
PAYMENT STATUSpayment_statustext
INV NUMinv_numtextINVOICE NUMBER
INVOICE DUE DATEinvoice_due_datecalendar_date
INVOICE DISCOUNT DUE DATEinvoice_discount_due_datecalendar_date
INV DATEinv_datecalendar_dateInvoice Receipt Date
INV LINEinv_linenumberVendor's Invoice Line Number
INVOICE DISTRIBUTION LINEinv_dist_linenumberSystem line associated with Vendor's Invoice Line Number
PO NUMpo_numtextPurchase Order Number
DESCRIPTIONdescriptiontextDescription of purchased item
DETAILED ITEM DESCRIPTIONdetailed_item_descriptiontext
UNIT PRICEunit_pricenumberUnit Price of purchased item
UNIT OF MEASUREunit_of_measuretext
QUANTITYquantitynumberNumber of items purchased
SALES TAX PERCENTsales_tax_percentnumber
SALES TAXsales_taxnumberSales Tax Amount
DISCOUNTdiscountnumberDiscount on purchased item
RECEIVER IDreceiver_idtext
PO DATEpo_datecalendar_datePurchase Order Date
PO LINE NUMBERpo_line_numbernumberPurchase Order Line Number
PROCUREMENT ORGANIZATIONprocurement_organizationtext
BUYER NAMEbuyer_nametextCity Buyer ID
SUPPLIER CITYsupplier_citytextVendor City
SUPPLIER COUNTRYsupplier_countrytextVendor Country
BU NAMEbu_nametextCity Business Unit Name
SITE LOCATIONsite_locationtextPurchased Item Site Location
ITEM CODEitem_codetextPurchased Item Code
ITEM CODE NAMEitem_code_nametextPurchased Item Code Name
CURRENCYcurrencytextType of currency used in transaction
VALUE OF SPENDvalue_of_spendnumberCalculation of Unit Price * Quanity
VENDOR NUMvendor_numtextVendor ID + Vendor Name