Table 5410 Prod. Order Capacity Need in 28
- App
- Base Application
- Namespace
- Microsoft.Manufacturing.Document
Fields, 28Keys, 13Procedures, 3
Versions171819202122232425262728latest
Source29
Fields, 28
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Status | Enum Production Order Status | - |
| 2 | Prod. Order No. | Code[20] | - |
| 3 | Routing No. | Code[20] | - |
| 4 | Line No. | Integer | - |
| 5 | Operation No. | Code[10] | - |
| 6 | Type | Enum Capacity Type | - |
| 7 | No. | Code[20] | - |
| 8 | Work Center No. | Code[20] | - |
| 9 | Work Center Group Code | Code[10] | - |
| 10 | Routing Reference No. | Integer | - |
| 11 | Date | Date | - |
| 12 | Starting Time | Time | - |
| 13 | Ending Time | Time | - |
| 14 | Allocated Time | Decimal | - |
| 16 | Send-Ahead Type | Option | - |
| 17 | Time Type | Enum Routing Time Type | - |
| 18 | Needed Time | Decimal | - |
| 19 | Needed Time (ms) | Decimal | - |
| 21 | Lot Size | Decimal | - |
| 22 | Concurrent Capacities | Decimal | - |
| 23 | Efficiency | Decimal | - |
| 26 | Starting Date-Time | DateTime | - |
| 27 | Ending Date-Time | DateTime | - |
| 31 | Worksheet Template Name | Code[10] | - |
| 32 | Worksheet Batch Name | Code[10] | - |
| 33 | Worksheet Line No. | Integer | - |
| 41 | Active | Boolean | - |
| 42 | Requested Only | Boolean | - |
Keys, 13
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Status, Prod. Order No., Requested Only, Routing No., Routing Reference No., Operation No., Line No. | - |
| Key2 | Prod. Order No., Routing No., Routing Reference No., Operation No., Status, Line No., Requested Only | - |
| Key3 | Status, Prod. Order No., Active, Requested Only, Routing No. | - |
| Key4 | Work Center No., Date, Active, Starting Date-Time | - |
| Key5 | Work Center Group Code, Date, Starting Date-Time | - |
| Key6 | Type, No., Date, Active | - |
| Key7 | Type, No., Starting Date-Time, Ending Date-Time, Active | - |
| Key8 | Type, No., Ending Date-Time, Starting Date-Time, Active | - |
| Key9 | Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No. | - |
| Key10 | Status, Prod. Order No., Routing Reference No., Operation No., Date, Starting Time | - |
| Key11 | Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Operation No., Date, Starting Time | - |
| Key12 | Worksheet Line No., Operation No. | - |
| Key13 | Status, Prod. Order No., Type, No., Work Center No., Date, Requested Only | - |
Procedures, 3
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| UpdateDatetime | () | public | - | |
| GetStartingEndingDateAndTime | (var Time, var Time, var Date) | public | - | |
| SetCapacityFilters | (Enum Capacity Type, Code[20]) | public | - |