<?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>