This data is all invoices with payments that have been processed in accounts payable. A single invoice may have separate payments under different checks, and this would show up as multiple rows in the data set. A single payment may have multiple invoices involved, and this would show up as multiple rows within the data set.
This dataset has the following 23 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Supplier Name | supplier_name | text | Name of the supplier or vendor receiving payment. | Lee-Smith Inc Tenn American Water Co Canon Solutions America Atlanta Gas Light Co Electric Power Board of Chattanooga view top 100 |
| Supplier Number | supplier_number | text | Number assigned in Oracle. | 039980 068508 866161 012570 021684 view top 100 |
| Payment Number | payment_number | text | Payment number assigned in Oracle. | 2214018 5011620 5010922 2135826 2179137 view top 100 |
| Payment Date | payment_date | calendar_date | Date payment was processed in Oracle. | 2013-04-30T00:00:00.000 2020-04-09T00:00:00.000 2021-05-18T00:00:00.000 2020-04-02T00:00:00.000 2012-06-28T00:00:00.000 view top 100 |
| Invoice Number | invoice_number | text | Payment number assigned in Oracle. | FEB 2013 MAY2012 09/14/2012 MAR 2013 #051112 view top 100 |
| Invoice Date | invoice_date | calendar_date | Date of invoice based on invoice document. | 2019-05-31T00:00:00.000 2020-09-30T00:00:00.000 2020-12-31T00:00:00.000 2019-02-28T00:00:00.000 2020-06-30T00:00:00.000 view top 100 |
| Payment Total | payment_total | number | Amount paid on the invoice. | 19 12.39 0 100 82.75 view top 100 |
| Po Number | po_number | text | Purchase Order number in Oracle if any. | 534257 505161 520051 526878 527768 view top 100 |
| Receipt Number | receipt_number | text | Receipt number assigned in Oracle. | 73019 95300 145275 39921 120150 view top 100 |
| Department | department | text | Public Works Undefined Youth & Family Development General Services General Gov't & Agencies view top 100 | |
| Account Description | account_description | text | Vehicle Parts Water Food & Ice Clothing & Linen Service Other Contracted Service view top 100 | |
| Fund Description | fund_description | text | General Fund Interceptor Sewer Operations Municipal Garage Water Quality Mgmt Operations Public Library view top 100 | |
| Cost Center Description | cost_center_description | text | Not Required Rep & Maint - Amnicola Garage Rep & Maint - 12th & Park Garage ISS Liquid Handling Water Quality Maintenance & Operation view top 100 | |
| Minority Owned | minority_owned | text | Indicates if the supplier is minority owned per Oracle. | No Yes view top 100 |
| Small Business | small_business | text | Indicates if the supplier is a small business per Oracle. | No Yes view top 100 |
| Women Owned | women_owned | text | Indicates if the supplier is women owned per Oracle. | No Yes view top 100 |
| City | city | text | Chattanooga, Atlanta, Chicago, ., Rossville, view top 100 | |
| State | state | text | TN, GA, IL, PA, TX, view top 100 | |
| Zip | zip | text | 37407 30741 00000 37408 15250-7880 view top 100 | |
| Country | country | text | US CA FR DE IL view top 100 | |
| Vendor Id | vendor_id | text | 156 217 190422 53 91 view top 100 | |
| Days to Pay | days_to_pay | number | Length of days from Invoice Date to Payment Date it took to pay. | 0 7 14 8 13 view top 100 |
| Compliant Indicator | compliant_indicator | text | Yes if Invoice paid within 30 days and No if not | Yes No view top 100 |