auditor.acq_invoice_entry_history

audit_id PK

bigint

No

audit_time

timestamp with time zone

No

audit_action

text

No

audit_user

integer

Yes

audit_ws

integer

Yes

id

integer

No

invoice

integer

No

purchase_order

integer

Yes

lineitem

integer

Yes

inv_item_count

integer

No

phys_item_count

integer

Yes

note

text

Yes

billed_per_item

boolean

Yes

cost_billed

numeric(8,2)

Yes

actual_cost

numeric(8,2)

Yes

amount_paid

numeric(8,2)

Yes

acq_invoice_entry_history_pkey PK

btree

CREATE UNIQUE INDEX acq_invoice_entry_history_pkey ON auditor.acq_invoice_entry_history USING btree (audit_id)