| DB | Areas | X-idx | Tables | Sequences | <- mfr-route | mfr-schedreq -> | HtmlDict 11 |
Schedule operation
| Area | ProdData |
|---|---|
| Dumpname | schedops |
| Label | Schedule operation |
| Val.exp | |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 370 | act-fix-oh-cost | X | Act Fixed OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 400 | act-lab-cost | X | Act Labour Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 290 | act-lab-hrs | X | Act Labour Hours | decimal-2 | >,>>9.99 | 0 | ||
| 390 | act-mat-cost | X | Act Material Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 410 | act-other-cost | X | Act Other Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 270 | act-prod-hrs | X | Act Production Hours | decimal-2 | >>9.99 | 0 | ||
| 380 | act-var-oh-cost | X | Act Variable OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 5 | branch-no | X | Branch No | integer | 99 | 0 | ||
| 220 | compl-qty | X | Compl Quantity | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 90 | cost-cde | X | Cost Code | character | x(4) | |||
| 120 | day-setup-time | X | Day Setup Time | decimal-2 | 9.99 | 0 | ||
| 160 | elapsed-time | X | Elapsed Time | logical | Yes/No | NO | ||
| 70 | end-date | X | End Date | date | 99/99/9999 | ? | ||
| 300 | hrs-to-compl | X | Hours To Compl | decimal-2 | >,>>9.99 | 0 | ||
| 170 | man-oper-ratio | X | Man Operation Ratio | decimal-4 | >>9.9999 | 0 | ||
| 310 | mat-to-compl | X | Material To Compl | decimal-2 | >>>,>>9.99 | 0 | ||
| 150 | move-time | X | Move Time | decimal-2 | >9.99 | 0 | ||
| 130 | no-of-days | X | No Of Days | integer | >>9 | 0 | ||
| 50 | oper-desc | X | Operation Description | character | x(25) | |||
| 30 | oper-no | X | Operation Number | integer | >>>>9 | 0 | ||
| 510 | reptg-pnt-ind | X | Reporting Point | logical | Yes/No | No | ||
| 180 | reptg-uom | X | Reporting UOM | character | x(2) | |||
| 210 | req-qty | X | Request Qty | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 230 | scrap-qty | X | Scrapped Qty | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 60 | start-date | X | Start date | date | 99/99/9999 | ? | ||
| 320 | std-fix-oh-cost | X | Std Fixed OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 350 | std-lab-cost | X | Std Labour Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 280 | std-lab-hrs | X | Std Labour Hours | decimal-2 | >,>>9.99 | 0 | ||
| 340 | std-mat-cost | X | Std Material Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 360 | std-other-cost | X | Std Other Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 260 | std-prod-hrs | X | Std Production Hours | decimal-2 | >>9.99 | 0 | ||
| 140 | std-time | X | Std Time | decimal-4 | >>9.9999 | 0 | ||
| 330 | std-var-oh-cost | X | Std Variable OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 200 | uom-conv-fct | X | UOM Conv Factor | decimal-4 | >>>,>>9.9999 | 0 | ||
| 480 | upd-date | X | Updated | date | 99/99/9999 | ? | ||
| 490 | upd-time | X | At | integer | 99999 | 0 | ||
| 500 | upd-user-id | X | By | character | x(12) | |||
| 240 | waste-qty | X | Waste Quantity | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 100 | wc-cde | X | Work centre Cde | character | x(2) | |||
| 420 | wip-fix-oh-cost | X | WIP Fixed OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 450 | wip-lab-cost | X | WIP Labour Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 440 | wip-mat-cost | X | WIP Material Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 470 | wip-other-cost | X | WIP Other Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 250 | wip-qty | X | Work in process Quan | decimal-3 | >,>>>,>>9.999 | 0 | ||
| 430 | wip-var-oh-cost | X | WIP Variable OH Cost | decimal-4 | >,>>>,>>9.9999 | 0 | ||
| 10 | wo-no | X | Worksorder Number | integer | >>>>>9 | 0 | ||
| 110 | wo-setup-time | X | W/O Setup Time | decimal-2 | >,>>9.99 | 0 | ||
| 190 | wo-stat | X | Worksorder Status | integer | 9 | 0 |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| wo-no | P | branch-no (+) | integer |
| wo-no (+) | integer | ||
| oper-no (+) | integer | ||
| wo-stat (+) | integer | ||
| cost-cde | branch-no (+) | integer | |
| cost-cde (+) | character | ||
| wc-cde (+) | character | ||
| wo-no (+) | integer | ||
| oper-no (+) | integer | ||
| start-date (+) | date |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| Parent tables |
|---|
| inv-combocom inv-comboitem mfr-workcent |
| generated 18-9-2026 09:33 |