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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
<?xml version="1.0" encoding="UTF-8"?>
<!--
$Author: DJ
$Date: 2013-5-6 下午3:05:38
$Revision: 1.0
$Purpose:
-->
<bm:model xmlns:e="leaf.service.exception" xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CSH_BANK_ACCOUNT">
<bm:fields>
<bm:field name="bank_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BANK_ACCOUNT_ID"/>
<bm:field name="bank_account_code" databaseType="VARCHAR2" datatype="java.lang.String" forUpdate="true" physicalName="BANK_ACCOUNT_CODE" prompt="HLS.BANK_ACCOUNT_CODE"/>
<bm:field name="bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_NAME" prompt="HLS.BANK_ACCOUNT_NAME"/>
<bm:field name="bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_NUM" prompt="HLS.BANK_ACCOUNT_NUM"/>
<bm:field name="bank_full_name" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false" physicalName="BANK_FULL_NAME" prompt="HLS.BANK_FULL_NAME"/>
<bm:field name="bank_branch_code" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false" physicalName="BANK_BRANCH_CODE" prompt="HLS.BANK_BRANCH_CODE"/>
<bm:field name="bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false" physicalName="BANK_BRANCH_NAME" prompt="HLS.BANK_BRANCH_NAME"/>
<bm:field name="bank_branch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BANK_BRANCH_ID"/>
<bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" forUpdate="false" insertExpression="${/session/@company_id}" physicalName="COMPANY_ID"/>
<bm:field name="currency_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY_CODE"/>
<bm:field name="currency_name" forInsert="false" forUpdate="false" prompt="HLS.CURRENCY"/>
<bm:field name="zero_amounts_allowed" forInsert="false" forUpdate="false"/>
<bm:field name="precision" databaseType="NUMBER" datatype="java.lang.Long" forInsert="false" forUpdate="false" physicalName="PRECISION"/>
<bm:field name="enabled_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLED_FLAG" prompt="HLS.ENABLED_FLAG"/>
<bm:field name="cash_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASH_ACCOUNT_ID"/>
<bm:field name="cash_account_code" forInsert="false" forUpdate="false" prompt="CSH101.CSH_BANK_ACCOUNT.CASH_ACCOUNT_CODE"/>
<bm:field name="responsibility_center_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RESPONSIBILITY_CENTER_ID"/>
<bm:field name="responsibility_center_name" forInsert="false" forUpdate="false" prompt="HLS.RESPONSIBILITY_CENTER_NAME"/>
<bm:field name="bank_account_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_TYPE"/>
<bm:field name="bank_account_type_name" forInsert="false" forUpdate="false" prompt="HLS.BANK_ACCOUNT_TYPE_NAME"/>
<bm:field name="is_company_account" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IS_COMPANY_ACCOUNT" prompt="CSH101.CSH_BANK_ACCOUNT.IS_COMPANY_ACCOUNT"/>
<bm:field name="settlement_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SETTLEMENT_FLAG" prompt="CSH101.CSH_BANK_ACCOUNT.SETTLEMENT_FLAG"/>
<bm:field name="repayment_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REPAYMENT_FLAG" prompt="CSH101.CSH_BANK_ACCOUNT.REPAYMENT_FLAG"/>
<bm:field name="loan_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_FLAG" prompt="CSH101.CSH_BANK_ACCOUNT.LOAN_FLAG"/>
<bm:field name="settlement_flag_n" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false"/>
<bm:field name="repayment_flag_n" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false"/>
<bm:field name="loan_flag_n" databaseType="VARCHAR2" datatype="java.lang.String" forInsert="false" forUpdate="false"/>
</bm:fields>
<bm:operations>
<bm:operation name="query">
<bm:query-sql><![CDATA[
select t1.bank_account_id,
t1.bank_branch_id,
t1.bank_branch_code,
t1.bank_branch_name,
t1.bank_full_name,
t1.zero_amounts_allowed,
t1.bank_account_code,
t1.bank_account_name,
t1.bank_account_num,
t1.company_id,
t1.currency_code,
t1.currency_name,
t1.precision,
t1.enabled_flag,
t1.cash_account_id,
t1.cash_account_code,
t1.responsibility_center_id,
t1.responsibility_center_name,
t1.bank_account_type,
t1.bank_account_type_name,
t1.is_company_account,
t1.settlement_flag,
t1.repayment_flag,
t1.loan_flag,
decode(t1.settlement_flag,'Y','是','N','否') settlement_flag_n,
decode(t1.repayment_flag,'Y','是','N','否') repayment_flag_n,
decode(t1.loan_flag,'Y','是','N','否') loan_flag_n
from csh_bank_account_v t1
#WHERE_CLAUSE#
]]></bm:query-sql>
</bm:operation>
</bm:operations>
<bm:data-filters>
<bm:data-filter name="bank_branch_id" enforceOperations="query" expression="bank_branch_id=${@bank_branch_id}"/>
<bm:data-filter name="enabled_flag" enforceOperations="query" expression="enabled_flag='Y'"/>
</bm:data-filters>
<bm:features>
<f:standard-who/>
<o:sequence-pk/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="bank_account_id"/>
</bm:primary-key>
<e:exception-descriptor-config>
<e:exception-descriptor exception="java.sql.SQLException" handleClass="leaf.database.SQLExceptionDescriptor">
<e:error-message code="1" message="CSH101.ERROR.BANK_ACCOUNT_CODE_REPEATED"/>
</e:exception-descriptor>
</e:exception-descriptor-config>
</bm:model>