Inbound product lookup FTM node

This node determines the inbound product code (ibmValProductId) and the batch (ICL) priority (ibmValDepositPriority).

The node searches its tables until it finds the data. Each table is checked, in turn, if the prior lookup fails to find the data.

Node descriptor

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<nodeDescriptor name="DepositProductLookupFtmNode" type="ESORT">
  <assignments>
    <assignment field="ibmValProductId" type="string" value="DFLT"/>
    <assignment field="ibmValDepositPriority" type="decimal" value="0"/>
        <!-- override TCHI product code with TCHS when      -->
        <!-- ibmValFileDestinationRT != ibmValFileOriginRT  -->
        <!-- (Both sides of txn are on-us)                  -->
    <assignment field="ibmValProductId" type="string" value="TCHS" executionPoint="onExit" 
                conditions="ibmValProductId EQ 'TCHI', ibmValFileDestinationRT EQ ibmValFileOriginRT"/>
    <assignment field="ibmValProductId" type="ReturnToClient" executionPoint="onExit"/>
    <assignment field="ibmValDepositPriority" type="ReturnToClient" executionPoint="onExit"/>
  </assignments>
  <tasks>
    <task name="DepositProductLookupCpaTask"/>
    <task name="DepositProductLookupWebSrvTask"/>
    <task name="DepositProductLookupRtnsTask"/>
    <task name="DepositProductLookupTask"/>
    <task name="DepositProductLookupCtFtmTask"/>
    <task name="DepositProductLookupOrigTask"/>
    <task name="DepositProductLookupFtmTask"/>
    <task name="DepositProductLookupMsgStdTask"/>
  </tasks>
  <connections>
    <connection srcName="CONDITIONAL_START" dstName="DepositProductLookupCpaTask">
      <paymentCheck field="ibmFileType" operator="EQ" value="CPA"/>
    </connection>
    <connection srcName="CONDITIONAL_START" dstName="DepositProductLookupWebSrvTask">
      <paymentCheck field="ibmFileType" operator="EQ" value="FTM_DP"/>
    </connection>
    <connection srcName="CONDITIONAL_START" dstName="DepositProductLookupRtnsTask">
      <paymentCheck and="true" field="ibmFileType" operator="NE" value="CPA"/>
      <paymentCheck            field="ibmFileType" operator="NE" value="FTM_DP"/>
    </connection>
    <connection srcName="DepositProductLookupCpaTask"    dstName="DepositProductLookupRtnsTask"   results="FAILURE"/>
    <connection srcName="DepositProductLookupRtnsTask"   dstName="DepositProductLookupTask"       results="FAILURE"/>
    <connection srcName="DepositProductLookupTask"       dstName="DepositProductLookupCtFtmTask"  results="FAILURE"/>
    <connection srcName="DepositProductLookupCtFtmTask"  dstName="DepositProductLookupOrigTask"   results="FAILURE"/>
    <connection srcName="DepositProductLookupWebSrvTask" dstName="DepositProductLookupOrigTask"   results="SUCCESS"/>
    <connection srcName="DepositProductLookupOrigTask"   dstName="DepositProductLookupFtmTask"    results="FAILURE"/>
    <connection srcName="DepositProductLookupFtmTask"    dstName="DepositProductLookupMsgStdTask" results="FAILURE"/>
  </connections>
</nodeDescriptor>

Tables

Table 1. Inbound product table
Field name	Field type	Data type	Length	Description
ibmValCollectType	key	byte	2	Field 2 of the X9 – cash letter record.
ibmValFedWorkType	key	char	2	Field 13 of the X9 – cash letter record.
ibmValProductId	payload	char	4	The inbound product code.
ibmValDepositPriority	payload	byte	2	The batch (ICL) priority.

Table 2. Inbound product customer type table
Field name	Field type	Data type	Length	Description
ibmNprMessageTypeNameIn	key	char	12	The NAME column from the PAYMENT_MESSAGE_TYPE table.
ibmValCustomerType	key	char	1	The CUSTOMER_TYPE column from the PARTNER table.
ibmValProductId	payload	char	4	The inbound product code.
ibmValDepositPriority	payload	byte	2	The batch (ICL) priority.
ibmValProductDesc	payload	char	80	Description of the inbound product.

Table 3. Inbound product FTM table
Field name	Field type	Data type	Length	Description
ibmNprMessageTypeNameIn	key	char	12	The NAME column from the PAYMENT_MESSAGE_TYPE table.
ibmValProductId	payload	char	4	The inbound product code.
ibmValDepositPriority	payload	byte	2	The batch (ICL) priority.
ibmValProductDesc	payload	char	80	Description of the inbound product.

Table 4. Inbound product message standard table
Field name	Field type	Data type	Length	Description
ibmNprStandardNameIn	key	char	12	The NAME column from the PAYMENT_STANDARD_TYPE table.
ibmValCustomerType	key	char	1	The CUSTOMER_TYPE column from the PARTNER table.
ibmValProductId	payload	char	4	The inbound product code.
ibmValDepositPriority	payload	byte	2	The batch (ICL) priority.
ibmValProductDesc	payload	char	80	Description of the inbound product.