$PBExportHeader$d_mbreqaplncont_detail_loan.srd
release 12.5;
datawindow(units=0 color=134217742 processing=0 print.canusedefaultprinter=yes print.margin.left=110 print.margin.right=110 print.margin.top=96 print.margin.bottom=96 )
header(height=184 )
detail(height=100 )
summary(height=0 )
footer(height=0 )
table(column=(name=coop_id dbname="mbreqaplncontdet.coop_id" dbalias=".coop_id" type=char(6) key=yes update=yes updatewhereclause=yes )
column=(name=appl_docno dbname="mbreqaplncontdet.appl_docno" dbalias=".appl_docno" type=char(10) key=yes update=yes updatewhereclause=yes )
column=(name=itemcont_code dbname="mbreqaplncontdet.itemcont_code" dbalias=".itemcont_code" type=char(3) key=yes update=yes updatewhereclause=yes )
column=(name=itemcont_desc dbname="mbreqaplncontdet.itemcont_desc" dbalias=".itemcont_desc" type=char(100) update=yes updatewhereclause=yes )
column=(name=area_amt dbname="mbreqaplncontdet.area_amt" dbalias=".area_amt" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=item_value dbname="mbreqaplncontdet.item_value" dbalias=".item_value" type=decimal(2) update=yes updatewhereclause=yes )
column=(name=itemobj_type dbname="mbreqaplncontdet.itemobj_type" dbalias=".itemobj_type" type=decimal(0) update=yes updatewhereclause=yes )
column=(name=remark dbname="mbreqaplncontdet.remark" dbalias=".remark" type=char(100) update=yes updatewhereclause=yes )
column=(name=item_signflag dbname="mbreqaplncontdet.item_signflag" dbalias=".item_signflag" type=decimal(0) update=yes updatewhereclause=yes )
column=(name=mastcoll_amt dbname="mbreqaplncontdet.mastcoll_amt" dbalias=".mastcoll_amt" type=decimal(2) update=yes updatewhereclause=yes )
retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"mbreqaplncontdet~" ) COLUMN(NAME=~"mbreqaplncontdet.coop_id~") COLUMN(NAME=~"mbreqaplncontdet.appl_docno~") COLUMN(NAME=~"mbreqaplncontdet.itemcont_code~") COLUMN(NAME=~"mbreqaplncontdet.itemcont_desc~") COLUMN(NAME=~"mbreqaplncontdet.area_amt~") COLUMN(NAME=~"mbreqaplncontdet.item_value~") COLUMN(NAME=~"mbreqaplncontdet.itemobj_type~") COLUMN(NAME=~"mbreqaplncontdet.remark~") COLUMN(NAME=~"mbreqaplncontdet.item_signflag~") COLUMN(NAME=~"mbreqaplncontdet.mastcoll_amt~")WHERE(    EXP1 =~"( ~~~"MBREQAPLNCONTDET~~~".~~~"APPL_DOCNO~~~"~"   OP =~"=~"    EXP2 =~":as_req_docno )~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"( ~~~"MBREQAPLNCONTDET~~~".~~~"COOP_ID~~~"~"   OP =~"=~"    EXP2 =~":as_coop_id )~"    LOGIC =~"and~" ) WHERE(    EXP1 =~"( ~~~"MBREQAPLNCONTDET~~~".~~~"ITEM_SIGNFLAG~~~"~"   OP =~"=~"    EXP2 =~"1 )~" ) ) ARG(NAME = ~"as_req_docno~" TYPE = string)  ARG(NAME = ~"as_coop_id~" TYPE = string)" update="mbreqaplncontdet" updatewhere=0 arguments=(("as_req_docno",string), ("as_coop_id",string))
)
text(name=t_3 band=header x="9" y="12" height="64" width="2542" alignment="2" border="2" color="0" text="รายสินทรัพย์ : " font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=t_7 band=header x="9" y="92" height="80" width="375" alignment="2" border="2" color="0" text="ประเภทรายการ" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=t_1 band=header x="398" y="92" height="80" width="626" alignment="2" border="2" color="0" text="เพิ่มเติมรายละเอียด" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=t_10 band=header x="1038" y="92" height="80" width="389" alignment="2" border="2" color="0" text="จำนวน/บ" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=t_2 band=header x="1865" y="92" height="76" width="686" alignment="2" border="2" color="0" text="หมายเหตุ" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
text(name=t_4 band=header x="1440" y="92" height="80" width="411" alignment="2" border="2" color="0" text="หลักประกัน" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="15780518" background.mode="2" )
button(name=b_addrow band=header x="2565" y="20" height="124" width="261" action="0" color="33554432" vtextalign="0" htextalign="0" text="เพิ่มแถว" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="67108864" background.mode="2" )
column(name=itemcont_code band=detail x="9" y="8" height="80" width="375" id=3 border="2" alignment="0" format="[general]" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="1073741824" background.mode="2" dddw.name=dddw_ucf_itemcontdet_1 dddw.displaycolumn=lnitem_desc dddw.datacolumn=lnitem_code dddw.percentwidth=0 )
column(name=itemcont_desc band=detail x="407" y="8" height="80" width="617" id=4 border="2" alignment="0" format="[general]" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="1073741824" background.mode="2" edit.autoselect=no edit.focusrectangle=no )
column(name=remark band=detail x="1865" y="4" height="80" width="677" id=8 border="2" alignment="0" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="1073741824" background.mode="2" edit.autoselect=no edit.focusrectangle=no )
column(name=item_value band=detail x="1038" y="8" height="80" width="389" id=6 border="2" alignment="1" format="#,##0.00" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="1073741824" background.mode="2" edit.autoselect=no edit.focusrectangle=no )
column(name=mastcoll_amt band=detail x="1440" y="8" height="80" width="411" id=10 border="2" alignment="1" format="#,##0.00" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="1073741824" background.mode="2" edit.autoselect=no edit.focusrectangle=no )
button(name=b_delrow band=detail x="2555" y="4" height="92" width="229" action="0" color="33554432" vtextalign="0" htextalign="0" text="ลบแถว" font.face="MS Sans Serif" font.height="-10" font.charset="222" background.color="67108864" background.mode="2" )