Table 5495 Sales Order Entity Buffer
src/Layers/W1/BaseApp/Integration/Entity/SalesOrderEntityBuffer.Table.al629 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.Integration.Entity;using Microsoft.CRM.Contact;using Microsoft.CRM.Team;using Microsoft.Finance.Currency;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Address;using Microsoft.Foundation.PaymentTerms;using Microsoft.Foundation.Shipping;using Microsoft.Sales.Customer;using Microsoft.Sales.Document;using Microsoft.Sales.History;using Microsoft.Sales.Receivables;table 5495 "Sales Order Entity Buffer"{ Caption = 'Sales Order Entity Buffer'; ReplicateData = false; DataClassification = CustomerContent; fields { field(2; "Sell-to Customer No."; Code[20]) { Caption = 'Sell-to Customer No.'; DataClassification = CustomerContent; NotBlank = true; TableRelation = Customer; trigger OnValidate() begin UpdateSellToCustomerId(); end; } field(3; "No."; Code[20]) { Caption = 'No.'; DataClassification = CustomerContent; } field(4; "Bill-to Customer No."; Code[20]) { Caption = 'Bill-to Customer No.'; DataClassification = CustomerContent; NotBlank = true; TableRelation = Customer; trigger OnValidate() begin UpdateBillToCustomerId(); end; } field(5; "Bill-to Name"; Text[100]) { Caption = 'Bill-to Name'; DataClassification = CustomerContent; TableRelation = Customer.Name; ValidateTableRelation = false; } field(7; "Bill-to Address"; Text[100]) { Caption = 'Bill-to Address'; DataClassification = CustomerContent; } field(8; "Bill-to Address 2"; Text[50]) { Caption = 'Bill-to Address 2'; DataClassification = CustomerContent; } field(9; "Bill-to City"; Text[30]) { Caption = 'Bill-to City'; DataClassification = CustomerContent; TableRelation = if ("Bill-to Country/Region Code" = const('')) "Post Code".City else if ("Bill-to Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Bill-to Country/Region Code")); ValidateTableRelation = false; } field(10; "Bill-to Contact"; Text[100]) { Caption = 'Bill-to Contact'; DataClassification = CustomerContent; } field(12; "Ship-to Code"; Code[10]) { Caption = 'Ship-to Code'; DataClassification = CustomerContent; } field(13; "Ship-to Name"; Text[100]) { Caption = 'Ship-to Name'; DataClassification = CustomerContent; } field(15; "Ship-to Address"; Text[100]) { Caption = 'Ship-to Address'; DataClassification = CustomerContent; } field(16; "Ship-to Address 2"; Text[50]) { Caption = 'Ship-to Address 2'; DataClassification = CustomerContent; } field(17; "Ship-to City"; Text[30]) { Caption = 'Ship-to City'; DataClassification = CustomerContent; TableRelation = if ("Ship-to Country/Region Code" = const('')) "Post Code".City else if ("Ship-to Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Ship-to Country/Region Code")); ValidateTableRelation = false; } field(18; "Ship-to Contact"; Text[100]) { Caption = 'Ship-to Contact'; DataClassification = CustomerContent; } field(20; "Posting Date"; Date) { Caption = 'Posting Date'; DataClassification = CustomerContent; } field(23; "Payment Terms Code"; Code[10]) { Caption = 'Payment Terms Code'; DataClassification = CustomerContent; TableRelation = "Payment Terms"; trigger OnValidate() begin UpdatePaymentTermsId(); end; } field(27; "Shipment Method Code"; Code[10]) { Caption = 'Shipment Method Code'; DataClassification = CustomerContent; TableRelation = "Shipment Method"; trigger OnValidate() begin UpdateShipmentMethodId(); end; } field(29; "Shortcut Dimension 1 Code"; Code[20]) { Caption = 'Shortcut Dimension 1 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); } field(30; "Shortcut Dimension 2 Code"; Code[20]) { Caption = 'Shortcut Dimension 2 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); } field(31; "Customer Posting Group"; Code[20]) { Caption = 'Customer Posting Group'; DataClassification = CustomerContent; TableRelation = "Customer Posting Group"; } field(32; "Currency Code"; Code[10]) { Caption = 'Currency Code'; DataClassification = CustomerContent; TableRelation = Currency; trigger OnValidate() begin UpdateCurrencyId(); end; } field(35; "Prices Including VAT"; Boolean) { Caption = 'Prices Including VAT'; DataClassification = CustomerContent; } field(43; "Salesperson Code"; Code[20]) { Caption = 'Salesperson Code'; DataClassification = CustomerContent; TableRelation = "Salesperson/Purchaser" where(Blocked = const(false)); } field(56; "Recalculate Invoice Disc."; Boolean) { CalcFormula = exist("Sales Line" where("Document Type" = const(Invoice), "Document No." = field("No."), "Recalculate Invoice Disc." = const(true))); Caption = 'Recalculate Invoice Disc.'; Editable = false; FieldClass = FlowField; } field(60; Amount; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Amount'; DataClassification = CustomerContent; } field(61; "Amount Including VAT"; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Amount Including VAT'; DataClassification = CustomerContent; } field(79; "Sell-to Customer Name"; Text[100]) { Caption = 'Sell-to Customer Name'; DataClassification = CustomerContent; TableRelation = Customer.Name; ValidateTableRelation = false; } field(81; "Sell-to Address"; Text[100]) { Caption = 'Sell-to Address'; DataClassification = CustomerContent; } field(82; "Sell-to Address 2"; Text[50]) { Caption = 'Sell-to Address 2'; DataClassification = CustomerContent; } field(83; "Sell-to City"; Text[30]) { Caption = 'Sell-to City'; DataClassification = CustomerContent; TableRelation = if ("Sell-to Country/Region Code" = const('')) "Post Code".City else if ("Sell-to Country/Region Code" = filter(<> '')) "Post Code".City where("Country/Region Code" = field("Sell-to Country/Region Code")); ValidateTableRelation = false; } field(84; "Sell-to Contact"; Text[100]) { Caption = 'Sell-to Contact'; DataClassification = CustomerContent; } field(85; "Bill-to Post Code"; Code[20]) { Caption = 'Bill-to Post Code'; DataClassification = CustomerContent; TableRelation = "Post Code"; ValidateTableRelation = false; } field(86; "Bill-to County"; Text[30]) { CaptionClass = '5,3,' + "Bill-to Country/Region Code"; Caption = 'Bill-to County'; DataClassification = CustomerContent; } field(87; "Bill-to Country/Region Code"; Code[10]) { Caption = 'Bill-to Country/Region Code'; DataClassification = CustomerContent; TableRelation = "Country/Region"; } field(88; "Sell-to Post Code"; Code[20]) { Caption = 'Sell-to Post Code'; DataClassification = CustomerContent; TableRelation = if ("Sell-to Country/Region Code" = const('')) "Post Code" else if ("Sell-to Country/Region Code" = filter(<> '')) "Post Code" where("Country/Region Code" = field("Sell-to Country/Region Code")); ValidateTableRelation = false; } field(89; "Sell-to County"; Text[30]) { CaptionClass = '5,2,' + "Sell-to Country/Region Code"; Caption = 'Sell-to County'; DataClassification = CustomerContent; } field(90; "Sell-to Country/Region Code"; Code[10]) { Caption = 'Sell-to Country/Region Code'; DataClassification = CustomerContent; TableRelation = "Country/Region"; } field(91; "Ship-to Post Code"; Code[20]) { Caption = 'Ship-to Post Code'; DataClassification = CustomerContent; TableRelation = if ("Ship-to Country/Region Code" = const('')) "Post Code" else if ("Ship-to Country/Region Code" = filter(<> '')) "Post Code" where("Country/Region Code" = field("Ship-to Country/Region Code")); ValidateTableRelation = false; } field(92; "Ship-to County"; Text[30]) { CaptionClass = '5,4,' + "Ship-to Country/Region Code"; Caption = 'Ship-to County'; DataClassification = CustomerContent; } field(93; "Ship-to Country/Region Code"; Code[10]) { Caption = 'Ship-to Country/Region Code'; DataClassification = CustomerContent; TableRelation = "Country/Region"; } field(99; "Document Date"; Date) { Caption = 'Document Date'; DataClassification = CustomerContent; } field(100; "External Document No."; Code[35]) { Caption = 'External Document No.'; DataClassification = CustomerContent; } field(171; "Sell-to Phone No."; Text[30]) { Caption = 'Sell-to Phone No.'; DataClassification = CustomerContent; ExtendedDatatype = PhoneNo; } field(172; "Sell-to E-Mail"; Text[80]) { Caption = 'Email'; DataClassification = CustomerContent; ExtendedDatatype = EMail; } field(210; "Ship-to Phone No."; Text[30]) { Caption = 'Ship-to Phone No.'; ExtendedDatatype = PhoneNo; } field(1304; "Cust. Ledger Entry No."; Integer) { Caption = 'Cust. Ledger Entry No.'; DataClassification = CustomerContent; TableRelation = "Cust. Ledger Entry"."Entry No."; } field(1305; "Invoice Discount Amount"; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Invoice Discount Amount'; DataClassification = CustomerContent; } field(5052; "Sell-To Contact No."; Code[20]) { Caption = 'Sell-To Contact No.'; DataClassification = CustomerContent; TableRelation = Contact; } field(5750; "Shipping Advice"; Option) { AccessByPermission = TableData "Sales Shipment Header" = R; Caption = 'Shipping Advice'; DataClassification = CustomerContent; OptionCaption = 'Partial,Complete'; OptionMembers = Partial,Complete; } field(5752; "Completely Shipped"; Boolean) { Caption = 'Completely Shipped'; DataClassification = CustomerContent; } field(5790; "Requested Delivery Date"; Date) { Caption = 'Requested Delivery Date'; DataClassification = CustomerContent; } field(8000; Id; Guid) { Caption = 'Id'; DataClassification = SystemMetadata; } field(9600; "Total Tax Amount"; Decimal) { AutoFormatExpression = Rec."Currency Code"; AutoFormatType = 1; Caption = 'Total Tax Amount'; DataClassification = CustomerContent; } field(9601; Status; Enum "Sales Order Entity Buffer Status") { Caption = 'Status'; DataClassification = CustomerContent; } field(9624; "Discount Applied Before Tax"; Boolean) { Caption = 'Discount Applied Before Tax'; DataClassification = CustomerContent; } field(9630; "Last Modified Date Time"; DateTime) { Caption = 'Last Modified Date Time'; DataClassification = SystemMetadata; Editable = false; } field(9631; "Customer Id"; Guid) { Caption = 'Customer Id'; DataClassification = SystemMetadata; TableRelation = Customer.SystemId; trigger OnValidate() begin UpdateSellToCustomerNo(); end; } field(9633; "Contact Graph Id"; Text[250]) { Caption = 'Contact Graph Id'; DataClassification = SystemMetadata; } field(9634; "Currency Id"; Guid) { Caption = 'Currency Id'; DataClassification = SystemMetadata; TableRelation = Currency.SystemId; trigger OnValidate() begin UpdateCurrencyCode(); end; } field(9635; "Payment Terms Id"; Guid) { Caption = 'Payment Terms Id'; DataClassification = SystemMetadata; TableRelation = "Payment Terms".SystemId; trigger OnValidate() begin UpdatePaymentTermsCode(); end; } field(9636; "Shipment Method Id"; Guid) { Caption = 'Shipment Method Id'; DataClassification = SystemMetadata; TableRelation = "Shipment Method".SystemId; trigger OnValidate() begin UpdateShipmentMethodCode(); end; } field(9638; "Bill-to Customer Id"; Guid) { Caption = 'Bill-to Customer Id'; DataClassification = SystemMetadata; TableRelation = Customer.SystemId; trigger OnValidate() begin UpdateBillToCustomerNo(); end; } } keys { key(Key1; "No.") { } key(Key2; Id) { Clustered = true; } key(Key3; "Cust. Ledger Entry No.") { } } fieldgroups { } trigger OnInsert() begin "Last Modified Date Time" := CurrentDateTime; UpdateReferencedRecordIds(); end; trigger OnModify() begin "Last Modified Date Time" := CurrentDateTime; UpdateReferencedRecordIds(); end; trigger OnRename() begin "Last Modified Date Time" := CurrentDateTime; UpdateReferencedRecordIds(); end; local procedure UpdateSellToCustomerId() var Customer: Record Customer; begin if "Sell-to Customer No." = '' then begin Clear("Customer Id"); exit; end; if not Customer.Get("Sell-to Customer No.") then exit; "Customer Id" := Customer.SystemId; end; local procedure UpdateBillToCustomerId() var Customer: Record Customer; begin if "Bill-to Customer No." = '' then begin Clear("Bill-to Customer Id"); exit; end; if not Customer.Get("Bill-to Customer No.") then exit; "Bill-to Customer Id" := Customer.SystemId; end; procedure UpdateCurrencyId() var Currency: Record Currency; begin if "Currency Code" = '' then begin Clear("Currency Id"); exit; end; if not Currency.Get("Currency Code") then exit; "Currency Id" := Currency.SystemId; end; procedure UpdatePaymentTermsId() var PaymentTerms: Record "Payment Terms"; begin if "Payment Terms Code" = '' then begin Clear("Payment Terms Id"); exit; end; if not PaymentTerms.Get("Payment Terms Code") then exit; "Payment Terms Id" := PaymentTerms.SystemId; end; procedure UpdateShipmentMethodId() var ShipmentMethod: Record "Shipment Method"; begin if "Shipment Method Code" = '' then begin Clear("Shipment Method Id"); exit; end; if not ShipmentMethod.Get("Shipment Method Code") then exit; "Shipment Method Id" := ShipmentMethod.SystemId; end; local procedure UpdateSellToCustomerNo() var Customer: Record Customer; begin if not IsNullGuid("Customer Id") then Customer.GetBySystemId("Customer Id"); Validate("Sell-to Customer No.", Customer."No."); end; local procedure UpdateBillToCustomerNo() var Customer: Record Customer; begin if not IsNullGuid("Bill-to Customer Id") then Customer.GetBySystemId("Bill-to Customer Id"); Validate("Bill-to Customer No.", Customer."No."); end; local procedure UpdateCurrencyCode() var Currency: Record Currency; begin if not IsNullGuid("Currency Id") then Currency.GetBySystemId("Currency Id"); Validate("Currency Code", Currency.Code); end; local procedure UpdatePaymentTermsCode() var PaymentTerms: Record "Payment Terms"; begin if not IsNullGuid("Payment Terms Id") then PaymentTerms.GetBySystemId("Payment Terms Id"); Validate("Payment Terms Code", PaymentTerms.Code); end; local procedure UpdateShipmentMethodCode() var ShipmentMethod: Record "Shipment Method"; begin if not IsNullGuid("Shipment Method Id") then ShipmentMethod.GetBySystemId("Shipment Method Id"); Validate("Shipment Method Code", ShipmentMethod.Code); end; procedure UpdateReferencedRecordIds() begin UpdateSellToCustomerId(); UpdateBillToCustomerId(); UpdateCurrencyId(); UpdatePaymentTermsId(); UpdateShipmentMethodId(); end;}