Table alter.public.mis_purc_invoices
Fatture d'acquisto

 Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
purc_invoice_id int4 10
mis_fast_purc_invoice_lines.purc_invoice_id Implied Constraint
mis_fast_purc_invoices.purc_invoice_id Implied Constraint
mis_fast_purc_iva.purc_invoice_id Implied Constraint
mis_purc_invoice_lines.purc_invoice_id mis_purc_invoice_lines_purc_invoice_id_fkey
mis_purc_invoices.purc_invoice_ref_id mis_purc_invoices_purc_invoice_ref_id_fkey
mis_purc_iva.purc_invoice_id mis_purc_iva_purc_invoice_id_fkey
mis_purc_paydates.purc_invoice_id mis_purc_paydates_purc_invoice_id_fkey
mis_purc_paydates_view.purc_invoice_id Implied Constraint
acs_objects.object_id mis_purc_invoices_purc_invoice_id_fkey
invoice_year int4 10
invoice_num varchar 30
invoice_date date 13
vendor_id int4 10
mis_parties.party_id mis_purc_invoices_vendor_id_fkey
invoice_ref_num varchar 20  √  null
invoice_ref_date date 13  √  null
payment_date date 13  √  null
invoice_type_id int4 10  √  null
mis_invoice_types.invoice_type_id mis_purc_invoices_invoice_type_id_fkey
purc_invoice_ref_id int4 10  √  null
mis_purc_invoices.purc_invoice_id mis_purc_invoices_purc_invoice_ref_id_fkey
Se nota di credito, referenzia la fattura accreditata.
sale_invoice_ref_id int4 10  √  null Riferimento alla fattura di vendita eventualmente generata.
payment_id int4 10  √  null
mis_payments.payment_id mis_purc_invoices_payment_id_fkey
bank_id int4 10  √  null
mis_banks.bank_id mis_purc_invoices_bank_id_fkey
is_accounted_p bool 1  √  null
is_paid_p bool 1  √  null
is_confirmed_p bool 1  √  null
invoice_amount numeric 13,2  √  null
invoice_notes text 2147483647  √  null
cee_currency bpchar 3  √  null
currencies.codea mis_purc_invoices_cee_currency_fkey
cee_amount numeric 13,2  √  null
ra_amount numeric 13,2  √  null

Table contained 3 rows at Fri Feb 29 12:05 CET 2008

Indexes:
Column(s) Type Sort Constraint Name
purc_invoice_id Primary key Asc mis_purc_invoices_pkey
invoice_year + invoice_num Must be unique Asc/Asc mis_purc_invoices_indx
vendor_id Performance Asc mis_purc_invoices_indx2

Close relationships  within one two degrees of separation :