Table 5991 "Service Shipment Line"
Base Application · Microsoft.Service.History
Across versions
- BC23present
- BC24declaration changed
- BC254 procedures added, 3 events added
- BC263 fields added, 1 fields removed
- BC27unchanged
- BC2859 fields changed, 2 fields added
- BC29-30unchanged
Neighbourhood 63 connected objects and pages
Base Application · Microsoft.Service.History · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Service Shipment Line |
| DataClassification | CustomerContent |
| Permissions | TableData “Item Ledger Entry” = r, TableData “Value Entry” = r |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 2 | Customer No. Δ BC28 | Code[20] | Specifies the number of the customer who owns the items on the service order. | TableRelation Table 18 “Customer”; not editable |
| 3 | Document No. Δ BC28 | Code[20] | Specifies the number of this shipment. | TableRelation Table 5990 “Service Shipment Header” (“Service Shipment Header”.“No.”) |
| 4 | Line No. Δ BC28 | Integer | Specifies the number of the shipment line. | |
| 5 | Type Δ BC28 | Enum “Service Line Type” | Specifies the type of this shipment line. | enum Enum 5902 “Service Line Type” |
| 6 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(” “)) “Standard Text” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(Cost)) “Service Cost” else if (Type = const(“G/L Account”)) “G/L Account”) |
| 7 | Location Code Δ BC28 | Code[10] | Specifies the location, such as warehouse or distribution center, from which the items should be taken and where they should be registered. | TableRelation Table 14 “Location” |
| 8 | Posting Group Δ BC28 | Code[20] | Specifies the code for the posting group used when the service line was posted. | TableRelation Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group”) |
| 11 | Description Δ BC28 | Text[100] | Specifies the description of an item, resource, cost, or a standard text on the service line. | |
| 12 | Description 2 Δ BC28 | Text[50] | Specifies information in addition to the description. | |
| 13 | Unit of Measure Δ BC28 | Text[50] | Specifies the name of the item or resource’s unit of measure, such as piece or hour. | |
| 15 | Quantity Δ BC28 | Decimal | Specifies the number of item units, resource hours, general ledger account payments, or cost that have been shipped to the customer. | |
| 22 | Unit Price Δ BC28 | Decimal | Specifies the price of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. | |
| 23 | Unit Cost (LCY) Δ BC28 | Decimal | Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 5949 “Posted Serv. Shpt. Line List” | |
| 25 | VAT % Δ BC28 | Decimal | — | not editable |
| 27 | Line Discount % Δ BC28 | Decimal | Specifies the discount percentage that is granted for the item on the line. | |
| 32 | Allow Invoice Disc. Δ BC28 | Boolean | Specifies if the invoice line is included when the invoice discount is calculated. | |
| 34 | Gross Weight Δ BC28 | Decimal | — | |
| 35 | Net Weight Δ BC28 | Decimal | — | |
| 36 | Units per Parcel Δ BC28 | Decimal | — | |
| 37 | Unit Volume Δ BC28 | Decimal | — | |
| 38 | Appl.-to Item Entry Δ BC28 | Integer | Specifies the number of the item ledger entry that the document or journal line is applied to. | |
| 39 | Item Shpt. Entry No. | Integer | — | |
| 40 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 41 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 42 | Customer Price Group | Code[10] | — | TableRelation Table 6 “Customer Price Group” (Customer Price Group); not editable |
| 45 | Job No. + BC26 | Code[20] | Project No. caption | TableRelation Table 167 “Job” |
| 46 | Job Task No. + BC26 | Code[20] | Project Task No. caption | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”))) |
| 52 | Work Type Code Δ BC28 | Code[10] | Specifies a code for the type of work performed under the posted service order. | TableRelation Table 200 “Work Type” (Work Type) |
| 58 | Qty. Shipped Not Invoiced Δ BC28 | Decimal | Specifies the quantity of the shipped item that has been posted as shipped but that has not yet been posted as invoiced. | not editable |
| 61 | Quantity Invoiced Δ BC28 | Decimal | Specifies how many units of the item on the line have been posted as invoiced. | not editable |
| 65 | Order No. | Code[20] | Specifies the number of the service order that this shipment was posted from. via Page 5994 “Get Service Shipment Lines” | |
| 66 | Order Line No. | Integer | — | |
| 68 | Bill-to Customer No. Δ BC28 | Code[20] | Specifies the number of the customer that you send or sent the invoice or credit memo to. | TableRelation Table 18 “Customer”; not editable |
| 74 | Gen. Bus. Posting Group | Code[20] | — | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 75 | Gen. Prod. Posting Group | Code[20] | — | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 77 | VAT Calculation Type | Enum “Tax Calculation Type” | — | enum Enum 254 “Tax Calculation Type”; not editable |
| 78 | Transaction Type | Code[10] | — | TableRelation Table 258 “Transaction Type” (Transaction Type) |
| 79 | Transport Method | Code[10] | — | TableRelation Table 259 “Transport Method” (Transport Method) |
| 80 | Attached to Line No. | Integer | — | not editable |
| 81 | Exit Point | Code[10] | — | TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point) |
| 82 | Area | Code[10] | — | TableRelation Table 284 “Area” |
| 83 | Transaction Specification | Code[10] | — | TableRelation Table 285 “Transaction Specification” (Transaction Specification) |
| 85 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 86 | Tax Liable | Boolean | — | |
| 87 | Tax Group Code | Code[20] | — | TableRelation Table 321 “Tax Group” (Tax Group) |
| 89 | VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 90 | VAT Prod. Posting Group | Code[20] | — | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 91 | Currency Code Δ BC28 | Code[10] | Specifies the currency code for various amounts on the shipment. | TableRelation Table 4 “Currency”; not editable |
| 99 | VAT Base Amount | Decimal | — | |
| 100 | Unit Cost | Decimal | — | |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 950 | Time Sheet No. | Code[20] | — | TableRelation Table 950 “Time Sheet Header” (Time Sheet Header) |
| 951 | Time Sheet Line No. | Integer | — | TableRelation Table 951 “Time Sheet Line” (“Time Sheet Line”.“Line No.” where(“Time Sheet No.” = field(“Time Sheet No.”))) |
| 952 | Time Sheet Date | Date | — | TableRelation Table 952 “Time Sheet Detail” (“Time Sheet Detail”.Date where(“Time Sheet No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Time Sheet Line No.”))) |
| 1019 | Job Planning Line No. + BC26 | Integer | Project Planning Line No. caption | |
| 5402 | Variant Code Δ BC28 | Code[10] | Specifies the variant of the item on the line. | TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”))) |
| 5403 | Bin Code Δ BC28 | Code[20] | Specifies the bin where the items are picked or put away. | TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”))) |
| 5404 | Qty. per Unit of Measure Δ BC28 | Decimal | — | not editable |
| 5407 | Unit of Measure Code Δ BC28 | Code[10] | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted. | TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”) |
| 5415 | Quantity (Base) Δ BC28 | Decimal | — | |
| 5458 | Qty. Shipped Not Invd. (Base) Δ BC28 | Decimal | — | not editable |
| 5461 | Qty. Invoiced (Base) Δ BC28 | Decimal | — | |
| 5700 | Responsibility Center | Code[10] | — | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 5709 | Item Category Code | Code[20] | — | TableRelation Table 5722 “Item Category” (“Item Category”.Code) |
| 5710 | Nonstock Δ BC28 | Boolean | Specifies that the item on the shipment line is a catalog item. | |
| 5798 | External Document No. + BC28 | Code[35] | Specifies the number that the customer uses in their own system to refer to this service document. via Page 5994 “Get Service Shipment Lines” | |
| 5799 | Your Reference + BC28 | Text[35] | Specifies the reference information that the customer uses in their own system to refer to this service document. via Page 5994 “Get Service Shipment Lines” | |
| 5817 | Correction | Boolean | — | |
| 5901 | Appl.-to Warranty Entry | Integer | — | |
| 5902 | Service Item No. Δ BC28 | Code[20] | Specifies the number of the service item to which this service line is linked. | TableRelation Table 5940 “Service Item” (“Service Item”.“No.”) |
| 5903 | Appl.-to Service Entry | Integer | — | |
| 5904 | Service Item Line No. Δ BC28 | Integer | Specifies the number of the service item line to which this service line is linked. | |
| 5905 | Service Item Serial No. Δ BC28 | Code[50] | Specifies the serial number of the service item to which this shipment line is linked. | |
| 5906 | Service Item Line Description | Text[100] | — | |
| 5908 | Posting Date Δ BC28 | Date | Specifies the date when the service line was posted. | |
| 5909 | Order Date Δ BC28 | Date | Specifies the date when the related order was created. | |
| 5910 | Needed by Date | Date | — | |
| 5916 | Ship-to Code Δ BC28 | Code[10] | Specifies a code for an alternate shipment address if you want to ship to another address than the one that has been entered automatically. This field is also used in case of drop shipment. | TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”))) |
| 5918 | Quantity Consumed Δ BC28 | Decimal | Specifies the number of units of items, resource hours, general ledger account payments, or costs that have been posted as consumed. | |
| 5920 | Qty. Consumed (Base) Δ BC28 | Decimal | — | |
| 5928 | Service Price Group Code | Code[10] | — | TableRelation Table 6080 “Service Price Group” (Service Price Group) |
| 5929 | Fault Area Code Δ BC28 | Code[10] | Specifies the code of the fault area associated with this service line. | TableRelation Table 5915 “Fault Area” (Fault Area) |
| 5930 | Symptom Code Δ BC28 | Code[10] | Specifies the code of the symptom associated with this service shipment line. | TableRelation Table 5916 “Symptom Code” (Symptom Code) |
| 5931 | Fault Code Δ BC28 | Code[10] | Specifies the fault code associated with this service shipment line. | TableRelation Table 5918 “Fault Code” (“Fault Code”.Code where(“Fault Area Code” = field(“Fault Area Code”), “Symptom Code” = field(“Symptom Code”))) |
| 5932 | Resolution Code Δ BC28 | Code[10] | Specifies the code of the resolution associated with this service shipment line. | TableRelation Table 5919 “Resolution Code” (Resolution Code) |
| 5933 | Exclude Warranty Δ BC28 | Boolean | Specifies that the warranty discount is excluded on this service shipment line. | |
| 5934 | Warranty Δ BC28 | Boolean | Specifies that a warranty discount is available on this service shipment line of type Item or Resource. | |
| 5936 | Contract No. Δ BC28 | Code[20] | Specifies the number of the contract associated with the posted service order. | TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract))) |
| 5938 | Contract Disc. % Δ BC28 | Decimal | Specifies the contract discount percentage valid for the items, resources, and costs on the service shipment line. | |
| 5939 | Warranty Disc. % Δ BC28 | Decimal | Specifies the percentage of the warranty discount valid for the items or resources on the service shipment line. | |
| 5965 | Component Line No. Δ BC28 | Integer | Specifies the number of the line in the Service Item Component List window. | |
| 5966 | Spare Part Action Δ BC28 | Option | Specifies whether the item has been used to replace the whole service item, one of the service item components, installed as a new component, or as a supplementary tool in the service process. | OptionCaption: ,Permanent,Temporary,Component Replaced,Component Installed |
| 5967 | Fault Reason Code Δ BC28 | Code[10] | Specifies the code of the fault reason for the service shipment line. | TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code) |
| 5968 | Replaced Item No. Δ BC28 | Code[20] | Specifies the number of the service item component replaced by the item on the service line. | TableRelation Table 27 “Item”, Table 5940 “Service Item” (if (“Replaced Item Type” = const(Item)) Item else if (“Replaced Item Type” = const(“Service Item”)) “Service Item”) |
| 5969 | Exclude Contract Discount | Boolean | — | |
| 5970 | Replaced Item Type Δ BC28 | Option | Specifies the type of the service item component replaced by the item on the service line. | OptionCaption: ,Service Item,Item |
| 5994 | Price Adjmt. Status | Option | — | OptionCaption: ,Adjusted,Modified |
| 5997 | Line Discount Type | Option | — | OptionCaption: ,Warranty Disc.,Contract Disc.,Line Disc.,Manual |
| 5999 | Copy Components From | Option | — | OptionCaption: None,Item BOM,Old Service Item,Old Serv.Item w/o Serial No. |
| 6608 | Return Reason Code Δ BC28 | Code[10] | Specifies the code explaining why the item was returned. | TableRelation Table 6635 “Return Reason” (Return Reason) |
| 7000 | Price Calculation Method | Enum “Price Calculation Method” | — | enum Enum 7000 “Price Calculation Method” |
| 7001 | Allow Line Disc. | Boolean | — | |
| 7002 | Customer Disc. Group | Code[20] | — | TableRelation Table 340 “Customer Discount Group” (Customer Discount Group) |
Keys
- Key1: Document No., Line No. (clustered)
- Key2: Order No., Order Line No.
- Key3: Item Shpt. Entry No.
- Key4: Service Item No., Type, Posting Date
- Key5: Customer No.
- Key6: Bill-to Customer No.
- Key7: Fault Reason Code
- Key8: Contract No.
Events published
OnAfterServiceInvLineInsert(var ToServiceLine: Record "Service Line"; FromServiceLine: Record "Service Line"; ServiceShipmentLine: Record "Service Shipment Line"; var NextLineNo: Integer)(integration)OnAfterValidateServiceLineAmounts(var ServiceLine: Record "Service Line"; ServiceOrderLine: Record "Service Line"; ServiceInvHeader: Record "Service Header")(integration)OnBeforeServiceInvLineInsert(var ToServiceLine: Record "Service Line"; FromServiceLine: Record "Service Line"; ServiceShipmentLine: Record "Service Shipment Line")(integration)OnBeforeInsertInvLineFromShptLineOnAfterInsertTextLine(var ServiceLine: Record "Service Line"; ServiceShipmentLine: Record "Service Shipment Line"; var NextLineNo: Integer)(integration)OnBeforeSetSecurityFilterOnRespCenter(var ServiceShipmentLine: Record "Service Shipment Line"; var IsHandled: Boolean)(integration)OnAfterCopyToItemJnlLine(var ItemJournalLine: Record "Item Journal Line"; ServiceShipmentLine: Record "Service Shipment Line")+ BC25 (integration)OnAfterCopyToResJournalLine(var ResJournalLine: Record "Res. Journal Line"; ServiceShipmentLine: Record "Service Shipment Line")+ BC25 (integration)OnAfterCopyToItemJnlLineUndo(var ItemJournalLine: Record "Item Journal Line"; ServiceShipmentLine: Record "Service Shipment Line")+ BC25 (integration)
Trigger event subscribers
- OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceShipmentLine
Procedures
ShowDimensions()ShowItemTrackingLines()InsertInvLineFromShptLine(var ServiceLine: Record "Service Line")FilterPstdDocLnItemLedgEntries(var ItemLedgEntry: Record "Item Ledger Entry")ShowItemServInvLines()GetCaptionClass(FieldNumber: Integer): Text[80]SetSecurityFilterOnRespCenter()CopyToItemJnlLine(var ItemJournalLine: Record "Item Journal Line")+ BC25CopyToItemJnlLineUndo(var ItemJournalLine: Record "Item Journal Line")+ BC25CopyToResJournalLine(var ResJournalLine: Record "Res. Journal Line")+ BC25TransferToItemEntryRelation(var ItemEntryRelation: Record "Item Entry Relation")+ BC25
Plus 4 local procedures.
Relations
- lookup page Page 5949 “Posted Serv. Shpt. Line List”
- Job Task No.: TableRelation Table 1001 “Job Task”
- Location Code: TableRelation Table 14 “Location”
- No.: TableRelation Table 15 “G/L Account” (conditional)
- No.: TableRelation Table 156 “Resource” (conditional)
- Job No.: TableRelation Table 167 “Job”
- Bill-to Customer No.: TableRelation Table 18 “Customer”
- Customer No.: TableRelation Table 18 “Customer”
- Work Type Code: TableRelation Table 200 “Work Type”
- Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
- Ship-to Code: TableRelation Table 222 “Ship-to Address”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Transaction Type: TableRelation Table 258 “Transaction Type”
- Transport Method: TableRelation Table 259 “Transport Method”
- No.: TableRelation Table 27 “Item” (conditional)
- Replaced Item No.: TableRelation Table 27 “Item” (conditional)
- Exit Point: TableRelation Table 282 “Entry/Exit Point”
- Area: TableRelation Table 284 “Area”
- Transaction Specification: TableRelation Table 285 “Transaction Specification”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Customer Disc. Group: TableRelation Table 340 “Customer Discount Group”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Item Category Code: TableRelation Table 5722 “Item Category”
- No.: TableRelation Table 5905 “Service Cost” (conditional)
- Fault Area Code: TableRelation Table 5915 “Fault Area”
- Symptom Code: TableRelation Table 5916 “Symptom Code”
- Fault Reason Code: TableRelation Table 5917 “Fault Reason Code”
- Fault Code: TableRelation Table 5918 “Fault Code”
- Resolution Code: TableRelation Table 5919 “Resolution Code”
- Replaced Item No.: TableRelation Table 5940 “Service Item” (conditional)
- Service Item No.: TableRelation Table 5940 “Service Item”
- Contract No.: TableRelation Table 5965 “Service Contract Header”
- Document No.: TableRelation Table 5990 “Service Shipment Header”
- Customer Price Group: TableRelation Table 6 “Customer Price Group”
- Service Price Group Code: TableRelation Table 6080 “Service Price Group”
- Return Reason Code: TableRelation Table 6635 “Return Reason”
- No.: TableRelation Table 7 “Standard Text” (conditional)
- Bin Code: TableRelation Table 7354 “Bin”
- Posting Group: TableRelation Table 94 “Inventory Posting Group”
- Time Sheet No.: TableRelation Table 950 “Time Sheet Header”
- Time Sheet Line No.: TableRelation Table 951 “Time Sheet Line”
- Time Sheet Date: TableRelation Table 952 “Time Sheet Detail”
Referenced by
3 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 5940 “Service Item”: Sales/Serv. Shpt. Document No., Sales/Serv. Shpt. Line No.
- Table extension 6278 “Sust. Serv. Shipment Item Line”: Total CO2e
Pages and codeunits on this table
- Page 5949 “Posted Serv. Shpt. Line List” (source table)
- Page 5970 “Posted Service Shipment Lines” (source table)
- Page 5994 “Get Service Shipment Lines” (source table)
- Page 6037 “Service Shipment Lines Subform” (source table)
- Codeunit 5818 “Undo Service Shipment Line” (codeunit runs on it)
- Codeunit 5819 “Undo Service Consumption Line” (codeunit runs on it)
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 379 “Transfer Old Ext. Text Lines” (3 calls:
InsertInvLineFromShptLine → ClearLineNumbers,InsertInvLineFromShptLine → GetNewLineNumber,InsertInvLineFromShptLine → TransferExtendedText) - Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetServiceFilter) - Codeunit 6483 “Serv. Item Tracking Mgt.” (1 call:
InsertInvLineFromShptLine → CopyHandledItemTrkgToServLine) - Codeunit 6503 “Item Tracking Doc. Management” (1 call:
ShowItemTrackingLines → ShowItemTrackingForShptRcptLine) - Page 5951 “Posted Service Invoice Lines” (1 call:
ShowItemServInvLines → (object))
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Service Shipment Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.