Setup table in Microsoft Dynamics 365 Business Central. 11 fields, 4 records in Cronus demo.
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.