BC Observatoryunofficial, made by waldo
tableService Managementofficial - Microsoftderived - from the source, no model text

Table 5992 "Service Invoice Header"

Base Application · Microsoft.Service.History

Open in Claude5992.mdSource on GitHub

Across versions

  1. BC23present
  2. BC241 fields added
  3. BC251 procedures added, 1 events added
  4. BC261 fields added, 1 procedures changed
  5. BC272 fields changed, 1 events added
  6. BC2868 fields changed
  7. BC29unchanged
  8. BC301 procedures removed, 1 events removed

Neighbourhood 66 connected objects and pages

Table 225 "Post Code" (relates to, 6 links)Post CodeTable 308 "No. Series" (relates to, 4 links)No. SeriesTable 9 "Country/Region" (relates to, 4 links)Table 5950 "Service Order Allocation" (relates to, 3 links)Table 18 "Customer" (relates to, 2 links)CustomerTable 270 "Bank Account" (relates to, 2 links)Bank AccountTable 349 "Dimension Value" (relates to, 2 links)Table 5050 "Contact" (relates to, 2 links)ContactTable 5957 "Service Zone" (relates to, 2 links)Table 5965 "Service Contract Header" (relates to, 2 links)Service Contract HeaderTable 5993 "Service Invoice Line" (relates to, 2 links)Table 10 "Shipment Method" (relates to)Shipment MethodTable 110 "Sales Shipment Header" (relates to)Sales Shipment HeaderTable 112 "Sales Invoice Header" (relates to)Sales Invoice HeaderTable 1230 "SEPA Direct Debit Mandate" (relates to)SEPA Direct Debit MandateTable 13 "Salesperson/Purchaser" (relates to)Table 14 "Location" (relates to)LocationTable 15 "G/L Account" (relates to)Table 152 "Resource Group" (relates to)Table 156 "Resource" (relates to)Table 222 "Ship-to Address" (relates to)Table 230 "Source Code" (relates to)Table 231 "Reason Code" (relates to)Page 5977 "Posted Service Invoices" (pages and codeunits on it, 3 links)Posted Service InvoicesCodeunit 1412 "Service Inv. Header - Edit" (pages and codeunits on it)Codeunit 5902 "Service Inv.-Printed" (pages and codeunits on it)Page 1356 "Posted Service Inv. - Update" (pages and codeunits on it)Page 5978 "Posted Service Invoice" (pages and codeunits on it)Page 6033 "Service Invoice Statistics" (pages and codeunits on it)Table extension 5032 "Serv. Decl. Serv. Inv. Header" (extended by)Table extension 6170 "Posted Service Invoice with QR" (extended by)Codeunit 5999 "Service Experience Tier" (event subscribers)Codeunit 6459 "Serv. Document Attachment Mgt." (event subscribers)Codeunit 10 "Type Helper" (calls, 2 links)Type HelperCodeunit 452 "Report Distribution Management" (calls, 2 links)Report Distribution ManagementCodeunit 408 "DimensionManagement" (calls)Codeunit 5700 "User Setup Management" (calls)Table 5900 "Service Header" (referenced by)Table 5909 "Service Shipment Buffer" (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 5978 “Posted Service Invoice” (1 Learn page), Page 6033 “Service Invoice Statistics” (1).

Properties

Property Value
Caption Service Invoice Header
DataClassification CustomerContent
Permissions TableData “Service Order Allocation” = rimd

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 invoice. TableRelation Table 18 “Customer”; NotBlank
3 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series.
4 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”; NotBlank
5 Bill-to Name Δ BC28 Text[100] Specifies the name of the customer that you send or sent the invoice or credit memo to.
6 Bill-to Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the customer that you send or sent the invoice to.
7 Bill-to Address Δ BC28 Text[100] Specifies the address of the customer to whom you sent the invoice.
8 Bill-to Address 2 Δ BC28 Text[50] Specifies an additional line of the address.
9 Bill-to City Δ BC28 Text[30] Specifies the city of the address. TableRelation Table 225 “Post Code” (“Post Code”.City)
10 Bill-to Contact Δ BC28 Text[100] Specifies the name of the contact person at the customer’s billing address.
11 Your Reference Δ BC28 Text[35] Specifies a customer reference, which will be used when printing service documents.
12 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.”)))
13 Ship-to Name Δ BC28 Text[100] Specifies the name of the customer at the address that the items are shipped to.
14 Ship-to Name 2 Δ BC28 Text[50] Specifies an additional part of thethe name of the customer at the address that the items are shipped to.
15 Ship-to Address Δ BC28 Text[100] Specifies the address that the items are shipped to.
16 Ship-to Address 2 Δ BC28 Text[50] Specifies an additional part of the ship-to address, in case it is a long address.
17 Ship-to City Δ BC28 Text[30] Specifies the city of the address that the items are shipped to. TableRelation Table 225 “Post Code” (“Post Code”.City)
18 Ship-to Contact Δ BC28 Text[100] Specifies the name of the contact person at the address that the items are shipped to.
19 Order Date Date — NotBlank
20 Posting Date Δ BC28 Date Specifies the date when the invoice was posted.
22 Posting Description Text[100] —
23 Payment Terms Code Code[10] — TableRelation Table 3 “Payment Terms” (Payment Terms)
24 Due Date Δ BC28 Date Specifies when the related invoice must be paid.
25 Payment Discount % Δ BC28 Decimal —
26 Pmt. Discount Date Date —
27 Shipment Method Code Δ BC28 Code[10] Specifies the code that represents the shipment method for the invoice. TableRelation Table 10 “Shipment Method” (Shipment Method)
28 Location Code Δ BC28 Code[10] Specifies the location, such as warehouse or distribution center, from which the service was shipped. TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
29 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)))
30 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)))
31 Customer Posting Group Δ BC28 Code[20] Specifies the customer’s market type to link business transactions to. TableRelation Table 92 “Customer Posting Group” (Customer Posting Group); not editable
32 Currency Code Δ BC28 Code[10] Specifies the currency code for the amounts on the invoice. TableRelation Table 4 “Currency”; not editable
33 Currency Factor Δ BC28 Decimal —
34 Customer Price Group Code[10] — TableRelation Table 6 “Customer Price Group” (Customer Price Group)
35 Prices Including VAT Boolean —
37 Invoice Disc. Code Code[20] —
40 Customer Disc. Group Code[20] — TableRelation Table 340 “Customer Discount Group” (Customer Discount Group)
41 Language Code Code[10] — TableRelation Table 8 “Language”
42 Format Region Text[80] — TableRelation “Language Selection”.“Language Tag”
43 Salesperson Code Δ BC28 Code[20] Specifies the code of the salesperson associated with the invoice. TableRelation Table 13 “Salesperson/Purchaser” (Salesperson/Purchaser)
44 Order No. Δ BC28 Code[20] Specifies the number of the service order from which this invoice was posted.
46 Comment Boolean — FlowField: exist(“Service Comment Line” where(“Table Name” = const(“Service Invoice Header”), “No.” = field(“No.”), Type = const(General))); not editable
47 No. Printed Δ BC28 Integer Specifies how many times the document has been printed. not editable
52 Applies-to Doc. Type Enum “Gen. Journal Document Type” — enum Enum 6 “Gen. Journal Document Type”
53 Applies-to Doc. No. Code[20] —
55 Bal. Account No. Code[20] — TableRelation Table 15 “G/L Account”, Table 270 “Bank Account” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account”)
60 Amount Δ BC28 Decimal Specifies the total invoice amount excluding VAT. FlowField: sum(“Service Invoice Line”.Amount where(“Document No.” = field(“No.”))); not editable
61 Amount Including VAT Δ BC28 Decimal Specifies the total invoice amount including VAT. FlowField: sum(“Service Invoice Line”.“Amount Including VAT” where(“Document No.” = field(“No.”))); not editable
62 Shipping No. Code[20] —
63 Posting No. Code[20] —
64 Last Shipping No. Code[20] — TableRelation Table 110 “Sales Shipment Header” (Sales Shipment Header); not editable
65 Last Posting No. Code[20] — TableRelation Table 112 “Sales Invoice Header” (Sales Invoice Header); not editable
70 VAT Registration No. Text[20] —
73 Reason Code Code[10] — TableRelation Table 231 “Reason Code” (Reason Code)
74 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75 EU 3-Party Trade Δ BC28 Boolean Specifies if the transaction is related to trade with a third party within the EU.
76 Transaction Type Code[10] — TableRelation Table 258 “Transaction Type” (Transaction Type)
77 Transport Method Code[10] — TableRelation Table 259 “Transport Method” (Transport Method)
78 VAT Country/Region Code Code[10] — TableRelation Table 9 “Country/Region” (Country/Region)
79 Name Δ BC28 Text[100] Specifies the name of the customer on the service invoice.
80 Name 2 Δ BC27 Text[50] Specifies an additional part of the name of the customer on the service credit memo.
81 Address Δ BC28 Text[100] Specifies the address of the customer on the invoice.
82 Address 2 Δ BC28 Text[50] Specifies additional address information.
83 City Δ BC28 Text[30] Specifies the city of the address. TableRelation Table 225 “Post Code” (“Post Code”.City)
84 Contact Name Δ BC28 Text[100] Specifies the name of the contact person at the customer company.
85 Bill-to Post Code Δ BC28 Code[20] Specifies the postal code of the customer’s billing address. TableRelation Table 225 “Post Code” (Post Code)
86 Bill-to County Δ BC28 Text[30] Specifies the county in the customer’s address.
87 Bill-to Country/Region Code Δ BC28 Code[10] Specifies the country/region code of the customer’s billing address. TableRelation Table 9 “Country/Region” (Country/Region)
88 Post Code Δ BC28 Code[20] Specifies the postal code. TableRelation Table 225 “Post Code” (Post Code)
89 County Δ BC28 Text[30] Specifies the county in the customer’s address.
90 Country/Region Code Δ BC28 Code[10] Specifies the country/region of the address. TableRelation Table 9 “Country/Region” (Country/Region)
91 Ship-to Post Code Δ BC28 Code[20] Specifies the postal code of the address that the items are shipped to. TableRelation Table 225 “Post Code” (Post Code)
92 Ship-to County Δ BC28 Text[30] Specifies the county in the customer’s address.
93 Ship-to Country/Region Code Δ BC28 Code[10] Specifies the country/region in the customer’s address. TableRelation Table 9 “Country/Region” (Country/Region)
94 Bal. Account Type enum “Payment Balance Account Type” — enum Enum 96 “Payment Balance Account Type”
97 Exit Point Code[10] — TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
98 Correction Boolean —
99 Document Date Δ BC28 Date Specifies the date when the related document was created.
100 External Document No. Δ BC28 Code[35] Specifies the external document number that is entered on the service header that this line was posted from.
101 Area Code[10] — TableRelation Table 284 “Area”
102 Transaction Specification Code[10] — TableRelation Table 285 “Transaction Specification” (Transaction Specification)
104 Payment Method Code Δ BC28 Code[10] Specifies how the customer must pay for products on the service document, such as with bank transfer, cash, or check. TableRelation Table 289 “Payment Method” (Payment Method)
105 Shipping Agent Code Δ BC28 Code[10] Specifies which shipping agent is used to transport the items on the service document to the customer. TableRelation Table 291 “Shipping Agent” (Shipping Agent)
107 Pre-Assigned No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series); not editable
108 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
109 Shipping No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
110 Order No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
111 Pre-Assigned No. Δ BC28 Code[20] Specifies the number of the service document from which the posted invoice was created.
112 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
113 Source Code Code[10] — TableRelation Table 230 “Source Code” (Source Code)
114 Tax Area Code Δ BC28 Code[20] Specifies the code of the tax area where the customer is located. TableRelation Table 318 “Tax Area” (Tax Area)
115 Tax Liable Δ BC28 Boolean Specifies if the customer is liable for sales tax.
116 VAT Bus. Posting Group Code[20] — TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
119 VAT Base Discount % Δ BC28 Decimal —
129 Company Bank Account Code Δ BC28 Code[20] Specifies the bank account to use for bank information when the document is printed. TableRelation Table 270 “Bank Account” (“Bank Account” where(“Currency Code” = field(“Currency Code”)))
131 VAT Reporting Date Δ BC28 Date Specifies the VAT date on the invoice. not editable
180 Payment Reference Δ BC28 Code[50] Specifies the payment of the service invoice.
200 Work Description + BC26 BLOB —
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
710 Document Exchange Identifier Text[50] —
711 Document Exchange Status Δ BC28 Enum “Service Document Exchange Status” Specifies the status of the document if you are using a document exchange service to send it as an electronic document. The status values are reported by the document exchange service. enum Enum 712 “Service Document Exchange Status”
712 Doc. Exch. Original Identifier Text[50] —
1200 Direct Debit Mandate ID Code[35] — TableRelation Table 1230 “SEPA Direct Debit Mandate” (“SEPA Direct Debit Mandate” where(“Customer No.” = field(“Bill-to Customer No.”))); DataClassification SystemMetadata
5052 Contact No. Δ BC28 Code[20] Specifies the number of the contact at the customer to whom you shipped the service. TableRelation Table 5050 “Contact”
5053 Bill-to Contact No. Δ BC28 Code[20] Specifies the number of the contact person at the customer’s billing address. TableRelation Table 5050 “Contact”
5700 Responsibility Center Δ BC28 Code[10] Specifies the code of the responsibility center, such as a distribution hub, that is associated with the involved user, company, customer, or vendor. TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5794 Shipping Agent Service Code Δ BC28 Code[10] Specifies which shipping agent service is used to transport the items on the service document to the customer. TableRelation Table 5790 “Shipping Agent Services” (“Shipping Agent Services”.Code where(“Shipping Agent Code” = field(“Shipping Agent Code”)))
5902 Description Text[100] —
5904 Service Order Type Code[10] — TableRelation Table 5903 “Service Order Type” (Service Order Type)
5905 Link Service to Service Item Boolean —
5907 Priority Option — OptionCaption: Low,Medium,High; not editable
5911 Allocated Hours Δ BC28 Decimal — FlowField: sum(“Service Order Allocation”.“Allocated Hours” where(“Document Type” = const(Order), “Document No.” = field(“No.”), “Resource No.” = field(“Resource Filter”), Status = filter(Active | Finished), “Resource Group No.” = field(“Resource Group Filter”))); not editable
5915 Phone No. Text[30] —
5916 E-Mail Text[80] Email caption
5917 Phone No. 2 Text[30] —
5918 Fax No. Text[30] —
5921 No. of Unallocated Items Integer — FlowField: count(“Service Item Line” where(“Document Type” = const(Order), “Document No.” = field(“No.”), “No. of Active/Finished Allocs” = const(0))); not editable
5923 Order Time Time — NotBlank
5924 Default Response Time (Hours) Δ BC28 Decimal —
5925 Actual Response Time (Hours) Δ BC28 Decimal — not editable
5926 Service Time (Hours) Δ BC28 Decimal — not editable
5927 Response Date Date — not editable
5928 Response Time Time — not editable
5929 Starting Date Date —
5930 Starting Time Time —
5931 Finishing Date Date —
5932 Finishing Time Time —
5933 Contract Serv. Hours Exist Boolean — FlowField: exist(“Service Hour” where(“Service Contract No.” = field(“Contract No.”))); not editable
5934 Reallocation Needed Boolean — FlowField: exist(“Service Order Allocation” where(Status = const(“Reallocation Needed”), “Resource No.” = field(“Resource Filter”), “Document Type” = const(Order), “Document No.” = field(“No.”), “Resource Group No.” = field(“Resource Group Filter”))); not editable
5936 Notify Customer Option — OptionCaption: No,By Phone 1,By Phone 2,By Fax,By Email
5937 Max. Labor Unit Price Decimal —
5938 Warning Status Option — OptionCaption: ,First Warning,Second Warning,Third Warning
5939 No. of Allocations Integer — FlowField: count(“Service Order Allocation” where(“Document Type” = const(Order), “Document No.” = field(“No.”), “Resource No.” = field(“Resource Filter”), “Resource Group No.” = field(“Resource Group Filter”), Status = filter(Active | Finished))); not editable
5940 Contract No. Code[20] — TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract), “Customer No.” = field(“Customer No.”), “Ship-to Code” = field(“Ship-to Code”), “Bill-to Customer No.” = field(“Bill-to Customer No.”)))
5951 Type Filter Option — FlowFilter; OptionCaption: ,Resource,Item,Service Cost,Service Contract
5952 Customer Filter Code[20] — TableRelation Customer.“No.”; FlowFilter
5953 Resource Filter Code[20] — TableRelation Table 156 “Resource”; FlowFilter
5954 Contract Filter Code[20] — TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract))); FlowFilter
5955 Ship-to Fax No. Text[30] —
5956 Ship-to E-Mail Text[80] Ship-to Email caption
5957 Resource Group Filter Code[20] — TableRelation Table 152 “Resource Group” (Resource Group); FlowFilter
5958 Ship-to Phone Δ BC28 Text[30] Specifies the telephone number of the company’s shipping address.
5959 Ship-to Phone 2 Text[30] —
5966 Service Zone Filter Code[10] — TableRelation Table 5957 “Service Zone” (“Service Zone”.Code); FlowFilter
5968 Service Zone Code Code[10] — TableRelation Table 5957 “Service Zone” (“Service Zone”.Code); not editable
5981 Expected Finishing Date Date —
7000 Price Calculation Method Enum “Price Calculation Method” — enum Enum 7000 “Price Calculation Method”
7001 Allow Line Disc. Boolean —
9001 Quote No. + BC24 Δ BC28 Code[20] Specifies the number of the service quote document if a quote was used to start the service process.

