Syntha Lab RU

Customers and points of sale

A reference of wholesale customers and stores: code, type, channel, region, payment terms.

Core data exchange 8 columns 2 example rows

Download CSV ↓

What the template is for

The order book, receivables, allocation to stores.

What one row is
one row = a customer or a point

Columns

ColumnCodeTypeRequiredValidation rule
Customer or point codecodeTextyesunique in the file
NamenameTextyesnot empty
TypetypeList valueyeswholesale, own store, platform, franchise
ChannelchannelList valueyesa value from the reference book
RegionregionList valuenoa value from the reference book
Payment term, daystermsIntegernoan integer not below 0
Credit limit excl. VATlimitNumbernoa number not below 0
E-document operatoredoTextnooperator name; check roaming

Example rows

Customer or point codeNameTypeChannelRegionPayment term, daysCredit limit excl. VATE-document operator
C001Store Awholesalemulti-brandMSK303,000,000op1
ST07Own store 7own storeretailSPB00

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

Note

Do not include personal data of individuals: for consumers keep only a pseudonymous identifier.

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 →