Table 5108 Sales Line Archive

Base Application, Microsoft.Sales.Archive

Source AL, 1,708 lines

src/Layers/W1/BaseApp/Sales/Archive/SalesLineArchive.Table.allines 43 to 58 of 1,708, Copyright (c) Microsoft Corporation. MIT

table 5108 "Sales Line Archive"{    Caption = 'Sales Line Archive';    PasteIsValid = false;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the type of the archived sales document, such as quote, order, invoice, or credit memo.        /// </summary>        field(1; "Document Type"; Enum "Sales Document Type")        {            Caption = 'Document Type';            ToolTip = 'Specifies the type of sales document.';        }

All 1,708 lines

Fields 165 in 29

1Document TypeEnum "Sales Document Type"17-29
2Sell-to Customer No.Code[20]17-29
3Document No.Code[20]17-29
4Line No.Integer17-29
5TypeEnum "Sales Line Type"17-29
6No.Code[20]17-29
7Location CodeCode[10]17-29
8Posting GroupCode[20]17-29
9Quantity Disc. CodeCode[20]17-29

All 176 fields in 17-29

Events 2 in 29

[IntegrationEvent] OnCopyTempLinesOnAfterSalesLineArchiveSetFilters(var SalesLineArchive: Record "Sales Line Archive"; SalesHeaderArchive: Record "Sales Header Archive")17-29
[IntegrationEvent] OnBeforeShowDeferrals(var SalesLineArchive: Record "Sales Line Archive"; var IsHandled: Boolean)new in 21

Public procedures 6 in 29

GetCaptionClass(FieldNumber: Integer): Text[80]17-29
ShowDimensions()17-29
ShowLineComments()17-29
ShowDeferrals()17-29
CopyTempLines(SalesHeaderArchive: Record "Sales Header Archive"; var TempSalesLine: Record "Sales Line" temporary)17-29
IsExtendedText(): Booleannew in 22changed in 23

Extended in Microsoft's apps by 3

tableextension 6408 "Serv. Sales Line Archive"Base Applicationnew in 25
tableextension 8068 "Sales Line Archive"Subscription Billingnew in 26
tableextension 30204 "Shpfy Sales Line Archive"Shopify Connectornew in 27

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Sales Line Archive"; var xRec: Record "Sales Line Archive"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 1 in 28

List17181920212223242526272829
Fields13465
Keys1
Procedures11
Events1
key(Key6; "Document No.", "Document Type", "Doc. No. Occurrence", "Version No.") { IncludedFields = Amount, "Amount Including VAT", "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)"; }17-29changed in 28
changed, was key(Key6; "Document No.", "Document Type", "Doc. No. Occurrence", "Version No.") { IncludedFields = Amount, "Amount Including VAT", "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)"; SumIndexFields = Amount, "Amount Including VAT", "Outstanding Amount", "Shipped Not Invoiced", "Outstanding Amount (LCY)", "Shipped Not Invoiced (LCY)"; }

All 23 changes in 17-29