auditor.acq_invoice_item_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

fund_debit

integer

Yes

inv_item_type

text

No

title

text

Yes

author

text

Yes

note

text

Yes

cost_billed

numeric(8,2)

Yes

actual_cost

numeric(8,2)

Yes

fund

integer

Yes

amount_paid

numeric(8,2)

Yes

po_item

integer

Yes

target

bigint

Yes

acq_invoice_item_history_pkey PK

btree

CREATE UNIQUE INDEX acq_invoice_item_history_pkey ON auditor.acq_invoice_item_history USING btree (audit_id)