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) |