<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CSH_TRANSACTION_INTERFACE" defaultOrderBy="trx_interface_id asc">
    <bm:fields>
        <bm:field name="batch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_ID" prompt="CSH_TRANSACTION_INTERFACE.BATCH_ID"/>
        <bm:field name="trx_interface_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TRX_INTERFACE_ID" prompt="CSH_TRANSACTION_INTERFACE.TRX_INTERFACE_ID"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="CSH_TRANSACTION_INTERFACE.COMPANY_ID"/>
        <bm:field name="csh_trx_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_TRX_TYPE" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_TYPE"/>
        <bm:field name="csh_trx_date" databaseType="DATE" datatype="java.util.Date" physicalName="CSH_TRX_DATE" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_DATE"/>
        <bm:field name="csh_trx_period_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_TRX_PERIOD_NAME" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_PERIOD_NAME"/>
        <bm:field name="csh_trx_period_num" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_TRX_PERIOD_NUM" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_PERIOD_NUM"/>
        <bm:field name="csh_trx_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CSH_TRX_AMOUNT" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_AMOUNT"/>
        <bm:field name="csh_trx_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_TRX_NUMBER" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRX_NUMBER"/>
        <bm:field name="csh_bank_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_BANK_ACCOUNT_ID" prompt="CSH_TRANSACTION_INTERFACE.CSH_BANK_ACCOUNT_ID"/>
        <bm:field name="csh_bp_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BP_CATEGORY" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_CATEGORY"/>
        <bm:field name="csh_bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_BP_ID" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_ID"/>
        <bm:field name="csh_bp_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BP_CODE" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_CODE"/>
        <bm:field name="csh_bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BP_NAME" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_NAME"/>
        <bm:field name="csh_bp_bank_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_BP_BANK_ACCOUNT_ID" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_BANK_ACCOUNT_ID"/>
        <bm:field name="csh_bp_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BP_BANK_ACCOUNT_NUM" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_BANK_ACCOUNT_NUM"/>
        <bm:field name="csh_payment_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_PAYMENT_METHOD" prompt="CSH_TRANSACTION_INTERFACE.CSH_PAYMENT_METHOD"/>
        <bm:field name="csh_payment_method_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_PAYMENT_METHOD_ID" prompt="CSH_TRANSACTION_INTERFACE.CSH_PAYMENT_METHOD_ID"/>
        <bm:field name="csh_bank_slip_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BANK_SLIP_NUM" prompt="CSH_TRANSACTION_INTERFACE.CSH_BANK_SLIP_NUM"/>
        <bm:field name="csh_currency_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_CURRENCY_CODE" prompt="CSH_TRANSACTION_INTERFACE.CSH_CURRENCY_CODE"/>
        <bm:field name="csh_exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_EXCHANGE_RATE_TYPE" prompt="CSH_TRANSACTION_INTERFACE.CSH_EXCHANGE_RATE_TYPE"/>
        <bm:field name="csh_exchange_rate_quotation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_EXCHANGE_RATE_QUOTATION" prompt="CSH_TRANSACTION_INTERFACE.CSH_EXCHANGE_RATE_QUOTATION"/>
        <bm:field name="csh_exchange_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_EXCHANGE_RATE" prompt="CSH_TRANSACTION_INTERFACE.CSH_EXCHANGE_RATE"/>
        <bm:field name="csh_handling_charge" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_HANDLING_CHARGE" prompt="CSH_TRANSACTION_INTERFACE.CSH_HANDLING_CHARGE"/>
        <bm:field name="csh_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_DESCRIPTION" prompt="CSH_TRANSACTION_INTERFACE.CSH_DESCRIPTION"/>
        <bm:field name="ref_contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_CONTRACT_NUMBER" prompt="CSH_TRANSACTION_INTERFACE.REF_CONTRACT_NUMBER"/>
        <bm:field name="ref_contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_CONTRACT_ID" prompt="CSH_TRANSACTION_INTERFACE.REF_CONTRACT_ID"/>
        <bm:field name="check_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CHECK_FLAG" prompt="CSH_TRANSACTION_INTERFACE.CHECK_FLAG"/>
        <bm:field name="post_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POST_FLAG" prompt="CSH_TRANSACTION_INTERFACE.POST_FLAG"/>
        <bm:field name="csh_transaction_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_TRANSACTION_ID" prompt="CSH_TRANSACTION_INTERFACE.CSH_TRANSACTION_ID"/>
        <bm:field name="ref_contract_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_CONTRACT_TIMES" prompt="CSH_TRANSACTION_INTERFACE.REF_CONTRACT_TIMES"/>
        <bm:field name="csh_bp_bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BP_BANK_ACCOUNT_NAME" prompt="CSH_TRANSACTION_INTERFACE.CSH_BP_BANK_ACCOUNT_NAME"/>
        <bm:field name="csh_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CSH_BANK_ACCOUNT_NUM" prompt="CSH_TRANSACTION_INTERFACE.CSH_BANK_ACCOUNT_NUM"/>
        <bm:field name="write_off_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG" prompt="CSH_TRANSACTION_INTERFACE.WRITE_OFF_FLAG"/>
        <bm:field name="lock_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOCK_FLAG" prompt="CSH_TRANSACTION_INTERFACE.LOCK_FLAG"/>
        <bm:field name="ref_contract_cf_item" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_CONTRACT_CF_ITEM" prompt="CSH_TRANSACTION_INTERFACE.REF_CONTRACT_CF_ITEM"/>
        <bm:field name="ebank_company_acc_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_COMPANY_ACC_NUM" prompt="CSH_TRANSACTION_INTERFACE.EBANK_COMPANY_ACC_NUM"/>
        <bm:field name="ebank_cust_acc_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_CUST_ACC_NUM" prompt="CSH_TRANSACTION_INTERFACE.EBANK_CUST_ACC_NUM"/>
        <bm:field name="ebank_cust_acc_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_CUST_ACC_NAME" prompt="CSH_TRANSACTION_INTERFACE.EBANK_CUST_ACC_NAME"/>
        <bm:field name="ebank_trx_amt" databaseType="NUMBER" datatype="java.lang.Double" physicalName="EBANK_TRX_AMT" prompt="CSH_TRANSACTION_INTERFACE.EBANK_TRX_AMT"/>
        <bm:field name="ebank_description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_DESCRIPTION" prompt="CSH_TRANSACTION_INTERFACE.EBANK_DESCRIPTION"/>
        <bm:field name="ebank_trx_date" databaseType="DATE" datatype="java.util.Date" physicalName="EBANK_TRX_DATE" prompt="CSH_TRANSACTION_INTERFACE.EBANK_TRX_DATE"/>
        <bm:field name="ebank_success_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_SUCCESS_STATUS" prompt="CSH_TRANSACTION_INTERFACE.EBANK_SUCCESS_STATUS"/>
        <bm:field name="ebank_result_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_RESULT_STATUS" prompt="CSH_TRANSACTION_INTERFACE.EBANK_RESULT_STATUS"/>
        <bm:field name="ebank_result_status_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_RESULT_STATUS_DESC" prompt="CSH_TRANSACTION_INTERFACE.EBANK_RESULT_STATUS_DESC"/>
        <bm:field name="ebank_result_acc_balance" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_RESULT_ACC_BALANCE" prompt="CSH_TRANSACTION_INTERFACE.EBANK_RESULT_ACC_BALANCE"/>
        <bm:field name="ebank_result_success_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_RESULT_SUCCESS_AMT" prompt="CSH_TRANSACTION_INTERFACE.EBANK_RESULT_SUCCESS_AMT"/>
        <bm:field name="line_num" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LINE_NUM" prompt="CSH_TRANSACTION_INTERFACE.LINE_NUM"/>
        <bm:field name="error_message" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ERROR_MESSAGE" prompt="CSH_TRANSACTION_INTERFACE.ERROR_MESSAGE"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="trx_interface_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field field="batch_id" queryOperator="="/>
    </bm:query-fields>
</bm:model>
