Order Transfer Methods for File Interface

Infor M3 SWB offers two methods with which to transfer orders:

  • One common file (Single file).

    In this method all 4 record types are included in the same import file.  This includes manufacturing order headers (type O), operations (type R), material links (type M), and end item order records (type H).

  • Multiple files (Multi-file).

    In this method each of the 4 record types are placed in individual import files, that is, order headers, operations, material links and end item order headers.  It is not mandatory to transfer all 4 files.

    Infor M3 SWB automatically combines information from different files during the input process.

The names of the different import and export files are shown in the table below.

  Multi Files Import Multi Files
  Complete Incremental Job reporting Export
Order headers PMOTOTxx.DAT PMOINCxx.DAT PMOJOBxx.DAT PMOEXPxx.DAT
Operations PMRTOTxx.DAT PMRINCxx.DAT PMRJOBxx.DAT PMREXPxx.DAT
Material links PMMTOTxx.DAT PMMINCxx.DAT PMMJOBxx.DAT PMMEXPxx.DAT
End item headers PMHTOTxx.DAT PMHINCxx.DAT PMHJOBxx.DAT PMHEXPxx.DAT
     
  Single File Import Single File
  Complete Incremental Job reporting Export
Order headers PMORGExx.DAT PMORGIxx.DAT PMJBUFxx.DAT PMSCGExx.DAT
Operations do do do  
Material links do do do  
End item headers do do do  

Note: xx refers to the schedule version number.

For more detail on these files refer to these sections:

  • Import Files
  • Export Files

Import Files

There are three ways to configure import files in Infor M3 SWB:

  • Complete file import PMORGExx.DAT.  This is a total replacement of the entire existing database.

  • Incremental file import PMOGI1xx.DAT and PMOGI2xx.DAT). This is order data that replaces or adds to the existing database.

    Note: Existing records in the database can be updated with this interface file, but not deleted.

  • Job report file import PMJBUFxx.DAT.  You can use the job reporting import file to modify values in existing fields. The job report import file uses the same layout as order import files.

    Note: Existing records in the database can be updated with this interface file, but not deleted.

The fields with the symbol [xx] refer to the schedule version number.  During the input, several validations are conducted. Validation operations can include:

  • A check of the formal record layout for all field types
  • A check to see if certain field values have been allowed
  • A check to see if the records are sequenced correctly
  • Warnings referring to capacity data (for example that a work center was not defined correctly).

Infor M3 SWB records all errors and warnings due to bad data in the import file in the spool file.  If any records have been dropped during data input, then these records are listed in the PMORGSxx.DAT file (scrap file).

If file input has been suspended due a series of errors, then all errors and warnings are reported to a general log file that is called PMLOGS99.DAT. When you exit Infor M3 SWB the log file is renamed LTTTTTTT.DAT. The T is an expression of the time at which the file was last created. Each time Infor M3 SWB is started a new log file is opened. The file most recently created has the highest value of T.

Note:  You must delete old log files to avoid confusion.

After a file has specified Infor M3 SWB, a network check function is performed. This function checks the validity of the relationship between orders and calculates low-level codes and internal priorities. These codes and priorities control the sequence in which orders are scheduled during automatic finite capacity scheduling. You can also invoke these functions independently. This will, for example, enable you to check manual or incremental modifications or to redo internal priority calculations.

Export Files

There are two fundamental ways to configure an export file in Infor M3 SWB:

  • Order Export Standard. Output file: PMSCGExx.DAT

    By using the standard selection for the export file your output records shows all fields. The file format is exactly the same as the format for the PMORGExx.DAT file.

    Because the layout of the export record is configured in the same way as the layout of the import record this function can be used to regenerate the order database if it becomes corrupted.

    Order data is extracted by using delimiters between fields, for example, [;]. You can choose the standard format or you can create your own path by redefining a control panel. In addition, you can specify how much output you want and how you want it to be organized (by type of record, time horizon, etc.).

  • Order Export Panel. Output file: PMSGEP__.SPL

    By using the panel selection for the export file the amount of data written to the output file can be decreased. The user can decide which fields to be exported by changing the panel definition file, PMSGEP__.SKM. This file is located in the NN/Panels folder under Infor M3 SWB folder, where NN is the national language of the Infor M3 SWB installation.
    Note: This output file does not depend on the schedule version. Only one output file can be used at a time.