Table 5995 "Service Cr.Memo Line"
Base Application · Microsoft.Service.History
Across versions
- BC23present
- BC244 fields added
- BC251 procedures added, 1 events added
- BC263 fields added, 1 fields removed
- BC27unchanged
- BC2848 fields changed
- BC29-30unchanged
Neighbourhood 58 connected objects and pages
Base Application · Microsoft.Service.History · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5952 “Posted Service Cr. Memo Lines” (1 Learn page), Page 5973 “Posted Serv. Cr. Memo Subform” (1).
Properties
| Property | Value |
|---|---|
| Caption | Service Cr.Memo 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 to receive the service on the credit memo. | TableRelation Table 18 “Customer”; not editable |
| 3 | Document No. Δ BC28 | Code[20] | Specifies the number of the credit memo. | TableRelation Table 5994 “Service Cr.Memo Header” (“Service Cr.Memo Header”.“No.”) |
| 4 | Line No. | Integer | — | |
| 5 | Type Δ BC28 | Enum “Service Line Type” | Specifies the type of the credit memo 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 credit memo 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, or some descriptive text on the service credit memo 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 credit memo 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 5952 “Posted Service Cr. Memo 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 | — | |
| 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 this credit memo line. | not editable |
| 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 5995 “Service Cr.Memo Line” (“Service Cr.Memo 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 items, resources, or costs on the current credit memo line are liable to 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 | — | |
| 100 | Unit Cost | 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 |
| 5709 | Item Category Code | Code[20] | — | TableRelation Table 5722 “Item Category” (“Item Category”.Code) |
| 5710 | Nonstock Δ BC28 | Boolean | Specifies that the item on the credit memo 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] | — | |
| 5811 | Appl.-from Item Entry Δ BC28 | Integer | Specifies the number of the item ledger entry that the document or journal line is applied from. | |
| 5902 | Service Item No. Δ BC28 | Code[20] | Specifies the number of the service item linked to this credit memo line. | TableRelation Table 5940 “Service Item” (“Service Item”.“No.”) |
| 5903 | Appl.-to Service Entry Δ BC28 | Integer | Specifies the number of the service ledger entry applied to this service credit memo. | not editable |
| 5905 | Service Item Serial No. | Code[50] | — | |
| 5906 | Service Item Line Description | Text[100] | — | 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 |
| 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 credit memo. | 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” |
| 5969 | Exclude Contract Discount | Boolean | — | |
| 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.
- Key6: Document 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., Component Line No.
- Key10: Fault Reason Code
- Key11: Customer No.
- Key12: Document No., Type
Events published
OnCalcVATAmountLinesOnBeforeInsertLine(ServiceCrMemoHeader: Record "Service Cr.Memo Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)(integration)OnBeforeSetSecurityFilterOnRespCenter(var ServiceCrMemoLine: Record "Service Cr.Memo Line"; var IsHandled: Boolean)(integration)OnAfterCopyToVATAmountLine(ServiceCrMemoLine: Record "Service Cr.Memo Line"; var VATAmountLine: Record "VAT Amount Line")+ BC25 (integration)OnAfterGetVATPct(var ServiceCrMemoLine: Record "Service Cr.Memo Line"; var VATPct: Decimal)+ BC26 (integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 6459 “Serv. Document Attachment Mgt.” DeleteAttachedDocumentsOnAfterDeleteServiceCreditMemoLine
- OnBeforeInsertEvent: Codeunit 5999 “Service Experience Tier” BlockInsertServiceCrMemoLine
Procedures
ShowDimensions()CalcVATAmountLines(ServCrMemoHeader: Record "Service Cr.Memo Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)CopyToVATAmountLine(var VATAmountLine: Record "VAT Amount Line")+ BC25GetCaptionClass(FieldNumber: Integer): Text[80]ShowItemTrackingLines()ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])RowID1(): Text[250]GetCurrencyCode(): Code[10]FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")SetSecurityFilterOnRespCenter()GetVATPct(): Decimal+ BC26 (internal)
Plus 1 local procedures.
Relations
- drill-down page Page 5952 “Posted Service Cr. Memo Lines”
- lookup page Page 5952 “Posted Service Cr. Memo Lines”
- 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”
- 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”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Variant Code: TableRelation Table 5401 “Item Variant”
- Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
- Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
- VAT Clause Code: TableRelation Table 560 “VAT Clause”
- 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”
- Service Item No.: TableRelation Table 5940 “Service Item”
- Contract No.: TableRelation Table 5965 “Service Contract Header”
- Document No.: TableRelation Table 5994 “Service Cr.Memo Header”
- Attached to Line No.: TableRelation Table 5995 “Service Cr.Memo Line”
- 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”
Referenced by
4 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 5994 “Service Cr.Memo Header”: Amount, Amount Including VAT
- Table 5995 “Service Cr.Memo Line”: Attached to Line No.
- Table extension 6272 “Sust. Service Cr. Memo Header”: Sustainability Lines Exist
Pages and codeunits on this table
- Page 5952 “Posted Service Cr. Memo Lines” (source table)
- Page 5973 “Posted Serv. Cr. Memo Subform” (source table)
- Page 6039 “Service Cr. Memo Lines Subform” (source 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.
- Codeunit 408 “DimensionManagement” (2 calls:
ShowDimensions → ShowDimensionSet,ShowShortcutDimCode → GetShortcutDimensions) - Codeunit 5700 “User Setup Management” (1 call:
SetSecurityFilterOnRespCenter → GetServiceFilter) - Codeunit 6500 “Item Tracking Management” (1 call:
RowID1 → ComposeRowID) - Codeunit 6503 “Item Tracking Doc. Management” (1 call:
ShowItemTrackingLines → ShowItemTrackingForInvoiceLine)
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 Cr.Memo Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.