AP PAYMENT CHECK DETAILS (XML REPORT)

=============  DATA TEMPLATE FOR CHECK ==============

<?xml version="1.0" encoding="UTF-8" ?>
<dataTemplate name="AP_INV_CHK" description="ITC CHECK" version="1.0">
  <dataQuery>
    <sqlStatement name="ITC_CHK_QUERY">
        <![CDATA[SELECT  AIA.INVOICE_NUM,AIPA.AMOUNT CHECK_AMOUNT,AP_AMOUNT_UTILITIES_PKG.ap_convert_number(AIPA.AMOUNT)||' Rupess Only' AMOUNT,AIPA.BANK_ACCOUNT_NUM,ACA.CHECK_NUMBER,
ACA.VENDOR_NAME,ASSA.VENDOR_SITE_CODE
,ASSA.ADDRESS_LINE1,ASSA.ADDRESS_LINE2,ASSA.ADDRESS_LINE3,ASSA.CITY,ASSA.STATE,ASSA.ZIP,ASSA.PROVINCE,ASSA.COUNTRY
,CBBV.BANK_NAME,CBBV.BANK_BRANCH_NAME
,CBBV.ADDRESS_LINE1 BANK_ADDRESS_LINE1
,CBBV.ADDRESS_LINE2 BANK_ADDRESS_LINE2
,CBBV.ADDRESS_LINE3 BANK_ADDRESS_LINE3
,CBBV.CITY BANK_CITY,CBBV.STATE BANK_STATE,CBBV.ZIP BANK_ZIP,CBBV.PROVINCE BANK_PROVINCE,CBBV.COUNTRY BANK_COUNTRY
FROM
 AP_INVOICES_ALL AIA
,AP_INVOICE_PAYMENTS_ALL AIPA
,AP_CHECKS_ALL ACA
,AP_SUPPLIER_SITES_ALL ASSA
,CE_BANK_ACCT_USES_ALL CBAUA
,CE_BANK_ACCOUNTS CBA
,CE_BANK_BRANCHES_V CBBV
WHERE 1=1
AND AIA.INVOICE_NUM='ITC40'
AND AIA.INVOICE_ID=AIPA.INVOICE_ID
AND AIPA.CHECK_ID=ACA.CHECK_ID
AND AIA.VENDOR_SITE_ID=ASSA.VENDOR_SITE_ID
AND ACA.CE_BANK_ACCT_USE_ID=CBAUA.BANK_ACCT_USE_ID
AND CBAUA.BANK_ACCOUNT_ID=CBA.BANK_ACCOUNT_ID
AND CBA.BANK_BRANCH_ID=CBBV.BRANCH_PARTY_ID]]>
    </sqlStatement>
  </dataQuery>
  <dataStructure>
    <group name="ITC_CHECK" source="ITC_CHK_QUERY">      
         <element name="INVOICE_NUM" value="INVOICE_NUM" />
         <element name="CHECK_AMOUNT" value="CHECK_AMOUNT" />
         <element name="BANK_ACCOUNT_NUM" value="BANK_ACCOUNT_NUM" />
         <element name="CHECK_NUMBER" value="CHECK_NUMBER" />
         <element name="VENDOR_NAME" value="VENDOR_NAME" />
         <element name="VENDOR_SITE_CODE" value="VENDOR_SITE_CODE" />
         <element name="ADDRESS_LINE1" value="ADDRESS_LINE1" />
         <element name="ADDRESS_LINE2" value="ADDRESS_LINE2" />
         <element name="ADDRESS_LINE3" value="ADDRESS_LINE3" />
         <element name="CITY" value="CITY" />
         <element name="STATE" value="STATE" />
         <element name="ZIP" value="ZIP" />
         <element name="PROVINCE" value="PROVINCE" />
         <element name="COUNTRY" value="COUNTRY" />
         <element name="BANK_NAME" value="BANK_NAME" />
         <element name="BANK_BRANCH_NAME" value="BANK_BRANCH_NAME" />
         <element name="BANK_ADDRESS_LINE1" value="BANK_ADDRESS_LINE1" />
         <element name="BANK_ADDRESS_LINE2" value="BANK_ADDRESS_LINE2" />
         <element name="BANK_ADDRESS_LINE3" value="BANK_ADDRESS_LINE3" />
         <element name="BANK_CITY" value="BANK_CITY" />
         <element name="BANK_STATE" value="BANK_STATE" />
         <element name="BANK_ZIP" value="BANK_ZIP" />
         <element name="BANK_PROVINCE" value="BANK_PROVINCE" />
         <element name="BANK_COUNTRY" value="BANK_COUNTRY" />
    </group>
  </dataStructure>
