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

receiver

integer

No

provider

integer

No

shipper

integer

No

recv_date

timestamp with time zone

No

recv_method

text

No

inv_type

text

Yes

inv_ident

text

No

payment_auth

text

Yes

payment_method

text

Yes

note

text

Yes

close_date

timestamp with time zone

Yes

closed_by

integer

Yes

acq_invoice_history_pkey PK

btree

CREATE UNIQUE INDEX acq_invoice_history_pkey ON auditor.acq_invoice_history USING btree (audit_id)