Syntha Lab RU

Supplier terms

Minimum order, lead time, payment and currency by supplier.

Core data exchange 8 columns 2 example rows

Download CSV ↓

What the template is for

Comparing offers, lead-time and cash calculations.

What one row is
one row = supplier × type of terms

Columns

ColumnCodeTypeRequiredValidation rule
Supplier codesupplierTextyesunique in the file
NamenameTextyesnot empty
CountrycountryList valueyesan ISO 3166 country code
Minimum order, pcsmoqIntegernoan integer not below 0
Lead time order to warehouse, daysleadIntegeryesan integer not below 0
Prepayment, %prepayNumberyesfrom 0 to 100
Credit days after deliverydaysIntegernoan integer not below 0
Contract currencycurList valueyesan ISO 4217 currency code

Example rows

Supplier codeNameCountryMinimum order, pcsLead time order to warehouse, daysPrepayment, %Credit days after deliveryContract currency
S01Factory 1CN30090300CNY
S02Factory 2RU10045014RUB

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

Download CSV ↓ Open interactively →