TekPortal V3.00.003
Copyright (c) 2000-2003.  Teknowledge Corporation.  All Rights Reserved.

12/18/2003


Overview
- Transfers
  - ISSUE: File ID in ACH File Header
    RESOLUTION: Configurable Value for File ID in ACH File Header
  - ISSUE: Settlement Dates
    RESOLUTION: Global Settlement Dates.  New properties:
      TR.BH_CreditSettlementDateAdjustment=
      TR.BH_DebitSettlementDateAdjustment=
  - ISSUE: Business Day (remove time in compare)
      Holiday Table (was only picking up last entry)
    RESOLUTION: Fixed
- Aggregation
  - ISSUE:  Enhancement
    RESOLUTION:  Allow TP_ACCOUNT_TXN.TP_TXN_CATEGORY_ID to be scraped.
  - ISSUE:  Enhancement
    RESOLUTION:  Added optional 3rd argument (either "T" or "F") to the 
      Compare macro.  It controls whether to ignore case in the comparison.
      The default is "T" for backward compatibility.
  - ISSUE:  Enhancement
    RESOLUTION:  Added log level 7 messages for building snapshot of 
      TekScrape when it crashes.
  - ISSUE:  Duplicate transactions may result after account aggregation.
    RESOLUTION:  SQLParser converts tab characters to space characters.  When
      a transaction description contains a tab character, TekCapture would
      compare tab characters against space charact
- TekPortal APIs
  - ISSUE:  The TPGet_Account_History_Date_Range_V3 api returns extra rows
      of data.
    RESOLUTION:  Fixed the SQL.  Linked the TP_ACCOUNT_TXN and TP_TXN_CATEGORY
      tables in the WHERE clause.


Requirements
- TekPortal V3.0 Patch 002
                    

Installation Instructions
- Log on to each of the TekPortal Aggregation Server(s) and TekPortfolio
  Application Server(s)
- Solaris
  - Login as tekp
  - Bring down TekPortal with TekPortal/bin/StopServices.sh
  - uncompress -c TekPortal_V3.00.003.tar.Z | (cd /; tar -xvf -)
  - chown -R tekp:tekp /TekPortal/*
  - chmod -R 750 /TekPortal/*
  - Bring up TekPortal with TekPortal/bin/StartServices.sh
- Windows NT/2000
  - Bring down TekPortal with c:\TekPortal\bin\StopServices.cmd
  - Run TekPortal_V3.00.003.exe and extract to c:\
  - Bring up TekPortal with c:\TekPortal\bin\StartServices.cmd


Summary of Changes
- Note: The following are the specific files that have changed.  If you have
  made any custom modifications to these files, you will need to reapply
  those changes to these new versions; or else these versions will overwrite
  your custom modifications.
- TekPortalUtils.jar
  - ISSUE: Business Day (remove time in compare)
      Holiday Table (was only picking up last entry)
    RESOLUTION: Fixed
- TekPortal.cfg
  - ISSUE: Settlement Dates
    RESOLUTION: Global Settlement Dates.  New properties:
      TR.BH_CreditSettlementDateAdjustment=
      TR.BH_DebitSettlementDateAdjustment=
- TekTransfersAction.jar
  - ISSUE: Business Day (remove time in compare)
      Holiday Table (was only picking up last entry)
    RESOLUTION: Fixed
  - ISSUE: Settlement Dates
    RESOLUTION: Global Settlement Dates.  New properties:
      TR.BH_CreditSettlementDateAdjustment=
      TR.BH_DebitSettlementDateAdjustment=
  - ISSUE: File ID in ACH File Header
    RESOLUTION: Configurable Value for File ID in ACH File Header
- TekCapture.jar
  - ISSUE:  Enhancement
    RESOLUTION:  Allow TP_ACCOUNT_TXN.TP_TXN_CATEGORY_ID to be scraped.
- TekScrape.jar
  - ISSUE:  Enhancement
    RESOLUTION:  Added optional 3rd argument (either "T" or "F") to the 
      Compare macro.  It controls whether to ignore case in the comparison.
      The default is "T" for backward compatibility.
  - ISSUE:  Enhancement
    RESOLUTION:  Added log level 7 messages for building snapshot of 
      TekScrape when it crashes.
- TekGateway.jar
  - ISSUE:  The TPGet_Account_History_Date_Range_V3 api returns extra rows
      of data.
    RESOLUTION:  Fixed the SQL.  Linked the TP_ACCOUNT_TXN and TP_TXN_CATEGORY
      tables in the WHERE clause.
  - ISSUE:  Duplicate transactions may result after account aggregation.
    RESOLUTION:  SQLParser converts tab characters to space characters.  When
      a transaction description contains a tab character, TekCapture would
      compare tab characters against space character when checking for
      duplicate transactions.  Fixed SQLParser.
- TekLIMB.jar
  - ISSUE:  Enhancement
    RESOLUTION:  3.1 Support
- TekPortal.cfg
  - ISSUE: Settlement Dates
    RESOLUTION: Global Settlement Dates.  New properties:
      TR.BH_CreditSettlementDateAdjustment=
      TR.BH_DebitSettlementDateAdjustment=
  - ISSUE: File ID in ACH File Header
    RESOLUTION: Configurable Value for File ID in ACH File Header