--- colonnes llx_facture_fourn_det --- rowid fk_facture_fourn fk_parent_line fk_product ref label description pu_ht pu_ttc qty remise_percent fk_remise_except vat_src_code tva_tx localtax1_tx localtax1_type localtax2_tx localtax2_type total_ht tva total_localtax1 total_localtax2 total_ttc product_type date_start date_end info_bits fk_code_ventilation special_code rang import_key fk_unit fk_multicurrency multicurrency_code multicurrency_subprice multicurrency_subprice_ttc multicurrency_total_ht multicurrency_total_tva multicurrency_total_ttc extraparams --- colonnes llx_paiementfourn --- rowid ref entity tms datec datep amount multicurrency_amount fk_user_author fk_user_modif fk_paiement num_paiement note fk_bank statut model_pdf === LIGNES fac 136 === rowid=426 | description=Foret métal - FORET DIN 338 HSS SMART STEP Ø6,8MM ZEBRA SMART STEP | ref= | qty=5 | pu_ht=6.38000000 | tva_tx=20.0000 | total_ht=31.90000000 | total_ttc=38.28000000 | fk_code_ventilation=100107436 | fk_product= | product_type=0 rowid=427 | description=Taraud machine, trous débouchants - TAR MACHINE HSCO MULTI Ø8 FORME B ZEBRA | ref= | qty=2 | pu_ht=15.37000000 | tva_tx=20.0000 | total_ht=30.74000000 | total_ttc=36.89000000 | fk_code_ventilation=100107436 | fk_product= | product_type=0 === LIGNES fac 269 === (vide) === LIGNES fac 135 === rowid=424 | description=Bobine de fil et baguette de soudage - BOBINE FIL ACIER 70S6 Ø 1,0MM 5KG | ref= | qty=3 | pu_ht=52.20000000 | tva_tx=20.0000 | total_ht=156.60000000 | total_ttc=187.92000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 rowid=425 | description=Prestation - FORFAIT FRAIS DE PORT | ref= | qty=1 | pu_ht=7.00000000 | tva_tx=20.0000 | total_ht=7.00000000 | total_ttc=8.40000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 === LIGNES fac 142 === rowid=443 | description=Nettoyant pour freins - NETTOYANT FREIN PLUS 500 ML | ref= | qty=2 | pu_ht=5.03000000 | tva_tx=20.0000 | total_ht=10.06000000 | total_ttc=12.07000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 rowid=444 | description=Papier de nettoyage - BOBINE PAPIER RECYCLE BLANC 1000 F. | ref= | qty=10 | pu_ht=11.80000000 | tva_tx=20.0000 | total_ht=118.00000000 | total_ttc=141.60000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 === LIGNES fac 134 === rowid=422 | description=DISQUE FIBRE-CUBITRON II-D125MM-G60- ZEBRA | ref= | qty=25 | pu_ht=2.91000000 | tva_tx=20.0000 | total_ht=72.75000000 | total_ttc=87.30000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 rowid=423 | description=DISQUE FIBRE-CUBITRON II-D125MM-G36- ZEBRA | ref= | qty=25 | pu_ht=3.18000000 | tva_tx=20.0000 | total_ht=79.50000000 | total_ttc=95.40000000 | fk_code_ventilation=100107439 | fk_product= | product_type=0 --- ventilation : libelle des comptes utilises --- === accounting_account des lignes === fk_facture_fourn=131 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables fk_facture_fourn=132 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables fk_facture_fourn=133 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables fk_facture_fourn=134 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables fk_facture_fourn=135 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables fk_facture_fourn=136 | fk_code_ventilation=100107436 | account_number=601 | label=Achats stockés - matières premières et fournitures fk_facture_fourn=142 | fk_code_ventilation=100107439 | account_number=6022 | label=Fournitures consommables --- PAIEMENTS lies aux factures WURTH + 136 --- === paiements === fk_facturefourn=103 | affecte=2090.99000000 | paiement=95 | datep=2026-07-31 00:00:00 | amount=8804.22000000 | num_paiement= | note=AgentCompta — effet domicilie du 2026-07-31 Factures : SI2606-0022 + SI2606-0089 + SI2606-0023 + SI2606-0199 + SI2606-0194 Libelle : EFFETS DOMICILIES DOMICILIES | fk_bank=209 | datev=2026-07-31 | bank_label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | bank_amount=-8804.22000000 fk_facturefourn=131 | affecte=28.32000000 | paiement=96 | datep=2026-03-31 00:00:00 | amount=28.32000000 | num_paiement=Relevé effets n°16 | note=AgentCompta — effet domicilié réglé le 2026-03-31, relevé d'effets Crédit Agricole n°16 (tireur : WURTH FRANCE SAS). | fk_bank=210 | datev=2026-03-31 | bank_label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | bank_amount=-28.32000000 fk_facturefourn=132 | affecte=43.20000000 | paiement=91 | datep=2026-04-30 00:00:00 | amount=6201.50000000 | num_paiement= | note=AgentCompta — effet domicilie du 2026-04-30 Factures : SI2603-0053 + SI2603-0030 Libelle : EFFETS DOMICILIES DOMICILIES | fk_bank=205 | datev=2026-04-30 | bank_label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | bank_amount=-6201.50000000 fk_facturefourn=133 | affecte=44.94000000 | paiement=97 | datep=2026-06-01 00:00:00 | amount=44.94000000 | num_paiement=Relevé effets n°19 | note=AgentCompta — effet domicilié réglé le 2026-06-01, relevé d'effets Crédit Agricole n°19 (tireur : WURTH FRANCE SAS). | fk_bank=211 | datev=2026-06-01 | bank_label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | bank_amount=-44.94000000 fk_facturefourn=134 | affecte=182.70000000 | paiement=95 | datep=2026-07-31 00:00:00 | amount=8804.22000000 | num_paiement= | note=AgentCompta — effet domicilie du 2026-07-31 Factures : SI2606-0022 + SI2606-0089 + SI2606-0023 + SI2606-0199 + SI2606-0194 Libelle : EFFETS DOMICILIES DOMICILIES | fk_bank=209 | datev=2026-07-31 | bank_label=(AgentCompta effet) EFFETS DOMICILIES DOMICILIES | bank_amount=-8804.22000000 --- toutes lignes de paiement sur factures du tiers 318 et 342 --- === paiements tiers === rowid=131 | ref=SI2602-0033 | ref_supplier=4334153589 | total_ttc=28.32000000 | paye=1 | fk_statut=2 | regle=28.32000000 rowid=132 | ref=SI2603-0030 | ref_supplier=4334393179 | total_ttc=43.20000000 | paye=1 | fk_statut=2 | regle=43.20000000 rowid=133 | ref=SI2604-0027 | ref_supplier=4334656108 | total_ttc=44.94000000 | paye=1 | fk_statut=2 | regle=44.94000000 rowid=134 | ref=SI2606-0023 | ref_supplier=4335225117 | total_ttc=182.70000000 | paye=1 | fk_statut=2 | regle=182.70000000 rowid=103 | ref=SI2606-0022 | ref_supplier=651C0003943793 | total_ttc=2090.99000000 | paye=1 | fk_statut=2 | regle=2090.99000000 rowid=135 | ref=SI2607-0020 | ref_supplier=4335343640 | total_ttc=196.32000000 | paye=0 | fk_statut=1 | regle=0.00000000 rowid=136 | ref=SI2607-0019 | ref_supplier=4335371605 | total_ttc=75.17000000 | paye=0 | fk_statut=1 | regle=0.00000000 rowid=142 | ref=SI2607-0007 | ref_supplier=4335464405 | total_ttc=153.67000000 | paye=0 | fk_statut=1 | regle=0.00000000 rowid=124 | ref=SI2607-0005 | ref_supplier=651C0003968958 | total_ttc=12770.24000000 | paye=0 | fk_statut=1 | regle=0.00000000 --- DOCUMENTS ECM lies --- === ecm === (vide) --- INTAKE id 107 (source du brouillon 136) --- === tables intake === Tables_in_teknipndolibarr (%intake%)=llx_agentcompta_intake === tables teknipli === Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_chutes Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_cnc_pli Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_cnc_programme Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_color Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_configurator Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_configurator_line Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_devis Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_devis_lines Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_email_log Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_margin Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_margins Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_material Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_materials Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_of Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_of_bandes Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_of_pieces Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_of_pliage Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_of_pliage_pieces Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_optimisation Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_outil Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_outil_ve Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_prix_achat Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_prix_vente_hist Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_production Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_production_lines Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_schemas Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_stock_mouvement Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_stock_mouvements Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_stock_toles Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_tracabilite Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_user_folders Tables_in_teknipndolibarr (%teknipli%)=llx_teknipli_user_presets === tables agentcompta === Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_echeance Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_forecast Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_gcaccount Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_intake Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_log Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_mailbox Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_match Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_ouverture Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_recurrent Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_sender Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_ventil_log Tables_in_teknipndolibarr (%agentcompta%)=llx_agentcompta_ventil_rule --- llx_societe complet 318 / 342 --- === soc === rowid=318 | nom=ASTURIENNE (SAS SAINT-GOBAIN DISTRIBUTION BÂTIMENT) | name_alias= | entity=1 | ref_ext= | statut=0 | parent= | status=1 | code_client= | code_fournisseur=SU2608-00015 | tp_payment_reference= | accountancy_code_customer_general= | code_compta= | accountancy_code_supplier_general= | code_compta_fournisseur= | address= | zip= | town= | fk_departement= | fk_pays=76 | geolat= | geolong= | geopoint= | georesultcode= | phone= | phone_mobile= | fax= | url= | email= | fk_account=0 | socialnetworks=null | fk_effectif= | fk_typent=0 | fk_forme_juridique= | birth= | fk_currency= | siren= | siret= | ape= | idprof4= | idprof5= | idprof6= | tva_intra=FR15929591741 | capital= | fk_stcomm=0 | note_private=[AGENTCOMPTA] Créée automatiquement à partir d'une facture scannée le 08/08/2026. À valider manuellement. | note_public= | model_pdf= | last_main_doc= | prefix_comm= | client=0 | fournisseur=1 | supplier_account= | fk_prospectlevel= | fk_incoterms=0 | location_incoterms= | customer_bad=0 | customer_rate=0 | supplier_rate=0 | remise_client=0 | remise_supplier=0 | mode_reglement= | cond_reglement= | deposit_percent= | transport_mode= | mode_reglement_supplier= | cond_reglement_supplier= | transport_mode_supplier= | fk_shipping_method= | tva_assuj=1 | vat_reverse_charge=0 | localtax1_assuj=0 | localtax1_value=0.0000 | localtax2_assuj=0 | localtax2_value=0.0000 | barcode= | fk_barcode_type=0 | price_level= | outstanding_limit= | order_min_amount= | supplier_order_min_amount= | default_lang= | logo= | logo_squarred= | canvas= | fk_warehouse= | webservices_url= | webservices_key= | accountancy_code_sell= | accountancy_code_buy= | tms=2026-08-08 16:47:49 | datec=2026-08-08 16:47:48 | fk_user_creat=1 | fk_user_modif=1 | fk_multicurrency=0 | multicurrency_code= | ip= | import_key= | vatexemptcode= rowid=342 | nom=Würth France SAS | name_alias= | entity=1 | ref_ext= | statut=0 | parent= | status=1 | code_client= | code_fournisseur=SU2608-00027 | tp_payment_reference= | accountancy_code_customer_general= | code_compta= | accountancy_code_supplier_general= | code_compta_fournisseur= | address= | zip= | town= | fk_departement= | fk_pays=76 | geolat= | geolong= | geopoint= | georesultcode= | phone= | phone_mobile= | fax= | url= | email=rouen.commercial@wurth.fr | fk_account=0 | socialnetworks=null | fk_effectif= | fk_typent=0 | fk_forme_juridique= | birth= | fk_currency= | siren= | siret= | ape= | idprof4= | idprof5= | idprof6= | tva_intra= | capital= | fk_stcomm=0 | note_private=[AGENTCOMPTA] Créée automatiquement à partir d'une facture scannée le 08/08/2026. À valider manuellement. | note_public= | model_pdf= | last_main_doc= | prefix_comm= | client=0 | fournisseur=1 | supplier_account= | fk_prospectlevel= | fk_incoterms=0 | location_incoterms= | customer_bad=0 | customer_rate=0 | supplier_rate=0 | remise_client=0 | remise_supplier=0 | mode_reglement= | cond_reglement= | deposit_percent= | transport_mode= | mode_reglement_supplier= | cond_reglement_supplier= | transport_mode_supplier= | fk_shipping_method= | tva_assuj=1 | vat_reverse_charge=0 | localtax1_assuj=0 | localtax1_value=0.0000 | localtax2_assuj=0 | localtax2_value=0.0000 | barcode= | fk_barcode_type=0 | price_level= | outstanding_limit= | order_min_amount= | supplier_order_min_amount= | default_lang= | logo= | logo_squarred= | canvas= | fk_warehouse= | webservices_url= | webservices_key= | accountancy_code_sell= | accountancy_code_buy= | tms=2026-08-08 22:45:16 | datec=2026-08-08 22:45:16 | fk_user_creat= | fk_user_modif= | fk_multicurrency=0 | multicurrency_code= | ip= | import_key= | vatexemptcode= FIN2