auditor.acq_invoice_item_history

↑ auditor schema

Written by External Triggers: This table can receive writes triggered by operations on other tables:

audit_acq_invoice_item_update_trigger on acq.invoice_item → INSERT into this table

Columns

Column Type Nullable Default Notes

Column	Type	Nullable
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

audit_id PK

bigint

audit_time

timestamp with time zone

audit_action

text

audit_user

integer

Yes

audit_ws

integer

Yes

integer

invoice

integer

purchase_order

integer

Yes

fund_debit

integer

Yes

inv_item_type

text

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

Primary Key

(audit_id)

Indexes

Index Method Definition

Index	Method	Definition
`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)`

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)