<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: ZLF
$Date: 2014-11-20 下午2:16:18
$Revision: 1.0
$Purpose:
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CSH_TRANSACTION_TEMP">
<bm:fields>
<bm:field name="csh_transaction_temp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_TRANSACTION_TEMP_ID" prompt="CSH_TRANSACTION_TEMP.CSH_TRANSACTION_TEMP_ID"/>
<bm:field name="batch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_ID" prompt="CSH_TRANSACTION_TEMP_ID.BATCH_ID"/>
<bm:field name="transaction_date" databaseType="DATE" datatype="java.util.Date" physicalName="TRANSACTION_DATE" prompt="CSH_TRANSACTION_TEMP.TRANSACTION_DATE"/>
<bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="CSH_TRANSACTION_TEMP.DESCRIPTION"/>
<bm:field name="transaction_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TRANSACTION_AMOUNT" prompt="CSH_TRANSACTION_TEMP.TRANSACTION_AMOUNT"/>
<bm:field name="bp_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_BANK_ACCOUNT_NUM" prompt="CSH_TRANSACTION_TEMP.BP_BANK_ACCOUNT_NUM"/>
<bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="CSH_TRANSACTION_TEMP.BP_NAME"/>
<bm:field name="bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_NUM" prompt="CSH_TRANSACTION_TEMP.BANK_ACCOUNT_NUM"/>
<bm:field name="bank_serial_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_SERIAL_NUM" prompt="CSH_TRANSACTION_TEMP.BANK_SERIAL_NUM"/>
<bm:field name="sys_date" databaseType="DATE" datatype="java.util.Date" physicalName="SYS_DATE" prompt="CSH_TRANSACTION_TEMP.SYS_DATE"/>
<bm:field name="project_number"/>
</bm:fields>
<bm:features>
<f:standard-who/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="csh_transaction_temp_id"/>
</bm:primary-key>
<bm:query-fields>
<bm:query-field name="batch_id" queryExpression="t1.batch_id=${@batch_id}"/>
</bm:query-fields>
</bm:model>
-
Spencer Chang authoredbfd31bca