Warehouse table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The primary key uniquely identifies each record in this table. It consists of: Item No., Variant Code, Location Code, Phys Invt Counting Period Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. PK | Code | Normal | → Item #27 |
| 2 | Variant Code PK | Code | Normal | → Item Variant #5401 |
| 3 | Location Code PK | Code | Normal | → Location #14 |
| 4 | Description ⚡ FLOW | Text | FlowField | |
| 5 | Shelf No. | Code | Normal | |
| 6 | Phys Invt Counting Period Code PK | Code | Normal | → Phys. Invt. Counting Period #7381 |
| 7 | Last Counting Date | Date | Normal | |
| 9 | Count Frequency per Year | Integer | Normal | |
| 10 | Selected | Boolean | Normal | |
| 11 | Phys Invt Counting Period Type | Option | Normal | |
| 12 | Next Counting Start Date | Date | Normal | |
| 13 | Next Counting End Date | Date | 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 |
Tables referenced by fields on the Phys. Invt. Item Selection table through TableRelation properties.