invoice

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('acq.invoice_id_seq'::regclass)
invoice_entry.invoice invoice_entry_invoice_fkey C
invoice_item.invoice invoice_item_invoice_fkey C
receiver int4 10 null
org_unit.id invoice_receiver_fkey R
provider int4 10 null
provider.id invoice_provider_fkey R
shipper int4 10 null
provider.id invoice_shipper_fkey R
recv_date timestamptz 35,6 now()
recv_method text 2147483647 'EDI'::text
invoice_method.code invoice_recv_method_fkey R
inv_type text 2147483647 √ null
inv_ident text 2147483647 null
payment_auth text 2147483647 √ null
payment_method text 2147483647 √ null
invoice_payment_method.code invoice_payment_method_fkey R
note text 2147483647 √ null
close_date timestamptz 35,6 √ null
closed_by int4 10 √ null
usr.id invoice_closed_by_fkey R

Indexes

Constraint Name Type Sort Column(s)
invoice_pkey Primary key Asc id
inv_ident_once_per_provider Must be unique Asc/Asc provider + inv_ident

Relationships

Close relationships within degrees of separation