SchemaSpy Analysis of alter.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Fri Feb 29 12:05 CET 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
alter.public contains 2620 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
abi mis_banks bpchar 5  √  null
abi mis_banks_view bpchar 5  √  null
abstract_p acs_object_types bool 1 false ...
If the object_type is not abstract, then all of its attributes must
have a non-null storage specified.
acc_405 mis_acct_iva numeric 13,2  √  null
accepted_on mis_bids date 13  √  null
accepted_on mis_fast_bids date 13  √  null
accepted_on_pretty mis_fast_bids text 2147483647  √  null
accepted_on_widget mis_fast_bids text 2147483647  √  null
account_class mis_accounts bpchar 1  √  null E=Economico P=Patrimoniale
account_class mis_accounts_view bpchar 1  √  null
account_class mis_canonical_accounts bpchar 1  √  null
account_code mis_accounts varchar 30  √  null
account_code mis_accounts_view varchar 30  √  null
account_code mis_canonical_accounts varchar 30  √  null
account_description mis_accounts varchar 50  √  null
account_description mis_accounts_view varchar 50  √  null
account_description mis_canonical_accounts varchar 50  √  null
account_id mis_accounts int4 10
mis_accounts_view.account_id Implied Constraint
mis_acct_plan.child_id mis_acct_plan_child_id_fkey
mis_acct_plan.parent_id mis_acct_plan_parent_id_fkey
mis_bank_accounts.account_id mis_bank_accounts_account_id_fkey
mis_bank_accounts.factoring_account_id mis_bank_accounts_factoring_account_id_fkey
mis_bank_accounts.pres_account_id mis_bank_accounts_pres_account_id_fkey
mis_bank_accounts.unsolved_account_id mis_bank_accounts_unsolved_account_id_fkey
mis_banks_view.account_id Implied Constraint
mis_canonical_accounts.account_id Implied Constraint
mis_centers.center_id mis_centers_center_id_fkey
mis_delivery_note_lines.account_id mis_delivery_note_lines_account_id_fkey
mis_fast_delivery_note_lines.account_id Implied Constraint
mis_fast_mrs.account_id Implied Constraint
mis_fast_po_lines.account_id Implied Constraint
mis_fast_pos.account_id Implied Constraint
mis_fast_purc_invoice_lines.account_id Implied Constraint
mis_fast_sale_invoice_lines.account_id Implied Constraint
mis_mov_accounts.account_id mis_mov_accounts_account_id_fkey
mis_mov_accounts_view.account_id Implied Constraint
mis_mrs.account_id mis_mrs_account_id_fk
mis_party_accounts.fin_account_id mis_party_accounts_fin_account_id_fkey
mis_party_accounts.mgm_account_id mis_party_accounts_mgm_account_id_fkey
mis_po_lines.account_id mis_po_lines_account_id_fk
mis_pos.account_id mis_mrs_account_id_fk
mis_product_categories.account_id mis_product_categories_account_id_fkey
mis_projects.project_id mis_projects_project_id_fkey
mis_purc_invoice_lines.account_id mis_purc_invoice_lines_account_id_fkey
mis_sale_invoice_lines.account_id mis_sale_invoice_lines_account_id_fkey
acs_objects.object_id mis_accounts_account_id_fkey
account_id mis_accounts_view int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_bank_accounts int4 10  √  null
mis_accounts.account_id mis_bank_accounts_account_id_fkey
account_id mis_banks_view int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_canonical_accounts int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_delivery_note_lines int4 10  √  null
mis_accounts.account_id mis_delivery_note_lines_account_id_fkey
account_id mis_fast_delivery_note_lines int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_fast_mrs int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_fast_po_lines int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_fast_pos int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_fast_purc_invoice_lines int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_fast_sale_invoice_lines int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_mov_accounts int4 10
mis_accounts.account_id mis_mov_accounts_account_id_fkey
account_id mis_mov_accounts_view int4 10  √  null
mis_accounts.account_id Implied Constraint
account_id mis_mrs int4 10  √  null
mis_accounts.account_id mis_mrs_account_id_fk
Imputazione del materiale richiesto.
Il riferimento puņ essere al cliente oppure ad una specifica commessa (per la quale č stato definito un'apposito conto)
oppure ad una commessa di magazzino. Quest'ultima viene assunta per default in caso di omissione.
account_id mis_po_lines int4 10  √  null
mis_accounts.account_id mis_po_lines_account_id_fk
account_id mis_pos int4 10  √  null
mis_accounts.account_id mis_mrs_account_id_fk
Imputazione del materiale acquistato.
Il riferimento puņ essere al cliente oppure ad una specifica commessa (per la quale č stato definito un'apposito conto)
oppure ad una commessa di magazzino. Quest'ultima viene assunta per default in caso di omissione.
account_id mis_product_categories int4 10  √  null
mis_accounts.account_id mis_product_categories_account_id_fkey
account_id mis_purc_invoice_lines int4 10  √  null
mis_accounts.account_id mis_purc_invoice_lines_account_id_fkey
account_id mis_sale_invoice_lines int4 10  √  null
mis_accounts.account_id mis_sale_invoice_lines_account_id_fkey
acct_iva_id mis_acct_iva int4 10
acct_iva_month mis_acct_iva int4 10  √  null
acct_iva_month mis_iva_ctr int4 10  √  null
acct_iva_year mis_acct_iva int4 10  √  null
acct_iva_year mis_iva_ctr int4 10  √  null
acct_mov_acc_amount mis_mov_accounts numeric 13,2  √  null
acct_mov_acc_amount mis_mov_accounts_view numeric 13,2  √  null
acct_mov_acc_amount_pretty mis_mov_accounts_view varchar 2147483647  √  null
acct_mov_acc_notes mis_mov_accounts text 2147483647  √  null
acct_mov_acc_notes mis_mov_accounts_view text 2147483647  √  null
acct_mov_amount mis_acct_mov numeric 13,2  √  null
acct_mov_amount mis_acct_mov_view numeric 13,2  √  null
acct_mov_amount_pretty mis_acct_mov_view varchar 2147483647  √  null
acct_mov_avere mis_mov_accounts_view numeric 131089  √  null
acct_mov_avere_pretty mis_mov_accounts_view varchar 2147483647  √  null
acct_mov_dare mis_mov_accounts_view numeric 131089  √  null
acct_mov_dare_pretty mis_mov_accounts_view varchar 2147483647  √  null
acct_mov_date mis_acct_mov date 13
acct_mov_date mis_acct_mov_view date 13  √  null
acct_mov_date_pretty mis_acct_mov_view text 2147483647  √  null
acct_mov_date_widget mis_acct_mov_view text 2147483647  √  null
acct_mov_description mis_acct_mov varchar 100  √  null
acct_mov_description mis_acct_mov_view varchar 100  √  null
acct_mov_id mis_acct_mov int4 10
mis_acct_mov_view.acct_mov_id Implied Constraint
mis_mov_accounts.acct_mov_id mis_mov_accounts_acct_mov_id_fkey
mis_mov_accounts_view.acct_mov_id Implied Constraint
acct_mov_id mis_acct_mov_view int4 10  √  null
mis_acct_mov.acct_mov_id Implied Constraint
acct_mov_id mis_mov_accounts int4 10
mis_acct_mov.acct_mov_id mis_mov_accounts_acct_mov_id_fkey
acct_mov_id mis_mov_accounts_view int4 10  √  null
mis_acct_mov.acct_mov_id Implied Constraint
acct_mov_record_date mis_acct_mov date 13
acct_mov_record_date mis_acct_mov_view date 13  √  null
acct_mov_record_date_pretty mis_acct_mov_view text 2147483647  √  null
acct_mov_record_date_widget mis_acct_mov_view text 2147483647  √  null
acct_mov_ref_date mis_acct_mov date 13  √  null
acct_mov_ref_date mis_acct_mov_view date 13  √  null
acct_mov_ref_date_pretty mis_acct_mov_view text 2147483647  √  null
acct_mov_ref_date_widget mis_acct_mov_view text 2147483647  √  null
acct_mov_ref_doc mis_acct_mov varchar 100  √  null
acct_mov_ref_doc mis_acct_mov_view varchar 100  √  null
acct_mov_user mis_acct_mov int4 10  √  null
users.user_id mis_acct_mov_acct_mov_user_fkey
acct_mov_user mis_acct_mov_view int4 10  √  null
acct_plan_id mis_acct_plan int4 10
acct_plan_type_code mis_acct_plan_types varchar 30  √  null
acct_plan_type_description mis_acct_plan_types varchar 100  √  null
acct_plan_type_id mis_acct_plan int4 10
mis_acct_plan_types.acct_plan_type_id mis_acct_plan_acct_plan_type_id_fkey
acct_plan_type_id mis_acct_plan_types int4 10
mis_acct_plan.acct_plan_type_id mis_acct_plan_acct_plan_type_id_fkey
acct_ref mis_bill_types_with_counter varchar 1  √  null
acct_schema_code mis_acct_schema varchar 30  √  null
acct_schema_description mis_acct_schema varchar 100  √  null
acct_schema_id mis_acct_mov int4 10
mis_acct_schema.acct_schema_id mis_acct_mov_acct_schema_id_fkey
acct_schema_id mis_acct_mov_view int4 10  √  null
mis_acct_schema.acct_schema_id Implied Constraint
acct_schema_id mis_acct_schema int4 10
mis_acct_mov.acct_schema_id mis_acct_mov_acct_schema_id_fkey
mis_acct_mov_view.acct_schema_id Implied Constraint
mis_invoice_types.acct_schema_id mis_invoice_types_acct_schema_id_fkey
mis_purc_operations.acct_schema_id Implied Constraint
mis_sale_operations.acct_schema_id Implied Constraint
acct_schema_id mis_invoice_types int4 10  √  null
mis_acct_schema.acct_schema_id mis_invoice_types_acct_schema_id_fkey
acct_schema_id mis_purc_operations int4 10  √  null
mis_acct_schema.acct_schema_id Implied Constraint
acct_schema_id mis_sale_operations int4 10  √  null
mis_acct_schema.acct_schema_id Implied Constraint
ack_required_p mis_fast_pos bool 1  √  null
ack_required_p mis_pos bool 1  √  null
address1 mis_addresses varchar 32
address1 mis_customers varchar 32  √  null
address1 mis_fast_customers varchar 32  √  null
address1 mis_fast_parties varchar 32  √  null
address1 mis_fast_vendors varchar 32  √  null
address1 mis_vendors varchar 32  √  null
address2 mis_addresses varchar 32  √  null
address2 mis_customers varchar 32  √  null
address2 mis_fast_customers varchar 32  √  null
address2 mis_fast_parties varchar 32  √  null
address2 mis_fast_vendors varchar 32  √  null
address2 mis_vendors varchar 32  √  null
address_code mis_addresses varchar 10 Codice identificativo univoco dell'indirizzo. Il codice 001 č magico ed individua
l'indirizzo della Sede Legale
address_code mis_customers varchar 10  √  null
address_code mis_fast_customers varchar 10  √  null
address_code mis_fast_parties varchar 10  √  null
address_code mis_fast_vendors varchar 10  √  null
address_code mis_vendors varchar 10  √  null
address_id mis_addresses int4 10
mis_all_orders.address_id Implied Constraint
mis_bids.address_id mis_bids_fk_address_id
mis_customers.address_id Implied Constraint
mis_delivery_notes.address_id mis_delivery_notes_address_id_fkey
mis_fast_bids.address_id Implied Constraint
mis_fast_customers.address_id Implied Constraint
mis_fast_delivery_notes.address_id Implied Constraint
mis_fast_orders.address_id Implied Constraint
mis_fast_parties.address_id Implied Constraint
mis_fast_vendors.address_id Implied Constraint
mis_orders.address_id mis_orders_address_id_fk
mis_parties.default_address_id mis_parties_fk_default_address_id
mis_vendors.address_id Implied Constraint
address_id mis_all_orders int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_bids int4 10  √  null
mis_addresses.address_id mis_bids_fk_address_id
address_id mis_customers int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_delivery_notes int4 10  √  null
mis_addresses.address_id mis_delivery_notes_address_id_fkey
address_id mis_fast_bids int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_fast_customers int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_fast_delivery_notes int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_fast_orders int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_fast_parties int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_fast_vendors int4 10  √  null
mis_addresses.address_id Implied Constraint
address_id mis_orders int4 10  √  null
mis_addresses.address_id mis_orders_address_id_fk
address_id mis_vendors int4 10  √  null
mis_addresses.address_id Implied Constraint
address_name mis_addresses varchar 32  √  null
address_name mis_customers varchar 32  √  null
address_name mis_fast_customers varchar 32  √  null
address_name mis_fast_parties varchar 32  √  null
address_name mis_fast_vendors varchar 32  √  null
address_name mis_vendors varchar 32  √  null
amount mis_customer_dates numeric 13,2  √  null
amount mis_fast_sale_iva numeric 131089  √  null
amount mis_projects numeric 13,2  √  null
amount mis_projects_view numeric 13,2  √  null
amount mis_purc_paydates numeric 13,2  √  null
amount mis_purc_paydates_view numeric 131089  √  null
amount mis_sale_paydates numeric 13,2  √  null
amount mis_sale_paydates_view numeric 131089  √  null
amount_paid mis_sale_paydates numeric 13,2  √  null
amount_paid mis_sale_paydates_view numeric 131089  √  null
amount_paid_pretty mis_sale_paydates_view varchar 2147483647  √  null
amount_pretty mis_fast_sale_iva varchar 2147483647  √  null
amount_pretty mis_projects_view varchar 2147483647  √  null
amount_pretty mis_purc_paydates_view varchar 2147483647  √  null
amount_pretty mis_sale_paydates_view varchar 2147483647  √  null
amount_to_pay mis_sale_paydates_view numeric 131089  √  null
amount_to_pay_pretty mis_sale_paydates_view varchar 2147483647  √  null
auth_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_auth_impl_fk
auth_token users varchar 100  √  null
authority_id auth_authorities int4 10
users.authority_id users_auth_authorities_fk
acs_objects.object_id auth_authorities_aid_fk
authority_id users int4 10  √  null
auth_authorities.authority_id users_auth_authorities_fk
available_plafond mis_acct_iva numeric 13,2  √  null
bank_code mis_banks varchar 10  √  null
bank_code mis_banks_view varchar 10  √  null
bank_description mis_banks varchar 50  √  null
bank_description mis_banks_view varchar 50  √  null
bank_id mis_addresses int4 10  √  null
mis_banks.bank_id mis_addresses_bank_id_fkey
Questa č la banca del soggetto in questa specifica ubicazione.
bank_id mis_all_orders int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_bank_accounts int4 10
mis_banks.bank_id mis_bank_accounts_bank_id_fkey
bank_id mis_banks int4 10
mis_addresses.bank_id mis_addresses_bank_id_fkey
mis_all_orders.bank_id Implied Constraint
mis_bank_accounts.bank_id mis_bank_accounts_bank_id_fkey
mis_banks.effect_bank_id mis_banks_effect_bank_id_fkey
mis_banks_view.bank_id Implied Constraint
mis_bids.bank_id mis_bids_fk_bank_id
mis_customer_dates.effect_bank_id mis_customer_dates_effect_bank_id_fkey
mis_customer_payments.presentation_bank_id mis_customer_payments_presentation_bank_id_fkey
mis_customers.bank_id Implied Constraint
mis_delivery_notes.bank_id mis_delivery_notes_bank_id_fkey
mis_effects.effect_bank_id mis_effects_effect_bank_id_fkey
mis_fast_bids.bank_id Implied Constraint
mis_fast_customers.bank_id Implied Constraint
mis_fast_delivery_notes.bank_id Implied Constraint
mis_fast_orders.bank_id Implied Constraint
mis_fast_parties.bank_id Implied Constraint
mis_fast_pos.bank_id Implied Constraint
mis_fast_purc_invoices.bank_id Implied Constraint
mis_fast_rec_notes.bank_id Implied Constraint
mis_fast_sale_invoices.bank_id Implied Constraint
mis_fast_vendors.bank_id Implied Constraint
mis_orders.bank_id mis_orders_fk_bank_id
mis_parties.company_bank_id mis_parties_fk_bank_id
mis_pos.bank_id mis_pos_fk_bank_id
mis_purc_invoices.bank_id mis_purc_invoices_bank_id_fkey
mis_purc_paydates.effect_bank_id mis_purc_paydates_effect_bank_id_fkey
mis_purc_paydates_view.bank_id Implied Constraint
mis_rec_notes.bank_id mis_rec_notes_bank_id_fkey
mis_sale_invoices.bank_id mis_sale_invoices_bank_id_fkey
mis_sale_invoices.factoring_bank_id mis_sale_invoices_factoring_bank_id_fkey
mis_sale_invoices_view.bank_id Implied Constraint
mis_sale_paydates.bank_id mis_sale_paydates_bank_id_fkey
mis_sale_paydates.effect_bank_id mis_sale_paydates_effect_bank_id_fkey
mis_sale_paydates_view.bank_id Implied Constraint
mis_vendors.bank_id Implied Constraint
bank_id mis_banks_view int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_bids int4 10  √  null
mis_banks.bank_id mis_bids_fk_bank_id
bank_id mis_customers int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_delivery_notes int4 10  √  null
mis_banks.bank_id mis_delivery_notes_bank_id_fkey
bank_id mis_fast_bids int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_customers int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_delivery_notes int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_orders int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_parties int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_pos int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_purc_invoices int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_rec_notes int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_sale_invoices int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_fast_vendors int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_orders int4 10  √  null
mis_banks.bank_id mis_orders_fk_bank_id
bank_id mis_pos int4 10  √  null
mis_banks.bank_id mis_pos_fk_bank_id
bank_id mis_purc_invoices int4 10  √  null
mis_banks.bank_id mis_purc_invoices_bank_id_fkey
bank_id mis_purc_paydates_view int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_rec_notes int4 10  √  null
mis_banks.bank_id mis_rec_notes_bank_id_fkey
bank_id mis_sale_invoices int4 10  √  null
mis_banks.bank_id mis_sale_invoices_bank_id_fkey
bank_id mis_sale_invoices_view int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_sale_paydates int4 10  √  null
mis_banks.bank_id mis_sale_paydates_bank_id_fkey
bank_id mis_sale_paydates_view int4 10  √  null
mis_banks.bank_id Implied Constraint
bank_id mis_vendors int4 10  √  null
mis_banks.bank_id Implied Constraint
base_store_id mis_plants int4 10  √  null
mis_stores.store_id mis_plants_fk_base_store_id
Magazzino prodotti finiti di default per questo plant.
batch_sync_enabled_p auth_authorities bool 1 false
bid_code mis_bids varchar 20  √  null
bid_code mis_fast_bids varchar 20  √  null
bid_date mis_bids date 13  √  null
bid_date mis_fast_bids date 13  √  null
bid_date_pretty mis_fast_bids text 2147483647  √  null
bid_date_widget mis_fast_bids text 2147483647  √  null
bid_id mis_all_orders int4 10  √  null
mis_bids.bid_id Implied Constraint
bid_id mis_bid_lines int4 10
mis_bids.bid_id mis_bid_lines_bid_id
bid_id mis_bids int4 10
mis_all_orders.bid_id Implied Constraint
mis_bid_lines.bid_id mis_bid_lines_bid_id
mis_fast_bid_lines.bid_id Implied Constraint
mis_fast_bids.bid_id Implied Constraint
mis_fast_orders.bid_id Implied Constraint
mis_orders.bid_id mis_orders_bid_id_fk
mis_projects.bid_id mis_projects_bid_id_fkey
mis_projects_view.bid_id Implied Constraint
acs_objects.object_id mis_bids_bid_id_fkey
bid_id mis_fast_bid_lines int4 10  √  null
mis_bids.bid_id Implied Constraint
bid_id mis_fast_bids int4 10  √  null
mis_bids.bid_id Implied Constraint
bid_id mis_fast_orders int4 10  √  null
mis_bids.bid_id Implied Constraint
bid_id mis_orders int4 10  √  null
mis_bids.bid_id mis_orders_bid_id_fk
bid_id mis_projects int4 10  √  null
mis_bids.bid_id mis_projects_bid_id_fkey
bid_id mis_projects_view int4 10  √  null
mis_bids.bid_id Implied Constraint
bill_type_code mis_bill_types varchar 3  √  null
bill_type_code mis_bill_types_with_counter varchar 3  √  null
bill_type_description mis_bill_types varchar 50  √  null
bill_type_description mis_bill_types_with_counter varchar 50  √  null
bill_type_id mis_bill_types int4 10
mis_bill_types_with_counter.bill_type_id Implied Constraint
mis_delivery_notes.bill_type_id mis_delivery_notes_bill_type_id_fkey
mis_fast_delivery_notes.bill_type_id Implied Constraint
mis_fast_rec_notes.bill_type_id Implied Constraint
mis_rec_notes.bill_type_id mis_rec_notes_bill_type_id_fkey
bill_type_id mis_bill_types_with_counter int4 10  √  null
mis_bill_types.bill_type_id Implied Constraint
bill_type_id mis_delivery_notes int4 10  √  null
mis_bill_types.bill_type_id mis_delivery_notes_bill_type_id_fkey
bill_type_id mis_fast_delivery_notes int4 10  √  null
mis_bill_types.bill_type_id Implied Constraint
bill_type_id mis_fast_rec_notes int4 10  √  null
mis_bill_types.bill_type_id Implied Constraint
bill_type_id mis_rec_notes int4 10  √  null
mis_bill_types.bill_type_id mis_rec_notes_bill_type_id_fkey
brand_code mis_brands varchar 200  √  null
brand_description mis_brands varchar 4000  √  null
brand_id mis_active_products int4 10  √  null
brand_id mis_brands int4 10  √  null
brand_id mis_fast_products int4 10  √  null
brand_id mis_products int4 10  √  null
categories.category_id mis_product_brand_id_fk
brand_id mis_purc_products_with_prices int4 10  √  null
brand_id mis_quotations_view int4 10  √  null
cab mis_banks bpchar 5  √  null
cab mis_banks_view bpchar 5  √  null
canonical_p mis_accounts bool 1  √  null I codici dei conti <em>canonici</em> devono avere una lunghezza coerente rispetto a quanto
stabilito nei parametri master_length, submaster_length e subcode_length.
Inoltre per i conti canonici viene mantenuta automaticamente la struttura gerarchica del
piano dei conti canonico.
I conti identificati come NON <em>canonici</em> possono invece avere qualsiasi lunghezza
e NON fanno parte del piano dei conti canonico, ma possono essere usati nei piani dei conti
riclassificati ovvero per rappresentare delle imputazioni di contabilitą industriale (ad.es.
progetti e CDC).
canonical_p mis_accounts_view bool 1  √  null
canonical_p mis_canonical_accounts bool 1  √  null
carrier_code mis_carriers varchar 200  √  null
carrier_description mis_carriers varchar 4000  √  null
carrier_id mis_bids int4 10  √  null
categories.category_id mis_bids_fk_carrier_id
carrier_id mis_carriers int4 10  √  null
carrier_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_carrier_id_fkey
carrier_id mis_fast_bids int4 10  √  null
carrier_id mis_fast_delivery_notes int4 10  √  null
carrier_id mis_fast_pos int4 10  √  null
carrier_id mis_pos int4 10  √  null
categories.category_id mis_pos_fk_carrier_id
category_id categories int4 10
categories.parent_id cat_parent_id_fk
mis_active_products.category_id Implied Constraint
mis_bids.carrier_id mis_bids_fk_carrier_id
mis_bids.guarantee_id mis_bids_fk_guarantee_id
mis_bids.port_id mis_bids_fk_port_id
mis_bids.sale_rep_id mis_bids_sale_rep_id_fk
mis_bids.shipping_id mis_bids_fk_shipping_id
mis_bids.zone_id mis_bids_zone_id_fk
mis_delivery_notes.carrier_id mis_delivery_notes_carrier_id_fkey
mis_delivery_notes.packaging_id mis_delivery_notes_packaging_id_fkey
mis_delivery_notes.port_id mis_delivery_notes_port_id_fkey
mis_delivery_notes.sale_rep_id mis_delivery_notes_sale_rep_id_fkey
mis_delivery_notes.shipping_id mis_delivery_notes_shipping_id_fkey
mis_delivery_notes.zone_id mis_delivery_notes_zone_id_fkey
mis_fast_products.category_id Implied Constraint
mis_orders.guarantee_id mis_orders_fk_guarantee_id
mis_orders.port_id mis_orders_fk_port_id
mis_orders.sale_rep_id mis_orders_sale_rep_id_fk
mis_orders.shipping_id mis_orders_fk_shipping_id
mis_orders.zone_id mis_orders_fk_zone_id
mis_parties.party_type_id mis_parties_fk_party_type_id
mis_parties.port_id mis_parties_fk_port_id
mis_parties.sale_rep_id mis_parties_fk_sale_rep_id
mis_parties.shipping_id mis_parties_fk_shipping_id
mis_parties.zone_id mis_parties_fk_zone_id
mis_pos.carrier_id mis_pos_fk_carrier_id
mis_pos.guarantee_id mis_pos_fk_guarantee_id
mis_pos.packaging_id mis_pos_fk_packaging_id
mis_pos.port_id mis_pos_fk_port_id
mis_pos.shipping_id mis_pos_fk_shipping_id
mis_products.brand_id mis_product_brand_id_fk
mis_rec_notes.packaging_id mis_rec_notes_packaging_id_fkey
mis_rec_notes.port_id mis_rec_notes_port_id_fkey
mis_rec_notes.shipping_id mis_rec_notes_shipping_id_fkey
mis_sale_invoices.sale_rep_id mis_sale_invoices_sale_rep_id_fkey
mis_sale_invoices.zone_id mis_sale_invoices_zone_id_fkey
acs_objects.object_id cat_category_id_fk
ID of a category.
category_id mis_active_products int4 10  √  null
categories.category_id Implied Constraint
category_id mis_fast_products int4 10  √  null
categories.category_id Implied Constraint
category_id mis_products int4 10  √  null
mis_product_categories.product_category_id mis_products_fk_category
cc mis_addresses bpchar 12  √  null
cc mis_banks bpchar 2  √  null
cc mis_banks_view bpchar 2  √  null
cc mis_customers bpchar 12  √  null
cc mis_fast_customers bpchar 12  √  null
cc mis_fast_parties bpchar 12  √  null
cc mis_fast_vendors bpchar 12  √  null
cc mis_vendors bpchar 12  √  null
cc_iban mis_addresses bpchar 2  √  null
cc_iban mis_customers bpchar 2  √  null
cc_iban mis_fast_customers bpchar 2  √  null
cc_iban mis_fast_parties bpchar 2  √  null
cc_iban mis_fast_vendors bpchar 2  √  null
cc_iban mis_vendors bpchar 2  √  null
ccn mis_banks bpchar 12  √  null
ccn mis_banks_view bpchar 12  √  null
cee_amount mis_fast_purc_invoices numeric 13,2  √  null
cee_amount mis_purc_invoices numeric 13,2  √  null
cee_amount_pretty mis_fast_purc_invoices varchar 2147483647  √  null
cee_currency mis_fast_purc_invoices bpchar 3  √  null
cee_currency mis_purc_invoices bpchar 3  √  null
currencies.codea mis_purc_invoices_cee_currency_fkey
center_code mis_centers_view varchar 30  √  null
center_description mis_centers_view varchar 50  √  null
center_id mis_centers int4 10
mis_centers_view.center_id Implied Constraint
mis_accounts.account_id mis_centers_center_id_fkey
center_id mis_centers_view int4 10  √  null
mis_centers.center_id Implied Constraint
change_pwd_url auth_authorities varchar 4000  √  null Any username in this url must be on the syntax foo={username}
and {username} will be replaced with the real username
child_id mis_acct_plan int4 10
mis_accounts.account_id mis_acct_plan_child_id_fkey
cin mis_addresses bpchar 1  √  null
cin mis_banks bpchar 1  √  null
cin mis_banks_view bpchar 1  √  null
cin mis_customers bpchar 1  √  null
cin mis_fast_customers bpchar 1  √  null
cin mis_fast_parties bpchar 1  √  null
cin mis_fast_vendors bpchar 1  √  null
cin mis_vendors bpchar 1  √  null
city mis_addresses varchar 32  √  null
city mis_customers varchar 32  √  null
city mis_fast_customers varchar 32  √  null
city mis_fast_parties varchar 32  √  null
city mis_fast_vendors varchar 32  √  null
city mis_vendors varchar 32  √  null
closing_date mis_all_orders date 13  √  null
closing_date mis_fast_orders date 13  √  null
closing_date mis_orders date 13  √  null
closing_date_pretty mis_all_orders text 2147483647  √  null
closing_date_pretty mis_fast_orders text 2147483647  √  null
closing_date_widget mis_all_orders text 2147483647  √  null
closing_date_widget mis_fast_orders text 2147483647  √  null
codea currencies bpchar 3
mis_bids.currency mis_bids_currency_fk
mis_orders.currency mis_orders_currency_fk
mis_parties.currency mis_parties_fk_currency
mis_pos.currency mis_pos_currency_fk
mis_purc_invoices.cee_currency mis_purc_invoices_cee_currency_fkey
mis_purc_price_lists.currency mis_purc_price_lists_currency_fkey
mis_quotations.codea mis_quotations_codea_fkey
mis_quotations_view.codea Implied Constraint
codea mis_quotations bpchar 3 'EUR'::bpchar
currencies.codea mis_quotations_codea_fkey
codea mis_quotations_view bpchar 3  √  null
currencies.codea Implied Constraint
coden currencies numeric 131089  √  null
comments mis_centers text 2147483647  √  null
comments mis_centers_view text 2147483647  √  null
comments mis_projects text 2147483647  √  null
comments mis_projects_view text 2147483647  √  null
company_bank_id mis_customers int4 10  √  null
company_bank_id mis_fast_customers int4 10  √  null
company_bank_id mis_fast_parties int4 10  √  null
company_bank_id mis_fast_vendors int4 10  √  null
company_bank_id mis_parties 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.
company_bank_id mis_vendors int4 10  √  null
company_sap_code mis_sap_parties varchar 30  √  null
contact mis_addresses text 2147483647  √  null
contact mis_customers text 2147483647  √  null
contact mis_fast_customers text 2147483647  √  null
contact mis_fast_parties text 2147483647  √  null
contact mis_fast_vendors text 2147483647  √  null
contact mis_vendors text 2147483647  √  null
content mis_print text 2147483647  √  null
context_id acs_objects int4 10  √  null
acs_objects.object_id acs_objects_context_id_fk
The context_id column points to an object that provides a context for
this object. Often this will reflect an observed hierarchy in a site,
for example a bboard message would probably list a bboard topic as
it's context, and a bboard topic might list a sub-site as it's
context. Whenever we ask a question of the form "can user X perform
action Y on object Z", the acs security model will defer to an
object's context if there is no information about user X's
permission to perform action Y on object Z.
context_id mis_accounts_view int4 10  √  null
context_id mis_active_products int4 10  √  null
context_id mis_all_orders int4 10  √  null
context_id mis_centers_view int4 10  √  null
context_id mis_contract_lines int4 10  √  null
context_id mis_customers int4 10  √  null
context_id mis_fast_bid_lines int4 10  √  null
context_id mis_fast_bids int4 10  √  null
context_id mis_fast_customers int4 10  √  null
context_id mis_fast_delivery_note_lines int4 10  √  null
context_id mis_fast_delivery_notes int4 10  √  null
context_id mis_fast_mr_lines int4 10  √  null
context_id mis_fast_mrs int4 10  √  null
context_id mis_fast_order_lines int4 10  √  null
context_id mis_fast_orders int4 10  √  null
context_id mis_fast_parties int4 10  √  null
context_id mis_fast_po_lines int4 10  √  null
context_id mis_fast_pos int4 10  √  null
context_id mis_fast_products int4 10  √  null
context_id mis_fast_purc_invoice_lines int4 10  √  null
context_id mis_fast_purc_invoices int4 10  √  null
context_id mis_fast_rec_note_lines int4 10  √  null
context_id mis_fast_rec_notes int4 10  √  null
context_id mis_fast_sale_invoice_lines int4 10  √  null
context_id mis_fast_sale_invoices int4 10  √  null
context_id mis_fast_vendors int4 10  √  null
context_id mis_projects_view int4 10  √  null
context_id mis_rec_note_lines_view int4 10  √  null
context_id mis_sale_invoices_view int4 10  √  null
context_id mis_vendors int4 10  √  null
conversion_factor mis_active_products float8 17,17  √  null
conversion_factor mis_bid_lines numeric 11,4 1
conversion_factor mis_contract_lines numeric 11,4  √  null
conversion_factor mis_delivery_note_lines numeric 11,4 1
conversion_factor mis_fast_bid_lines numeric 11,4  √  null
conversion_factor mis_fast_delivery_note_lines numeric 11,4  √  null
conversion_factor mis_fast_order_lines numeric 11,4  √  null
conversion_factor mis_fast_po_lines numeric 11,4  √  null
conversion_factor mis_fast_products float8 17,17  √  null
conversion_factor mis_fast_purc_invoice_lines numeric 11,4  √  null
conversion_factor mis_fast_rec_note_lines numeric 11,4  √  null
conversion_factor mis_fast_sale_invoice_lines numeric 11,4  √  null
conversion_factor mis_order_lines numeric 11,4 1
conversion_factor mis_po_lines numeric 11,4 1 Fattore di conversione fra purc_um_id e UM interna.
conversion_factor mis_products float8 17,17  √  null
conversion_factor mis_purc_invoice_lines numeric 11,4  √  null
conversion_factor mis_purc_list_prices float8 17,17 1 Fattore di conversione fra um_id e purc_um_id
conversion_factor mis_purc_prices float8 17,17  √  null
conversion_factor mis_purc_products_with_prices float8 17,17  √  null
conversion_factor mis_quotations float8 17,17 1
conversion_factor mis_quotations_view float8 17,17  √  null
conversion_factor mis_rec_note_lines numeric 11,4  √  null
conversion_factor mis_rec_note_lines_view numeric 11,4  √  null
conversion_factor mis_sale_invoice_lines numeric 11,4  √  null
conversion_factor_pretty mis_active_products varchar 2147483647  √  null
conversion_factor_pretty mis_contract_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_bid_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_order_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_po_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_products varchar 2147483647  √  null
conversion_factor_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
conversion_factor_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
conversion_factor_pretty mis_purc_prices varchar 2147483647  √  null
conversion_factor_pretty mis_purc_products_with_prices varchar 2147483647  √  null
conversion_factor_pretty mis_quotations_view varchar 2147483647  √  null
conversion_factor_pretty mis_rec_note_lines_view varchar 2147483647  √  null
counter mis_bill_types_with_counter int4 10  √  null
counter mis_counters int4 10  √  null
counter_description mis_bill_types_with_counter varchar 50  √  null
counter_description mis_counters varchar 50  √  null
counter_id mis_bill_types int4 10
mis_counters.counter_id mis_bill_types_counter_id_fkey
counter_id mis_bill_types_with_counter int4 10  √  null
mis_counters.counter_id Implied Constraint
counter_id mis_counters int4 10
mis_bill_types.counter_id mis_bill_types_counter_id_fkey
mis_bill_types_with_counter.counter_id Implied Constraint
mis_invoice_types.counter_id mis_invoice_types_counter_id_fkey
mis_iva_ctr.counter_id mis_iva_ctr_counter_id_fkey
counter_id mis_invoice_types int4 10
mis_counters.counter_id mis_invoice_types_counter_id_fkey
counter_id mis_iva_ctr int4 10  √  null
mis_counters.counter_id mis_iva_ctr_counter_id_fkey
counter_section mis_bill_types_with_counter varchar 1  √  null
counter_section mis_counters varchar 1  √  null Carattere identificativo del sezionale che verrą stampato, separato da /, dopo il numero.
Per motivi storici alcuni programmi, ad es. lo scadenziario IVA, propongono di scegliere un
sezionale: in realtą questo equivale a scegliere il contatore a paritą di counter_type.
counter_type mis_bill_types_with_counter varchar 10  √  null
counter_type mis_counters varchar 10  √  null Tipo Contatore. Puņ assumere i seguenti valori in funzione del tipo documento di riferimento:
ddt=DDT, pin=Purchase invoice, sin=Sale invoice, rec=BEM
country_iso mis_addresses bpchar 2  √  null
countries.iso mis_addresses_country_iso_fkey
country_iso mis_customers bpchar 2  √  null
country_iso mis_fast_customers bpchar 2  √  null
country_iso mis_fast_parties bpchar 2  √  null
country_iso mis_fast_vendors bpchar 2  √  null
country_iso mis_vendors bpchar 2  √  null
creation_date acs_objects timestamptz 35,6 now()
creation_date mis_accounts_view timestamptz 35,6  √  null
creation_date mis_active_products timestamptz 35,6  √  null
creation_date mis_all_orders timestamptz 35,6  √  null
creation_date mis_centers_view timestamptz 35,6  √  null
creation_date mis_contract_lines timestamptz 35,6  √  null
creation_date mis_customers timestamptz 35,6  √  null
creation_date mis_fast_bid_lines timestamptz 35,6  √  null
creation_date mis_fast_bids timestamptz 35,6  √  null
creation_date mis_fast_customers timestamptz 35,6  √  null
creation_date mis_fast_delivery_note_lines timestamptz 35,6  √  null
creation_date mis_fast_delivery_notes timestamptz 35,6  √  null
creation_date mis_fast_mr_lines timestamptz 35,6  √  null
creation_date mis_fast_mrs timestamptz 35,6  √  null
creation_date mis_fast_order_lines timestamptz 35,6  √  null
creation_date mis_fast_orders timestamptz 35,6  √  null
creation_date mis_fast_parties timestamptz 35,6  √  null
creation_date mis_fast_po_lines timestamptz 35,6  √  null
creation_date mis_fast_pos timestamptz 35,6  √  null
creation_date mis_fast_products timestamptz 35,6  √  null
creation_date mis_fast_purc_invoice_lines timestamptz 35,6  √  null
creation_date mis_fast_purc_invoices timestamptz 35,6  √  null
creation_date mis_fast_rec_note_lines timestamptz 35,6  √  null
creation_date mis_fast_rec_notes timestamptz 35,6  √  null
creation_date mis_fast_sale_invoice_lines timestamptz 35,6  √  null
creation_date mis_fast_sale_invoices timestamptz 35,6  √  null
creation_date mis_fast_vendors timestamptz 35,6  √  null
creation_date mis_projects_view timestamptz 35,6  √  null
creation_date mis_rec_note_lines_view timestamptz 35,6  √  null
creation_date mis_sale_invoices_view timestamptz 35,6  √  null
creation_date mis_vendors timestamptz 35,6  √  null
creation_ip acs_objects varchar 50  √  null
creation_ip mis_accounts_view varchar 50  √  null
creation_ip mis_active_products varchar 50  √  null
creation_ip mis_all_orders varchar 50  √  null
creation_ip mis_centers_view varchar 50  √  null
creation_ip mis_contract_lines varchar 50  √  null
creation_ip mis_customers varchar 50  √  null
creation_ip mis_fast_bid_lines varchar 50  √  null
creation_ip mis_fast_bids varchar 50  √  null
creation_ip mis_fast_customers varchar 50  √  null
creation_ip mis_fast_delivery_note_lines varchar 50  √  null
creation_ip mis_fast_delivery_notes varchar 50  √  null
creation_ip mis_fast_mr_lines varchar 50  √  null
creation_ip mis_fast_mrs varchar 50  √  null
creation_ip mis_fast_order_lines varchar 50  √  null
creation_ip mis_fast_orders varchar 50  √  null
creation_ip mis_fast_parties varchar 50  √  null
creation_ip mis_fast_po_lines varchar 50  √  null
creation_ip mis_fast_pos varchar 50  √  null
creation_ip mis_fast_products varchar 50  √  null
creation_ip mis_fast_purc_invoice_lines varchar 50  √  null
creation_ip mis_fast_purc_invoices varchar 50  √  null
creation_ip mis_fast_rec_note_lines varchar 50  √  null
creation_ip mis_fast_rec_notes varchar 50  √  null
creation_ip mis_fast_sale_invoice_lines varchar 50  √  null
creation_ip mis_fast_sale_invoices varchar 50  √  null
creation_ip mis_fast_vendors varchar 50  √  null
creation_ip mis_projects_view varchar 50  √  null
creation_ip mis_rec_note_lines_view varchar 50  √  null
creation_ip mis_sale_invoices_view varchar 50  √  null
creation_ip mis_vendors varchar 50  √  null
creation_user acs_objects int4 10  √  null
users.user_id acs_objects_creation_user_fk
Who created the object; may be null since objects can be created by
automated processes
creation_user mis_accounts_view int4 10  √  null
creation_user mis_active_products int4 10  √  null
creation_user mis_all_orders int4 10  √  null
creation_user mis_centers_view int4 10  √  null
creation_user mis_contract_lines int4 10  √  null
creation_user mis_customers int4 10  √  null
creation_user mis_fast_bid_lines int4 10  √  null
creation_user mis_fast_bids int4 10  √  null
creation_user mis_fast_customers int4 10  √  null
creation_user mis_fast_delivery_note_lines int4 10  √  null
creation_user mis_fast_delivery_notes int4 10  √  null
creation_user mis_fast_mr_lines int4 10  √  null
creation_user mis_fast_mrs int4 10  √  null
creation_user mis_fast_order_lines int4 10  √  null
creation_user mis_fast_orders int4 10  √  null
creation_user mis_fast_parties int4 10  √  null
creation_user mis_fast_po_lines int4 10  √  null
creation_user mis_fast_pos int4 10  √  null
creation_user mis_fast_products int4 10  √  null
creation_user mis_fast_purc_invoice_lines int4 10  √  null
creation_user mis_fast_purc_invoices int4 10  √  null
creation_user mis_fast_rec_note_lines int4 10  √  null
creation_user mis_fast_rec_notes int4 10  √  null
creation_user mis_fast_sale_invoice_lines int4 10  √  null
creation_user mis_fast_sale_invoices int4 10  √  null
creation_user mis_fast_vendors int4 10  √  null
creation_user mis_projects_view int4 10  √  null
creation_user mis_rec_note_lines_view int4 10  √  null
creation_user mis_sale_invoices_view int4 10  √  null
creation_user mis_vendors int4 10  √  null
credit_amount mis_acct_iva numeric 13,2  √  null
credit_limit mis_customers numeric 13,2  √  null
credit_limit mis_fast_customers numeric 13,2  √  null
credit_limit mis_fast_parties numeric 13,2  √  null
credit_limit mis_fast_vendors numeric 13,2  √  null
credit_limit mis_parties numeric 13,2  √  null
credit_limit mis_vendors numeric 13,2  √  null
credit_limit_pretty mis_customers varchar 2147483647  √  null
credit_limit_pretty mis_fast_customers varchar 2147483647  √  null
credit_limit_pretty mis_fast_parties varchar 2147483647  √  null
credit_limit_pretty mis_fast_vendors varchar 2147483647  √  null
credit_limit_pretty mis_vendors varchar 2147483647  √  null
currency mis_all_orders bpchar 3  √  null
currency mis_bids bpchar 3  √  null
currencies.codea mis_bids_currency_fk
currency mis_customers bpchar 3  √  null
currency mis_fast_bids bpchar 3  √  null
currency mis_fast_customers bpchar 3  √  null
currency mis_fast_orders bpchar 3  √  null
currency mis_fast_parties bpchar 3  √  null
currency mis_fast_pos bpchar 3  √  null
currency mis_fast_vendors bpchar 3  √  null
currency mis_orders bpchar 3  √  null
currencies.codea mis_orders_currency_fk
currency mis_parties bpchar 3  √  null
currencies.codea mis_parties_fk_currency
currency mis_pos bpchar 3  √  null
currencies.codea mis_pos_currency_fk
currency mis_purc_price_lists bpchar 3 'EUR'::bpchar
currencies.codea mis_purc_price_lists_currency_fkey
currency mis_purc_prices bpchar 3  √  null
currency mis_purc_products_with_prices bpchar 3  √  null
currency mis_vendors bpchar 3  √  null
cust_price_map_id mis_cust_price_map int4 10
customer_code mis_fast_delivery_notes varchar 30  √  null
customer_code mis_sale_invoices_view varchar 30  √  null
customer_code mis_sale_operations varchar 30  √  null
customer_description mis_sale_operations varchar 1000  √  null
customer_id mis_acct_customers int4 10  √  null
customer_id mis_all_orders int4 10  √  null
customer_id mis_bids int4 10  √  null
mis_parties.party_id mis_bids_customer_id_fk
customer_id mis_contract_lines int4 10  √  null
customer_id mis_cust_price_map int4 10  √  null
mis_parties.party_id mis_cust_price_map_customer_id_fkey
customer_id mis_customers_products_map int4 10  √  null
mis_parties.party_id mis_customers_products_map_customer_id_fkey
customer_id mis_fast_bids int4 10  √  null
customer_id mis_fast_delivery_notes int4 10  √  null
customer_id mis_fast_orders int4 10  √  null
customer_id mis_fast_sale_invoices int4 10  √  null
customer_id mis_orders int4 10  √  null
mis_parties.party_id mis_orders_customer_id_fk
customer_id mis_projects int4 10
mis_parties.party_id mis_projects_customer_id_fkey
customer_id mis_projects_view int4 10  √  null
customer_id mis_sale_invoices int4 10
mis_parties.party_id mis_sale_invoices_customer_id_fkey
customer_id mis_sale_invoices_view int4 10  √  null
customer_id mis_sale_operations int4 10  √  null
customer_id mis_sale_paydates_view int4 10  √  null
customer_name mis_fast_delivery_notes varchar 1000  √  null
customer_name mis_sale_invoices_view varchar 1000  √  null
customer_sap_code mis_sap_parties varchar 30  √  null
date_delivered mis_contract_lines date 13  √  null
date_delivered mis_fast_order_lines date 13  √  null
date_delivered mis_order_lines date 13  √  null
date_delivered_pretty mis_contract_lines text 2147483647  √  null
date_delivered_pretty mis_fast_order_lines text 2147483647  √  null
date_delivered_widget mis_contract_lines text 2147483647  √  null
date_delivered_widget mis_fast_order_lines text 2147483647  √  null
date_id mis_customer_dates int4 10
mis_fast_customer_payments.date_id Implied Constraint
mis_sale_paydates.date_id Implied Constraint
mis_sale_paydates_view.date_id Implied Constraint
date_id mis_customer_payments int4 10
mis_sale_paydates.date_id mis_customer_payments_date_id_fkey
date_id mis_fast_customer_payments int4 10  √  null
mis_customer_dates.date_id Implied Constraint
date_id mis_sale_paydates int4 10
mis_customer_payments.date_id mis_customer_payments_date_id_fkey
mis_customer_dates.date_id Implied Constraint
date_id mis_sale_paydates_view int4 10  √  null
mis_customer_dates.date_id Implied Constraint
date_invoiced mis_contract_lines date 13  √  null
date_invoiced mis_fast_order_lines date 13  √  null
date_invoiced mis_order_lines date 13  √  null Il modello dati č insufficientein quanto l'unco campo 'date_invoiced' non permette
di gestire il fatto che la riga potrebbe essere fatturata in pił soluzioni.
Decido pertanto di procedere cosģ:
In caso di approvazione aggiorno la data con la data della fattura che sto approvando,
In caso di ripristino annullo la data solo se non ci sono altre fatture.
date_invoiced_pretty mis_contract_lines text 2147483647  √  null
date_invoiced_pretty mis_fast_order_lines text 2147483647  √  null
date_invoiced_widget mis_contract_lines text 2147483647  √  null
date_invoiced_widget mis_fast_order_lines text 2147483647  √  null
date_promised mis_all_orders date 13  √  null
date_promised mis_fast_orders date 13  √  null
date_promised mis_orders date 13  √  null
date_promised_pretty mis_all_orders text 2147483647  √  null
date_promised_pretty mis_fast_orders text 2147483647  √  null
date_promised_widget mis_all_orders text 2147483647  √  null
date_promised_widget mis_fast_orders text 2147483647  √  null
date_requested mis_fast_mrs date 13  √  null
date_requested mis_fast_pos date 13  √  null
date_requested mis_mrs date 13  √  null
date_requested mis_pos date 13  √  null Indica la prima data di consegna richiesta (verrą impostata per default su tutte le righe)
date_requested_pretty mis_fast_mrs text 2147483647  √  null
date_requested_pretty mis_fast_pos text 2147483647  √  null
date_requested_widget mis_fast_mrs text 2147483647  √  null
date_requested_widget mis_fast_pos text 2147483647  √  null
days_from_order mis_bids int4 10  √  null
days_from_order mis_fast_bids int4 10  √  null
days_next_month_1 mis_payments int4 10  √  null
days_next_month_2 mis_payments int4 10  √  null
days_valid mis_bids int4 10  √  null
days_valid mis_fast_bids int4 10  √  null
ddt_grouping_p mis_customers bool 1  √  null
ddt_grouping_p mis_fast_customers bool 1  √  null
ddt_grouping_p mis_fast_parties bool 1  √  null
ddt_grouping_p mis_fast_vendors bool 1  √  null
ddt_grouping_p mis_parties bool 1  √  null indica se i DDT del cliente debbano essere raggruppati o meno
ddt_grouping_p mis_vendors bool 1  √  null
declaration_date mis_export_declarations date 13  √  null
declaration_from mis_export_declarations date 13  √  null
declaration_id mis_export_declarations int4 10
declaration_ref mis_export_declarations varchar 20  √  null
declaration_to mis_export_declarations date 13  √  null
default_address_id mis_customers int4 10  √  null
default_address_id mis_fast_customers int4 10  √  null
default_address_id mis_fast_parties int4 10  √  null
default_address_id mis_fast_vendors int4 10  √  null
default_address_id mis_parties 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
default_address_id mis_vendors int4 10  √  null
default_discount mis_purc_price_lists numeric 5,2  √  0
default_discount mis_purc_prices numeric 5,2  √  null
default_discount mis_purc_products_with_prices numeric 5,2  √  null
default_discount_2 mis_purc_price_lists numeric 5,2  √  0
default_discount_2 mis_purc_prices numeric 5,2  √  null
default_discount_2 mis_purc_products_with_prices numeric 5,2  √  null
default_discount_2_pretty mis_purc_prices varchar 2147483647  √  null
default_discount_2_pretty mis_purc_products_with_prices varchar 2147483647  √  null
default_discount_3 mis_purc_price_lists numeric 5,2  √  0
default_discount_3 mis_purc_prices numeric 5,2  √  null
default_discount_3 mis_purc_products_with_prices numeric 5,2  √  null
default_discount_3_pretty mis_purc_prices varchar 2147483647  √  null
default_discount_3_pretty mis_purc_products_with_prices varchar 2147483647  √  null
default_discount_pretty mis_purc_prices varchar 2147483647  √  null
default_discount_pretty mis_purc_products_with_prices varchar 2147483647  √  null
default_locale apm_packages varchar 30  √  null
default_name countries varchar 100 This is admittedly a violation of 3NF but it is more efficient and helps with non-translated values.
See country.sql for more comments.
default_name currencies varchar 100
default_sale_discount mis_purc_price_lists numeric 5,2  √  0 Applicabile solo in assenza di uno sconto specifico del cliente su questo listino
default_sale_discount mis_purc_prices numeric 5,2  √  null
default_sale_discount mis_purc_products_with_prices numeric 5,2  √  null
default_sale_discount_2 mis_purc_price_lists numeric 5,2  √  0
default_sale_discount_2 mis_purc_prices numeric 5,2  √  null
default_sale_discount_2 mis_purc_products_with_prices numeric 5,2  √  null
default_sale_discount_2_pretty mis_purc_prices varchar 2147483647  √  null
default_sale_discount_2_pretty mis_purc_products_with_prices varchar 2147483647  √  null
default_sale_discount_3 mis_purc_price_lists numeric 5,2  √  0
default_sale_discount_3 mis_purc_prices numeric 5,2  √  null
default_sale_discount_3 mis_purc_products_with_prices numeric 5,2  √  null
default_sale_discount_3_pretty mis_purc_prices varchar 2147483647  √  null
default_sale_discount_3_pretty mis_purc_products_with_prices varchar 2147483647  √  null
default_sale_discount_pretty mis_purc_prices varchar 2147483647  √  null
default_sale_discount_pretty mis_purc_products_with_prices varchar 2147483647  √  null
delivered_qty mis_delivery_note_lines numeric 11,2
delivered_qty mis_fast_delivery_note_lines numeric 11,2  √  null
delivered_qty mis_fast_rec_note_lines numeric 11,2  √  null
delivered_qty mis_rec_note_lines numeric 11,2
delivered_qty mis_rec_note_lines_view numeric 11,2  √  null
delivered_qty_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
delivered_qty_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
delivered_qty_pretty mis_rec_note_lines_view varchar 2147483647  √  null
delivery_code mis_delivery_notes varchar 10  √  null
delivery_code mis_fast_delivery_note_lines varchar 10  √  null
delivery_code mis_fast_delivery_notes varchar 10  √  null
delivery_code mis_fast_rec_note_lines varchar 30  √  null
delivery_code mis_fast_rec_notes varchar 30  √  null
delivery_code mis_rec_notes varchar 30  √  null
delivery_date mis_delivery_notes date 13
delivery_date mis_fast_delivery_note_lines date 13  √  null
delivery_date mis_fast_delivery_notes date 13  √  null
delivery_date mis_fast_rec_notes date 13  √  null
delivery_date mis_rec_notes date 13  √  null
delivery_date_pretty mis_fast_delivery_note_lines text 2147483647  √  null
delivery_date_pretty mis_fast_delivery_notes text 2147483647  √  null
delivery_date_pretty mis_fast_rec_notes text 2147483647  √  null
delivery_date_widget mis_fast_delivery_notes text 2147483647  √  null
delivery_date_widget mis_fast_rec_notes text 2147483647  √  null
delivery_id mis_delivery_note_lines int4 10
mis_delivery_notes.delivery_id mis_delivery_note_lines_delivery_id_fkey
delivery_id mis_delivery_notes int4 10
mis_delivery_note_lines.delivery_id mis_delivery_note_lines_delivery_id_fkey
acs_objects.object_id mis_delivery_notes_delivery_id_fkey
delivery_id mis_delivery_transport int4 10
mis_fast_delivery_note_lines.delivery_id Implied Constraint
mis_fast_delivery_notes.delivery_id Implied Constraint
delivery_id mis_fast_delivery_note_lines int4 10  √  null
mis_delivery_transport.delivery_id Implied Constraint
delivery_id mis_fast_delivery_notes int4 10  √  null
mis_delivery_transport.delivery_id Implied Constraint
delivery_line_id mis_delivery_note_lines int4 10
mis_fast_delivery_note_lines.delivery_line_id Implied Constraint
mis_fast_sale_invoice_lines.delivery_line_id Implied Constraint
mis_sale_invoice_lines.delivery_line_id mis_sale_invoice_lines_delivery_line_id_fkey
acs_objects.object_id mis_delivery_note_lines_delivery_line_id_fkey
delivery_line_id mis_fast_delivery_note_lines int4 10  √  null
mis_delivery_note_lines.delivery_line_id Implied Constraint
delivery_line_id mis_fast_sale_invoice_lines int4 10  √  null
mis_delivery_note_lines.delivery_line_id Implied Constraint
delivery_line_id mis_sale_invoice_lines int4 10  √  null
mis_delivery_note_lines.delivery_line_id mis_sale_invoice_lines_delivery_line_id_fkey
delivery_state mis_all_orders bpchar 1  √  null
delivery_state mis_fast_orders bpchar 1  √  null
delivery_state mis_fast_pos bpchar 1  √  null
delivery_state mis_orders bpchar 1  √  null
delivery_state mis_pos bpchar 1  √  null N=Non ricevuto P=Parzialmente ricevuto C=chiuso
departure_date mis_delivery_notes date 13  √  null
departure_date mis_fast_delivery_notes date 13  √  null
departure_date_pretty mis_fast_delivery_notes text 2147483647  √  null
departure_date_widget mis_fast_delivery_notes text 2147483647  √  null
deprecated_p categories bpchar 1  √  'f'::bpchar Marks categories to be no longer supported.
depth mis_active_products float8 17,17  √  null
depth mis_fast_products float8 17,17  √  null
depth mis_products float8 17,17  √  null
depth_pretty mis_active_products varchar 2147483647  √  null
depth_pretty mis_fast_products varchar 2147483647  √  null
description mis_active_products text 2147483647  √  null
description mis_all_orders text 2147483647  √  null
description mis_bid_lines text 2147483647  √  null
description mis_bids text 2147483647  √  null
description mis_contract_lines text 2147483647  √  null
description mis_customers text 2147483647  √  null
description mis_fast_bid_lines text 2147483647  √  null
description mis_fast_bids text 2147483647  √  null
description mis_fast_customers text 2147483647  √  null
description mis_fast_mr_lines text 2147483647  √  null
description mis_fast_mrs text 2147483647  √  null
description mis_fast_order_lines text 2147483647  √  null
description mis_fast_orders text 2147483647  √  null
description mis_fast_parties text 2147483647  √  null
description mis_fast_po_lines text 2147483647  √  null
description mis_fast_pos text 2147483647  √  null
description mis_fast_products text 2147483647  √  null
description mis_fast_rec_note_lines text 2147483647  √  null
description mis_fast_vendors text 2147483647  √  null
description mis_mr_lines text 2147483647  √  null
description mis_mrs text 2147483647  √  null
description mis_order_lines text 2147483647  √  null Contiene la descrizione del prodotto e puo' essere editata dall'utente.
Il suo contenuto viene trasferito nella colonna PRODUCT_DESCRIPTION della
DDT, e da questa alla fattura.
description mis_orders text 2147483647  √  null
description mis_parties text 2147483647  √  null
description mis_po_lines text 2147483647  √  null Descrizione sostitutiva d'acquisto: prevale su quella anagrafica dell'articolo.
description mis_pos text 2147483647  √  null
description mis_products text 2147483647  √  null
description mis_rec_note_lines text 2147483647  √  null
description mis_rec_note_lines_view text 2147483647  √  null
description mis_scripts text 2147483647  √  null
description mis_vendors text 2147483647  √  null
discontinued_by mis_active_products date 13  √  null
discontinued_by mis_fast_products date 13  √  null
discontinued_by mis_products date 13  √  null
discount mis_bid_lines numeric 5,2  √  0
discount mis_contract_lines numeric 5,2  √  null
discount mis_customers numeric 5,2  √  null
discount mis_delivery_note_lines numeric 5,2  √  null
discount mis_fast_bid_lines numeric 5,2  √  null
discount mis_fast_customers numeric 5,2  √  null
discount mis_fast_delivery_note_lines numeric 5,2  √  null
discount mis_fast_order_lines numeric 5,2  √  null
discount mis_fast_parties numeric 5,2  √  null
discount mis_fast_po_lines numeric 5,2  √  null
discount mis_fast_purc_invoice_lines numeric 5,2  √  null
discount mis_fast_rec_note_lines numeric 5,2  √  null
discount mis_fast_sale_invoice_lines numeric 5,2  √  null
discount mis_fast_vendors numeric 5,2  √  null
discount mis_order_lines numeric 5,2  √  0
discount mis_parties numeric 5,2  √  null
discount mis_po_lines numeric 5,2 0
discount mis_purc_invoice_lines numeric 5,2  √  null
discount mis_purc_list_prices numeric 5,2  √  0
discount mis_purc_prices numeric 5,2  √  null
discount mis_purc_products_with_prices numeric 5,2  √  null
discount mis_quotations numeric 5,2  √  0
discount mis_quotations_view numeric 5,2  √  null
discount mis_rec_note_lines numeric 5,2  √  null
discount mis_rec_note_lines_view numeric 5,2  √  null
discount mis_sale_invoice_lines numeric 5,2  √  null
discount mis_vendors numeric 5,2  √  null
discount_2 mis_bid_lines numeric 5,2  √  0
discount_2 mis_contract_lines numeric 5,2  √  null
discount_2 mis_delivery_note_lines numeric 5,2  √  null
discount_2 mis_fast_bid_lines numeric 5,2  √  null
discount_2 mis_fast_delivery_note_lines numeric 5,2  √  null
discount_2 mis_fast_order_lines numeric 5,2  √  null
discount_2 mis_fast_po_lines numeric 5,2  √  null
discount_2 mis_fast_purc_invoice_lines numeric 5,2  √  null
discount_2 mis_fast_rec_note_lines numeric 5,2  √  null
discount_2 mis_fast_sale_invoice_lines numeric 5,2  √  null
discount_2 mis_order_lines numeric 5,2  √  0
discount_2 mis_po_lines numeric 5,2 0
discount_2 mis_purc_invoice_lines numeric 5,2  √  null
discount_2 mis_purc_list_prices numeric 5,2  √  0
discount_2 mis_purc_prices numeric 5,2  √  null
discount_2 mis_purc_products_with_prices numeric 5,2  √  null
discount_2 mis_quotations numeric 5,2  √  0
discount_2 mis_quotations_view numeric 5,2  √  null
discount_2 mis_rec_note_lines numeric 5,2  √  null
discount_2 mis_rec_note_lines_view numeric 5,2  √  null
discount_2 mis_sale_invoice_lines numeric 5,2  √  null
discount_2_pretty mis_contract_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_bid_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_order_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_po_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
discount_2_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
discount_2_pretty mis_purc_prices varchar 2147483647  √  null
discount_2_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_2_pretty mis_quotations_view varchar 2147483647  √  null
discount_2_pretty mis_rec_note_lines_view varchar 2147483647  √  null
discount_3 mis_bid_lines numeric 5,2  √  0
discount_3 mis_contract_lines numeric 5,2  √  null
discount_3 mis_delivery_note_lines numeric 5,2  √  null
discount_3 mis_fast_bid_lines numeric 5,2  √  null
discount_3 mis_fast_delivery_note_lines numeric 5,2  √  null
discount_3 mis_fast_order_lines numeric 5,2  √  null
discount_3 mis_fast_po_lines numeric 5,2  √  null
discount_3 mis_fast_purc_invoice_lines numeric 5,2  √  null
discount_3 mis_fast_rec_note_lines numeric 5,2  √  null
discount_3 mis_fast_sale_invoice_lines numeric 5,2  √  null
discount_3 mis_order_lines numeric 5,2  √  0
discount_3 mis_po_lines numeric 5,2 0
discount_3 mis_purc_invoice_lines numeric 5,2  √  null
discount_3 mis_purc_list_prices numeric 5,2  √  0
discount_3 mis_purc_prices numeric 5,2  √  null
discount_3 mis_purc_products_with_prices numeric 5,2  √  null
discount_3 mis_quotations numeric 5,2  √  0
discount_3 mis_quotations_view numeric 5,2  √  null
discount_3 mis_rec_note_lines numeric 5,2  √  null
discount_3 mis_rec_note_lines_view numeric 5,2  √  null
discount_3 mis_sale_invoice_lines numeric 5,2  √  null
discount_3_pretty mis_contract_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_bid_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_order_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_po_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
discount_3_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
discount_3_pretty mis_purc_prices varchar 2147483647  √  null
discount_3_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_3_pretty mis_quotations_view varchar 2147483647  √  null
discount_3_pretty mis_rec_note_lines_view varchar 2147483647  √  null
discount_applied mis_purc_products_with_prices numeric 5,2  √  null
discount_applied_2 mis_purc_products_with_prices numeric 5,2  √  null
discount_applied_2_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_applied_3 mis_purc_products_with_prices numeric 5,2  √  null
discount_applied_3_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_applied_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_pretty mis_contract_lines varchar 2147483647  √  null
discount_pretty mis_customers varchar 2147483647  √  null
discount_pretty mis_fast_bid_lines varchar 2147483647  √  null
discount_pretty mis_fast_customers varchar 2147483647  √  null
discount_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
discount_pretty mis_fast_order_lines varchar 2147483647  √  null
discount_pretty mis_fast_parties varchar 2147483647  √  null
discount_pretty mis_fast_po_lines varchar 2147483647  √  null
discount_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
discount_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
discount_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
discount_pretty mis_fast_vendors varchar 2147483647  √  null
discount_pretty mis_purc_prices varchar 2147483647  √  null
discount_pretty mis_purc_products_with_prices varchar 2147483647  √  null
discount_pretty mis_quotations_view varchar 2147483647  √  null
discount_pretty mis_rec_note_lines_view varchar 2147483647  √  null
discount_pretty mis_vendors varchar 2147483647  √  null
document_id mis_acct_mov int4 10  √  null
acs_objects.object_id mis_acct_mov_document_id_fkey
document_id mis_acct_mov_view int4 10  √  null
drawing_ref mis_active_products varchar 50  √  null
drawing_ref mis_fast_products varchar 50  √  null
drawing_ref mis_products varchar 50  √  null
duty_amount mis_delivery_transport numeric 13,2  √  null
dynamic_p acs_object_types bool 1  √  false This flag is used to identify object types created dynamically
(e.g. through a web interface). Dynamically created object types can
be administered differently. For example, the group type admin pages
only allow users to add attributes or otherwise modify dynamic
object types. This column is still experimental and may not be supported in the
future. That is the reason it is not yet part of the API.
ean_code mis_active_products varchar 13  √  null
ean_code mis_fast_products varchar 13  √  null
ean_code mis_products varchar 13  √  null
effect_bank_id mis_banks int4 10  √  null
mis_banks.bank_id mis_banks_effect_bank_id_fkey
effect_bank_id mis_banks_view int4 10  √  null
effect_bank_id mis_customer_dates int4 10  √  null
mis_banks.bank_id mis_customer_dates_effect_bank_id_fkey
effect_bank_id mis_effects int4 10  √  null
mis_banks.bank_id mis_effects_effect_bank_id_fkey
effect_bank_id mis_purc_paydates int4 10  √  null
mis_banks.bank_id mis_purc_paydates_effect_bank_id_fkey
effect_bank_id mis_purc_paydates_view int4 10  √  null
effect_bank_id mis_sale_paydates int4 10  √  null
mis_banks.bank_id mis_sale_paydates_effect_bank_id_fkey
effect_bank_id mis_sale_paydates_view int4 10  √  null
effect_id mis_effects int4 10
email mis_addresses text 2147483647  √  null
email mis_customers text 2147483647  √  null
email mis_fast_customers text 2147483647  √  null
email mis_fast_parties text 2147483647  √  null
email mis_fast_vendors text 2147483647  √  null
email mis_vendors text 2147483647  √  null
email parties varchar 100  √  null
email_bouncing_p users bool 1 false
email_verified_p users bool 1  √  true
enabled_p auth_authorities bool 1 true
end_date mis_party_mod date 13  √  null
end_date mis_projects date 13  √  null
end_date mis_projects_view date 13  √  null
end_date mis_quotations date 13  √  null
end_date mis_quotations_view date 13  √  null
end_date_pretty mis_projects_view text 2147483647  √  null
end_date_pretty mis_quotations_view text 2147483647  √  null
end_date_widget mis_projects_view text 2147483647  √  null
end_date_widget mis_quotations_view text 2147483647  √  null
exp_declaration_p mis_iva bool 1  √  null
expected_date mis_customer_dates date 13
expected_date mis_sale_paydates date 13
expected_date mis_sale_paydates_view date 13  √  null
expected_date_pretty mis_sale_paydates_view text 2147483647  √  null
external_ref_code mis_delivery_notes varchar 20  √  null
external_ref_code mis_fast_delivery_notes varchar 20  √  null
factoring_account_id mis_bank_accounts int4 10  √  null
mis_accounts.account_id mis_bank_accounts_factoring_account_id_fkey
factoring_account_id mis_banks_view int4 10  √  null
factoring_bank_id mis_fast_sale_invoices int4 10  √  null
factoring_bank_id mis_sale_invoices int4 10  √  null
mis_banks.bank_id mis_sale_invoices_factoring_bank_id_fkey
factoring_bank_id mis_sale_invoices_view int4 10  √  null
factoring_bank_id mis_sale_paydates_view int4 10  √  null
fax mis_addresses varchar 35  √  null
fax mis_customers varchar 35  √  null
fax mis_fast_customers varchar 35  √  null
fax mis_fast_parties varchar 35  √  null
fax mis_fast_vendors varchar 35  √  null
fax mis_vendors varchar 35  √  null
fin_account_id mis_acct_customers int4 10  √  null
fin_account_id mis_acct_vendors int4 10  √  null
fin_account_id mis_party_accounts int4 10
mis_accounts.account_id mis_party_accounts_fin_account_id_fkey
first_names persons varchar 100
fiscal_code mis_customers bpchar 16  √  null
fiscal_code mis_fast_customers bpchar 16  √  null
fiscal_code mis_fast_parties bpchar 16  √  null
fiscal_code mis_fast_vendors bpchar 16  √  null
fiscal_code mis_parties bpchar 16  √  null
fiscal_code mis_purc_operations text 2147483647  √  null
fiscal_code mis_sale_operations text 2147483647  √  null
fiscal_code mis_vendors bpchar 16  √  null
fix_amount mis_delivery_transport numeric 13,2  √  null
forgotten_pwd_url auth_authorities varchar 4000  √  null Any username in this url must be on the syntax foo={username}
and {username} will be replaced with the real username
freight_amount mis_delivery_transport numeric 13,2  √  null
from_mov_type mis_bill_types varchar 3
mis_wh_mov_types.wh_mov_type_code mis_bill_types_from_mov_type_fkey
from_mov_type mis_bill_types_with_counter varchar 3  √  null
get_doc_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_getdoc_impl_fk
gross_weight mis_delivery_notes numeric 5,2  √  null
gross_weight mis_fast_delivery_notes numeric 5,2  √  null
gross_weight mis_fast_rec_notes numeric 11,2  √  null
gross_weight mis_rec_notes numeric 11,2  √  null
gross_weight_pretty mis_fast_delivery_notes varchar 2147483647  √  null
gross_weight_pretty mis_fast_rec_notes varchar 2147483647  √  null
guarantee_code mis_guarantees varchar 200  √  null
guarantee_description mis_guarantees varchar 4000  √  null
guarantee_id mis_all_orders int4 10  √  null
guarantee_id mis_bids int4 10  √  null
categories.category_id mis_bids_fk_guarantee_id
guarantee_id mis_fast_bids int4 10  √  null
guarantee_id mis_fast_orders int4 10  √  null
guarantee_id mis_fast_pos int4 10  √  null
guarantee_id mis_guarantees int4 10  √  null
guarantee_id mis_orders int4 10  √  null
categories.category_id mis_orders_fk_guarantee_id
guarantee_id mis_pos int4 10  √  null
categories.category_id mis_pos_fk_guarantee_id
height mis_active_products float8 17,17  √  null
height mis_fast_products float8 17,17  √  null
height mis_products float8 17,17  √  null
height_pretty mis_active_products varchar 2147483647  √  null
height_pretty mis_fast_products varchar 2147483647  √  null
help_contact_text auth_authorities varchar 4000  √  null Contact information (phone, email, etc.) to be displayed
as a last resort when people are having problems with an authority.
help_contact_text_format auth_authorities varchar 200  √  null
holes mis_bill_types_with_counter text 2147483647  √  null
holes mis_counters text 2147483647  √  null
id_column acs_object_types varchar 30  √  null The name of the primary key column in the table identified by
table_name.
img_mime_type mis_active_products varchar 50  √  null
img_mime_type mis_fast_products varchar 50  √  null
img_mime_type mis_products varchar 50  √  null
img_name mis_active_products varchar 200  √  null
img_name mis_fast_products varchar 200  √  null
img_name mis_products varchar 200  √  null
import_used mis_acct_iva numeric 13,2  √  null
initial_install_p apm_package_types bool 1 false Indicates if the package should be installed during initial installation,
in other words whether or not this package is part of the OpenACS core.
instance_name apm_packages varchar 300 This column enables a name to associated with each instance of package. This enables the storage
of a human-readable distinction between different package instances. This is useful
if a site admin wishes to name an instance of an application, e.g. bboard, for a subsite. The admin
might create one instance, "Boston Public Bboard" for managing public forums for the Boston subsite,
and "Boston Private Bboard" for managing private forums for the Boston subsite.
internal_used mis_acct_iva numeric 13,2  √  null
inv_account_id mis_inventories int4 10  √  null Se il campo č nullo si assume che sia imputato a 'STOCK'
inv_location_id mis_inventories int4 10  √  null
mis_store_locations.location_id mis_inventories_inv_location_id_fkey
inv_lot_id mis_inventories int4 10  √  null
mis_product_lots.lot_id mis_inventories_inv_lot_id_fkey
inv_product_id mis_inventories int4 10
mis_products.product_id mis_inventories_inv_product_id_fkey
inv_qty mis_fast_purc_invoice_lines numeric 11,2  √  null
inv_qty mis_fast_sale_invoice_lines numeric 11,2  √  null
inv_qty mis_inventories numeric 11,2  √  0
inv_qty mis_purc_invoice_lines numeric 11,2  √  null
inv_qty mis_sale_invoice_lines numeric 11,2  √  null
inv_qty_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
inv_qty_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
inv_store_id mis_inventories int4 10
mis_stores.store_id mis_inventories_inv_store_id_fkey
inventory_id mis_inventories int4 10
invoice_amount mis_fast_purc_invoices numeric 13,2  √  null
invoice_amount mis_fast_sale_invoices numeric 13,2  √  null
invoice_amount mis_purc_invoices numeric 13,2  √  null
invoice_amount mis_purc_paydates_view numeric 131089  √  null
invoice_amount mis_sale_invoices numeric 13,2  √  null
invoice_amount mis_sale_invoices_view numeric 13,2  √  null
invoice_amount mis_sale_paydates_view numeric 131089  √  null
invoice_amount_pretty mis_fast_purc_invoices varchar 2147483647  √  null
invoice_amount_pretty mis_fast_sale_invoices varchar 2147483647  √  null
invoice_amount_pretty mis_purc_paydates_view varchar 2147483647  √  null
invoice_amount_pretty mis_sale_invoices_view varchar 2147483647  √  null
invoice_amount_pretty mis_sale_paydates_view varchar 2147483647  √  null
invoice_date mis_fast_purc_invoices date 13  √  null
invoice_date mis_fast_sale_invoices date 13  √  null
invoice_date mis_purc_invoices date 13
invoice_date mis_purc_paydates_view date 13  √  null
invoice_date mis_sale_invoices date 13
invoice_date mis_sale_invoices_view date 13  √  null
invoice_date mis_sale_paydates_view date 13  √  null
invoice_date_pretty mis_fast_purc_invoices text 2147483647  √  null
invoice_date_pretty mis_fast_sale_invoices text 2147483647  √  null
invoice_date_pretty mis_purc_paydates_view text 2147483647  √  null
invoice_date_pretty mis_sale_invoices_view text 2147483647  √  null
invoice_date_pretty mis_sale_paydates_view text 2147483647  √  null
invoice_date_widget mis_fast_purc_invoices text 2147483647  √  null
invoice_date_widget mis_fast_sale_invoices text 2147483647  √  null
invoice_date_widget mis_sale_invoices_view text 2147483647  √  null
invoice_id mis_customer_dates int4 10
mis_sale_invoices.sale_invoice_id mis_customer_dates_invoice_id_fkey
invoice_id mis_sale_paydates int4 10
mis_sale_invoices.sale_invoice_id mis_sale_paydates_invoice_id_fkey
invoice_id mis_sale_paydates_view int4 10  √  null
invoice_notes mis_fast_purc_invoices text 2147483647  √  null
invoice_notes mis_fast_sale_invoices text 2147483647  √  null
invoice_notes mis_purc_invoices text 2147483647  √  null
invoice_notes mis_purc_paydates_view text 2147483647  √  null
invoice_notes mis_sale_invoices text 2147483647  √  null
invoice_notes mis_sale_invoices_view text 2147483647  √  null
invoice_num mis_fast_purc_invoices varchar 30  √  null
invoice_num mis_fast_sale_invoices varchar 30  √  null
invoice_num mis_purc_invoices varchar 30
invoice_num mis_purc_paydates_view varchar 30  √  null
invoice_num mis_sale_invoices varchar 30
invoice_num mis_sale_invoices_view varchar 30  √  null
invoice_num mis_sale_paydates_view varchar 30  √  null
invoice_ref_date mis_fast_purc_invoices date 13  √  null
invoice_ref_date mis_purc_invoices date 13  √  null
invoice_ref_date mis_purc_paydates_view date 13  √  null
invoice_ref_date_pretty mis_fast_purc_invoices text 2147483647  √  null
invoice_ref_date_pretty mis_purc_paydates_view text 2147483647  √  null
invoice_ref_date_widget mis_fast_purc_invoices text 2147483647  √  null
invoice_ref_num mis_fast_purc_invoices varchar 20  √  null
invoice_ref_num mis_purc_invoices varchar 20  √  null
invoice_ref_num mis_purc_paydates_view varchar 20  √  null
invoice_type_code mis_invoice_types varchar 3  √  null
invoice_type_code mis_purc_paydates_view varchar 3  √  null
invoice_type_code mis_sale_invoices_view varchar 3  √  null
invoice_type_code mis_sale_paydates_view varchar 3  √  null
invoice_type_description mis_invoice_types text 2147483647  √  null
invoice_type_id mis_bill_types int4 10  √  null
mis_invoice_types.invoice_type_id mis_bill_types_invoice_type_id_fkey
invoice_type_id mis_bill_types_with_counter int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_id mis_fast_purc_invoices int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_id mis_fast_sale_invoices int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_id mis_invoice_types int4 10
mis_bill_types.invoice_type_id mis_bill_types_invoice_type_id_fkey
mis_bill_types_with_counter.invoice_type_id Implied Constraint
mis_fast_purc_invoices.invoice_type_id Implied Constraint
mis_fast_sale_invoices.invoice_type_id Implied Constraint
mis_invoice_types.invoice_type_ref_id mis_invoice_types_invoice_type_ref_id_fkey
mis_purc_invoices.invoice_type_id mis_purc_invoices_invoice_type_id_fkey
mis_purc_operations.invoice_type_id Implied Constraint
mis_sale_invoices.invoice_type_id mis_sale_invoices_invoice_type_id_fkey
mis_sale_invoices_view.invoice_type_id Implied Constraint
mis_sale_operations.invoice_type_id Implied Constraint
invoice_type_id mis_purc_invoices int4 10  √  null
mis_invoice_types.invoice_type_id mis_purc_invoices_invoice_type_id_fkey
invoice_type_id mis_purc_operations int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_id mis_sale_invoices int4 10  √  null
mis_invoice_types.invoice_type_id mis_sale_invoices_invoice_type_id_fkey
invoice_type_id mis_sale_invoices_view int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_id mis_sale_operations int4 10  √  null
mis_invoice_types.invoice_type_id Implied Constraint
invoice_type_ref_id mis_invoice_types int4 10  √  null
mis_invoice_types.invoice_type_id mis_invoice_types_invoice_type_ref_id_fkey
invoice_year mis_fast_purc_invoices int4 10  √  null
invoice_year mis_fast_sale_invoices int4 10  √  null
invoice_year mis_purc_invoices int4 10
invoice_year mis_purc_operations int4 10  √  null
invoice_year mis_sale_invoices int4 10
invoice_year mis_sale_invoices_view int4 10  √  null
invoice_year mis_sale_operations int4 10  √  null
invoicing_state mis_all_orders bpchar 1  √  null
invoicing_state mis_fast_orders bpchar 1  √  null
invoicing_state mis_orders bpchar 1  √  null
ipaddr mis_monitoring varchar 20  √  null
is_accounted_p mis_fast_purc_invoices bool 1  √  null
is_accounted_p mis_fast_purc_payments bool 1  √  null
is_accounted_p mis_fast_sale_invoices bool 1  √  null
is_accounted_p mis_purc_invoices bool 1  √  null
is_accounted_p mis_purc_payments bool 1  √  null
is_accounted_p mis_sale_invoices bool 1  √  null
is_accounted_p mis_sale_invoices_view bool 1  √  null
is_accounted_p_pretty mis_sale_invoices_view text 2147483647  √  null
is_active_p mis_active_products bool 1  √  null
is_active_p mis_centers bool 1
is_active_p mis_centers_view bool 1  √  null
is_active_p mis_cust_price_map bool 1 true
is_active_p mis_customers bool 1  √  null
is_active_p mis_fast_customers bool 1  √  null
is_active_p mis_fast_parties bool 1  √  null
is_active_p mis_fast_products bool 1  √  null
is_active_p mis_fast_vendors bool 1  √  null
is_active_p mis_parties bool 1  √  null
is_active_p mis_product_categories bool 1  √  true
is_active_p mis_products bool 1  √  null
is_active_p mis_projects bool 1
is_active_p mis_projects_view bool 1  √  null
is_active_p mis_scripts bool 1  √  null
is_active_p mis_vendors bool 1  √  null
is_approved_p mis_all_orders bool 1  √  null
is_approved_p mis_bids bool 1  √  null
is_approved_p mis_delivery_notes bool 1  √  false
is_approved_p mis_fast_bids bool 1  √  null
is_approved_p mis_fast_delivery_note_lines bool 1  √  null
is_approved_p mis_fast_delivery_notes bool 1  √  null
is_approved_p mis_fast_orders bool 1  √  null
is_approved_p mis_fast_pos bool 1  √  null
is_approved_p mis_fast_rec_note_lines bool 1  √  null
is_approved_p mis_fast_rec_notes bool 1  √  null
is_approved_p mis_orders bool 1  √  null
is_approved_p mis_pos bool 1  √  null Indica se il PO č stato confermato.
is_approved_p mis_rec_notes bool 1  √  false
is_bom_p mis_active_products bool 1  √  null
is_bom_p mis_fast_products bool 1  √  null
is_bom_p mis_products bool 1  √  null
is_closed_p mis_customer_dates bool 1  √  null
is_closed_p mis_iva_ctr bool 1  √  null
is_closed_p mis_purc_paydates bool 1  √  null
is_closed_p mis_purc_paydates_view bool 1  √  null
is_closed_p mis_sale_paydates bool 1  √  null
is_closed_p mis_sale_paydates_view bool 1  √  null
is_closed_p_pretty mis_sale_paydates_view text 2147483647  √  null
is_confirmed_p mis_fast_purc_invoices bool 1  √  null
is_confirmed_p mis_fast_sale_invoices bool 1  √  null
is_confirmed_p mis_purc_invoices bool 1  √  null
is_confirmed_p mis_sale_invoices bool 1  √  null
is_confirmed_p mis_sale_invoices_view bool 1  √  null
is_confirmed_p mis_sale_paydates_view bool 1  √  null
is_confirmed_p_pretty mis_sale_invoices_view text 2147483647  √  null
is_confirmed_p_pretty mis_sale_paydates_view text 2147483647  √  null
is_contractor_p mis_bill_types bool 1  √  null
is_contractor_p mis_bill_types_with_counter bool 1  √  null
is_corrected_p mis_acct_mov bool 1  √  null
is_corrected_p mis_acct_mov_view bool 1  √  null
is_customer_p mis_customers bool 1  √  null
is_customer_p mis_fast_customers bool 1  √  null
is_customer_p mis_fast_parties bool 1  √  null
is_customer_p mis_fast_vendors bool 1  √  null
is_customer_p mis_parties bool 1  √  null
is_customer_p mis_vendors bool 1  √  null
is_ddt_p mis_invoice_types bool 1  √  null
is_effect_bank mis_banks bool 1  √  null
is_effect_bank mis_banks_view bool 1  √  null
is_effect_p mis_customer_dates bool 1  √  null
is_effect_p mis_payment_types bool 1  √  null
is_effect_p mis_purc_paydates bool 1  √  null
is_effect_p mis_purc_paydates_view bool 1  √  null
is_effect_p mis_sale_paydates bool 1  √  null
is_effect_p mis_sale_paydates_view bool 1  √  null
is_effect_p_pretty mis_sale_paydates_view text 2147483647  √  null
is_executable_p mis_scripts bool 1  √  null
is_invoice mis_invoice_types bool 1  √  null
is_invoice mis_purc_operations bool 1  √  null
is_invoice mis_purc_paydates_view bool 1  √  null
is_invoice mis_sale_operations bool 1  √  null
is_invoice mis_sale_paydates_view bool 1  √  null
is_invoice_p mis_bill_types bool 1  √  null
is_invoice_p mis_bill_types_with_counter bool 1  √  null
is_invoiced_p mis_delivery_note_lines bool 1  √  null
is_invoiced_p mis_fast_delivery_note_lines bool 1  √  null
is_invoiced_p mis_fast_rec_note_lines bool 1  √  null
is_invoiced_p mis_rec_note_lines bool 1  √  null
is_invoiced_p mis_rec_note_lines_view bool 1  √  null
is_manual_p mis_acct_schema bool 1  √  null
is_manual_p mis_wh_mov_types bool 1  √  null
is_month_end mis_payments bool 1  √  null
is_paid_p mis_fast_purc_invoices bool 1  √  null
is_paid_p mis_fast_sale_invoices bool 1  √  null
is_paid_p mis_purc_invoices bool 1  √  null
is_paid_p mis_sale_invoices bool 1  √  null
is_paid_p mis_sale_invoices_view bool 1  √  null
is_printed_p mis_all_orders bool 1  √  null
is_printed_p mis_bids bool 1  √  null
is_printed_p mis_fast_bids bool 1  √  null
is_printed_p mis_fast_orders bool 1  √  null
is_printed_p mis_fast_pos bool 1  √  null
is_printed_p mis_fast_sale_invoices bool 1  √  null
is_printed_p mis_orders bool 1  √  null
is_printed_p mis_pos bool 1  √  null Indica se il PO č stato stampato e spedito al fornitore.
is_printed_p mis_sale_invoices bool 1  √  null
is_printed_p mis_sale_invoices_view bool 1  √  null
is_purchased_p mis_active_products bool 1  √  null
is_purchased_p mis_fast_products bool 1  √  null
is_purchased_p mis_products bool 1  √  null
is_purcs_closed_p mis_acct_iva bool 1  √  null
is_ready_p mis_all_orders bool 1  √  null
is_ready_p mis_fast_orders bool 1  √  null
is_ready_p mis_orders bool 1  √  null
is_revert_p mis_acct_mov bool 1  √  false
is_revert_p mis_acct_mov_view bool 1  √  null
is_revert_p mis_wh_mov bool 1  √  false
is_sales mis_invoice_types bool 1  √  null
is_sales_closed_p mis_acct_iva bool 1  √  null
is_sales_p mis_bill_types bool 1  √  null
is_sales_p mis_bill_types_with_counter bool 1  √  null
is_sold_p mis_active_products bool 1  √  null
is_sold_p mis_fast_products bool 1  √  null
is_sold_p mis_products bool 1  √  null
is_stocked_p mis_active_products bool 1  √  null
is_stocked_p mis_fast_delivery_note_lines bool 1  √  null
is_stocked_p mis_fast_products bool 1  √  null
is_stocked_p mis_fast_rec_note_lines bool 1  √  null
is_stocked_p mis_products bool 1  √  null
is_stocked_p mis_rec_note_lines_view bool 1  √  null
is_tax_included_p mis_purc_price_lists bool 1 false
is_tax_included_p mis_purc_prices bool 1  √  null
is_tax_included_p mis_purc_products_with_prices bool 1  √  null
is_to_pay_stamp_p mis_fast_sale_invoices bool 1  √  null
is_to_pay_stamp_p mis_sale_invoices bool 1  √  null
is_to_pay_stamp_p mis_sale_invoices_view bool 1  √  null
is_urgent_p mis_all_orders bool 1  √  null
is_urgent_p mis_fast_orders bool 1  √  null
is_urgent_p mis_orders bool 1  √  null
is_vendor_p mis_customers bool 1  √  null
is_vendor_p mis_fast_customers bool 1  √  null
is_vendor_p mis_fast_parties bool 1  √  null
is_vendor_p mis_fast_vendors bool 1  √  null
is_vendor_p mis_parties bool 1  √  null
is_vendor_p mis_vendors bool 1  √  null
iso countries bpchar 2
mis_addresses.country_iso mis_addresses_country_iso_fkey
mis_banks.iso Implied Constraint
mis_banks_view.iso Implied Constraint
iso mis_banks bpchar 2  √  null
countries.iso Implied Constraint
iso mis_banks_view bpchar 2  √  null
countries.iso Implied Constraint
item_description mis_fast_purc_invoice_lines text 2147483647  √  null
item_description mis_fast_sale_invoice_lines text 2147483647  √  null
item_description mis_purc_invoice_lines text 2147483647  √  null
item_description mis_sale_invoice_lines text 2147483647  √  null
item_id mis_accounts_view int4 10  √  null
item_id mis_active_products int4 10  √  null
item_id mis_all_orders int4 10  √  null
item_id mis_centers_view int4 10  √  null
item_id mis_contract_lines int4 10  √  null
item_id mis_customers int4 10  √  null
item_id mis_fast_bid_lines int4 10  √  null
item_id mis_fast_bids int4 10  √  null
item_id mis_fast_customers int4 10  √  null
item_id mis_fast_delivery_note_lines int4 10  √  null
item_id mis_fast_delivery_notes int4 10  √  null
item_id mis_fast_mr_lines int4 10  √  null
item_id mis_fast_mrs int4 10  √  null
item_id mis_fast_order_lines int4 10  √  null
item_id mis_fast_orders int4 10  √  null
item_id mis_fast_parties int4 10  √  null
item_id mis_fast_po_lines int4 10  √  null
item_id mis_fast_pos int4 10  √  null
item_id mis_fast_products int4 10  √  null
item_id mis_fast_purc_invoice_lines int4 10  √  null
item_id mis_fast_purc_invoices int4 10  √  null
item_id mis_fast_rec_note_lines int4 10  √  null
item_id mis_fast_rec_notes int4 10  √  null
item_id mis_fast_sale_invoice_lines int4 10  √  null
item_id mis_fast_sale_invoices int4 10  √  null
item_id mis_fast_vendors int4 10  √  null
item_id mis_projects_view int4 10  √  null
item_id mis_rec_note_lines_view int4 10  √  null
item_id mis_sale_invoices_view int4 10  √  null
item_id mis_vendors int4 10  √  null
iva_amount mis_fast_purc_invoice_lines numeric 11,2  √  null
iva_amount mis_fast_purc_iva numeric 11,2  √  null
iva_amount mis_fast_sale_iva numeric 11,2  √  null
iva_amount mis_purc_invoice_lines numeric 11,2  √  null
iva_amount mis_purc_iva numeric 11,2  √  null
iva_amount mis_purc_operations numeric 131089  √  null
iva_amount mis_sale_iva numeric 11,2  √  null
iva_amount mis_sale_operations numeric 131089  √  null
iva_amount_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
iva_amount_pretty mis_fast_purc_iva varchar 2147483647  √  null
iva_amount_pretty mis_fast_sale_iva varchar 2147483647  √  null
iva_code mis_customers bpchar 11  √  null
iva_code mis_fast_customers bpchar 11  √  null
iva_code mis_fast_parties bpchar 11  √  null
iva_code mis_fast_purc_iva varchar 10  √  null
iva_code mis_fast_sale_iva varchar 10  √  null
iva_code mis_fast_vendors bpchar 11  √  null
iva_code mis_iva varchar 10  √  null
iva_code mis_parties bpchar 11  √  null partita IVA
iva_code mis_party_mod varchar 11  √  null
iva_code mis_purc_operations text 2147483647  √  null
iva_code mis_sale_operations text 2147483647  √  null
iva_code mis_vendors bpchar 11  √  null
iva_ctr_id mis_iva_ctr int4 10
iva_description mis_fast_purc_iva varchar 50  √  null
iva_description mis_fast_sale_iva varchar 50  √  null
iva_description mis_iva varchar 50  √  null
iva_id mis_active_products int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_customers int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_delivery_note_lines int4 10
mis_iva.iva_id mis_delivery_note_lines_iva_id_fkey
iva_id mis_fast_customers int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_delivery_note_lines int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_delivery_notes int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_parties int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_products int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_purc_invoice_lines int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_purc_iva int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_rec_note_lines int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_rec_notes int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_sale_invoice_lines int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_sale_iva int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_fast_vendors int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_iva int4 10
mis_active_products.iva_id Implied Constraint
mis_customers.iva_id Implied Constraint
mis_delivery_note_lines.iva_id mis_delivery_note_lines_iva_id_fkey
mis_fast_customers.iva_id Implied Constraint
mis_fast_delivery_note_lines.iva_id Implied Constraint
mis_fast_delivery_notes.iva_id Implied Constraint
mis_fast_parties.iva_id Implied Constraint
mis_fast_products.iva_id Implied Constraint
mis_fast_purc_invoice_lines.iva_id Implied Constraint
mis_fast_purc_iva.iva_id Implied Constraint
mis_fast_rec_note_lines.iva_id Implied Constraint
mis_fast_rec_notes.iva_id Implied Constraint
mis_fast_sale_invoice_lines.iva_id Implied Constraint
mis_fast_sale_iva.iva_id Implied Constraint
mis_fast_vendors.iva_id Implied Constraint
mis_parties.iva_id mis_parties_fk_iva_id
mis_products.iva_id mis_product_iva_id_fk
mis_purc_invoice_lines.iva_id mis_purc_invoice_lines_iva_id_fkey
mis_purc_iva.iva_id mis_purc_iva_iva_id_fkey
mis_purc_operations.iva_id Implied Constraint
mis_rec_note_lines_view.iva_id Implied Constraint
mis_sale_invoice_lines.iva_id mis_sale_invoice_lines_iva_id_fkey
mis_sale_iva.iva_id mis_sale_iva_iva_id_fkey
mis_sale_operations.iva_id Implied Constraint
mis_vendors.iva_id Implied Constraint
iva_id mis_parties int4 10  √  null
mis_iva.iva_id mis_parties_fk_iva_id
codice imposta IVA; se presente prevale in fattura su quello dell'articolo
iva_id mis_products int4 10  √  null
mis_iva.iva_id mis_product_iva_id_fk
iva_id mis_purc_invoice_lines int4 10
mis_iva.iva_id mis_purc_invoice_lines_iva_id_fkey
iva_id mis_purc_iva int4 10
mis_iva.iva_id mis_purc_iva_iva_id_fkey
iva_id mis_purc_operations int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_rec_note_lines_view int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_sale_invoice_lines int4 10
mis_iva.iva_id mis_sale_invoice_lines_iva_id_fkey
iva_id mis_sale_iva int4 10
mis_iva.iva_id mis_sale_iva_iva_id_fkey
iva_id mis_sale_operations int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_id mis_vendors int4 10  √  null
mis_iva.iva_id Implied Constraint
iva_percent mis_fast_purc_iva float8 17,17  √  null
iva_percent mis_fast_sale_iva float8 17,17  √  null
iva_percent mis_iva float8 17,17  √  null
iva_percent_pretty mis_fast_purc_iva varchar 2147483647  √  null
iva_percent_pretty mis_fast_sale_iva varchar 2147483647  √  null
iva_type mis_iva varchar 1  √  null
iva_type mis_purc_operations varchar 1  √  null
iva_type mis_sale_operations varchar 1  √  null
ivable_amount mis_fast_purc_iva numeric 13,2  √  null
ivable_amount mis_fast_sale_iva numeric 13,2  √  null
ivable_amount mis_purc_iva numeric 13,2  √  null
ivable_amount mis_purc_operations numeric 131089  √  null
ivable_amount mis_sale_iva numeric 13,2  √  null
ivable_amount mis_sale_operations numeric 131089  √  null
ivable_amount_pretty mis_fast_purc_iva varchar 2147483647  √  null
ivable_amount_pretty mis_fast_sale_iva varchar 2147483647  √  null
language_id language_codes bpchar 2
mis_all_orders.language_id Implied Constraint
mis_bids.language_id mis_bids_fk_language_id
mis_customers.language_id Implied Constraint
mis_delivery_notes.language_id mis_delivery_notes_language_id_fkey
mis_fast_bids.language_id Implied Constraint
mis_fast_customers.language_id Implied Constraint
mis_fast_delivery_notes.language_id Implied Constraint
mis_fast_orders.language_id Implied Constraint
mis_fast_parties.language_id Implied Constraint
mis_fast_pos.language_id Implied Constraint
mis_fast_sale_invoices.language_id Implied Constraint
mis_fast_vendors.language_id Implied Constraint
mis_orders.language_id mis_orders_fk_language_id
mis_parties.language_id mis_parties_fk_language_id
mis_pos.language_id mis_pos_fk_language_id
mis_sale_invoices.language_id mis_sale_invoices_language_id_fkey
mis_sale_invoices_view.language_id Implied Constraint
mis_vendors.language_id Implied Constraint
This is the ISO standard language code
language_id mis_all_orders bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_bids bpchar 2  √  null
language_codes.language_id mis_bids_fk_language_id
language_id mis_customers bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_delivery_notes bpchar 2  √  null
language_codes.language_id mis_delivery_notes_language_id_fkey
language_id mis_fast_bids bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_customers bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_delivery_notes bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_orders bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_parties bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_pos bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_sale_invoices bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_fast_vendors bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_orders bpchar 2  √  null
language_codes.language_id mis_orders_fk_language_id
language_id mis_parties bpchar 2  √  null
language_codes.language_id mis_parties_fk_language_id
language_id mis_pos bpchar 2  √  null
language_codes.language_id mis_pos_fk_language_id
language_id mis_sale_invoices bpchar 2  √  null
language_codes.language_id mis_sale_invoices_language_id_fkey
language_id mis_sale_invoices_view bpchar 2  √  null
language_codes.language_id Implied Constraint
language_id mis_vendors bpchar 2  √  null
language_codes.language_id Implied Constraint
last_modified acs_objects timestamptz 35,6 now()
last_modified mis_accounts_view timestamptz 35,6  √  null
last_modified mis_active_products timestamptz 35,6  √  null
last_modified mis_all_orders timestamptz 35,6  √  null
last_modified mis_centers_view timestamptz 35,6  √  null
last_modified mis_contract_lines timestamptz 35,6  √  null
last_modified mis_customers timestamptz 35,6  √  null
last_modified mis_fast_bid_lines timestamptz 35,6  √  null
last_modified mis_fast_bids timestamptz 35,6  √  null
last_modified mis_fast_customers timestamptz 35,6  √  null
last_modified mis_fast_delivery_note_lines timestamptz 35,6  √  null
last_modified mis_fast_delivery_notes timestamptz 35,6  √  null
last_modified mis_fast_mr_lines timestamptz 35,6  √  null
last_modified mis_fast_mrs timestamptz 35,6  √  null
last_modified mis_fast_order_lines timestamptz 35,6  √  null
last_modified mis_fast_orders timestamptz 35,6  √  null
last_modified mis_fast_parties timestamptz 35,6  √  null
last_modified mis_fast_po_lines timestamptz 35,6  √  null
last_modified mis_fast_pos timestamptz 35,6  √  null
last_modified mis_fast_products timestamptz 35,6  √  null
last_modified mis_fast_purc_invoice_lines timestamptz 35,6  √  null
last_modified mis_fast_purc_invoices timestamptz 35,6  √  null
last_modified mis_fast_rec_note_lines timestamptz 35,6  √  null
last_modified mis_fast_rec_notes timestamptz 35,6  √  null
last_modified mis_fast_sale_invoice_lines timestamptz 35,6  √  null
last_modified mis_fast_sale_invoices timestamptz 35,6  √  null
last_modified mis_fast_vendors timestamptz 35,6  √  null
last_modified mis_projects_view timestamptz 35,6  √  null
last_modified mis_rec_note_lines_view timestamptz 35,6  √  null
last_modified mis_sale_invoices_view timestamptz 35,6  √  null
last_modified mis_vendors timestamptz 35,6  √  null
last_name persons varchar 100
last_visit users timestamptz 35,6  √  null Set when user reappears at site
left_ind categories int4 10  √  null Left index in nested set structure of a tree.
line_amount mis_fast_sale_invoice_lines numeric 131089  √  null
line_amount_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
line_date_promised mis_contract_lines date 13  √  null
line_date_promised mis_fast_order_lines date 13  √  null
line_date_promised mis_order_lines date 13  √  null
line_date_promised_pretty mis_contract_lines text 2147483647  √  null
line_date_promised_pretty mis_fast_order_lines text 2147483647  √  null
line_date_promised_widget mis_contract_lines text 2147483647  √  null
line_date_promised_widget mis_fast_order_lines text 2147483647  √  null
line_date_requested mis_fast_mr_lines date 13  √  null
line_date_requested mis_fast_po_lines date 13  √  null
line_date_requested mis_mr_lines date 13  √  null
line_date_requested mis_po_lines date 13
line_date_requested_pretty mis_fast_mr_lines text 2147483647  √  null
line_date_requested_pretty mis_fast_po_lines text 2147483647  √  null
line_date_requested_widget mis_fast_mr_lines text 2147483647  √  null
line_date_requested_widget mis_fast_po_lines text 2147483647  √  null
line_days_from_order mis_bid_lines int4 10  √  0
line_days_from_order mis_fast_bid_lines int4 10  √  null
line_id mis_bid_lines int4 10
acs_objects.object_id mis_bid_lines_line_id_fkey
line_id mis_contract_lines int4 10  √  null
mis_mr_lines.line_id Implied Constraint
line_id mis_fast_bid_lines int4 10  √  null
mis_mr_lines.line_id Implied Constraint
line_id mis_fast_mr_lines int4 10  √  null
mis_mr_lines.line_id Implied Constraint
line_id mis_fast_order_lines int4 10  √  null
mis_mr_lines.line_id Implied Constraint
line_id mis_fast_po_lines int4 10  √  null
mis_mr_lines.line_id Implied Constraint
line_id mis_mr_lines int4 10
mis_contract_lines.line_id Implied Constraint
mis_fast_bid_lines.line_id Implied Constraint
mis_fast_mr_lines.line_id Implied Constraint
mis_fast_order_lines.line_id Implied Constraint
mis_fast_po_lines.line_id Implied Constraint
mis_po_lines.mr_line_id mis_po_lines_mr_line_id_fk
acs_objects.object_id mis_mr_lines_line_id_fk
line_id mis_order_lines int4 10
acs_objects.object_id mis_order_lines_line_id_fkey
line_id mis_po_lines int4 10
mis_rec_note_lines.po_line_id mis_rec_note_lines_po_line_id_fkey
acs_objects.object_id mis_po_lines_line_id_fk
line_no mis_bid_lines int4 10
line_no mis_contract_lines int4 10  √  null
line_no mis_fast_bid_lines int4 10  √  null
line_no mis_fast_mr_lines int4 10  √  null
line_no mis_fast_order_lines int4 10  √  null
line_no mis_fast_po_lines int4 10  √  null
line_no mis_mr_lines int4 10
line_no mis_order_lines int4 10
line_no mis_po_lines int4 10
line_no mis_print int4 10  √  null
line_notes mis_fast_purc_invoice_lines text 2147483647  √  null
line_notes mis_fast_sale_invoice_lines text 2147483647  √  null
line_notes mis_purc_invoice_lines text 2147483647  √  null
line_notes mis_sale_invoice_lines text 2147483647  √  null
line_price mis_contract_lines numeric 131089  √  null
line_price mis_fast_bid_lines numeric 131089  √  null
line_price mis_fast_delivery_note_lines numeric 131089  √  null
line_price mis_fast_order_lines numeric 131089  √  null
line_price mis_fast_po_lines numeric 131089  √  null
line_price mis_fast_purc_invoice_lines numeric 131089  √  null
line_price mis_fast_rec_note_lines numeric 131089  √  null
line_price mis_rec_note_lines_view numeric 131089  √  null
line_price_pretty mis_contract_lines varchar 2147483647  √  null
line_price_pretty mis_fast_bid_lines varchar 2147483647  √  null
line_price_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
line_price_pretty mis_fast_order_lines varchar 2147483647  √  null
line_price_pretty mis_fast_po_lines varchar 2147483647  √  null
line_price_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
line_price_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
line_price_pretty mis_rec_note_lines_view varchar 2147483647  √  null
line_rec_text mis_fast_rec_note_lines text 2147483647  √  null
line_rec_text mis_rec_note_lines text 2147483647  √  null
line_rec_text mis_rec_note_lines_view text 2147483647  √  null
line_state mis_contract_lines bpchar 1  √  null
line_state mis_fast_mr_lines bpchar 1  √  null
line_state mis_fast_order_lines bpchar 1  √  null
line_state mis_fast_po_lines bpchar 1  √  null
line_state mis_mr_lines bpchar 1  √  null O=Open C=Closed
line_state mis_order_lines bpchar 1  √  null
line_state mis_po_lines bpchar 1  √  null O=Open C=Closed
location_code mis_store_locations varchar 50
location_id mis_product_wh int4 10  √  null
mis_store_locations.location_id mis_product_wh_location_id_fkey
Ubicazione di default del prodotto in magazzino.
location_id mis_store_locations int4 10
mis_inventories.inv_location_id mis_inventories_inv_location_id_fkey
mis_product_wh.location_id mis_product_wh_location_id_fkey
mis_wh_mov.wh_mov_location_id mis_wh_mov_wh_mov_location_id_fkey
logdate mis_monitoring timestamp 29,6  √  null
lot_description mis_product_lots varchar 50  √  null
lot_id mis_delivery_note_lines int4 10  √  null
mis_product_lots.lot_id mis_delivery_note_lines_lot_id_fkey
lot_id mis_fast_delivery_note_lines int4 10  √  null
mis_product_lots.lot_id Implied Constraint
lot_id mis_product_lots int4 10
mis_delivery_note_lines.lot_id mis_delivery_note_lines_lot_id_fkey
mis_fast_delivery_note_lines.lot_id Implied Constraint
mis_inventories.inv_lot_id mis_inventories_inv_lot_id_fkey
mis_wh_mov.wh_mov_lot_id mis_wh_mov_wh_mov_lot_id_fkey
lot_no mis_fast_rec_note_lines varchar 20  √  null
lot_no mis_product_lots varchar 20  √  null
lot_no mis_rec_note_lines varchar 20  √  null
lot_no mis_rec_note_lines_view varchar 20  √  null
lot_po_id mis_product_lots int4 10  √  null Riferimento all'ordine fornitore.
lot_source mis_product_lots varchar 50  √  null Fonte: attualmente non usata.
maintainer mis_scripts int4 10  √  null
users.user_id mis_scripts_fk2
map_id mis_customers_products_map int4 10
mis_vendors_products_map.map_id Implied Constraint
map_id mis_vendors_products_map int4 10
mis_customers_products_map.map_id Implied Constraint
mapping_type mis_party_accounts bpchar 1 Poichč un soggetto puņ essere contemporaneamente cliente e fornitore, il campo
specifica se i conti seguenti si riferiscono al soggetto inteso come cliente 'C'
o come fornitore 'F'.
max_child_sortkey acs_objects varbit 2147483647  √  null
max_child_sortkey mis_accounts_view varbit 2147483647  √  null
max_child_sortkey mis_active_products varbit 2147483647  √  null
max_child_sortkey mis_all_orders varbit 2147483647  √  null
max_child_sortkey mis_centers_view varbit 2147483647  √  null
max_child_sortkey mis_contract_lines varbit 2147483647  √  null
max_child_sortkey mis_customers varbit 2147483647  √  null
max_child_sortkey mis_fast_bid_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_bids varbit 2147483647  √  null
max_child_sortkey mis_fast_customers varbit 2147483647  √  null
max_child_sortkey mis_fast_delivery_note_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_delivery_notes varbit 2147483647  √  null
max_child_sortkey mis_fast_mr_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_mrs varbit 2147483647  √  null
max_child_sortkey mis_fast_order_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_orders varbit 2147483647  √  null
max_child_sortkey mis_fast_parties varbit 2147483647  √  null
max_child_sortkey mis_fast_po_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_pos varbit 2147483647  √  null
max_child_sortkey mis_fast_products varbit 2147483647  √  null
max_child_sortkey mis_fast_purc_invoice_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_purc_invoices varbit 2147483647  √  null
max_child_sortkey mis_fast_rec_note_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_rec_notes varbit 2147483647  √  null
max_child_sortkey mis_fast_sale_invoice_lines varbit 2147483647  √  null
max_child_sortkey mis_fast_sale_invoices varbit 2147483647  √  null
max_child_sortkey mis_fast_vendors varbit 2147483647  √  null
max_child_sortkey mis_projects_view varbit 2147483647  √  null
max_child_sortkey mis_rec_note_lines_view varbit 2147483647  √  null
max_child_sortkey mis_sale_invoices_view varbit 2147483647  √  null
max_child_sortkey mis_vendors varbit 2147483647  √  null
mgm_account_id mis_acct_customers int4 10  √  null
mgm_account_id mis_acct_vendors int4 10  √  null
mgm_account_id mis_party_accounts int4 10  √  null
mis_accounts.account_id mis_party_accounts_mgm_account_id_fkey
min_inv_qty mis_product_wh numeric 11,2  √  0
min_lot_qty mis_product_wh numeric 11,2  √  0
minor_unit currencies bpchar 1  √  null
modifying_ip acs_objects varchar 50  √  null
modifying_ip mis_accounts_view varchar 50  √  null
modifying_ip mis_active_products varchar 50  √  null
modifying_ip mis_all_orders varchar 50  √  null
modifying_ip mis_centers_view varchar 50  √  null
modifying_ip mis_contract_lines varchar 50  √  null
modifying_ip mis_customers varchar 50  √  null
modifying_ip mis_fast_bid_lines varchar 50  √  null
modifying_ip mis_fast_bids varchar 50  √  null
modifying_ip mis_fast_customers varchar 50  √  null
modifying_ip mis_fast_delivery_note_lines varchar 50  √  null
modifying_ip mis_fast_delivery_notes varchar 50  √  null
modifying_ip mis_fast_mr_lines varchar 50  √  null
modifying_ip mis_fast_mrs varchar 50  √  null
modifying_ip mis_fast_order_lines varchar 50  √  null
modifying_ip mis_fast_orders varchar 50  √  null
modifying_ip mis_fast_parties varchar 50  √  null
modifying_ip mis_fast_po_lines varchar 50  √  null
modifying_ip mis_fast_pos varchar 50  √  null
modifying_ip mis_fast_products varchar 50  √  null
modifying_ip mis_fast_purc_invoice_lines varchar 50  √  null
modifying_ip mis_fast_purc_invoices varchar 50  √  null
modifying_ip mis_fast_rec_note_lines varchar 50  √  null
modifying_ip mis_fast_rec_notes varchar 50  √  null
modifying_ip mis_fast_sale_invoice_lines varchar 50  √  null
modifying_ip mis_fast_sale_invoices varchar 50  √  null
modifying_ip mis_fast_vendors varchar 50  √  null
modifying_ip mis_projects_view varchar 50  √  null
modifying_ip mis_rec_note_lines_view varchar 50  √  null
modifying_ip mis_sale_invoices_view varchar 50  √  null
modifying_ip mis_vendors varchar 50  √  null
modifying_user acs_objects int4 10  √  null
users.user_id acs_objects_modifying_user_fk
Who last modified the object
modifying_user mis_accounts_view int4 10  √  null
modifying_user mis_active_products int4 10  √  null
modifying_user mis_all_orders int4 10  √  null
modifying_user mis_centers_view int4 10  √  null
modifying_user mis_contract_lines int4 10  √  null
modifying_user mis_customers int4 10  √  null
modifying_user mis_fast_bid_lines int4 10  √  null
modifying_user mis_fast_bids int4 10  √  null
modifying_user mis_fast_customers int4 10  √  null
modifying_user mis_fast_delivery_note_lines int4 10  √  null
modifying_user mis_fast_delivery_notes int4 10  √  null
modifying_user mis_fast_mr_lines int4 10  √  null
modifying_user mis_fast_mrs int4 10  √  null
modifying_user mis_fast_order_lines int4 10  √  null
modifying_user mis_fast_orders int4 10  √  null
modifying_user mis_fast_parties int4 10  √  null
modifying_user mis_fast_po_lines int4 10  √  null
modifying_user mis_fast_pos int4 10  √  null
modifying_user mis_fast_products int4 10  √  null
modifying_user mis_fast_purc_invoice_lines int4 10  √  null
modifying_user mis_fast_purc_invoices int4 10  √  null
modifying_user mis_fast_rec_note_lines int4 10  √  null
modifying_user mis_fast_rec_notes int4 10  √  null
modifying_user mis_fast_sale_invoice_lines int4 10  √  null
modifying_user mis_fast_sale_invoices int4 10  √  null
modifying_user mis_fast_vendors int4 10  √  null
modifying_user mis_projects_view int4 10  √  null
modifying_user mis_rec_note_lines_view int4 10  √  null
modifying_user mis_sale_invoices_view int4 10  √  null
modifying_user mis_vendors int4 10  √  null
month_to_skip_1 mis_payments int4 10  √  null
month_to_skip_2 mis_payments int4 10  √  null
mov_account_id mis_customer_payments int4 10  √  null
mis_mov_accounts.mov_account_id mis_customer_payments_mov_account_id_fkey
mov_account_id mis_fast_customer_payments int4 10  √  null
mis_mov_accounts.mov_account_id Implied Constraint
mov_account_id mis_fast_purc_payments int4 10  √  null
mis_mov_accounts.mov_account_id Implied Constraint
mov_account_id mis_mov_accounts int4 10
mis_customer_payments.mov_account_id mis_customer_payments_mov_account_id_fkey
mis_fast_customer_payments.mov_account_id Implied Constraint
mis_fast_purc_payments.mov_account_id Implied Constraint
mis_mov_accounts_view.mov_account_id Implied Constraint
mis_purc_payments.mov_account_id mis_purc_payments_mov_account_id_fkey
mov_account_id mis_mov_accounts_view int4 10  √  null
mis_mov_accounts.mov_account_id Implied Constraint
mov_account_id mis_purc_payments int4 10  √  null
mis_mov_accounts.mov_account_id mis_purc_payments_mov_account_id_fkey
mr_code mis_fast_mrs varchar 20  √  null
mr_code mis_mrs varchar 20
mr_date mis_fast_mrs date 13  √  null
mr_date mis_mrs date 13  √  null
mr_date_pretty mis_fast_mrs text 2147483647  √  null
mr_date_widget mis_fast_mrs text 2147483647  √  null
mr_id mis_fast_mr_lines int4 10  √  null
mis_mrs.mr_id Implied Constraint
mr_id mis_fast_mrs int4 10  √  null
mis_mrs.mr_id Implied Constraint
mr_id mis_fast_pos int4 10  √  null
mis_mrs.mr_id Implied Constraint
mr_id mis_mr_lines int4 10
mis_mrs.mr_id mis_mr_lines_mr_id_fk
mr_id mis_mrs int4 10
mis_fast_mr_lines.mr_id Implied Constraint
mis_fast_mrs.mr_id Implied Constraint
mis_fast_pos.mr_id Implied Constraint
mis_mr_lines.mr_id mis_mr_lines_mr_id_fk
mis_pos.mr_id mis_pos_mr_id_fk
acs_objects.object_id mis_mrs_mr_id_fk
mr_id mis_pos int4 10  √  null
mis_mrs.mr_id mis_pos_mr_id_fk
Il normale ciclo passivo prevede la predisposizione di una RDA, che sarą evasa da un ordine d'acquisto (PO) ed
in questo caso la colonna mr_id fa riferimento alla RDA originante. Notare che, per scelta progettuale, un PO
puņ evadere una ed una sola RDA.

Un PO puņ anche essere creato direttamente, ed in questo caso mr_id deve essere nullo.
mr_line_id mis_fast_po_lines int4 10  √  null
mr_line_id mis_po_lines int4 10  √  null
mis_mr_lines.line_id mis_po_lines_mr_line_id_fk
Riferimento alla riga di RDA.
n_sessions users int4 10 1 How many times this user has visited
name language_codes varchar 100 This is the English version of the language name.
I don't want to get crazy here!
name_method acs_object_types varchar 100  √  null The name of a stored function that takes an object_id as an argument
and returns a varchar2: the corresponding object name. This column is
required to implement the polymorphic behavior of the acs.object_name()
function.
net_weight mis_delivery_notes numeric 5,2  √  null
net_weight mis_fast_delivery_notes numeric 5,2  √  null
net_weight mis_fast_rec_notes numeric 11,2  √  null
net_weight mis_rec_notes numeric 11,2  √  null
net_weight_pretty mis_fast_delivery_notes varchar 2147483647  √  null
net_weight_pretty mis_fast_rec_notes varchar 2147483647  √  null
no_alerts_until users timestamptz 35,6  √  null For suppressing email alerts
note currencies varchar 4000  √  null
notes mis_bid_lines text 2147483647  √  null
notes mis_bill_types text 2147483647  √  null
notes mis_bill_types_with_counter text 2147483647  √  null
notes mis_delivery_transport text 2147483647  √  null
notes mis_fast_bid_lines text 2147483647  √  null
notes mis_invoice_types text 2147483647  √  null
num_pages mis_iva_ctr int4 10  √  null
object_id acs_objects int4 10
acs_objects.context_id acs_objects_context_id_fk
apm_packages.package_id apm_packages_package_id_fk
auth_authorities.auth_impl_id auth_authority_auth_impl_fk
auth_authorities.authority_id auth_authorities_aid_fk
auth_authorities.get_doc_impl_id auth_authority_getdoc_impl_fk
auth_authorities.process_doc_impl_id auth_authority_procdoc_impl_fk
auth_authorities.pwd_impl_id auth_authority_pwd_impl_fk
auth_authorities.register_impl_id auth_authority_reg_impl_fk
auth_authorities.user_info_impl_id auth_authority_userinf_impl_fk
categories.category_id cat_category_id_fk
category_trees.tree_id cat_trees_tree_id_fk
mis_accounts.account_id mis_accounts_account_id_fkey
mis_accounts_view.object_id Implied Constraint
mis_acct_mov.document_id mis_acct_mov_document_id_fkey
mis_active_products.object_id Implied Constraint
mis_all_orders.object_id Implied Constraint
mis_bid_lines.line_id mis_bid_lines_line_id_fkey
mis_bids.bid_id mis_bids_bid_id_fkey
mis_centers_view.object_id Implied Constraint
mis_contract_lines.object_id Implied Constraint
mis_customers.object_id Implied Constraint
mis_delivery_note_lines.delivery_line_id mis_delivery_note_lines_delivery_line_id_fkey
mis_delivery_note_lines.reference_id mis_delivery_note_lines_reference_id_fkey
mis_delivery_notes.delivery_id mis_delivery_notes_delivery_id_fkey
mis_fast_bid_lines.object_id Implied Constraint
mis_fast_bids.object_id Implied Constraint
mis_fast_customers.object_id Implied Constraint
mis_fast_delivery_note_lines.object_id Implied Constraint
mis_fast_delivery_notes.object_id Implied Constraint
mis_fast_mr_lines.object_id Implied Constraint
mis_fast_mrs.object_id Implied Constraint
mis_fast_order_lines.object_id Implied Constraint
mis_fast_orders.object_id Implied Constraint
mis_fast_parties.object_id Implied Constraint
mis_fast_po_lines.object_id Implied Constraint
mis_fast_pos.object_id Implied Constraint
mis_fast_products.object_id Implied Constraint
mis_fast_purc_invoice_lines.object_id Implied Constraint
mis_fast_purc_invoices.object_id Implied Constraint
mis_fast_rec_note_lines.object_id Implied Constraint
mis_fast_rec_notes.object_id Implied Constraint
mis_fast_sale_invoice_lines.object_id Implied Constraint
mis_fast_sale_invoices.object_id Implied Constraint
mis_fast_vendors.object_id Implied Constraint
mis_mr_lines.line_id mis_mr_lines_line_id_fk
mis_mrs.mr_id mis_mrs_mr_id_fk
mis_order_lines.line_id mis_order_lines_line_id_fkey
mis_orders.order_id mis_orders_order_id_fkey
mis_parties.party_id mis_parties_party_id_fkey
mis_party_mod.party_id mis_party_mod_party_id_fkey
mis_po_lines.line_id mis_po_lines_line_id_fk
mis_pos.po_id mis_pos_po_id_fk
mis_products.product_id mis_products_product_id_fkey
mis_projects_view.object_id Implied Constraint
mis_purc_invoice_lines.purc_invoice_line_id mis_purc_invoice_lines_purc_invoice_line_id_fkey
mis_purc_invoices.purc_invoice_id mis_purc_invoices_purc_invoice_id_fkey
mis_rec_note_lines.rec_line_id mis_rec_note_lines_rec_line_id_fkey
mis_rec_note_lines_view.object_id Implied Constraint
mis_rec_notes.rec_id mis_rec_notes_rec_id_fkey
mis_sale_invoice_lines.sale_invoice_line_id mis_sale_invoice_lines_sale_invoice_line_id_fkey
mis_sale_invoices.sale_invoice_id mis_sale_invoices_sale_invoice_id_fkey
mis_sale_invoices_view.object_id Implied Constraint
mis_scripts.script_id mis_scripts_script_id_fkey
mis_vendors.object_id Implied Constraint
parties.party_id parties_party_id_fk
object_id mis_accounts_view int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_active_products int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_all_orders int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_centers_view int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_contract_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_customers int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_bid_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_bids int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_customers int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_delivery_note_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_delivery_notes int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_mr_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_mrs int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_order_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_orders int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_parties int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_po_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_pos int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_products int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_purc_invoice_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_purc_invoices int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_rec_note_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_rec_notes int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_sale_invoice_lines int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_sale_invoices int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_fast_vendors int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_projects_view int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_rec_note_lines_view int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_sale_invoices_view int4 10  √  null
acs_objects.object_id Implied Constraint
object_id mis_vendors int4 10  √  null
acs_objects.object_id Implied Constraint
object_type acs_object_types varchar 1000
acs_object_types.supertype acs_object_types_supertype_fk
acs_objects.object_type acs_objects_object_type_fk
object_type acs_objects varchar 100
acs_object_types.object_type acs_objects_object_type_fk
object_type mis_accounts_view varchar 100  √  null
object_type mis_active_products varchar 100  √  null
object_type mis_all_orders varchar 100  √  null
object_type mis_centers_view varchar 100  √  null
object_type mis_contract_lines varchar 100  √  null
object_type mis_customers varchar 100  √  null
object_type mis_fast_bid_lines varchar 100  √  null
object_type mis_fast_bids varchar 100  √  null
object_type mis_fast_customers varchar 100  √  null
object_type mis_fast_delivery_note_lines varchar 100  √  null
object_type mis_fast_delivery_notes varchar 100  √  null
object_type mis_fast_mr_lines varchar 100  √  null
object_type mis_fast_mrs varchar 100  √  null
object_type mis_fast_order_lines varchar 100  √  null
object_type mis_fast_orders varchar 100  √  null
object_type mis_fast_parties varchar 100  √  null
object_type mis_fast_po_lines varchar 100  √  null
object_type mis_fast_pos varchar 100  √  null
object_type mis_fast_products varchar 100  √  null
object_type mis_fast_purc_invoice_lines varchar 100  √  null
object_type mis_fast_purc_invoices varchar 100  √  null
object_type mis_fast_rec_note_lines varchar 100  √  null
object_type mis_fast_rec_notes varchar 100  √  null
object_type mis_fast_sale_invoice_lines varchar 100  √  null
object_type mis_fast_sale_invoices varchar 100  √  null
object_type mis_fast_vendors varchar 100  √  null
object_type mis_projects_view varchar 100  √  null
object_type mis_rec_note_lines_view varchar 100  √  null
object_type mis_sale_invoices_view varchar 100  √  null
object_type mis_vendors varchar 100  √  null
on_hand_qty mis_product_wh numeric 11,2  √  0
on_order_qty mis_product_wh numeric 11,2  √  0
option_code mis_bid_lines varchar 20  √  null
option_code mis_fast_bid_lines varchar 20  √  null
order_code mis_all_orders varchar 20  √  null
order_code mis_fast_delivery_notes varchar 20  √  null
order_code mis_fast_orders varchar 20  √  null
order_code mis_orders varchar 20  √  null
order_date mis_all_orders date 13  √  null
order_date mis_fast_delivery_notes date 13  √  null
order_date mis_fast_orders date 13  √  null
order_date mis_orders date 13  √  null
order_date_pretty mis_all_orders text 2147483647  √  null
order_date_pretty mis_fast_delivery_notes text 2147483647  √  null
order_date_pretty mis_fast_orders text 2147483647  √  null
order_date_widget mis_all_orders text 2147483647  √  null
order_date_widget mis_fast_delivery_notes text 2147483647  √  null
order_date_widget mis_fast_orders text 2147483647  √  null
order_id mis_all_orders int4 10  √  null
mis_orders.order_id Implied Constraint
order_id mis_contract_lines int4 10  √  null
mis_orders.order_id Implied Constraint
order_id mis_delivery_notes int4 10  √  null
mis_orders.order_id mis_delivery_notes_order_id_fkey
order_id mis_fast_delivery_notes int4 10  √  null
mis_orders.order_id Implied Constraint
order_id mis_fast_order_lines int4 10  √  null
mis_orders.order_id Implied Constraint
order_id mis_fast_orders int4 10  √  null
mis_orders.order_id Implied Constraint
order_id mis_order_lines int4 10  √  null
mis_orders.order_id mis_order_lines_order_id
order_id mis_orders int4 10
mis_all_orders.order_id Implied Constraint
mis_contract_lines.order_id Implied Constraint
mis_delivery_notes.order_id mis_delivery_notes_order_id_fkey
mis_fast_delivery_notes.order_id Implied Constraint
mis_fast_order_lines.order_id Implied Constraint
mis_fast_orders.order_id Implied Constraint
mis_order_lines.order_id mis_order_lines_order_id
acs_objects.object_id mis_orders_order_id_fkey
order_ref_no mis_all_orders varchar 20  √  null
order_ref_no mis_fast_orders varchar 20  √  null
order_ref_no mis_orders varchar 20  √  null
order_type mis_all_orders bpchar 1  √  null
order_type mis_fast_orders bpchar 1  √  null
order_type mis_orders bpchar 1  √  null
origin mis_delivery_notes bpchar 1  √  null
origin mis_fast_delivery_notes bpchar 1  √  null
original_author mis_scripts int4 10  √  null
users.user_id mis_scripts_fk1
package_id acs_objects int4 10  √  null
apm_packages.package_id acs_objects_package_id_fk
Which package instance this object belongs to.
Please note that in mid-term this column will replace all
package_ids of package specific tables.
package_id apm_packages int4 10
acs_objects.package_id acs_objects_package_id_fk
mis_accounts_view.package_id Implied Constraint
mis_active_products.package_id Implied Constraint
mis_all_orders.package_id Implied Constraint
mis_centers_view.package_id Implied Constraint
mis_contract_lines.package_id Implied Constraint
mis_customers.package_id Implied Constraint
mis_fast_bid_lines.package_id Implied Constraint
mis_fast_bids.package_id Implied Constraint
mis_fast_customers.package_id Implied Constraint
mis_fast_delivery_note_lines.package_id Implied Constraint
mis_fast_delivery_notes.package_id Implied Constraint
mis_fast_mr_lines.package_id Implied Constraint
mis_fast_mrs.package_id Implied Constraint
mis_fast_order_lines.package_id Implied Constraint
mis_fast_orders.package_id Implied Constraint
mis_fast_parties.package_id Implied Constraint
mis_fast_po_lines.package_id Implied Constraint
mis_fast_pos.package_id Implied Constraint
mis_fast_products.package_id Implied Constraint
mis_fast_purc_invoice_lines.package_id Implied Constraint
mis_fast_purc_invoices.package_id Implied Constraint
mis_fast_rec_note_lines.package_id Implied Constraint
mis_fast_rec_notes.package_id Implied Constraint
mis_fast_sale_invoice_lines.package_id Implied Constraint
mis_fast_sale_invoices.package_id Implied Constraint
mis_fast_vendors.package_id Implied Constraint
mis_projects_view.package_id Implied Constraint
mis_rec_note_lines_view.package_id Implied Constraint
mis_sale_invoices_view.package_id Implied Constraint
mis_vendors.package_id Implied Constraint
acs_objects.object_id apm_packages_package_id_fk
package_id mis_accounts_view int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_active_products int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_all_orders int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_centers_view int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_contract_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_customers int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_bid_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_bids int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_customers int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_delivery_note_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_delivery_notes int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_mr_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_mrs int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_order_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_orders int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_parties int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_po_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_pos int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_products int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_purc_invoice_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_purc_invoices int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_rec_note_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_rec_notes int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_sale_invoice_lines int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_sale_invoices int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_fast_vendors int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_projects_view int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_rec_note_lines_view int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_sale_invoices_view int4 10  √  null
apm_packages.package_id Implied Constraint
package_id mis_vendors int4 10  √  null
apm_packages.package_id Implied Constraint
package_key apm_package_types varchar 100
apm_packages.package_key apm_packages_package_key_fk
mis_packages.package_key Implied Constraint
The package_key is what we call the package on this system.
package_key apm_packages varchar 100  √  null
apm_package_types.package_key apm_packages_package_key_fk
package_key mis_packages varchar 100
apm_package_types.package_key Implied Constraint
package_name acs_object_types varchar 30
package_no mis_delivery_notes int4 10  √  null
package_no mis_fast_delivery_notes int4 10  √  null
package_no mis_fast_rec_notes int4 10  √  null
package_no mis_rec_notes int4 10  √  null
package_type apm_package_types varchar 300  √  null
package_uri apm_package_types varchar 1500 The package URI indicates where the package can be downloaded and
is a unique identifier for the package.
packaging_code mis_packagings varchar 200  √  null
packaging_description mis_packagings varchar 4000  √  null
packaging_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_packaging_id_fkey
packaging_id mis_fast_delivery_notes int4 10  √  null
packaging_id mis_fast_pos int4 10  √  null
packaging_id mis_fast_rec_notes int4 10  √  null
packaging_id mis_packagings int4 10  √  null
packaging_id mis_pos int4 10  √  null
categories.category_id mis_pos_fk_packaging_id
packaging_id mis_rec_notes int4 10  √  null
categories.category_id mis_rec_notes_packaging_id_fkey
page_no mis_print int4 10  √  null
parent_id categories int4 10  √  null
categories.category_id cat_parent_id_fk
Points to a parent category in the tree or null (if topmost category).
parent_id mis_acct_plan int4 10  √  null
mis_accounts.account_id mis_acct_plan_parent_id_fkey
party_channel mis_sap_parties bpchar 2  √  null
party_code mis_customers varchar 30  √  null
party_code mis_fast_customers varchar 30  √  null
party_code mis_fast_delivery_notes varchar 30  √  null
party_code mis_fast_parties varchar 30  √  null
party_code mis_fast_vendors varchar 30  √  null
party_code mis_parties varchar 30  √  null
party_code mis_sale_invoices_view varchar 30  √  null
party_code mis_vendors varchar 30  √  null
party_id mis_addresses int4 10
mis_parties.party_id mis_addresses_party_id_fkey
party_id mis_customers int4 10  √  null
mis_parties.party_id Implied Constraint
party_id mis_delivery_notes int4 10  √  null
mis_parties.party_id mis_delivery_notes_party_id_fkey
party_id mis_export_declarations int4 10
mis_parties.party_id mis_export_declarations_party_id_fkey
party_id mis_fast_customers int4 10  √  null
mis_parties.party_id Implied Constraint
party_id mis_fast_delivery_notes int4 10  √  null
mis_parties.party_id Implied Constraint
party_id mis_fast_parties int4 10  √  null
mis_parties.party_id Implied Constraint
party_id mis_fast_vendors int4 10  √  null
mis_parties.party_id Implied Constraint
party_id mis_parties 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_id mis_party_accounts int4 10
mis_parties.party_id mis_party_accounts_party_id_fkey
party_id mis_party_mod int4 10
acs_objects.object_id mis_party_mod_party_id_fkey
party_id mis_sap_parties int4 10  √  null
mis_parties.party_id mis_sap_parties_party_id_fkey
party_id mis_vendors int4 10  √  null
mis_parties.party_id Implied Constraint
party_id parties int4 10
persons.person_id persons_person_id_fk
acs_objects.object_id parties_party_id_fk
party_mod_id mis_party_mod int4 10
party_name mis_fast_delivery_notes varchar 1000  √  null
party_name mis_party_mod varchar 1000  √  null
party_name mis_sale_invoices_view varchar 1000  √  null
party_org mis_sap_parties bpchar 4  √  null
party_type mis_customers bpchar 1  √  null
party_type mis_fast_customers bpchar 1  √  null
party_type mis_fast_parties bpchar 1  √  null
party_type mis_fast_vendors bpchar 1  √  null
party_type mis_parties bpchar 1  √  null F=persona fisica G=persona giuridica
party_type mis_vendors bpchar 1  √  null
party_type_code mis_party_types varchar 200  √  null
party_type_description mis_party_types varchar 4000  √  null
party_type_id mis_customers int4 10  √  null
party_type_id mis_fast_customers int4 10  √  null
party_type_id mis_fast_parties int4 10  √  null
party_type_id mis_fast_vendors int4 10  √  null
party_type_id mis_parties int4 10  √  null
categories.category_id mis_parties_fk_party_type_id
tipi soggetto (terzista, grossista, dipendente, socio ecc.)
party_type_id mis_party_types int4 10  √  null
party_type_id mis_vendors int4 10  √  null
password users bpchar 40  √  null
password_answer users varchar 1000  √  null
password_changed_date users timestamptz 35,6  √  null
password_question users varchar 1000  √  null
pay_date mis_purc_paydates date 13
pay_date mis_purc_paydates_view date 13  √  null
pay_date_pretty mis_purc_paydates_view text 2147483647  √  null
payment_amount mis_customer_payments numeric 13,2  √  null
payment_amount mis_fast_customer_payments numeric 13,2  √  null
payment_amount mis_fast_purc_payments numeric 13,2  √  null
payment_amount mis_purc_payments numeric 13,2  √  null
payment_amount_pretty mis_fast_customer_payments varchar 2147483647  √  null
payment_amount_pretty mis_fast_purc_payments varchar 2147483647  √  null
payment_code mis_payments varchar 10  √  null
payment_date mis_customer_payments date 13
payment_date mis_fast_customer_payments date 13  √  null
payment_date mis_fast_purc_invoices date 13  √  null
payment_date mis_fast_purc_payments date 13  √  null
payment_date mis_purc_invoices date 13  √  null
payment_date mis_purc_payments date 13
payment_date_pretty mis_fast_customer_payments text 2147483647  √  null
payment_date_pretty mis_fast_purc_invoices text 2147483647  √  null
payment_date_pretty mis_fast_purc_payments text 2147483647  √  null
payment_date_widget mis_fast_customer_payments text 2147483647  √  null
payment_date_widget mis_fast_purc_invoices text 2147483647  √  null
payment_date_widget mis_fast_purc_payments text 2147483647  √  null
payment_days mis_projects int4 10  √  null
payment_days mis_projects_view int4 10  √  null
payment_description mis_payments varchar 50  √  null
payment_id mis_all_orders int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_bids int4 10  √  null
mis_payments.payment_id mis_bids_fk_payment_id
payment_id mis_customer_payments int4 10
mis_customer_payments.ref_payment_id mis_customer_payments_ref_payment_id_fkey
mis_effects.payment_id mis_effects_payment_id_fkey
mis_payments.payment_id Implied Constraint
payment_id mis_customers int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_delivery_notes int4 10  √  null
mis_payments.payment_id mis_delivery_notes_payment_id_fkey
payment_id mis_effects int4 10
mis_customer_payments.payment_id mis_effects_payment_id_fkey
payment_id mis_fast_bids int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_customer_payments int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_customers int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_delivery_notes int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_orders int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_parties int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_pos int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_purc_invoices int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_rec_notes int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_sale_invoices int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_fast_vendors int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_orders int4 10  √  null
mis_payments.payment_id mis_orders_fk_payment_id
payment_id mis_parties int4 10  √  null
mis_payments.payment_id mis_parties_fk_payment_id
payment_id mis_payment_terms int4 10
mis_payments.payment_id mis_payment_terms_payment_id_fkey
payment_id mis_payments int4 10
mis_all_orders.payment_id Implied Constraint
mis_bids.payment_id mis_bids_fk_payment_id
mis_customer_payments.payment_id Implied Constraint
mis_customers.payment_id Implied Constraint
mis_delivery_notes.payment_id mis_delivery_notes_payment_id_fkey
mis_fast_bids.payment_id Implied Constraint
mis_fast_customer_payments.payment_id Implied Constraint
mis_fast_customers.payment_id Implied Constraint
mis_fast_delivery_notes.payment_id Implied Constraint
mis_fast_orders.payment_id Implied Constraint
mis_fast_parties.payment_id Implied Constraint
mis_fast_pos.payment_id Implied Constraint
mis_fast_purc_invoices.payment_id Implied Constraint
mis_fast_rec_notes.payment_id Implied Constraint
mis_fast_sale_invoices.payment_id Implied Constraint
mis_fast_vendors.payment_id Implied Constraint
mis_orders.payment_id mis_orders_fk_payment_id
mis_parties.payment_id mis_parties_fk_payment_id
mis_payment_terms.payment_id mis_payment_terms_payment_id_fkey
mis_pos.payment_id mis_pos_fk_payment_id
mis_purc_invoices.payment_id mis_purc_invoices_payment_id_fkey
mis_purc_paydates_view.payment_id Implied Constraint
mis_rec_notes.payment_id mis_rec_notes_payment_id_fkey
mis_sale_invoices.payment_id mis_sale_invoices_payment_id_fkey
mis_sale_invoices_view.payment_id Implied Constraint
mis_vendors.payment_id Implied Constraint
payment_id mis_pos int4 10  √  null
mis_payments.payment_id mis_pos_fk_payment_id
payment_id mis_purc_invoices int4 10  √  null
mis_payments.payment_id mis_purc_invoices_payment_id_fkey
payment_id mis_purc_paydates_view int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_rec_notes int4 10  √  null
mis_payments.payment_id mis_rec_notes_payment_id_fkey
payment_id mis_sale_invoices int4 10  √  null
mis_payments.payment_id mis_sale_invoices_payment_id_fkey
payment_id mis_sale_invoices_view int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_id mis_vendors int4 10  √  null
mis_payments.payment_id Implied Constraint
payment_term_days mis_payment_terms varchar 50  √  null
payment_term_id mis_payment_terms int4 10
payment_term_seq mis_payment_terms int4 10  √  null
payment_type_code mis_payment_types varchar 10  √  null
payment_type_description mis_payment_types varchar 50  √  null
payment_type_id mis_customer_payments int4 10  √  null
mis_payment_types.payment_type_id mis_customer_payments_payment_type_id_fkey
payment_type_id mis_fast_customer_payments int4 10  √  null
mis_payment_types.payment_type_id Implied Constraint
payment_type_id mis_payment_types int4 10
mis_customer_payments.payment_type_id mis_customer_payments_payment_type_id_fkey
mis_fast_customer_payments.payment_type_id Implied Constraint
mis_payments.payment_type_id mis_payments_payment_type_id_fkey
mis_sale_paydates.payment_type_id mis_sale_paydates_payment_type_id_fkey
mis_sale_paydates_view.payment_type_id Implied Constraint
payment_type_id mis_payments int4 10
mis_payment_types.payment_type_id mis_payments_payment_type_id_fkey
payment_type_id mis_sale_paydates int4 10  √  null
mis_payment_types.payment_type_id mis_sale_paydates_payment_type_id_fkey
payment_type_id mis_sale_paydates_view int4 10  √  null
mis_payment_types.payment_type_id Implied Constraint
perc_indet mis_fast_purc_iva float8 17,17  √  null
perc_indet mis_fast_sale_iva float8 17,17  √  null
perc_indet mis_iva float8 17,17  √  null
perc_indet_pretty mis_fast_purc_iva varchar 2147483647  √  null
perc_indet_pretty mis_fast_sale_iva varchar 2147483647  √  null
person_id persons int4 10
users.user_id users_user_id_fk
parties.party_id persons_person_id_fk
phone mis_addresses varchar 35  √  null
phone mis_customers varchar 35  √  null
phone mis_fast_customers varchar 35  √  null
phone mis_fast_parties varchar 35  √  null
phone mis_fast_vendors varchar 35  √  null
phone mis_vendors varchar 35  √  null
plant_code mis_plants varchar 10  √  null
plant_code mis_plants_t varchar 10  √  null
plant_description mis_plants text 2147483647  √  null
plant_description mis_plants_t text 2147483647  √  null
plant_id mis_plants int4 10
mis_plants_t.plant_id Implied Constraint
mis_product_wh.plant_id mis_product_wh_plant_id_fkey
mis_stores.plant_id mis_stores_plant_id_fkey
mis_user_preferences.plant_id Implied Constraint
plant_id mis_plants_t int4 10  √  null
mis_plants.plant_id Implied Constraint
plant_id mis_product_wh int4 10
mis_plants.plant_id mis_product_wh_plant_id_fkey
plant_id mis_stores int4 10  √  null
mis_plants.plant_id mis_stores_plant_id_fkey
plant_id mis_user_preferences int4 10  √  null
mis_plants.plant_id Implied Constraint
plant_type mis_plants varchar 3  √  null
plant_type mis_plants_t varchar 3  √  null
po_code mis_fast_pos varchar 20  √  null
po_code mis_fast_rec_notes varchar 20  √  null
po_code mis_pos varchar 20
po_date mis_fast_pos date 13  √  null
po_date mis_fast_rec_notes date 13  √  null
po_date mis_pos date 13
po_date_pretty mis_fast_pos text 2147483647  √  null
po_date_pretty mis_fast_rec_notes text 2147483647  √  null
po_date_widget mis_fast_pos text 2147483647  √  null
po_date_widget mis_fast_rec_notes text 2147483647  √  null
po_id mis_fast_po_lines int4 10  √  null
mis_pos.po_id Implied Constraint
po_id mis_fast_pos int4 10  √  null
mis_pos.po_id Implied Constraint
po_id mis_fast_rec_notes int4 10  √  null
mis_pos.po_id Implied Constraint
po_id mis_po_lines int4 10
mis_pos.po_id mis_po_lines_po_id_fk
po_id mis_pos int4 10
mis_fast_po_lines.po_id Implied Constraint
mis_fast_pos.po_id Implied Constraint
mis_fast_rec_notes.po_id Implied Constraint
mis_po_lines.po_id mis_po_lines_po_id_fk
mis_rec_notes.po_id mis_rec_notes_po_id_fkey
acs_objects.object_id mis_pos_po_id_fk
po_id mis_rec_notes int4 10  √  null
mis_pos.po_id mis_rec_notes_po_id_fkey
po_line_id mis_fast_rec_note_lines int4 10  √  null
po_line_id mis_rec_note_lines int4 10  √  null
mis_po_lines.line_id mis_rec_note_lines_po_line_id_fkey
po_line_id mis_rec_note_lines_view int4 10  √  null
po_type mis_fast_pos varchar 3  √  null
po_type mis_pos varchar 3 PO=Purchase Order RDO=Richiesta D'Offerta
port_code mis_ports varchar 200  √  null
port_description mis_ports varchar 4000  √  null
port_id mis_all_orders int4 10  √  null
port_id mis_bids int4 10  √  null
categories.category_id mis_bids_fk_port_id
port_id mis_customers int4 10  √  null
port_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_port_id_fkey
port_id mis_fast_bids int4 10  √  null
port_id mis_fast_customers int4 10  √  null
port_id mis_fast_delivery_notes int4 10  √  null
port_id mis_fast_orders int4 10  √  null
port_id mis_fast_parties int4 10  √  null
port_id mis_fast_pos int4 10  √  null
port_id mis_fast_rec_notes int4 10  √  null
port_id mis_fast_vendors int4 10  √  null
port_id mis_orders int4 10  √  null
categories.category_id mis_orders_fk_port_id
port_id mis_parties int4 10  √  null
categories.category_id mis_parties_fk_port_id
port_id mis_ports int4 10  √  null
port_id mis_pos int4 10  √  null
categories.category_id mis_pos_fk_port_id
port_id mis_rec_notes int4 10  √  null
categories.category_id mis_rec_notes_port_id_fkey
port_id mis_vendors int4 10  √  null
prec_credit_amount mis_acct_iva numeric 13,2  √  null
pres_account_id mis_bank_accounts int4 10  √  null
mis_accounts.account_id mis_bank_accounts_pres_account_id_fkey
pres_account_id mis_banks_view int4 10  √  null
presentation_bank_id mis_customer_payments int4 10  √  null
mis_banks.bank_id mis_customer_payments_presentation_bank_id_fkey
presentation_bank_id mis_fast_customer_payments int4 10  √  null
presentation_date mis_customer_payments date 13  √  null
presentation_date mis_effects date 13
presentation_date mis_fast_customer_payments date 13  √  null
presentation_date_pretty mis_fast_customer_payments text 2147483647  √  null
presentation_date_widget mis_fast_customer_payments text 2147483647  √  null
pretty_name acs_object_types varchar 1000
pretty_name apm_package_types varchar 100
pretty_name auth_authorities varchar 4000  √  null
pretty_plural acs_object_types varchar 1000
pretty_plural apm_package_types varchar 100  √  null
price_id mis_purc_list_prices int4 10
mis_purc_prices.price_id Implied Constraint
mis_purc_products_with_prices.price_id Implied Constraint
price_id mis_purc_prices int4 10  √  null
mis_purc_list_prices.price_id Implied Constraint
price_id mis_purc_products_with_prices int4 10  √  null
mis_purc_list_prices.price_id Implied Constraint
price_list_id mis_cust_price_map int4 10  √  null
mis_purc_price_lists.price_list_id mis_cust_price_map_price_list_id_fkey
price_list_id mis_purc_list_prices int4 10
mis_purc_price_lists.price_list_id mis_purc_list_prices_price_list_id_fkey
price_list_id mis_purc_price_lists int4 10
mis_cust_price_map.price_list_id mis_cust_price_map_price_list_id_fkey
mis_purc_list_prices.price_list_id mis_purc_list_prices_price_list_id_fkey
mis_purc_prices.price_list_id Implied Constraint
mis_purc_products_with_prices.price_list_id Implied Constraint
price_list_id mis_purc_prices int4 10  √  null
mis_purc_price_lists.price_list_id Implied Constraint
price_list_id mis_purc_products_with_prices int4 10  √  null
mis_purc_price_lists.price_list_id Implied Constraint
price_list_name mis_purc_price_lists varchar 60
price_list_name mis_purc_prices varchar 60  √  null
price_list_name mis_purc_products_with_prices varchar 60  √  null
priv_email users int4 10 5
priv_name users int4 10 0
process_doc_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_procdoc_impl_fk
product_category_code mis_product_categories varchar 20  √  null
product_category_description mis_product_categories text 2147483647  √  null
product_category_id mis_product_categories int4 10
mis_products.category_id mis_products_fk_category
product_code mis_active_products varchar 40  √  null
product_code mis_customers_products_map varchar 50  √  null
product_code mis_fast_delivery_note_lines varchar 40  √  null
product_code mis_fast_products varchar 40  √  null
product_code mis_fast_rec_note_lines varchar 40  √  null
product_code mis_products varchar 40  √  null
product_code mis_purc_prices varchar 40  √  null
product_code mis_purc_products_with_prices varchar 40  √  null
product_code mis_quotations_view varchar 40  √  null
product_code mis_rec_note_lines_view varchar 40  √  null
product_code mis_vendors_products_map varchar 50  √  null
product_description mis_delivery_note_lines text 2147483647  √  null
product_description mis_fast_delivery_note_lines text 2147483647  √  null
product_description mis_purc_prices varchar 1000  √  null
product_description mis_purc_products_with_prices varchar 1000  √  null
product_description mis_quotations_view varchar 1000  √  null
product_id mis_active_products int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_bid_lines int4 10
mis_products.product_id mis_bid_lines_product_id
product_id mis_contract_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_customers_products_map int4 10  √  null
mis_products.product_id mis_customers_products_map_product_id_fkey
product_id mis_delivery_note_lines int4 10
mis_products.product_id mis_delivery_note_lines_product_id_fkey
product_id mis_fast_bid_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_delivery_note_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_mr_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_order_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_po_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_products int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_purc_invoice_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_rec_note_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_fast_sale_invoice_lines int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_mr_lines int4 10
mis_products.product_id mis_mr_lines_product_id_fk
product_id mis_order_lines int4 10  √  null
mis_products.product_id mis_order_lines_product_id
product_id mis_po_lines int4 10
mis_products.product_id mis_po_lines_product_id_fk
product_id mis_product_lots int4 10
mis_products.product_id mis_product_lots_product_id_fkey
product_id mis_product_wh int4 10
mis_products.product_id mis_product_wh_product_id_fkey
product_id mis_products int4 10
mis_active_products.product_id Implied Constraint
mis_bid_lines.product_id mis_bid_lines_product_id
mis_contract_lines.product_id Implied Constraint
mis_customers_products_map.product_id mis_customers_products_map_product_id_fkey
mis_delivery_note_lines.product_id mis_delivery_note_lines_product_id_fkey
mis_fast_bid_lines.product_id Implied Constraint
mis_fast_delivery_note_lines.product_id Implied Constraint
mis_fast_mr_lines.product_id Implied Constraint
mis_fast_order_lines.product_id Implied Constraint
mis_fast_po_lines.product_id Implied Constraint
mis_fast_products.product_id Implied Constraint
mis_fast_purc_invoice_lines.product_id Implied Constraint
mis_fast_rec_note_lines.product_id Implied Constraint
mis_fast_sale_invoice_lines.product_id Implied Constraint
mis_inventories.inv_product_id mis_inventories_inv_product_id_fkey
mis_mr_lines.product_id mis_mr_lines_product_id_fk
mis_order_lines.product_id mis_order_lines_product_id
mis_po_lines.product_id mis_po_lines_product_id_fk
mis_product_lots.product_id mis_product_lots_product_id_fkey
mis_product_wh.product_id mis_product_wh_product_id_fkey
mis_purc_invoice_lines.product_id mis_purc_invoice_lines_product_id_fkey
mis_purc_list_prices.product_id mis_purc_list_prices_product_id_fkey
mis_purc_prices.product_id Implied Constraint
mis_purc_products_with_prices.product_id Implied Constraint
mis_quotations.product_id mis_quotations_product_id_fkey
mis_quotations_view.product_id Implied Constraint
mis_rec_note_lines.product_id mis_rec_note_lines_product_id_fkey
mis_rec_note_lines_view.product_id Implied Constraint
mis_sale_invoice_lines.product_id mis_sale_invoice_lines_product_id_fkey
mis_vendors_products_map.product_id mis_vendors_products_map_product_id_fkey
mis_wh_mov.wh_mov_product_id mis_wh_mov_wh_mov_product_id_fkey
acs_objects.object_id mis_products_product_id_fkey
product_id mis_purc_invoice_lines int4 10  √  null
mis_products.product_id mis_purc_invoice_lines_product_id_fkey
product_id mis_purc_list_prices int4 10
mis_products.product_id mis_purc_list_prices_product_id_fkey
product_id mis_purc_prices int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_purc_products_with_prices int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_quotations int4 10
mis_products.product_id mis_quotations_product_id_fkey
product_id mis_quotations_view int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_rec_note_lines int4 10
mis_products.product_id mis_rec_note_lines_product_id_fkey
product_id mis_rec_note_lines_view int4 10  √  null
mis_products.product_id Implied Constraint
product_id mis_sale_invoice_lines int4 10  √  null
mis_products.product_id mis_sale_invoice_lines_product_id_fkey
product_id mis_vendors_products_map int4 10  √  null
mis_products.product_id mis_vendors_products_map_product_id_fkey
product_image mis_active_products oid 10  √  null
product_image mis_fast_products oid 10  √  null
product_image mis_products oid 10  √  null
product_name mis_fast_delivery_note_lines varchar 1000  √  null
product_name mis_fast_rec_note_lines varchar 1000  √  null
product_name mis_rec_note_lines_view varchar 1000  √  null
product_net_price mis_contract_lines numeric 131089  √  null
product_net_price mis_fast_bid_lines numeric 131089  √  null
product_net_price mis_fast_delivery_note_lines numeric 131089  √  null
product_net_price mis_fast_order_lines numeric 131089  √  null
product_net_price mis_fast_po_lines numeric 131089  √  null
product_net_price mis_fast_purc_invoice_lines numeric 131089  √  null
product_net_price mis_fast_rec_note_lines numeric 131089  √  null
product_net_price mis_fast_sale_invoice_lines numeric 131089  √  null
product_net_price mis_quotations_view numeric 131089  √  null
product_net_price mis_rec_note_lines_view numeric 131089  √  null
product_net_price_pretty mis_contract_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_bid_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_order_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_po_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
product_net_price_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
product_net_price_pretty mis_quotations_view varchar 2147483647  √  null
product_net_price_pretty mis_rec_note_lines_view varchar 2147483647  √  null
product_price mis_bid_lines numeric 17,5
product_price mis_contract_lines numeric 17,5  √  null
product_price mis_delivery_note_lines numeric 17,5  √  null
product_price mis_fast_bid_lines numeric 17,5  √  null
product_price mis_fast_delivery_note_lines numeric 17,5  √  null
product_price mis_fast_order_lines numeric 17,5  √  null
product_price mis_fast_po_lines numeric 17,5  √  null
product_price mis_fast_purc_invoice_lines numeric 17,5  √  null
product_price mis_fast_rec_note_lines numeric 17,5  √  null
product_price mis_fast_sale_invoice_lines numeric 17,5  √  null
product_price mis_order_lines numeric 17,5 0
product_price mis_po_lines numeric 17,5
product_price mis_purc_invoice_lines numeric 17,5  √  null
product_price mis_quotations numeric 17,5  √  null
product_price mis_quotations_view numeric 17,5  √  null
product_price mis_rec_note_lines numeric 17,5  √  null
product_price mis_rec_note_lines_view numeric 17,5  √  null
product_price mis_sale_invoice_lines numeric 17,5  √  null
product_price_pretty mis_contract_lines varchar 2147483647  √  null
product_price_pretty mis_fast_bid_lines varchar 2147483647  √  null
product_price_pretty mis_fast_delivery_note_lines varchar 2147483647  √  null
product_price_pretty mis_fast_order_lines varchar 2147483647  √  null
product_price_pretty mis_fast_po_lines varchar 2147483647  √  null
product_price_pretty mis_fast_purc_invoice_lines varchar 2147483647  √  null
product_price_pretty mis_fast_rec_note_lines varchar 2147483647  √  null
product_price_pretty mis_fast_sale_invoice_lines varchar 2147483647  √  null
product_price_pretty mis_quotations_view varchar 2147483647  √  null
product_price_pretty mis_rec_note_lines_view varchar 2147483647  √  null
project_code mis_projects_view varchar 30  √  null
project_description mis_projects_view varchar 50  √  null
project_id mis_all_orders int4 10  √  null
mis_projects.project_id Implied Constraint
project_id mis_bids int4 10  √  null
mis_projects.project_id Implied Constraint
project_id mis_fast_bids int4 10  √  null
mis_projects.project_id Implied Constraint
project_id mis_fast_orders int4 10  √  null
mis_projects.project_id Implied Constraint
project_id mis_orders int4 10  √  null
mis_projects.project_id mis_orders_project_id_fk
project_id mis_projects int4 10
mis_all_orders.project_id Implied Constraint
mis_bids.project_id Implied Constraint
mis_fast_bids.project_id Implied Constraint
mis_fast_orders.project_id Implied Constraint
mis_orders.project_id mis_orders_project_id_fk
mis_projects_view.project_id Implied Constraint
mis_accounts.account_id mis_projects_project_id_fkey
project_id mis_projects_view int4 10  √  null
mis_projects.project_id Implied Constraint
project_type mis_projects bpchar 1 T=Tariffa C=Corpo
project_type mis_projects_view bpchar 1  √  null
province mis_addresses varchar 4  √  null
province mis_customers varchar 4  √  null
province mis_fast_customers varchar 4  √  null
province mis_fast_parties varchar 4  √  null
province mis_fast_vendors varchar 4  √  null
province mis_vendors varchar 4  √  null
purc_base_price mis_purc_list_prices numeric 17,5
purc_base_price mis_purc_prices numeric 17,5  √  null
purc_base_price mis_purc_products_with_prices numeric 17,5  √  null
purc_base_price_pretty mis_purc_prices varchar 2147483647  √  null
purc_base_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
purc_invoice_id mis_fast_purc_invoice_lines int4 10  √  null
mis_purc_invoices.purc_invoice_id Implied Constraint
purc_invoice_id mis_fast_purc_invoices int4 10  √  null
mis_purc_invoices.purc_invoice_id Implied Constraint
purc_invoice_id mis_fast_purc_iva int4 10  √  null
mis_purc_invoices.purc_invoice_id Implied Constraint
purc_invoice_id mis_purc_invoice_lines int4 10
mis_purc_invoices.purc_invoice_id mis_purc_invoice_lines_purc_invoice_id_fkey
purc_invoice_id mis_purc_invoices 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
purc_invoice_id mis_purc_iva int4 10
mis_purc_invoices.purc_invoice_id mis_purc_iva_purc_invoice_id_fkey
purc_invoice_id mis_purc_paydates int4 10
mis_purc_invoices.purc_invoice_id mis_purc_paydates_purc_invoice_id_fkey
purc_invoice_id mis_purc_paydates_view int4 10  √  null
mis_purc_invoices.purc_invoice_id Implied Constraint
purc_invoice_line_id mis_fast_purc_invoice_lines int4 10  √  null
mis_purc_invoice_lines.purc_invoice_line_id Implied Constraint
purc_invoice_line_id mis_purc_invoice_lines int4 10
mis_fast_purc_invoice_lines.purc_invoice_line_id Implied Constraint
acs_objects.object_id mis_purc_invoice_lines_purc_invoice_line_id_fkey
purc_invoice_ref_id mis_fast_purc_invoices int4 10  √  null
purc_invoice_ref_id mis_purc_invoices 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.
purc_invoice_seq mis_fast_purc_invoice_lines int4 10  √  null
purc_invoice_seq mis_purc_invoice_lines int4 10  √  null
purc_iva_id mis_fast_purc_iva int4 10  √  null
mis_purc_iva.purc_iva_id Implied Constraint
purc_iva_id mis_purc_iva int4 10
mis_fast_purc_iva.purc_iva_id Implied Constraint
purc_net_calc_price mis_purc_prices numeric 131089  √  null
purc_net_calc_price mis_purc_products_with_prices numeric 131089  √  null
purc_net_calc_price_pretty mis_purc_prices varchar 2147483647  √  null
purc_net_calc_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
purc_net_price mis_purc_list_prices numeric 17,5  √  null Se digitato prescinde dagli sconti d'acquisto e prevale sul prezzo netto calcolato in base a questi.
purc_net_price mis_purc_prices numeric 17,5  √  null
purc_net_price mis_purc_products_with_prices numeric 17,5  √  null
purc_net_price_pretty mis_purc_prices varchar 2147483647  √  null
purc_net_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
purc_paydate_id mis_fast_purc_payments int4 10  √  null
mis_purc_paydates.purc_paydate_id Implied Constraint
purc_paydate_id mis_purc_paydates int4 10
mis_fast_purc_payments.purc_paydate_id Implied Constraint
mis_purc_paydates_view.purc_paydate_id Implied Constraint
mis_purc_payments.purc_paydate_id mis_purc_payments_purc_paydate_id_fkey
purc_paydate_id mis_purc_paydates_view int4 10  √  null
mis_purc_paydates.purc_paydate_id Implied Constraint
purc_paydate_id mis_purc_payments int4 10
mis_purc_paydates.purc_paydate_id mis_purc_payments_purc_paydate_id_fkey
purc_payment_id mis_fast_purc_payments int4 10  √  null
mis_purc_payments.purc_payment_id Implied Constraint
purc_payment_id mis_purc_payments int4 10
mis_fast_purc_payments.purc_payment_id Implied Constraint
purc_um_code mis_fast_purc_invoice_lines varchar 2147483647  √  null
purc_um_code mis_fast_rec_note_lines varchar 2147483647  √  null
purc_um_code mis_purc_prices varchar 2147483647  √  null
purc_um_code mis_purc_products_with_prices varchar 2147483647  √  null
purc_um_code mis_quotations_view varchar 2147483647  √  null
purc_um_code mis_rec_note_lines_view varchar 2147483647  √  null
purc_um_id mis_fast_po_lines int4 10  √  null
purc_um_id mis_fast_purc_invoice_lines int4 10  √  null
purc_um_id mis_fast_rec_note_lines int4 10  √  null
purc_um_id mis_po_lines int4 10
mis_um.um_id mis_po_lines_purc_um_id_fk
UM d'acquisto.
purc_um_id mis_purc_invoice_lines int4 10
mis_um.um_id mis_purc_invoice_lines_purc_um_id_fkey
purc_um_id mis_purc_list_prices int4 10
mis_um.um_id mis_purc_list_prices_purc_um_id_fkey
purc_um_id mis_purc_prices int4 10  √  null
purc_um_id mis_purc_products_with_prices int4 10  √  null
purc_um_id mis_quotations int4 10
mis_um.um_id mis_quotations_purc_um_id_fkey
purc_um_id mis_quotations_view int4 10  √  null
purc_um_id mis_rec_note_lines int4 10  √  null
mis_um.um_id mis_rec_note_lines_purc_um_id_fkey
purc_um_id mis_rec_note_lines_view int4 10  √  null
purcs_pages mis_acct_iva int4 10  √  null
pwd_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_pwd_impl_fk
qty_delivered mis_contract_lines numeric 11,2  √  null
qty_delivered mis_fast_order_lines numeric 11,2  √  null
qty_delivered mis_fast_po_lines numeric 11,2  √  null
qty_delivered mis_order_lines numeric 11,2  √  0
qty_delivered mis_po_lines numeric 11,2
qty_delivered_pretty mis_contract_lines varchar 2147483647  √  null
qty_delivered_pretty mis_fast_order_lines varchar 2147483647  √  null
qty_delivered_pretty mis_fast_po_lines varchar 2147483647  √  null
qty_on_order mis_fast_po_lines numeric 11,2  √  null
qty_on_order mis_po_lines numeric 11,2
qty_on_order_pretty mis_fast_po_lines varchar 2147483647  √  null
qty_ordered mis_bid_lines numeric 11,2
qty_ordered mis_contract_lines numeric 11,2  √  null
qty_ordered mis_fast_bid_lines numeric 11,2  √  null
qty_ordered mis_fast_order_lines numeric 11,2  √  null
qty_ordered mis_fast_po_lines numeric 11,2  √  null
qty_ordered mis_order_lines numeric 11,2
qty_ordered mis_po_lines numeric 11,2
qty_ordered_pretty mis_contract_lines varchar 2147483647  √  null
qty_ordered_pretty mis_fast_bid_lines varchar 2147483647  √  null
qty_ordered_pretty mis_fast_order_lines varchar 2147483647  √  null
qty_ordered_pretty mis_fast_po_lines varchar 2147483647  √  null
qty_requested mis_fast_mr_lines numeric 11,2  √  null
qty_requested mis_mr_lines numeric 11,2
qty_requested_pretty mis_fast_mr_lines varchar 2147483647  √  null
qty_reserved mis_contract_lines numeric 11,2  √  null
qty_reserved mis_fast_order_lines numeric 11,2  √  null
qty_reserved mis_order_lines numeric 11,2  √  0
qty_reserved_pretty mis_contract_lines varchar 2147483647  √  null
qty_reserved_pretty mis_fast_order_lines varchar 2147483647  √  null
qty_to_deliver mis_fast_po_lines numeric 131089  √  null
qty_to_deliver_pretty mis_fast_po_lines varchar 2147483647  √  null
query_args mis_monitoring varchar 500  √  null
quotation_id mis_quotations int4 10
mis_quotations_view.quotation_id Implied Constraint
quotation_id mis_quotations_view int4 10  √  null
mis_quotations.quotation_id Implied Constraint
ra_amount mis_fast_purc_invoices numeric 13,2  √  null
ra_amount mis_purc_invoices numeric 13,2  √  null
ra_amount mis_purc_paydates_view numeric 131089  √  null
ra_amount_pretty mis_fast_purc_invoices varchar 2147483647  √  null
raw_material_store_id mis_plants int4 10  √  null
mis_stores.store_id mis_plants_fk_raw_material_store_id
Magazzino materie prime di default per questo plant.
real_amount mis_purc_paydates_view numeric 13,2  √  null
real_amount mis_sale_paydates_view numeric 13,2  √  null
real_amount_paid mis_sale_paydates_view numeric 13,2  √  null
real_amount_paid_pretty mis_sale_paydates_view varchar 2147483647  √  null
real_amount_pretty mis_purc_paydates_view varchar 2147483647  √  null
real_amount_pretty mis_sale_paydates_view varchar 2147483647  √  null
real_invoice_amount mis_purc_paydates_view numeric 13,2  √  null
real_invoice_amount mis_sale_paydates_view numeric 13,2  √  null
real_invoice_amount_pretty mis_purc_paydates_view varchar 2147483647  √  null
real_invoice_amount_pretty mis_sale_paydates_view varchar 2147483647  √  null
real_ra_amount mis_purc_paydates_view numeric 13,2  √  null
rec_code mis_fast_rec_note_lines varchar 10  √  null
rec_code mis_fast_rec_notes varchar 10  √  null
rec_code mis_rec_notes varchar 10  √  null
rec_date mis_fast_rec_note_lines date 13  √  null
rec_date mis_fast_rec_notes date 13  √  null
rec_date mis_rec_notes date 13
rec_date_pretty mis_fast_rec_note_lines text 2147483647  √  null
rec_date_pretty mis_fast_rec_notes text 2147483647  √  null
rec_date_widget mis_fast_rec_notes text 2147483647  √  null
rec_id mis_fast_rec_note_lines int4 10  √  null
mis_rec_notes.rec_id Implied Constraint
rec_id mis_fast_rec_notes int4 10  √  null
mis_rec_notes.rec_id Implied Constraint
rec_id mis_rec_note_lines int4 10
mis_rec_notes.rec_id mis_rec_note_lines_rec_id_fkey
rec_id mis_rec_note_lines_view int4 10  √  null
mis_rec_notes.rec_id Implied Constraint
rec_id mis_rec_notes int4 10
mis_fast_rec_note_lines.rec_id Implied Constraint
mis_fast_rec_notes.rec_id Implied Constraint
mis_rec_note_lines.rec_id mis_rec_note_lines_rec_id_fkey
mis_rec_note_lines_view.rec_id Implied Constraint
acs_objects.object_id mis_rec_notes_rec_id_fkey
rec_line_id mis_fast_purc_invoice_lines int4 10  √  null
mis_rec_note_lines.rec_line_id Implied Constraint
rec_line_id mis_fast_rec_note_lines int4 10  √  null
mis_rec_note_lines.rec_line_id Implied Constraint
rec_line_id mis_purc_invoice_lines int4 10  √  null
mis_rec_note_lines.rec_line_id mis_purc_invoice_lines_rec_line_id_fkey
rec_line_id mis_rec_note_lines int4 10
mis_fast_purc_invoice_lines.rec_line_id Implied Constraint
mis_fast_rec_note_lines.rec_line_id Implied Constraint
mis_purc_invoice_lines.rec_line_id mis_purc_invoice_lines_rec_line_id_fkey
mis_rec_note_lines_view.rec_line_id Implied Constraint
acs_objects.object_id mis_rec_note_lines_rec_line_id_fkey
rec_line_id mis_rec_note_lines_view int4 10  √  null
mis_rec_note_lines.rec_line_id Implied Constraint
rec_text mis_fast_rec_notes text 2147483647  √  null
rec_text mis_rec_notes text 2147483647  √  null
rec_type mis_fast_rec_notes varchar 8  √  null
rec_type mis_rec_notes varchar 8  √  null generic = BEM generata da ricevimento ordine
vendor = BEM manuale
ref_payment_id mis_customer_payments int4 10  √  null
mis_customer_payments.payment_id mis_customer_payments_ref_payment_id_fkey
ref_payment_id mis_fast_customer_payments int4 10  √  null
reference_id mis_delivery_note_lines int4 10  √  null
acs_objects.object_id mis_delivery_note_lines_reference_id_fkey
reference_id mis_fast_delivery_note_lines int4 10  √  null
register_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_reg_impl_fk
register_url auth_authorities varchar 4000  √  null
required_by mis_fast_mrs varchar 50  √  null
required_by mis_mrs varchar 50  √  null
reserved_qty mis_product_wh numeric 11,2  √  0
result mis_bids bpchar 1  √  null
result mis_fast_bids bpchar 1  √  null
right_ind categories int4 10  √  null Right index in nested set structure of a tree.
rows_per_page mis_user_preferences int4 10  √  null
sale_base_price mis_purc_list_prices numeric 17,5 Prezzo di vendita raccomandato.
sale_base_price mis_purc_prices numeric 17,5  √  null
sale_base_price mis_purc_products_with_prices numeric 17,5  √  null
sale_base_price_pretty mis_purc_prices varchar 2147483647  √  null
sale_base_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
sale_discount mis_cust_price_map numeric 5,2  √  null
sale_discount_2 mis_cust_price_map numeric 5,2  √  null
sale_discount_3 mis_cust_price_map numeric 5,2  √  null
sale_invoice_id mis_delivery_notes int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_fast_delivery_notes int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_fast_sale_invoice_lines int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_fast_sale_invoices int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_fast_sale_iva int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_sale_invoice_lines int4 10
mis_sale_invoices.sale_invoice_id mis_sale_invoice_lines_sale_invoice_id_fkey
sale_invoice_id mis_sale_invoices int4 10
mis_customer_dates.invoice_id mis_customer_dates_invoice_id_fkey
mis_delivery_notes.sale_invoice_id Implied Constraint
mis_fast_delivery_notes.sale_invoice_id Implied Constraint
mis_fast_sale_invoice_lines.sale_invoice_id Implied Constraint
mis_fast_sale_invoices.sale_invoice_id Implied Constraint
mis_fast_sale_iva.sale_invoice_id Implied Constraint
mis_sale_invoice_lines.sale_invoice_id mis_sale_invoice_lines_sale_invoice_id_fkey
mis_sale_invoices.sale_invoice_ref_id mis_sale_invoices_sale_invoice_ref_id_fkey
mis_sale_invoices_view.sale_invoice_id Implied Constraint
mis_sale_iva.sale_invoice_id mis_sale_iva_sale_invoice_id_fkey
mis_sale_paydates.invoice_id mis_sale_paydates_invoice_id_fkey
acs_objects.object_id mis_sale_invoices_sale_invoice_id_fkey
sale_invoice_id mis_sale_invoices_view int4 10  √  null
mis_sale_invoices.sale_invoice_id Implied Constraint
sale_invoice_id mis_sale_iva int4 10
mis_sale_invoices.sale_invoice_id mis_sale_iva_sale_invoice_id_fkey
sale_invoice_line_id mis_fast_sale_invoice_lines int4 10  √  null
mis_sale_invoice_lines.sale_invoice_line_id Implied Constraint
sale_invoice_line_id mis_sale_invoice_lines int4 10
mis_fast_sale_invoice_lines.sale_invoice_line_id Implied Constraint
acs_objects.object_id mis_sale_invoice_lines_sale_invoice_line_id_fkey
sale_invoice_ref_id mis_fast_purc_invoices int4 10  √  null
sale_invoice_ref_id mis_fast_sale_invoices int4 10  √  null
sale_invoice_ref_id mis_purc_invoices int4 10  √  null Riferimento alla fattura di vendita eventualmente generata.
sale_invoice_ref_id mis_sale_invoices int4 10  √  null
mis_sale_invoices.sale_invoice_id mis_sale_invoices_sale_invoice_ref_id_fkey
sale_invoice_ref_id mis_sale_invoices_view int4 10  √  null
sale_invoice_seq mis_delivery_notes int4 10  √  null
sale_invoice_seq mis_fast_delivery_notes int4 10  √  null
sale_invoice_seq mis_fast_sale_invoice_lines int4 10  √  null
sale_invoice_seq mis_sale_invoice_lines int4 10  √  null
sale_iva_id mis_fast_sale_iva int4 10  √  null
mis_sale_iva.sale_iva_id Implied Constraint
sale_iva_id mis_sale_iva int4 10
mis_fast_sale_iva.sale_iva_id Implied Constraint
sale_max_price mis_purc_list_prices numeric 17,5  √  0
sale_max_price mis_purc_prices numeric 17,5  √  null
sale_max_price mis_purc_products_with_prices numeric 17,5  √  null
sale_max_price_pretty mis_purc_prices varchar 2147483647  √  null
sale_max_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
sale_min_price mis_purc_list_prices numeric 17,5  √  0
sale_min_price mis_purc_prices numeric 17,5  √  null
sale_min_price mis_purc_products_with_prices numeric 17,5  √  null
sale_min_price_pretty mis_purc_prices varchar 2147483647  √  null
sale_min_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
sale_public_price mis_purc_list_prices numeric 17,5  √  null Prezzo di vendita imposto al pubblico.
sale_public_price mis_purc_prices numeric 17,5  √  null
sale_public_price mis_purc_products_with_prices numeric 17,5  √  null
sale_public_price_pretty mis_purc_prices varchar 2147483647  √  null
sale_public_price_pretty mis_purc_products_with_prices varchar 2147483647  √  null
sale_rep_code mis_sale_reps varchar 200  √  null
sale_rep_description mis_sale_reps varchar 4000  √  null
sale_rep_id mis_all_orders int4 10  √  null
sale_rep_id mis_bids int4 10  √  null
categories.category_id mis_bids_sale_rep_id_fk
sale_rep_id mis_customers int4 10  √  null
sale_rep_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_sale_rep_id_fkey
sale_rep_id mis_fast_bids int4 10  √  null
sale_rep_id mis_fast_customers int4 10  √  null
sale_rep_id mis_fast_delivery_notes int4 10  √  null
sale_rep_id mis_fast_orders int4 10  √  null
sale_rep_id mis_fast_parties int4 10  √  null
sale_rep_id mis_fast_sale_invoices int4 10  √  null
sale_rep_id mis_fast_vendors int4 10  √  null
sale_rep_id mis_orders int4 10  √  null
categories.category_id mis_orders_sale_rep_id_fk
sale_rep_id mis_parties int4 10  √  null
categories.category_id mis_parties_fk_sale_rep_id
sale_rep_id mis_sale_invoices int4 10  √  null
categories.category_id mis_sale_invoices_sale_rep_id_fkey
sale_rep_id mis_sale_invoices_view int4 10  √  null
sale_rep_id mis_sale_reps int4 10  √  null
sale_rep_id mis_vendors int4 10  √  null
sales_pages mis_acct_iva int4 10  √  null
salt users bpchar 40  √  null
sap_id mis_sap_parties int4 10
scope mis_delivery_note_lines bpchar 1  √  null
scope mis_fast_delivery_note_lines bpchar 1  √  null
scope mis_fast_rec_note_lines bpchar 1  √  null
scope mis_rec_note_lines bpchar 1  √  null
scope mis_rec_note_lines_view bpchar 1  √  null
screen_name users varchar 100  √  null
script_id mis_scripts int4 10
acs_objects.object_id mis_scripts_script_id_fkey
second_to_last_visit users timestamptz 35,6  √  null This is what most pages query against (since last_visit will only be
a few minutes old for most pages in a session)
sector mis_sap_parties bpchar 2  √  null
security_inherit_p acs_objects bool 1 true
security_inherit_p mis_accounts_view bool 1  √  null
security_inherit_p mis_active_products bool 1  √  null
security_inherit_p mis_all_orders bool 1  √  null
security_inherit_p mis_centers_view bool 1  √  null
security_inherit_p mis_contract_lines bool 1  √  null
security_inherit_p mis_customers bool 1  √  null
security_inherit_p mis_fast_bid_lines bool 1  √  null
security_inherit_p mis_fast_bids bool 1  √  null
security_inherit_p mis_fast_customers bool 1  √  null
security_inherit_p mis_fast_delivery_note_lines bool 1  √  null
security_inherit_p mis_fast_delivery_notes bool 1  √  null
security_inherit_p mis_fast_mr_lines bool 1  √  null
security_inherit_p mis_fast_mrs bool 1  √  null
security_inherit_p mis_fast_order_lines bool 1  √  null
security_inherit_p mis_fast_orders bool 1  √  null
security_inherit_p mis_fast_parties bool 1  √  null
security_inherit_p mis_fast_po_lines bool 1  √  null
security_inherit_p mis_fast_pos bool 1  √  null
security_inherit_p mis_fast_products bool 1  √  null
security_inherit_p mis_fast_purc_invoice_lines bool 1  √  null
security_inherit_p mis_fast_purc_invoices bool 1  √  null
security_inherit_p mis_fast_rec_note_lines bool 1  √  null
security_inherit_p mis_fast_rec_notes bool 1  √  null
security_inherit_p mis_fast_sale_invoice_lines bool 1  √  null
security_inherit_p mis_fast_sale_invoices bool 1  √  null
security_inherit_p mis_fast_vendors bool 1  √  null
security_inherit_p mis_projects_view bool 1  √  null
security_inherit_p mis_rec_note_lines_view bool 1  √  null
security_inherit_p mis_sale_invoices_view bool 1  √  null
security_inherit_p mis_vendors bool 1  √  null
sell_conversion_factor mis_purc_prices float8 17,17  √  null
sell_conversion_factor mis_purc_products_with_prices float8 17,17  √  null
sell_conversion_factor_pretty mis_purc_prices varchar 2147483647  √  null
sell_conversion_factor_pretty mis_purc_products_with_prices varchar 2147483647  √  null
sell_um_code mis_fast_delivery_note_lines varchar 2147483647  √  null
sell_um_code mis_fast_sale_invoice_lines varchar 2147483647  √  null
sell_um_code mis_purc_prices varchar 2147483647  √  null
sell_um_code mis_purc_products_with_prices varchar 2147483647  √  null
sell_um_id mis_active_products int4 10  √  null
sell_um_id mis_bid_lines int4 10
mis_um.um_id mis_bid_lines_sell_um_id
sell_um_id mis_contract_lines int4 10  √  null
sell_um_id mis_delivery_note_lines int4 10  √  null
mis_um.um_id mis_delivery_note_lines_sell_um_id_fkey
sell_um_id mis_fast_bid_lines int4 10  √  null
sell_um_id mis_fast_delivery_note_lines int4 10  √  null
sell_um_id mis_fast_order_lines int4 10  √  null
sell_um_id mis_fast_products int4 10  √  null
sell_um_id mis_fast_sale_invoice_lines int4 10  √  null
sell_um_id mis_order_lines int4 10  √  null
mis_um.um_id mis_order_lines_sell_um_id
sell_um_id mis_products int4 10  √  null
mis_um.um_id mis_products_fk_sell_um
sell_um_id mis_purc_prices int4 10  √  null
sell_um_id mis_purc_products_with_prices int4 10  √  null
sell_um_id mis_sale_invoice_lines int4 10
mis_um.um_id mis_sale_invoice_lines_sell_um_id_fkey
seq mis_acct_plan int4 10  √  null
shipping_address mis_all_orders text 2147483647  √  null
shipping_address mis_bids text 2147483647  √  null
shipping_address mis_delivery_notes text 2147483647  √  null
shipping_address mis_fast_bids text 2147483647  √  null
shipping_address mis_fast_delivery_notes text 2147483647  √  null
shipping_address mis_fast_orders text 2147483647  √  null
shipping_address mis_orders text 2147483647  √  null
shipping_code mis_shippings varchar 200  √  null
shipping_description mis_shippings varchar 4000  √  null
shipping_id mis_all_orders int4 10  √  null
shipping_id mis_bids int4 10  √  null
categories.category_id mis_bids_fk_shipping_id
shipping_id mis_customers int4 10  √  null
shipping_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_shipping_id_fkey
shipping_id mis_fast_bids int4 10  √  null
shipping_id mis_fast_customers int4 10  √  null
shipping_id mis_fast_delivery_notes int4 10  √  null
shipping_id mis_fast_orders int4 10  √  null
shipping_id mis_fast_parties int4 10  √  null
shipping_id mis_fast_pos int4 10  √  null
shipping_id mis_fast_rec_notes int4 10  √  null
shipping_id mis_fast_vendors int4 10  √  null
shipping_id mis_orders int4 10  √  null
categories.category_id mis_orders_fk_shipping_id
shipping_id mis_parties int4 10  √  null
categories.category_id mis_parties_fk_shipping_id
shipping_id mis_pos int4 10  √  null
categories.category_id mis_pos_fk_shipping_id
shipping_id mis_rec_notes int4 10  √  null
categories.category_id mis_rec_notes_shipping_id_fkey
shipping_id mis_shippings int4 10  √  null
shipping_id mis_vendors int4 10  √  null
shipping_notes mis_delivery_note_lines text 2147483647  √  null
shipping_notes mis_delivery_notes text 2147483647  √  null
shipping_notes mis_fast_delivery_note_lines text 2147483647  √  null
shipping_notes mis_fast_delivery_notes text 2147483647  √  null
short_name auth_authorities varchar 255  √  null
singleton_p apm_package_types bool 1 false Indicates if the package can be used for subsites. If this is set to
't', the package can be enabled for any subsite. Otherwise, it is
restricted to the acs-admin/ subsite.
site_wide_p category_trees bpchar 1  √  't'::bpchar Declares if a tree is site-wide or local (only usable by users/groups
that have permissions).
sort_order auth_authorities int4 10
spec_file_mtime apm_package_types int4 10  √  null The last time a spec file was modified. This information is maintained in the
database so that if a user changes the specification file by editing the file
(as opposed to using the UI, the system can read the .info file and update
the information in the database appropriately.
spec_file_path apm_package_types varchar 1500  √  null The path to the package specification file.
start_date mis_projects date 13  √  null
start_date mis_projects_view date 13  √  null
start_date mis_quotations date 13  √  null
start_date mis_quotations_view date 13  √  null
start_date_pretty mis_projects_view text 2147483647  √  null
start_date_pretty mis_quotations_view text 2147483647  √  null
start_date_widget mis_projects_view text 2147483647  √  null
start_date_widget mis_quotations_view text 2147483647  √  null
starting_day mis_payments int4 10  √  null
state mis_addresses varchar 32  √  null
state mis_customers varchar 32  √  null
state mis_fast_customers varchar 32  √  null
state mis_fast_mrs bpchar 1  √  null
state mis_fast_parties varchar 32  √  null
state mis_fast_vendors varchar 32  √  null
state mis_mrs bpchar 1  √  null N=Nuova A=Approvata C=Chiusa
state mis_vendors varchar 32  √  null
store_description mis_stores varchar 100  √  null
store_id mis_all_orders int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_contract_lines int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_delivery_notes int4 10  √  null
mis_stores.store_id mis_delivery_notes_store_id_fkey
store_id mis_fast_delivery_note_lines int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_delivery_notes int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_mrs int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_order_lines int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_orders int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_po_lines int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_pos int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_rec_note_lines int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_fast_rec_notes int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_mrs int4 10  √  null
mis_stores.store_id mis_mrs_store_id_fk
Riferimento al magazzino a cui č destinato l materiale.
store_id mis_order_lines int4 10  √  null
mis_stores.store_id mis_order_lines_store_id
store_id mis_orders int4 10  √  null
mis_stores.store_id mis_orders_store_id_fk
store_id mis_po_lines int4 10  √  null
mis_stores.store_id mis_po_lines_store_id_fk
Magazzino a cui č destinato il materiale. La quantitą 'on_order' verrą registrata nel record inventariale
corrispondente a questo magazzino.
store_id mis_pos int4 10  √  null
mis_stores.store_id mis_pos_store_id_fk
Magazzino a cui č destinato il materiale. La quantitą 'on_order' verrą registrata nel record inventariale
corrispondente a questo magazzino. (verrą impostato per default su tutte le righe)
store_id mis_rec_note_lines int4 10  √  null
mis_stores.store_id mis_rec_note_lines_store_id_fkey
store_id mis_rec_note_lines_view int4 10  √  null
mis_stores.store_id Implied Constraint
store_id mis_rec_notes int4 10  √  null
mis_stores.store_id mis_rec_notes_store_id_fkey
store_id mis_store_locations int4 10
mis_stores.store_id mis_store_locations_store_id_fkey
store_id mis_stores int4 10
mis_all_orders.store_id Implied Constraint
mis_contract_lines.store_id Implied Constraint
mis_delivery_notes.store_id mis_delivery_notes_store_id_fkey
mis_fast_delivery_note_lines.store_id Implied Constraint
mis_fast_delivery_notes.store_id Implied Constraint
mis_fast_mrs.store_id Implied Constraint
mis_fast_order_lines.store_id Implied Constraint
mis_fast_orders.store_id Implied Constraint
mis_fast_po_lines.store_id Implied Constraint
mis_fast_pos.store_id Implied Constraint
mis_fast_rec_note_lines.store_id Implied Constraint
mis_fast_rec_notes.store_id Implied Constraint
mis_inventories.inv_store_id mis_inventories_inv_store_id_fkey
mis_mrs.store_id mis_mrs_store_id_fk
mis_order_lines.store_id mis_order_lines_store_id
mis_orders.store_id mis_orders_store_id_fk
mis_plants.base_store_id mis_plants_fk_base_store_id
mis_plants.raw_material_store_id mis_plants_fk_raw_material_store_id
mis_po_lines.store_id mis_po_lines_store_id_fk
mis_pos.store_id mis_pos_store_id_fk
mis_rec_note_lines.store_id mis_rec_note_lines_store_id_fkey
mis_rec_note_lines_view.store_id Implied Constraint
mis_rec_notes.store_id mis_rec_notes_store_id_fkey
mis_store_locations.store_id mis_store_locations_store_id_fkey
mis_user_preferences.store_id Implied Constraint
mis_wh_mov.wh_mov_store_id mis_wh_mov_wh_mov_store_id_fkey
Colonna utilizzata anche come codice esterno del deposito.
store_id mis_user_preferences int4 10  √  null
mis_stores.store_id Implied Constraint
subaddr mis_addresses varchar 100  √  null
subaddr mis_customers varchar 100  √  null
subaddr mis_fast_customers varchar 100  √  null
subaddr mis_fast_parties varchar 100  √  null
subaddr mis_fast_vendors varchar 100  √  null
subaddr mis_vendors varchar 100  √  null
supertype acs_object_types varchar 100  √  null
acs_object_types.object_type acs_object_types_supertype_fk
The object_type of which this object_type is a specialization (if
any). For example, the supertype of the "user" object_type is
"person". An object_type inherits the attributes and relationship
rules of its supertype, though it can add constraints to the
attributes and/or it can override the relationship rules. For
instance, the "person" object_type has an optional "email" attribute,
while its "user" subtype makes "email" mandatory.
table_name acs_object_types varchar 30  √  null The name of the type-specific table in which the values of attributes
specific to this object_type are stored, if any.
tax_amount mis_delivery_transport numeric 13,2  √  null
title acs_objects varchar 1000  √  null Title of the object if applicable.
Please note that in mid-term this column will replace all
titles or object_names of package specific tables.
title mis_accounts_view varchar 1000  √  null
title mis_active_products varchar 1000  √  null
title mis_all_orders varchar 1000  √  null
title mis_centers_view varchar 1000  √  null
title mis_contract_lines varchar 1000  √  null
title mis_customers varchar 1000  √  null
title mis_fast_bid_lines varchar 1000  √  null
title mis_fast_bids varchar 1000  √  null
title mis_fast_customers varchar 1000  √  null
title mis_fast_delivery_note_lines varchar 1000  √  null
title mis_fast_delivery_notes varchar 1000  √  null
title mis_fast_mr_lines varchar 1000  √  null
title mis_fast_mrs varchar 1000  √  null
title mis_fast_order_lines varchar 1000  √  null
title mis_fast_orders varchar 1000  √  null
title mis_fast_parties varchar 1000  √  null
title mis_fast_po_lines varchar 1000  √  null
title mis_fast_pos varchar 1000  √  null
title mis_fast_products varchar 1000  √  null
title mis_fast_purc_invoice_lines varchar 1000  √  null
title mis_fast_purc_invoices varchar 1000  √  null
title mis_fast_rec_note_lines varchar 1000  √  null
title mis_fast_rec_notes varchar 1000  √  null
title mis_fast_sale_invoice_lines varchar 1000  √  null
title mis_fast_sale_invoices varchar 1000  √  null
title mis_fast_vendors varchar 1000  √  null
title mis_projects_view varchar 1000  √  null
title mis_rec_note_lines_view varchar 1000  √  null
title mis_sale_invoices_view varchar 1000  √  null
title mis_vendors varchar 1000  √  null
to_mov_type mis_bill_types varchar 3  √  null
mis_wh_mov_types.wh_mov_type_code mis_bill_types_to_mov_type_fkey
to_mov_type mis_bill_types_with_counter varchar 3  √  null
tree_id categories int4 10  √  null
category_trees.tree_id cat_tree_id_fk
ID of a tree (see category_trees).
tree_id category_trees int4 10
categories.tree_id cat_tree_id_fk
acs_objects.object_id cat_trees_tree_id_fk
ID of a tree.
tree_sortkey acs_object_types varbit 2147483647  √  null
tree_sortkey acs_objects varbit 2147483647
tree_sortkey mis_accounts_view varbit 2147483647  √  null
tree_sortkey mis_active_products varbit 2147483647  √  null
tree_sortkey mis_all_orders varbit 2147483647  √  null
tree_sortkey mis_centers_view varbit 2147483647  √  null
tree_sortkey mis_contract_lines varbit 2147483647  √  null
tree_sortkey mis_customers varbit 2147483647  √  null
tree_sortkey mis_fast_bid_lines varbit 2147483647  √  null
tree_sortkey mis_fast_bids varbit 2147483647  √  null
tree_sortkey mis_fast_customers varbit 2147483647  √  null
tree_sortkey mis_fast_delivery_note_lines varbit 2147483647  √  null
tree_sortkey mis_fast_delivery_notes varbit 2147483647  √  null
tree_sortkey mis_fast_mr_lines varbit 2147483647  √  null
tree_sortkey mis_fast_mrs varbit 2147483647  √  null
tree_sortkey mis_fast_order_lines varbit 2147483647  √  null
tree_sortkey mis_fast_orders varbit 2147483647  √  null
tree_sortkey mis_fast_parties varbit 2147483647  √  null
tree_sortkey mis_fast_po_lines varbit 2147483647  √  null
tree_sortkey mis_fast_pos varbit 2147483647  √  null
tree_sortkey mis_fast_products varbit 2147483647  √  null
tree_sortkey mis_fast_purc_invoice_lines varbit 2147483647  √  null
tree_sortkey mis_fast_purc_invoices varbit 2147483647  √  null
tree_sortkey mis_fast_rec_note_lines varbit 2147483647  √  null
tree_sortkey mis_fast_rec_notes varbit 2147483647  √  null
tree_sortkey mis_fast_sale_invoice_lines varbit 2147483647  √  null
tree_sortkey mis_fast_sale_invoices varbit 2147483647  √  null
tree_sortkey mis_fast_vendors varbit 2147483647  √  null
tree_sortkey mis_projects_view varbit 2147483647  √  null
tree_sortkey mis_rec_note_lines_view varbit 2147483647  √  null
tree_sortkey mis_sale_invoices_view varbit 2147483647  √  null
tree_sortkey mis_vendors varbit 2147483647  √  null
trip_amount mis_delivery_transport numeric 13,2  √  null
type_extension_table acs_object_types varchar 30  √  null Object types (and their subtypes) that require more type-specific
data than the fields already existing in acs_object_types may name
a table in which that data is stored. The table should be keyed
by the associated object_type. For example, a row in the group_types
table stores a default approval policy for every user group of that type.
In this example, the group_types table has a primary key named
group_type that references acs_object_types. If a subtype of groups
for example, lab_courses, has its own type-specific data, it could be
maintained in a table called lab_course_types, with a primary key named
lab_course_type that references group_types. This provides the same
functionality as static class fields in an object-oriented programming language.
um_code mis_fast_delivery_note_lines varchar 2147483647  √  null
um_code mis_fast_rec_note_lines varchar 2147483647  √  null
um_code mis_purc_prices varchar 2147483647  √  null
um_code mis_purc_products_with_prices varchar 2147483647  √  null
um_code mis_quotations_view varchar 2147483647  √  null
um_code mis_rec_note_lines_view varchar 2147483647  √  null
um_code mis_um varchar 3  √  null
um_description mis_um text 2147483647  √  null
um_id mis_active_products int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_fast_delivery_note_lines int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_fast_products int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_fast_rec_note_lines int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_products int4 10  √  null
mis_um.um_id mis_products_fk_um
um_id mis_projects int4 10
mis_um.um_id mis_projects_um_id_fkey
um_id mis_projects_view int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_purc_prices int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_purc_products_with_prices int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_quotations_view int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_rec_note_lines_view int4 10  √  null
mis_um.um_id Implied Constraint
um_id mis_um int4 10
mis_active_products.um_id Implied Constraint
mis_bid_lines.sell_um_id mis_bid_lines_sell_um_id
mis_delivery_note_lines.sell_um_id mis_delivery_note_lines_sell_um_id_fkey
mis_fast_delivery_note_lines.um_id Implied Constraint
mis_fast_products.um_id Implied Constraint
mis_fast_rec_note_lines.um_id Implied Constraint
mis_order_lines.sell_um_id mis_order_lines_sell_um_id
mis_po_lines.purc_um_id mis_po_lines_purc_um_id_fk
mis_products.sell_um_id mis_products_fk_sell_um
mis_products.um_id mis_products_fk_um
mis_projects.um_id mis_projects_um_id_fkey
mis_projects_view.um_id Implied Constraint
mis_purc_invoice_lines.purc_um_id mis_purc_invoice_lines_purc_um_id_fkey
mis_purc_list_prices.purc_um_id mis_purc_list_prices_purc_um_id_fkey
mis_purc_prices.um_id Implied Constraint
mis_purc_products_with_prices.um_id Implied Constraint
mis_quotations.purc_um_id mis_quotations_purc_um_id_fkey
mis_quotations_view.um_id Implied Constraint
mis_rec_note_lines.purc_um_id mis_rec_note_lines_purc_um_id_fkey
mis_rec_note_lines_view.um_id Implied Constraint
mis_sale_invoice_lines.sell_um_id mis_sale_invoice_lines_sell_um_id_fkey
unit_cost mis_active_products float8 17,17  √  null
unit_cost mis_fast_products float8 17,17  √  null
unit_cost mis_products float8 17,17  √  0
unit_cost_pretty mis_active_products varchar 2147483647  √  null
unit_cost_pretty mis_fast_products varchar 2147483647  √  null
unsolved_account_id mis_bank_accounts int4 10  √  null
mis_accounts.account_id mis_bank_accounts_unsolved_account_id_fkey
unsolved_account_id mis_banks_view int4 10  √  null
unsolved_exp mis_bank_accounts numeric 13,2  √  null
unsolved_exp mis_banks_view numeric 131089  √  null
unsolved_exp_pretty mis_banks_view varchar 2147483647  √  null
upper_title mis_active_products varchar 1000  √  null
upper_title mis_all_orders varchar 1000  √  null
upper_title mis_customers varchar 1000  √  null
upper_title mis_fast_customers varchar 1000  √  null
upper_title mis_fast_orders varchar 1000  √  null
upper_title mis_fast_parties varchar 1000  √  null
upper_title mis_fast_products varchar 1000  √  null
upper_title mis_fast_vendors varchar 1000  √  null
upper_title mis_orders varchar 1000  √  null
upper_title mis_parties varchar 1000  √  null Ragione sociale maiuscola.
(title column stored in acs_objects)
upper_title mis_products varchar 1000  √  null
upper_title mis_purc_prices varchar 1000  √  null
upper_title mis_purc_products_with_prices varchar 1000  √  null
upper_title mis_quotations_view varchar 1000  √  null
upper_title mis_vendors varchar 1000  √  null
url mis_addresses varchar 100  √  null
url mis_customers varchar 100  √  null
url mis_fast_customers varchar 100  √  null
url mis_fast_parties varchar 100  √  null
url mis_fast_vendors varchar 100  √  null
url mis_monitoring varchar 100  √  null
url mis_vendors varchar 100  √  null
url parties varchar 200  √  null We store url here so that we can always make party names hyperlinks
without joining to any other table.
user_id mis_monitoring int4 10  √  null
mis_user_preferences.user_id Implied Constraint
user_id mis_print int4 10  √  null
mis_user_preferences.user_id Implied Constraint
user_id mis_user_preferences int4 10
mis_monitoring.user_id Implied Constraint
mis_print.user_id Implied Constraint
users.user_id mis_user_preferences_user_id_fkey
user_id users int4 10
acs_objects.creation_user acs_objects_creation_user_fk
acs_objects.modifying_user acs_objects_modifying_user_fk
mis_acct_mov.acct_mov_user mis_acct_mov_acct_mov_user_fkey
mis_scripts.maintainer mis_scripts_fk2
mis_scripts.original_author mis_scripts_fk1
mis_user_preferences.user_id mis_user_preferences_user_id_fkey
mis_wh_mov.wh_mov_user mis_wh_mov_wh_mov_user_fkey
persons.person_id users_user_id_fk
user_info_impl_id auth_authorities int4 10  √  null
acs_objects.object_id auth_authority_userinf_impl_fk
username users varchar 100
valid_from mis_purc_price_lists date 13
valid_from mis_purc_prices date 13  √  null
valid_from mis_purc_products_with_prices date 13  √  null
valid_from_pretty mis_purc_prices text 2147483647  √  null
valid_from_pretty mis_purc_products_with_prices text 2147483647  √  null
valid_from_widget mis_purc_prices text 2147483647  √  null
valid_from_widget mis_purc_products_with_prices text 2147483647  √  null
valid_to mis_purc_price_lists date 13  √  null
valid_to mis_purc_prices date 13  √  null
valid_to mis_purc_products_with_prices date 13  √  null
valid_to_pretty mis_purc_prices text 2147483647  √  null
valid_to_pretty mis_purc_products_with_prices text 2147483647  √  null
valid_to_widget mis_purc_prices text 2147483647  √  null
valid_to_widget mis_purc_products_with_prices text 2147483647  √  null
vendor_code mis_fast_rec_notes varchar 30  √  null
vendor_code mis_purc_operations varchar 30  √  null
vendor_code mis_purc_prices varchar 30  √  null
vendor_code mis_purc_products_with_prices varchar 30  √  null
vendor_code mis_quotations_view varchar 30  √  null
vendor_description mis_purc_operations varchar 1000  √  null
vendor_id mis_acct_vendors int4 10  √  null
vendor_id mis_fast_pos int4 10  √  null
vendor_id mis_fast_purc_invoices int4 10  √  null
vendor_id mis_fast_rec_notes int4 10  √  null
vendor_id mis_pos int4 10
mis_parties.party_id mis_pos_vendor_id_fk
vendor_id mis_purc_invoices int4 10
mis_parties.party_id mis_purc_invoices_vendor_id_fkey
vendor_id mis_purc_operations int4 10  √  null
vendor_id mis_purc_paydates_view int4 10  √  null
vendor_id mis_purc_price_lists int4 10
mis_parties.party_id mis_purc_price_lists_vendor_id_fkey
vendor_id mis_purc_prices int4 10  √  null
vendor_id mis_purc_products_with_prices int4 10  √  null
vendor_id mis_quotations int4 10
mis_parties.party_id mis_quotations_vendor_id_fkey
vendor_id mis_quotations_view int4 10  √  null
vendor_id mis_stores int4 10  √  null
mis_parties.party_id mis_stores_vendor_id_fkey
In caso di Conto Lavoro fa riferimento al terzista.
vendor_id mis_vendors_products_map int4 10  √  null
mis_parties.party_id mis_vendors_products_map_vendor_id_fkey
vendor_name mis_fast_rec_notes varchar 1000  √  null
vendor_name mis_purc_prices varchar 1000  √  null
vendor_name mis_purc_products_with_prices varchar 1000  √  null
vendor_name mis_quotations_view varchar 1000  √  null
vendor_product_code mis_purc_prices varchar 2147483647  √  null
vendor_product_code mis_purc_products_with_prices varchar 2147483647  √  null
vendor_product_code mis_quotations_view varchar 2147483647  √  null
weight mis_active_products float8 17,17  √  null
weight mis_fast_products float8 17,17  √  null
weight mis_products float8 17,17  √  null
weight_pretty mis_active_products varchar 2147483647  √  null
weight_pretty mis_fast_products varchar 2147483647  √  null
wh_mov_account_id mis_wh_mov int4 10  √  null Imputazione del movimento. Se omessa si assume 'STOCK'.
wh_mov_amount mis_wh_mov numeric 17,5  √  0
wh_mov_date mis_wh_mov date 13  √  null
wh_mov_id mis_wh_mov int4 10
wh_mov_location_id mis_wh_mov int4 10  √  null
mis_store_locations.location_id mis_wh_mov_wh_mov_location_id_fkey
wh_mov_lot_id mis_wh_mov int4 10  √  null
mis_product_lots.lot_id mis_wh_mov_wh_mov_lot_id_fkey
wh_mov_notes mis_wh_mov text 2147483647  √  null
wh_mov_party_id mis_wh_mov int4 10  √  null
mis_parties.party_id mis_wh_mov_wh_mov_party_id_fkey
wh_mov_product_id mis_wh_mov int4 10  √  null
mis_products.product_id mis_wh_mov_wh_mov_product_id_fkey
wh_mov_qty mis_wh_mov numeric 11,2  √  0
wh_mov_ref mis_wh_mov varchar 20  √  null
wh_mov_ref_id mis_wh_mov int4 10  √  null
wh_mov_store_id mis_wh_mov int4 10  √  null
mis_stores.store_id mis_wh_mov_wh_mov_store_id_fkey
wh_mov_type mis_wh_mov int4 10  √  null
mis_wh_mov_types.wh_mov_type_id mis_wh_mov_wh_mov_type_fkey
wh_mov_type_code mis_wh_mov_types varchar 3  √  null
mis_bill_types.from_mov_type mis_bill_types_from_mov_type_fkey
mis_bill_types.to_mov_type mis_bill_types_to_mov_type_fkey
wh_mov_type_description mis_wh_mov_types varchar 50  √  null
wh_mov_type_id mis_wh_mov_types int4 10
mis_wh_mov.wh_mov_type mis_wh_mov_wh_mov_type_fkey
wh_mov_type_qty_type mis_wh_mov_types varchar 15 'qty'::character varying Definisce la grandezza gestita dal movimento (qty, on_order, qty_reserved)
wh_mov_type_sign mis_wh_mov_types bpchar 1  √  null
wh_mov_user mis_wh_mov int4 10  √  null
users.user_id mis_wh_mov_wh_mov_user_fkey
width mis_active_products float8 17,17  √  null
width mis_fast_products float8 17,17  √  null
width mis_products float8 17,17  √  null
width_pretty mis_active_products varchar 2147483647  √  null
width_pretty mis_fast_products varchar 2147483647  √  null
zipcode mis_addresses varchar 10  √  null
zipcode mis_customers varchar 10  √  null
zipcode mis_fast_customers varchar 10  √  null
zipcode mis_fast_parties varchar 10  √  null
zipcode mis_fast_vendors varchar 10  √  null
zipcode mis_vendors varchar 10  √  null
zone_code mis_sale_zones varchar 200  √  null
zone_description mis_sale_zones varchar 4000  √  null
zone_id mis_all_orders int4 10  √  null
zone_id mis_bids int4 10  √  null
categories.category_id mis_bids_zone_id_fk
zone_id mis_customers int4 10  √  null
zone_id mis_delivery_notes int4 10  √  null
categories.category_id mis_delivery_notes_zone_id_fkey
zone_id mis_fast_bids int4 10  √  null
zone_id mis_fast_customers int4 10  √  null
zone_id mis_fast_delivery_notes int4 10  √  null
zone_id mis_fast_orders int4 10  √  null
zone_id mis_fast_parties int4 10  √  null
zone_id mis_fast_sale_invoices int4 10  √  null
zone_id mis_fast_vendors int4 10  √  null
zone_id mis_orders int4 10  √  null
categories.category_id mis_orders_fk_zone_id
zone_id mis_parties int4 10  √  null
categories.category_id mis_parties_fk_zone_id
zone_id mis_sale_invoices int4 10  √  null
categories.category_id mis_sale_invoices_zone_id_fkey
zone_id mis_sale_invoices_view int4 10  √  null
zone_id mis_sale_zones int4 10  √  null
zone_id mis_vendors int4 10  √  null