Table MFGOPE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| MFGOPE | MFO | Work order - operations | Manufacturing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MFO0 | MFGNUM+OPENUM+OPESPLNUM | No | |
| MFO1 | POHNUM+POPLIN+POPSEQ | Yes | |
| MFO2 | MFGFCY+EXTWST+SCHSBB+MFGNUM | Yes | |
| MFO4 | MFGFCY+OPESTA | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ALTOPECOD | Routing code ope. | M | 4 | 1 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BASQTY | Base quantity | QTY | ||||||
| BPAADD | Address | ADR | ||||||
| BPRNUM | BP | BPR | [BPR]BPR0=[MFO]BPRNUM | Other | ||||
| CAD | Rate | DCB | 6.4 | |||||
| CPLCRG | Actual charge | MD8 | ||||||
| CPLLAB | Actual labor W/C | WST | ||||||
| CPLLABNBR | Act. no. labor | C | 2 | |||||
| CPLOPETIM | Actual run time | TIH | ||||||
| CPLPRI | Actual price | MD8 | ||||||
| CPLQTY | Total completed qty. | QTY | ||||||
| CPLSETTIM | Actual stp. time | TIH | ||||||
| CPLUNTTIM | Actual unit time | TIH | ||||||
| CPLWST | Actual work center | WST | ||||||
| CPLWSTNBR | Actual resources | C | 2 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| EFF | % efficiency | DCB | 3.3 | |||||
| EQUNUM | Tools | ITM | [ITM]ITM0=[MFO]EQUNUM | Block | ||||
| EXPNUM | Export number | L | 8 | |||||
| EXTLAB | Expected labor work center | WST | ||||||
| EXTLABNBR | Exp. no. labor | C | 2 | |||||
| EXTOPETIM | Exp. run time | TIH | ||||||
| EXTPRI | Expected price | MD8 | ||||||
| EXTQTY | Planned quantity | QTY | ||||||
| EXTSETTIM | Expected stp. time | TIH | ||||||
| EXTSTRQTY | Sub-contract quantity | QTY | ||||||
| EXTSTUQTY | Expected STK quantity | QTY | ||||||
| EXTUNTTIM | Expected unit time | TIH | ||||||
| EXTWST | Expected W/C | WST | ||||||
| EXTWSTNBR | Expected resources | C | 2 | |||||
| FDMA | First availability | ADATIM | ||||||
| FITCAPEND | End finite capacity | D | ||||||
| FITCAPSTR | Finite capacity start | D | ||||||
| FRCSTRDAT | Sched forced scheduling | D | ||||||
| FRCSTRHOU | Forced scheduling time | HM | ||||||
| FXGNUM | Fixture | A | 20 | |||||
| GRPSETTIM | Group setup time | TIH | ||||||
| INFCAPEND | End date | D | ||||||
| INFCAPSTR | Start date | D | ||||||
| INVQTY | Invoiced qty. | QTY | ||||||
| MFGFCY | Production site | FCY | [FCY]FCY0=[MFO]MFGFCY | Block | ||||
| MFGNUM | Order no. | VCR | ||||||
| MFGPIO | Priority | M | 15 | 365 | ||||
| MFGSTA | Order status | M | 10 | 317 | ||||
| MFOTEX | Text | TXC | ||||||
| MFOTRKFLG | Tracking flag | M | 15 | 339 | ||||
| OPEEND | End date | D | ||||||
| OPELABCOE | Labor r-time fact | DCB | 3.3 | |||||
| OPENUM | Operation | OPE | ||||||
| OPENUMLEV | Operation suffix | C | 1 | |||||
| OPEPLNNUM | Operation plan | A | 20 | |||||
| OPEROUPCT | Operation image | A | 20 | |||||
| OPESPLNUM | Operation split | C | 4 | |||||
| OPESTA | Operation status | M | 15 | 308 | ||||
| OPESTR | Start date | D | ||||||
| OPESTRCOE | SUSCU/OU factor | COE | ||||||
| OPESTUCOE | STK-OPE conversion | COE | ||||||
| OPEUOM | Operation UOM | UOM | [TUN]TUN0=[MFO]OPEUOM | Block | ||||
| OPSNUM | Load no. | VCR | ||||||
| PLNFCY | Planning site | FCY | [FCY]FCY0=[MFO]PLNFCY | Block | ||||
| POHNUM | Order no. | VCR | ||||||
| POPLIN | Line | L | 8 | |||||
| POPSEQ | Sequence | L | 8 | |||||
| PRGNUM | Program | A | 20 | |||||
| PRPTIM | Preparation time | TIH | ||||||
| PSPTIM | Post-run time | TIH | ||||||
| QUACPLQTY | Actual QC quantity | QTY | ||||||
| REFPRI | Reference price | MD8 | ||||||
| REJCPLQTY | Actual rejected qty. | QTY | ||||||
| ROODES | Ope description | DES | ||||||
| ROOTIMCOD | Run time code | M | 15 | 312 | ||||
| ROUOPENUM | Operation no. | OPE | ||||||
| RPLIND | Alternate index | C | 3 | |||||
| RSTMAC | Machine restriction | A | 5 | |||||
| SCHGRP | Grouping criterion | A | 15 | |||||
| SCHSBB | Distinction criteria | A | 15 | |||||
| SCOCOD | Subcontract | M | 15 | 311 | ||||
| SCOITMREF | Subcontracted prod. | ITM | [ITM]ITM0=[MFO]SCOITMREF | Block | ||||
| SCOLTI | Subcontract LT | LTI | ||||||
| SCOPUU | Purchase unit | UOM | [TUN]TUN0=[MFO]SCOPUU | Block | ||||
| SCOWST | Subcontract work C | WST | ||||||
| SETLABCOE | Labor time set fac | DCB | 3.3 | |||||
| SHR | Shrinkage in % | DCB | 3.3 | |||||
| SPLCOD | Splitting | M | 15 | 304 | ||||
| SPLMAXNBR | Max splits | C | 4 | |||||
| STDLAB | Standard labor | WST | ||||||
| STDLABNBR | Std no. labor | C | 2 | |||||
| STDOPETIM | Standard run time | TIH | ||||||
| STDQTY | Standard quantity | QTY | ||||||
| STDSETTIM | Standard stp. time | TIH | ||||||
| STDUNTTIM | Standard unit time | TIH | ||||||
| STDWST | Standard position | WST | ||||||
| STDWSTNBR | Std no. workcenters | C | 2 | |||||
| TECCRD | Technical sheet | A | 8 | |||||
| TIMCOD | Management unit | M | 15 | 303 | ||||
| TIMUOMCOD | Time unit | M | 15 | 301 | ||||
| TRKFIRST | First tracking date | D | ||||||
| TRKFIRSTC | First tracking date | D | ||||||
| TRKLAST | Last tracking date | D | ||||||
| TRKLASTC | Last tracking date | D | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WAITIM | Waiting time | TIH | ||||||
| WIPNUM | WIP no. | VCR | ||||||
| WSTEFF | Post efficiency | DCB | 3.3 |