</dataTemplate>


based on above data template the following XML Tags are generated.
======================= XML TAGS FOR CHECK DESIGN  ====================
<?xml version="1.0" encoding="UTF-8"?>

<AP_INV_CHK>
<LIST_ITC_CHECK>
<ITC_CHECK>
<INVOICE_NUM>ITC40</INVOICE_NUM>
<CHECK_AMOUNT>108.52</CHECK_AMOUNT>
<AMOUNT>One hundred nine Rupess Only</AMOUNT>
<BANK_ACCOUNT_NUM>10271-17621-619</BANK_ACCOUNT_NUM>
<CHECK_NUMBER>1008</CHECK_NUMBER>
<VENDOR_NAME>3M Health Care</VENDOR_NAME>
<VENDOR_SITE_CODE>CORP HQ1</VENDOR_SITE_CODE>
<ADDRESS_LINE1>1000000 3M Way</ADDRESS_LINE1>
<ADDRESS_LINE2/>
<ADDRESS_LINE3/>
<CITY>St. Paul</CITY>
<STATE>MN</STATE>
<ZIP>55144</ZIP>
<PROVINCE/>
<COUNTRY>US</COUNTRY>
<BANK_NAME>Bank of America</BANK_NAME>
<BANK_BRANCH_NAME>New York</BANK_BRANCH_NAME>
<BANK_ADDRESS_LINE1>6788 Wall Street</BANK_ADDRESS_LINE1>
<BANK_ADDRESS_LINE2/>
<BANK_ADDRESS_LINE3/>
<BANK_CITY>New York</BANK_CITY>
<BANK_STATE>New York</BANK_STATE>
<BANK_ZIP>05443</BANK_ZIP>
<BANK_PROVINCE/>
<BANK_COUNTRY>US</BANK_COUNTRY>
</ITC_CHECK>
</LIST_ITC_CHECK>
<LIST_ITC_CHECK>
<ITC_CHECK>
<INVOICE_NUM>ITC40</INVOICE_NUM>
<CHECK_AMOUNT>20000</CHECK_AMOUNT>
<AMOUNT>Twenty Thousands Rupess Only</AMOUNT>
<BANK_ACCOUNT_NUM>10271-17621-619</BANK_ACCOUNT_NUM>
<CHECK_NUMBER>1009</CHECK_NUMBER>
<VENDOR_NAME>Talasila Gowthami</VENDOR_NAME>
<VENDOR_SITE_CODE>CORP HQ</VENDOR_SITE_CODE>
<ADDRESS_LINE1>100 3M Way</ADDRESS_LINE1>
<ADDRESS_LINE2/>
<ADDRESS_LINE3/>
<CITY>St. Paul</CITY>
<STATE>MN</STATE>
<ZIP>55144</ZIP>
<PROVINCE/>
<COUNTRY>US</COUNTRY>
<BANK_NAME>Bank of America</BANK_NAME>
<BANK_BRANCH_NAME>New York</BANK_BRANCH_NAME>
<BANK_ADDRESS_LINE1>6788 Wall Street</BANK_ADDRESS_LINE1>
<BANK_ADDRESS_LINE2/>
<BANK_ADDRESS_LINE3/>
<BANK_CITY>New York</BANK_CITY>
<BANK_STATE>New York</BANK_STATE>
<BANK_ZIP>05443</BANK_ZIP>
<BANK_PROVINCE/>
<BANK_COUNTRY>US</BANK_COUNTRY>
</ITC_CHECK>
</LIST_ITC_CHECK>
</AP_INV_CHK>

based on the above tags design check as below

=====================  CHECK DESIGN IN .rtf FILE ======================

HERE ARE SAMPLE DESIGN

----------------------------------

client has to purchase MICR Code

for free MICR Code refer

http://www.fontspace.com/digital-graphics-labs/micr-encoding