Table extension 6450 Serv. Customer

Base Application, Microsoft.Service.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;        }    }}