Table 336 Tracking Specification in 17
- App
- Base Application
Fields, 43Keys, 4Procedures, 60Events, 51
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 | - |
| 7 | Description | Text[100] | - |
| 8 | Creation Date | Date | - |
| 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 | - |
| 17 | Transfer Item Entry No. | Integer | - |
| 24 | Serial No. | Code[50] | - |
| 28 | Positive | Boolean | - |
| 29 | Qty. per Unit of Measure | Decimal | - |
| 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 | - |
| 52 | Quantity Handled (Base) | Decimal | - |
| 53 | Quantity Invoiced (Base) | Decimal | - |
| 60 | Qty. to Handle | Decimal | - |
| 61 | Qty. to Invoice | Decimal | - |
| 70 | Buffer Status | Option | - |
| 71 | Buffer Status2 | Option | - |
| 72 | Buffer Value1 | Decimal | - |
| 73 | Buffer Value2 | Decimal | - |
| 74 | Buffer Value3 | Decimal | - |
| 75 | Buffer Value4 | Decimal | - |
| 76 | Buffer Value5 | Decimal | - |
| 80 | New Serial No. | Code[50] | - |
| 81 | New Lot No. | Code[50] | - |
| 900 | Prohibit Cancellation | Boolean | - |
| 5400 | Lot No. | Code[50] | - |
| 5401 | Variant Code | Code[10] | - |
| 5402 | Bin Code | Code[20] | - |
| 5811 | Appl.-from Item Entry | Integer | - |
| 5817 | Correction | Boolean | - |
| 6505 | New Expiration Date | Date | - |
| 7300 | Quantity actual Handled (Base) | Decimal | - |
Keys, 4
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Source ID, Source Type, Source Subtype, Source Batch Name, Source Prod. Order Line, Source Ref. No. | - |
| Key3 | Lot No., Serial No. | - |
| Key4 | New Lot No., New Serial No. | - |
Procedures, 60
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| GetLastEntryNo | () | Integer | public | - | |||
| InitQtyToShip | () | public | - | ||||
| InitQtyToInvoice | () | public | - | ||||
| InitFromAsmHeader | (var Record Assembly Header) | public | - | ||||
| InitFromAsmLine | (var Record Assembly Line) | public | - | ||||
| InitFromItemJnlLine | (Record Item Journal Line) | public | - | ||||
| InitFromJobJnlLine | (var Record Job Journal Line) | public | - | ||||
| InitFromPurchLine | (Record Purchase Line) | public | - | ||||
| InitFromProdOrderLine | (var Record Prod. Order Line) | public | - | ||||
| InitFromProdOrderComp | (var Record Prod. Order Component) | public | - | ||||
| InitFromProdPlanningComp | (var Record Planning Component) | public | - | ||||
| InitFromReqLine | (Record Requisition Line) | public | - | ||||
| InitFromSalesLine | (Record Sales Line) | public | - | ||||
| InitFromServLine | (var Record Service Line, Boolean) | public | - | ||||
| InitFromTransLine | (var Record Transfer Line, var Date, Enum Transfer Direction) | public | - | ||||
| CalcQty | (Decimal) | Decimal | public | - | |||
| CopySpecification | (var Record Tracking Specification) | public | - | ||||
| HasSameTracking | (Record Tracking Specification) | Boolean | public | - | |||
| InsertSpecification | () | public | - | ||||
| InitTrackingSpecification | (Integer, Integer, Code[20], Code[10], Integer, Integer, Code[10], Code[10], Code[50], Code[50], Decimal) | public | Pending 17.0 | ||||
| Replaced by InitTrackingSpecification without tracking parameters. | |||||||
| InitTrackingSpecification | (Integer, Integer, Code[20], Code[10], Integer, Integer, Code[10], Code[10], Decimal) | public | - | ||||
| InitExpirationDate | () | public | - | ||||
| IsReclass | () | Boolean | public | - | |||
| TestFieldError | (Text[80], Decimal, Decimal) | public | - | ||||
| SetItemData | (Code[20], Text[100], Code[10], Code[10], Code[20], Decimal) | public | - | ||||
| SetQuantities | (Decimal, Decimal, Decimal, Decimal, Decimal, Decimal, Decimal) | public | - | ||||
| ClearSourceFilter | () | public | - | ||||
| SetSource | (Integer, Integer, Code[20], Integer, Code[10], Integer) | public | - | ||||
| SetSourceFromPurchLine | (Record Purchase Line) | public | - | ||||
| SetSourceFromSalesLine | (Record Sales Line) | public | - | ||||
| SetSourceFromReservEntry | (Record Reservation Entry) | public | - | ||||
| SetSourceFilter | (Integer, Integer, Code[20], Integer, Boolean) | public | - | ||||
| SetSourceFilter | (Code[10], Integer) | public | - | ||||
| ClearTracking | () | public | - | ||||
| ClearTrackingFilter | () | public | - | ||||
| SetTracking | (Code[50], Code[50], Date, Date) | public | Pending 17.0 | ||||
| Replaced by CopyTrackingFrom procedures. | |||||||
| SetTrackingBlank | () | public | - | ||||
| CopyTrackingFromTrackingSpec | (Record Tracking Specification) | public | - | ||||
| CopyNewTrackingFromTrackingSpec | (Record Tracking Specification) | public | - | ||||
| CopyTrackingFromEntrySummary | (Record Entry Summary) | public | - | ||||
| CopyTrackingFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| CopyTrackingFromItemTrackingSetup | (Record Item Tracking Setup) | public | - | ||||
| CopyTrackingFromReservEntry | (Record Reservation Entry) | public | - | ||||
| CopyTrackingFromWhseActivityLine | (Record Warehouse Activity Line) | public | - | ||||
| CopyTrackingFromWhseItemTrackingLine | (Record Whse. Item Tracking Line) | public | - | ||||
| SetTrackingFilter | (Code[50], Code[50]) | public | Pending 17.0 | ||||
| Replaced by SetTrackingFilterFrom procedures. | |||||||
| SetTrackingFilterBlank | () | public | - | ||||
| SetTrackingFilterFromEntrySummary | (Record Entry Summary) | public | - | ||||
| SetTrackingFilterFromItemJnlLine | (Record Item Journal Line) | public | - | ||||
| SetTrackingFilterFromItemLedgEntry | (Record Item Ledger Entry) | public | - | ||||
| SetTrackingFilterFromItemTrackingSetup | (Record Item Tracking Setup) | public | - | ||||
| SetTrackingFilterFromReservEntry | (Record Reservation Entry) | public | - | ||||
| SetNewTrackingFilterFromNewReservEntry | (Record Reservation Entry) | public | - | ||||
| SetTrackingFilterFromSpec | (Record Tracking Specification) | public | - | ||||
| SetTrackingFilterFromWhseActivityLine | (Record Warehouse Activity Line) | public | - | ||||
| SetSkipSerialNoQtyValidation | (Boolean) | public | - | ||||
| CheckItemTrackingQuantity | (Integer, Option, Code[20], Integer, Decimal, Decimal, Boolean, Boolean) | public | - | ||||
| CheckItemTrackingQuantity | (Integer, Option, Code[20], Integer, Integer, Decimal, Decimal, Boolean, Boolean) | public | - | ||||
| TestTrackingFieldsAreBlank | () | public | - | ||||
| TrackingExists | () | Boolean | public | - | |||
Events, 51
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterClearTracking | (var Record Tracking Specification) | - |
| Integration event | OnAfterClearTrackingFilter | (var Record Tracking Specification) | - |
| Integration event | OnAfterCopyTrackingFromReservEntry | (var Record Tracking Specification, Record Reservation Entry) | - |
| Integration event | OnAfterCopyTrackingFromWhseActivityLine | (var Record Tracking Specification, Record Warehouse Activity Line) | - |
| Integration event | OnAfterCopyTrackingFromWhseItemTrackingLine | (var Record Tracking Specification, Record Whse. Item Tracking Line) | - |
| Integration event | OnAfterInitFromAsmHeader | (var Record Tracking Specification, Record Assembly Header) | - |
| Integration event | OnAfterInitFromAsmLine | (var Record Tracking Specification, Record Assembly Line) | - |
| Integration event | OnAfterInitFromItemJnlLine | (var Record Tracking Specification, Record Item Journal Line) | - |
| Integration event | OnAfterInitFromItemLedgEntry | (var Record Tracking Specification, Record Item Ledger Entry) | - |
| Integration event | OnAfterInitFromJobJnlLine | (var Record Tracking Specification, Record Job Journal Line) | - |
| Integration event | OnAfterInitFromPurchLine | (var Record Tracking Specification, Record Purchase Line) | - |
| Integration event | OnAfterInitFromProdOrderLine | (var Record Tracking Specification, Record Prod. Order Line) | - |
| Integration event | OnAfterInitFromProdOrderComp | (var Record Tracking Specification, Record Prod. Order Component) | - |
| Integration event | OnAfterInitFromProdPlanningComp | (var Record Tracking Specification, Record Planning Component) | - |
| Integration event | OnAfterInitFromReqLine | (var Record Tracking Specification, Record Requisition Line) | - |
| Integration event | OnAfterInitFromSalesLine | (var Record Tracking Specification, Record Sales Line) | - |
| Integration event | OnAfterInitFromServLine | (var Record Tracking Specification, Record Service Line) | - |
| Integration event | OnAfterInitFromTransLine | (var Record Tracking Specification, Record Transfer Line, Enum Transfer Direction) | - |
| Integration event | OnAfterInitQtyToInvoice | (var Record Tracking Specification) | - |
| Integration event | OnAfterInitQtyToShip | (var Record Tracking Specification) | - |
| Integration event | OnAfterInitExpirationDate | (var Record Tracking Specification) | - |
| Integration event | OnAfterCopyTrackingFromEntrySummary | (var Record Tracking Specification, Record Entry Summary) | - |
| Integration event | OnAfterCopyTrackingFromItemLedgEntry | (var Record Tracking Specification, Record Item Ledger Entry) | - |
| Integration event | OnAfterCopyTrackingFromItemTrackingSetup | (var Record Tracking Specification, Record Item Tracking Setup) | - |
| Integration event | OnAfterCopyTrackingFromTrackingSpec | (var Record Tracking Specification, Record Tracking Specification) | - |
| Integration event | OnAfterCopyNewTrackingFromTrackingSpec | (var Record Tracking Specification, Record Tracking Specification) | - |
| Integration event | OnAfterSetTrackingBlank | (var Record Tracking Specification) | - |
| Integration event | OnAfterSetTrackingFilterBlank | (var Record Tracking Specification) | - |
| Integration event | OnAfterSetTrackingFilterFromEntrySummary | (var Record Tracking Specification, Record Entry Summary) | - |
| Integration event | OnAfterSetTrackingFilterFromItemJnlLine | (var Record Tracking Specification, Record Item Journal Line) | - |
| Integration event | OnAfterSetTrackingFilterFromItemTrackingSetup | (var Record Tracking Specification, Record Item Tracking Setup) | - |
| Integration event | OnAfterSetTrackingFilterFromItemLedgEntry | (var Record Tracking Specification, Record Item Ledger Entry) | - |
| Integration event | OnAfterSetTrackingFilterFromReservEntry | (var Record Tracking Specification, Record Reservation Entry) | - |
| Integration event | OnAfterSetNewTrackingFilterFromNewReservEntry | (var Record Tracking Specification, Record Reservation Entry) | - |
| Integration event | OnAfterSetTrackingFilterFromTrackingSpec | (var Record Tracking Specification, Record Tracking Specification) | - |
| Integration event | OnAfterSetTrackingFilterFromWhseActivityLine | (var Record Tracking Specification, Record Warehouse Activity Line) | - |
| Integration event | OnAfterLookupApplFromItemEntrySetFilters | (var Record Item Ledger Entry, Record Tracking Specification) | - |
| Integration event | OnAfterTestTrackingFieldsAreBlank | (var Record Tracking Specification) | - |
| Integration event | OnAfterTrackingExist | (var Record Tracking Specification, var Boolean) | - |
| Integration event | OnAfterHasSameTracking | (var Record Tracking Specification, Record Tracking Specification, var Boolean) | - |
| Integration event | OnAfterValidateApplFromItemEntry | (var Record Tracking Specification, Record Item Ledger Entry, Boolean) | - |
| Integration event | OnBeforeCheckSerialNoQty | (var Record Tracking Specification, var Boolean) | - |
| Integration event | OnBeforeClearApplyToEntryIfQuantityToInvoiceIsNotSufficient | (var Record Tracking Specification, var Boolean) | - |
| Integration event | OnBeforeInitQtyToInvoice | (var Record Tracking Specification) | - |
| Integration event | OnBeforeInitQtyToShip | (var Record Tracking Specification) | - |
| Integration event | OnBeforeTestApplyToItemLedgEntry | (var Record Tracking Specification, Record Item Ledger Entry, var Boolean) | - |
| Integration event | OnBeforeTestFieldError | (Text[80], Decimal, Decimal, var Boolean) | - |
| Integration event | OnBeforeUpdateTrackingSpecification | (var Record Tracking Specification, Record Tracking Specification) | - |
| Integration event | OnValidateQtyToHandleOnBeforeInitQtyToInvoice | (var Record Tracking Specification, Record Tracking Specification, Integer) | - |
| Integration event | OnBeforeCheckItemTrackingQuantity | (var Record Tracking Specification, Integer, Option, Code[20], Integer, Integer, var Decimal, var Decimal, var Boolean, var Boolean, var Boolean) | - |
| Integration event | OnBeforeCheckItemTrackingByType | (var Record Reservation Entry, var Decimal, var Decimal, var Boolean, var Boolean, var Boolean, var Boolean) | - |