Table 5830 Availability Calc. Overview in 25
- App
- Base Application
- Namespace
- Microsoft.Inventory.Availability
Versions171819202122232425262728latest
Source29
Fields, 23
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Entry No. | Integer | - |
| 2 | Type | Option | - |
| 3 | Date | Date | - |
| 4 | Item No. | Code[20] | - |
| 5 | Location Code | Code[10] | - |
| 6 | Variant Code | Code[10] | - |
| 7 | Unit of Measure Code | Code[10] | - |
| 11 | Attached to Entry No. | Integer | - |
| 13 | Level | Integer | - |
| 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 | Description | Text[100] | - |
| 41 | Quantity | Decimal | - |
| 42 | Reserved Quantity | Decimal | - |
| 45 | Inventory Running Total | Decimal | - |
| 46 | Supply Running Total | Decimal | - |
| 47 | Demand Running Total | Decimal | - |
| 48 | Running Total | Decimal | - |
| 50 | Matches Criteria | Boolean | - |
Keys, 3
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Entry No. | - |
| Key2 | Item No., Date, Attached to Entry No., Type | - |
| Key3 | Item No., Variant Code, Location Code | - |