Query 8000 Overdue Customer Serv. Comm.
src/Apps/W1/Subscription Billing/App/Overdue Service Commitments/Queries/OverdueCustomerServComm.Query.al56 lines, Copyright (c) Microsoft Corporation. MIT
#if not CLEAN26namespace Microsoft.SubscriptionBilling;query 8000 "Overdue Customer Serv. Comm."{ Caption = 'Overdue Customer Subscription Lines'; QueryType = Normal; ObsoleteState = Pending; ObsoleteTag = '26.0'; ObsoleteReason = 'Removed as there is no need to use queries in order to fetch Service Commitments for temporary display using buffer table "Overdue Service Commitments"'; elements { dataitem(ServiceCommitment; "Subscription Line") { DataItemTableFilter = Partner = const(Customer); column(Partner; Partner) { } column(ContractNo; "Subscription Contract No.") { } column(ServCommDescription; Description) { } column(NextBillingDate; "Next Billing Date") { } column(Quantity; Quantity) { } column(Price; Price) { } column(ServiceAmount; Amount) { }#if not CLEAN26 column(ItemNo; "Item No.") { ObsoleteReason = 'Replaced by field Source No.'; ObsoleteState = Pending; ObsoleteTag = '26.0'; }#endif column(SourceType; "Source Type") { } column(SourceNo; "Source No.") { } column(BillingRhythm; "Billing Rhythm") { } column(ServiceStartDate; "Subscription Line Start Date") { } column(ServiceEndDate; "Subscription Line End Date") { } column(ServiceObjectNo; "Subscription Header No.") { } column(ServiceObjectDescription; "Subscription Description") { } column(ServiceObjectCustomerNo; "Sub. Header Customer No.") { } column(Discount; "Discount %") { } dataitem(Contract; "Customer Subscription Contract") { DataItemLink = "No." = ServiceCommitment."Subscription Contract No."; column(ContractDescription; "Description Preview") { } column(ContractType; "Contract Type") { } column(PartnerName; "Ship-to Name") { } dataitem(ContractLine; "Cust. Sub. Contract Line") { DataItemLink = "Subscription Contract No." = ServiceCommitment."Subscription Contract No.", "Line No." = ServiceCommitment."Subscription Contract Line No."; column(ContractLineClosed; Closed) { } } } } }}#endif