Enterprise Procurement Transaction Logs
This dataset provides a comprehensive view of enterprise procurement transactions, including detailed records of requests, approvals, and payments. It enables in-depth spend analytics, process mining, compliance monitoring, and vendor management, supporting organizations in optimizing procurement workflows and controlling costs.
Sample rows
preview · 8 of 200 rows · all 27 columns| procurement_request_idstring | payment_statusstring | unit_pricefloat | payment_methodstring | request_datedatetime | requester_idstring | departmentstring | item_categorystring | quantityinteger | currencystring | total_estimated_amountfloat | vendor_idstring | approval_idstring | approval_statusstring | approval_datedatetime | approver_idstring | approval_commentsstring | payment_idstring | payment_datedatetime | payment_amountfloat | vendor_namestring | vendor_street_addressstring | vendor_citystring | vendor_statestring | vendor_postal_codestring | vendor_countrystring | item_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PRC-00001 | Completed | 1299.99 | Bank Transfer | 2023-01-15T09:32:18Z | EMP00101 | IT | IT Equipment | 12 | USD | 15599.88 | VND1001 | APR-00001 | Approved | 2023-01-16T11:03:42Z | EMP00201 | Meets Q1 refresh, approved. | PAY-00001 | 2023-01-18T14:22:30Z | 15599.88 | TechSource Solutions | 425 Market St | San Francisco | CA | 94105 | USA | Dell Latitude 7420 Laptops, 16GB RAM, 512GB SSD |
| PRC-00002 | Completed | 2450 | Bank Transfer | 2023-02-11T13:24:01Z | EMP00102 | Engineering | Software | 3 | USD | 7350 | VND1002 | APR-00002 | Approved | 2023-02-12T10:59:49Z | EMP00202 | Essential for CAD team, proceeding. | PAY-00002 | 2023-02-14T08:44:21Z | 7350 | 3D Systems Group | 88 Innovation Blvd | San Jose | CA | 95134 | USA | SolidWorks Premium License (1yr) |
| PRC-00003 | blank | 5400 | blank | 2023-02-15T16:41:55Z | EMP00103 | HR | Services | 1 | USD | 5400 | VND1003 | APR-00003 | Pending | blank | blank | blank | blank | blank | blank | Wellness Partners Inc. | 77 Wellness Way | Austin | TX | 78701 | USA | Employee Assistance Program annual fee |
| PRC-00004 | Pending | 900 | blank | 2023-02-18T10:15:32Z | EMP00104 | Finance | Software | 2 | USD | 1800 | VND1004 | APR-00004 | Approved | 2023-02-18T13:01:53Z | EMP00203 | Renewal, finance tools essential. | PAY-00003 | blank | blank | Intuit Inc. | 2700 Coast Ave | Mountain View | CA | 94043 | USA | QuickBooks Online Advanced (annual) |
| PRC-00005 | Completed | 0.85 | Cheque | 2023-03-05T14:28:00Z | EMP00105 | Marketing | Marketing Materials | 3000 | USD | 2550 | VND1005 | APR-00005 | Approved | 2023-03-06T10:12:47Z | EMP00204 | Q2 launch, print run required. | PAY-00004 | 2023-03-08T09:47:22Z | 2550 | PrintWorks Press | 1010 Main Rd | Chicago | IL | 60601 | USA | Design and printing of Q2 brochures |
| PRC-00006 | Completed | 59000 | Bank Transfer | 2023-03-11T11:08:11Z | EMP00106 | R&D | IT Equipment | 1 | USD | 59000 | VND1006 | APR-00006 | Approved | 2023-03-13T17:21:36Z | EMP00205 | Prototype for new composites line. | PAY-00005 | 2023-03-15T16:19:12Z | 59000 | Innovate3D Solutions | 44 Industrial Pkwy | Boston | MA | 02110 | USA | 3D printer prototype, Markforged FX20 |
| PRC-00007 | Completed | 1200 | Bank Transfer | 2023-03-20T13:21:22Z | EMP00107 | Legal | Legal Fees | 2 | GBP | 2400 | VND1007 | APR-00007 | Approved | 2023-03-22T11:15:00Z | EMP00206 | Legal review for M&A activity. | PAY-00006 | 2023-03-25T13:04:33Z | 2400 | Baker & Associates LLP | 10 Fleet St | London | blank | EC4Y 8BQ | UK | External counsel fees (Q1) |
| PRC-00008 | Completed | 0.07 | Cheque | 2023-03-22T08:13:17Z | EMP00108 | Admin | Office Supplies | 10000 | USD | 700 | VND1008 | APR-00008 | Approved | 2023-03-22T13:06:55Z | EMP00207 | Annual supply purchase. | PAY-00007 | 2023-03-25T10:11:29Z | 700 | OfficeDepot Inc. | 900 Paper Ave | Dallas | TX | 75201 | USA | Bulk order of A4 printer paper (50,000 sheets) |
| PRC-00009 | Completed | 102.5 | Credit Card | 2023-03-28T15:27:49Z | EMP00109 | Support | IT Equipment | 18 | USD | 1845 | VND1009 | APR-00009 | Approved | 2023-03-29T09:03:21Z | EMP00208 | For remote support staff. | PAY-00008 | 2023-03-30T12:14:45Z | 1845 | Headset Direct | 123 Tech Lane | Austin | TX | 78702 | USA | Wireless headsets for helpdesk |
| PRC-00010 | Pending | 11.5 | blank | 2023-04-02T09:10:38Z | EMP00110 | Logistics | Logistics | 500 | USD | 5750 | VND1010 | APR-00010 | Approved | 2023-04-03T13:48:16Z | EMP00209 | Stock up for peak season. | PAY-00009 | blank | blank | MoveFast Freight | 78 Cargo Rd | Seattle | WA | 98101 | USA | Pallet shipment, Q2 stock replenishment |
| PRC-00011 | Pending | 2100 | blank | 2023-04-04T14:36:58Z | EMP00111 | Operations | Facilities Management | 1 | USD | 2100 | VND1011 | APR-00011 | Approved | 2023-04-05T16:44:42Z | EMP00210 | Quarterly maintenance contract. | PAY-00010 | blank | blank | CleanTech Services | 12 Sparkle Ave | Atlanta | GA | 30303 | USA | Warehouse cleaning and maintenance |
| PRC-00012 | blank | 3400 | blank | 2023-04-06T13:19:45Z | EMP00112 | IT | IT Equipment | 4 | USD | 13600 | VND1012 | APR-00012 | Pending | blank | blank | blank | blank | blank | blank | NetTech Solutions | 4321 Silicon Dr | San Jose | CA | 95131 | USA | Cisco Catalyst 9300 Switches |
| PRC-00013 | blank | 1500 | blank | 2023-04-10T10:21:14Z | EMP00113 | Engineering | Software | 5 | USD | 7500 | VND1013 | APR-00013 | Rejected | 2023-04-12T09:22:00Z | EMP00211 | Budget exceeded, postpone. | blank | blank | blank | SoftWorks LLC | 66 Park Ave | San Diego | CA | 92101 | USA | Lab software license renewal |
| PRC-00014 | Completed | 4900.5 | Bank Transfer | 2023-04-13T08:15:10Z | EMP00114 | Research | Laboratory Supplies | 2 | EUR | 9801 | VND1014 | APR-00014 | Approved | 2023-04-14T11:45:32Z | EMP00212 | Project 5B: critical reagents. | PAY-00011 | 2023-04-16T10:33:20Z | 9801 | ChemBest GmbH | Am Bahnhof 8 | Munich | BY | 80335 | Germany | Specialty chemical reagents |
| PRC-00015 | Completed | 185 | Bank Transfer | 2023-04-18T15:17:55Z | EMP00115 | Customer Service | IT Equipment | 20 | USD | 3700 | VND1015 | APR-00015 | Approved | 2023-04-19T12:38:16Z | EMP00213 | Headcount growth support. | PAY-00012 | 2023-04-21T14:45:55Z | 3700 | Telecom Direct | 555 Call Ave | Denver | CO | 80202 | USA | Desk phones for new call center agents |
| PRC-00016 | Completed | 1.12 | Bank Transfer | 2023-04-22T10:03:32Z | EMP00116 | Production | Raw Materials | 5000 | USD | 5600 | VND1016 | APR-00016 | Approved | 2023-04-23T09:28:19Z | EMP00214 | Production ramp up. | PAY-00013 | 2023-04-26T15:12:01Z | 5600 | PolyChem Corp. | 200 Plastics Dr | Houston | TX | 77002 | USA | Bulk raw material: HDPE resin pellets |
| PRC-00017 | Completed | 48 | Cheque | 2023-04-29T14:48:24Z | EMP00117 | Facilities | Facilities Management | 30 | USD | 1440 | VND1017 | APR-00017 | Approved | 2023-04-30T09:06:21Z | EMP00215 | Quarterly maintenance. | PAY-00014 | 2023-05-02T13:47:38Z | 1440 | AirCare Solutions | 800 Filter Blvd | Las Vegas | NV | 89109 | USA | HVAC system filter replacements |
| PRC-00018 | blank | 250 | blank | 2023-05-04T15:25:31Z | EMP00118 | Legal | Compliance | 1 | USD | 250 | blank | APR-00018 | Cancelled | 2023-05-06T10:18:38Z | EMP00216 | Filing withdrawn. | blank | blank | blank | blank | blank | blank | blank | blank | blank | State filing fee |
| PRC-00019 | Completed | 29.99 | Credit Card | 2023-05-09T09:52:12Z | EMP00119 | Support | IT Equipment | 25 | USD | 749.75 | VND1018 | APR-00019 | Approved | 2023-05-10T14:16:49Z | EMP00217 | Remote work kits. | PAY-00015 | 2023-05-12T10:39:03Z | 749.75 | OfficeTech Supply | 4250 Tech Blvd | Phoenix | AZ | 85004 | USA | Wireless keyboard and mouse combos |
| PRC-00020 | Pending | 8700 | blank | 2023-05-13T17:08:17Z | EMP00120 | Sales | Marketing Materials | 1 | USD | 8700 | VND1019 | APR-00020 | Approved | 2023-05-14T12:33:22Z | EMP00218 | Q3 event spend. | PAY-00016 | blank | blank | ExpoDesign Group | 300 Exhibition Ln | Orlando | FL | 32801 | USA | Custom trade show booth design |
What the 200 rows show
from the 200-row sample- 1,200median unit_
price - 4approval statuses
- 5currencies
- 5vendor countries
- 12item categories
- 16departments
Median 1,200, from 0.07 to 99,000.
- string 20
- integer 1
- float 3
- datetime 3
Columns
27 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 20 columns | |||
procurement_request_id | string | Unique identifier for each procurement request.unique | PRC-00001 |
requester_id | string | Unique identifier of the employee who submitted the procurement request. | EMP00101 |
department | string | Department submitting the procurement request. | IT |
item_description | string | Description of the goods or services requested. | State filing fee |
item_category | string | Category of the item being procured (e.g., IT Equipment, Office Supplies).12 categories | IT Equipment |
currency | string | Currency code for the transaction (e.g., USD, EUR).5 currencies | USD |
vendor_id | string | Unique identifier of the vendor (if pre-selected).optional | VND1001 |
approval_id | string | Unique identifier for the approval record associated with this request.unique · optional | APR-00001 |
approval_status | string | Current status of the approval (e.g., Pending, Approved, Rejected).Pending · Approved · Rejected · Cancelled | Approved |
approver_id | string | Unique identifier of the employee who approved or rejected the request.optional | EMP00201 |
approval_comments | string | Comments or notes from the approver.optional | Annual supply purchase. |
payment_id | string | Unique identifier for the payment transaction related to this procurement.unique · optional | PAY-00001 |
payment_status | string | Status of the payment (e.g., Pending, Completed, Failed, Cancelled).Pending · Completed · Failed · Cancelled · optional | Completed |
payment_method | string | Method used for payment (e.g., Bank Transfer, Credit Card, Cheque).Bank Transfer · Credit Card · Cheque · Other · optional | Bank Transfer |
vendor_name | string | Name of the vendor supplying the goods or services.optional | TechSource Solutions |
vendor_street_address | string | Street address of the vendor.optional | 425 Market St |
vendor_city | string | City where the vendor is located.optional | San Francisco |
vendor_state | string | State or province where the vendor is located.optional | CA |
vendor_postal_code | string | Postal code of the vendor's address.optional | 94105 |
vendor_country | string | Country where the vendor is located.5 countries · optional | USA |
| Numbers 4 columns | |||
quantity | integer | Number of units requested.1 or more | 12 |
unit_price | float | Estimated price per unit of the item.0 or more | 1299.99 |
total_estimated_amount | float | Total estimated amount for the procurement request (quantity x unit_price).0 or more | 15599.88 |
payment_amount | float | Actual amount paid to the vendor.0 or more · optional | 15599.88 |
| Dates and times 3 columns | |||
request_date | datetime | Timestamp when the procurement request was submitted. | 2023-01-15T09:32:18Z |
approval_date | datetime | Timestamp when the request was approved or rejected.optional | 2023-01-16T11:03:42Z |
payment_date | datetime | Timestamp when the payment was processed.optional | 2023-01-18T14:22:30Z |
Use it for
A finance dashboard
Unit_
price by payment_ status and a breakdown of payment_ method. Excel, Power BI or Tableau. What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
- Procurement requests200PRC-000011299.99CompletedPRC-000022450CompletedPRC-000035400—
A software demo
Believable procurement requests with request_
date, requester_ id and department to fill a screen in front of a buyer.
blueprint · enterprise-procurement-transaction-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Each transaction links to supplier and department.
- Approval flow and status history included.
- Purchase categories and contract numbers provided.
- Payment and delivery confirmation fields populated.
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- enterprise-procurement-transaction-logs