Record Types for File Interface

These record types are available:

Type Description
O-record Manufacturing order headers
R-record Operations
M-record Material links
H-record End item order headers

O-record (Manufacturing Order Record)

Field Type Default Offset Length R Field ID 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
#13 TIME   11     -"- -"-
#14 SHORT NULL:ERROR 136     IOHSTA Shop order status
#15 FLOAT NULL:ERROR 13     ROHPLQ Planned quantity
#16 FLOAT   14     ROHFDQ Finished quantity
#17 CHAR   138 25   COHRON Description
#18 CHAR   163 10   COHSON Shop order number
#19 DATE   60     MOHIST Infinite scheduled start
#20 TIME   60     -"- -"-
#21 DATE   61     MOHIED Infinite scheduled end
#22 TIME   61     -"- -"-
#23 DATE   58     MOHFST Finite scheduled start
#24 TIME   58     -"- -"-
#25 DATE   59     MOHFED Finite scheduled end
#26 TIME   59     -"- -"-
#27 SHORT   130     IOHMLC Low level code
#28 SHORT   528     IXRPGC Pegging code
#30 SHORT   13     IOHPU1 Pull-up code 1  - too early
#31 SHORT   14     IOHPU2 Pull-up code 2  - delayed
#32 SHORT   128     IOHEXT Extra code
#33 SHORT   56     IOHORI Origination code
#34 SHORT NULL:1 135     IOHOCD Order group
#35 CHAR   6 3   COHRTY Routing type
#36 LONG   6     MOHPGS Peg Suffix
#37 FLOAT   17     SOHMFC Multiplication factor 1
#38 FLOAT   18     SOHMFC Multiplication factor 2
#39 FLOAT   19     SOHMFC Multiplication factor 3
#40 FLOAT   20     SOHMFC Multiplication factor 4
#41 FLOAT   21     SOHMFC Multiplication factor 5
#42 FLOAT   22     SOHMFC Multiplication factor 6
#43 FLOAT   23     SOHMFC Multiplication factor 7
#44 FLOAT   24     SOHMFC Multiplication factor 8
#45 FLOAT   25     SOHMFC Multiplication factor 9
#46 FLOAT   26     SOHMFC Multiplication factor 10
#47 SHORT   55     IOHOPR External order priority
#48 DATE   63     MOHTIM Order timestamp
#49 TIME   63     -"- -"-
#50 SHORT   139     IOHCGR Coloring group
#51 CHAR   288 1   EOHOSS MRP status
#52 CHAR   280 1   EOHOTY Order type
#53 CHAR   335 1   EOHROC Reference order category (11.01)
#54 CHAR   336 7   COHROR Reference order number (11.01)
#55 LONG   87     MOHROL Reference order line (11.01)
#56 CHAR   378 25   COHIFM Item family (11.01)

8.2.2 R-record (Operation Record)

Field Type Default Offset Length R Field ID Description
#1 CHAR   1029 1 "R" EXRTYP Record type
#2 CHAR   1071 12   CXRPEG Peg ID
#3 CHAR NULL:ERROR 1030 25   CXRITM Item number
#4 LONG NULL:ERROR 257     MXRMRP Order number
#5 LONG NULL:ERROR 9     MOPNUM Operation number
#6 CHAR   155 4   MOPSFF Operation number suffix
#7 FLOAT   18     MOPSUS Setup time standard
#10 FLOAT NULL:ERROR 20     MOPTIM Operation time
#11 FLOAT   23     MOPMAN Manpower time
#12 FLOAT   24     MOPPRE Preparation time
#13 FLOAT   25     MOPPOT Post operation time
#14 SHORT   66     MOPTNS Parallel operation generation code
#15 CHAR   196 1   MOPALO Alternative operation indicator
#16 SHORT   529     IXROKY Old overlap key (only used in v. 2.01)
#17 FLOAT   32     MOPBAS Overlap base
#18 CHAR   373 20   MOPSSF Co-sorting key (scheduling group)
#19 FLOAT   26     MOPSHF Shrinkage factor
#20 FLOAT NULL:100.0 27     MOPEFF Efficiency (%)
#21 CHAR NULL:ERROR 171 12   MOPWCF Workcenter number
#22 CHAR   183 12   MOPPMF Planned single machine number (forced machine)
#23 SHORT NULL:ERROR 70     MOPCOP Operation status
#24 CHAR   269 12   MOPMAF Finite scheduled machine number
#25 FLOAT   28     MOPCPQ Quantity completed
#26 FLOAT   29     MOPPLQ Planned quantity
#27 FLOAT   30     MOPACS Actual scrap
#28 DATE   11     MOPLTS Last timestamp
#29 TIME   11     -"- -"-
#30 SHORT NULL:ERROR 77     MOPIND Operation time indicator
#31 DATE   36     MOPFOR Forced start timestamp
#32 TIME   36     -"- -"-
#33 DATE   12     MOPSTS Setup start timestamp
#34 TIME   12     -"- -"-
#35 FLOAT   31     MOPPCT Percent completed
#36 DATE   56     MOPFST Finite scheduled start
#37 TIME   56     -"- -"-
#38 DATE   57     MOPFED Finite scheduled end
#39 TIME   57     -"- -"-
#40 DATE   58     MOPIST Infinite scheduled start
#41 TIME   58     -"- -"-
#42 DATE   59     MOPIED Infinite scheduled end
#43 TIME   59     -"- -"-
#44 LONG   10     MOPNON Next operation number
#45 FLOAT   19     MOPSUF Grouping setup time
#47 FLOAT   21     MOPRUN Total run time
#48 FLOAT   22     MOPTOT Remaining run time
#49 SHORT   124     MOPCOD Scheduling control code
#50 SHORT   125     MOPSTA Scheduling status
#53 CHAR   49 20   MOPDES Operation text
#54 FLOAT   50     MOPFMA Max. operation load
#55 CHAR   6 1   MOPSKY Splitting key
#56 CHAR NULL:ERROR 307 1   MOPOKY Operation
#57 SHORT   4     MOPMIN Manpower indicator
#58 CHAR   9 12   MOPAMF Actual machine
#59 FLOAT   7     MOPAOP Run time accumulated
#60 FLOAT   8     MOPASU Setup time accumulated
#61 FLOAT   65     MOPRSU Remaining setup time
#62 SHORT   67     MOPFNS Forced number of splits
#63 FLOAT   51     MOPFMI Min. operation load
#64 CHAR   205 5   MOPMRF Machine restriction
#65 CHAR   217 2   MOPMOS Infor M3 BE server operation status           (11.01)
#66 LONG   73     MOPGRP Group number                     (11.01)
#67 CHAR   401 1   MOPOLA Normal operation overlap code (11.01)
#68 CHAR   402 2   MOPSES Parallel operation overlap code (11.01)

