Objects/Tables/Table 520 Availability Info. Buffer
Table 520 Availability Info. Buffer in 26
Jonas Paprotka, Base Application 26.5.38752.40541, checked
- App
- Base Application
- Namespace
- Microsoft.Inventory.Availability
Fields, 33Keys, 1Procedures, 8Events, 5
Versions171819202122232425262728latest
Source29
Fields, 33
| Id | Name | Type | Obsolete |
|---|
| 1 | Item No. | Code[20] | - |
| 3 | Lot No. | Code[50] | - |
| 4 | Serial No. | Code[50] | - |
| 5 | Package No. | Code[50] | - |
| 6 | Expiration Date | Date | - |
| 7 | Quality | Option | - |
| 8 | Certificate Number | Code[20] | - |
| 9 | Blocked | Boolean | - |
| 20 | Inventory | Decimal | - |
| 21 | Date Filter | Date | - |
| 23 | Variant Code Filter | Code[10] | - |
| 24 | Location Code Filter | Code[10] | - |
| 25 | Lot No. Filter | Code[50] | - |
| 30 | Qty. In Hand | Decimal | - |
| 31 | Gross Requirement | Decimal | - |
| 32 | Planned Order Receipt | Decimal | - |
| 33 | Scheduled Receipt | Decimal | - |
| 34 | Available Inventory | Decimal | - |
| 503 | Qty. on Sales Order | Decimal | - |
| 504 | Qty. on Service Order | Decimal | - |
| 505 | Qty. on Job Order | Decimal | - |
| 506 | Qty. on Component Lines | Decimal | - |
| 507 | Qty. on Trans. Order Shipment | Decimal | - |
| 509 | Qty. on Asm. Component | Decimal | - |
| 510 | Qty. on Purch. Return | Decimal | - |
| 511 | Qty. on Purch. Order | Decimal | - |
| 512 | Planned Order Receipt (Qty.) | Decimal | - |
| 513 | Purch. Req. Receipt (Qty.) | Decimal | - |
| 514 | Qty. on Prod. Receipt | Decimal | - |
| 516 | Qty. on Trans. Order Receipt | Decimal | - |
| 517 | Qty. on Assembly Order | Decimal | - |
| 518 | Qty. on Sales Return | Decimal | - |
| 99000777 | Qty. on Prod. Order | Decimal | - |
Keys, 1
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Lot No., Serial No., Package No. | - |
Procedures, 8
| Name | Parameters | Returns | Access | Obsolete |
|---|
| LookupInventory | (var Record Item Ledger Entry) | | internal | - |
| LookupGrossRequirement | (var Record Reservation Entry) | | internal | - |
| LookupPlannedOrderReceipt | (var Record Reservation Entry) | | internal | - |
| LookupScheduledReceipt | (var Record Reservation Entry) | | internal | - |
| LookupAvailableInventory | (var Record Reservation Entry) | | internal | - |
| AddEntriesForLookUp | (var Record Reservation Entry, Integer, Text, Text, Enum Reservation Date Filter) | | public | - |
| GetRangeFilter | (Variant, Variant) | Text | public | - |
| GetOptionFilter | (Variant, Variant, Variant) | Text | public | - |
Events, 5
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnLookupAvailableInventory | (var Record Reservation Entry) | - |
| Integration event | OnLookupGrossRequirement | (var Record Reservation Entry) | - |
| Integration event | OnLookupScheduledReceipt | (var Record Reservation Entry) | - |
| Integration event | OnLookupPlannedOrderReceipt | (var Record Reservation Entry) | - |
| Integration event | OnAddEntriesForLookUpOnBeforeVariantCodeGetFilter | (var Record Availability Info. Buffer, var Boolean) | - |