Table 99000829 Planning Component in 26
- App
- Base Application
- Namespace
- Microsoft.Inventory.Planning
Fields, 52Keys, 4Procedures, 31Events, 22
Versions171819202122232425262728latest
Source29
Fields, 52
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Worksheet Template Name | Code[10] | - |
| 2 | Worksheet Batch Name | Code[10] | - |
| 3 | Worksheet Line No. | Integer | - |
| 5 | Line No. | Integer | - |
| 11 | Item No. | Code[20] | - |
| 12 | Description | Text[100] | - |
| 13 | Unit of Measure Code | Code[10] | - |
| 14 | Quantity | Decimal | - |
| 15 | Position | Code[10] | - |
| 16 | Position 2 | Code[10] | - |
| 17 | Position 3 | Code[10] | - |
| 18 | Lead-Time Offset | DateFormula | - |
| 21 | Variant Code | Code[10] | - |
| 22 | Qty. Rounding Precision | Decimal | - |
| 23 | Qty. Rounding Precision (Base) | Decimal | - |
| 25 | Expected Quantity | Decimal | - |
| 30 | Location Code | Code[10] | - |
| 31 | Shortcut Dimension 1 Code | Code[20] | - |
| 32 | Shortcut Dimension 2 Code | Code[20] | - |
| 33 | Bin Code | Code[20] | - |
| 35 | Supplied-by Line No. | Integer | - |
| 36 | Planning Level Code | Integer | - |
| 37 | Ref. Order Status | Enum Production Order Status | - |
| 38 | Ref. Order No. | Code[20] | - |
| 39 | Ref. Order Line No. | Integer | - |
| 40 | Length | Decimal | - |
| 41 | Width | Decimal | - |
| 42 | Weight | Decimal | - |
| 43 | Depth | Decimal | - |
| 44 | Calculation Formula | Enum Quantity Calculation Formula | - |
| 45 | Quantity per | Decimal | - |
| 46 | Ref. Order Type | Enum Requisition Ref. Order Type | - |
| 50 | Unit Cost | Decimal | - |
| 51 | Cost Amount | Decimal | - |
| 52 | Due Date | Date | - |
| 53 | Due Time | Time | - |
| 55 | Direct Unit Cost | Decimal | - |
| 56 | Indirect Cost % | Decimal | - |
| 57 | Overhead Rate | Decimal | - |
| 58 | Direct Cost Amount | Decimal | - |
| 59 | Overhead Amount | Decimal | - |
| 60 | Qty. per Unit of Measure | Decimal | - |
| 62 | Quantity (Base) | Decimal | - |
| 63 | Reserved Qty. (Base) | Decimal | - |
| 71 | Reserved Quantity | Decimal | - |
| 73 | Expected Quantity (Base) | Decimal | - |
| 74 | Original Expected Qty. (Base) | Decimal | - |
| 75 | Net Quantity (Base) | Decimal | - |
| 76 | Due Date-Time | DateTime | - |
| 480 | Dimension Set ID | Integer | - |
| 99000875 | Critical | Boolean | - |
| 99000915 | Planning Line Origin | Enum Planning Line Origin Type | - |
Keys, 4
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Line No. | - |
| Key2 | Item No., Variant Code, Location Code, Due Date, Planning Line Origin | - |
| Key3 | Item No., Variant Code, Location Code, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code, Planning Line Origin, Due Date | - |
| Key4 | Worksheet Template Name, Worksheet Batch Name, Worksheet Line No., Item No. | - |
Procedures, 31
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| Caption | () | Text | public | - |
| ShowReservation | () | Boolean | public | - |
| ShowReservationEntries | (Boolean) | public | - | |
| TransferFromAsmLine | (var Record Assembly Line) | public | - | |
| BlockDynamicTracking | (Boolean) | public | - | |
| OpenItemTrackingLines | () | public | - | |
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | |
| GetDefaultBin | () | 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 | - |
| FindLinesWithItemToPlan | (var Record Item) | Boolean | public | - |
| FindLinesForReservation | (Record Reservation Entry, Text, Boolean) | public | - | |
| SetRequisitionLine | (Record Requisition Line) | public | - | |
| ShowDimensions | () | public | - | |
| InitFromRequisitionLine | (Record Requisition Line) | public | - | |
| CreateDim | (List) | public | - | |
| CreateDimFromDefaultDim | () | public | - | |
| FilterLinesWithItemToPlan | (var Record Item) | public | - | |
| UpdateDatetime | () | public | - | |
| GetGLSetup | () | public | - | |
| GetItem | () | public | - | |
| GetReqLine | () | public | - | |
| GetLocation | (Code[10]) | public | - | |
| SelectMultipleItems | () | public | - | |
| AddItems | (Text) | public | - | |
| AddItem | (var Record Planning Component, Code[20]) | public | - | |
| InitNewLine | (var Record Planning Component) | public | - |
Events, 22
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterFilterLinesWithItemToPlan | (var Record Planning Component, var Record Item) | - |
| Integration event | OnAfterSetReservationFilters | (var Record Reservation Entry, Record Planning Component) | - |
| Integration event | OnAfterTransferFromAsmLine | (var Record Planning Component, Record Assembly Line) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Planning Component, var Record Planning Component, Integer, var Code[20]) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Planning Component, var Record Planning Component, Integer, var Code[20]) | - |
| Integration event | OnValidateCalculationFormulaEnumExtension | (var Record Planning Component) | - |
| Integration event | OnValidateCalculationFormulaOnAfterSetQuantity | (var Record Planning Component) | - |
| Integration event | OnAfterInitFromRequisitionLine | (var Record Planning Component, Record Requisition Line) | - |
| Integration event | OnAfterValidateItemNo | (var Record Planning Component, Record Item) | - |
| Integration event | OnItemNoOnValidateOnAfterInitFromItem | (var Record Planning Component, Record Item) | - |
| Integration event | OnAfterFindLinesForReservation | (var Record Planning Component, Record Reservation Entry, Text, Boolean) | - |
| Integration event | OnBeforeGetWMSDefaultBin | (var Record Planning Component, var Code[20], var Boolean, Record Location) | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Planning Component, var List) | - |
| Integration event | OnAfterGetItem | (var Record Item, var Record Planning Component) | - |
| Integration event | OnAfterCreateDim | (var Record Planning Component, List) | - |
| Integration event | OnBeforeShowReservation | (var Record Planning Component, var Boolean) | - |
| Integration event | OnBeforeGetUpdateFromSKU | (var Record Planning Component, var Boolean) | - |
| Integration event | OnBeforeValidateCalculationFormula | (var Record Planning Component, var Boolean) | - |
| Integration event | OnAfterGetUpdateFromSKU | (var Record Planning Component, Record Stockkeeping Unit) | - |
| Integration event | OnAfterValidateCalculationFormula | (var Record Planning Component) | - |
| Integration event | OnGetToBinOnBeforeGetWMSDefaultCode | (var Record Planning Component, var Code[20]) | - |
| Integration event | OnBeforeGetDefaultBin | (var Record Planning Component, var Record Planning Component, var Boolean) | - |