Other table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
The Availability Info. Buffer table (ID 520) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 38 fields, with a primary key of Lot No., Serial No., Package No., and includes 19 calculated FlowFields. 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: Lot No., Serial No., Package No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. | Code | Normal | → Item #27 |
| 3 | Lot No. PK | Code | Normal | |
| 4 | Serial No. PK | Code | Normal | |
| 5 | Package No. PK | Code | Normal | |
| 6 | Expiration Date | Date | Normal | |
| 7 | Quality ⚡ FLOW | Option | FlowField | |
| 8 | Certificate Number ⚡ FLOW | Code | FlowField | |
| 9 | Blocked ⚡ FLOW | Boolean | FlowField | |
| 20 | Inventory ⚡ FLOW | Decimal | FlowField | |
| 21 | Date Filter | Date | FlowFilter | |
| 23 | Variant Code Filter | Code | FlowFilter | → Item Variant #5401 |
| 24 | Location Code Filter | Code | FlowFilter | → Location #14 |
| 25 | Lot No. Filter | Code | FlowFilter | |
| 30 | Qty. in Hand | Decimal | Normal | |
| 31 | Gross Requirement | Decimal | Normal | |
| 32 | Planned Order Receipt | Decimal | Normal | |
| 33 | Scheduled Receipt | Decimal | Normal | |
| 34 | Available Inventory | Decimal | Normal | |
| 503 | Qty. on Sales Orders ⚡ FLOW | Decimal | FlowField | |
| 504 | Qty. on Service Orders ⚡ FLOW | Decimal | FlowField | |
| 505 | Qty. on Project Order ⚡ FLOW | Decimal | FlowField | |
| 506 | Res. Qty. on Prod. Order Comp. ⚡ FLOW | Decimal | FlowField | |
| 507 | Qty. on Transfer Order Shipment ⚡ FLOW | Decimal | FlowField | |
| 509 | Qty. on Asm. Comp. ⚡ FLOW | Decimal | FlowField | |
| 510 | Qty. on Purch. Returns ⚡ FLOW | Decimal | FlowField | |
| 511 | Qty. on Purch. Orders ⚡ FLOW | Decimal | FlowField | |
| 512 | Planned Order Receipt (Qty.) ⚡ FLOW | Decimal | FlowField | |
| 513 | Purch. Req. Receipt (Qty.) ⚡ FLOW | Decimal | FlowField | |
| 514 | Qty. on Prod. Receipt ⚡ FLOW | Decimal | FlowField | |
| 516 | Qty. on Transfer Order Receipt ⚡ FLOW | Decimal | FlowField | |
| 517 | Qty. on Assembly Order ⚡ FLOW | Decimal | FlowField | |
| 518 | Qty. on Sales Return ⚡ FLOW | Decimal | FlowField | |
| 99000777 | Qty. on Prod. Order ⚡ FLOW | Decimal | FlowField | |
| 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 |
Tables referenced by fields on the Availability Info. Buffer table through TableRelation properties.