Sales Documents table in Microsoft Dynamics 365 Business Central. 20 fields, 518 records in Cronus demo.
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.