<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                Select
                    t.transaction_wfl_id,
                    t.transaction_id,
                    t.transaction_num,
                    to_char(t.transaction_date, 'yyyy-mm-dd') transaction_date,
                    to_char(t.reversed_date, 'yyyy-mm-dd') reversed_date,
                    t.reversed_period_name,
                    t.description,
                    t.note,
                    t.creation_date,
                    t.created_by,
                    t.last_update_date,
                    t.last_updated_by,
                    t.ref_v01,
                    t.ref_v02,
                    t.ref_v03,
                    t.ref_v04,
                    t.ref_v05,
                    t.ref_n01,
                    t.ref_n02,
                    t.ref_n03,
                    t.ref_n04,
                    t.ref_n05,
                    t.ref_d01,
                    t.ref_d02,
                    t.ref_d03,
                    t.ref_d04,
                    t.ref_d05,
                    t.wfl_instance_id,
                    t.approval_status,
                    nvl(t.ignore_invoice_check_flag,'N') ignore_invoice_check_flag
                From csh_transaction_wfl t #WHERE_CLAUSE#
                ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:query-fields>
        <bm:query-field name="transaction_wfl_id" queryExpression="t.transaction_wfl_id =  ${@transaction_wfl_id}"/>
    </bm:query-fields>
</bm:model>
