tableService Managementofficial - Microsoftderived - from the source, no model text

Table 5993 "Service Invoice Line"

Base Application · Microsoft.Service.History

Across versions

  1. BC23present
  2. BC244 fields added
  3. BC251 procedures added, 1 events added
  4. BC263 fields added, 1 fields removed
  5. BC27unchanged
  6. BC2852 fields changed
  7. BC291 fields changed
  8. BC30unchanged

Neighbourhood 59 connected objects and pages

Table 18 "Customer" (relates to, 2 links)CustomerTable 27 "Item" (relates to, 2 links)ItemTable 349 "Dimension Value" (relates to, 2 links)Table 5404 "Item Unit of Measure" (relates to, 2 links)Table 5940 "Service Item" (relates to, 2 links)Service ItemTable 1001 "Job Task" (relates to)Job TaskTable 14 "Location" (relates to)Table 15 "G/L Account" (relates to)G/L AccountTable 156 "Resource" (relates to)Table 167 "Job" (relates to)JobTable 200 "Work Type" (relates to)Table 204 "Unit of Measure" (relates to)Unit of MeasureTable 222 "Ship-to Address" (relates to)Ship-to AddressTable 250 "Gen. Business Posting Group" (relates to)Gen. Business Posting GroupTable 251 "Gen. Product Posting Group" (relates to)Gen. Product Posting GroupTable 258 "Transaction Type" (relates to)Table 259 "Transport Method" (relates to)Transport MethodTable 282 "Entry/Exit Point" (relates to)Table 284 "Area" (relates to)Table 285 "Transaction Specification" (relates to)Table 318 "Tax Area" (relates to)Table 321 "Tax Group" (relates to)Table 323 "VAT Business Posting Group" (relates to)Table 324 "VAT Product Posting Group" (relates to)Table 340 "Customer Discount Group" (relates to)Table 480 "Dimension Set Entry" (relates to)Page 5951 "Posted Service Invoice Lines" (pages and codeunits on it, 3 links)Posted Service Invoice LinesPage 5979 "Posted Service Invoice Subform" (pages and codeunits on it)Page 6038 "Service Invoice Lines Subform" (pages and codeunits on it)Table extension 5033 "Serv. Decl. Serv. Inv. Line" (extended by)Table extension 6275 "Sust. Service Invoice Line" (extended by)Codeunit 5999 "Service Experience Tier" (event subscribers)Codeunit 6459 "Serv. Document Attachment Mgt." (event subscribers)Codeunit 408 "DimensionManagement" (calls, 2 links)DimensionManagementCodeunit 5700 "User Setup Management" (calls)Codeunit 6500 "Item Tracking Management" (calls)Codeunit 6503 "Item Tracking Doc. Management" (calls)Table 5992 "Service Invoice Header" (referenced by, 2 links)Service Invoice HeaderTable extension 6274 "Sust. Service Invoice Header" (referenced by)Sustainability value chain in Service Management (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Service.History · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5979 “Posted Service Invoice Subform” (1 Learn page).

Properties

Property Value
Caption Service Invoice Line
DataClassification CustomerContent

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 has received the service on the invoice. TableRelation Table 18 “Customer”; not editable
3 Document No. Δ BC28 Δ BC29 Code[20] Specifies the number of the invoice. TableRelation Table 5992 “Service Invoice Header” (Service Invoice Header)
4 Line No. Integer —
5 Type Δ BC28 Enum “Service Line Type” Specifies the type of this invoice 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, in which the invoice line was registered. TableRelation Table 14 “Location”
8 Posting Group Code[20] — TableRelation Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group”)
11 Description Δ BC28 Text[100] Specifies the name of an item, resource, cost, general ledger account description, or some descriptive text on the service invoice 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 specified on the invoice line.
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 5951 “Posted Service Invoice Lines”
25 VAT % Δ BC28 Decimal — not editable
27 Line Discount % Δ BC28 Decimal Specifies the discount percentage that is granted for the item on the line.
28 Line Discount Amount Δ BC28 Decimal Specifies the discount amount that is granted for the item on the line. not editable
29 Amount Δ BC28 Decimal Specifies the total net amount on the service line. not editable
30 Amount Including VAT Δ BC28 Decimal Specifies the net amount, including VAT, for this line. not editable
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.
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 Code[10] — TableRelation Table 200 “Work Type” (Work Type)
63 Shipment No. Δ BC28 Code[20] Specifies the number of the posted shipment for the invoice line. not editable
64 Shipment Line No. Integer — not editable
65 Order No. Code[20] —
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
69 Inv. Discount Amount Δ BC28 Decimal Specifies the total calculated invoice discount amount for the line.
74 Gen. Bus. Posting Group Δ BC28 Code[20] Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75 Gen. Prod. Posting Group Δ BC28 Code[20] Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. 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 — TableRelation Table 5993 “Service Invoice Line” (“Service Invoice Line”.“Line No.” where(“Document No.” = field(“Document No.”))); 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 Δ BC28 Code[20] Specifies the tax area that is used to calculate and post sales tax. TableRelation Table 318 “Tax Area” (Tax Area)
86 Tax Liable Δ BC28 Boolean Specifies that the bill-to customer is liable for sales tax. If the field is blank, the program does not calculate the sales tax.
87 Tax Group Code Δ BC28 Code[20] Specifies the tax group that is used to calculate and post sales tax. TableRelation Table 321 “Tax Group” (Tax Group)
88 VAT Clause Code Code[20] — TableRelation Table 560 “VAT Clause” (VAT Clause)
89 VAT Bus. Posting Group Δ BC28 Code[20] Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90 VAT Prod. Posting Group Δ BC28 Code[20] Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
99 VAT Base Amount Decimal —
101 System-Created Entry Boolean — not editable
103 Line Amount Δ BC28 Decimal Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104 VAT Difference Decimal — not editable
106 VAT Identifier Code[20] — not editable
145 Pmt. Discount Amount Decimal —
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
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 —
5700 Responsibility Center Code[10] — TableRelation Table 5714 “Responsibility Center” (Responsibility Center); not editable
5702 Substitution Available Boolean — not editable
5709 Item Category Code Code[20] — TableRelation Table 5722 “Item Category” (“Item Category”.Code)
5710 Nonstock Δ BC28 Boolean Specifies that the item on the invoice line is a catalog item. not editable
5725 Item Reference No. + BC24 Δ BC28 Code[50] Specifies the referenced item number.
5726 Item Reference Unit of Measure + BC24 Code[10] Unit of Measure (Item Ref.) caption TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727 Item Reference Type + BC24 Enum “Item Reference Type” — enum Enum 5726 “Item Reference Type”
5728 Item Reference Type No. + BC24 Code[30] —
5902 Service Item No. Δ BC28 Code[20] Specifies the number of the service item to which this invoice line is linked. TableRelation Table 5940 “Service Item” (“Service Item”.“No.”)
5903 Appl.-to Service Entry Δ BC28 Integer Specifies the number of the service ledger entry that the program applies this service invoice line to. not editable
5904 Service Item Line No. Integer —
5905 Service Item Serial No. Δ BC28 Code[50] Specifies the serial number of the service item to which this invoice line is linked.
5906 Service Item Line Description Text[100] — not editable
5907 Serv. Price Adjmt. Gr. Code Δ BC28 Code[10] Specifies the service price adjustment group code that applies to the invoice line. TableRelation Table 6082 “Service Price Adjustment Group” (Service Price Adjustment Group); not editable
5908 Posting Date Date —
5910 Needed by Date Date —
5916 Ship-to Code Code[10] — TableRelation Table 222 “Ship-to Address” (“Ship-to Address”.Code where(“Customer No.” = field(“Customer No.”))); not editable
5918 Quantity Consumed Δ BC28 Decimal — not editable
5920 Qty. Consumed (Base) Δ BC28 Decimal — not editable
5928 Service Price Group Code Code[10] — TableRelation Table 6080 “Service Price Group” (Service Price Group)
5929 Fault Area Code Code[10] — TableRelation Table 5915 “Fault Area” (Fault Area)
5930 Symptom Code Code[10] — TableRelation Table 5916 “Symptom Code” (Symptom Code)
5931 Fault Code Code[10] — TableRelation Table 5918 “Fault Code” (“Fault Code”.Code where(“Fault Area Code” = field(“Fault Area Code”), “Symptom Code” = field(“Symptom Code”)))
5932 Resolution Code Code[10] — TableRelation Table 5919 “Resolution Code” (Resolution Code)
5933 Exclude Warranty Boolean —
5934 Warranty Boolean — not editable
5936 Contract No. Δ BC28 Code[20] Specifies the number of the contract associated with the posted service invoice. TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract))); not editable
5938 Contract Disc. % Δ BC28 Decimal — not editable
5939 Warranty Disc. % Δ BC28 Decimal — not editable
5965 Component Line No. Integer —
5966 Spare Part Action Option — OptionCaption: ,Permanent,Temporary,Component Replaced,Component Installed
5967 Fault Reason Code Code[10] — TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code)
5968 Replaced Item No. Code[20] — TableRelation Table 27 “Item”, Table 5940 “Service Item” (if (“Replaced Item Type” = const(“Service Item”)) “Service Item” else if (“Replaced Item Type” = const(Item)) Item)
5969 Exclude Contract Discount Boolean —
5970 Replaced Item Type Option — OptionCaption: ,Service Item,Item
5994 Price Adjmt. Status Option — OptionCaption: ,Adjusted,Modified; not editable
5997 Line Discount Type Option — OptionCaption: ,Warranty Disc.,Contract Disc.,Line Disc.,Manual; not editable
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: Type, No.
  • Key3: Service Item No., Type, Posting Date
  • Key4: Document No., Service Item No.
  • Key5: Document No., Service Item Line No., Serv. Price Adjmt. Gr. Code
  • Key6: Document No., Service Item Line No., Type, No.
  • Key7: Type, No., Variant Code, Location Code, Posting Date, Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
  • Key8: Appl.-to Service Entry
  • Key9: Document No., Service Item Line No., Component Line No.
  • Key10: Fault Reason Code
  • Key11: Customer No.
  • Key12: Document No., Type

