View alter.public.mis_fast_sale_invoices

Generated by SchemaSpy

Implied relationships Related columns Constraint names Comments Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships Dashed lines show implied relationships < n > number of related tables Please support this project

Column Type Size Nulls Auto Default Children Parents Comments sale_invoice_id int4 10  √  null mis_sale_invoices.sale_invoice_id Implied Constraint invoice_year int4 10  √  null invoice_num varchar 30  √  null invoice_date date 13  √  null customer_id int4 10  √  null invoice_type_id int4 10  √  null mis_invoice_types.invoice_type_id Implied Constraint sale_invoice_ref_id int4 10  √  null sale_rep_id int4 10  √  null language_id bpchar 2  √  null language_codes.language_id Implied Constraint payment_id int4 10  √  null mis_payments.payment_id Implied Constraint bank_id int4 10  √  null mis_banks.bank_id Implied Constraint zone_id int4 10  √  null is_to_pay_stamp_p bool 1  √  null is_printed_p bool 1  √  null is_accounted_p bool 1  √  null is_paid_p bool 1  √  null is_confirmed_p bool 1  √  null invoice_amount numeric 13,2  √  null invoice_notes text 2147483647  √  null factoring_bank_id int4 10  √  null object_id int4 10  √  null acs_objects.object_id Implied Constraint object_type varchar 100  √  null title varchar 1000  √  null package_id int4 10  √  null apm_packages.package_id Implied Constraint context_id int4 10  √  null security_inherit_p bool 1  √  null creation_user int4 10  √  null creation_date timestamptz 35,6  √  null creation_ip varchar 50  √  null last_modified timestamptz 35,6  √  null modifying_user int4 10  √  null modifying_ip varchar 50  √  null tree_sortkey varbit 2147483647  √  null max_child_sortkey varbit 2147483647  √  null item_id int4 10  √  null invoice_date_pretty text 2147483647  √  null invoice_date_widget text 2147483647  √  null invoice_amount_pretty varchar 2147483647  √  null

Close relationships: