Table 99000853 Inventory Profile in 28
- App
- Base Application
- Namespace
- Microsoft.Inventory.Tracking
Fields, 59Keys, 4Procedures, 21Events, 18
Versions171819202122232425262728latest
Source29
Fields, 59
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 3 | Line No. | Integer | - |
| 4 | Attribute Priority | Integer | - |
| 5 | Order Priority | Integer | - |
| 11 | Item No. | Code[20] | - |
| 12 | Variant Code | Code[10] | - |
| 13 | Location Code | Code[10] | - |
| 14 | Bin Code | Code[20] | - |
| 15 | IsSupply | Boolean | - |
| 16 | Order Relation | Option | - |
| 21 | Source Type | Integer | - |
| 22 | Source Order Status | Integer | - |
| 23 | Source ID | Code[20] | - |
| 24 | Source Batch Name | Code[10] | - |
| 25 | Source Ref. No. | Integer | - |
| 26 | Source Prod. Order Line | Integer | - |
| 27 | Primary Order Status | Integer | - |
| 28 | Primary Order No. | Code[20] | - |
| 29 | Primary Order Line | Integer | - |
| 30 | Primary Order Type | Integer | - |
| 31 | Original Quantity | Decimal | - |
| 32 | Remaining Quantity (Base) | Decimal | - |
| 33 | Untracked Quantity | Decimal | - |
| 34 | Original Due Date | Date | - |
| 35 | Due Date | Date | - |
| 36 | Planning Flexibility | Enum Inventory Planning Flexibility | - |
| 37 | Fixed Date | Date | - |
| 38 | Action Message | Enum Action Message Type | - |
| 39 | Binding | Enum Reservation Binding | - |
| 40 | Quantity (Base) | Decimal | - |
| 41 | Min. Quantity | Decimal | - |
| 42 | Starting Date | Date | - |
| 43 | Planning Line No. | Integer | - |
| 44 | Unit of Measure Code | Code[10] | - |
| 45 | Qty. per Unit of Measure | Decimal | - |
| 46 | Quantity | Decimal | - |
| 47 | Remaining Quantity | Decimal | - |
| 48 | Finished Quantity | Decimal | - |
| 50 | Planning Level Code | Integer | - |
| 51 | Planning Line Phase | Option | - |
| 52 | Due Time | Time | - |
| 53 | Sell-to Customer No. | Code[20] | - |
| 54 | Drop Shipment | Boolean | - |
| 55 | Special Order | Boolean | - |
| 56 | Ref. Order No. | Code[20] | - |
| 57 | Ref. Line No. | Integer | - |
| 58 | Derived from Blanket Order | Boolean | - |
| 59 | Ref. Blanket Order No. | Code[20] | - |
| 60 | Tracking Reference | Integer | - |
| 61 | Lot No. | Code[50] | - |
| 62 | Serial No. | Code[50] | - |
| 63 | Max. Quantity | Decimal | - |
| 64 | Safety Stock Quantity | Decimal | - |
| 65 | Is Exception Order | Boolean | - |
| 66 | Transfer Location Not Planned | Boolean | - |
| 67 | Expiration Date | Date | - |
| 68 | Ref. Order Type | Enum Requisition Ref. Order Type | - |
| 69 | Disallow Cancellation | Boolean | - |
| 70 | MPS Order | Boolean | - |
| 6515 | Package No. | Code[50] | - |
Keys, 4
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Line No. | - |
| Key2 | Item No., Variant Code, Location Code, Due Date, Attribute Priority, Order Priority | - |
| Key3 | Item No., Variant Code, Location Code, IsSupply, Primary Order Status, Primary Order No., Due Date, Order Priority | - |
| Key4 | Source Type, Source Order Status, Source ID, Source Batch Name, Source Ref. No., Source Prod. Order Line, IsSupply, Due Date | - |
Procedures, 21
| Name | Parameters | Returns | Access | Obsolete |
|---|---|---|---|---|
| TransferFromItemLedgerEntry | (var Record Item Ledger Entry, var Record Reservation Entry) | public | - | |
| TransferFromOutboundTransfPlan | (var Record Requisition Line, var Record Reservation Entry) | public | - | |
| TransferFromOutboundTransfer | (var Record Transfer Line, var Record Reservation Entry) | public | - | |
| TransferFromInboundTransfer | (var Record Transfer Line, var Record Reservation Entry) | public | - | |
| TransferBindings | (var Record Reservation Entry, var Record Reservation Entry) | Decimal | public | - |
| TransferQtyFromItemTrgkEntry | (var Record Reservation Entry) | public | - | |
| ReduceQtyByItemTracking | (var Record Inventory Profile) | public | - | |
| ChangeSign | () | public | - | |
| TransferToTrackingEntry | (var Record Reservation Entry, Boolean) | public | - | |
| ActiveInWarehouse | () | Boolean | public | - |
| SetSource | (Integer, Integer, Code[20], Integer, Code[10], Integer) | public | - | |
| CopyTrackingFromItemLedgEntry | (Record Item Ledger Entry) | public | - | |
| CopyTrackingFromInvtProfile | (Record Inventory Profile) | public | - | |
| CopyTrackingFromReservEntry | (Record Reservation Entry) | public | - | |
| SetTrackingFilter | (Record Inventory Profile) | public | - | |
| TrackingExists | () | Boolean | public | - |
| SetTrackingFilterFromInvtProfile | (Record Inventory Profile) | public | - | |
| SetSourceFilter | (Integer, Integer, Code[20], Integer, Code[10], Integer) | public | - | |
| CalcReservedQty | (var Record Reservation Entry, var Decimal) | public | - | |
| SetSourceTypeFilter | (Integer) | public | - | |
| InsertSupplyInvtProfile | (Date) | public | - |
Events, 18
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnAfterCopyTrackingFromItemLedgEntry | (var Record Inventory Profile, Record Item Ledger Entry) | - |
| Integration event | OnAfterCopyTrackingFromInvtProfile | (var Record Inventory Profile, Record Inventory Profile) | - |
| Integration event | OnAfterCopyTrackingFromReservEntry | (var Record Inventory Profile, Record Reservation Entry) | - |
| Integration event | OnAfterTransferFromItemLedgerEntry | (var Record Inventory Profile, Record Item Ledger Entry) | - |
| Integration event | OnAfterTransferFromInboundTransfer | (var Record Inventory Profile, Record Transfer Line) | - |
| Integration event | OnAfterTransferFromOutboundTransfPlan | (var Record Inventory Profile, Record Requisition Line) | - |
| Integration event | OnAfterTransferFromOutboundTransfer | (var Record Inventory Profile, Record Transfer Line) | - |
| Integration event | OnAfterTransferToTrackingEntry | (var Record Reservation Entry, Record Inventory Profile, Boolean) | - |
| Integration event | OnAfterTrackingExists | (Record Inventory Profile, var Boolean) | - |
| Integration event | OnAfterSetTrackingFilter | (var Record Inventory Profile, Record Inventory Profile) | - |
| Integration event | OnTransferBindingsOnAfterAssignPrimaryOrderInfo | (var Record Inventory Profile, Record Reservation Entry) | - |
| Integration event | OnTransferToTrackingEntrySourceTypeElseCase | (var Record Inventory Profile, var Record Reservation Entry, Boolean, var Boolean) | - |
| Integration event | OnAfterSetTrackingFilterFromInvtProfile | (var Record Inventory Profile, Record Inventory Profile) | - |
| Integration event | OnBeforeTransferBindings | (var Record Reservation Entry, var Record Reservation Entry, var Decimal, var Boolean) | - |
| Integration event | OnCalcReservedQtyOnBeforeReservationEntryLoop | (var Record Reservation Entry, var Decimal, var Boolean) | - |
| Integration event | OnAfterTransferQtyFromItemTrgkEntry | (var Record Inventory Profile, Record Reservation Entry) | - |
| Integration event | OnAfterReduceQtyByItemTracking | (var Record Inventory Profile, Record Inventory Profile) | - |
| Integration event | OnAfterChangeSign | (var Record Inventory Profile) | - |