TAAS

Solutions

*GUI CHanges
-Add Mege Checkbox like #234->Supplier Sale & Refund Report
-List Changes like #234->Supplier Sale & Refund Report

-Issue Date to Issue/Cancel Date*
SELECT ...
        dbl_fare
        dbl_fare_paid_agency_cc,
        dbl_fare_paid_cust_cc,
        dbl_fare_paid_pax_cc
    FROM airticket.tbl_ticket tkt
        LEFT JOIN service.tbl_supp_doc_no spd
            ON tkt.fk_supp_doc_no_id = spd.pk_supp_doc_no_id
        LEFT JOIN airticket.tbl_ticket_gen_data tkg 
            ON spd.pk_supp_doc_no_id = tkg.fk_supp_doc_no_id
        LEFT JOIN service.tbl_supp_doc_fare sfr
            ON tkt.fk_ticket_cus_ledg_fare_id = sfr.pk_supp_doc_fare_id --*1
    WHERE tkt.int_sys_action_id != -1
        --AND (spd.sin_sys_sale_side_status = IN (1,2) OR spd.sin_sys_refund_side_status IN (1,3))
        --AND spd.dat_issue BETWEEN '2023-08-08' AND '2023-08-08'
        --AND (spd.vhr_pax_name ILIKE '*' OR pxp.vhr_pax_name ILIKE '*')
        ...
* Consider sin_record_type
* Fare Cash = dbl_fare_paid_agency_cc+ dbl_fare_paid_pax_cc+dbl_fare_paid_pax_cc
* Fare Credit = dbl_fare - Fare Cash
dbl_fare

TESTING DONE