Table 901 Assembly Line in 27
- App
- Base Application
- Namespace
- Microsoft.Assembly.Document
Fields, 49Keys, 4Procedures, 70Events, 47
Versions171819202122232425262728latest
Source29
Fields, 49
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Document Type | Enum Assembly Document Type | - |
| 2 | Document No. | Code[20] | - |
| 3 | Line No. | Integer | - |
| 10 | Type | Enum BOM Component Type | - |
| 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] | - |
| 64 | Gen. Bus. Posting Group | Code[20] | - |
| 65 | Unit Cost | Decimal | - |
| 67 | Cost Amount | Decimal | - |
| 72 | Date Filter | Date | - |
| 80 | Unit of Measure Code | Code[10] | - |
| 82 | Qty. Rounding Precision | Decimal | - |
| 83 | Qty. Rounding Precision (Base) | Decimal | - |
| 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, 70
| 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 | - | |
| 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 | - |
| SetItemToPlanFilters | (var Record Item, Enum Assembly Document Type) | public | - | |
| FindItemToPlanLines | (var Record Item, Enum Assembly Document Type) | Boolean | public | - |
| ItemToPlanLinesExist | (var Record Item, Enum Assembly Document Type) | Boolean | public | - |
| 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 | - |
| CalcBOMQuantity | (Enum BOM Component Type, Decimal, Decimal, Decimal, Option) | Decimal | public | - |
| RoundQty | (var Decimal) | public | - | |
| CheckItemAvailable | (Integer) | public | - | |
| GetHeader | () | Record Assembly Header | public | - |
| CreateDim | (List, Integer) | public | - | |
| CreateDimFromDefaultDim | (Integer) | public | - | |
| SetAssemblyHeader | (Record Assembly Header) | public | - | |
| CheckIfAssemblyLineMeetsReservedFromStockSetting | (Decimal, Enum Reservation From Stock) | Boolean | public | - |
| SuspendDeletionCheck | (Boolean) | public | - | |
| ShowAssemblyDocument | () | internal | - | |
| CalcBaseQty | (Decimal, Text, Text) | Decimal | public | - |
| GetSuspendDeletionCheck | () | Boolean | public | - |
Events, 47
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| 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 | 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) | - |
| Integration event | OnBeforeGetHeader | (var Record Assembly Line, var Record Assembly Header, var Boolean) | - |
| Integration event | OnBeforeFindBin | (var Record Assembly Line, var Code[20], var Boolean) | - |
| Integration event | OnBeforeValidateQuantityBase | (var Record Assembly Line, var Record Assembly Line, Integer, var Boolean) | - |
| Integration event | OnBeforeCalcAvailBaseQuantities | (var Record Assembly Line, var Record Item, var Decimal, var Decimal, var Decimal, var Decimal, var Decimal, var Boolean) | - |
| Integration event | OnBeforeValidateQuantitytoConsume | (var Record Assembly Line, Record Assembly Line, Integer, var Boolean) | - |
| Integration event | OnAfterInitDefaultDimensionSources | (var Record Assembly Line, var List) | - |
| Integration event | OnAfterCreateDim | (var Record Assembly Line, List, Integer) | - |
| Integration event | OnBeforeOpenItemTrackingLines | (var Record Assembly Line, var Boolean) | - |
| Integration event | OnValidateApplToItemEntryOnBeforeShowNotOpenItemLedgerEntryMessage | (var Record Assembly Line, Record Assembly Line, var Record Item Ledger Entry, Integer) | - |
| Integration event | OnAfterCalcExpectedInventory | (var Record Assembly Line, var Record Item, var Decimal, Decimal, Decimal, Decimal, Decimal, Decimal) | - |
| Integration event | OnBeforeGetItemResource | (Record Assembly Line, var Record Item, var Record Resource, var Boolean) | - |
| Integration event | OnBeforeValidateQuantityPer | (var Record Assembly Line, Record Assembly Line, var Boolean) | - |
| Integration event | OnBeforeInitTableValuePair | (var Dictionary, Integer, var Boolean, var Record Assembly Line) | - |
| Integration event | OnAfterInitTableValuePair | (var Dictionary, Integer, var Record Assembly Line) | - |
| Integration event | OnAfterFindBin | (var Record Assembly Line, var Code[20]) | - |
| Integration event | OnBeforeCalcBOMQuantity | (var Record Assembly Line, Enum BOM Component Type, Decimal, Decimal, Decimal, Option, var Decimal, var Boolean) | - |
| Integration event | OnBeforeCreateDim | (var Record Assembly Line, Integer, List, Integer, var Boolean) | - |
| Integration event | OnCheckIfAssemblyLineMeetsReservedFromStockSetting | (Decimal, Enum Reservation From Stock, var Boolean) | - |
| Integration event | OnBeforeSetQtyPerUoMAndQtyRoundingPrecision | (var Record Assembly Line, var Boolean) | - |
| Integration event | OnValidateVariantCodeOnUpdateDescriptionsFromItem | (var Record Assembly Line, Record Item) | - |
| Integration event | OnValidateVariantCodeOnUpdateDescriptionsFromVariantCode | (var Record Assembly Line, Record Item Variant) | - |