abirama62

init_admin_cash_giro_opname

Jul 13th, 2020
398
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO cb_admin_process_daily_cash_opname(
  2. tenant_id, ou_id, cashbank_id, cashbank_date, flag_process, ref_process_id,
  3. curr_code, total_cash_amount, total_giro_amount,
  4. create_datetime, create_user_id, update_datetime, update_user_id, version)
  5.  
  6. SELECT B.tenant_id, A.ou_id, A.cashbank_id, '20200731', 'Y', -99,
  7. 'IDR', 0, 0,
  8. TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24IISS')::character varying, -1, TO_CHAR(CURRENT_TIMESTAMP, 'YYYYMMDDHH24IISS')::character varying, -1, 0
  9. FROM m_cashbank_ou A
  10. INNER JOIN m_cashbank B ON A.cashbank_id = B.cashbank_id;
RAW Paste Data