=== COLONNES llx_paiementfourn ===
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment
Field=ref | Type=varchar(30) | Null=YES | Key= | Default= | Extra=
Field=entity | Type=int | Null=YES | Key= | Default=1 | 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= | Extra=
Field=datep | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=amount | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_amount | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=fk_user_author | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_user_modif | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_paiement | Type=int | Null=NO | Key= | Default= | Extra=
Field=num_paiement | Type=varchar(50) | Null=YES | Key= | Default= | Extra=
Field=note | Type=text | Null=YES | Key= | Default= | Extra=
Field=fk_bank | Type=int | Null=NO | Key= | Default= | Extra=
Field=statut | Type=smallint | Null=NO | Key= | Default=0 | Extra=
Field=model_pdf | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
-- 16 ligne(s)

=== COLONNES llx_paiementfourn_facturefourn ===
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment
Field=fk_paiementfourn | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=fk_facturefourn | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=amount | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
Field=multicurrency_code | Type=varchar(3) | Null=YES | Key= | Default= | Extra=
Field=multicurrency_tx | Type=double(24,8) | Null=YES | Key= | Default=1.00000000 | Extra=
Field=multicurrency_amount | Type=double(24,8) | Null=YES | Key= | Default=0.00000000 | Extra=
-- 7 ligne(s)

=== COLONNES llx_facture_fourn ===
Field=rowid | Type=int | Null=NO | Key=PRI | Default= | Extra=auto_increment
Field=ref | Type=varchar(180) | Null=NO | Key=MUL | Default= | Extra=
Field=ref_supplier | Type=varchar(180) | Null=NO | Key=MUL | Default= | Extra=
Field=entity | Type=int | Null=NO | Key= | Default=1 | Extra=
Field=ref_ext | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=type | Type=smallint | Null=NO | Key= | Default=0 | Extra=
Field=subtype | Type=smallint | Null=YES | Key= | Default= | Extra=
Field=fk_soc | Type=int | Null=NO | Key=MUL | Default= | Extra=
Field=datec | Type=datetime | Null=YES | Key= | Default= | Extra=
Field=datef | Type=date | Null=YES | Key= | Default= | Extra=
Field=date_pointoftax | Type=date | Null=YES | Key= | Default= | Extra=
Field=date_valid | Type=date | Null=YES | Key= | Default= | 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= | Extra=
Field=libelle | Type=varchar(255) | Null=YES | Key= | Default= | 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= | Extra=
Field=close_missing_amount | Type=double(24,8) | Null=YES | Key= | Default= | Extra=
Field=close_note | Type=varchar(128) | Null=YES | Key= | Default= | 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= | Extra=
Field=fk_user_modif | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_user_valid | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=fk_user_closing | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_fac_rec_source | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_facture_source | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_projet | Type=int | Null=YES | Key=MUL | Default= | Extra=
Field=fk_account | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_cond_reglement | Type=int | Null=YES | Key= | Default= | Extra=
Field=fk_mode_reglement | Type=int | Null=YES | Key= | Default= | Extra=
Field=date_lim_reglement | Type=date | Null=YES | Key=MUL | Default= | Extra=
Field=note_private | Type=text | Null=YES | Key= | Default= | Extra=
Field=note_public | Type=text | Null=YES | Key= | Default= | Extra=
Field=fk_incoterms | Type=int | Null=YES | Key= | Default= | Extra=
Field=location_incoterms | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=fk_transport_mode | Type=int | Null=YES | Key= | Default= | Extra=
Field=model_pdf | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=last_main_doc | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=import_key | Type=varchar(14) | Null=YES | Key= | Default= | Extra=
Field=extraparams | Type=varchar(255) | Null=YES | Key= | Default= | Extra=
Field=fk_multicurrency | Type=int | Null=YES | Key= | Default= | Extra=
Field=multicurrency_code | Type=varchar(3) | Null=YES | Key= | Default= | 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= | Extra=
Field=payment_reference | Type=varchar(25) | Null=YES | Key= | Default= | Extra=
Field=dispute_status | Type=int | Null=YES | Key= | Default=0 | Extra=
-- 59 ligne(s)