M-record (Material Link Record)

Field Type Default Offset Length R Field ID Description
#1 CHAR   1029 1 "M" EXRTYP Record type
#3 CHAR NULL:ERROR 85 25   CRSPIT Parent item number
#4 LONG NULL:ERROR 19     MRSPON Parent order number
#5 LONG   21     MRSSEQ Sequence number
#7 LONG   20     MRSPOP Operation no. where used
#8 CHAR   110 25   CRSCIT Component item number
#9 LONG   17     MRSCON Component order number
#10 FLOAT   5     RRSQTY Quantity of requirement
#11 SHORT   530     IXRMCC Material const. code (only used in v. 2.01)
#12 DATE   4     MRSCAD Purchased component availability date
#13 TIME   4     -"- -"-
#17 LONG   18     MRSCOP Component operation number
#18 CHAR NULL:ERROR 29 1   ERSTYP Relation type
#19 CHAR   37 2   FRSOCO Order overlap code
#20 FLOAT   9     RRSOBA Order overlap base
#21 CHAR   135 1   ERSPOS Purchased order status
#22 FLOAT   38     RRSOBV Overlap calculation base
#23 CHAR   158 3   CRSFIL Filler
#24 CHAR   144 1   ERSOCM Overlap base control
#25 CHAR   43 1   ERSRST Synchronization status
#26 CHAR   44 1   ERSSST Shortage status
#27 FLOAT   37     RRSDQT Shortage quantity
#28 FLOAT   39     RRSOQT Original quantity
#29 CHAR   157 1   ERSORI Relationship origination
#30 CHAR   136 4   GRSPSU Parent Operation suffix
#31 CHAR   140 4   GRSCSU Component Operation suffix
#34 Dummy            

8.2.4 H-record (End Item Order Record)

Field Type Default Offset Length R Field ID Description
#1 CHAR   1029 1 "H" EXRTYP Record type
#2 CHAR   158 12   CCOPEG Peg ID
#3 DATE   2     MCOEDD Earliest order line due date
#4 TIME   2     -"- -"-
#5 DATE   3     MCOLDD End Item Peg due date
#6 TIME   3     -"- -"-
#7 DATE   4     MCOERD End Item Peg release date
#8 TIME   4     -"- -"-
#9 LONG   5     MCOIPR Internal customer order priority
#10 SHORT   108     ICOPGC Component order generation
#11 SHORT   12     ICOPRI External network priority
#12 SHORT   13     ICOSTA Customer order status
#13 LONG   1     MCOPGS Peg suffix
#14 SHORT   109     ICOCGR Coloring group
#15 CHAR   105 12   CCOORN Customer order number
#16 CHAR   117 10   CCONUM Customer number
#17 CHAR   127 31   CCODES Description
#18 CHAR NULL:ERROR 170 25   CCOITM Item number of the top order
#19 SHORT   16     ICOTYP Order type
#24 LONG   11     MCOMRP Order number
#33 FLOAT NULL:ERROR 16     RCOQTY Top order quantity
#34 SHORT   33     ICOGEN Generation status control code
#35 SHORT   34     ICOOCD Order group
#36 SHORT   35     ICOGST Generation status
#37 SHORT   36     ICOORI Origination code
#38 CHAR   267 1   ECOROC Reference order category  (11.01)
#39 CHAR   268 7   ECOROR Reference order number    (11.01)
#40 LONG   70     MCOROL Reference order line      (11.01)