select rdb_log.dt_time_stamp_end as "TransactionList_timestamp", rdb_log.n0_terminal_no as "TransactionList_pos",
       rdb_log.n0_unique_str_no as "TransactionList_store",rdb_log.n0_xact_no as "TransactionList_xactnumber",
       rdb_log.n2_amount_price as "TransactionList_total" from rdb_log where bl_suspended = 1 and rdb_log.dt_time_stamp_end > date_trunc('day', now())
       order by rdb_log.dt_time_stamp_end