inFORM Decisions Information Portal

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Data Base Field Retrieval (6.03+) ======

Add data from a defined data base.

The data base field retrieval requires F7=Map Field Settings. 

  * The mapped field must be a type 6.
  * The F7 key needs to be pressed to insure that the data base file has been defined.

<html><pre>
                       Map Field Settings                         
                                                                  
  Map Field . . . . ADB        Type . . 6 Database field retrieval
                                                                  
  1st Key:             2nd Key:              3rd Key:             
    Concatenate Key Fields into a Single String Key *NO           
                                                                  
  File . .               Library *LIBL         Member *FIRST      
  Extract data from field                Edit code                
    From column         To column                                 
  Or constant Value                                               
  F4=Prompt    F10=Save     F12=Previous                          
                                                                  
                                                                  
</pre></html>

====== Enhancement to convert PNG image to PCL and include into output PCL details (8.02 02/26/2026) ======

1. The process begans on the clients ERP system when a customer signs a credit card machine to capture the signature. Once the signature is captured, it will be saved to the predefined location on the IFS directory.

2. The customer service representative completes the ERP invoice process, which will trigger 1.) The creation of the spool file, and 2.) Evoke the merge process of the spool file and the Invoice Form Application.

3. The Merge Process can be evoked by the iDocs Engine (monitors an out queue to start the process) or by using the TFPRTAPI API. During the Merge Process, the Invoice Form Application will use the Mapped Field rules to extract the data from the spool file to use on the final document. During this process, we’ll need to trigger the captured signature image file to be pulled from the IFS directory (which we can pull from a static location or a dynamic location as long as the dynamic location appears on the spool file) and inserted in the documents based on a Mapped Field (Type 6). 

4. Once the Merge Process is complete, the output will be the PCL file which we will send to an out queue, and the originating spool file sent to an out queue for archive or secondary use.

5. From this point, a distribution option can be chosen dynamically via RPG programming or based on predefined static configurations.

https://manual.informdecisions.com/lib/exe/fetch.php?media=pub:idocs:sigimage_sigfolder_maptype6.pdf
----

<html>&#091;</html>[[configuredatamap#mapped_field_maintenance | Up To Mapped Field Maintenance ]]<html>&#093;</html>