Page History

Field name

Type

Length

Dec.

Description

TYPE

C

1

C for customer, S for supplier

ID

C

10

Code of the third (account number)

NAME

C

40

Name of the company

CONTACT

C

40

Name of the person to contact

LANGUAGE

C

1

Language code

CURRID

C

3

Currency code mostly used by the third

CATEGORY

C

10

Category of the third (free use)

PAYDELAY

C

10

Payment delay (number of days followed by E for End of month or F for Fin de mois : f.i. 30E, 60, …)

PAYMODE

C

10

Code for the way of payment

VATTYPE

C

1

V.A.T. type code (bound, unbound, exempt, …)

VATNUMBER

C

20

V.A.T. number (without the country code)

VATCOUNTRY

C

2

V.A.T. country (code ISO2)

VATID

C

10

V.A.T. code by default (21, 6, 0, IEXP, ECEE, …)

VATPC

N

5

2

V.A.T. % corresponding or bounded to the V.A.T. code

CENTACCID

C

10

General account (400000 f.i.) bounded to the third if the third is not bounded to the default general account for the customers or the suppliers.

PARTACCID

C

10

AGENT

C

10

Code of the agent (account manager) in charge with the third

ADRCOUNTRY

C

2

Code ISO2 of the country (BE, FR, DE, …)

ADRZIP

C

10

Zip code

ADRCITY

C

40

City

ADRSTREET1

C

40

Street

ADRSTREET2

C

40

Street 2

PHONE1

C

20

Phone number

PHONE2

C

20

Phone number 2

FAX

C

20

Fax number

EMAIL

C

40

E-mail address

BANK1

C

20

Bank number

BANK2

C

20

Bank name

MEMO

M

4

Comment

Field name

Type

Length

Dec.

Description

JNLTYPE

C

3

0

Type of the journal (SAL = sales, SAC = credit note on sales, PUR = purchases, PUC = credit note on purchases, PRI = principal, CAS = cash)

JNL

C

10

0

Code of the journal

NUMBER

N

12

0

Number of the document

RENUMBER

L

1

0

True if the number must be renumbered (continuing the numbering of the journal in the financial package). False if Flex manage the numbering (which is the fact for the invoices and the credit notes).

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 = tax to book but not to pay (or tax to pay and to receive back; f.i. EMD21 in Cubic) 2 =  code V.A.T. on the discounted basis for cash payment

VATID

C

5

0

V.A.T. code

VATPC

N

5

2

V.A.T. %

VATAMTCUR

N

17

3

Amount of the tax in the supplied CUR

VATAMT

N

17

3

Amount of the tax in the base currency

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

MATCHJNL

C

10

0

Matching journal

MATCHNUM

N

12

0

Matching number

EXTNOTE

C

40

0

External comment

INTNOTE

C

40

0

Internal comment