Schema money

Table: billable_xact

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
usr : integer -- NOT NULL, REFERENCES actor.usr.
xact_start : timestamp with time zone -- NOT NULL, DEFAULT now(),
xact_finish : timestamp with time zone --
unrecovered : boolean --

Indexes: 

m_b_x_open_xacts_idx : usr

View: billable_xact_summary

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
total_paid : numeric --
last_payment_ts : timestamp with time zone --
last_payment_note : text --
last_payment_type : name --
total_owed : numeric --
last_billing_ts : timestamp with time zone --
last_billing_note : text --
last_billing_type : text --
balance_owed : numeric --
xact_type : name --

View: billable_xact_summary_location_view

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
total_paid : numeric --
last_payment_ts : timestamp with time zone --
last_payment_note : text --
last_payment_type : name --
total_owed : numeric --
last_billing_ts : timestamp with time zone --
last_billing_note : text --
last_billing_type : text --
balance_owed : numeric --
xact_type : name --
billing_location : integer --

View: billable_xact_with_void_summary

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
total_paid : numeric --
last_payment_ts : timestamp with time zone --
last_payment_note : text --
last_payment_type : name --
total_owed : numeric --
last_billing_ts : timestamp with time zone --
last_billing_note : text --
last_billing_type : text --
balance_owed : numeric --
xact_type : name --

Table: billing

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
xact : bigint -- NOT NULL,
billing_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
voider : integer --
void_time : timestamp with time zone --
amount : numeric(6,2) -- NOT NULL,
billing_type : text -- NOT NULL,
btype : integer -- NOT NULL, REFERENCES config.billing_type.
note : text --

Indexes: 

m_b_time_idx : billing_ts
m_b_xact_idx : xact

Table: bnm_desk_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,
cash_drawer : integer -- REFERENCES actor.workstation.

Table: bnm_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,

View: bnm_payment_view

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
xact : bigint --
payment_ts : timestamp with time zone --
voided : boolean --
amount : numeric(6,2) --
note : text --
amount_collected : numeric(6,2) --
accepting_usr : integer --
payment_type : name --

Table: cash_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,
cash_drawer : integer --

Indexes: 

money_cash_id_idx : id
money_cash_payment_accepting_usr_idx : accepting_usr
money_cash_payment_cash_drawer_idx : cash_drawer
money_cash_payment_ts_idx : payment_ts
money_cash_payment_xact_idx : xact

View: cashdrawer_payment_view

Columns: 

field name : datatype -- parameters, contraints and notes
org_unit : integer --
cashdrawer : integer --
payment_type : name --
payment_ts : timestamp with time zone --
amount : numeric(6,2) --
voided : boolean --
note : text --

Table: check_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,
cash_drawer : integer --
check_number : text -- NOT NULL,

Indexes: 

money_check_id_idx : id
money_check_payment_accepting_usr_idx : accepting_usr
money_check_payment_cash_drawer_idx : cash_drawer
money_check_payment_ts_idx : payment_ts
money_check_payment_xact_idx : xact

Table: collections_tracker

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
usr : integer -- NOT NULL, REFERENCES actor.usr.
collector : integer -- NOT NULL, REFERENCES actor.usr.
location : integer -- NOT NULL, REFERENCES actor.org_unit.
enter_time : timestamp with time zone --

Indexes: 

m_c_t_collector_idx : collector

Table: credit_card_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,
cash_drawer : integer --
cc_type : text --
cc_number : text --
cc_processor : text --
cc_first_name : text --
cc_last_name : text --
expire_month : integer --
expire_year : integer --
approval_code : text --

Indexes: 

money_credit_card_id_idx : id
money_credit_card_payment_accepting_usr_idx : accepting_usr
money_credit_card_payment_cash_drawer_idx : cash_drawer
money_credit_card_payment_ts_idx : payment_ts
money_credit_card_payment_xact_idx : xact

Table: credit_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,

Indexes: 

money_credit_id_idx : id
money_credit_payment_accepting_usr_idx : accepting_usr
money_credit_payment_payment_ts_idx : payment_ts
money_credit_payment_xact_idx : xact

View: desk_payment_view

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
xact : bigint --
payment_ts : timestamp with time zone --
voided : boolean --
amount : numeric(6,2) --
note : text --
amount_collected : numeric(6,2) --
accepting_usr : integer --
cash_drawer : integer --
payment_type : name --

Table: forgive_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,

Indexes: 

money_forgive_id_idx : id
money_forgive_payment_accepting_usr_idx : accepting_usr
money_forgive_payment_payment_ts_idx : payment_ts
money_forgive_payment_xact_idx : xact

Table: goods_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,

Indexes: 

money_goods_id_idx : id
money_goods_payment_accepting_usr_idx : accepting_usr
money_goods_payment_payment_ts_idx : payment_ts
money_goods_payment_xact_idx : xact

