XPT / Schema / Service Shipment Line

Service Shipment Line #5991

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

The Service Shipment Line table (ID 5991) is part of the Service area in Microsoft Dynamics 365 Business Central. It contains 106 fields, with a primary key of Document No., Line No.. Use the reference below to explore every field, data type, and table relation.

106
Fields
0
Records
2
Primary key
0
FlowFields
42
Relations
Open in Data Explorer →

Primary key

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

All fields (106)

Service Shipment Line — FIELDS
NO.FIELDTYPECLASSRELATION
2 Customer No. Code Normal → Customer #18
3 Document No. PK Code Normal → Service Shipment Header #5990
4 Line No. PK Integer Normal
5 Type Option Normal
6 No. Code Normal
7 Location Code Code Normal → Location #14
8 Posting Group Code Normal
11 Description Text Normal
12 Description 2 Text Normal
13 Unit of Measure Text Normal
15 Quantity Decimal Normal
22 Unit Price Decimal Normal
23 Unit Cost (LCY) Decimal Normal
25 VAT % Decimal Normal
27 Line Discount % Decimal Normal
32 Allow Invoice Disc. Boolean Normal
34 Gross Weight Decimal Normal
35 Net Weight Decimal Normal
36 Units per Parcel Decimal Normal
37 Unit Volume Decimal Normal
38 Appl.-to Item Entry Integer Normal
39 Item Shpt. Entry No. Integer Normal
40 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
41 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
42 Customer Price Group Code Normal → Customer Price Group #6
45 Project No. Code Normal → Job #167
46 Project Task No. Code Normal → Job Task #1001
52 Work Type Code Code Normal → Work Type #200
58 Qty. Shipped Not Invoiced Decimal Normal
61 Quantity Invoiced Decimal Normal
65 Order No. Code Normal
66 Order Line No. Integer Normal
68 Bill-to Customer No. Code Normal → Customer #18
74 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
75 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
77 VAT Calculation Type Option Normal
78 Transaction Type Code Normal → Transaction Type #258
79 Transport Method Code Normal → Transport Method #259
80 Attached to Line No. Integer Normal
81 Exit Point Code Normal → Entry/Exit Point #282
82 Area Code Normal → Area #284
83 Transaction Specification Code Normal → Transaction Specification #285
85 Tax Area Code Code Normal → Tax Area #318
86 Tax Liable Boolean Normal
87 Tax Group Code Code Normal → Tax Group #321
89 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
90 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
91 Currency Code Code Normal → Currency #4
99 VAT Base Amount Decimal Normal
100 Unit Cost Decimal Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
950 Time Sheet No. Code Normal → Time Sheet Header #950
951 Time Sheet Line No. Integer Normal → Time Sheet Line #951
952 Time Sheet Date Date Normal → Time Sheet Detail #952
1019 Project Planning Line No. Integer Normal
5402 Variant Code Code Normal
5403 Bin Code Code Normal → Bin #7354
5404 Qty. per Unit of Measure Decimal Normal
5407 Unit of Measure Code Code Normal
5415 Quantity (Base) Decimal Normal
5458 Qty. Shipped Not Invd. (Base) Decimal Normal
5461 Qty. Invoiced (Base) Decimal Normal
5700 Responsibility Center Code Normal → Responsibility Center #5714
5709 Item Category Code Code Normal → Item Category #5722
5710 Catalog Boolean Normal
5817 Correction Boolean Normal
5901 Appl.-to Warranty Entry Integer Normal
5902 Service Item No. Code Normal → Service Item #5940
5903 Appl.-to Service Entry Integer Normal
5904 Service Item Line No. Integer Normal
5905 Service Item Serial No. Code Normal
5906 Service Item Line Description Text Normal
5908 Posting Date Date Normal
5909 Order Date Date Normal
5910 Needed by Date Date Normal
5916 Ship-to Code Code Normal → Ship-to Address #222
5918 Quantity Consumed Decimal Normal
5920 Qty. Consumed (Base) Decimal Normal
5928 Service Price Group Code Code Normal → Service Price Group #6080
5929 Fault Area Code Code Normal → Fault Area #5915
5930 Symptom Code Code Normal → Symptom Code #5916
5931 Fault Code Code Normal → Fault Code #5918
5932 Resolution Code Code Normal → Resolution Code #5919
5933 Exclude Warranty Boolean Normal
5934 Warranty Boolean Normal
5936 Contract No. Code Normal → Service Contract Header #5965
5938 Contract Disc. % Decimal Normal
5939 Warranty Disc. % Decimal Normal
5965 Component Line No. Integer Normal
5966 Spare Part Action Option Normal
5967 Fault Reason Code Code Normal → Fault Reason Code #5917
5968 Replaced Item No. Code Normal
5969 Exclude Contract Discount Boolean Normal
5970 Replaced Item Type Option Normal
5994 Price Adjmt. Status Option Normal
5997 Line Discount Type Option Normal
5999 Copy Components From Option Normal
6608 Return Reason Code Code Normal → Return Reason #6635
7000 Price Calculation Method Option Normal
7001 Allow Line Disc. Boolean Normal
7002 Customer Disc. Group Code Normal → Customer Discount Group #340
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 (39)

Tables referenced by fields on the Service Shipment Line table through TableRelation properties.

Customer
#18 · Sales · via Customer No., Bill-to Customer No.
Service Shipment Header
#5990 · Service · via Document No.
Location
#14 · General Ledger · via Location Code
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Customer Price Group
#6 · General Ledger · via Customer Price Group
Job
#167 · Other · via Project No.
Job Task
#1001 · Jobs · via Project Task No.
Work Type
#200 · Other · via Work Type Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Transaction Type
#258 · Other · via Transaction Type
Transport Method
#259 · Other · via Transport Method
Entry/Exit Point
#282 · Other · via Exit Point
Area
#284 · Other · via Area
Transaction Specification
#285 · Other · via Transaction Specification
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Currency
#4 · General Ledger · via Currency Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Time Sheet Header
#950 · Other · via Time Sheet No.
Time Sheet Line
#951 · Other · via Time Sheet Line No.
Time Sheet Detail
#952 · Other · via Time Sheet Date
Bin
#7354 · Warehouse · via Bin Code
Responsibility Center
#5714 · Other · via Responsibility Center
Item Category
#5722 · Other · via Item Category Code
Service Item
#5940 · Service · via Service Item No.
Ship-to Address
#222 · Other · via Ship-to Code
Service Price Group
#6080 · Other · via Service Price Group Code
Fault Area
#5915 · Service · via Fault Area Code
Symptom Code
#5916 · Service · via Symptom Code
Fault Code
#5918 · Service · via Fault Code
Resolution Code
#5919 · Service · via Resolution Code
Service Contract Header
#5965 · Service · via Contract No.
Fault Reason Code
#5917 · Service · via Fault Reason Code
Return Reason
#6635 · Other · via Return Reason Code
Customer Discount Group
#340 · Other · via Customer Disc. Group

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms