Table 337 Reservation Entry in 17
- App
- Base Application
Fields, 43Keys, 10Procedures, 65Events, 46
Versions171819202122232425262728latest
Source29
Fields, 43
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Item No. | Code[20] | - |
| 3 | Location Code | Code[10] | - |
| 4 | Quantity (Base) | Decimal | - |
| 5 | Reservation Status | Enum Reservation Status | - |
| 7 | Description | Text[100] | - |
| 8 | Creation Date | Date | - |
| 9 | Transferred from Entry No. | Integer | - |
| 10 | Source Type | Integer | - |
| 11 | Source Subtype | Option | - |
| 12 | Source ID | Code[20] | - |
| 13 | Source Batch Name | Code[10] | - |
| 14 | Source Prod. Order Line | Integer | - |
| 15 | Source Ref. No. | Integer | - |
| 16 | Item Ledger Entry No. | Integer | - |
| 22 | Expected Receipt Date | Date | - |
| 23 | Shipment Date | Date | - |
| 24 | Serial No. | Code[50] | - |
| 25 | Created By | Code[50] | - |
| 27 | Changed By | Code[50] | - |
| 28 | Positive | Boolean | - |
| 29 | Qty. per Unit of Measure | Decimal | - |
| 30 | Quantity | Decimal | - |
| 31 | Action Message Adjustment | Decimal | - |
| 32 | Binding | Enum Reservation Binding | - |
| 33 | Suppressed Action Msg. | Boolean | - |
| 34 | Planning Flexibility | Enum Reservation Planning Flexibility | - |
| 38 | Appl.-to Item Entry | Integer | - |
| 40 | Warranty Date | Date | - |
| 41 | Expiration Date | Date | - |
| 50 | Qty. to Handle (Base) | Decimal | - |
| 51 | Qty. to Invoice (Base) | Decimal | - |
| 53 | Quantity Invoiced (Base) | Decimal | - |
| 80 | New Serial No. | Code[50] | - |
| 81 | New Lot No. | Code[50] | - |
| 900 | Disallow Cancellation | Boolean | - |
| 5400 | Lot No. | Code[50] | - |
| 5401 | Variant Code | Code[10] | - |
| 5811 | Appl.-from Item Entry | Integer | - |
| 5817 | Correction | Boolean | - |
| 6505 | New Expiration Date | Date | - |
| 6510 | Item Tracking | Enum Item Tracking Entry Type | - |
| 6511 | Untracked Surplus | Boolean | - |
Keys, 10
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No., Positive | - |
| Key2 | Source ID, Source Ref. No., Source Type, Source Subtype, Source Batch Name, Source Prod. Order Line, Reservation Status, Shipment Date, Expected Receipt Date | - |
| Key3 | Item No., Variant Code, Location Code | - |
| Key4 | Item No., Variant Code, Location Code, Reservation Status, Shipment Date, Expected Receipt Date, Serial No., Lot No. | - |
| Key5 | Item No., Source Type, Source Subtype, Reservation Status, Location Code, Variant Code, Shipment Date, Expected Receipt Date, Serial No., Lot No. | - |
| Key6 | Item No., Variant Code, Location Code, Item Tracking, Reservation Status, Lot No., Serial No. | - |
| Key7 | Lot No. | - |
| Key8 | Serial No. | - |
| Key9 | Source Type, Source Subtype, Source ID, Source Batch Name, Source Prod. Order Line, Source Ref. No. | - |
| Key10 | Reservation Status, Item No., Variant Code, Location Code, Expected Receipt Date | - |
Procedures, 65
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| GetLastEntryNo | () | Integer | public | - | |||
| InitSortingAndFilters | (Boolean) | public | - | ||||
| TextCaption | () | Text[255] | public | - | |||
| SummEntryNo | () | Integer | public | - | |||
| HasSamePointer | (Record Reservation Entry) | Boolean | public | - | |||
| HasSamePointerWithSpec | (Record Tracking Specification) | Boolean | public | - | |||
| HasSameTracking | (Record Reservation Entry) | Boolean | public | - | |||
| HasSameTrackingWithSpec | (Record Tracking Specification) | Boolean | public | - | |||
| HasSameNewTracking | (Record Reservation Entry) | Boolean | public | - | |||
| SetPointer | (Text[250]) | public | - | ||||
| SetPointerFilter | () | public | - | ||||
| SetSourceFilterFromReservEntry | (Record Reservation Entry) | public | - | ||||
| Lock | () | public | - | ||||
| SetItemData | (Code[20], Text[100], Code[10], Code[10], Decimal) | public | - | ||||
| SetSource | (Integer, Integer, Code[20], Integer, Code[10], Integer) | public | - | ||||
| SetSourceFilter | (Integer, Integer, Code[20], Integer, Boolean) | public | - | ||||
| SetSourceFilter | (Code[10], Integer) | public | - | ||||
| ClearTracking | () | public | - | ||||
| ClearNewTracking | () | public | - | ||||
| ClearTrackingFilter | () | public | - | ||||
| CopyTrackingFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| CopyTrackingFromItemTrackingSetup | (Record Item Tracking Setup) | public | - | ||||
| CopyTrackingFromInvtProfile | (Record Inventory Profile) | public | - | ||||
| CopyTrackingFromReservEntry | (Record Reservation Entry) | public | - | ||||
| CopyTrackingFromReservEntryNewTracking | (Record Reservation Entry) | public | - | ||||
| CopyTrackingFromSpec | (Record Tracking Specification) | public | - | ||||
| CopyTrackingFromWhseActivLine | (Record Warehouse Activity Line) | public | - | ||||
| CopyTrackingFromWhseEntry | (Record Warehouse Entry) | public | - | ||||
| CopyTrackingFromWhseItemTrackingLine | (Record Whse. Item Tracking Line) | public | - | ||||
| CopyNewTrackingFromItemJnlLine | (Record Item Journal Line) | public | - | ||||
| CopyNewTrackingFromTrackingSpec | (Record Tracking Specification) | public | - | ||||
| CopyNewTrackingFromWhseItemTrackingLine | (Record Whse. Item Tracking Line) | public | - | ||||
| CopyTrackingFiltersToReservEntry | (var Record Reservation Entry) | public | - | ||||
| FilterLinesForTracking | (Record Reservation Entry, Boolean) | public | - | ||||
| SetTrackingFilter | (Code[50], Code[50]) | public | Pending 17.0 | ||||
| Replaced by SetTrackingFilterFrom procedures. | |||||||
| SetTrackingFilterBlank | () | public | - | ||||
| SetTrackingFilterFromItemJnlLine | (Record Item Journal Line) | public | - | ||||
| SetTrackingFilterFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| SetTrackingFilterFromItemTrackingSetup | (Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterFromItemTrackingSetupIfNotBlank | (Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterFromReservEntry | (Record Reservation Entry) | public | - | ||||
| SetTrackingFilterFromSpec | (Record Tracking Specification) | public | - | ||||
| SetTrackingFilterFromSpecIfNotBlank | (Record Tracking Specification) | public | - | ||||
| SetTrackingFilterFromWhseActivityLine | (Record Warehouse Activity Line) | public | - | ||||
| SetTrackingFilterFromWhseJnlLine | (Record Warehouse Journal Line) | public | - | ||||
| SetTrackingFilterFromWhseSpec | (Record Whse. Item Tracking Line) | public | - | ||||
| SetTrackingFilterFromWhseActivityLineIfRequired | (Record Warehouse Activity Line, Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterFromWhseItemTrackingSetupNotBlankIfRequired | (Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterFromWhseItemTrackingSetupIfRequired | (Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterToItemIfRequired | (var Record Item) | public | - | ||||
| GetItemTrackingEntryType | () | Enum Item Tracking Entry Type | public | - | |||
| UpdateItemTracking | () | public | - | ||||
| UpdateActionMessageEntries | (Record Reservation Entry) | public | - | ||||
| ClearItemTrackingFields | () | public | - | ||||
| ClearApplFromToItemEntry | () | public | - | ||||
| IsResidualSurplus | () | Boolean | public | - | |||
| TestItemFields | (Code[20], Code[10], Code[10]) | public | - | ||||
| TrackingExists | () | Boolean | public | - | |||
| GetTrackingText | () | Text | public | - | |||
| NewTrackingExists | () | Boolean | public | - | |||
| TransferReservations | (var Record Reservation Entry, Code[20], Code[10], Code[10], Boolean, Decimal, Decimal, Integer, Option, Code[20], Code[10], Integer, Integer) | public | - | ||||
| FieldFilterNeeded | (var Text, Boolean, Enum Item Tracking Type) | Boolean | public | - | |||
| GetAvailabilityFilter | (Date, Boolean) | Text | public | - | |||
| IsReservationOrTracking | () | Boolean | public | - | |||
| GetTransferDirection | () | Enum Transfer Direction | public | - | |||
Events, 46
| Kind | Name | Parameters | Obsolete | ||||
|---|---|---|---|---|---|---|---|
| Integration event | OnAfterCopyTrackingFromItemLedgEntry | (var Record Reservation Entry, Record Item Ledger Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFromItemTrackingSetup | (var Record Reservation Entry, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterCopyTrackingFromInvtProfile | (var Record Reservation Entry, Record Inventory Profile) | - | ||||
| Integration event | OnAfterCopyTrackingFromReservEntry | (var Record Reservation Entry, Record Reservation Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFromReservEntryNewTracking | (var Record Reservation Entry, Record Reservation Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFromTrackingSpec | (var Record Reservation Entry, Record Tracking Specification) | - | ||||
| Integration event | OnAfterCopyTrackingFromWhseActivLine | (var Record Reservation Entry, Record Warehouse Activity Line) | - | ||||
| Integration event | OnAfterCopyTrackingFromWhseEntry | (var Record Reservation Entry, Record Warehouse Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFromWhseItemTrackingLine | (var Record Reservation Entry, Record Whse. Item Tracking Line) | - | ||||
| Integration event | OnAfterCopyNewTrackingFromWhseItemTrackingLine | (var Record Reservation Entry, Record Whse. Item Tracking Line) | - | ||||
| Integration event | OnAfterClearItemTrackingFields | (var Record Reservation Entry) | - | ||||
| Integration event | OnAfterClearTracking | (var Record Reservation Entry) | - | ||||
| Integration event | OnAfterClearNewTracking | (var Record Reservation Entry) | - | ||||
| Integration event | OnAfterClearTrackingFilter | (var Record Reservation Entry) | - | ||||
| Integration event | OnAfterCopyTrackingFiltersToResernEntry | (var Record Reservation Entry, var Record Reservation Entry) | Pending 17.0 | ||||
| Replaced by OnAfterCopyTrackingFiltersToReservEntry(). | |||||||
| Integration event | OnAfterCopyTrackingFiltersToReservEntry | (var Record Reservation Entry, var Record Reservation Entry) | - | ||||
| Integration event | OnAfterFilterLinesForTracking | (var Record Reservation Entry, Record Reservation Entry, Boolean) | - | ||||
| Integration event | OnAfterSetNewTrackingFromItemJnlLine | (var Record Reservation Entry, Record Item Journal Line) | - | ||||
| Integration event | OnAfterSetNewTrackingFromTrackingSpecification | (var Record Reservation Entry, Record Tracking Specification) | - | ||||
| Integration event | OnAfterSetTrackingFilterBlank | (var Record Reservation Entry) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromItemJnlLine | (var Record Reservation Entry, Record Item Journal Line) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromItemLedgEntry | (var Record Reservation Entry, Record Item Ledger Entry) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromItemTrackingSetup | (var Record Reservation Entry, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromItemTrackingSetupIfNotBlank | (var Record Reservation Entry, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromReservEntry | (var Record Reservation Entry, Record Reservation Entry) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromSpecIfNotBlank | (var Record Reservation Entry, Record Tracking Specification) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromTrackingSpec | (var Record Reservation Entry, Record Tracking Specification) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseActivityLine | (var Record Reservation Entry, Record Warehouse Activity Line) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseJnlLine | (var Record Reservation Entry, Record Warehouse Journal Line) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseSpec | (var Record Reservation Entry, Record Whse. Item Tracking Line) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseActivityLineIfRequired | (var Record Reservation Entry, Record Warehouse Activity Line, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseItemTrackingSetupNotBlankIfRequired | (var Record Reservation Entry, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterSetTrackingFilterFromWhseItemTrackingSetupIfRequired | (var Record Reservation Entry, Record Item Tracking Setup) | - | ||||
| Integration event | OnAfterSetTrackingFilterToItemIfRequired | (Record Reservation Entry, var Record Item) | - | ||||
| Integration event | OnAfterGetItemTrackingEntryType | (Record Reservation Entry, var Enum Item Tracking Entry Type) | - | ||||
| Integration event | OnAfterTextCaption | (Integer, var Text[255]) | - | ||||
| Integration event | OnAfterGetTrackingText | (Record Reservation Entry, var Text) | - | ||||
| Integration event | OnBeforeClearItemTrackingFields | (Record Reservation Entry) | - | ||||
| Integration event | OnAfterHasSameTracking | (Record Reservation Entry, Record Reservation Entry, var Boolean) | - | ||||
| Integration event | OnAfterHasSameNewTracking | (Record Reservation Entry, Record Reservation Entry, var Boolean) | - | ||||
| Integration event | OnAfterHasSameTrackingWithSpec | (Record Reservation Entry, Record Tracking Specification, var Boolean) | - | ||||
| Integration event | OnAfterTrackingExists | (Record Reservation Entry, var Boolean) | - | ||||
| Integration event | OnAfterNewTrackingExists | (Record Reservation Entry, var Boolean) | - | ||||
| Integration event | OnBeforeSummEntryNo | (Record Reservation Entry, var Integer, var Boolean) | - | ||||
| Integration event | OnBeforeTestItemFields | (Record Reservation Entry, Code[20], Code[10], Code[10], var Boolean) | - | ||||
| Integration event | OnBeforeTransferReservations | (var Record Reservation Entry, Code[20], Code[10], Code[10], Boolean, Decimal, Decimal, Integer, Option, Code[20], Code[10], Integer, Integer, var Boolean) | - | ||||