Table 6100 E-Document Purchase Header

E-Document Core, Microsoft.eServices.EDocument.Processing.Import.Purchase

src/Apps/W1/EDocument/App/src/Processing/Import/Purchase/EDocumentPurchaseHeader.Table.al360 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.EServices.EDocument.Processing.Import.Purchase;using Microsoft.eServices.EDocument;using Microsoft.eServices.EDocument.Processing.Import;using Microsoft.Finance.GeneralLedger.Setup;using Microsoft.Purchases.Document;using Microsoft.Purchases.Setup;using Microsoft.Purchases.Vendor;using System.Telemetry;table 6100 "E-Document Purchase Header"{    ReplicateData = false;    InherentEntitlements = RIMDX;    InherentPermissions = RIMDX;    fields    {        field(1; "E-Document Entry No."; Integer)        {            Caption = 'E-Document Entry No.';            TableRelation = "E-Document"."Entry No";            DataClassification = SystemMetadata;            ValidateTableRelation = true;        }        #region External data - Purchase fields [2-100]        field(2; "Customer Company Name"; Text[250])        {            Caption = 'Customer Company Name';            DataClassification = CustomerContent;        }        field(3; "Customer Company Id"; Text[250])        {            Caption = 'Customer Company Id';            DataClassification = CustomerContent;        }        field(4; "Purchase Order No."; Text[100])        {            Caption = 'Purchase Order No.';            DataClassification = CustomerContent;        }        field(5; "Sales Invoice No."; Text[100])        {            Caption = 'Sales Invoice No.';            DataClassification = CustomerContent;        }        field(6; "Invoice Date"; Date)        {            Caption = 'Invoice Date';            DataClassification = CustomerContent;        }        field(7; "Due Date"; Date)        {            Caption = 'Due Date';            DataClassification = CustomerContent;        }        field(8; "Document Date"; Date)        {            Caption = 'Document Date';            DataClassification = CustomerContent;        }        field(9; "Vendor Company Name"; Text[250])        {            Caption = 'Vendor Company Name';            DataClassification = CustomerContent;        }        field(10; "Vendor Address"; Text[250])        {            Caption = 'Vendor Address';            DataClassification = CustomerContent;        }        field(11; "Vendor Address Recipient"; Text[250])        {            Caption = 'Vendor Address Recipient';            DataClassification = CustomerContent;        }        field(12; "Customer Address"; Text[250])        {            Caption = 'Customer Address';            DataClassification = CustomerContent;        }        field(13; "Customer Address Recipient"; Text[250])        {            Caption = 'Customer Address Recipient';            DataClassification = CustomerContent;        }        field(14; "Billing Address"; Text[250])        {            Caption = 'Billing Address';            DataClassification = CustomerContent;        }        field(15; "Billing Address Recipient"; Text[250])        {            Caption = 'Billing Address Recipient';            DataClassification = CustomerContent;        }        field(16; "Shipping Address"; Text[250])        {            Caption = 'Shipping Address';            DataClassification = CustomerContent;        }        field(17; "Shipping Address Recipient"; Text[250])        {            Caption = 'Shipping Address Recipient';            DataClassification = CustomerContent;        }        field(18; "Sub Total"; Decimal)        {            Caption = 'Sub Total';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(19; "Total Discount"; Decimal)        {            Caption = 'Total Discount';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(20; "Total VAT"; Decimal)        {            Caption = 'Total VAT';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(21; Total; Decimal)        {            Caption = 'Total';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(22; "Amount Due"; Decimal)        {            Caption = 'Amount Due';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(23; "Previous Unpaid Balance"; Decimal)        {            Caption = 'Previous Unpaid Balance';            DataClassification = CustomerContent;            AutoFormatType = 1;            AutoFormatExpression = Rec."Currency Code";        }        field(24; "Currency Code"; Code[10])        {            Caption = 'Currency Code';            DataClassification = CustomerContent;        }        field(25; "Remittance Address"; Text[250])        {            Caption = 'Remittance Address';            DataClassification = CustomerContent;        }        field(26; "Remittance Address Recipient"; Text[250])        {            Caption = 'Remittance Address Recipient';            DataClassification = CustomerContent;        }        field(27; "Service Address"; Text[250])        {            Caption = 'Service Address';            DataClassification = CustomerContent;        }        field(28; "Service Address Recipient"; Text[250])        {            Caption = 'Service Address Recipient';            DataClassification = CustomerContent;        }        field(29; "Service Start Date"; Date)        {            Caption = 'Service Start Date';            DataClassification = CustomerContent;        }        field(30; "Service End Date"; Date)        {            Caption = 'Service End Date';            DataClassification = CustomerContent;        }        field(31; "Vendor VAT Id"; Text[100])        {            Caption = 'Vendor VAT Id';            DataClassification = CustomerContent;        }        field(32; "Customer VAT Id"; Text[100])        {            Caption = 'Customer VAT Id';            DataClassification = CustomerContent;        }        field(33; "Payment Terms"; Text[250])        {            Caption = 'Payment Terms';            DataClassification = CustomerContent;        }        field(34; "Customer GLN"; Text[13])        {            Caption = 'Customer Global Location Number';            DataClassification = CustomerContent;        }        field(35; "Vendor GLN"; Text[13])        {            Caption = 'Vendor Global Location Number';            DataClassification = CustomerContent;        }        field(36; "Vendor External Id"; Text[250])        {            Caption = 'Vendor External Id';            DataClassification = CustomerContent;        }        field(37; "Vendor Contact Name"; Text[250])        {            Caption = 'Vendor Contact Name';            DataClassification = CustomerContent;        }        field(38; "Posting Description"; Text[100])        {            Caption = 'Posting Description';            DataClassification = CustomerContent;        }        field(39; "Applies-to Doc. No."; Text[100])        {            Caption = 'Applies-to Doc. No.';            DataClassification = CustomerContent;        }        field(40; "Vendor Invoice No."; Text[100])        {            Caption = 'Applies-to Vendor Inv. No.';            DataClassification = CustomerContent;        }        field(41; "Several Invoices Referenced"; Boolean)        {            Caption = 'Several Invoices Referenced';            ToolTip = 'Specifies whether the credit note states more than one invoice. Only the first one is kept in Applies-to Vendor Inv. No.';            DataClassification = SystemMetadata;        }        #endregion Purchase fields        #region Business Central Data - Validated fields [101-200]        field(101; "[BC] Vendor No."; Code[20])        {            Caption = 'Vendor No.';            DataClassification = CustomerContent;            TableRelation = Vendor."No.";        }        field(102; "[BC] Purchase Order No."; Code[20])        {            Caption = 'Purchase Order No.';            DataClassification = CustomerContent;            TableRelation = "Purchase Header"."No." where("Document Type" = const(Order));        }        #endregion Business Central Data    }    keys    {        key(PK; "E-Document Entry No.")        {            Clustered = true;        }    }    trigger OnDelete()    var        EDocImpSessionTelemetry: Codeunit "E-Doc. Imp. Session Telemetry";        Telemetry: Codeunit Telemetry;        CustomDimensions: Dictionary of [Text, Text];    begin        CustomDimensions.Set('Category', FeatureName());        CustomDimensions.Set('SystemId', EDocImpSessionTelemetry.CreateSystemIdText(Rec.SystemId));        Telemetry.LogMessage('0000PCQ', DeleteDraftPerformedTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::All, CustomDimensions);        FeatureTelemetry.LogUsage('0000PCV', FeatureName(), 'Discard draft');    end;    procedure GetFromEDocument(EDocument: Record "E-Document")    begin        Clear(Rec);        if Rec.Get(EDocument."Entry No") then;    end;    procedure InsertForEDocument(EDocument: Record "E-Document")    begin        if not Rec.Get(EDocument."Entry No") then begin            Rec."E-Document Entry No." := EDocument."Entry No";            Rec.Insert();        end;    end;    procedure GetBCVendor() Vendor: Record Vendor    begin        if Vendor.Get(Rec."[BC] Vendor No.") then;    end;    procedure GetAppliedVATAmountDiff(): Decimal    var        EDocumentPurchaseLine: Record "E-Document Purchase Line";        PurchasesPayablesSetup: Record "Purchases & Payables Setup";        GeneralLedgerSetup: Record "General Ledger Setup";        LineAmount: Decimal;        TotalLineVATAmount: Decimal;        VATAmountDiff: Decimal;    begin        if Rec."Total VAT" = 0 then            exit(0);        if not PurchasesPayablesSetup.Get() then            exit(0);        if not PurchasesPayablesSetup."Apply VAT Diff. For Purch EDoc" then            exit(0);        if not PurchasesPayablesSetup."Allow VAT Difference" then            exit(0);        if not GeneralLedgerSetup.Get() then            exit(0);        EDocumentPurchaseLine.SetRange("E-Document Entry No.", Rec."E-Document Entry No.");        if EDocumentPurchaseLine.FindSet() then            repeat                LineAmount := Round(EDocumentPurchaseLine.Quantity * EDocumentPurchaseLine."Unit Price" - EDocumentPurchaseLine."Total Discount");                TotalLineVATAmount += Round(LineAmount * EDocumentPurchaseLine."VAT Rate" / 100);            until EDocumentPurchaseLine.Next() = 0;        if TotalLineVATAmount = Rec."Total VAT" then            exit(0);        VATAmountDiff := Rec."Total VAT" - TotalLineVATAmount;        if Abs(VATAmountDiff) > GeneralLedgerSetup."Max. VAT Difference Allowed" then            exit(0);        exit(VATAmountDiff);    end;    internal procedure FeatureName(): Text    begin        exit('E-Document Matching Assistance');    end;    internal procedure IsFinalized(): Boolean    var        EDocument: Record "E-Document";    begin        if Rec."E-Document Entry No." = 0 then            exit(false);        if not EDocument.Get(Rec."E-Document Entry No.") then            exit(false);        exit(EDocument.Status = EDocument.Status::Processed);    end;    var        FeatureTelemetry: Codeunit "Feature Telemetry";        DeleteDraftPerformedTxt: Label 'User deleted the draft.', Locked = true;}