Navigation:  Printing and exporting documents > Exporting documents >

To any program

Previous pageReturn to chapter overviewNext page

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:

downloaded from a file - a type of document must be compatible with the one existing in System Symfonia program
with symbol – if information about a type of document will be downloaded from the main dialog window of a module/report and not from a file,a field needs to be left empty

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

E-mail

biuro@nokia.pl

E-mail

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

E-mail

mPunkt@mPunkt.pl

E-mail

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.