Differences

This shows you the differences between two versions of the page.

--- pub:ipayment [2021/08/06 18:24] – [Installation] kkramer
+++ pub:ipayment [2022/06/25 17:02] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-[[Epay | Epay Module to iACH ]]\\
+[[start#iach | iACH ]]\\
 ====== iPayment Module ======
@@ Line 12: / Line 12: @@
-===== Configuration =====
+===== iPayment Menu =====
-Below is a sample configuration screen for Epay.
+Below is the Main menu screen for iPayment.
 <html><pre>
-/10/11                           iACH 1.0                          IA1000S2
+ IPAYMENT            ACH iPayment Solution  6.95 07.15.20
-:44:23                 Work with iACH Applications                 DYOKANA
- Application:  SAMPLECFG  Description: Sample Configuration
+ Select one of the following:
- Communications Configuration:                           ACH Library: CMSFIL
+. Work with ACH Definitions                                  CALL AC1000R
-                                                         ACH File. .: PRPACHA
+. Work with ACH Applications                                 CALL AC2000R
- Baud Rate: 9600                                         Routing Nbr: 031207584
+. Work with ACH Files                                        CALL AC4000R
- Phone. . : T:18005551212     Modem Device: IACH         Bank File  : BANKMSTR
+. Work with Database Connections                             CALL AC6000R
-                                                         Bank Libr  : QGPL
+. Work with Payees                                           CALL AC1200R
- Sign on Configuration:
+. Purge ACH Transactions                                     CALL AC8000R
-                                                         Partner ID : 0001
-                                                         Program ID : 0002
-                                                         Sec Lbl ID : 28
-                                                         Sec Lbl Val: Y
-                                                         TYPE 28 DEFAULT
-                                                         Use Type 23: Y
+. Merge ACH Definition with External Database                IMRGACHDB
-                                                         TYPE 23 DEFAULT
+. Merge ACH Definition with Spool File                       IMRGACHSPL
- Report Configuration: Outqueue: PRT01       Save: Y     Emp Master : PRPMST1
-                          Library: QUSRSYS    Hold: Y    Emp Libr   : EPAY
+. Work with Selected Access Groups                           CALL AC9100R
+. Selected Access Authorization                              CALL AC9000R
+ Selection or command
+ ===>
+ F3=Exit   F4=Prompt   F9=Retrieve   F12=Cancel
+ F13=Information Assistant  F16=System main menu
- F3=Exit   F10=Save   F12=Cancel
 </pre></html>
-  * **ACH File and Library**: This is the CGC ACH file, or copy thereof, that will be processed by the Epay module.
-  * **Routing Number**:  Bank account to search for in ACH file.
-  * **Bank File and Library**: Output Epay file.
-  * **Partner ID**: Written into the header record, record type 01, as the PARTNER_ID.
-  * **Program ID**: Written into the header record, record type 03, as the PROGRAM_ID.
-  * **Secondary Label ID**: Written into record type 72 as SECOND_ID. The value (below) is the company name from SYSCNC.
-  * **Secondary Label Value**:
-<html><div style="border: 1px solid gray; padding: 5px;">
-Secondary Label Value - First 20 characters written into the header record, record type 01, as the FILE_NAME.<br/>
-If a company record is not found in SYSCNC, this is written into record type 09 as PASS_THROUGH, and<br/>
-record type 72 as SECOND_VALUE
-</div></html>
-\\
-  * **Use Type 23**: Y/N Write an additional type 72 record with trancode 23 following the secondary label id above.
-This field is populated with company number concatenated with division number from the CGC file SYSCNC.
-Use the value on the following line as the default in the event a record is not found in SYSCNC.
-  * **Employee Master File and Library**: A logical file built on PRPMST in the installation section of these instructions. The name specified here should be the name used in the logical file creation.
@@ Line 66: / Line 50: @@
-===== File Creation =====
+==== 4. Work with Database Connections  ====
-Program IAR2000 concatenates the members of the CGC ACH file PRPACH into one member with name PRPACH. It then invokes IAR2100, which creates the Epay files. IAR2000 then recalculates the totals records in the original file to provide for the removal of records to the Epay file. The result of the processing is PRPACH with Epay records deleted, and the Epay file itself.
-The output files are two undefined files ( flat files ): the reworked CGC file PRPACH 94 bytes in length, and the Epay file at 401 bytes length.
+<html><pre>
+/06/21                   ACH iPayment Solutions                    AC6000C1
+:31:59              Work with Database Connections                 KKRAMER
+ Type options, press Enter.
+=Edit   3=Copy   4=Delete   7=Rename   8=Work with Map Fields   9=Conditions
+ Position to              Name, *START
+ Opt  Connection  Description                      Creation/Update Log Info.
+      ADELACHDBC  Adellines ACH DB Connector       OFERRER      6/08/2021  11:57
+      DEMOACH     Florida Outdoors                 ANGUYEN      5/05/2014  14:12
+      TEST                                         ANGUYEN      1/28/2013  12:53
+   TESTCONN    Test connection                  ANGUYEN      1/14/2013  10:25
+                                                                         Bottom
+ F3=Exit   F5=Refresh   F6=Add
+</pre></html>
-IAR2100 processes scans all the records in PRPACH and selects records of transaction amount 0, bank r/t equal to the specified r/t, and a transaction code of 23 ( checking account credit prenotification ). Employee information is pulled from the defined employee file. Company information is pulled from SYSCNC.
+The database file should be setup in a Database connection because it requires the constraint mapping between database field and ACH fields.
-Verbose Processing: If the data area **DSEPAYVERB** is 'Y' IAR2100 will write into the job log information about what it is doing. If it is set to 'N' it will not.
+<html><pre>
+/06/21                   ACH iPayment Solutions                    AC6000R5
+:33:48                  Maintain a DB Connection                   KKRAMER
+ DB Connection . . . . : TESTCONN   Description: Test connection
+ Host name/address . . : *LOCAL                               *LOCAL, IP or Name
+ File  . . . . . . . . : PAYEETEST  Library  . : IDOCSACH     *LIBL, Name
+ Settings for remote host:
+ Port  . . . . . . . . :        Number
+ User name . . . . . . :                 Name
+ Password  . . . . . . :                       Confirm Password:
+ Connection Time-out . :   60  Second
+ Connection Statement .:
+ Connection Driver . . :
+  F3=Exit   F4=Prompt   F10=Save   F12=Cancel
+</pre></html>
+----
+==== Work with Database Map Fields  ====
+Select the Connection with option 8
+<html><pre>
+/06/21                   ACH iPayment Solutions                    AC6000C1
+:49:12              Work with Database Connections                 KKRAMER
+ Type options, press Enter.
+=Edit   3=Copy   4=Delete   7=Rename   8=Work with Map Fields   9=Conditions
+ Position to              Name, *START
+ Opt  Connection  Description                      Creation/Update Log Info.
+      ADELACHDBC  Adellines ACH DB Connector       OFERRER      6/08/2021  11:57
+      DEMOACH     Florida Outdoors                 ANGUYEN      5/05/2014  14:12
+      TEST                                         ANGUYEN      1/28/2013  12:53
+   TESTCONN    Test connection                  ANGUYEN      1/14/2013  10:25
+                                                                         Bottom
+ F3=Exit   F5=Refresh   F6=Add
+</pre></html>
+<html><pre>
+/06/21                   ACH iPayment Solutions                    AC6100C1
+:45:18              Work with Database Map Fields                  KKRAMER
+                       File: PAYEETEST  Library: IDOCSACH
+ Database Connection . . TESTCONN
+ Type options, press Enter.
+=Edit   4=Delete
+ Position to              Name, *START
+ Opt  Name        Function    Description                          Len Type Dec
+      CHECKAMT    DCHECKAMT   Check amount                          15   P   5
+      CHECKAMT    *NONE       Check amount                          15   P   5
+      CHECKNUM    DCHECKNBR   Check number                          10   A   5
+      CHECKNUM    *NONE       Check number                          10   A   5
+      PAYEEACC    DPAYEEACC   Payee Account                         20   A   5
+      PAYEEACC    DBNKTRNS#   Payee Account                         20   A   5
+      PAYEEIDN    DPAYEEID    Payee ID in numeric                    7   S   0
+      PAYEENAM    DPAYEENAME  Payee Name                            50   A   0
+      PAYMDATE    *NONE       Payment Date                           7   S   0
+      PAYMENTYPE  DTRNCODE    Payment Type                           3   A   0
+      PAYORID     HPAYORID    Payor Company ID                      20   A   0
+                                                                        More...
+ F3=Exit   F5=Refresh   F6=Add   F9=Condition
+</pre></html>
+==== Merge ACH with dbase and Email ====
+Merge ACH with dbase and Email (ACHDBEML) 6.97 08/06/2021
+<html><pre>
+                    Merge ACH with dbase and Email (ACHDBEML)
+ Type choices, press Enter.
+ ACH Definition . . . . . . . . .   achdemo       Name
+ Database connection  . . . . . .   testconn      Name
+ Effective Date (YYMMDD)  . . . .   *FORMD        Character value, *FORMD
+ From: eMail address  . . . . . .
+ To: eMail address  . . . . . . .   info@bankofmoney.com
+                + for more values
+ CC: eMail address  . . . . . . .
+                + for more values
+                                                                        More...
+ F3=Exit   F4=Prompt   F5=Refresh   F12=Cancel   F13=How to use this display
+ F24=More keys
+</pre></html>
 ----
 <html>&#091;</html>[[start#iach | Up to Main Menu ]]<html>&#093;</html>
+----