Find files, editable templates and browser test targets by what you need to make or test. The directory below is cut by format; the two collections under it cut the same library by subject and by workflow.
Certificate of conformance register for Pine Assembly Workshop. Two certificates against the same lot and the same inspection report, one per production order. The first discloses 2 nonconformances and the second none, because the nonconforming legs were consumed by the replacement on the first order and the second order drew clean stock from the same lot.
Covenant test schedule for Pine Assembly Workshop. The 4 covenant tests as data, with required, actual and headroom in their own columns and a unit column, because two of the four are money and one is a ratio. Headroom is signed in the direction of compliance, so a minimum covenant and a maximum covenant both show positive headroom when they pass.
Customs commercial invoice lines for Pine Assembly Workshop. 4 invoice lines covering the 20 kits on BOL-2026-0004, all classified under HS 9403.30 with country of origin CA. amount_usd equals quantity times unit_price_usd on every line and the column sums to 1360.00; net weight sums to 226.880 kg and gross to 244.000 kg, the difference being the packaging.
Customs entry XML for Pine Assembly Workshop. An import entry for the BOL-2026-0004 consignment on a CIF basis. Goods 1360.00 plus freight 388.08 gives a customs value of 1748.08; duty at 0.025 is 43.70 and import tax at 0.050 on the customs value plus duty is 89.59, a total payable of 133.29. The statistical breakdown restates the 226.880 kg across the three component codes.
Delivery route plan and capacity for Pine Assembly Workshop. 4 rounds with 4 stops each. Parcels per round are 8, 12, 16, 20 against a vehicle capacity of 30 parcels, so capacity_used_percent runs from 26.67 to 66.67 and no round is over capacity. freight_charged_usd counts only delivered shipments and sums to 861.19.
EDI X12 856 advance ship notice for Pine Assembly Workshop. An ANSI X12 004010 transaction set 856 for bill of lading BOL-2026-0004: 35 segments from ISA to IEA, terminated with a tilde and CRLF as the format carries in practice. The hierarchy is one shipment level, 4 order levels and 4 item levels, so CTT declares 9 HL segments and SE declares 31 segments in the transaction set.
Exploded bill of materials whose sub-assembly quantities do not roll up for Pine Assembly Workshop. The same 6 rows with one number changed: the SCREW line under BASE carries an extended quantity of 12 instead of 16. That row now says 8 per parent times 2 parents is 12, which is arithmetically false, and the SCREW leaf total falls to 20 against the 24 the model_requirement_component_total column on the same rows still declares. The shortfall is 4 screws, 0.40 USD of material, and it is enough to leave one BASE sub-assembly short at build time.
First article inspection for Pine Assembly Workshop. The first article record for LEG against DRW-LEG-002 revision C: all 5 characteristics measured and passed before the run started. The readings are the fourth sample from the production inspection, which is deliberate: the first article passes on every characteristic while the production lot later fails on two, so the pair shows that a clean first article does not guarantee a clean run.
Gauge calibration register for Pine Assembly Workshop. The 5 gauges used on this inspection, each with its calibration certificate, the date it was calibrated and the date it falls due. All 5 were inside calibration on 2026-09-10, the inspection date, and the used_for column names the characteristics each one measured, so every characteristic can be traced to a gauge and every gauge to a certificate.
Generic primary records CSV for Pine Assembly Workshop. 6 generic records with stable primary keys. Map the documented fields before importing into another platform.
HS tariff code reference for Pine Assembly Workshop. Four tariff codes with duty rates and the unit of quantity each is measured in. Only 9403.30 is used on this entry, because the kit is presented complete but unassembled and is classified as the finished article; the three component codes are shipped so a classification test has a wrong-but-plausible alternative to reject.
Indented bill of materials for Pine Assembly Workshop. The DESK structure exploded to 2 levels in 6 rows, with an indent column so the tree is readable and an is_assembly flag so leaves can be told from sub-assemblies. Per finished unit the leaves are 4 LEG, 1 PANEL and 12 SCREW, which cost 25.20 USD. The 35.00 USD of sub-assembly rows is the same material counted again at a higher level and must not be added to it.
Inspection characteristics and tolerances for Pine Assembly Workshop. The 5 characteristics taken from DRW-LEG-002 revision C, with the nominal, both tolerances and the resulting limits. Four are bilateral and one, surface roughness, is unilateral with a lower tolerance of zero, so its lower limit equals its nominal and a reader that assumes symmetry computes a limit that does not exist.
Inspection measurements with tolerances for Pine Assembly Workshop. 25 readings, 5 samples across 5 characteristics of the LEG part. Deviation is measured less nominal and carries an explicit sign, and result is pass only when the reading lies between both limits inclusive. 2 readings fail: CH-3 sample 3 measured 25.41, above the upper limit of 25.300 by 0.110; CH-5 sample 5 measured 1.58, below the lower limit of 1.600 by 0.020.
Inspection summary for Pine Assembly Workshop. One row per characteristic with the pass count, the observed minimum and maximum and the range. 3 characteristics pass every sample and 2 do not. The range column is observed spread and not tolerance, so a characteristic can have a small range and still fail if the whole sample sits off nominal.
Intentionally invalid semantic test records for Pine Assembly Workshop. Three independent cases report duplicate-primary-key, schema-type and foreign-key errors. JSON syntax remains valid.
Linked operating model for Pine Assembly Workshop. 89 records across 11 linked tables; no duplicate primary keys or missing references. Units received=96.00 units; Units issued=72.00 units; Assembly relationships=6.00 records.
Loan amortisation schedule for Pine Assembly Workshop. 36 rows with opening balance, payment, interest, capital, closing balance and cumulative interest. Payment equals interest plus capital and closing equals opening less capital on every row. The closing balance on row 36 is exactly 0.00 because the final payment is adjusted to 1479.81, and cumulative interest ends at 5276.66 USD.
Loan amortisation schedule whose final balance does not reach zero for Pine Assembly Workshop. The same 36 months with one number changed: the instalment is 1479.00, the correct 1479.91 rounded down to whole dollars. Every row still satisfies payment equals interest plus capital and closing equals opening less capital, but after the last payment the borrower still owes 36.15 USD instead of 0.00. Cumulative interest ends at 5280.15, which is 3.49 more than the correct schedule, because the balance falls more slowly.
Loan summary for Pine Assembly Workshop. The facility terms as a flat object, including the arrangement fee of 480.00 USD with an explicit arrangementFeeIsFinanced flag set to false, so a reader cannot silently add it to the principal. The monthly rate is a string at eight decimal places for the same reason the workbook carries it that way.
Logistics reconciliation assertions for Pine Assembly Workshop. The six identities this set claims with the exact figure each must produce: 683.200 kg gross, 56 parcels, 56 cartons, 861.19 of billable freight and 133.29 of customs charges. It also records the size and cause of both deliberate defects.
Lot genealogy for Pine Assembly Workshop. The chain from purchase to certificate for lot LOT-2026-0912 in 7 records, each naming its parent record and the file that evidences it. Every evidence value that names a file names one that exists in this directory, so the genealogy is walkable rather than decorative.
Manufacturing and quality reconciliation identities for Pine Assembly Workshop. 6 named identities covering the explosion, the cost roll-up, the work order that closes to standard, the routing, the inspection rule including the unilateral tolerance, and the difference between component scrap and finished-goods yield. The deliberate defect and its 4 unit, 0.40 USD shortfall are listed separately.
Material issue list for Pine Assembly Workshop. The 3 leaf components issued to BUILD-1, at the quantities the explosion reaches and the model requires. Issued value is 50.40 USD, which is exactly line 1 of work-order-cost.csv, so the issue list and the cost build-up close on each other. No sub-assembly appears, because BASE and TOP are made on this order rather than issued to it.
