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