Standard Purchase Line #174

Other table in Microsoft Dynamics 365 Business Central. 17 fields, 0 records in Cronus demo.

17
Fields
0
Records
2
Primary key
0
FlowFields
6
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Standard Purchase Code, Line No..

All fields (17)

Standard Purchase Line — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (4)

Tables referenced by fields on the Standard Purchase Line table through TableRelation properties.

Standard Purchase Code
#173 · Other · via Standard Purchase Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID