Table 8072 Vend. Sub. Contract Deferral
src/Apps/W1/Subscription Billing/App/Deferrals/Tables/VendSubContractDeferral.Table.al257 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.SubscriptionBilling;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Ledger;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Purchases.Document;using Microsoft.Purchases.History;using Microsoft.Purchases.Vendor;using System.Security.User;table 8072 "Vend. Sub. Contract Deferral"{ Caption = 'Vendor Subscription Contract Deferral'; DataClassification = CustomerContent; DrillDownPageId = "Vendor Contract Deferrals"; LookupPageId = "Vendor Contract Deferrals"; Permissions = tabledata "Purch. Inv. Line" = r, tabledata "Purch. Cr. Memo Line" = r; fields { field(1; "Entry No."; Integer) { Caption = 'Entry No.'; AutoIncrement = true; } field(2; "Subscription Contract No."; Code[20]) { Caption = 'Subscription Contract No.'; TableRelation = "Vendor Subscription Contract"."No."; } field(3; "Document Type"; Enum "Rec. Billing Document Type") { Caption = 'Document Type'; } field(4; "Document No."; Code[20]) { Caption = 'Document No.'; } field(5; "Subscription Contract Type"; Code[10]) { Caption = 'Contract Type'; TableRelation = "Subscription Contract Type".Code; } field(6; "Released"; Boolean) { Caption = 'Released'; } field(7; "Posting Date"; Date) { Caption = 'Posting Date'; } field(8; Amount; Decimal) { Caption = 'Amount'; AutoFormatType = 1; AutoFormatExpression = Rec."Currency Code"; } field(9; "Vendor No."; Code[20]) { Caption = 'Vendor No.'; TableRelation = Vendor; } field(10; "User ID"; Code[50]) { Caption = 'User ID'; DataClassification = EndUserIdentifiableInformation; TableRelation = "User Setup"; ValidateTableRelation = false; } field(13; "Discount Amount"; Decimal) { Caption = 'Discount Amount'; AutoFormatType = 1; AutoFormatExpression = Rec."Currency Code"; } field(14; "Deferral Base Amount"; Decimal) { Caption = 'Deferral Base Amount'; AutoFormatType = 1; AutoFormatExpression = Rec."Currency Code"; } field(15; "Discount %"; Decimal) { Caption = 'Discount %'; DecimalPlaces = 0 : 5; AutoFormatType = 0; } field(16; "Pay-to Vendor No."; Code[20]) { Caption = 'Pay-to Vendor No.'; TableRelation = Vendor; } field(17; "Document Line No."; Integer) { Caption = 'Document Line No.'; } field(18; "Document Posting Date"; Date) { Caption = 'Document Posting Date'; Editable = false; } field(19; "Release Posting Date"; Date) { Caption = 'Release Posting Date'; } field(20; "G/L Entry No."; Integer) { Caption = 'General Ledger Entry No.'; TableRelation = "G/L Entry"; } field(21; "Number of Days"; Integer) { Caption = 'Number of Days'; } field(22; "Subscription Contract Line No."; Integer) { Caption = 'Subscription Contract Line No.'; TableRelation = "Vend. Sub. Contract Line"."Line No."; } field(23; "Subscription Description"; Text[100]) { Caption = 'Subscription Description'; } field(24; "Subscription Line Description"; Text[100]) { Caption = 'Subscription Line Description'; } field(25; Discount; Boolean) { Caption = 'Discount'; } field(26; "Currency Code"; Code[10]) { Caption = 'Currency Code'; } field(27; "G/L Account No."; Code[20]) { Caption = 'G/L Account No.'; ToolTip = 'Specifies the G/L account selected on the Subscription Contract line. If it is filled, releasing the deferral posts to this account instead of the Vendor Subscription Contract Account from the General Posting Setup.'; DataClassification = CustomerContent; Editable = false; TableRelation = "G/L Account"; } field(74; "Gen. Bus. Posting Group"; Code[20]) { Caption = 'Gen. Bus. Posting Group'; ToolTip = 'Specifies the general business posting group.'; TableRelation = "Gen. Business Posting Group"; } field(75; "Gen. Prod. Posting Group"; Code[20]) { Caption = 'Gen. Prod. Posting Group'; ToolTip = 'Specifies the general product posting group.'; TableRelation = "Gen. Product Posting Group"; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; Editable = false; TableRelation = "Dimension Set Entry"; trigger OnLookup() begin ShowDimensions(); end; } } keys { key(PK; "Entry No.") { Clustered = true; } key(SK1; "Subscription Contract No.") { } } internal procedure InitFromPurchaseLine(PurchaseLine: Record "Purchase Line"; var Sign: Integer) begin case PurchaseLine."Document Type" of Enum::"Purchase Document Type"::"Credit Memo": begin "Document Type" := "Document Type"::"Credit Memo"; Sign := -1; end; Enum::"Purchase Document Type"::Invoice: begin "Document Type" := "Document Type"::Invoice; Sign := 1; end; end; if (PurchaseLine."Document Type" = Enum::"Purchase Document Type"::"Credit Memo") and (PurchaseLine.Quantity < 0) then Sign := Sign * -1 else if (PurchaseLine.Quantity < 0) and (not PurchaseLine."Discount") then Sign := Sign * -1; Rec."Vendor No." := PurchaseLine."Pay-to Vendor No."; Rec."Dimension Set ID" := PurchaseLine."Dimension Set ID"; Rec."Discount %" := PurchaseLine."Line Discount %"; Rec."Document Line No." := PurchaseLine."Line No."; Rec."Pay-to Vendor No." := PurchaseLine."Pay-to Vendor No."; Rec.Discount := PurchaseLine."Discount"; Rec."Currency Code" := PurchaseLine."Currency Code"; Rec."Gen. Bus. Posting Group" := PurchaseLine."Gen. Bus. Posting Group"; Rec."Gen. Prod. Posting Group" := PurchaseLine."Gen. Prod. Posting Group"; if PurchaseLine.Type = PurchaseLine.Type::"G/L Account" then Rec."G/L Account No." := PurchaseLine."No."; OnAfterInitFromPurchaseLine(Rec, PurchaseLine, Sign); end; internal procedure ShowDimensions() var DimMgt: Codeunit DimensionManagement; DimTextLbl: Label '%1 %2', Locked = true; begin DimMgt.ShowDimensionSet("Dimension Set ID", CopyStr(StrSubstNo(DimTextLbl, TableCaption, "Entry No."), 1, 250)); end; internal procedure FilterOnDocumentTypeAndDocumentNo(RecurringBillingDocumentType: Enum "Rec. Billing Document Type"; DocumentNo: Code[20]) begin Rec.SetRange("Document Type", RecurringBillingDocumentType); Rec.SetRange("Document No.", DocumentNo); end; internal procedure GetDocumentPostingGroups(var GenBusPostingGroup: Code[20]; var GenProdPostingGroup: Code[20]): Boolean var PurchaseInvoiceLine: Record "Purch. Inv. Line"; PurchCrMemoLine: Record "Purch. Cr. Memo Line"; begin case "Document Type" of "Rec. Billing Document Type"::Invoice: if PurchaseInvoiceLine.Get("Document No.", "Document Line No.") then begin GenBusPostingGroup := PurchaseInvoiceLine."Gen. Bus. Posting Group"; GenProdPostingGroup := PurchaseInvoiceLine."Gen. Prod. Posting Group"; exit(true); end; "Rec. Billing Document Type"::"Credit Memo": if PurchCrMemoLine.Get("Document No.", "Document Line No.") then begin GenBusPostingGroup := PurchCrMemoLine."Gen. Bus. Posting Group"; GenProdPostingGroup := PurchCrMemoLine."Gen. Prod. Posting Group"; exit(true); end; end; exit(false); end; [IntegrationEvent(false, false)] local procedure OnAfterInitFromPurchaseLine(var VendSubContractDeferral: Record "Vend. Sub. Contract Deferral"; PurchaseLine: Record "Purchase Line"; var Sign: Integer) begin end;}