Table: grocery

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.billable_xact_id_seq'::regclass),
usr : integer -- NOT NULL,
xact_start : timestamp with time zone -- NOT NULL, DEFAULT now(),
xact_finish : timestamp with time zone --
unrecovered : boolean --
billing_location : integer -- NOT NULL,
note : text --

Indexes: 

circ_open_date_idx : xact_start) WHERE (xact_finish IS NULL
m_g_usr_idx : usr

Table: materialized_billable_xact_summary

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY,
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
total_paid : numeric --
last_payment_ts : timestamp with time zone --
last_payment_note : text --
last_payment_type : name --
total_owed : numeric --
last_billing_ts : timestamp with time zone --
last_billing_note : text --
last_billing_type : text --
balance_owed : numeric --
xact_type : name --

Indexes: 

money_mat_summary_usr_idx : usr
money_mat_summary_xact_start_idx : xact_start

View: non_drawer_payment_view

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
xact : bigint --
payment_ts : timestamp with time zone --
voided : boolean --
amount : numeric(6,2) --
note : text --
amount_collected : numeric(6,2) --
accepting_usr : integer --
payment_type : name --

View: open_billable_xact_summary

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
usr : integer --
xact_start : timestamp with time zone --
xact_finish : timestamp with time zone --
total_paid : numeric --
last_payment_ts : timestamp with time zone --
last_payment_note : text --
last_payment_type : name --
total_owed : numeric --
last_billing_ts : timestamp with time zone --
last_billing_note : text --
last_billing_type : text --
balance_owed : numeric --
xact_type : name --
billing_location : integer --

View: open_transaction_billing_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_billing_type : text --
last_billing_note : text --
last_billing_ts : timestamp with time zone --
total_owed : numeric --

View: open_transaction_billing_type_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_billing_type : text --
last_billing_note : text --
last_billing_ts : timestamp with time zone --
total_owed : numeric --

View: open_transaction_payment_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_payment_type : name --
last_payment_note : text --
last_payment_ts : timestamp with time zone --
total_paid : numeric --

View: open_usr_circulation_summary

Columns: 

field name : datatype -- parameters, contraints and notes
usr : integer --
total_paid : numeric --
total_owed : numeric --
balance_owed : numeric --

View: open_usr_summary

Columns: 

field name : datatype -- parameters, contraints and notes
usr : integer --
total_paid : numeric --
total_owed : numeric --
balance_owed : numeric --

Table: payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigserial -- PRIMARY KEY,
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --

Indexes: 

m_p_time_idx : payment_ts
m_p_xact_idx : xact

View: payment_view

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint --
xact : bigint --
payment_ts : timestamp with time zone --
voided : boolean --
amount : numeric(6,2) --
note : text --
payment_type : name --

View: transaction_billing_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_billing_type : text --
last_billing_note : text --
last_billing_ts : timestamp with time zone --
total_owed : numeric --

View: transaction_billing_type_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_billing_type : text --
last_billing_note : text --
last_billing_ts : timestamp with time zone --
total_owed : numeric --

View: transaction_billing_with_void_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_billing_type : text --
last_billing_note : text --
last_billing_ts : timestamp with time zone --
total_owed : numeric --

View: transaction_payment_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_payment_type : name --
last_payment_note : text --
last_payment_ts : timestamp with time zone --
total_paid : numeric --

View: transaction_payment_with_void_summary

Columns: 

field name : datatype -- parameters, contraints and notes
xact : bigint --
last_payment_type : name --
last_payment_note : text --
last_payment_ts : timestamp with time zone --
total_paid : numeric --

View: usr_circulation_summary

Columns: 

field name : datatype -- parameters, contraints and notes
usr : integer --
total_paid : numeric --
total_owed : numeric --
balance_owed : numeric --

View: usr_summary

Columns: 

field name : datatype -- parameters, contraints and notes
usr : integer --
total_paid : numeric --
total_owed : numeric --
balance_owed : numeric --

Table: work_payment

Columns: 

field name : datatype -- parameters, contraints and notes
id : bigint -- PRIMARY KEY, DEFAULT nextval('money.payment_id_seq'::regclass),
xact : bigint -- NOT NULL,
payment_ts : timestamp with time zone -- NOT NULL, DEFAULT now(),
voided : boolean -- NOT NULL, DEFAULT false,
amount : numeric(6,2) -- NOT NULL,
note : text --
amount_collected : numeric(6,2) -- NOT NULL,
accepting_usr : integer -- NOT NULL,

Indexes: 

money_work_id_idx : id
money_work_payment_accepting_usr_idx : accepting_usr
money_work_payment_payment_ts_idx : payment_ts
money_work_payment_xact_idx : xact

mat_summary_create()

Function Properties
Language: PLPGSQL
Return Type: trigger

mat_summary_delete()

Function Properties
Language: PLPGSQL
Return Type: trigger

mat_summary_update()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_billing_add()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_billing_del()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_billing_update()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_payment_add()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_payment_del()

Function Properties
Language: PLPGSQL
Return Type: trigger

materialized_summary_payment_update()

Function Properties
Language: PLPGSQL
Return Type: trigger