FEC | MQL Functions | MentDB Weak

FEC

fec write fec write fec check fec check fec read fec read

fec write <path> <json_rows>

Description

Write a FEC from JSON rows (keys = the column names, case ignored): dates yyyy-MM-dd or AAAAMMJJ written AAAAMMJJ, amounts with a comma and 2 decimals, tab separator, UTF-8; returns the file, the number of lines and warnings

Parameters

path: The FEC file - String - required
json_rows: The accounting entries - String - required

admin
json load "tuto_w" (fec write "tmp/tuto_etl/732829320FEC20261231.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.98, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C002\", \"CompAuxLib\": \"Formation Plus\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 1200, \"Credit\": 0, \"ValidDate\": \"2026-11-04\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 0, \"Credit\": 1200, \"ValidDate\": \"2026-11-04\"}]");
json load "tuto_c" (fec check "tmp/tuto_etl/732829320FEC20261231.txt" "{\"fiscal_year\": {\"start\": \"2026-01-01\", \"end\": \"2026-12-31\"}}");
json load "tuto_r" (fec read "tmp/tuto_etl/732829320FEC20261231.txt");
-> "[res]" (concat (json select "tuto_w" "/lines") " lines written, valid " (json select "tuto_c" "/valid") ", " (json select "tuto_c" "/entries") " entries, debit " (json select "tuto_c" "/total_debit") " = credit " (json select "tuto_c" "/total_credit") ", first account " (json select "tuto_r" "/[0]/CompteNum"));
json unload "tuto_w"; json unload "tuto_c"; json unload "tuto_r";
file delete "tmp/tuto_etl/732829320FEC20261231.txt";
[res]

mentdb
5 lines written, valid true, 2 entries, debit 1537.16 = credit 1537.16, first account 411000

fec write <path> <json_rows> <json_params>

Description

FEC with parameters: separator (tab or |), encoding (UTF-8, windows-1252, ISO-8859-15), line_end (lf or crlf)

Parameters

path: The FEC file - String - required
json_rows: The entries - String - required
json_params: The parameters - String - required

admin
json load "tuto_w" (fec write "tmp/tuto_etl/732829320FEC20261231.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.98, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C002\", \"CompAuxLib\": \"Formation Plus\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 1200, \"Credit\": 0, \"ValidDate\": \"2026-11-04\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 0, \"Credit\": 1200, \"ValidDate\": \"2026-11-04\"}]" "{\"separator\": \"|\", \"encoding\": \"windows-1252\", \"line_end\": \"crlf\"}");
json load "tuto_c" (fec check "tmp/tuto_etl/732829320FEC20261231.txt");
-> "[res]" (concat (json select "tuto_w" "/encoding") ": " (json select "tuto_c" "/lines") " lines read with the separator " (json select "tuto_c" "/separator") ", valid " (json select "tuto_c" "/valid"));
json unload "tuto_w"; json unload "tuto_c";
file delete "tmp/tuto_etl/732829320FEC20261231.txt";
[res]

mentdb
windows-1252: 5 lines read with the separator |, valid true

Used in use cases (1 recipe)

Accountant & manager › Fichier des Écritures Comptables: write the FEC of the year and check it before the tax audit

Often used with

equal · fec check · file delete · file exist · file mkdir

fec check <path>

Description

Check a FEC: header (names and order of the 18 columns), number of columns, mandatory fields, dates, amounts, balance of each entry (journal + EcritureNum) and of the file, ValidDate, continuity of the numbering per journal, file name; valid, totals, errors and warnings with the line and the rule, totals per journal

Parameters

path: The FEC file - String - required

admin
fec write "tmp/tuto_etl/732829320FEC20261231.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.89, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE4\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C002\", \"CompAuxLib\": \"Formation Plus\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 1200, \"Credit\": 0, \"ValidDate\": \"2026-11-04\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE4\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 0, \"Credit\": 1200, \"ValidDate\": \"2026-11-04\"}]";
-> "[res]" (fec check "tmp/tuto_etl/732829320FEC20261231.txt");
file delete "tmp/tuto_etl/732829320FEC20261231.txt";
[res]

mentdb
{"valid": false, "lines": 5, "entries": 2, "total_debit": 1537.16, "total_credit": 1537.07, "balanced": false, "encoding": "UTF-8", "separator": "tab", "error_count": 2, "errors": [{"line": 2, "rule": "BALANCE", "message": "the entry VE1 of the journal VE is not balanced (debit - credit = 0.09)"}, {"rule": "BALANCE", "message": "the FEC is not balanced: total debit 1537.16, total credit 1537.07"}], "warning_count": 1, "warnings": [{"rule": "NUMBERING", "message": "journal VE: 2 missing number(s) in EcritureNum VE1 to VE4 (first: VE2, VE3)"}], "journals": [{"code": "VE", "entries": 2, "debit": 1537.16, "credit": 1537.07}]}

fec check <path> <json_params>

Description

Check with parameters: fiscal_year {start, end} (the EcritureDate must be inside), max_errors (500), encoding, separator

Parameters

path: The FEC file - String - required
json_params: The parameters - String - required

admin
fec write "tmp/tuto_etl/732829320FEC20261031.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.98, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C002\", \"CompAuxLib\": \"Formation Plus\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 1200, \"Credit\": 0, \"ValidDate\": \"2026-11-04\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 0, \"Credit\": 1200, \"ValidDate\": \"2026-11-04\"}]";
-> "[res]" (fec check "tmp/tuto_etl/732829320FEC20261031.txt" "{\"fiscal_year\": {\"start\": \"2025-11-01\", \"end\": \"2026-10-31\"}, \"max_errors\": 3}");
file delete "tmp/tuto_etl/732829320FEC20261031.txt";
[res]

