Table SNPTSKOPE
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SNPTSKOPE | SPTKO | Tasks - Operations | Common Data | PJM |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PTKO0 | SNPVCR+OPPNUM+TASCOD+OPENUM+OPESPLNUM | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CSMQTY | Consumed load | QTY | ||||||
CUR | Currency | CUR | [TCU]TCU0=[SPTKO]CUR | Block | ||||
EXTLAB | Expected labor work center | WST | ||||||
EXTLABNBR | Exp. no. labor | C | 2 | |||||
EXTQTY | Planned quantity | QTY | ||||||
EXTWST | Expected W/C | WST | ||||||
EXTWSTNBR | Expected resources | C | 2 | |||||
OPECST | Hourly rate | MS1 | ||||||
OPECST2 | Labor rate | MD8 | ||||||
OPEDATH | Suspension date | D | ||||||
OPEDATS | Date closed | D | ||||||
OPEDUR | Duration | C | 4 | |||||
OPEEND | End date | D | ||||||
OPEENDDT | Actual end date | D | ||||||
OPENUM | Operation | OPE | ||||||
OPESPLNUM | Operation split | C | 4 | |||||
OPESTA | Operation status | M | 15 | 308 | ||||
OPESTARTDT | Actual start date | D | ||||||
OPESTR | Start date | D | ||||||
OPEUOM2 | Unit | UOM | [TUN]TUN0=[SPTKO]OPEUOM2 | Block | ||||
OPPNUM | Project number | PIM | [PIM]PIM0=[SPTKO]OPPNUM | Delete | ||||
PTETYP | Time category | PJTC | [PJTC]PJTC0=[SPTKO]PTETYP | Block | ||||
RMNQTY | Remaining load | QTY | ||||||
ROODESAXX | Description | AXX | ||||||
SNPVCR | Snapshot code | VPJ | ||||||
SPLDREF | Reference | VPJBIG | ||||||
TASCOD | Task code | TAC | ||||||
TASFCY | Site | FCY | [FCY]FCY0=[SPTKO]TASFCY | Block | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |