Field name | Type | Length | Dec. | Description |
---|---|---|---|---|
JNLTYPE | C | 3 | 0 | Type of the journal |
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). |
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. : |
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 |
For cost accounting (ANA1, ANA2, ...), if the dimension is date, the format has to be YYYY/MM/DD and if the dimension is number we will use the point as decimal separator (nnnn.nn).