mentdb
{"valid": false, "lines": 5, "entries": 2, "total_debit": 1537.16, "total_credit": 1537.16, "balanced": true, "encoding": "UTF-8", "separator": "tab", "error_count": 5, "errors": [{"line": 2, "rule": "FISCAL-YEAR", "message": "EcritureDate 2026-11-03 is after the fiscal year (2026-10-31)"}, {"line": 3, "rule": "FISCAL-YEAR", "message": "EcritureDate 2026-11-03 is after the fiscal year (2026-10-31)"}, {"line": 4, "rule": "FISCAL-YEAR", "message": "EcritureDate 2026-11-03 is after the fiscal year (2026-10-31)"}], "warning_count": 0, "warnings": [], "journals": [{"code": "VE", "entries": 2, "debit": 1537.16, "credit": 1537.16}]}

Used in use cases (1 recipe)

Accountant & manager › Fichier des Écritures Comptables: write the FEC of the year and check it before the tax audit

Often used with

equal · fec write · file delete · file exist · file mkdir

fec read <path>

Description

Read a FEC (tab or | detected, UTF-8 or windows-1252 detected) into JSON rows: dates yyyy-MM-dd, amounts as numbers (the variant Montant + Sens gives Debit and Credit)

Parameters

path: The FEC file - String - required

admin
fec write "tmp/tuto_etl/732829320FEC20261231.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.98, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C002\", \"CompAuxLib\": \"Formation Plus\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 1200, \"Credit\": 0, \"ValidDate\": \"2026-11-04\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE2\", \"EcritureDate\": \"2026-11-04\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0043\", \"PieceDate\": \"2026-11-04\", \"EcritureLib\": \"Invoice F2026-0043\", \"Debit\": 0, \"Credit\": 1200, \"ValidDate\": \"2026-11-04\"}]";
-> "[rows]" (fec read "tmp/tuto_etl/732829320FEC20261231.txt");
file delete "tmp/tuto_etl/732829320FEC20261231.txt";
[rows]

mentdb
[{"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "411000", "CompteLib": "Clients", "CompAuxNum": "C001", "CompAuxLib": "Client SAS", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 337.16, "Credit": 0, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "706000", "CompteLib": "Prestations", "CompAuxNum": "", "CompAuxLib": "", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 0, "Credit": 312.98, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "445710", "CompteLib": "TVA collectee", "CompAuxNum": "", "CompAuxLib": "", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 0, "Credit": 24.18, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE2", "EcritureDate": "2026-11-04", "CompteNum": "411000", "CompteLib": "Clients", "CompAuxNum": "C002", "CompAuxLib": "Formation Plus", "PieceRef": "F2026-0043", "PieceDate": "2026-11-04", "EcritureLib": "Invoice F2026-0043", "Debit": 1200, "Credit": 0, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-04", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE2", "EcritureDate": "2026-11-04", "CompteNum": "706000", "CompteLib": "Prestations", "CompAuxNum": "", "CompAuxLib": "", "PieceRef": "F2026-0043", "PieceDate": "2026-11-04", "EcritureLib": "Invoice F2026-0043", "Debit": 0, "Credit": 1200, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-04", "Montantdevise": null, "Idevise": ""}]

fec read <path> <json_params>

Description

Read with parameters: encoding, separator

Parameters

path: The FEC file - String - required
json_params: The parameters - String - required

admin
fec write "tmp/tuto_etl/732829320FEC20261231.txt" "[{\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"411000\", \"CompteLib\": \"Clients\", \"CompAuxNum\": \"C001\", \"CompAuxLib\": \"Client SAS\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 337.16, \"Credit\": 0, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"706000\", \"CompteLib\": \"Prestations\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 312.98, \"ValidDate\": \"2026-11-03\"}, {\"JournalCode\": \"VE\", \"JournalLib\": \"Ventes\", \"EcritureNum\": \"VE1\", \"EcritureDate\": \"2026-11-03\", \"CompteNum\": \"445710\", \"CompteLib\": \"TVA collectee\", \"CompAuxNum\": \"\", \"CompAuxLib\": \"\", \"PieceRef\": \"F2026-0042\", \"PieceDate\": \"2026-11-03\", \"EcritureLib\": \"Invoice F2026-0042\", \"Debit\": 0, \"Credit\": 24.18, \"ValidDate\": \"2026-11-03\"}]" "{\"encoding\": \"windows-1252\"}";
-> "[rows]" (fec read "tmp/tuto_etl/732829320FEC20261231.txt" "{\"encoding\": \"windows-1252\"}");
file delete "tmp/tuto_etl/732829320FEC20261231.txt";
[rows]

mentdb
[{"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "411000", "CompteLib": "Clients", "CompAuxNum": "C001", "CompAuxLib": "Client SAS", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 337.16, "Credit": 0, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "706000", "CompteLib": "Prestations", "CompAuxNum": "", "CompAuxLib": "", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 0, "Credit": 312.98, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}, {"JournalCode": "VE", "JournalLib": "Ventes", "EcritureNum": "VE1", "EcritureDate": "2026-11-03", "CompteNum": "445710", "CompteLib": "TVA collectee", "CompAuxNum": "", "CompAuxLib": "", "PieceRef": "F2026-0042", "PieceDate": "2026-11-03", "EcritureLib": "Invoice F2026-0042", "Debit": 0, "Credit": 24.18, "EcritureLet": "", "DateLet": null, "ValidDate": "2026-11-03", "Montantdevise": null, "Idevise": ""}]