Service Order Posting Buffer #5933

Service table in Microsoft Dynamics 365 Business Central. 26 fields, 0 records in Cronus demo.

26
Fields
0
Records
12
Primary key
0
FlowFields
8
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Service Order No., Entry Type, Posting Group Type, No., Global Dimension 1 Code, Global Dimension 2 Code, Gen. Bus. Posting Group, Gen. Prod. Posting Group, Unit of Measure Code, Appl.-to Service Entry, Service Item No., Location Code.

All fields (26)

Service Order Posting Buffer — FIELDS
NO.FIELDTYPECLASSRELATION
1 Service Order No. PK Code Normal
2 Entry Type PK Option Normal
3 Posting Group Type PK Option Normal
4 No. PK Code Normal
6 Global Dimension 1 Code PK Code Normal → Dimension Value #349
7 Global Dimension 2 Code PK Code Normal → Dimension Value #349
8 Gen. Bus. Posting Group PK Code Normal → Gen. Business Posting Group #250
9 Gen. Prod. Posting Group PK Code Normal → Gen. Product Posting Group #251
10 Unit of Measure Code PK Code Normal
11 Work Type Code Code Normal → Work Type #200
13 Quantity Decimal Normal
14 Total Cost Decimal Normal
15 Total Price Decimal Normal
16 Appl.-to Service Entry PK Integer Normal
17 Service Contract No. Code Normal
18 Service Item No. PK Code Normal
21 Qty. to Invoice Decimal Normal
22 Location Code PK Code Normal
23 Dimension Entry No. Integer Normal
24 Line Discount % Decimal 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 (6)

Tables referenced by fields on the Service Order Posting Buffer table through TableRelation properties.

Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Work Type
#200 · Other · via Work Type Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID