===== Colonnes payment_various ===== SHOW COLUMNS FROM llx_payment_various ----- Field=rowid | Type=int | Null=NO | Key=PRI | Default=NULL | Extra=auto_increment Field=ref | Type=varchar(30) | Null=YES | Key= | Default=NULL | Extra= Field=num_payment | Type=varchar(50) | Null=YES | Key= | Default=NULL | Extra= Field=label | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=tms | Type=timestamp | Null=YES | Key= | Default=CURRENT_TIMESTAMP | Extra=DEFAULT_GENERATED on update CURRENT_TIMESTAMP Field=datec | Type=datetime | Null=YES | Key= | Default=NULL | Extra= Field=datep | Type=date | Null=YES | Key= | Default=NULL | Extra= Field=datev | Type=date | Null=YES | Key= | Default=NULL | Extra= Field=sens | Type=smallint | Null=NO | Key= | Default=0 | Extra= Field=amount | Type=double(24,8) | Null=NO | Key= | Default=0.00000000 | Extra= Field=fk_typepayment | Type=int | Null=NO | Key= | Default=NULL | Extra= Field=accountancy_code | Type=varchar(32) | Null=YES | Key= | Default=NULL | Extra= Field=subledger_account | Type=varchar(32) | Null=YES | Key= | Default=NULL | Extra= Field=fk_projet | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=entity | Type=int | Null=NO | Key= | Default=1 | Extra= Field=note | Type=text | Null=YES | Key= | Default=NULL | Extra= Field=fk_bank | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_user_author | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_user_modif | Type=int | Null=YES | Key= | Default=NULL | Extra= (19 lignes) ===== payment_various 86 et 97 ===== SELECT * FROM llx_payment_various WHERE rowid IN (86,97) ----- rowid=86 | ref=NULL | num_payment= | label=Acompte KDI sur proforma 9011595061 | tms=2026-08-10 13:50:03 | datec=2026-08-10 13:50:03 | datep=2026-05-26 | datev=2026-05-26 | sens=0 | amount=1795.20000000 | fk_typepayment=2 | accountancy_code=4091 | subledger_account= | fk_projet=0 | entity=1 | note=NULL | fk_bank=421 | fk_user_author=1 | fk_user_modif=NULL rowid=97 | ref=NULL | num_payment= | label=Avoir KDI reçu — remboursement client 3813883 | tms=2026-10-18 06:30:33 | datec=2026-08-10 13:50:03 | datep=2026-07-27 | datev=2026-07-27 | sens=1 | amount=26.40000000 | fk_typepayment=2 | accountancy_code=4091 | subledger_account= | fk_projet=0 | entity=1 | note=NULL | fk_bank=432 | fk_user_author=1 | fk_user_modif=NULL (2 lignes) ===== Tous payment_various ===== SELECT rowid,datep,amount,label,accountancy_code,subledger_account,sens,fk_bank,fk_projet FROM llx_payment_various ORDER BY datep ----- rowid=1 | datep=2026-01-06 | amount=61.15000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=286 | fk_projet=0 rowid=9 | datep=2026-01-06 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=294 | fk_projet=0 rowid=26 | datep=2026-01-07 | amount=80.46000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=319 | fk_projet=0 rowid=27 | datep=2026-01-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=320 | fk_projet=0 rowid=28 | datep=2026-01-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=321 | fk_projet=0 rowid=69 | datep=2026-01-09 | amount=225.84000000 | label=Règlement dette d'ouverture — NLJ, pièce FA12/06 | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=404 | fk_projet=0 rowid=70 | datep=2026-01-12 | amount=1334.74000000 | label=Règlement dette d'ouverture — ARF Caen Epoxy, pièce FA11/13 | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=405 | fk_projet=0 rowid=71 | datep=2026-01-12 | amount=2688.00000000 | label=Règlement dette d'ouverture — Sellerie Thomas, pièce FA11/10 | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=406 | fk_projet=0 rowid=72 | datep=2026-01-14 | amount=16.75000000 | label=Acompte HTC — annulé le jour même (1/2) | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=407 | fk_projet=0 rowid=73 | datep=2026-01-14 | amount=16.75000000 | label=Annulation acompte HTC (1/2) | accountancy_code=471 | subledger_account= | sens=1 | fk_bank=408 | fk_projet=0 rowid=74 | datep=2026-01-14 | amount=16.75000000 | label=Annulation acompte HTC (2/2) | accountancy_code=471 | subledger_account= | sens=1 | fk_bank=409 | fk_projet=0 rowid=104 | datep=2026-01-14 | amount=16.75000000 | label=Acompte HTC - tentative annulee (3e debit du releve) | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=440 | fk_projet=0 rowid=29 | datep=2026-01-15 | amount=20.90000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=322 | fk_projet=0 rowid=30 | datep=2026-01-23 | amount=60.00000000 | label=Crédit-bail — acte de gestion à identifier | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=323 | fk_projet=0 rowid=17 | datep=2026-01-28 | amount=7014.00000000 | label=TVA CA3 de décembre 2025 — solde la dette d'ouverture | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=309 | fk_projet=0 rowid=10 | datep=2026-02-04 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=295 | fk_projet=0 rowid=2 | datep=2026-02-05 | amount=59.84000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=287 | fk_projet=0 rowid=31 | datep=2026-02-09 | amount=80.46000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=324 | fk_projet=0 rowid=32 | datep=2026-02-09 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=325 | fk_projet=0 rowid=33 | datep=2026-02-09 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=326 | fk_projet=0 rowid=34 | datep=2026-02-17 | amount=54.00000000 | label=Crédit-bail — acte de gestion à identifier | accountancy_code=471 | subledger_account= | sens=1 | fk_bank=327 | fk_projet=0 rowid=35 | datep=2026-02-17 | amount=20.90000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=328 | fk_projet=0 rowid=75 | datep=2026-02-17 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=410 | fk_projet=0 rowid=76 | datep=2026-02-19 | amount=44.98000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | accountancy_code=6064 | subledger_account= | sens=0 | fk_bank=411 | fk_projet=0 rowid=18 | datep=2026-02-25 | amount=3115.00000000 | label=Remboursement DGFiP — crédit de TVA | accountancy_code=44567 | subledger_account= | sens=1 | fk_bank=310 | fk_projet=0 rowid=11 | datep=2026-03-04 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=296 | fk_projet=0 rowid=3 | datep=2026-03-05 | amount=58.52000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=288 | fk_projet=0 rowid=36 | datep=2026-03-09 | amount=80.46000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=329 | fk_projet=0 rowid=37 | datep=2026-03-09 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=330 | fk_projet=0 rowid=38 | datep=2026-03-09 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=331 | fk_projet=0 rowid=39 | datep=2026-03-17 | amount=20.90000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=332 | fk_projet=0 rowid=77 | datep=2026-03-17 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=412 | fk_projet=0 rowid=19 | datep=2026-03-25 | amount=2367.00000000 | label=TVA CA3 de mars 2026 | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=311 | fk_projet=0 rowid=12 | datep=2026-04-03 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=297 | fk_projet=0 rowid=40 | datep=2026-04-07 | amount=80.46000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=333 | fk_projet=0 rowid=41 | datep=2026-04-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=334 | fk_projet=0 rowid=42 | datep=2026-04-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=335 | fk_projet=0 rowid=4 | datep=2026-04-08 | amount=57.20000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=289 | fk_projet=0 rowid=78 | datep=2026-04-08 | amount=132.80000000 | label=Facture Crédit Agricole 2026-03 — services bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=413 | fk_projet=0 rowid=79 | datep=2026-04-14 | amount=147.76000000 | label=Carburant — Leclerc station (TVA non récupérée faute de pièce) | accountancy_code=6061 | subledger_account= | sens=0 | fk_bank=414 | fk_projet=0 rowid=43 | datep=2026-04-15 | amount=22.00000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=336 | fk_projet=0 rowid=80 | datep=2026-04-17 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=415 | fk_projet=0 rowid=20 | datep=2026-04-30 | amount=4808.00000000 | label=Remboursement DGFiP — crédit de TVA | accountancy_code=44567 | subledger_account= | sens=1 | fk_bank=312 | fk_projet=0 rowid=81 | datep=2026-05-04 | amount=37.73000000 | label=Fournitures d'atelier — Négo Achat C+ (TVA non récupérée faute de pièce) | accountancy_code=6063 | subledger_account= | sens=0 | fk_bank=416 | fk_projet=0 rowid=5 | datep=2026-05-05 | amount=55.88000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=290 | fk_projet=0 rowid=13 | datep=2026-05-06 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=298 | fk_projet=0 rowid=44 | datep=2026-05-07 | amount=80.46000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=337 | fk_projet=0 rowid=45 | datep=2026-05-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=338 | fk_projet=0 rowid=46 | datep=2026-05-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=339 | fk_projet=0 rowid=82 | datep=2026-05-12 | amount=253.43000000 | label=Achat Verpakgigant — remboursé le 15/05 | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=417 | fk_projet=0 rowid=21 | datep=2026-05-15 | amount=4385.00000000 | label=Impôt sur les sociétés — solde la dette d'ouverture | accountancy_code=444 | subledger_account= | sens=0 | fk_bank=313 | fk_projet=0 rowid=83 | datep=2026-05-15 | amount=253.43000000 | label=Remboursement Verpakgigant | accountancy_code=471 | subledger_account= | sens=1 | fk_bank=418 | fk_projet=0 rowid=47 | datep=2026-05-16 | amount=22.00000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=340 | fk_projet=0 rowid=48 | datep=2026-05-18 | amount=118.80000000 | label=Compte courant d'associé | accountancy_code=455 | subledger_account= | sens=1 | fk_bank=341 | fk_projet=0 rowid=84 | datep=2026-05-18 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=419 | fk_projet=0 rowid=68 | datep=2026-05-19 | amount=550.00000000 | label=Virement notaire du 19/05 — part non justifiée | accountancy_code=471 | subledger_account= | sens=0 | fk_bank=370 | fk_projet=0 rowid=85 | datep=2026-05-20 | amount=31.70000000 | label=Fournitures d'atelier — Delvia (TVA non récupérée faute de pièce) | accountancy_code=6063 | subledger_account= | sens=0 | fk_bank=420 | fk_projet=0 rowid=86 | datep=2026-05-26 | amount=1795.20000000 | label=Acompte KDI sur proforma 9011595061 | accountancy_code=4091 | subledger_account= | sens=0 | fk_bank=421 | fk_projet=0 rowid=87 | datep=2026-05-26 | amount=143.80000000 | label=Carburant — Relais Bretteville (TVA non récupérée faute de pièce) | accountancy_code=6061 | subledger_account= | sens=0 | fk_bank=422 | fk_projet=0 rowid=22 | datep=2026-05-28 | amount=1272.00000000 | label=TVA CA3 de mai 2026 | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=314 | fk_projet=0 rowid=88 | datep=2026-05-28 | amount=7.30000000 | label=Péage — SAPN | accountancy_code=6251 | subledger_account= | sens=0 | fk_bank=423 | fk_projet=0 rowid=49 | datep=2026-05-29 | amount=500.00000000 | label=Compte courant d'associé | accountancy_code=455 | subledger_account= | sens=1 | fk_bank=342 | fk_projet=0 rowid=50 | datep=2026-05-30 | amount=500.00000000 | label=Compte courant d'associé | accountancy_code=455 | subledger_account= | sens=0 | fk_bank=343 | fk_projet=0 rowid=14 | datep=2026-06-03 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=299 | fk_projet=0 rowid=6 | datep=2026-06-05 | amount=54.55000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=291 | fk_projet=0 rowid=52 | datep=2026-06-08 | amount=80.45000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=345 | fk_projet=0 rowid=53 | datep=2026-06-08 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=346 | fk_projet=0 rowid=54 | datep=2026-06-08 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=347 | fk_projet=0 rowid=89 | datep=2026-06-09 | amount=68.35000000 | label=Facture Crédit Agricole 2026-05 — services bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=424 | fk_projet=0 rowid=55 | datep=2026-06-16 | amount=22.00000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=348 | fk_projet=0 rowid=23 | datep=2026-06-17 | amount=1096.00000000 | label=Acompte d'impôt sur les sociétés 2026 | accountancy_code=444 | subledger_account= | sens=0 | fk_bank=315 | fk_projet=0 rowid=90 | datep=2026-06-17 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=425 | fk_projet=0 rowid=56 | datep=2026-06-23 | amount=590.40000000 | label=Compte courant d'associé | accountancy_code=455 | subledger_account= | sens=1 | fk_bank=349 | fk_projet=0 rowid=57 | datep=2026-06-23 | amount=10000.00000000 | label=Compte courant d'associé | accountancy_code=455 | subledger_account= | sens=1 | fk_bank=350 | fk_projet=0 rowid=24 | datep=2026-06-24 | amount=3.00000000 | label=TVA CA3 de juin 2026 | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=316 | fk_projet=0 rowid=15 | datep=2026-07-03 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=300 | fk_projet=0 rowid=91 | datep=2026-07-03 | amount=35.01000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | accountancy_code=6064 | subledger_account= | sens=0 | fk_bank=426 | fk_projet=0 rowid=92 | datep=2026-07-03 | amount=10.72000000 | label=Fournitures — Amazon (TVA non récupérée faute de pièce) | accountancy_code=6064 | subledger_account= | sens=0 | fk_bank=427 | fk_projet=0 rowid=7 | datep=2026-07-07 | amount=53.21000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=292 | fk_projet=0 rowid=58 | datep=2026-07-07 | amount=106.62000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=351 | fk_projet=0 rowid=59 | datep=2026-07-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=352 | fk_projet=0 rowid=60 | datep=2026-07-07 | amount=57.53000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=353 | fk_projet=0 rowid=61 | datep=2026-07-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=354 | fk_projet=0 rowid=93 | datep=2026-07-07 | amount=68.35000000 | label=Facture Crédit Agricole 2026-06 — services bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=428 | fk_projet=0 rowid=62 | datep=2026-07-16 | amount=22.00000000 | label=Frais bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=355 | fk_projet=0 rowid=94 | datep=2026-07-16 | amount=12.00000000 | label=Fournitures d'atelier — Setin (TVA non récupérée faute de pièce) | accountancy_code=6063 | subledger_account= | sens=0 | fk_bank=429 | fk_projet=0 rowid=95 | datep=2026-07-17 | amount=5.99000000 | label=Uber One — nature à confirmer | accountancy_code=401 | subledger_account= | sens=0 | fk_bank=430 | fk_projet=0 rowid=96 | datep=2026-07-21 | amount=225.77000000 | label=Redevance INPI — dépôt/renouvellement de marque | accountancy_code=6354 | subledger_account= | sens=0 | fk_bank=431 | fk_projet=0 rowid=97 | datep=2026-07-27 | amount=26.40000000 | label=Avoir KDI reçu — remboursement client 3813883 | accountancy_code=4091 | subledger_account= | sens=1 | fk_bank=432 | fk_projet=0 rowid=25 | datep=2026-07-30 | amount=2194.00000000 | label=Remboursement DGFiP — crédit de TVA | accountancy_code=44567 | subledger_account= | sens=1 | fk_bank=317 | fk_projet=0 rowid=63 | datep=2026-07-31 | amount=1627.13000000 | label=Salaire net | accountancy_code=641 | subledger_account= | sens=0 | fk_bank=356 | fk_projet=0 rowid=105 | datep=2026-07-31 | amount=32.57000000 | label=Avoir carte INPI VADS du 30/07 — remboursement de la redevance de marque | accountancy_code=6354 | subledger_account= | sens=1 | fk_bank=453 | fk_projet=0 rowid=8 | datep=2026-08-05 | amount=51.87000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=293 | fk_projet=0 rowid=16 | datep=2026-08-05 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=301 | fk_projet=0 rowid=102 | datep=2026-08-06 | amount=280.90000000 | label=Fournitures d'atelier — Setin (TVA non récupérée faute de pièce) | accountancy_code=6063 | subledger_account= | sens=0 | fk_bank=437 | fk_projet=0 rowid=64 | datep=2026-08-07 | amount=130.01000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=357 | fk_projet=0 rowid=65 | datep=2026-08-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=358 | fk_projet=0 rowid=66 | datep=2026-08-07 | amount=57.53000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=359 | fk_projet=0 rowid=67 | datep=2026-08-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=360 | fk_projet=0 rowid=103 | datep=2026-08-07 | amount=59.30000000 | label=Facture Crédit Agricole 2026-07 — services bancaires | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=438 | fk_projet=0 rowid=113 | datep=2026-08-14 | amount=31.40000000 | label=Frais bancaires — cotisation Compte à composer Pro | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=485 | fk_projet=0 rowid=118 | datep=2026-08-26 | amount=3617.00000000 | label=DGFiP TVA | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=521 | fk_projet=0 rowid=107 | datep=2026-09-02 | amount=18.30000000 | label=Assurance emprunteur ASSU. CAAE — prêt 10003101334 | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=479 | fk_projet=0 rowid=106 | datep=2026-09-05 | amount=50.52000000 | label=Remboursement de prêt 10003101334 — intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=478 | fk_projet=0 rowid=108 | datep=2026-09-07 | amount=130.01000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=480 | fk_projet=0 rowid=109 | datep=2026-09-07 | amount=78.89000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=481 | fk_projet=0 rowid=110 | datep=2026-09-07 | amount=57.53000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=482 | fk_projet=0 rowid=111 | datep=2026-09-07 | amount=11.38000000 | label=Assurance | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=483 | fk_projet=0 rowid=114 | datep=2026-09-14 | amount=31.40000000 | label=Frais bancaires — cotisation Compte à composer Pro | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=486 | fk_projet=0 rowid=119 | datep=2026-09-16 | amount=1096.00000000 | label=DGFiP IS | accountancy_code=444 | subledger_account= | sens=0 | fk_bank=522 | fk_projet=0 rowid=112 | datep=2026-09-29 | amount=5550.00000000 | label=TVA CA3 de septembre 2026 — TVA1-092026 | accountancy_code=44551 | subledger_account= | sens=0 | fk_bank=484 | fk_projet=0 rowid=115 | datep=2026-10-02 | amount=18.30000000 | label=Assurance emprunteur CAAE | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=517 | fk_projet=0 rowid=116 | datep=2026-10-05 | amount=49.17000000 | label=Prêt, intérêts | accountancy_code=6611 | subledger_account= | sens=0 | fk_bank=518 | fk_projet=0 rowid=120 | datep=2026-10-07 | amount=130.01000000 | label=GAN, quatre contrats | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=523 | fk_projet=0 rowid=121 | datep=2026-10-07 | amount=78.89000000 | label=GAN, quatre contrats | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=524 | fk_projet=0 rowid=122 | datep=2026-10-07 | amount=57.53000000 | label=GAN, quatre contrats | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=525 | fk_projet=0 rowid=123 | datep=2026-10-07 | amount=11.38000000 | label=GAN, quatre contrats | accountancy_code=616 | subledger_account= | sens=0 | fk_bank=526 | fk_projet=0 rowid=117 | datep=2026-10-14 | amount=31.40000000 | label=Cotisation du compte CA | accountancy_code=627 | subledger_account= | sens=0 | fk_bank=520 | fk_projet=0 (118 lignes) ===== Tiers 375 ===== SELECT rowid,nom,code_fournisseur FROM llx_societe WHERE rowid=375 ----- rowid=375 | nom=KDI S.A.S | code_fournisseur=SU2608-00062 (1 lignes) ===== Factures fourn tiers 375 ===== SELECT rowid,ref,ref_supplier,datef,total_ht,total_ttc,fk_statut,paye,type FROM llx_facture_fourn WHERE fk_soc=375 ----- (0 lignes) ===== Lignes factures 293/294 ===== SELECT rowid,fk_facture_fourn,description,total_ht,total_ttc,tva_tx FROM llx_facture_fourn_det WHERE fk_facture_fourn IN (293,294) ----- rowid=611 | fk_facture_fourn=293 | description=ACHAT MAT 1è FOURNITURES | total_ht=1485.00000000 | total_ttc=1782.00000000 | tva_tx=20.0000 rowid=612 | fk_facture_fourn=294 | description=ACHAT MAT 1è FOURNITURES | total_ht=-11.00000000 | total_ttc=-13.20000000 | tva_tx=20.0000 (2 lignes) ===== Notes factures 293/294 ===== SELECT rowid,ref,note_public,note_private,fk_user_author,datec,date_valid,close_code,close_note FROM llx_facture_fourn WHERE rowid IN (293,294) ----- rowid=293 | ref=SI2606-0142 | note_public= | note_private=Repris de la comptabilité Excel de l'assistante de direction — pièce 06/12 (ACHAT MAT 1è FOURNITURES). | fk_user_author=1 | datec=2026-08-09 12:09:29 | date_valid=2026-08-09 | close_code=other | close_note=Soldée par l'acompte KDI du 26/05 (paiement divers #86, 1 795,20 €) moins le remboursement du 27/07 (paiement divers #97, 26,40 rowid=294 | ref=SI2606-0143 | note_public= | note_private=Repris de la comptabilité Excel de l'assistante de direction — pièce 06/13 (ACHAT MAT 1è FOURNITURES). [AgentCompta 09/08/2026] Numéro réel du fournisseur : 3410281941. Doublon (PROV415) supprimé, son justificatif scanné a été repris ici. | fk_user_author=1 | datec=2026-08-09 12:09:29 | date_valid=2026-08-09 | close_code=other | close_note=Avoir de 13,20 € imputé sur l'acompte KDI (voir SI2606-0142) — 18/10/2026 (2 lignes) ===== Colonnes facture_fourn ===== SHOW COLUMNS FROM llx_facture_fourn ----- Field=rowid | Type=int | Null=NO | Key=PRI | Default=NULL | Extra=auto_increment Field=ref | Type=varchar(180) | Null=NO | Key=MUL | Default=NULL | Extra= Field=ref_supplier | Type=varchar(180) | Null=NO | Key=MUL | Default=NULL | Extra= Field=entity | Type=int | Null=NO | Key= | Default=1 | Extra= Field=ref_ext | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=type | Type=smallint | Null=NO | Key= | Default=0 | Extra= Field=subtype | Type=smallint | Null=YES | Key= | Default=NULL | Extra= Field=fk_soc | Type=int | Null=NO | Key=MUL | Default=NULL | Extra= Field=datec | Type=datetime | Null=YES | Key= | Default=NULL | Extra= Field=datef | Type=date | Null=YES | Key= | Default=NULL | Extra= Field=date_pointoftax | Type=date | Null=YES | Key= | Default=NULL | Extra= Field=date_valid | Type=date | Null=YES | Key= | Default=NULL | Extra= Field=tms | Type=timestamp | Null=YES | Key=MUL | Default=CURRENT_TIMESTAMP | Extra=DEFAULT_GENERATED on update CURRENT_TIMESTAMP Field=date_closing | Type=datetime | Null=YES | Key= | Default=NULL | Extra= Field=libelle | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=paye | Type=smallint | Null=NO | Key= | Default=0 | Extra= Field=amount | Type=double(24,8) | Null=NO | Key= | Default=0.00000000 | Extra= Field=remise | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=close_code | Type=varchar(16) | Null=YES | Key= | Default=NULL | Extra= Field=close_missing_amount | Type=double(24,8) | Null=YES | Key= | Default=NULL | Extra= Field=close_note | Type=varchar(128) | Null=YES | Key= | Default=NULL | Extra= Field=vat_reverse_charge | Type=tinyint | Null=YES | Key= | Default=0 | Extra= Field=tva | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=total_tva | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=localtax1 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=localtax2 | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=revenuestamp | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=total_ht | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=total_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=fk_statut | Type=smallint | Null=NO | Key= | Default=0 | Extra= Field=fk_user_author | Type=int | Null=YES | Key=MUL | Default=NULL | Extra= Field=fk_user_modif | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_user_valid | Type=int | Null=YES | Key=MUL | Default=NULL | Extra= Field=fk_user_closing | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_fac_rec_source | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_facture_source | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_projet | Type=int | Null=YES | Key=MUL | Default=NULL | Extra= Field=fk_account | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_cond_reglement | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=fk_mode_reglement | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=date_lim_reglement | Type=date | Null=YES | Key=MUL | Default=NULL | Extra= Field=note_private | Type=text | Null=YES | Key= | Default=NULL | Extra= Field=note_public | Type=text | Null=YES | Key= | Default=NULL | Extra= Field=fk_incoterms | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=location_incoterms | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=fk_transport_mode | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=model_pdf | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=last_main_doc | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=import_key | Type=varchar(14) | Null=YES | Key= | Default=NULL | Extra= Field=extraparams | Type=varchar(255) | Null=YES | Key= | Default=NULL | Extra= Field=fk_multicurrency | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=multicurrency_code | Type=varchar(3) | Null=YES | Key= | Default=NULL | Extra= Field=multicurrency_tx | Type=double(24,8) | Null=YES | Key= | Default=1.00000000 | Extra= Field=multicurrency_total_ht | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=multicurrency_total_tva | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=multicurrency_total_ttc | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra= Field=fk_thirdparty_rib_id | Type=int | Null=YES | Key= | Default=NULL | Extra= Field=payment_reference | Type=varchar(25) | Null=YES | Key= | Default=NULL | Extra= Field=dispute_status | Type=int | Null=YES | Key= | Default=0 | Extra= (59 lignes)