Standard Service Line #5997

Service table in Microsoft Dynamics 365 Business Central. 17 fields, 1 records in Cronus demo.

17
Fields
1
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 Service Code, Line No..

All fields (17)

Standard Service Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Standard Service Code PK Code Normal → Standard Service Code #5996
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 Service Line table through TableRelation properties.

Standard Service Code
#5996 · Service · via Standard Service Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID