Other table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.
The Standard Purchase Line table (ID 174) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 17 fields, with a primary key of Standard Purchase Code, 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: Standard Purchase Code, Line No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | Standard Purchase Code PK | Code | Normal | → Standard Purchase Code #173 |
| 2 | Line No. PK | Integer | Normal | |
| 3 | Type | Option | Normal | |
| 4 | No. | Code | Normal | |
| 5 | Description | Text | Normal | |
| 6 | Quantity | Decimal | Normal | |
| 7 | Amount Excl. VAT | Decimal | Normal | |
| 8 | Unit of Measure Code | Code | Normal | |
| 9 | Shortcut Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 10 | Shortcut Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 11 | Variant Code | Code | Normal | |
| 480 | Dimension Set ID | Integer | Normal | → Dimension Set Entry #480 |
| 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 Standard Purchase Line table through TableRelation properties.