Purchase orders
Order lines to a factory or supplier: SKU, quantity, price, dates and delivery actuals.
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
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Order number | po | Text | yes | unique in the file |
| Line | line | Integer | yes | a number not below 0 |
| SKU code | sku | Text | yes | a value from the reference book |
| Supplier code | supplier | Text | yes | a value from the reference book |
| Ordered, pcs | qty | Integer | yes | an integer above 0 |
| Unit price excl. VAT | price | Number | yes | a number not below 0 |
| Currency | cur | List value | yes | an ISO 4217 currency code |
| Promised delivery date | due | Date | yes | date YYYY-MM-DD, not in the future |
| Actual receipt date | recd | Date | no | date YYYY-MM-DD, not in the future |
| Received, pcs | recq | Integer | no | an integer not below 0 |
Example rows
| Order number | Line | SKU code | Supplier code | Ordered, pcs | Unit price excl. VAT | Currency | Promised delivery date | Actual receipt date | Received, pcs |
|---|---|---|---|---|---|---|---|---|---|
| PO-2026-014 | 1 | A100-BLK-M | S01 | 500 | 14.5 | CNY | 2026-09-15 | 2026-09-22 | 480 |
| PO-2026-014 | 2 | A100-BLK-L | S01 | 500 | 14.5 | CNY | 2026-09-15 | 2026-09-22 | 500 |
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
- Open-to-buy budget (OTB)
- Sourcing from factories: CMT, FOB, OEM/ODM, full cost and lead times
- Brand and retailer contracts: supply, commission, consignment, agency, dropshipping
- Allocation and replenishment
- AQL and batch quality inspection
- Management balance sheet
- Budget: P&L, cash, purchase, marketing, payroll and CAPEX budgets
- A buyer session: the brand scorecard, the agenda and the order terms
- Cash flow statement: direct and indirect method
- Supply chain due diligence: the map of links, risk by link, factory admission and a corrective plan
- Collection calendar (critical path) and lead time
- The swatch and trim card and the materials order: the composition of the card, consumption, losses and shrinkage, packing and the minimum lot, the order date, approval and the table template