aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_update_outstanding
Parameters
Name
Type
Mode
adate
date
IN (DEFAULT NULL)
user_name
text
IN (DEFAULT NULL)
status
text
OUT
msg
text
OUT
Definition
BEGIN adate = coalesce(adate, fn_system_date()); INSERT INTO outstanding( date_ref, yesterday_balance, post_summary, paid_summary, net_different, debit_balance, credit_balance, advance_post, net_outstanding, guest_folio_balance, deposit_folio_balance, cashsale_folio_balance, deposit_yesterday_balance, deposit_received, deposit_canceled, deposit_clearing, deposit_no_show, deposit_refund, deposit_outstanding, user_name) SELECT $1, os.yesterday_balance, os.post_summary, os.paid_summary, os.net_different, os.debit_balance, os.credit_balance, os.advance_post, os.net_outstanding, os.guest_folio_balance, os.deposit_folio_balance, os.cashsale_folio_balance, dp.yesterday_balance, dp.today_received, dp.today_canceled, dp.today_clearing, dp.today_no_show, dp.today_refund, dp.outstanding, coalesce(user_name, fn_current_user()) FROM sp_get_outstanding($1, true) AS os, sp_deposit_outstanding($1, true) AS dp ON CONFLICT (date_ref) DO NOTHING; status = 'success'; msg = 'Outstanding record generated'; END