Ember Lane Pizza: Goods-received note lines CSV
Goods-received note lines CSV for Ember Lane Pizza. 12 received lines across 4 goods-received notes. Three lines are exceptions: a short delivery of 4 units on GRN-PIZ-2002, an item substitution on GRN-PIZ-2003 where the delivered ingredient id differs from the ordered one, and a part return of 3 units on GRN-PIZ-2004. accepted_quantity equals delivered_quantity minus returned_quantity on every row.
grn_number,grn_date,delivery_note_number,po_number,supplier_id,received_at_location_id,line_no,po_ingredient_id,delivered_ingredient_id,description,uom,ordered_quantity,delivered_quantity,returned_quantity,accepted_quantity,line_status,note
GRN-PIZ-2001,2026-08-07,DN-PIZ-3001,PO-PIZ-1001,SUP-01,LOC-01,1,ING-01,ING-01,Pizza Flour,kg,15,15,0,15,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2001,2026-08-07,DN-PIZ-3001,PO-PIZ-1001,SUP-01,LOC-01,2,ING-02,ING-02,Mozzarella,kg,18,18,0,18,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2001,2026-08-07,DN-PIZ-3001,PO-PIZ-1001,SUP-01,LOC-01,3,ING-03,ING-03,Crushed Tomatoes,kg,21,21,0,21,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2002,2026-08-14,DN-PIZ-3002,PO-PIZ-1002,SUP-02,LOC-01,1,ING-01,ING-01,Pizza Flour,kg,17,17,0,17,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2002,2026-08-14,DN-PIZ-3002,PO-PIZ-1002,SUP-02,LOC-01,2,ING-03,ING-03,Crushed Tomatoes,kg,23,19,0,19,short delivery,4 kg ordered were not on the vehicle; the driver recorded a short delivery.
GRN-PIZ-2002,2026-08-14,DN-PIZ-3002,PO-PIZ-1002,SUP-02,LOC-01,3,ING-05,ING-05,Basil,kg,29,29,0,29,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2003,2026-08-21,DN-PIZ-3003,PO-PIZ-1003,SUP-01,LOC-01,1,ING-04,ING-04,Pepperoni,kg,28,28,0,28,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2003,2026-08-21,DN-PIZ-3003,PO-PIZ-1003,SUP-01,LOC-01,2,ING-05,ING-01,Pizza Flour,kg,31,31,0,31,substituted,Ordered item ING-05 was out of stock; the supplier substituted ING-01 at the same quantity.
GRN-PIZ-2003,2026-08-21,DN-PIZ-3003,PO-PIZ-1003,SUP-01,LOC-01,3,ING-06,ING-06,Pizza Box,each,34,34,0,34,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2004,2026-08-28,DN-PIZ-3004,PO-PIZ-1004,SUP-02,LOC-01,1,ING-02,ING-02,Mozzarella,kg,18,18,0,18,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2004,2026-08-28,DN-PIZ-3004,PO-PIZ-1004,SUP-02,LOC-01,2,ING-04,ING-04,Pepperoni,kg,24,24,0,24,received in full,Quantity and item match the purchase order line.
GRN-PIZ-2004,2026-08-28,DN-PIZ-3004,PO-PIZ-1004,SUP-02,LOC-01,3,ING-06,ING-06,Pizza Box,each,30,30,3,27,part returned,3 each were rejected on arrival for condition and returned with the driver.
Specifications
- Kit
- restaurant-pizzeria
- Schema Version
- 1
- Synthetic
- true
- As Of
- 2026-09-08
- Currency
- CAD
- Tax Name
- GST
- Tax Rate
- 0.05
- Rows
- 12
- Columns
- 17
- Delimiter
- comma
- Encoding
- UTF-8
- Byte Order Mark
- false
- Line Endings
- LF
- Decimal Separator
- .
Testing contract
Expected to pass- Scenario
- Read goods-received note lines csv into a procure-to-pay import, three-way match and reconciliation workflow for Ember Lane Pizza.
- Expected result
- 12 received lines across 4 goods-received notes. Three lines are exceptions: a short delivery of 4 units on GRN-PIZ-2002, an item substitution on GRN-PIZ-2003 where the delivered ingredient id differs from the ordered one, and a part return of 3 units on GRN-PIZ-2004. accepted_quantity equals delivered_quantity minus returned_quantity on every row.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Ember Lane Pizza: Goods-received note lines CSV” is a deterministic Testaroo fixture for Data import, CSV parsing. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 12 rows · 17 columns · UTF-8 · LF. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("goods-received.csv")
print(df.head())
print(df.dtypes)Generated by generation/restaurant_procurement.py. Free for any use, no attribution required, license.
Related files
- csvAlder Table Bistro: Credit note lines CSVCredit note lines CSV for Alder Table Bistro. 2 credit lines, one per note. CN-BST-7001 credits 4 units for the short delivery and agrees with the goods-received note. CN-BST-7002 credits 5 units where GRN-BST-2004 records only 3 returned, an overstatement of 15.58 CAD net.
- csvAlder Table Bistro: Goods-received note lines CSVGoods-received note lines CSV for Alder Table Bistro. 12 received lines across 4 goods-received notes. Three lines are exceptions: a short delivery of 4 units on GRN-BST-2002, an item substitution on GRN-BST-2003 where the delivered ingredient id differs from the ordered one, and a part return of 3 units on GRN-BST-2004. accepted_quantity equals delivered_quantity minus returned_quantity on every row.
- csvAlder Table Bistro: Purchase order lines CSVPurchase order lines CSV for Alder Table Bistro. 12 lines across 4 purchase orders dated 2026-08-05 to 2026-08-26. Each line repeats its order's net, tax and gross totals, so a reader can check that the line values sum to the header without a second file. Order PO-BST-1002 totals 329.53 CAD including GST.
- csvAlder Table Bistro: Remittance advice lines CSVRemittance advice lines CSV for Alder Table Bistro. 13 lines, one for every document on both statements, each marked paid or withheld with a reason. 1120.68 CAD is settled and 1765.18 CAD is withheld against statement balances of 2885.86 CAD; the first two figures sum to the third.
- csvAlder Table Bistro: Statements of account CSVStatements of account CSV for Alder Table Bistro. 13 transaction rows across 2 month-end statements dated 2026-08-31. STM-BST-6001 closes at 1326.11 CAD and its four declared ageing buckets sum to exactly that. STM-BST-6002 closes at 1559.75 CAD while its declared buckets sum to 1566.76 CAD.
- csvAlder Table Bistro: Supplier invoice lines CSVSupplier invoice lines CSV for Alder Table Bistro. 14 lines across 5 invoice documents that carry only 4 distinct invoice numbers: INV-BST-5002 appears twice, dated 2026-08-14 and 2026-08-17. invoice_number is therefore not a key; the pair of invoice_number and invoice_date is. invoice_stated_tax_total is the figure printed on the document, which for INV-BST-5003 is one cent above the sum of its line tax amounts.
