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

Table 5907 "Service Ledger Entry"

Base Application · Microsoft.Service.Ledger

Across versions

  1. BC23present
  2. BC244 fields changed, 1 fields added
  3. BC25unchanged
  4. BC261 procedures changed
  5. BC27unchanged
  6. BC2850 fields changed
  7. BC291 fields changed, 1 fields added
  8. BC30unchanged

Neighbourhood 36 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 18 "Customer" (relates to, 2 links)CustomerTable 27 "Item" (relates to, 2 links)Table 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 5401 "Item Variant" (relates to, 2 links)Table 5965 "Service Contract Header" (relates to, 2 links)Service Contract HeaderTable 1001 "Job Task" (relates to)Table 14 "Location" (relates to)LocationTable 156 "Resource" (relates to)Table 200 "Work Type" (relates to)Work TypeTable 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)Table 5714 "Responsibility Center" (relates to)Responsibility CenterTable 5903 "Service Order Type" (relates to)Table 5905 "Service Cost" (relates to)Table 5917 "Fault Reason Code" (relates to)Table 5934 "Service Register" (relates to)Table 5940 "Service Item" (relates to)Table 5966 "Contract Group" (relates to)Table 5973 "Service Contract Account Group" (relates to)Table 6080 "Service Price Group" (relates to)Table 6082 "Service Price Adjustment Group" (relates to)Table 7 "Standard Text" (relates to)Table 7354 "Bin" (relates to)Page 5912 "Service Ledger Entries" (pages and codeunits on it, 3 links)Service Ledger EntriesPage 168 "Service Ledger Entries Preview" (pages and codeunits on it)Codeunit 6499 "Serv. Posting Preview Handler" (event subscribers, 2 links)Serv. Posting Preview HandlerCodeunit 5999 "Service Experience Tier" (event subscribers)Codeunit 408 "DimensionManagement" (calls)Codeunit 703 "Find Record Management" (calls)Codeunit 9500 "Sequence No. Mgt." (calls)Table 5940 "Service Item" (referenced by, 11 links)Service ItemTable 5965 "Service Contract Header" (referenced by, 4 links)Table 5934 "Service Register" (referenced by, 2 links)Service Register

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.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property Value
Caption Service Ledger Entry
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
1 Entry No. Δ BC28 Integer Specifies the number of the entry, as assigned from the specified number series when the entry was created.
2 Service Contract No. Δ BC28 Code[20] Specifies the number of the service contract, if this entry is linked to a service contract. TableRelation Table 5965 “Service Contract Header” (“Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract)))
3 Document Type Δ BC28 Enum “Service Ledger Entry Document Type” Specifies the document type of the service ledger entry. enum Enum 5909 “Service Ledger Entry Document Type”
4 Document No. Δ BC28 Code[20] Specifies the number of the document from which this entry was created.
5 Serv. Contract Acc. Gr. Code Δ BC28 Code[10] Specifies the service contract account group code the service contract is associated with, if this entry is included in a service contract. TableRelation Table 5973 “Service Contract Account Group” (“Service Contract Account Group”.Code)
6 Document Line No. Integer —
8 Moved from Prepaid Acc. Δ BC28 Boolean Specifies that this entry is not a prepaid entry from a service contract.
9 Posting Date Δ BC28 Date Specifies the date when this entry was posted.
11 Amount (LCY) Δ BC28 Decimal Specifies the amount of the entry in LCY. via Page 168 “Service Ledger Entries Preview”
12 Customer No. Δ BC28 Code[20] Specifies the number of the customer related to this entry. TableRelation Table 18 “Customer”
13 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.”)))
14 Item No. (Serviced) Code[20] Specifies the number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview” TableRelation Table 27 “Item”
15 Serial No. (Serviced) Code[50] Specifies the serial number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview”
16 User ID Δ BC28 Code[50] Specifies the ID of the user who posted the entry, to be used, for example, in the change log. TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
17 Contract Invoice Period Δ BC28 Text[30] Specifies the invoice period of that contract, if this entry originates from a service contract.
18 Global Dimension 1 Code Δ BC28 Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
19 Global Dimension 2 Code Δ BC28 Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
20 Service Item No. (Serviced) Code[20] Specifies the number of the serviced item associated with this entry. via Page 168 “Service Ledger Entries Preview” TableRelation Table 5940 “Service Item” (Service Item)
21 Variant Code (Serviced) Code[10] — TableRelation Table 5401 “Item Variant” (“Item Variant”.Code where(“Item No.” = field(“Item No. (Serviced)”)))
22 Contract Group Code Δ BC28 Code[10] Specifies the contract group code of the service contract to which this entry is associated. TableRelation Table 5966 “Contract Group” (“Contract Group”.Code)
23 Type Δ BC28 Enum “Service Ledger Entry Type” Specifies the type of origin of this entry. enum Enum 5907 “Service Ledger Entry Type”
24 No. Δ BC28 Code[20] Specifies the number of the involved entry or record, according to the specified number series. TableRelation Table 156 “Resource”, Table 27 “Item”, Table 5905 “Service Cost” (if (Type = const(“Service Contract”)) “Service Contract Header”.“Contract No.” where(“Contract Type” = const(Contract)) else if (Type = const(” “)) “Standard Text” else if (Type = const(Item)) Item else if (Type = const(Resource)) Resource else if (Type = const(“Service Cost”)) “Service Cost” else i…)
25 Cost Amount Δ BC28 Decimal Specifies the total cost on the line by multiplying the unit cost by the quantity.
26 Discount Amount Δ BC28 Decimal Specifies the total discount amount on this entry.
27 Unit Cost Δ BC28 Decimal Specifies the cost of one unit of the item or resource on the line.
28 Quantity Δ BC28 Decimal Specifies the number of units in this entry.
29 Charged Qty. Δ BC28 Decimal Specifies the number of units in this entry that should be invoiced.
30 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.
31 Discount % Δ BC28 Decimal Specifies the discount percentage of this entry.
32 Contract Disc. Amount Δ BC28 Decimal Specifies the total contract discount amount of this entry.
33 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”
34 Fault Reason Code Δ BC28 Code[10] Specifies the fault reason code for this entry. TableRelation Table 5917 “Fault Reason Code” (Fault Reason Code)
35 Description Δ BC28 Text[100] Specifies a description of the resource, item, cost, standard text, general ledger account, or service contract associated with this entry.
37 Service Order Type Δ BC28 Code[10] Specifies the type of the service order if this entry was created for a service order. TableRelation Table 5903 “Service Order Type” (Service Order Type)
39 Service Order No. Δ BC28 Code[20] Specifies the number of the service order, if this entry was created for a service order.
40 Job No. Δ BC24 Δ BC28 Δ BC29 Code[20] Specifies the number of the related project. TableRelation Job.“No.”
41 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)
42 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)
43 Location Code Δ BC28 Code[10] Specifies the code for the location associated with this entry. TableRelation Table 14 “Location”
44 Unit of Measure Code Code[10] — TableRelation Table 204 “Unit of Measure” (Unit of Measure)
45 Work Type Code Code[10] — TableRelation Table 200 “Work Type” (Work Type)
46 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”)))
47 Responsibility Center Code[10] — TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
48 Variant Code Code[10] — TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
50 Entry Type Δ BC28 Enum “Service Ledger Entry Entry Type” Specifies the type for this entry. enum Enum 5908 “Service Ledger Entry Entry Type”
51 Open Δ BC28 Boolean Specifies contract-related service ledger entries.
52 Serv. Price Adjmt. Gr. Code Code[10] — TableRelation Table 6082 “Service Price Adjustment Group” (Service Price Adjustment Group)
53 Service Price Group Code Code[10] — TableRelation Table 6080 “Service Price Group” (Service Price Group)
54 Prepaid Δ BC28 Boolean Specifies whether the service contract or contract-related service order was prepaid.
55 Apply Until Entry No. Integer —
56 Applies-to Entry No. Δ BC28 Integer Specifies the number of the entry to which this entry is applied, if an entry is created for a service credit memo.
57 Amount Δ BC28 Decimal Specifies the amount on this entry.
58 Job Task No. Δ BC24 Δ BC28 Code[20] Specifies the number of the related project task. TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
59 Job Line Type Δ BC24 Δ BC28 Enum “Job Line Type” Specifies the journal line type that is created in the Project Planning Line table and linked to this project ledger entry. enum Enum 1002 “Job Line Type”
60 Job Posted Δ BC24 Boolean Project Posted caption
61 External Document No. + BC24 Δ BC28 Code[35] Specifies a document number that refers to the customer’s numbering system.
95 Service Register No. + BC29 Integer Specifies the service register number that this entry belongs to. TableRelation Table 5934 “Service Register” (Service Register); not editable
480 Dimension Set ID Δ BC28 Integer Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
481 Shortcut Dimension 3 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable
482 Shortcut Dimension 4 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable
483 Shortcut Dimension 5 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable
484 Shortcut Dimension 6 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable
485 Shortcut Dimension 7 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable
486 Shortcut Dimension 8 Code Δ BC28 Code[20] Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable

Keys

  • Key1: Entry No. (clustered)
  • Key2: Document No., Posting Date
  • Key3: Entry Type, Document Type, Document No., Document Line No.
  • Key4: Service Contract No., Entry No., Entry Type, Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid, Service Item No. (Serviced), Customer No., Contract Group Code, Responsibility Center
  • Key5: Service Order No., Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Posting Date, Open, Type, Service Contract No.
  • Key6: Type, No., Entry Type, Moved from Prepaid Acc., Posting Date, Open, Prepaid
  • Key7: Service Item No. (Serviced), Entry Type, Moved from Prepaid Acc., Type, Posting Date, Open, Service Contract No., Prepaid, Customer No., Contract Group Code, Responsibility Center
  • Key8: Service Item No. (Serviced), Entry Type, Type, Service Contract No., Posting Date, Service Order No.
  • Key9: Service Register No.
  • Key10: Service Contract No., Service Item No. (Serviced), Entry Type, Applies-to Entry No.

Events published

  • OnAfterCopyFromServHeader(var ServiceLedgerEntry: Record "Service Ledger Entry"; ServiceHeader: Record "Service Header") (integration)
  • OnAfterCopyFromServLine(var ServiceLedgerEntry: Record "Service Ledger Entry"; ServiceLine: Record "Service Line") (integration)

Trigger event subscribers

Procedures

  • GetNextEntryNo(): Integer + BC29: Gets the next entry number for the Service Ledger Entry table.
  • GetLastEntryNo(): Integer Δ BC26
  • ShowDimensions()
  • CopyFromServHeader(ServHeader: Record "Service Header")
  • CopyFromServLine(ServLine: Record "Service Line"; DocNo: Code[20])
  • CopyServicedInfo(ServiceItemNo: Code[20]; ItemNo: Code[20]; SerialNo: Code[50]; VariantCode: Code[10])

Relations

Referenced by

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

Pages and codeunits on this table

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

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

Evidence 1 sources