You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
121 lines
2.4 KiB
121 lines
2.4 KiB
columns:
|
|
ajustement:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
cle_originale:
|
|
type: text
|
|
default: "''::text"
|
|
clinique_honoraire:
|
|
type: character(1)
|
|
comptabilisee:
|
|
type: character(1)
|
|
default: "'1'::bpchar"
|
|
compte_contrepartie_id:
|
|
type: bigint
|
|
default: "0"
|
|
compte_extra_id:
|
|
type: bigint
|
|
compte_id:
|
|
type: bigint
|
|
not_null: NOT NULL
|
|
date_echeance:
|
|
type: date
|
|
date_ecriture:
|
|
type: date
|
|
not_null: NOT NULL
|
|
date_facture_fournisseur:
|
|
type: date
|
|
dossier:
|
|
type: text
|
|
default: "''::text"
|
|
ecriture_consolidee:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
ecriture_exclue:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
exercice_comptable:
|
|
type: numeric
|
|
facture_soldee:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
fin_exercice:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
identifiant_operation:
|
|
type: text
|
|
default: "''::text"
|
|
inter_site:
|
|
type: character(1)
|
|
default: "'0'::bpchar"
|
|
journal_id:
|
|
type: bigint
|
|
journal_paiement_id:
|
|
type: bigint
|
|
default: "0"
|
|
mode_paiement_id:
|
|
type: bigint
|
|
default: "0"
|
|
mois_comptable:
|
|
type: numeric
|
|
montant_credit:
|
|
type: numeric
|
|
montant_debit:
|
|
type: numeric
|
|
numero_cheque:
|
|
type: text
|
|
partenaire_id:
|
|
type: bigint
|
|
default: "0"
|
|
piece:
|
|
type: text
|
|
default: "''::text"
|
|
section_analytique_id:
|
|
type: bigint
|
|
site_id:
|
|
type: bigint
|
|
default: "0"
|
|
texte:
|
|
type: text
|
|
type_compta_id:
|
|
type: bigint
|
|
indexes:
|
|
i_ecriture_fournisseur_1:
|
|
column: mois_comptable
|
|
method: btree
|
|
i_ecriture_fournisseur_10:
|
|
column: fin_exercice
|
|
method: btree
|
|
i_ecriture_fournisseur_11:
|
|
column: ajustement
|
|
method: btree
|
|
i_ecriture_fournisseur_12:
|
|
column: partenaire_id
|
|
method: btree
|
|
i_ecriture_fournisseur_13:
|
|
column: identifiant_operation
|
|
method: btree
|
|
i_ecriture_fournisseur_2:
|
|
column: compte_id
|
|
method: btree
|
|
i_ecriture_fournisseur_3:
|
|
column: comptabilisee
|
|
method: btree
|
|
i_ecriture_fournisseur_4:
|
|
column: compte_extra_id
|
|
method: btree
|
|
i_ecriture_fournisseur_5:
|
|
column: cle_originale
|
|
method: btree
|
|
i_ecriture_fournisseur_6:
|
|
column: journal_id
|
|
method: btree
|
|
i_ecriture_fournisseur_7:
|
|
column: date_ecriture
|
|
method: btree
|
|
i_ecriture_fournisseur_8:
|
|
column: dossier
|
|
method: btree
|
|
i_ecriture_fournisseur_9:
|
|
column: site_id
|
|
method: btree
|