Table PJMTSKOPE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PJMTSKOPE | PTKO | Tasks - Operations | Common Data | PJM |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PTKO0 | OPPNUM+TASCOD+OPENUM+OPESPLNUM | No | |
| PTKO1 | OPPNUM+TASCOD+OPENUM | Yes | |
| PTKO2 | OPPNUM+TASCOD | 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=[PTKO]BPRNUM | Block | ||||
| 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 | ||||||
| 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 | |||||
| CSMQTY | Consumed load | QTY | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[PTKO]CUR | Block | ||||
| EFF | % efficiency | DCB | 3.3 | |||||
| EQUNUM | Tools | ITM | [ITM]ITM0=[PTKO]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 | ||||||
| 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 | |||||
| FITCAPEND | End finite capacity | D | ||||||
| FITCAPSTR | Finite capacity start | D | ||||||
| FRCSTRDAT | Sched forced scheduling | D | ||||||
| FRCSTRHOU | Forced scheduling time | HM | ||||||
| FXGNUM | Fixture | A | 20 | |||||
| INFCAPEND | End date | D | ||||||
| INFCAPSTR | Start date | D | ||||||
| INVQTY | Invoiced qty. | QTY | ||||||
| OPECST | Hourly rate | MS1 | ||||||
| OPECST2 | Labor rate | MD8 | ||||||
| OPEDATH | Suspension date | D | ||||||
| OPEDATS | Date closed | D | ||||||
| OPEEND | End date | D | ||||||
| OPEENDDT | Actual 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 | ||||
| OPESTARTDT | Actual start date | D | ||||||
| OPESTR | Start date | D | ||||||
| OPESTRCOE | SUSCU/OU factor | COE | ||||||
| OPESTUCOE | STK-OPE conversion | COE | ||||||
| OPEUOM | Operation UOM | UOM | [TUN]TUN0=[PTKO]OPEUOM | Block | ||||
| OPEUOM2 | Unit | UOM | [TUN]TUN0=[PTKO]OPEUOM2 | Block | ||||
| OPPNUM | Project number | PIM | [PIM]PIM0=[PTKO]OPPNUM | Delete | ||||
| OPSNUM | Load no. | VCR | ||||||
| PIO | Priority | C | 2 | |||||
| POHNUM | Order no. | VCR | ||||||
| POPLIN | Line | L | 8 | |||||
| POPSEQ | Sequence | L | 8 | |||||
| PRGNUM | Program | A | 20 | |||||
| QUACPLQTY | Actual QC quantity | QTY | ||||||
| REFPRI | Reference price | MD8 | ||||||
| REJCPLQTY | Actual rejected qty. | QTY | ||||||
| RMNQTY | Remaining load | QTY | ||||||
| ROODESAXX | Description | AXX | ||||||
| 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=[PTKO]SCOITMREF | Block | ||||
| SCOLTI | Subcontract LT | LTI | ||||||
| SCOPUU | Purchase unit | UOM | [TUN]TUN0=[PTKO]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 | |||||
| STDOPENUM | Standard operation | ROT | ||||||
| STDOPETIM | Standard run time | TIH | ||||||
| STDQTY | Standard quantity | QTY | ||||||
| STDUNTTIM | Standard unit time | TIH | ||||||
| STDWST | Standard position | WST | ||||||
| STDWSTNBR | Std no. workcenters | C | 2 | |||||
| TASCOD | Task code | TAC | ||||||
| TASFCY | Site | FCY | [FCY]FCY0=[PTKO]TASFCY | Block | ||||
| TECCRD | Technical sheet | A | 8 | |||||
| TIMCOD | Management unit | M | 15 | 303 | ||||
| TIMUOMCOD | Time unit | M | 15 | 301 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| WIPNUM | WIP no. | VCR | ||||||
| WSTEFF | Post efficiency | DCB | 3.3 | |||||
| WSTTYP | Work center type | M | 20 | 313 |