Supplier terms
Minimum order, lead time, payment and currency by supplier.
What the template is for
Comparing offers, lead-time and cash calculations.
- What one row is
- one row = supplier × type of terms
Columns
| Column | Code | Type | Required | Validation rule |
|---|---|---|---|---|
| Supplier code | supplier | Text | yes | unique in the file |
| Name | name | Text | yes | not empty |
| Country | country | List value | yes | an ISO 3166 country code |
| Minimum order, pcs | moq | Integer | no | an integer not below 0 |
| Lead time order to warehouse, days | lead | Integer | yes | an integer not below 0 |
| Prepayment, % | prepay | Number | yes | from 0 to 100 |
| Credit days after delivery | days | Integer | no | an integer not below 0 |
| Contract currency | cur | List value | yes | an ISO 4217 currency code |
Example rows
| Supplier code | Name | Country | Minimum order, pcs | Lead time order to warehouse, days | Prepayment, % | Credit days after delivery | Contract currency |
|---|---|---|---|---|---|---|---|
| S01 | Factory 1 | CN | 300 | 90 | 30 | 0 | CNY |
| S02 | Factory 2 | RU | 100 | 45 | 0 | 14 | RUB |
The example data is illustrative: an exercise, replace it with your own.
Note
Payments abroad and import depend on the measures in force: check them with the bank and a lawyer.
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
- Sourcing from factories: CMT, FOB, OEM/ODM, full cost and lead times
- AQL and batch quality inspection
- Commercial terms: payment terms, retro bonuses, MDF and listing fees, SLA penalties, chargebacks
- Bankruptcy and subsidiary liability: what the owner of a brand and a retailer needs to know
- Business continuity plan (BCP) and crisis measures
- 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
- Consolidation of several legal entities, intercompany and transfer pricing
- Brand and retailer contracts: supply, commission, consignment, agency, dropshipping
- Foreign trade and customs: HS code, customs value, duty, import VAT, landed cost, currency control