Table 901 Assembly Line in 18
- App
- Base Application
Fields, 46Keys, 4Procedures, 63Events, 28
Versions171819202122232425262728latest
Source29
Fields, 46
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Document Type | Enum Assembly Document Type | - |
| 2 | Document No. | Code[20] | - |
| 3 | Line No. | Integer | - |
| 10 | Type | Option | - |
| 11 | No. | Code[20] | - |
| 12 | Variant Code | Code[10] | - |
| 13 | Description | Text[100] | - |
| 14 | Description 2 | Text[50] | - |
| 18 | Lead-Time Offset | DateFormula | - |
| 19 | Resource Usage Type | Option | - |
| 20 | Location Code | Code[10] | - |
| 21 | Shortcut Dimension 1 Code | Code[20] | - |
| 22 | Shortcut Dimension 2 Code | Code[20] | - |
| 23 | Bin Code | Code[20] | - |
| 25 | Position | Code[10] | - |
| 26 | Position 2 | Code[10] | - |
| 27 | Position 3 | Code[10] | - |
| 38 | Appl.-to Item Entry | Integer | - |
| 39 | Appl.-from Item Entry | Integer | - |
| 40 | Quantity | Decimal | - |
| 41 | Quantity (Base) | Decimal | - |
| 42 | Remaining Quantity | Decimal | - |
| 43 | Remaining Quantity (Base) | Decimal | - |
| 44 | Consumed Quantity | Decimal | - |
| 45 | Consumed Quantity (Base) | Decimal | - |
| 46 | Quantity to Consume | Decimal | - |
| 47 | Quantity to Consume (Base) | Decimal | - |
| 48 | Reserved Quantity | Decimal | - |
| 49 | Reserved Qty. (Base) | Decimal | - |
| 50 | Avail. Warning | Boolean | - |
| 51 | Substitution Available | Boolean | - |
| 52 | Due Date | Date | - |
| 53 | Reserve | Enum Reserve Method | - |
| 60 | Quantity per | Decimal | - |
| 61 | Qty. per Unit of Measure | Decimal | - |
| 62 | Inventory Posting Group | Code[20] | - |
| 63 | Gen. Prod. Posting Group | Code[20] | - |
| 65 | Unit Cost | Decimal | - |
| 67 | Cost Amount | Decimal | - |
| 72 | Date Filter | Date | - |
| 80 | Unit of Measure Code | Code[10] | - |
| 480 | Dimension Set ID | Integer | - |
| 7301 | Pick Qty. | Decimal | - |
| 7302 | Pick Qty. (Base) | Decimal | - |
| 7303 | Qty. Picked | Decimal | - |
| 7304 | Qty. Picked (Base) | Decimal | - |
Keys, 4
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Document Type, Document No., Line No. | - |
| Key2 | Document Type, Document No., Type, Location Code | - |
| Key3 | Document Type, Type, No., Variant Code, Location Code, Due Date | - |
| Key4 | Type, No. | - |
Procedures, 63
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| InitRemainingQty | () | public | - | ||||
| InitQtyToConsume | () | public | - | ||||
| MaxQtyToConsume | () | Decimal | public | - | |||
| GetUnitCost | () | Decimal | public | - | |||
| CalcCostAmount | (Decimal, Decimal) | Decimal | public | - | |||
| ShowReservation | () | public | - | ||||
| ShowReservationEntries | (Boolean) | public | - | ||||
| UpdateAvailWarning | () | Boolean | public | - | |||
| ShowAvailabilityWarning | () | public | - | ||||
| ShowAvailabilityWarningPage | () | public | - | ||||
| IsInbound | () | Boolean | public | - | |||
| OpenItemTrackingLines | () | public | - | ||||
| AutoReserve | () | public | - | ||||
| ReservationStatus | () | Integer | public | - | |||
| SetTestReservationDateConflict | (Boolean) | public | - | ||||
| GetRemainingQty | (var Decimal, var Decimal) | public | - | ||||
| GetReservationQty | (var Decimal, var Decimal, var Decimal, var Decimal) | Decimal | public | - | |||
| GetSourceCaption | () | Text[80] | public | - | |||
| SetReservationEntry | (var Record Reservation Entry) | public | - | ||||
| SetReservationFilters | (var Record Reservation Entry) | public | - | ||||
| ReservEntryExist | () | Boolean | public | - | |||
| ShowDimensions | () | public | - | ||||
| CreateDim | (Integer, Code[20], Integer) | public | - | ||||
| UpdateDim | (Integer, Integer) | public | - | ||||
| ValidateShortcutDimCode | (Integer, var Code[20]) | public | - | ||||
| ShowShortcutDimCode | (var Code[20]) | public | - | ||||
| ShowItemSub | () | public | - | ||||
| ShowAssemblyList | () | public | - | ||||
| ExplodeAssemblyList | () | public | - | ||||
| CalcQuantityPer | (Decimal) | Decimal | public | - | |||
| CalcQuantityFromBOM | (Option, Decimal, Decimal, Decimal, Option) | Decimal | public | - | |||
| SetItemToPlanFilters | (var Record Item, Enum Assembly Document Type) | public | - | ||||
| FilterLinesWithItemToPlan | (var Record Item, Option) | public | Pending 17.0 | ||||
| Replaced by SetItemToPlanFilters(). | |||||||
| FindItemToPlanLines | (var Record Item, Enum Assembly Document Type) | Boolean | public | - | |||
| FindLinesWithItemToPlan | (var Record Item, Option) | Boolean | public | Pending 17.0 | |||
| Replaced by FindItemToPlanLines(). | |||||||
| ItemToPlanLinesExist | (var Record Item, Enum Assembly Document Type) | Boolean | public | - | |||
| LinesWithItemToPlanExist | (var Record Item, Option) | Boolean | public | Pending 17.0 | |||
| Replaced by ItemToPlanLinesExist(). | |||||||
| FilterLinesForReservation | (Record Reservation Entry, Option, Text, Boolean) | public | - | ||||
| SetItemFilter | (var Record Item) | public | - | ||||
| CalcAvailToAssemble | (Record Assembly Header, var Record Item, var Decimal, var Decimal, var Decimal, var Decimal, var Date, var Decimal) | public | - | ||||
| FixedUsage | () | Boolean | public | - | |||
| SignedXX | (Decimal) | Decimal | public | - | |||
| RowID1 | () | Text[250] | public | - | |||
| GetDefaultBin | () | public | - | ||||
| FindBin | () | Code[20] | public | - | |||
| TestStatusOpen | () | public | - | ||||
| SuspendStatusCheck | (Boolean) | public | - | ||||
| CompletelyPicked | () | Boolean | public | - | |||
| CalcQtyToPick | () | Decimal | public | - | |||
| CalcQtyToPickBase | () | Decimal | public | - | |||
| CalcQtyPickedNotConsumed | () | Decimal | public | - | |||
| CalcQtyPickedNotConsumedBase | () | Decimal | public | - | |||
| ItemExists | (Code[20]) | Boolean | public | - | |||
| ShowTracking | () | public | - | ||||
| VerifyReservationQuantity | (var Record Assembly Line, var Record Assembly Line) | public | - | ||||
| VerifyReservationChange | (var Record Assembly Line, var Record Assembly Line) | public | - | ||||
| VerifyReservationDateConflict | (Record Assembly Line) | public | - | ||||
| SetSkipVerificationsThatChangeDatabase | (Boolean) | public | - | ||||
| GetSkipVerificationsThatChangeDatabase | () | Boolean | public | - | |||
| ValidateDueDate | (Record Assembly Header, Date, Boolean) | public | - | ||||
| ValidateLeadTimeOffset | (Record Assembly Header, DateFormula, Boolean) | public | - | ||||
| TestItemFields | (Code[20], Code[10], Code[10]) | public | - | ||||
| IsInventoriableItem | () | Boolean | public | - | |||
Events, 28
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCalcExpectedInventory | (var Record Assembly Line, var Record Item, var Decimal) | - |
| Integration event | OnAfterCopyFromItem | (var Record Assembly Line, Record Item, Record Assembly Header) | - |
| Integration event | OnAfterCopyFromResource | (var Record Assembly Line, Record Resource, Record Assembly Header) | - |
| Integration event | OnAfterCreateDimTableIDs | (var Record Assembly Line, Integer, var Integer, var Code[20]) | - |
| Integration event | OnAfterFilterLinesWithItemToPlan | (var Record Assembly Line, Record Item, Option) | - |
| Integration event | OnAfterGetSKU | (Record Assembly Line, var Boolean) | - |
| Integration event | OnAfterGetUnitCost | (var Record Assembly Line, var Decimal) | - |
| Integration event | OnAfterInitRemainingQty | (var Record Assembly Line, Record Assembly Line, Integer) | - |
| Integration event | OnAfterInitQtyToConsume | (var Record Assembly Line, Record Assembly Line, Integer) | - |
| Integration event | OnAfterSetReservationFilters | (var Record Reservation Entry, Record Assembly Line) | - |
| Integration event | OnAfterValidateShortcutDimCode | (var Record Assembly Line, var Record Assembly Line, Integer, var Code[20]) | - |
| Integration event | OnBeforeAutoReserve | (var Record Assembly Line, var Boolean) | - |
| Integration event | OnBeforeCalcQtyToPick | (var Record Assembly Line, var Decimal, var Boolean) | - |
| Integration event | OnBeforeCalcQtyToPickBase | (var Record Assembly Line, var Decimal, var Boolean) | - |
| Integration event | OnBeforeInitQtyToConsume | (var Record Assembly Line, Record Assembly Line, Integer) | - |
| Integration event | OnBeforeValidateShortcutDimCode | (var Record Assembly Line, var Record Assembly Line, Integer, var Code[20]) | - |
| Integration event | OnBeforeCheckItemAvailable | (var Record Assembly Line, Integer, var Boolean) | - |
| Integration event | OnBeforeCalcAvailQuantities | (var Record Assembly Line) | - |
| Integration event | OnBeforeCopyFromItem | (var Record Assembly Line) | - |
| Integration event | OnBeforeCopyFromResource | (var Record Assembly Line) | - |
| Integration event | OnBeforeShowReservation | (var Record Assembly Line, var Boolean) | - |
| Integration event | OnBeforeUpdateAvailWarning | (var Record Assembly Line, var Boolean, var Boolean) | - |
| Integration event | OnValidateQuantityOnAfterCalcBaseQty | (var Record Assembly Line, Record Assembly Line, Integer) | - |
| Integration event | OnAfterFilterLinesForReservation | (var Record Assembly Line, Record Reservation Entry, Option, Text, Boolean) | - |
| Integration event | OnAfterShowDimensions | (var Record Assembly Line) | - |
| Integration event | OnAfterUpdateDim | (var Record Assembly Line) | - |
| Integration event | OnBeforeValidateDueDate | (var Record Assembly Line, Record Assembly Header, Date, var Boolean) | - |
| Integration event | OnValidateQuantityPerOnAfterRoundQty | (var Record Assembly Line) | - |