Keys

  • Key1: No. (clustered)
  • Key2: Order No.
  • Key3: Customer No., Order Date
  • Key4: Contract No., Posting Date
  • Key5: Response Date, Response Time, Priority
  • Key6: Priority, Response Date, Response Time
  • Key7: Posting Date

Events published

  • OnBeforePrintRecords(var ServiceInvoiceHeader: Record "Service Invoice Header"; ShowRequestPage: Boolean; var IsHandled: Boolean) (integration)
  • OnBeforeSendProfile(var ServiceInvoiceHeader: Record "Service Invoice Header"; var DocumentSendingProfile: Record "Document Sending Profile"; var IsHandled: Boolean) (integration)
  • OnBeforeSendRecords(var ServiceInvoiceHeader: Record "Service Invoice Header"; var IsHandled: Boolean) (integration)
  • OnBeforeSetSecurityFilterOnRespCenter(var ServiceInvoiceHeader: Record "Service Invoice Header"; var IsHandled: Boolean) (integration)
  • OnOpenStatisticsOnAfterSetStatPageID(var ServiceInvoiceHeader: Record "Service Invoice Header"; var StatPageID: Integer) + BC25 Δ BC26 − BC30 (integration, obsolete 27.0)
  • OnLookupAppliestoDocNoOnAfterSetFilters(ServiceInvoiceHeader: Record "Service Invoice Header"; var CustLedgerEntry: Record "Cust. Ledger Entry") + BC27 (integration)
  • OnBeforeOnDelete(var ServiceInvoiceHeader: Record "Service Invoice Header") + BC26 (integration)

