Miscellaneous Reports

From Vital Soft Wiki
Revision as of 22:21, 24 May 2021 by Johno (talk | contribs)
Jump to: navigation, search

CMNDXREF History Command Cross Reference File - In-house Clients

  • Build an SD Indexed file called CMNDXREF on the Host. This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers.
  • The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.
  • Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.
  • This version requires copying the CMNDFILE and is recommended for In-house clients only.
Sample Report Output

HISTRY.SH-HISTORY.ENTRY-DATE = #MONTH-LIST(@) and
HISTRY.SH-HISTORY.TYPE = 100 and
CMNDXREF.CMNDXREF.CHAR-COMMAND = "SHDP"


Notes:

#MONTH-LIST(@) is a global array variable that and loads an entire month's worth of dates allowing
a keyed read.

TYPE 100 selects monetary transactions

SHDP is stored in HISTRY.SH-HISTORY.COMMAND as the number 15


DATE: 05/21/2021        TIME: 11:42 AM                                        Page: 1
 
                                  SHDP Transactions
 
CHAR-COMMAND COMMAND     ACCOUNT SUFFIX       AMOUNT-SH TELLER-INTL ENTRY-DATE
 
        SHDP      15         472     00         700.00         92D3 09-30-2002
        SHDP      15        2972     15          30.92         68D3 09-06-2002
        SHDP      15        3653     16          49.57         67D3 09-05-2002
        SHDP      15        3757     10         700.00         92D3 09-30-2002
        SHDP      15        3757     10       1,000.00         BOP  09-05-2002
        SHDP      15        4061     16          37.08         67D3 09-05-2002
        SHDP      15        5138     16          25.00         68D3 09-06-2002
        SHDP      15        6101     16          28.00         68D3 09-06-2002
        SHDP      15        6917     15         138.22         68D3 09-06-2002
        SHDP      15        7189     16          52.44         68D3 09-06-2002
        SHDP      15        7212     16       2,102.98         68D3 09-06-2002
        SHDP      15        7228     16          11.12         68D3 09-06-2002
        SHDP      15        7228     16         100.00         BOP  09-10-2002

Download CMNDXREF History Command Cross Reference File - In-house Clients
Created: 2021/05/21

CMNDXREF History Command Cross Reference File - ASP Clients

  • Build an SD Indexed file called CMNDXREF on the Host. This file is used to cross reference the numeric data that is stored in the HISTRY.SH-HISTORY.COMMAND and the HISTRY.LN-HISTORY.COMMAND fields, with the character commands entered by the tellers.
  • The CMNDXREF file should be added to the Visimage environment file so that it is accessible to all Visimage users. This file makes reporting HISTRY records easier by printing the CHAR-COMMAND (eg “FLAG”) instead of actual command number (79), that is stored in the database.
  • Do NOT use CHAR-COMMAND when selecting HISTRY records as it will dramatically slow down the selection.
  • This version loads commands from a CSV file and is recommended for ASP clients.
Sample Report Output

{{{results}}}

Download CMNDXREF History Command Cross Reference File - ASP Clients
Created: 2021/05/24

Response File Responses

  • Reports responses for Quest-Code = REGEDATE, REGEMTHD, REGEACTN, REGENAME or REGECONF.
  • This context will report Response-File.Response for Response-File.Quest-Code entries matching : REGEDATE, REGEMTHD, REGEACTN, REGENAME or REGECONF.

Download Response File Responses
Created: 2016/09/01

XD3307

  • Script to create an SD indexed file from D3307 csv file.
  • The spectrum P3307 program creates a csv file called which contains several delinquent loan fields not stored in the MEMBRS database. This script converts the D3307 file into an SD indexed file that can be read by AskPlus and Visimage. Extract the install instructions which are stored inside the zip file.
Sample Report Output

Download XD3307
Created: 2016/09/01

GL-HISTORY-HOLD-FILE-COMBO

  • Created in LIST. Uses multipass reporting and contains 3 LISTS.
  • The first LIST, or pass, will ask for the GL ACCOUNT number and the date range for the transactions in the HISTORY-FILE and outputs to a HOST file called GLCOMBO. The second LIST will select all records for the GL ACCOUNT number entered in the first list and append the information to the GLCOMBO file. The third and final LIST uses the GLCOMBO file to report all entries from the HISTORY-FILE and the HOLD-FILE for the given GL ACCOUNT.

Download GL-HISTORY-HOLD-FILE-COMBO
Created: 2016/09/01

REVERSE-NAME-ADD-SLASH

  • Created in REPORT. Names stored FIRST-NAME LAST-NAME print as LAST-NAME/FIRST-NAME.
  • Names stored FIRST-NAME LAST-NAME print as LAST-NAME/FIRST-NAME. This is the same format as the MEMBER-FILE.NAME field is stored in the database.

Download REVERSE-NAME-ADD-SLASH
Created: 2016/09/01


Back to Context Library