Table 520 Availability Info. Buffer in 23
- App
- Base Application
- Namespace
- Microsoft.Inventory.Availability
Fields, 33Keys, 1Procedures, 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, 5
| 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 | - |