acq.fund_debit

↑ acq schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: fund_debit_fund_fkey, fund_debit_origin_currency_type_fkey, fund_debit_xfer_destination_fkey.

Trigger Side Effects: Writing to this table automatically triggers writes to other tables:

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('acq.fund_debit_id_seq'::regclass)

fund FK

integer

No

→ acq.fund(id)

origin_amount

numeric

No

origin_currency_type FK

text

No

→ acq.currency_type(code)

amount

numeric

No

encumbrance

boolean

No

true

debit_type

text

No

xfer_destination FK

integer

Yes

→ acq.fund(id)

create_time

timestamp with time zone

No

now()

invoice_entry FK

integer

Yes

→ acq.invoice_entry(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

fund

acq.fund(id)

NO ACTION

NO ACTION

DEFERRED

fund_debit_fund_fkey

invoice_entry

acq.invoice_entry(id)

SET NULL

NO ACTION

No

fund_debit_invoice_entry_fkey

origin_currency_type

acq.currency_type(code)

NO ACTION

NO ACTION

DEFERRED

fund_debit_origin_currency_type_fkey

xfer_destination

acq.fund(id)

NO ACTION

NO ACTION

DEFERRED

fund_debit_xfer_destination_fkey

Indexes

Index Method Definition

fund_debit_pkey PK

btree

CREATE UNIQUE INDEX fund_debit_pkey ON acq.fund_debit USING btree (id)

fund_debit_invoice_entry_idx

btree

CREATE INDEX fund_debit_invoice_entry_idx ON acq.fund_debit USING btree (invoice_entry)

Triggers

Trigger Timing Event Level Function

audit_acq_fund_debit_update_trigger

AFTER

DELETE OR UPDATE

ROW

auditor.audit_acq_fund_debit_func()

Trigger Bodies

audit_acq_fund_debit_update_trigger

Function: auditor.audit_acq_fund_debit_func()
Timing: AFTER DELETE OR UPDATE ROW

        BEGIN
            INSERT INTO auditor.acq_fund_debit_history ( audit_id, audit_time, audit_action, audit_user, audit_ws, id, fund, origin_amount, origin_currency_type, amount, encumbrance, debit_type, xfer_destination, create_time, invoice_entry )
                SELECT  nextval('auditor.acq_fund_debit_pkey_seq'),
                    now(),
                    SUBSTR(TG_OP,1,1),
                    eg_user,
                    eg_ws,
                    OLD.id, OLD.fund, OLD.origin_amount, OLD.origin_currency_type, OLD.amount, OLD.encumbrance, OLD.debit_type, OLD.xfer_destination, OLD.create_time, OLD.invoice_entry
                FROM auditor.get_audit_info();
            RETURN NULL;
        END;

Referenced By

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

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

acq.debit_attribution

fund_debit

id

debit_attribution_fund_debit_fkey

acq.invoice_item

fund_debit

id

invoice_item_fund_debit_fkey

acq.lineitem_detail

fund_debit

id

lineitem_detail_fund_debit_fkey

acq.po_item

fund_debit

id

po_item_fund_debit_fkey
Previous
Next