Other table in Microsoft Dynamics 365 Business Central. 21 fields, 0 records in Cronus demo.
The GP Item table (ID 4095) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 21 fields, with a primary key of Item Number. 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 Number.
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Item Number PK | Code | Normal | |
| 2 | Item Description | Text | Normal | |
| 3 | Search Description | Code | Normal | |
| 4 | Short Name | Text | Normal | |
| 5 | Base Unit of Measure | Code | Normal | |
| 6 | Item Type | Integer | Normal | |
| 7 | Costing Method | Text | Normal | |
| 8 | Current Cost | Decimal | Normal | |
| 9 | Standard Cost | Decimal | Normal | |
| 10 | Unit List Price | Decimal | Normal | |
| 11 | Shipping Weight | Decimal | Normal | |
| 12 | Blocked | Boolean | Normal | |
| 13 | Quantity on Hand | Decimal | Normal | |
| 14 | Sales Unit of Measure | Code | Normal | |
| 15 | Purchase Unit of Measure | Code | Normal | |
| 16 | Item Tracking Code | Code | 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 |