Sales Documents table in Microsoft Dynamics 365 Business Central. 20 fields, 518 records in Cronus demo.
The Item Register table (ID 46) is part of the Sales Documents area in Microsoft Dynamics 365 Business Central. It contains 20 fields, with a primary key of 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: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | No. PK | Integer | Normal | |
| 2 | From Entry No. | Integer | Normal | → Item Ledger Entry #32 |
| 3 | To Entry No. | Integer | Normal | → Item Ledger Entry #32 |
| 4 | Creation Date | Date | Normal | |
| 5 | Source Code | Code | Normal | → Source Code #230 |
| 6 | User ID | Code | Normal | |
| 7 | Journal Batch Name | Code | Normal | → Item Journal Batch #233 |
| 9 | Creation Time | Time | Normal | |
| 10 | From Phys. Inventory Entry No. | Integer | Normal | → Phys. Inventory Ledger Entry #281 |
| 11 | To Phys. Inventory Entry No. | Integer | Normal | → Phys. Inventory Ledger Entry #281 |
| 5800 | From Value Entry No. | Integer | Normal | → Value Entry #5802 |
| 5801 | To Value Entry No. | Integer | Normal | → Value Entry #5802 |
| 5831 | From Capacity Entry No. | Integer | Normal | → Capacity Ledger Entry #5832 |
| 5832 | To Capacity Entry No. | Integer | Normal | → Capacity Ledger Entry #5832 |
| 5895 | Cost Adjustment Run Guid | GUID | 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 Item Register table through TableRelation properties.