Other table in Microsoft Dynamics 365 Business Central. 27 fields, 54 records in Cronus demo.
The E-Document Purchase Line table (ID 6101) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 27 fields, with a primary key of E-Document Entry No., Line 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: E-Document Entry No., Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | E-Document Entry No. PK | Integer | Normal | → E-Document #6121 |
| 2 | Line No. PK | Integer | Normal | |
| 3 | Date | Date | Normal | |
| 4 | Product Code | Text | Normal | |
| 5 | Description | Text | Normal | |
| 6 | Quantity | Decimal | Normal | |
| 7 | Unit of Measure | Text | Normal | |
| 8 | Unit Price | Decimal | Normal | |
| 9 | Sub Total | Decimal | Normal | |
| 10 | Total Discount | Decimal | Normal | |
| 11 | Tax Rate | Decimal | Normal | |
| 12 | Currency Code | Code | Normal | |
| 101 | Type | Option | Normal | |
| 102 | No. | Code | Normal | |
| 103 | Unit of Measure | Code | Normal | → Unit of Measure #204 |
| 104 | Deferral Code | Code | Normal | → Deferral Template #1700 |
| 105 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 106 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 107 | Item Reference No. | Code | Normal | → Item Reference #5777 |
| 108 | Variant Code | Code | Normal | → Item Variant #5401 |
| 109 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 201 | E-Doc. Purch. Line History Id | Integer | Normal | → E-Doc. Purchase Line History #6140 |
| 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 E-Document Purchase Line table through TableRelation properties.