Table 37 Sales Line

Base Application, Microsoft.Sales.Document

Source AL, 15,751 lines

src/Layers/W1/BaseApp/Sales/Document/SalesLine.Table.allines 69 to 84 of 15,751, Copyright (c) Microsoft Corporation. MIT

table 37 "Sales Line"{    Caption = 'Sales Line';    DrillDownPageID = "Sales Lines";    LookupPageID = "Sales Lines";    Permissions = TableData "Sales Line" = m;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the type of sales document such as quote, order, invoice, credit memo, blanket order, or return order.        /// </summary>        field(1; "Document Type"; Enum "Sales Document Type")        {            Caption = 'Document Type';

All 15,751 lines

Fields 193 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
10Shipment DateDate17-29

All 198 fields in 17-29

Events 418 in 29

[IntegrationEvent] OnAfterAssignFieldsForNo(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header")17-29
[IntegrationEvent] OnAfterApplyPrice(var SalesLine: Record "Sales Line"; var xSalesLine: Record "Sales Line"; CallFieldNo: Integer; CurrentFieldNo: Integer)17-29
[IntegrationEvent] OnAfterAssignHeaderValues(var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header")17-29
[IntegrationEvent] OnAfterAssignResourceUOM(var SalesLine: Record "Sales Line"; Resource: Record Resource; ResourceUOM: Record "Resource Unit of Measure")17-29
[IntegrationEvent] OnAfterAutoReserve(var SalesLine: Record "Sales Line")17-29
[IntegrationEvent] OnAfterCheckItemAvailable(var SalesLine: Record "Sales Line"; CalledByFieldNo: Integer; HideValidationDialog: Boolean)17-29
[IntegrationEvent] OnAfterCheckShipmentRelation(SalesLine: Record "Sales Line"; SalesShipmentLine: Record "Sales Shipment Line")17-29

All 515 events in 17-29

Public procedures 217 in 29

InitOutstanding()17-29
InitOutstandingAmount()17-29
InitQtyToShip()17-29
InitQtyToReceive()17-29
InitQtyToInvoice()17-29
MaxQtyToInvoice(): Decimal17-29

All 233 procedures in 17-29

Extended in Microsoft's apps by 3

tableextension 6235 "Sustainability Sales Line"Sustainabilitynew in 26
tableextension 8054 "Sales Line"Subscription Billingnew in 26
tableextension 30104 "Shpfy Sales Line"Shopify Connectornew in 20

Trigger events 10

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

Changes 4 in 29

List17181920212223242526272829
Fields2115361
Keys11021
Procedures14714851331112382
Events29725196572013151019102
FormatType(): Text[20]17-29
marked Pending, tag 29.0: Use FormatTypeAsText() instead.
FormatTypeAsText(): Text[30]new in 29
added
[IntegrationEvent] OnBeforeFormatType(SalesLine: Record "Sales Line"; var FormattedType: Text[20]; var IsHandled: Boolean)17-29
marked Pending, tag 29.0: Use OnBeforeFormatTypeAsText instead.
[IntegrationEvent] OnBeforeFormatTypeAsText(SalesLine: Record "Sales Line"; var FormattedType: Text[30]; var IsHandled: Boolean)new in 29
added

All 527 changes in 17-29