===== 1. payment_various accountancy_code=401 =====
SELECT pv.rowid,pv.datep,pv.amount,pv.accountancy_code,pv.subledger_account,pv.label,pv.sens,pv.fk_bank,pv.entity,bu.fk_bank AS bu_fk_bank,bu.type FROM llx_payment_various pv LEFT JOIN llx_bank_url bu ON bu.url_id=pv.rowid AND bu.type='payment_various' WHERE pv.accountancy_code='401'
{"rowid":"69","datep":"2026-01-09","amount":"225.84000000","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","sens":"0","fk_bank":"404","entity":"1","bu_fk_bank":"404","type":"payment_various"}
{"rowid":"70","datep":"2026-01-12","amount":"1334.74000000","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","sens":"0","fk_bank":"405","entity":"1","bu_fk_bank":"405","type":"payment_various"}
{"rowid":"71","datep":"2026-01-12","amount":"2688.00000000","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","sens":"0","fk_bank":"406","entity":"1","bu_fk_bank":"406","type":"payment_various"}
{"rowid":"80","datep":"2026-04-17","amount":"5.99000000","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","sens":"0","fk_bank":"415","entity":"1","bu_fk_bank":"415","type":"payment_various"}
{"rowid":"84","datep":"2026-05-18","amount":"5.99000000","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","sens":"0","fk_bank":"419","entity":"1","bu_fk_bank":"419","type":"payment_various"}
{"rowid":"90","datep":"2026-06-17","amount":"5.99000000","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","sens":"0","fk_bank":"425","entity":"1","bu_fk_bank":"425","type":"payment_various"}
{"rowid":"95","datep":"2026-07-17","amount":"5.99000000","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","sens":"0","fk_bank":"430","entity":"1","bu_fk_bank":"430","type":"payment_various"}
-- 7 ligne(s)

===== 2. payment_various sens=0 par compte =====
SELECT accountancy_code, COUNT(*) nb, ROUND(SUM(amount),2) tot FROM llx_payment_various WHERE sens=0 GROUP BY accountancy_code ORDER BY tot DESC
{"accountancy_code":"44551","nb":"6","tot":"19823"}
{"accountancy_code":"444","nb":"3","tot":"6577"}
{"accountancy_code":"401","nb":"7","tot":"4272.54"}
{"accountancy_code":"616","nb":"44","tot":"2295.22"}
{"accountancy_code":"4091","nb":"1","tot":"1795.2"}
{"accountancy_code":"641","nb":"1","tot":"1627.13"}
{"accountancy_code":"471","nb":"7","tot":"908.91"}
{"accountancy_code":"627","nb":"14","tot":"573.7"}
{"accountancy_code":"6611","nb":"10","tot":"551.91"}
{"accountancy_code":"455","nb":"1","tot":"500"}
{"accountancy_code":"6063","nb":"4","tot":"362.33"}
{"accountancy_code":"6061","nb":"2","tot":"291.56"}
{"accountancy_code":"6354","nb":"1","tot":"225.77"}
{"accountancy_code":"6064","nb":"3","tot":"90.71"}
{"accountancy_code":"6251","nb":"1","tot":"7.3"}
-- 15 ligne(s)

===== 2b. payment_various tous sens =====
SELECT sens, accountancy_code, COUNT(*) nb, ROUND(SUM(amount),2) tot FROM llx_payment_various GROUP BY sens,accountancy_code ORDER BY sens,tot DESC
{"sens":"0","accountancy_code":"44551","nb":"6","tot":"19823"}
{"sens":"0","accountancy_code":"444","nb":"3","tot":"6577"}
{"sens":"0","accountancy_code":"401","nb":"7","tot":"4272.54"}
{"sens":"0","accountancy_code":"616","nb":"44","tot":"2295.22"}
{"sens":"0","accountancy_code":"4091","nb":"1","tot":"1795.2"}
{"sens":"0","accountancy_code":"641","nb":"1","tot":"1627.13"}
{"sens":"0","accountancy_code":"471","nb":"7","tot":"908.91"}
{"sens":"0","accountancy_code":"627","nb":"14","tot":"573.7"}
{"sens":"0","accountancy_code":"6611","nb":"10","tot":"551.91"}
{"sens":"0","accountancy_code":"455","nb":"1","tot":"500"}
{"sens":"0","accountancy_code":"6063","nb":"4","tot":"362.33"}
{"sens":"0","accountancy_code":"6061","nb":"2","tot":"291.56"}
{"sens":"0","accountancy_code":"6354","nb":"1","tot":"225.77"}
{"sens":"0","accountancy_code":"6064","nb":"3","tot":"90.71"}
{"sens":"0","accountancy_code":"6251","nb":"1","tot":"7.3"}
{"sens":"1","accountancy_code":"455","nb":"4","tot":"11209.2"}
{"sens":"1","accountancy_code":"44567","nb":"3","tot":"10117"}
{"sens":"1","accountancy_code":"471","nb":"4","tot":"340.93"}
{"sens":"1","accountancy_code":"6354","nb":"1","tot":"32.57"}
{"sens":"1","accountancy_code":"4091","nb":"1","tot":"26.4"}
-- 20 ligne(s)

===== 3. total 401 =====
SELECT COUNT(*) nb, ROUND(SUM(amount),2) tot FROM llx_payment_various WHERE accountancy_code='401'
{"nb":"7","tot":"4272.54"}
-- 1 ligne(s)

===== 4. facture_fourn ref_supplier exacts =====
SELECT rowid,ref,ref_supplier,fk_soc,datef,total_ttc,fk_statut,paye FROM llx_facture_fourn WHERE ref_supplier IN ('12/06','11/13','11/10')
-- 0 ligne(s)

===== 4b. facture_fourn LIKE =====
SELECT rowid,ref,ref_supplier,fk_soc,datef,total_ttc,fk_statut,paye FROM llx_facture_fourn WHERE ref_supplier LIKE '%12/06%' OR ref_supplier LIKE '%11/13%' OR ref_supplier LIKE '%11/10%' OR ref LIKE '%12/06%' OR ref LIKE '%11/13%' OR ref LIKE '%11/10%'
-- 0 ligne(s)

===== 4c. volumetrie facture_fourn =====
SELECT COUNT(*) nb, MIN(datef) mn, MAX(datef) mx, ROUND(SUM(total_ttc),2) tot FROM llx_facture_fourn WHERE entity=1
{"nb":"256","mn":"2026-01-01","mx":"2026-10-20","tot":"293843.83"}
-- 1 ligne(s)

===== 5. lignes banque 404,405,406 =====
SELECT b.rowid,b.dateo,b.datev,b.amount,b.label,b.num_releve,b.rappro,b.fk_account,b.fk_type FROM llx_bank b WHERE b.rowid IN (404,405,406)
{"rowid":"404","dateo":"2026-01-09","datev":"2026-01-09","amount":"-225.84000000","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","num_releve":"202601","rappro":"1","fk_account":"1","fk_type":"VIR"}
{"rowid":"405","dateo":"2026-01-12","datev":"2026-01-12","amount":"-1334.74000000","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","num_releve":"202601","rappro":"1","fk_account":"1","fk_type":"VIR"}
{"rowid":"406","dateo":"2026-01-12","datev":"2026-01-12","amount":"-2688.00000000","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","num_releve":"202601","rappro":"1","fk_account":"1","fk_type":"VIR"}
-- 3 ligne(s)

===== 6. bank_url des 3 lignes =====
SELECT * FROM llx_bank_url WHERE fk_bank IN (404,405,406)
{"rowid":"741","fk_bank":"404","url_id":"69","url":"\/compta\/bank\/various_payment\/card.php?id=","label":"(VariousPayment)","type":"payment_various"}
{"rowid":"742","fk_bank":"405","url_id":"70","url":"\/compta\/bank\/various_payment\/card.php?id=","label":"(VariousPayment)","type":"payment_various"}
{"rowid":"743","fk_bank":"406","url_id":"71","url":"\/compta\/bank\/various_payment\/card.php?id=","label":"(VariousPayment)","type":"payment_various"}
-- 3 ligne(s)

===== 7. bank FAmm/nn sans payment_supplier =====
SELECT b.rowid,b.dateo,b.amount,b.label,b.fk_account FROM llx_bank b WHERE b.label REGEXP 'FA[ ]?[0-9]{2}/[0-9]{2}' AND NOT EXISTS (SELECT 1 FROM llx_bank_url u WHERE u.fk_bank=b.rowid AND u.type='payment_supplier')
{"rowid":"404","dateo":"2026-01-09","amount":"-225.84000000","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","fk_account":"1"}
{"rowid":"405","dateo":"2026-01-12","amount":"-1334.74000000","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","fk_account":"1"}
{"rowid":"406","dateo":"2026-01-12","amount":"-2688.00000000","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","fk_account":"1"}
{"rowid":"460","dateo":"2026-09-28","amount":"13611.12000000","label":"(AgentCompta groupé) VIREMENT EN VOTRE FAVEUR NORMANDIE BIO SEPTEMBRE 26 S.A.R FA09\/30+31+32+33+34 TEKNIPLI NORMANDIE BIO SEPTEMBRE 26","fk_account":"1"}
{"rowid":"488","dateo":"2026-09-09","amount":"4582.74000000","label":"(AgentCompta groupé) VIREMENT EN VOTRE FAVEUR 322+323+324+326+327+328 NORMANDI FA08\/18+19+20+21+27+28 TKP 322+323+324+326+327+328 NORMANDIE B","fk_account":"1"}
-- 5 ligne(s)

===== 7b. toutes bank FAmm/nn =====
SELECT b.rowid,b.dateo,b.amount,b.label,(SELECT GROUP_CONCAT(CONCAT(u.type,':',u.url_id)) FROM llx_bank_url u WHERE u.fk_bank=b.rowid) links FROM llx_bank b WHERE b.label REGEXP 'FA[ ]?[0-9]{2}/[0-9]{2}'
{"rowid":"160","dateo":"2026-08-03","amount":"-1290.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06\/27 SELLERIE THOMAS F267110 TEKNIPLI","links":"payment_supplier:46,company:235"}
{"rowid":"182","dateo":"2026-03-17","amount":"-625.58000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers GARAGE LEROY FA02\/14 CITROEN 101630 TEKNIPLI","links":"payment_supplier:68,company:339"}
{"rowid":"183","dateo":"2026-03-17","amount":"-1452.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA02\/13 SELLERIE THOMAS F266642 TEKNIPLI","links":"payment_supplier:69,company:235"}
{"rowid":"185","dateo":"2026-04-02","amount":"-2970.00000000","label":"(AgentCompta) VIREMENT EMIS WEB GREGOIRE DONNART 26-03-2 TKP FA03\/07 DONNART 26-03-2 TKP","links":"payment_supplier:71,company:322"}
{"rowid":"192","dateo":"2026-05-12","amount":"-1316.64000000","label":"(AgentCompta) VIREMENT EMIS WEB DU CLOS 2026\/022\/R TEKNPLI FA04\/02 SCI DU CLOS 2026\/022\/R TEKNPLI","links":"payment_supplier:78,company:325"}
{"rowid":"195","dateo":"2026-07-16","amount":"-1944.00000000","label":"(AgentCompta) VIREMENT EMIS WEB B.D.I.T 2093 TEKNIPLI FA06\/30 BDIT 2093 TEKNIPLI","links":"payment_supplier:81,company:337"}
{"rowid":"196","dateo":"2026-07-16","amount":"-179.96000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers FONDATION GABRIEL FA06\/31 ATELIERS DU MOULIN A VENT FA26000653 TEKNIPLI","links":"payment_supplier:82,company:326"}
{"rowid":"199","dateo":"2026-07-20","amount":"-1152.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA06\/28 SELLERIE THOMAS F267047 TEKNIPLI","links":"payment_supplier:85,company:235"}
{"rowid":"200","dateo":"2026-04-10","amount":"-2688.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL THOMAS FA11\/10 SELLERIE THOMAS F256444 TEKNIPLI","links":"payment_supplier:86,company:235"}
{"rowid":"201","dateo":"2026-04-09","amount":"-3386.95000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers MULTILAQUE FA02\/07+08+09+10 MULTILAQUE TEKNIPLI FEVRIER 26","links":"payment_supplier:87,company:353"}
{"rowid":"202","dateo":"2026-04-17","amount":"-1439.20000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers EQUIPEMENTS SCIENT FA03\/03+06 EQUIPEMENT SCIENTIFIQUE TEKNIPLI 3692 + 3891","links":"payment_supplier:88,company:357"}
{"rowid":"203","dateo":"2026-05-13","amount":"-599.88000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers Les Ateliers du Mo FA04\/15+16 ATELIERS MOULIN 348 + 349 TEKNIPLI","links":"payment_supplier:89,company:326"}
{"rowid":"204","dateo":"2026-06-08","amount":"-1755.00000000","label":"(AgentCompta) VIREMENT EMIS WEB GREGOIRE DONNART 26-06-6 + 7 FA06\/02+03 DONNART 26-06-6 + 7 TEKNI PLI","links":"payment_supplier:90,company:322"}
{"rowid":"212","dateo":"2026-08-03","amount":"-3240.00000000","label":"(AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-08-12 TE - FA08\/01 DONNART 26-08-12 TEKNIPLI","links":"payment_supplier:98,company:322"}
{"rowid":"213","dateo":"2026-07-20","amount":"-330.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers ADS TECHNOLOGIES - FA07\/05 ADS TECHNO 2803 TEKNIPLI","links":"payment_supplier:99,company:288"}
{"rowid":"215","dateo":"2026-07-03","amount":"-4800.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers SCI MARLEG - FA07\/01 SCI MARLEG TEKNIPLI JUILLET 26","links":"payment_supplier:101,company:347"}
{"rowid":"216","dateo":"2026-07-01","amount":"-2565.00000000","label":"(AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-06-11 TE - FA06\/24 DONNART 26-06-11 TEKNIPLI","links":"payment_supplier:102,company:322"}
{"rowid":"217","dateo":"2026-06-26","amount":"-6000.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers NOREQUIPEMENTS - FA06\/16 NOREQUIPEMENTS VTE2026\/073 TEKNIPLI","links":"payment_supplier:103,company:288"}
{"rowid":"218","dateo":"2026-06-22","amount":"-3807.98000000","label":"(AgentCompta relevé) Virement émis VIR INST vers ARCELORMITTAL DIST - fa04\/14 arcelor TEKNI PLI","links":"payment_supplier:104,company:372"}
{"rowid":"219","dateo":"2026-06-17","amount":"-198.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers GONTHIER MATERIAUX - FA06\/09 GONTHIER 0072 TEKNIPLI","links":"payment_supplier:105,company:288"}
{"rowid":"220","dateo":"2026-06-17","amount":"-1558.49000000","label":"(AgentCompta relevé) Virement émis VIR INST vers GONTHIER MATERIAUX - FA05\/22 GONTHIER 9938 TEKNIPLI","links":"payment_supplier:106,company:288"}
{"rowid":"221","dateo":"2026-06-04","amount":"-4800.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers SCI MARLEG - FA05\/16 SCI MARLEG FA N1 TEKNIPLI","links":"payment_supplier:107,company:347"}
{"rowid":"222","dateo":"2026-05-12","amount":"-2295.00000000","label":"(AgentCompta relevé) Virement émis WEB GREGOIRE DONNART 26-05-3 TEK - FA05\/03 DONNART 26-05-3 TEKNIPLI","links":"payment_supplier:108,company:322"}
{"rowid":"223","dateo":"2026-04-09","amount":"-1308.00000000","label":"(AgentCompta relevé) Virement émis WEB DU CLOS 2026\/021\/R TEKNIPLI - FA03\/02 SCI DU CLOS 2026\/021\/R TEKNIPLI","links":"payment_supplier:109,company:325"}
{"rowid":"224","dateo":"2026-03-05","amount":"-1500.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers AMAN Maxime - FA03\/01 AMAN VENTE CAMION TEKNIPLI","links":"payment_supplier:110,company:288"}
{"rowid":"225","dateo":"2026-03-03","amount":"-1308.00000000","label":"(AgentCompta relevé) Virement émis WEB DU CLOS 2026\/020\/R TEKNIPLI - FA02\/01 SCI DU CLOS 2026\/020\/R TEKNIPLI","links":"payment_supplier:111,company:325"}
{"rowid":"226","dateo":"2026-03-03","amount":"-120.60000000","label":"(AgentCompta relevé) Virement émis VIR INST vers NLJ - FA02\/02 NLJ FAC5048955 TEKNIPLI","links":"payment_supplier:112,company:286"}
{"rowid":"227","dateo":"2026-02-10","amount":"-114.00000000","label":"(AgentCompta relevé) Virement émis VIR INST vers NLJ - FA01\/04 NLJ FAC5048467 TEKNIPLI","links":"payment_supplier:113,company:286"}
{"rowid":"228","dateo":"2026-01-09","amount":"-1308.00000000","label":"(AgentCompta relevé) Virement émis WEB DU CLOS 2026\/019\/R TEKNI PLI - FA01\/01 SCI DU CLOS 2026\/019\/R TEKNI PLI","links":"payment_supplier:114,company:325"}
{"rowid":"365","dateo":"2026-02-10","amount":"-96.00000000","label":"(AgentCompta) Virement DMD METAL FA01\/06","links":"payment_supplier:172,company:367"}
{"rowid":"404","dateo":"2026-01-09","amount":"-225.84000000","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","links":"payment_various:69"}
{"rowid":"405","dateo":"2026-01-12","amount":"-1334.74000000","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","links":"payment_various:70"}
{"rowid":"406","dateo":"2026-01-12","amount":"-2688.00000000","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","links":"payment_various:71"}
{"rowid":"449","dateo":"2026-08-11","amount":"-4800.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SCI MARLEG FA08\/02 SCI MARLEG LOYER AOUT 26","links":"payment_supplier:207,company:347"}
{"rowid":"460","dateo":"2026-09-28","amount":"13611.12000000","label":"(AgentCompta groupé) VIREMENT EN VOTRE FAVEUR NORMANDIE BIO SEPTEMBRE 26 S.A.R FA09\/30+31+32+33+34 TEKNIPLI NORMANDIE BIO SEPTEMBRE 26","links":"payment:132,company:222"}
{"rowid":"468","dateo":"2026-09-28","amount":"-1303.68000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers EQUIPEMENTS SCIENT FA08\/08 EQUIPEMENT SCIENTIFIQUE ES261012067 TEKNIPLI","links":"payment_supplier:215,company:369"}
{"rowid":"470","dateo":"2026-09-03","amount":"-115.44000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers NORMANDIE ACIERS D FA06\/33 NLJ FAC5050486 TEKNIPLI","links":"payment_supplier:216,company:241"}
{"rowid":"488","dateo":"2026-09-09","amount":"4582.74000000","label":"(AgentCompta groupé) VIREMENT EN VOTRE FAVEUR 322+323+324+326+327+328 NORMANDI FA08\/18+19+20+21+27+28 TKP 322+323+324+326+327+328 NORMANDIE B","links":"payment:140,company:222"}
{"rowid":"489","dateo":"2026-09-03","amount":"-675.00000000","label":"(AgentCompta) VIREMENT EMIS WEB GREGOIRE DONNART 26-09-14 TE FA09\/01 DONNART 26-09-14 TEKNIPLI","links":"payment_supplier:223,company:322"}
{"rowid":"491","dateo":"2026-09-09","amount":"-340.93000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers AIR LIQUIDE FRANCE FA08\/15 AIR LIQUIDE 5801562824 TEKNIPLI","links":"payment_supplier:225,company:381"}
{"rowid":"492","dateo":"2026-10-09","amount":"-4800.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SCI MARLEG FA10\/02 SCI MARLEG TEKNIPLI","links":"payment_supplier:226,company:347"}
{"rowid":"498","dateo":"2026-09-03","amount":"-192.60000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL MOUGENOT PROT FA07\/07 MPI FA0717278 MPI","links":"payment_supplier:232,company:376"}
{"rowid":"500","dateo":"2026-09-09","amount":"-4800.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SCI MARLEG FA09\/02 SCI MARLEG N 4 TEKNIPLI","links":"payment_supplier:234,company:347"}
{"rowid":"502","dateo":"2026-09-28","amount":"-373.20000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SARL MOUGENOT PROT FA08\/10 MPI FA0717290 TEKNIPLI","links":"payment_supplier:235,company:376"}
{"rowid":"504","dateo":"2026-09-28","amount":"-240.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers ETABLISSEMENTS JAC FA09\/08 JACQUET FA0064929 TEKNIPLI","links":"payment_supplier:236,company:394"}
{"rowid":"505","dateo":"2026-09-28","amount":"-120.00000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers NORMANDIE ACIERS D FA07\/29 NLJ FAC5050744 NBK","links":"payment_supplier:237,company:286"}
{"rowid":"513","dateo":"2026-10-09","amount":"-1159.20000000","label":"(AgentCompta) VIREMENT EMIS VIR INST vers SCI MARLEG FA01\/10 MARLEG TEKNIPLI TF 2026","links":"payment_supplier:245,company:347"}
-- 47 ligne(s)

===== 8. tiers concernes =====
SELECT rowid,nom,code_fournisseur,code_client,fournisseur,client FROM llx_societe WHERE nom LIKE '%NLJ%' OR nom LIKE '%ARF%' OR nom LIKE '%Sellerie%' OR nom LIKE '%Thomas%' OR nom LIKE '%Epoxy%'
{"rowid":"201","nom":"M.Thomas Tardif de Petiville","code_fournisseur":null,"code_client":"CU2506-00008","fournisseur":"0","client":"1"}
{"rowid":"235","nom":"Sellerie Thomas","code_fournisseur":"SU2507-00003","code_client":"CU2609-00103","fournisseur":"1","client":"1"}
{"rowid":"241","nom":"NORMANDIE ACIERS DECOUPE (NLJ)","code_fournisseur":"SU2509-00004","code_client":"CU2508-00045","fournisseur":"1","client":"1"}
{"rowid":"286","nom":"NLJ","code_fournisseur":"SU2602-00006","code_client":"CU2602-00059","fournisseur":"1","client":"1"}
{"rowid":"287","nom":"Thomas Charpente","code_fournisseur":null,"code_client":"CU2602-00060","fournisseur":"0","client":"1"}
-- 5 ligne(s)

===== 9. tous les payment_various =====
SELECT rowid,datep,amount,sens,accountancy_code,subledger_account,label,fk_projet,fk_user_author FROM llx_payment_various ORDER BY rowid
{"rowid":"1","datep":"2026-01-06","amount":"61.15000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"2","datep":"2026-02-05","amount":"59.84000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"3","datep":"2026-03-05","amount":"58.52000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"4","datep":"2026-04-08","amount":"57.20000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"5","datep":"2026-05-05","amount":"55.88000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"6","datep":"2026-06-05","amount":"54.55000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"7","datep":"2026-07-07","amount":"53.21000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"8","datep":"2026-08-05","amount":"51.87000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"9","datep":"2026-01-06","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"10","datep":"2026-02-04","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"11","datep":"2026-03-04","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"12","datep":"2026-04-03","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"13","datep":"2026-05-06","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"14","datep":"2026-06-03","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"15","datep":"2026-07-03","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"16","datep":"2026-08-05","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"17","datep":"2026-01-28","amount":"7014.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de décembre 2025 — solde la dette d'ouverture","fk_projet":"0","fk_user_author":"1"}
{"rowid":"18","datep":"2026-02-25","amount":"3115.00000000","sens":"1","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_projet":"0","fk_user_author":"1"}
{"rowid":"19","datep":"2026-03-25","amount":"2367.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de mars 2026","fk_projet":"0","fk_user_author":"1"}
{"rowid":"20","datep":"2026-04-30","amount":"4808.00000000","sens":"1","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_projet":"0","fk_user_author":"1"}
{"rowid":"21","datep":"2026-05-15","amount":"4385.00000000","sens":"0","accountancy_code":"444","subledger_account":"","label":"Impôt sur les sociétés — solde la dette d'ouverture","fk_projet":"0","fk_user_author":"1"}
{"rowid":"22","datep":"2026-05-28","amount":"1272.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de mai 2026","fk_projet":"0","fk_user_author":"1"}
{"rowid":"23","datep":"2026-06-17","amount":"1096.00000000","sens":"0","accountancy_code":"444","subledger_account":"","label":"Acompte d'impôt sur les sociétés 2026","fk_projet":"0","fk_user_author":"1"}
{"rowid":"24","datep":"2026-06-24","amount":"3.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de juin 2026","fk_projet":"0","fk_user_author":"1"}
{"rowid":"25","datep":"2026-07-30","amount":"2194.00000000","sens":"1","accountancy_code":"44567","subledger_account":"","label":"Remboursement DGFiP — crédit de TVA","fk_projet":"0","fk_user_author":"1"}
{"rowid":"26","datep":"2026-01-07","amount":"80.46000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"27","datep":"2026-01-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"28","datep":"2026-01-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"29","datep":"2026-01-15","amount":"20.90000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"30","datep":"2026-01-23","amount":"60.00000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Crédit-bail — acte de gestion à identifier","fk_projet":"0","fk_user_author":"1"}
{"rowid":"31","datep":"2026-02-09","amount":"80.46000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"32","datep":"2026-02-09","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"33","datep":"2026-02-09","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"34","datep":"2026-02-17","amount":"54.00000000","sens":"1","accountancy_code":"471","subledger_account":"","label":"Crédit-bail — acte de gestion à identifier","fk_projet":"0","fk_user_author":"1"}
{"rowid":"35","datep":"2026-02-17","amount":"20.90000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"36","datep":"2026-03-09","amount":"80.46000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"37","datep":"2026-03-09","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"38","datep":"2026-03-09","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"39","datep":"2026-03-17","amount":"20.90000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"40","datep":"2026-04-07","amount":"80.46000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"41","datep":"2026-04-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"42","datep":"2026-04-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"43","datep":"2026-04-15","amount":"22.00000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"44","datep":"2026-05-07","amount":"80.46000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"45","datep":"2026-05-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"46","datep":"2026-05-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"47","datep":"2026-05-16","amount":"22.00000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"48","datep":"2026-05-18","amount":"118.80000000","sens":"1","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_projet":"0","fk_user_author":"1"}
{"rowid":"49","datep":"2026-05-29","amount":"500.00000000","sens":"1","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_projet":"0","fk_user_author":"1"}
{"rowid":"50","datep":"2026-05-30","amount":"500.00000000","sens":"0","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_projet":"0","fk_user_author":"1"}
{"rowid":"52","datep":"2026-06-08","amount":"80.45000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"53","datep":"2026-06-08","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"54","datep":"2026-06-08","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"55","datep":"2026-06-16","amount":"22.00000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"56","datep":"2026-06-23","amount":"590.40000000","sens":"1","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_projet":"0","fk_user_author":"1"}
{"rowid":"57","datep":"2026-06-23","amount":"10000.00000000","sens":"1","accountancy_code":"455","subledger_account":"","label":"Compte courant d'associé","fk_projet":"0","fk_user_author":"1"}
{"rowid":"58","datep":"2026-07-07","amount":"106.62000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"59","datep":"2026-07-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"60","datep":"2026-07-07","amount":"57.53000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"61","datep":"2026-07-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"62","datep":"2026-07-16","amount":"22.00000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"63","datep":"2026-07-31","amount":"1627.13000000","sens":"0","accountancy_code":"641","subledger_account":"","label":"Salaire net","fk_projet":"0","fk_user_author":"1"}
{"rowid":"64","datep":"2026-08-07","amount":"130.01000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"65","datep":"2026-08-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"66","datep":"2026-08-07","amount":"57.53000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"67","datep":"2026-08-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"68","datep":"2026-05-19","amount":"550.00000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Virement notaire du 19\/05 — part non justifiée","fk_projet":"0","fk_user_author":"1"}
{"rowid":"69","datep":"2026-01-09","amount":"225.84000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — NLJ, pièce FA12\/06","fk_projet":"0","fk_user_author":"1"}
{"rowid":"70","datep":"2026-01-12","amount":"1334.74000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11\/13","fk_projet":"0","fk_user_author":"1"}
{"rowid":"71","datep":"2026-01-12","amount":"2688.00000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Règlement dette d'ouverture — Sellerie Thomas, pièce FA11\/10","fk_projet":"0","fk_user_author":"1"}
{"rowid":"72","datep":"2026-01-14","amount":"16.75000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Acompte HTC — annulé le jour même (1\/2)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"73","datep":"2026-01-14","amount":"16.75000000","sens":"1","accountancy_code":"471","subledger_account":"","label":"Annulation acompte HTC (1\/2)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"74","datep":"2026-01-14","amount":"16.75000000","sens":"1","accountancy_code":"471","subledger_account":"","label":"Annulation acompte HTC (2\/2)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"75","datep":"2026-02-17","amount":"5.99000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"76","datep":"2026-02-19","amount":"44.98000000","sens":"0","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"77","datep":"2026-03-17","amount":"5.99000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"78","datep":"2026-04-08","amount":"132.80000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-03 — services bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"79","datep":"2026-04-14","amount":"147.76000000","sens":"0","accountancy_code":"6061","subledger_account":"","label":"Carburant — Leclerc station (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"80","datep":"2026-04-17","amount":"5.99000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"81","datep":"2026-05-04","amount":"37.73000000","sens":"0","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Négo Achat C+ (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"82","datep":"2026-05-12","amount":"253.43000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Achat Verpakgigant — remboursé le 15\/05","fk_projet":"0","fk_user_author":"1"}
{"rowid":"83","datep":"2026-05-15","amount":"253.43000000","sens":"1","accountancy_code":"471","subledger_account":"","label":"Remboursement Verpakgigant","fk_projet":"0","fk_user_author":"1"}
{"rowid":"84","datep":"2026-05-18","amount":"5.99000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"85","datep":"2026-05-20","amount":"31.70000000","sens":"0","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Delvia (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"86","datep":"2026-05-26","amount":"1795.20000000","sens":"0","accountancy_code":"4091","subledger_account":"","label":"Acompte KDI sur proforma 9011595061","fk_projet":"0","fk_user_author":"1"}
{"rowid":"87","datep":"2026-05-26","amount":"143.80000000","sens":"0","accountancy_code":"6061","subledger_account":"","label":"Carburant — Relais Bretteville (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"88","datep":"2026-05-28","amount":"7.30000000","sens":"0","accountancy_code":"6251","subledger_account":"","label":"Péage — SAPN","fk_projet":"0","fk_user_author":"1"}
{"rowid":"89","datep":"2026-06-09","amount":"68.35000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-05 — services bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"90","datep":"2026-06-17","amount":"5.99000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"91","datep":"2026-07-03","amount":"35.01000000","sens":"0","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"92","datep":"2026-07-03","amount":"10.72000000","sens":"0","accountancy_code":"6064","subledger_account":"","label":"Fournitures — Amazon (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"93","datep":"2026-07-07","amount":"68.35000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-06 — services bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"94","datep":"2026-07-16","amount":"12.00000000","sens":"0","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"95","datep":"2026-07-17","amount":"5.99000000","sens":"0","accountancy_code":"401","subledger_account":"","label":"Uber One — nature à confirmer","fk_projet":"0","fk_user_author":"1"}
{"rowid":"96","datep":"2026-07-21","amount":"225.77000000","sens":"0","accountancy_code":"6354","subledger_account":"","label":"Redevance INPI — dépôt\/renouvellement de marque","fk_projet":"0","fk_user_author":"1"}
{"rowid":"97","datep":"2026-07-27","amount":"26.40000000","sens":"1","accountancy_code":"4091","subledger_account":"","label":"Avoir KDI reçu — remboursement client 3813883","fk_projet":"0","fk_user_author":"1"}
{"rowid":"102","datep":"2026-08-06","amount":"280.90000000","sens":"0","accountancy_code":"6063","subledger_account":"","label":"Fournitures d'atelier — Setin (TVA non récupérée faute de pièce)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"103","datep":"2026-08-07","amount":"59.30000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Facture Crédit Agricole 2026-07 — services bancaires","fk_projet":"0","fk_user_author":"1"}
{"rowid":"104","datep":"2026-01-14","amount":"16.75000000","sens":"0","accountancy_code":"471","subledger_account":"","label":"Acompte HTC - tentative annulee (3e debit du releve)","fk_projet":"0","fk_user_author":"1"}
{"rowid":"105","datep":"2026-07-31","amount":"32.57000000","sens":"1","accountancy_code":"6354","subledger_account":"","label":"Avoir carte INPI VADS du 30\/07 — remboursement de la redevance de marque","fk_projet":"0","fk_user_author":"1"}
{"rowid":"106","datep":"2026-09-05","amount":"50.52000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Remboursement de prêt 10003101334 — intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"107","datep":"2026-09-02","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur ASSU. CAAE — prêt 10003101334","fk_projet":"0","fk_user_author":"1"}
{"rowid":"108","datep":"2026-09-07","amount":"130.01000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"109","datep":"2026-09-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"110","datep":"2026-09-07","amount":"57.53000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"111","datep":"2026-09-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance","fk_projet":"0","fk_user_author":"1"}
{"rowid":"112","datep":"2026-09-29","amount":"5550.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"TVA CA3 de septembre 2026 — TVA1-092026","fk_projet":"0","fk_user_author":"1"}
{"rowid":"113","datep":"2026-08-14","amount":"31.40000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires — cotisation Compte à composer Pro","fk_projet":"0","fk_user_author":"1"}
{"rowid":"114","datep":"2026-09-14","amount":"31.40000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Frais bancaires — cotisation Compte à composer Pro","fk_projet":"0","fk_user_author":"1"}
{"rowid":"115","datep":"2026-10-02","amount":"18.30000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"Assurance emprunteur CAAE","fk_projet":"0","fk_user_author":"1"}
{"rowid":"116","datep":"2026-10-05","amount":"49.17000000","sens":"0","accountancy_code":"6611","subledger_account":"","label":"Prêt, intérêts","fk_projet":"0","fk_user_author":"1"}
{"rowid":"117","datep":"2026-10-14","amount":"31.40000000","sens":"0","accountancy_code":"627","subledger_account":"","label":"Cotisation du compte CA","fk_projet":"0","fk_user_author":"1"}
{"rowid":"118","datep":"2026-08-26","amount":"3617.00000000","sens":"0","accountancy_code":"44551","subledger_account":"","label":"DGFiP TVA","fk_projet":"0","fk_user_author":"1"}
{"rowid":"119","datep":"2026-09-16","amount":"1096.00000000","sens":"0","accountancy_code":"444","subledger_account":"","label":"DGFiP IS","fk_projet":"0","fk_user_author":"1"}
{"rowid":"120","datep":"2026-10-07","amount":"130.01000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_projet":"0","fk_user_author":"1"}
{"rowid":"121","datep":"2026-10-07","amount":"78.89000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_projet":"0","fk_user_author":"1"}
{"rowid":"122","datep":"2026-10-07","amount":"57.53000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_projet":"0","fk_user_author":"1"}
{"rowid":"123","datep":"2026-10-07","amount":"11.38000000","sens":"0","accountancy_code":"616","subledger_account":"","label":"GAN, quatre contrats","fk_projet":"0","fk_user_author":"1"}
-- 118 ligne(s)