Table alter.public.mis_parties 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
party_id int4 10
mis_addresses.party_id mis_addresses_party_id_fkey
mis_bids.customer_id mis_bids_customer_id_fk
mis_cust_price_map.customer_id mis_cust_price_map_customer_id_fkey
mis_customers.party_id Implied Constraint
mis_customers_products_map.customer_id mis_customers_products_map_customer_id_fkey
mis_delivery_notes.party_id mis_delivery_notes_party_id_fkey
mis_export_declarations.party_id mis_export_declarations_party_id_fkey
mis_fast_customers.party_id Implied Constraint
mis_fast_delivery_notes.party_id Implied Constraint
mis_fast_parties.party_id Implied Constraint
mis_fast_vendors.party_id Implied Constraint
mis_orders.customer_id mis_orders_customer_id_fk
mis_party_accounts.party_id mis_party_accounts_party_id_fkey
mis_pos.vendor_id mis_pos_vendor_id_fk
mis_projects.customer_id mis_projects_customer_id_fkey
mis_purc_invoices.vendor_id mis_purc_invoices_vendor_id_fkey
mis_purc_price_lists.vendor_id mis_purc_price_lists_vendor_id_fkey
mis_quotations.vendor_id mis_quotations_vendor_id_fkey
mis_sale_invoices.customer_id mis_sale_invoices_customer_id_fkey
mis_sap_parties.party_id mis_sap_parties_party_id_fkey
mis_stores.vendor_id mis_stores_vendor_id_fkey
mis_vendors.party_id Implied Constraint
mis_vendors_products_map.vendor_id mis_vendors_products_map_vendor_id_fkey
mis_wh_mov.wh_mov_party_id mis_wh_mov_wh_mov_party_id_fkey
acs_objects.object_id mis_parties_party_id_fkey
party_code varchar 30  √  null
party_type bpchar 1  √  null F=persona fisica G=persona giuridica
party_type_id int4 10  √  null
categories.category_id mis_parties_fk_party_type_id
tipi soggetto (terzista, grossista, dipendente, socio ecc.)
iva_code bpchar 11  √  null partita IVA
iva_id int4 10  √  null
mis_iva.iva_id mis_parties_fk_iva_id
codice imposta IVA; se presente prevale in fattura su quello dell'articolo
fiscal_code bpchar 16  √  null
is_active_p bool 1  √  null
is_customer_p bool 1  √  null
is_vendor_p bool 1  √  null
upper_title varchar 1000  √  null Ragione sociale maiuscola.
(title column stored in acs_objects)
description text 2147483647  √  null
language_id bpchar 2  √  null
language_codes.language_id mis_parties_fk_language_id
currency bpchar 3  √  null
currencies.codea mis_parties_fk_currency
discount numeric 5,2  √  null
credit_limit numeric 13,2  √  null
ddt_grouping_p bool 1  √  null indica se i DDT del cliente debbano essere raggruppati o meno
company_bank_id int4 10  √  null
mis_banks.bank_id mis_parties_fk_bank_id
Questa è la banca che l'azienda normalmente utilizza nei rapporti con questo
soggetto per le operazioni di pagamento ed incasso.
port_id int4 10  √  null
categories.category_id mis_parties_fk_port_id
payment_id int4 10  √  null
mis_payments.payment_id mis_parties_fk_payment_id
shipping_id int4 10  √  null
categories.category_id mis_parties_fk_shipping_id
zone_id int4 10  √  null
categories.category_id mis_parties_fk_zone_id
sale_rep_id int4 10  √  null
categories.category_id mis_parties_fk_sale_rep_id
default_address_id int4 10  √  null
mis_addresses.address_id mis_parties_fk_default_address_id
contatti
l'indirizzo della Sede Legale viene memorizzato nella tabella mis_addresses con la
colonna address_code=001 mentre l' indirizzo abituale di spedizione viene referenziato
dalla colonna default_address_id

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
party_id Primary key Asc mis_parties_pkey  
party_code Must be unique Asc mis_parties_indx_party_code This unique column is also nullable
upper_title Performance Asc mis_parties_indx_upper_title  

Close relationships  within one two degrees of separation :