===== 0. Colonnes societe pertinentes ===== COLUMN_NAME=[accountancy_code_buy] COLUMN_NAME=[accountancy_code_customer_general] COLUMN_NAME=[accountancy_code_sell] COLUMN_NAME=[accountancy_code_supplier_general] COLUMN_NAME=[code_compta] COLUMN_NAME=[code_compta_fournisseur] COLUMN_NAME=[idprof4] COLUMN_NAME=[idprof5] COLUMN_NAME=[idprof6] COLUMN_NAME=[siren] COLUMN_NAME=[siret] -- 11 ligne(s) ===== 6. Comptes auxiliaires ===== rowid=[314] | nom=[ArcelorMittal Distribution Solutions France] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00011] | code_client=[] rowid=[320] | nom=[Shenzhenshi Fengmaishiyeyouxiangongsi] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00017] | code_client=[] rowid=[349] | nom=[shenzhenshiluanniaomaoyiyouxiangongsi] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00031] | code_client=[] rowid=[356] | nom=[EDF] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00043] | code_client=[] rowid=[357] | nom=[EQUIPEMENT SCIENTIFIQUE] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00044] | code_client=[] rowid=[369] | nom=[EQUIPEMENTS SCIENTIFIQUES S.A.S] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00056] | code_client=[] rowid=[371] | nom=[EDF] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00058] | code_client=[] rowid=[372] | nom=[ARCELOR MITTAL] | code_compta_fournisseur=[] | code_compta=[] | code_fournisseur=[SU2608-00059] | code_client=[] -- 8 ligne(s) ===== 6b. Identite complete 314 / 372 ===== ERR Unknown column 'idprof1' in 'field list' ===== 9. Lignes + ventilation comptable ===== fk_facture_fourn=[189] | ref=[SI2605-0050] | fk_soc=[314] | rowid=[517] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[3721.95000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[156] | ref=[SI2606-0199] | fk_soc=[314] | rowid=[480] | descr=[2116692 - tôle prélaqué sur zinc magnésium RAL7016] | total_ht=[1528.67000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[156] | ref=[SI2606-0199] | fk_soc=[314] | rowid=[481] | descr=[2116653 - tôle prélaqué sur zinc magnésium RAL7016] | total_ht=[982.69000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[156] | ref=[SI2606-0199] | fk_soc=[314] | rowid=[482] | descr=[Contrib redevance KM] | total_ht=[60.00000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[190] | ref=[SI2607-0051] | fk_soc=[314] | rowid=[518] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[263.73000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[513] | ref=[SI2608-0276] | fk_soc=[314] | rowid=[903] | descr=[tôle EN 10143 Galvanisé DX51D+Z275 MA E-passivatio] | total_ht=[1573.04000000] | fk_code_ventilation=[0] fk_facture_fourn=[537] | ref=[SI2608-0300] | fk_soc=[314] | rowid=[942] | descr=[tôle Aluminium laqué poudre RAL7016 satiné AW5005H] | total_ht=[2389.50000000] | fk_code_ventilation=[0] fk_facture_fourn=[399] | ref=[SI2603-0192] | fk_soc=[372] | rowid=[712] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[354.75000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[400] | ref=[SI2604-0193] | fk_soc=[372] | rowid=[713] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[3173.32000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[401] | ref=[SI2606-0194] | fk_soc=[372] | rowid=[714] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[1605.77000000] | fk_code_ventilation=[100107436] fk_facture_fourn=[408] | ref=[SI2607-0198] | fk_soc=[372] | rowid=[721] | descr=[ACHAT MAT 1è FOURNITURES] | total_ht=[174.24000000] | fk_code_ventilation=[100107436] -- 11 ligne(s) ===== 10. Nb ecritures comptables ===== n=[0] -- 1 ligne(s) ===== 11. Autres objets rattaches ===== t=[propal] | n=[0] t=[commande_fourn] | n=[3] t=[contact] | n=[0] t=[facture_client] | n=[0] -- 4 ligne(s) ===== 12. Regle par facture ===== rowid=[189] | ref=[SI2605-0050] | fk_soc=[314] | total_ttc=[4466.34000000] | paye=[1] | fk_statut=[2] | regle=[4466.34000000] rowid=[156] | ref=[SI2606-0199] | fk_soc=[314] | total_ttc=[3085.63000000] | paye=[1] | fk_statut=[2] | regle=[3085.63000000] rowid=[190] | ref=[SI2607-0051] | fk_soc=[314] | total_ttc=[316.48000000] | paye=[1] | fk_statut=[2] | regle=[316.48000000] rowid=[513] | ref=[SI2608-0276] | fk_soc=[314] | total_ttc=[1887.65000000] | paye=[1] | fk_statut=[2] | regle=[1887.65000000] rowid=[537] | ref=[SI2608-0300] | fk_soc=[314] | total_ttc=[2867.40000000] | paye=[1] | fk_statut=[2] | regle=[2867.40000000] rowid=[399] | ref=[SI2603-0192] | fk_soc=[372] | total_ttc=[425.70000000] | paye=[1] | fk_statut=[2] | regle=[425.70000000] rowid=[400] | ref=[SI2604-0193] | fk_soc=[372] | total_ttc=[3807.98000000] | paye=[1] | fk_statut=[2] | regle=[3807.98000000] rowid=[401] | ref=[SI2606-0194] | fk_soc=[372] | total_ttc=[1926.92000000] | paye=[1] | fk_statut=[2] | regle=[1926.92000000] rowid=[408] | ref=[SI2607-0198] | fk_soc=[372] | total_ttc=[209.09000000] | paye=[1] | fk_statut=[2] | regle=[209.09000000] -- 9 ligne(s) ===== 13. Detail paiement 94 ===== fk_paiementfourn=[94] | ref=[SI2605-0039] | amount=[17437.10000000] | fk_soc=[282] | nom=[ALMET PARIS] fk_paiementfourn=[94] | ref=[SI2605-0050] | amount=[4466.34000000] | fk_soc=[314] | nom=[ArcelorMittal Distribution Solutions France] fk_paiementfourn=[94] | ref=[SI2607-0051] | amount=[316.48000000] | fk_soc=[314] | nom=[ArcelorMittal Distribution Solutions France] -- 3 ligne(s) ===== 14. Fiches vides ? (tous rattachements) ===== rowid=[314] | nom=[ArcelorMittal Distribution Solutions France] | status=[1] | ff=[5] | cf=[3] | ct=[0] | pfp=[0] | bu=[3] rowid=[320] | nom=[Shenzhenshi Fengmaishiyeyouxiangongsi] | status=[1] | ff=[1] | cf=[0] | ct=[0] | pfp=[0] | bu=[0] rowid=[349] | nom=[shenzhenshiluanniaomaoyiyouxiangongsi] | status=[1] | ff=[0] | cf=[0] | ct=[0] | pfp=[0] | bu=[0] rowid=[369] | nom=[EQUIPEMENTS SCIENTIFIQUES S.A.S] | status=[1] | ff=[1] | cf=[0] | ct=[0] | pfp=[0] | bu=[1] rowid=[371] | nom=[EDF] | status=[0] | ff=[0] | cf=[0] | ct=[0] | pfp=[0] | bu=[0] rowid=[372] | nom=[ARCELOR MITTAL] | status=[1] | ff=[4] | cf=[0] | ct=[0] | pfp=[0] | bu=[4] -- 6 ligne(s)