Other table in Microsoft Dynamics 365 Business Central. 16 fields, 12 records in Cronus demo.
The Item Reference table (ID 5777) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 16 fields, with a primary key of Item No., Variant Code, Unit of Measure, Reference Type, Reference Type No., Reference No.. 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: Item No., Variant Code, Unit of Measure, Reference Type, Reference Type No., Reference No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. PK | Code | Normal | → Item #27 |
| 2 | Variant Code PK | Code | Normal | → Item Variant #5401 |
| 3 | Unit of Measure PK | Code | Normal | → Item Unit of Measure #5404 |
| 4 | Reference Type PK | Option | Normal | |
| 5 | Reference Type No. PK | Code | Normal | |
| 6 | Reference No. PK | Code | Normal | |
| 7 | Description | Text | Normal | |
| 9 | Description 2 | Text | Normal | |
| 10 | Starting Date | Date | Normal | |
| 11 | Ending Date | Date | Normal | |
| 8000 | Usage Data Supplier Ref. Entry No. | Integer | Normal | → Usage Data Supplier Reference #8015 |
| 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 Item Reference table through TableRelation properties.