Table 5406 Prod. Order Line in 27
- App
- Base Application
- Namespace
- Microsoft.Manufacturing.Document
Fields, 65Keys, 12Procedures, 43Events, 47
Versions171819202122232425262728latest
Source29
Fields, 65
| 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] | - | ||||
| 35 | Standard Task Code | Code[10] | Pending 27.0 | ||||
| This field is not required anymore. The standard task code is now defined on the routing line. | |||||||
| 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 | - | ||||
| 66 | Put-away Status | Option | - | ||||
| 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 | - | ||||
| 73 | Qty. Rounding Precision | Decimal | - | ||||
| 74 | Qty. Rounding Precision (Base) | Decimal | - | ||||
| 75 | Manual Scheduling | Boolean | - | ||||
| 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 | - | ||||
| 5850 | Qty. Put Away | Decimal | - | ||||
| 5851 | Qty. Put Away (Base) | Decimal | - | ||||
| 5852 | Put-away Qty. | Decimal | - | ||||
| 5853 | Put-away Qty. (Base) | Decimal | - | ||||
| 5854 | Lot No. Filter | Code[50] | - | ||||
| 5855 | Serial No. Filter | Code[50] | - | ||||
| 5856 | Package No. Filter | Code[50] | - | ||||
| 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, 43
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| DeleteRelations | () | public | - | |
| ShowReservation | () | public | - | |
| ShowReservationEntries | (Boolean) | public | - | |
| CheckEndingDate | (Boolean) | public | - | |
| BlockDynamicTracking | (Boolean) | public | - | |
| IsDynamicTrackingBlocked | () | Boolean | 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 | - |
| CreateDim | (List) | public | - | |
| CreateDimFromDefaultDim | () | public | - | |
| SuspendDeletionCheck | (Boolean) | public | - | |
| ShowOrderTracking | () | public | - | |
| GetUpdateFromSKU | () | public | - | |
| GetLinePutAwayStatus | () | Integer | public | - |
| GetRemainingPutAwayQty | () | Decimal | public | - |
| ConfirmUpdateDueDateAndEndingDate | (Text, Date) | Boolean | public | - |
| GetUsedPutAwayQtyPerItemTracking | (Code[50], Code[50], Code[50]) | Decimal | internal | - |
Events, 47
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCheckEndingDate | (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 | OnBeforeValidateUnitofMeasureCodeFromItem | (var Record Prod. Order Line, Record Prod. Order Line, var Record Item, var Record Production Order, var Boolean) | - |
| Integration event | OnBeforeValidateQuantityBase | (var Record Prod. Order Line, Record Prod. Order Line, Integer, var Boolean) | - |
| Integration event | OnAfterCreateDim | (var Record Prod. Order Line, List) | - |
| Integration event | OnAfterGetItem | (var Record Item, var Record Prod. Order Line) | - |
| Integration event | OnValidateProductionBOMNoOnBeforeTestStatus | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnValidateLocationCodeOnBeforeCreateDim | (var Record Prod. Order Line) | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Prod. Order Line, var List, Integer) | - |
| Integration event | OnAfterCalcBaseQty | (var Record Prod. Order Line, var Record Prod. Order Line, var Decimal, Text, Text) | - |
| Integration event | OnAfterCopyFromItem | (var Record Prod. Order Line, Record Item, var Record Prod. Order Line, Integer) | - |
| Integration event | OnBeforeValidateRoutingNo | (var Record Prod. Order Line, var Record Prod. Order Line, Integer, var Boolean) | - |
| Integration event | OnValidateItemNoOnAfterAssignItemValues | (var Record Prod. Order Line, Record Item, Record Prod. Order Line, var Boolean) | - |
| Integration event | OnValidateUnitOfMeasureCodeOnAfterWhseValidateSourceLine | (var Record Prod. Order Line, Record Prod. Order Line, Integer) | - |
| Integration event | OnBeforeShowRouting | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnValidateQuantityOnAfterCalcBaseQty | (var Record Prod. Order Line, Record Prod. Order Line) | - |
| Integration event | OnDeleteRelationsOnBeforeProdOrderRoutingLineDelete | (var Record Prod. Order Routing Line, var Boolean) | - |
| Integration event | OnValidateEndingTimeOnBeforeRecalculate | (var Record Prod. Order Line, Integer, var Boolean) | - |
| Integration event | OnAfterGetUpdateFromSKU | (var Record Prod. Order Line, var Record Item, var Record Stockkeeping Unit) | - |
| Integration event | OnShowDimensionsOnAfterEditDimensionSet | (var Record Prod. Order Line, Integer) | - |
| Integration event | OnValidateItemNoOnBeforeCheckReservations | (var Record Prod. Order Line, Record Prod. Order Line, Integer, var Boolean) | - |
| Integration event | OnValidateVariantCodeOnAfterVerifyChange | (var Record Prod. Order Line, Record Prod. Order Line, Integer) | - |
| Integration event | OnAfterDeleteRelations | (var Record Prod. Order Line) | - |
| Integration event | OnShowRoutingOnBeforeFindAndSetProdOrderLineBinCodeFromProdRoutingLines | (var Record Prod. Order Line, var Boolean) | - |
| Integration event | OnBeforeValidateProductionBOMVersionCode | (var Record Prod. Order Line, Record Prod. Order Line, var Boolean) | - |
| Integration event | OnBeforeOnValidateUnitCost | (var Record Prod. Order Line, var Boolean) | - |