Loading...
Loading...
Available on 1 platform
Sign in to view source links and access this dataset
Legacy purchase orders from the City-Parish government of Baton Rouge, Louisiana, detailing procurement of goods and services. The dataset includes both header records for overall orders and detail records for individual line items, as tracked in the old system prior to September 15, 2017. Data is provided by the data.brla.gov organization.
Header records (Record Type 'H') and detail records (Record Type 'D') are in the same table; analysis requires joining on PURCHASE ORDER NUMBER. For data after September 14, 2017, a separate dataset is required.
| # | Column Name |
|---|---|
| 1 | REQUISITION NUMBER |
| 2 | VENDOR ZIP |
| 3 | VENDOR CONTACT PHONE |
| 4 | ITEM QUANTITY ORDERED |
| 5 | ITEM NUMBER |
| 6 | TOTAL ITEMS |
| 7 | VENDOR CONTACT EXTENSION |
| 8 | VENDOR CONTACT TITLE |
| 9 | VENDOR STATE |
| 10 | VENDOR ADDRESS 2 |
| 11 | VENDOR ADDRESS 1 |
| 12 | VENDOR NAME 1 |
| 13 | VENDOR NUMBER |
| 14 | VOUCHED AMOUNT |
| 15 | PO CATEGORY CODE |
| 16 | COST CENTER NAME |
| 17 | DEPARTMENT NAME |
| 18 | TOTAL AMOUNT |
| 19 | INPUT DATE |
| 20 | PURCHASE ORDER NUMBER |
| 21 | ITEM TOTAL COST |
| 22 | PO BALANCE |
| 23 | VENDOR MINORITY DESCRIPTION |
| 24 | DEPARTMENT NUMBER |
| 25 | VENDOR NAME 2 |
| 26 | ITEM UNIT OF MEASURE |
| 27 | VENDOR MINORITY CODE |
| 28 | VENDOR CONTACT NAME |
| 29 | INPUT BY |
| 30 | PO TYPE DESCRIPTION |
| 31 | COST CENTER |
| 32 | ITEM UNIT OF MEASURE DESCRIPTION |
| 33 | VENDOR CITY |
| 34 | PO CATEGORY DESCRIPTION |
| 35 | RECORD TYPE |
| 36 | ITEM UNIT COST |
| 37 | PO TYPE CODE |
| 38 | UNIQUE ID |
| 39 | ITEM DESCRIPTION |
| 40 | PO STATUS DESCRIPTION |
| 41 | PO STATUS CODE |
| 42 | PURCHASING AGENT |