<table>

<!-- 帳票レイアウトテーブル(GE52) 作成 -->
<tr><td width="150px">
<og:link gamenId="REP03" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP03}
</og:link></td>
<td width="100px">GE52.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select LISTID,KBTEXT,CLM,SEQ,START_POS,USE_LENGTH,FGUSE,RDC_CODE,RELEASE_NOTES,SYSTEM_ID,
			   FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
		from GE52
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
	</og:where>
		order by SYSTEM_ID,LISTID,KBTEXT,SEQ
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE52.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE52" />
	<og:writeTableParam key="First" >
		delete from GE52 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
	</og:writeTableParam>
</og:writeTable>

<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- 振り分け条件マスタ(GE53) 作成 -->
<tr><td>
<og:link gamenId="REP04" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP04}
</og:link></td>
<td width="100px">GE53.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select JOKEN,PRTID,FGRUN,DMN_GRP,PRGDIR,PRGFILE,COMMENTS,SYSTEM_ID,LANG,DMN_TIME,RDC_CODE,RELEASE_NOTES,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
		from GE53
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ       = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
	</og:where>
		order by SYSTEM_ID,JOKEN
  </og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE53.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE53" />
	<og:writeTableParam key="First" >
		delete from GE53 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
	</og:writeTableParam>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>


<!-- 帳票定義マスタ(GE54) 作成 -->
<tr><td>
<og:link gamenId="REP05" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP05}
</og:link></td>
<td width="100px">GE54.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select LISTID,LISTNAME,MODELDIR,MODELFILE,FGCUT,HSQL,FSQL,BSQL,COMMENTS,FGLOCAL,FGDIRECT,RDC_CODE,RELEASE_NOTES,SYSTEM_ID,FGJ,DYUPD
		from GE54
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ        = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
	</og:where>
		order by SYSTEM_ID,LISTID
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE54.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE54" />
	<og:writeTableParam key="First" >
		delete from GE54 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
	</og:writeTableParam>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>


<!-- 出力先マスタ(GE55) 作成 -->
<tr><td>
<og:link gamenId="REP06" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP06}
</og:link></td>
<td width="100px">GE55.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select PRTID,PRTNM,PORTNM,COMMENTS,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
		from GE55
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ        = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
	</og:where>
		order by SYSTEM_ID,PRTID
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE55.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE55" />
	<og:writeTableParam key="First" >
		delete from GE55 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
	</og:writeTableParam>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>


<!-- 雛形明細定義テーブル(GE57) 作成 -->
<tr><td>
<og:link gamenId="REP11" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@RDC_CODE},{@RELEASE_NOTES},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP11}
</og:link></td>
<td width="100px">GE57.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select LISTID,SHEETNO,SHEETREF,HEADDBID,BODYDBID,LOOPCLM,SYSTEM_ID,RDC_CODE,RELEASE_NOTES,
			FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
		from GE57
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		and   FGJ        = '1'
	<og:where startKey="and">
		<og:and value = "RDC_CODE   = '{@RDC_CODE}'"  />
	</og:where>
		order by SYSTEM_ID,LISTID,SHEETNO
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE57.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE57" />
	<og:writeTableParam key="First" >
		delete from GE57 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		<og:where startKey="and"><og:and value = "RDC_CODE='{@RDC_CODE}'" /></og:where>
	</og:writeTableParam>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>

<!-- RFIDレイアウトテーブル(GE58) 作成 -->
<tr><td>
<og:link gamenId="REP14" href="index.jsp" target="CONTENTS" 
	keys="command,SYSTEM_ID,DYUPDFROM,DYUPDTO" 
	vals="NEW,{@SYSTEM_ID},{@DYUPDFROM},{@DYUPDTO}" >{@LBL.REP14}
</og:link></td>
<td width="100px">GE58.xml</td>

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}" dbid="{@DBID}">
		select LISTID,CLM,KBOUT,
			DATA1,DATA2,DATA3,DATA4,DATA5,DATA6,DATA7,DATA8,DATA9,DATA10,DATA11,DATA12,DATA13,DATA14,DATA15,
			SYSTEM_ID,FGJ,DYSET,DYUPD,USRSET,USRUPD,PGUPD
		from GE58
		where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
		order by SYSTEM_ID,LISTID,LISTID,CLM
</og:query>

<og:writeTable
	fileURL        = "{@DIR}"
	filename       = "GE58.xml"
	writerClass    = "XML"
	encode         = "UTF-8" >
	<og:writeTableParam key="TableName" value="GE58" />
	<og:writeTableParam key="First" >
		delete from GE58 where SYSTEM_ID in ( '{@SYSTEM_ID}','{@AST}' )
	</og:writeTableParam>
</og:writeTable>
<td width="100px"><og:text>{@DB.COUNT}</og:text></td>
</tr>


</table>