Events published

  • OnCalcVATAmountLinesOnBeforeInsertLine(ServInvHeader: Record "Service Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary) (integration)
  • OnBeforeSetSecurityFilterOnRespCenter(var ServiceInvoiceLine: Record "Service Invoice Line"; var IsHandled: Boolean) (integration)
  • OnAfterCopyToVATAmountLine(ServiceInvoiceLine: Record "Service Invoice Line"; var VATAmountLine: Record "VAT Amount Line") + BC25 (integration)
  • OnAfterGetVATPct(var ServiceInvoiceLine: Record "Service Invoice Line"; var VATPct: Decimal) + BC26 (integration)

Trigger event subscribers

Procedures

  • ShowItemTrackingLines()
  • CalcVATAmountLines(ServInvHeader: Record "Service Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)
  • CopyToVATAmountLine(var VATAmountLine: Record "VAT Amount Line") + BC25
  • RowID1(): Text[250]
  • GetCaptionClass(FieldNumber: Integer): Text[80]
  • ShowDimensions()
  • ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
  • GetCurrencyCode(): Code[10]
  • FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")
  • ShowItemShipmentLines()
  • SetSecurityFilterOnRespCenter()
  • GetVATPct(): Decimal + BC26 (internal)

Plus 2 local procedures.

Relations

Referenced by

4 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

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.

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 Invoice Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources