Table 5406 Prod. Order Line in 18
- App
- Base Application
Fields, 53Keys, 12Procedures, 35Events, 26
Versions171819202122232425262728latest
Source29
Fields, 53
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Status | Enum Production Order Status | - |
| 2 | Prod. Order No. | Code[20] | - |
| 3 | Line No. | Integer | - |
| 11 | Item No. | Code[20] | - |
| 12 | Variant Code | Code[10] | - |
| 13 | Description | Text[100] | - |
| 14 | Description 2 | Text[50] | - |
| 20 | Location Code | Code[10] | - |
| 21 | Shortcut Dimension 1 Code | Code[20] | - |
| 22 | Shortcut Dimension 2 Code | Code[20] | - |
| 23 | Bin Code | Code[20] | - |
| 40 | Quantity | Decimal | - |
| 41 | Finished Quantity | Decimal | - |
| 42 | Remaining Quantity | Decimal | - |
| 45 | Scrap % | Decimal | - |
| 47 | Due Date | Date | - |
| 48 | Starting Date | Date | - |
| 49 | Starting Time | Time | - |
| 50 | Ending Date | Date | - |
| 51 | Ending Time | Time | - |
| 52 | Planning Level Code | Integer | - |
| 53 | Priority | Integer | - |
| 60 | Production BOM No. | Code[20] | - |
| 61 | Routing No. | Code[20] | - |
| 62 | Inventory Posting Group | Code[20] | - |
| 63 | Routing Reference No. | Integer | - |
| 65 | Unit Cost | Decimal | - |
| 67 | Cost Amount | Decimal | - |
| 68 | Reserved Quantity | Decimal | - |
| 70 | Capacity Type Filter | Enum Capacity Type | - |
| 71 | Capacity No. Filter | Code[20] | - |
| 72 | Date Filter | Date | - |
| 80 | Unit of Measure Code | Code[10] | - |
| 81 | Quantity (Base) | Decimal | - |
| 82 | Finished Qty. (Base) | Decimal | - |
| 83 | Remaining Qty. (Base) | Decimal | - |
| 84 | Reserved Qty. (Base) | Decimal | - |
| 90 | Expected Operation Cost Amt. | Decimal | - |
| 91 | Total Exp. Oper. Output (Qty.) | Decimal | - |
| 94 | Expected Component Cost Amt. | Decimal | - |
| 198 | Starting Date-Time | DateTime | - |
| 199 | Ending Date-Time | DateTime | - |
| 480 | Dimension Set ID | Integer | - |
| 5831 | Cost Amount (ACY) | Decimal | - |
| 5832 | Unit Cost (ACY) | Decimal | - |
| 99000750 | Production BOM Version Code | Code[20] | - |
| 99000751 | Routing Version Code | Code[20] | - |
| 99000752 | Routing Type | Option | - |
| 99000753 | Qty. per Unit of Measure | Decimal | - |
| 99000754 | MPS Order | Boolean | - |
| 99000755 | Planning Flexibility | Enum Reservation Planning Flexibility | - |
| 99000764 | Indirect Cost % | Decimal | - |
| 99000765 | Overhead Rate | Decimal | - |
Keys, 12
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Status, Prod. Order No., Line No. | - |
| Key2 | Prod. Order No., Line No., Status | - |
| Key3 | Status, Item No., Variant Code, Location Code, Ending Date | - |
| Key4 | Status, Item No., Variant Code, Location Code, Starting Date | - |
| Key5 | Status, Item No., Variant Code, Location Code, Due Date | - |
| Key6 | Status, Item No., Variant Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Location Code, Due Date | - |
| Key7 | Status, Prod. Order No., Item No. | - |
| Key8 | Status, Prod. Order No., Routing No., Routing Reference No. | - |
| Key9 | Status, Prod. Order No., Planning Level Code | - |
| Key10 | Planning Level Code, Priority | - |
| Key11 | Item No., Variant Code, Location Code, Status, Ending Date | - |
| Key12 | Item No., Variant Code, Location Code, Status, Due Date | - |
Procedures, 35
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| DeleteRelations | () | public | - | |
| ShowReservation | () | public | - | |
| ShowReservationEntries | (Boolean) | public | - | |
| CheckEndingDate | (Boolean) | public | - | |
| BlockDynamicTracking | (Boolean) | public | - | |
| IsDynamicTrackingBlocked | () | Boolean | public | - |
| CreateDim | (Integer, Code[20]) | public | - | |
| IsInbound | () | Boolean | public | - |
| OpenItemTrackingLines | () | public | - | |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| LookupShortcutDimCode | (Integer, var Code[20]) | public | - | |
| ShowShortcutDimCode | (var Code[20]) | public | - | |
| UpdateDatetime | () | public | - | |
| ShowDimensions | () | public | - | |
| RowID1 | () | Text[250] | public | - |
| GetRemainingQty | (var Decimal, var Decimal) | public | - | |
| GetReservationQty | (var Decimal, var Decimal, var Decimal, var Decimal) | Decimal | public | - |
| GetSourceCaption | () | Text | public | - |
| SetReservationEntry | (var Record Reservation Entry) | public | - | |
| SetReservationFilters | (var Record Reservation Entry) | public | - | |
| ReservEntryExist | () | Boolean | public | - |
| FilterLinesWithItemToPlan | (var Record Item, Boolean) | public | - | |
| FindLinesWithItemToPlan | (var Record Item, Boolean) | Boolean | public | - |
| LinesWithItemToPlanExist | (var Record Item, Boolean) | Boolean | public | - |
| FilterLinesForReservation | (Record Reservation Entry, Option, Text, Boolean) | public | - | |
| SetIgnoreErrors | () | public | - | |
| SetCalledFromComponent | (Boolean) | public | - | |
| HasErrorOccured | () | Boolean | public | - |
| UpdateProdOrderComp | (Decimal) | public | - | |
| UpdateProdOrderCompDim | (Integer, Integer) | public | - | |
| ShowRouting | () | public | - | |
| SetFilterByReleasedOrderNo | (Code[20]) | public | - | |
| TestItemFields | (Code[20], Code[10], Code[10]) | public | - | |
| GetStartingEndingDateAndTime | (var Time, var Date, var Time, var Date) | public | - | |
| IsStatusLessThanReleased | () | Boolean | public | - |
Events, 26
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCheckEndingDate | (var Record Prod. Order Line) | - |
| Integration event | OnAfterCreateDimTableIDs | (var Record Prod. Order Line, Integer, var Integer, var Code[20]) | - |
| Integration event | OnAfterCopyFromItem | (var Record Prod. Order Line, Record Item, var Record Prod. Order Line) | - |
| Integration event | OnAfterGetSKU | (Record Prod. Order Line, var Boolean) | - |
| Integration event | OnAfterDeleteProdOrderRtngLines | (var Record Prod. Order Line) | - |
| Integration event | OnAfterOnDelete | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnAfterRecalculate | (var Record Prod. Order Line, Option, var Integer) | - |
| Integration event | OnAfterSetReservationFilters | (var Record Reservation Entry, Record Prod. Order Line) | - |
| Integration event | OnAfterUpdateDateTime | (var Record Prod. Order Line, var Record Prod. Order Line, Integer) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Prod. Order Line, var Record Prod. Order Line, Integer, var Code[20]) | - |
| Integration event | OnBeforeCheckEndingDate | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnBeforeGetUpdateFromSKU | (var Record Prod. Order Line, var Record Stockkeeping Unit, var Record Item, var Boolean) | - |
| Integration event | OnBeforeDeleteRelations | (var Record Prod. Order Line) | - |
| Integration event | OnBeforeDeleteProdOrderRtngLines | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnBeforeShowReservation | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Prod. Order Line, var Record Prod. Order Line, Integer, var Code[20]) | - |
| Integration event | OnDeleteRelationsNotCalledFromComponentFilter | (var Record Prod. Order Line, var Record Prod. Order Component) | - |
| Integration event | OnDeleteRelationsNotCalledFromComponentInitFields | (var Record Prod. Order Component) | - |
| Integration event | OnUpdateProdOrderCompOnAfterFind | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnUpdateProdOrderCompOnBeforeModify | (var Record Prod. Order Line, var Record Prod. Order Component) | - |
| Integration event | OnBeforeValidateQuantity | (var Record Prod. Order Line, Record Prod. Order Line, Integer, var Boolean) | - |
| Integration event | OnAfterFilterLinesWithItemToPlan | (var Record Prod. Order Line, var Record Item, Boolean) | - |
| Integration event | OnAfterFilterLinesForReservation | (var Record Prod. Order Line, Record Reservation Entry, Option, Text, Boolean) | - |
| Integration event | OnBeforeUpdateProdOrderComp | (var Record Prod. Order Line, Decimal, Integer, var Boolean, var Record Prod. Order Component, Boolean) | - |
| Integration event | OnDeleteRelationsOnBeforeProdOrderCompDeleteAll | (var Record Prod. Order Component, Boolean, var Boolean) | - |
| Integration event | OnValidateItemNoOnAfterAssignItemValues | (var Record Prod. Order Line, Record Item) | - |