Versions Compared

Old Version 1

changes.mady.by.user Jean-François Cuylits

Saved on

compared with

New Version 2

changes.mady.by.user Jean-François Cuylits

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

WinBooks on Web allows you to import accounting documents of any type (sales invoices & CN, purchase invoices & CN, miscellaneous operations or bank & cash document).

Field name

Type

Length

Dec.

Description

JNLTYPE

jnltype

C

3

0

Type of the journal:

(
  • SAL = sales
,
  • SAC = credit note on sales
,
  • PUR = purchases
,
  • PUC = credit note on purchases
,
  • PRI = principal
,
  • journal (miscellaneous operation)
  • CAS = bank and cash
)
JNL

jnl

C

10

0

Code of the journal

NUMBER

number

N

12

0

Number of the document

RENUMBER

renumber

L

1

0

True (T) if the number must be renumbered (continuing the numbering of the journal in the financial package). 
False

if Flex manage

(F) if your application manages the numbering (which is the fact for the invoices and the credit notes).

If Wow has to renumber your documents, start your numbering to 1 and Wow will add the last number of the journal to your numbers.

ACCOUNTTYP

accountype

C

1

0

Type of account (G = general, C = customer, S = supplier)

ACCOUNTID

accountid

C

10

0

Code (number) of the account

DATE

date

D

8

0

Date of the document (YYYY/MM/DD)

DUEDATE

duedate

D

8

0

Due date (YYYY/MM/DD)

CUR

cur

C

3

0

Code of the currency (optional, blank if the amounts are given only in the base currency)

SIDE

side

C

1

0

D for Debit, C for Credit

AMOUNTCUR

amountcur

N

17

3

Amount in the currency if CUR is supplied

AMOUNT

amount

N

17

3

Amount in the base currency

VATTYPE

vattype

N

1

0

Type of the V.A.T. : 
0 =  normal 
1 =

tax

V.A.T. to book but not to pay (or tax to pay and to receive back; f.i.

EMD21

EM21 in

Cubic

Winbooks on Web) 
2 = 

code

V.A.T. on the discounted basis for cash payment

(f.i. when code is SC or DIS in WinBooks on Web)

vatid

VATID

C

5

6

0

V.A.T. code (internal code

VATPC

of V.A.T. as used in WinBooks classic on WinBooks on Web)

vatpc

N

5

2

V.A.T. %

VATAMTCUR

(Ex: 0.00, 6.00, 21.00)

vatamtcur

N

17

3

Amount of the tax in the supplied

CUR

cur

VATAMT

vatamt

N

17

3

Amount of the tax in the base currency

ANA1

ana1

C

20

0

Analytical code 1

ANA2

ana2

C

20

0

Analytical code 2

ANA3

ana3

C

20

0

Analytical code 3

ANA4

ana4

C

20

0

Analytical code 4

ANA5

ana5

C

20

0

Analytical code 5

ANA6

ana6

C

20

0

Analytical code 6

ANA7

ana7

C

20

0

Analytical code 7

ANA8

ana8

C

20

0

Analytical code 8

ANA9

ana9

C

20

0

Analytical code 9

MATCHJNL

matchjnl

C

10

0

Matching journal (not yet supported)

MATCHNUM

matchnum

N

12

0

Matching number (not yet supported)

EXTNOTE

extnote

C

40

0

External comment

INTNOTE

intnote

C

40

0

Internal comment

 

For the cost accounting (ANA1, ANA2, ...)

...

:

  • if the dimension is of type date, the format has to be YYYY/MM/DD

...

  • if the dimension is number we

...

  • have to use the point as decimal separator (nnnn.nn)

...