Syntha Lab RU

Purchase orders

Order lines to a factory or supplier: SKU, quantity, price, dates and delivery actuals.

Core data exchange 10 columns 2 example rows

Download CSV ↓

What the template is for

Control of the buying plan, supplier OTIF and lead time.

What one row is
one row = an order line (order × SKU)

Columns

ColumnCodeTypeRequiredValidation rule
Order numberpoTextyesunique in the file
LinelineIntegeryesa number not below 0
SKU codeskuTextyesa value from the reference book
Supplier codesupplierTextyesa value from the reference book
Ordered, pcsqtyIntegeryesan integer above 0
Unit price excl. VATpriceNumberyesa number not below 0
CurrencycurList valueyesan ISO 4217 currency code
Promised delivery datedueDateyesdate YYYY-MM-DD, not in the future
Actual receipt daterecdDatenodate YYYY-MM-DD, not in the future
Received, pcsrecqIntegernoan integer not below 0

Example rows

Order numberLineSKU codeSupplier codeOrdered, pcsUnit price excl. VATCurrencyPromised delivery dateActual receipt dateReceived, pcs
PO-2026-0141A100-BLK-MS0150014.5CNY2026-09-152026-09-22480
PO-2026-0142A100-BLK-LS0150014.5CNY2026-09-152026-09-22500

The example data is illustrative: an exercise, replace it with your own.

Note

OTIF is counted by lines: on time and in full. The tolerance on date and quantity is set by the contract: there is no single standard.

How to open the file

The file is UTF-8 with a BOM, comma separated, with a decimal point. Set the text format for code columns (SKU, article, GTIN) so that long numbers and leading zeros are not distorted. The validation rules are suggested defaults, not norms: your systems and contracts may require something else.

Calculations that use these fields

Documents that need this data

Download CSV ↓ Open interactively →