Versions Compared

Key

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

...

Field name

Type

Length

Dec.

Description

bookyearN4
Related year of the book period
bookmonthN2
Related month of the book period (0=open, 1=jan, 2=feb, ..., 12=dec, 13=close)

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

C

10

0

Code of the journal

number

N

12

0

Number of the document

renumber

L

1

0

True (T) if the number must be renumbered (continuing the numbering of the journal in the financial package). 
False (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

C

1

0

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

accountid

C

10

0

Code (number) of the account

date

D

8

0

Date of the document (YYYY/MM/DD)

duedate

D

8

0

Due date (YYYY/MM/DD)

cur

C

3

0

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

side

C

1

0

D for Debit, C for Credit

amountcur

N

17

3

Amount in the currency if CUR is supplied

amount

N

17

3

Amount in the base currency

vattype

N

1

0

Type of the V.A.T. : 
0 =  normal 
1 = V.A.T. to book but not to pay (or tax to pay and to receive back; f.i. EM21 in Winbooks on Web) 
2 =  V.A.T. on the discounted basis for cash payment (f.i. when code is SC or DIS in WinBooks on Web)

vatid

C

6

0

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

vatpc

N

5

2

V.A.T. % (Ex: 0.00, 6.00, 21.00)

vatamtcur

N

17

3

Amount of the tax in the supplied cur

vatamt

N

17

3

Amount of the tax in the base currency

dedrateN52Currency Deductibility rate

ana1

C

20

0

Analytical code 1

ana2

C

20

0

Analytical code 2

ana3

C

20

0

Analytical code 3

ana4

C

20

0

Analytical code 4

ana5

C

20

0

Analytical code 5

ana6

C

20

0

Analytical code 6

ana7

C

20

0

Analytical code 7

ana8

C

20

0

Analytical code 8

ana9

C

20

0

Analytical code 9

matchnum

N

12

0

Matching number (not yet supported)

intnote

C

40

0

Internal comment

extnote

C

40

0

External comment

structcomC120Structured communication without the formatting chars 999999999999
costcomC400Analytical comment

...