hls_ebank_interface.lwm 6.4 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Razgriz.Tang  
    $Date: 2014-3-26 上午10:32:07  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HLS_EBANK_INTERFACE" defaultOrderBy="interface_id">
    <bm:fields>
        <bm:field name="interface_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTERFACE_ID" prompt="HLS_EBANK_INTERFACE.INTERFACE_ID"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="HLS_EBANK_INTERFACE.COMPANY_ID"/>
        <bm:field name="cashflow_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_ID" prompt="HLS_EBANK_INTERFACE.CASHFLOW_ID"/>
        <bm:field name="priority" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRIORITY" prompt="HLS_EBANK_INTERFACE.PRIORITY"/>
        <bm:field name="funnam" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FUNNAM" prompt="HLS_EBANK_INTERFACE.FUNNAM"/>
        <bm:field name="dattyp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DATTYP" prompt="HLS_EBANK_INTERFACE.DATTYP"/>
        <bm:field name="lgnnam" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LGNNAM" prompt="HLS_EBANK_INTERFACE.LGNNAM"/>
        <bm:field name="buscod" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSCOD" prompt="HLS_EBANK_INTERFACE.BUSCOD"/>
        <bm:field name="busmod" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSMOD" prompt="HLS_EBANK_INTERFACE.BUSMOD"/>
        <bm:field name="modals" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MODALS" prompt="HLS_EBANK_INTERFACE.MODALS"/>
        <bm:field name="trstyp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRSTYP" prompt="HLS_EBANK_INTERFACE.TRSTYP"/>
        <bm:field name="c_trstyp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="C_TRSTYP" prompt="HLS_EBANK_INTERFACE.C_TRSTYP"/>
        <bm:field name="eptdat" databaseType="DATE" datatype="java.util.Date" physicalName="EPTDAT" prompt="HLS_EBANK_INTERFACE.EPTDAT"/>
        <bm:field name="dbtacc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DBTACC" prompt="HLS_EBANK_INTERFACE.DBTACC"/>
        <bm:field name="bbknbr" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BBKNBR" prompt="HLS_EBANK_INTERFACE.BBKNBR"/>
        <bm:field name="bankarea" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANKAREA" prompt="HLS_EBANK_INTERFACE.BANKAREA"/>
        <bm:field name="sum" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SUM" prompt="HLS_EBANK_INTERFACE.SUM"/>
        <bm:field name="total" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TOTAL" prompt="HLS_EBANK_INTERFACE.TOTAL"/>
        <bm:field name="ccynbr" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CCYNBR" prompt="HLS_EBANK_INTERFACE.CCYNBR"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="HLS_EBANK_INTERFACE.CURRENCY"/>
        <bm:field name="yurref" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="YURREF" prompt="HLS_EBANK_INTERFACE.YURREF"/>
        <bm:field name="memo" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MEMO" prompt="HLS_EBANK_INTERFACE.MEMO"/>
        <bm:field name="accnbr" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCNBR" prompt="HLS_EBANK_INTERFACE.ACCNBR"/>
        <bm:field name="cltnam" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLTNAM" prompt="HLS_EBANK_INTERFACE.CLTNAM"/>
        <bm:field name="trsamt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TRSAMT" prompt="HLS_EBANK_INTERFACE.TRSAMT"/>
        <bm:field name="bnkflg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BNKFLG" prompt="HLS_EBANK_INTERFACE.BNKFLG"/>
        <bm:field name="eacbnk" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EACBNK" prompt="HLS_EBANK_INTERFACE.EACBNK"/>
        <bm:field name="eaccty" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EACCTY" prompt="HLS_EBANK_INTERFACE.EACCTY"/>
        <bm:field name="trsdsp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRSDSP" prompt="HLS_EBANK_INTERFACE.TRSDSP"/>
        <bm:field name="retcod" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RETCOD" prompt="HLS_EBANK_INTERFACE.RETCOD"/>
        <bm:field name="errmsg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ERRMSG" prompt="HLS_EBANK_INTERFACE.ERRMSG"/>
        <bm:field name="reqnbr" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REQNBR" prompt="HLS_EBANK_INTERFACE.REQNBR"/>
        <bm:field name="oprdat" databaseType="DATE" datatype="java.util.Date" physicalName="OPRDAT" prompt="HLS_EBANK_INTERFACE.OPRDAT"/>
        <bm:field name="trs_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRS_STATUS" prompt="HLS_EBANK_INTERFACE.TRS_STATUS"/>
        <bm:field name="confirm_date" databaseType="DATE" datatype="java.util.Date" physicalName="CONFIRM_DATE" prompt="HLS_EBANK_INTERFACE.CONFIRM_DATE"/>
        <bm:field name="submit_date" databaseType="DATE" datatype="java.util.Date" physicalName="SUBMIT_DATE" prompt="HLS_EBANK_INTERFACE.SUBMIT_DATE"/>
        <bm:field name="csh_transaction_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_TRANSACTION_ID" prompt="HLS_EBANK_INTERFACE.CSH_TRANSACTION_ID"/>
        <bm:field name="protocol_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="protocol_number" prompt="HLS_EBANK_INTERFACE.protocol_number"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <o:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="interface_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="trs_status" queryExpression="t1.trs_status = ${@trs_status}"/>
        <bm:query-field name="interface_id" queryExpression="t1.interface_id in ${:@interface_id}"/>
    </bm:query-fields>
    <!--     <bm:data-filters>
        <bm:data-filter name="company_id" enforceOperations="query" expression="t1.company_id=${/session/@company_id}"/>
    </bm:data-filters> -->
</bm:model>