Table 339 Item Application Entry in 27
- App
- Base Application
- Namespace
- Microsoft.Inventory.Ledger
Fields, 19Keys, 8Procedures, 30Events, 7
Versions171819202122232425262728latest
Source29
Fields, 19
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Item Ledger Entry No. | Integer | - |
| 3 | Inbound Item Entry No. | Integer | - |
| 4 | Outbound Item Entry No. | Integer | - |
| 11 | Quantity | Decimal | - |
| 20 | Item Register No. | Integer | - |
| 21 | Posting Date | Date | - |
| 23 | Transferred-from Entry No. | Integer | - |
| 25 | Creation Date | DateTime | - |
| 26 | Created By User | Code[50] | - |
| 27 | Last Modified Date | DateTime | - |
| 28 | Last Modified By User | Code[50] | - |
| 101 | Item No. | Code[20] | - |
| 102 | Location Code | Code[10] | - |
| 103 | Variant Code | Code[10] | - |
| 111 | Latest Valuation Date | Date | - |
| 5800 | Cost Application | Boolean | - |
| 5804 | Output Completely Invd. Date | Date | - |
| 5805 | Outbound Entry is Updated | Boolean | - |
Keys, 8
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Posting Date, Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Cost Application | - |
| Key3 | Outbound Item Entry No., Item Ledger Entry No., Cost Application, Transferred-from Entry No. | - |
| Key4 | Transferred-from Entry No., Cost Application | - |
| Key5 | Inbound Item Entry No., Outbound Item Entry No., Cost Application | - |
| Key6 | Item Ledger Entry No., Output Completely Invd. Date | - |
| Key9 | Inbound Item Entry No., Transferred-from Entry No., Item Ledger Entry No. | - |
| Key10 | Inbound Item Entry No., Item Ledger Entry No., Outbound Item Entry No., Cost Application | - |
Procedures, 30
| Name | Parameters | Returns | Access | Obsolete | |||
|---|---|---|---|---|---|---|---|
| AppliedOutbndEntryExists | (Integer, Boolean, Boolean) | Boolean | public | - | |||
| AppliedInbndTransEntryExists | (Integer, Boolean) | Boolean | public | - | |||
| AppliedInbndEntryExists | (Integer, Boolean) | Boolean | public | - | |||
| AppliedFromEntryExists | (Integer) | Boolean | public | - | |||
| GetInboundEntriesTheOutbndEntryAppliedTo | (Integer) | Boolean | public | - | |||
| CheckAppliedFromEntryToAdjust | (Integer) | public | - | ||||
| CostReceiver | () | Integer | public | - | |||
| Fixed | () | Boolean | public | - | |||
| InsertHistory | () | Integer | public | - | |||
| CostApplication | () | Boolean | public | - | |||
| CheckIsCyclicalLoop | (Record Item Ledger Entry, Record Item Ledger Entry) | Boolean | public | - | |||
| GetLastEntryNo | () | Integer | public | - | |||
| GetVisitedEntries | (Record Item Ledger Entry, var Record Item Ledger Entry, Boolean) | public | - | ||||
| OutboundApplied | (Integer, Boolean) | Decimal | public | - | |||
| InboundApplied | (Integer, Boolean) | Decimal | public | - | |||
| Returned | (Integer) | Decimal | public | - | |||
| ExistsBetween | (Integer, Integer) | Boolean | public | - | |||
| SetOutboundsNotUpdated | (Record Item Ledger Entry) | public | - | ||||
| SetInboundToUpdated | (Record Item Ledger Entry) | public | - | ||||
| IsAppliedFromIncrease | (Integer) | Boolean | public | - | |||
| IsOutbndItemApplEntryCostApplication | (Integer) | Boolean | public | - | |||
| GetOutboundEntriesAppliedToTheInboundEntry | (Integer) | Boolean | public | - | |||
| SetSearchedItemLedgerEntry | (var Record Item Ledger Entry) | public | Pending 27.0 | ||||
| The optimization that used this function was obsoleted. | |||||||
| GetNextEntryNo | () | Integer | public | - | |||
| SetCostApplication | (Boolean) | public | - | ||||
| AppliedOutbndEntryExists | (var Query Item Application Entries, Integer, Boolean, Boolean) | Boolean | public | Pending 28.0 | |||
| Replaced with namesake procedure with "Item Application Entries Outb." as parameter. | |||||||
| AppliedOutbndEntryExists | (var Query Item Application Entries Outb., Integer, Boolean, Boolean) | Boolean | public | - | |||
| AppliedInbndTransEntryExists | (var Query Item Application Entries, Integer, Boolean) | Boolean | public | - | |||
| AppliedInbndEntryExists | (var Query Item Application Entries, Integer, Boolean) | Boolean | public | Pending 28.0 | |||
| Replaced with namesake procedure with "Item Application Entries Inb." as parameter. | |||||||
| AppliedInbndEntryExists | (var Query Item Application Entries Inb., Integer, Boolean) | Boolean | public | - | |||
Events, 7
| Kind | Name | Parameters | Obsolete |
|---|---|---|---|
| Integration event | OnBeforeFixed | (Record Item Application Entry, var Boolean, var Boolean) | - |
| Integration event | OnBeforeCheckCyclicProdCyclicalLoop | (var Record Item Application Entry, Record Item Ledger Entry, Record Item Ledger Entry, var Boolean, var Boolean) | - |
| Integration event | OnSetInboundToUpdatedOnAfterSetFilters | (var Record Item Application Entry) | - |
| Integration event | OnSetOutboundsNotUpdatedOnAfterSetFilters | (var Record Item Application Entry) | - |
| Integration event | OnCheckIsCyclicalLoopOnBeforeCheckCyclicForwardToAppliedInbounds | (Record Item Ledger Entry, Record Item Ledger Entry, Date, var Boolean) | - |
| Integration event | OnCheckCyclicFwdToAppliedEntriesOnAfterCheckItemApplicationEntry | (Record Item Ledger Entry, Integer, Boolean, var Boolean) | - |
| Integration event | OnBeforeCheckCyclicAsmCyclicalLoop | (var Record Item Application Entry, Record Item Ledger Entry, Record Item Ledger Entry, var Boolean, var Boolean) | - |