Parameter file for data transfer

M3 SWB data transfer procedure is flexible and the interface easily adapted to different user environments. The process is controlled by user defined parameter files and independent files are created for each record type. You can control the number and sequence of fields in each record and insert standard values into selected fields.

The parameter file PMOTRA.FID controls the layout of the input and export files, and is found in the M3 SWB Control directory (for US installation it usually is C:\Program Files\MvxAPP11\CONTROL).

A parameter file consists of these three parts:

Statement header
Record definition
Field definition

Example of parameter file

Below is an example of a parameter file controlling complete and incremental file input (including 4 record types per file):

!*****************************************************************************

!* IMPORT FROM FILE WITH MULTIPLE RECORDS *

!* O,R,M/N & H IN THE SAME FILE: *

!* *

!* TOTAL: PMORGExx.DAT *

!* *

!* INCREMENTAL: PMOGI1xx.DAT *

!*****************************************************************************

[IMPORT]

FILEFORMAT=SEPARATED

ID=#1

! DELIMITER=;

! CHARQUOTES=

[O]

! Field Type Default Offset Length R Description

! ----- ------ --------------- ------ ------ - -------------------

#1 ;CHAR ; ;1029 ;1 ; "O" EXRTYP Record type

#2 ;CHAR ; ;9 ;12 ; COHPEG Peg ID

#3 ;CHAR ;NULL:ERROR ;113 ;25 ; COHITM Item number

#4 ;LONG ;NULL:ERROR ;8 ; ; MOHMRP Order number

#7 ;SHORT ; ;134 ; ; IOHPRI External network priority

#8 ;DATE ; ;9 ; ; MOHDDT MRP order due date

#9 ;TIME ; ;9 ; ; -"- -"-

#10 ;DATE ; ;10 ; ; MOHRDT MRP order release date

#11 ;TIME ; ;10 ; ; -"- -"-

#12 ;DATE ; ;11 ; ; MOHCDT End item peg receipt date