<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
 "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="SMP001">

	<!-- データ取得 -->
	<!-- 入出金テーブル -->
	<select id="selectNyusyukkin"
		resultClass="jp.terasoluna.batch.tutorial.common.NyusyukkinData">
		SELECT
		SHITENNAME AS "shitenName"
		,KOKYAKUID AS "kokyakuId"
		,NYUSYUKKINKUBUN AS "nyusyukkinKubun"
		,KINGAKU AS "kingaku"
		,TORIHIKIBI AS "torihikibi"
		FROM
		NYUSYUKKINTBL
	</select>
</sqlMap>