Setup table in Microsoft Dynamics 365 Business Central. 11 fields, 4 records in Cronus demo.
The Item Vendor table (ID 99) is part of the Setup area in Microsoft Dynamics 365 Business Central. It contains 11 fields, with a primary key of Item No., Vendor No., Variant Code. 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., Vendor No., Variant Code.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item No. PK | Code | Normal | → Item #27 |
| 2 | Vendor No. PK | Code | Normal | → Vendor #23 |
| 6 | Lead Time Calculation | DateFormula | Normal | |
| 7 | Vendor Item No. | Text | Normal | |
| 5700 | Variant Code PK | Code | Normal | → Item Variant #5401 |
| 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 Vendor table through TableRelation properties.