Other table in Microsoft Dynamics 365 Business Central. 30 fields, 0 records in Cronus demo.
The Item Availability Buffer table (ID 925) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 30 fields, with a primary key of Period Type, Period Start. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Period Type, Period Start.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. | Code | Normal | |
| 5 | Period Type PK | Option | Normal | |
| 6 | Period Name | Text | Normal | |
| 7 | Period Start PK | Date | Normal | |
| 8 | Period End | Date | Normal | |
| 10 | Gross Requirement | Decimal | Normal | |
| 11 | Scheduled Receipt | Decimal | Normal | |
| 12 | Planned Order Receipt | Decimal | Normal | |
| 13 | Projected Available Balance | Decimal | Normal | |
| 14 | Inventory | Decimal | Normal | |
| 15 | Qty. on Purch. Order | Decimal | Normal | |
| 16 | Qty. on Sales Order | Decimal | Normal | |
| 17 | Qty. on Service Order | Decimal | Normal | |
| 18 | Qty. on Job Order | Decimal | Normal | |
| 19 | Trans. Ord. Shipment (Qty.) | Decimal | Normal | |
| 20 | Qty. in Transit | Decimal | Normal | |
| 21 | Trans. Ord. Receipt (Qty.) | Decimal | Normal | |
| 22 | Qty. on Asm. Comp. Lines | Decimal | Normal | |
| 23 | Qty. on Assembly Order | Decimal | Normal | |
| 24 | Expected Inventory | Decimal | Normal | |
| 25 | Available Inventory | Decimal | Normal | |
| 26 | Scheduled Receipt (Qty.) | Decimal | Normal | |
| 27 | Scheduled Issue (Qty.) | Decimal | Normal | |
| 28 | Planned Order Releases | Decimal | Normal | |
| 29 | Net Change | Decimal | Normal | |
| 2000000000 | System ID | GUID | Normal | |
| 2000000001 | Created At | DateTime | Normal | |
| 2000000002 | Created By | GUID | Normal | |
| 2000000003 | Modified At | DateTime | Normal | |
| 2000000004 | Modified By | GUID | Normal |