The structure of the data file - import - on-line shop
ver. 2009-06-16
[Document]
Field's no. |
Field's name |
Value |
Description |
||||
1 |
Sale document type |
FVS, PAR, ZMO |
A type of imported document - if in the main directory we select:
|
||||
2 |
Serial number |
sFVS, sPAR, sZMO |
A serial of an issued document, closely related to a type of document - an optional field |
||||
3 |
Prices on document |
0 / 1 |
Determination of the kind of prices in which a document is supposed to be issued – an optional field (by default, the prices compatible with the settings of System Symfonia are selected): 0 – a document issued in NET prices 1 – a document issued in GROSS prices |
||||
4 |
Reservation to the document |
0 / 1 / 2 |
Are products to be reserved?
0 – NO – it does not provide a reservation on a document, the product trade status will remain unchanged, 1 – YES – it provides a quantitative reservation on a document, the product trade status will be reduced 2 – YES – it provides a reservation with indication of supplies (FIFO) to document, the product trade status will be reduced |
||||
5 |
Date of issue |
2009-07-31 |
The date of issue of a document in a format YYYY-MM-DD |
||||
6 |
Date of sale |
2009-08-05 |
The date of sale in a format YYYY-MM-DD |
||||
7 |
Description of document |
Description of document |
The description of a document, a maximum of 80 characters |
||||
8 |
Warehouse code |
MAG |
A code of a warehouse in which a document is supposed to be issued, it must be compatible with a warehouse in System Symfonia program |
||||
9 |
Payment record |
BANK KASA INNE |
A register of payment issued together with a document, it must be compatible with the register in System Symfonia program |
||||
10 |
Form of payment |
bank transfer 14 days advance payment 7 days cash 0 days |
A form of payment issued together with a document, it must be compatible with the one existing in System Symfonia program, a value of the field must be appropriately organized:
[name of form] + " " + [number of days] + " " days
if there are three forms of payment and each of them is called 'bank transfer' and they have various number of days (e.g. 7, 14, 21), the value of the field is to be set as the following:
bank transfer 7 days bank transfer 14 days bank transfer 21 days
If in an advance payment form a number of days is 0 it looks like the following:
advance payment |
||||
11 |
Payment deadline |
2009-08-15 |
Payment deadline |
||||
12 |
Marker number |
0, 65, 66, 67… |
A document is marked with a given marker number, specific to a given document type. A marker is determined as follows: 0 for an empty marker 65, 66, 67,... for the subsequent markers If a marker with a given number does not exist, a document will be marked with an empty marker. It is enough to fill in only one field (Marker number or Marker name). |
||||
13 |
Marker name |
label A label B … |
A document is marked with a given marker name, specific to a given document type, if a marker with a given name does not exist, a document will be marked with an empty market. It is enough to fill in only one field (Marker number or Marker name). |
||||
14 |
Directory name |
\@Dokumenty sprzedaży\@Internet\@Kraków |
The name of directory of sale documents, in which a document is placed; Directory name has the following format: [\@Sub-directoryNameN], where [\@Sub-directoryNameN] may appear once ore more often; if a directory does not exist, it is created. |
||||
15 |
Type name |
On-line sale |
A name of sale documents type, which will be assigned to the document; if a type does not exist, it is created. |
||||
16 |
Note to a document (in a separate line) |
Note to a document |
This information appears in a Note to a document, a maximum of 8192 characters. |
Demonstration data:
FVS;sFVS;0;Y;2009-07-31;2009-08-05;Description of document;MAG;BANK PKO;bank transfer 14 days;2009-08-15;65;label A;\@Dokumenty sprzedaży\@Internet\@Kraków;On-line sale;
Note to a document, please provide a delivery between 10am to 2pm.
[Trading partner - Purchaser]
Field No. |
Field name |
Value |
Description |
1 |
Adding a trading partner - purchaser |
Y / N |
Is a trading partner - purchaser supposed to be added? Y – YES - a trading partner is searched for in System Symfonia Handel (English: Trade) program, on the basis of Vat No. field and Code/Index field: - if the trading partner is found in the program, they are placed in a document (Vat No. and Code/Index fields are taken from a file), - if the trading partner is not found in the program, they are added to it and placed in a document (all data describing trading partner are taken from the file, including those in red).
N – NO - a trading partner is searched for in System Symfonia Handel (English: Trade) program, on the basis of Vat No. field and Code/Index field: - if the trading partner is found in the program, they are placed in a document (Vat No. and Code/Index fields are taken from the file), - if the trading partner is not found in the program, they are placed in a document as so-called INCIDENTAL trading partner, they will not be added to trading partners' base (all data describing trading partner are taken from a file, including those in red). |
2 |
Updating a trading partner - purchaser |
Y / N |
Is a trading partner - purchaser supposed to be updated?
Y – YES – trading partner's data are updated when there is a difference between the data included in System Symfonia program and the ones in file (if the data in file are not filled, the report will skip them and will not update them in Symfonia),
N – NO – trading partner's data are not updated, they remain in an unchanged form. |
3 |
Code/Index |
NOKIA |
Trading partner's code/Abbreviation/Index - if you import trading partners who are registered in System Symfonia program, this field is sufficient to issue documents provided that there is compliance of data in the program, red fields may be omitted, this field is a replacement for Vat No. field. |
4 |
Vat No. |
000-000-00-00 |
Vat No. - optional field, if there is no trading partner's code, this field is used to search for the trading partner and to organize files |
5 |
Name |
NOKIA Poland |
Trading partner's name |
6 |
Address |
Sienna 73 |
Street and number |
7 |
Postal code |
00-833 |
Postal code |
8 |
City |
Warszawa |
City |
9 |
Telephone 1 |
(022) 821-82-10 |
Telephone number |
10 |
Telephone 2 |
(022) 203-03-10 |
Telephone number |
11 |
FAX |
(022) 203-03-11 |
FAX number |
12 |
biuro@nokia.pl |
||
13 |
Website |
www.nokia.pl |
Web address |
14 |
Marker number |
0, 65, 66, 67… |
A trading partner is marked with a given marker number. A marker is determined as follows: 0 for an empty marker 65, 66, 67,... for the subsequent markers If a marker with a given number does not exist, a trading partner is marked with an empty marker. |
Demonstration data:
T;N;NOKIA;000-000-00-00;Nokia Poland;Sienna 73;00-833;Warszawa;(022) 821-82-10;(022) 203-03-10; (022) 203-03-11;biuro@nokia.pl;www.nokia.pl;65;
[Trading partner - recipient]
Field No. |
Field name |
Value |
Description |
1 |
Adding a trading partner - recipient |
Y / N |
Is a trading partner - recipient supposed to be added?
Y – YES - a trading partner is searched for in System Symfonia Handel (English: Trade) program, on the basis of Vat No. field and Code/Index field: - if the trading partner is found in the program, they are placed in a document (Vat No. and Code/Index fields are taken from the file), - if the trading partner is not found in the program, they are added to it and placed in a document (all data describing trading partner are taken from the file, including those in red).
N – NO - a trading partner is searched for in System Symfonia Handel (English: Trade) program, on the basis of Vat No. field and Code/Index field: - if the trading partner is found in the program, they are placed in a document (Vat No. and Code/Index fields are taken from the file), - if the trading partner is not found in the program, they are placed in a document as so-called INCIDENTAL trading partner, they will not be added to trading partners' base (all data describing trading partner are taken from a file, including those in red). |
2 |
Updating a trading partner - recipient |
Y / N |
Is a trading partner - recipient supposed to be updated?
Y – YES – trading partner's data are updated when there is a difference between the data included in System Symfonia program and the ones in file (if the data in file are not filled, the report will skip them and will not update them in Symfonia),
N – NO – trading partner's data are not updated, they remain in an unchanged form. |
3 |
Code/Index |
mPunkt |
Trading partner's code/Abbreviation/Index - if you import trading partners who are registered in System Symfonia program, this field is sufficient to issue documents provided that there is compliance of data in the program, red fields may be omitted, this field is a replacement for Vat No. field. |
4 |
Vat No. |
813-30-61-246 |
Vat No. - optional field, if there is no trading partner's code, this field is used to search for the trading partner and to organize files |
5 |
Name |
mPunkt Polska SA |
Trading partner's name |
6 |
Address |
Domaniewska 37 |
Street and number |
7 |
Postal code |
02-672 |
Postal code |
8 |
City |
Warszawa |
City |
9 |
Telephone 1 |
(022) 337 86 30 |
Telephone number |
10 |
Telephone 2 |
Telephone number |
|
11 |
FAX |
(022) 337 86 36 |
FAX number |
12 |
mPunkt@mPunkt.pl |
||
13 |
Website |
www.mPunkt.pl |
Web address |
14 |
Marker number |
0, 65, 66, 67… |
A trading partner is marked with a given marker number. A marker is determined as follows: 0 for an empty marker 65, 66, 67,... for the subsequent markers If a marker with a given number does not exist, a trading partner is marked with an empty marker. |
Demonstration data:
T;T;mPunkt;813-30-61-246;mPunkt Polska SA;Domaniewska 37;02-672;Warszawa;(022) 337 86 30;;(022) 337 86 36;mPunkt@mPunkt.pl;www.mPunkt.pl;66;
[Positions]
Field No. |
Field name |
Value |
Description |
1 |
Code / shortcut / index |
HMP2008-3st |
Product code/abbreviation/index must be compatible with the one Symfonia Trade program |
2 |
Quantity |
2 |
A quantity of product in a sales unit |
3 |
Sale price |
1290,00 |
A product NET/GROSS sale price in an on-line shop (prices according to the settings in Documnet - Prices in document) or 0/empty if a price is to be downloaded from System Symfonia lists of prices in accordance with customer's trade policy |
4 |
Product name |
Symfonia Trade Premium 2008 3-workplace version |
Product name of any content and length |
5 |
Measurement unit |
pcs, kg, l, t… |
Measurement unit, any, it does not have to exist in System Symfonia program. |
6 |
Bar code |
5900259017222 59017222 ABC123DEF456GHI789 |
Product bar code in any standard (EAN13, EAN8, EAN 128/CODE 128), also own bar codes and other data at your own discretion |
7 |
Sale VAT |
0, 3, 7, 22, ZW, NP |
VAT rate of sale of products, it must be compatible with the ones existing in System Symfonia program (NP – not applicable. used e.g. for returnable packaging, a value of this position is not placed in VAT imprint and VAT registry of sales) |
8 |
Polish Classification of Goods and Services |
01234-56789 |
PKWiU of a product, required for products of different than 22 NP rate |
9 |
Marker number |
0, 65, 66, 67… |
A product is marked with a given marker number. A marker is determined as follows: 0 for an empty marker 65, 66, 67,... for the subsequent markers If a marker with a given number does not exist, a trading partner is marked with an empty marker. |
Demonstration data:
STP2008-3v;2;1290;Symfonia Trade Premium 2008 3-workplace version;pcs;5900259017222;22;;0;
NPH-E50;1;399.00;Nokia E50 mobile phone;pcs;5900259017227;22;;65;
NPH-6230i;2;99.99;Nokia 6230i silver mobile phone;pcs;5900259017234;22;;66;
UNIV-CH;10;9.99;Universal charger for Nokia;pcs;5900259017241;7;01234-56789;67;
Comments:
- Polish characters encoding in Windows standard, Codepage 1250
- field separator is a semicolon ";", in the input data this sign cannot appear, it needs to be replaced with e.g. comma "," or another.