Trigger event subscribers

Procedures

  • Navigate()
  • SendRecords()
  • SendProfile(var DocumentSendingProfile: Record "Document Sending Profile")
  • PrintRecords(ShowRequestPage: Boolean)
  • LookupAdjmtValueEntries()
  • ShowDimensions()
  • SetSecurityFilterOnRespCenter()
  • OpenStatistics() + BC25 Δ BC26 − BC30 (obsolete 27.0: The statistics action will be replaced with the ServiceStatistics action. The new action uses RunObject and does not run the action trigger. Use a page extension to modify the behaviour.)
  • ShowActivityLog()
  • GetDocExchStatusStyle(): Text
  • PrintToDocumentAttachment(var ServiceInvoiceHeader: Record "Service Invoice Header")
  • GetWorkDescription(): Text + BC26

Plus 1 local procedures.

Triggers

OnDelete

Relations

Referenced by

4 fields in 4 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.

Recent changes

Deprecations

  • procedure OnOpenStatisticsOnAfterSetStatPageID: Pending 27.0 (#if not CLEAN27), “The statistics action will be replaced with the ServiceStatistics action. The new action uses RunObject and does not run the action trigger. Use a page extension to modify the behaviour.”
  • procedure OpenStatistics: Pending 27.0 (#if not CLEAN27), “The statistics action will be replaced with the ServiceStatistics action. The new action uses RunObject and does not run the action trigger. Use a page extension to modify the behaviour.”

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

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

Evidence 1 sources