Other table in Microsoft Dynamics 365 Business Central. 38 fields, 0 records in Cronus demo.
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.