acq.invoice_item_type

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default
code PK	`text`	No
name	`text`	No
prorate	`boolean`	No	false
blanket	`boolean`	No	false

code PK

text

name

text

prorate

boolean

false

blanket

boolean

false

(code)

Index Method Definition

Index	Method	Definition
`invoice_item_type_pkey` PK	btree	`CREATE UNIQUE INDEX invoice_item_type_pkey ON acq.invoice_item_type USING btree (code)`

invoice_item_type_pkey PK

btree

CREATE UNIQUE INDEX invoice_item_type_pkey ON acq.invoice_item_type USING btree (code)

The following tables have foreign keys pointing to acq.invoice_item_type (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.invoice_item	`inv_item_type`	`code`	`invoice_item_inv_item_type_fkey`
acq.po_item	`inv_item_type`	`code`	`po_item_inv_item_type_fkey`

inv_item_type

code

invoice_item_inv_item_type_fkey

inv_item_type

code

po_item_inv_item_type_fkey