Table extension 6450 Serv. Customer
src/Layers/W1/BaseApp/Service/Sales/Customer/ServCustomer.TableExt.al87 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Service.Customer;using Microsoft.Sales.Customer;using Microsoft.Service.Contract;using Microsoft.Service.Document;using Microsoft.Service.History;using Microsoft.Service.Setup;tableextension 6450 "Serv. Customer" extends Customer{ fields { field(5900; "Service Zone Code"; Code[10]) { Caption = 'Service Zone Code'; DataClassification = CustomerContent; TableRelation = "Service Zone"; } field(5902; "Contract Gain/Loss Amount"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; CalcFormula = sum("Contract Gain/Loss Entry".Amount where("Customer No." = field("No."), "Ship-to Code" = field("Ship-to Filter"), "Change Date" = field("Date Filter"))); Caption = 'Contract Gain/Loss Amount'; Editable = false; FieldClass = FlowField; } field(5903; "Ship-to Filter"; Code[10]) { Caption = 'Ship-to Filter'; FieldClass = FlowFilter; TableRelation = "Ship-to Address".Code where("Customer No." = field("No.")); } field(5910; "Outstanding Serv. Orders (LCY)"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; CalcFormula = sum("Service Line"."Outstanding Amount (LCY)" where("Document Type" = const(Order), "Bill-to Customer No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Currency Code" = field("Currency Filter"))); Caption = 'Outstanding Serv. Orders (LCY)'; Editable = false; FieldClass = FlowField; } field(5911; "Serv Shipped Not Invoiced(LCY)"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; CalcFormula = sum("Service Line"."Shipped Not Invoiced (LCY)" where("Document Type" = const(Order), "Bill-to Customer No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Currency Code" = field("Currency Filter"))); Caption = 'Serv Shipped Not Invoiced(LCY)'; Editable = false; FieldClass = FlowField; } field(5912; "Outstanding Serv.Invoices(LCY)"; Decimal) { AutoFormatType = 1; AutoFormatExpression = ''; CalcFormula = sum("Service Line"."Outstanding Amount (LCY)" where("Document Type" = const(Invoice), "Bill-to Customer No." = field("No."), "Shortcut Dimension 1 Code" = field("Global Dimension 1 Filter"), "Shortcut Dimension 2 Code" = field("Global Dimension 2 Filter"), "Currency Code" = field("Currency Filter"))); Caption = 'Outstanding Serv.Invoices(LCY)'; Editable = false; FieldClass = FlowField; } field(5930; "Combine Service Shipments"; Boolean) { AccessByPermission = TableData "Service Shipment Header" = R; Caption = 'Combine Service Shipments'; DataClassification = CustomerContent; } }}