austintexas-gov/purchase-order-quantity-price-detail-for-3ebq-e9iz
Icon for Socrata external plugin
 
Readme
Updated 1 day ago
Indexed 3 hours ago

Purchase Order Quantity Price detail for Commodity/Goods procurements

Purchase Order commodity line level detail for City of Austin Commodities/Goods purchases dating back to October 1st, 2009. Each line includes the NIGP Commodity Code/COA Inventory Code, commodity description, quantity, unit of measure, unit price, total amount, referenced Master Agreement if applicable, the contract name, purchase order, award date, and vendor information. The data contained in this data set is for informational purposes only. Certain Austin Energy transactions have been excluded as competitive matters under Texas Government Code Section 552.133 and City Council Resolution 20051201-002.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
MASTER_AGREEMENTmaster_agreementmaster_agreementText
STststText
QUANTITYquantityquantityNumber
UNIT_PRICEunit_priceunit_priceNumber
EXTENDED_DESCRIPTIONextended_descriptionextended_descriptionText
AD_LN_1ad_ln_1ad_ln_1Text
COMMODITYcommoditycommodityText
ITM_TOT_AMitm_tot_amitm_tot_amNumber
LGL_NMlgl_nmlgl_nmText
DATA_BUILD_DATEdata_build_datedata_build_dateCalendar dateThe date the data set was last built from production data.
VENDOR_CODEvendor_codevendor_codeText
UNIT_OF_MEAS_DESCunit_of_meas_descunit_of_meas_descText
CITYcitycityText
AD_LN_2ad_ln_2ad_ln_2Text
CONTRACT_NAMEcontract_namecontract_nameText
COMMODITY_DESCRIPTIONcommodity_descriptioncommodity_descriptionText
PURCHASE_ORDERpurchase_orderpurchase_orderText
AWARD_DATEaward_dateaward_dateCalendar date
ZIPzipzipText
UNIT_OF_MEASUREunit_of_measureunit_of_measureText
CTRYctryctryText
 
Preview
  • purchase_order_quantity_price_detail_for
     
Upstream Metadata