E-Document Purchase Line #6101

Other table in Microsoft Dynamics 365 Business Central. 27 fields, 54 records in Cronus demo.

27
Fields
54
Records
2
Primary key
0
FlowFields
11
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: E-Document Entry No., Line No..

All fields (27)

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

Related tables (9)

Tables referenced by fields on the E-Document Purchase Line table through TableRelation properties.

E-Document
#6121 · Other · via E-Document Entry No.
Unit of Measure
#204 · Other · via Unit of Measure
Deferral Template
#1700 · Other · via Deferral Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Item Reference
#5777 · Other · via Item Reference No.
Item Variant
#5401 · Other · via Variant Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
E-Doc. Purchase Line History
#6140 · Other · via E-Doc. Purch. Line History Id