Table 113 Sales Invoice Line

Base Application, Microsoft.Sales.History

Source AL, 1,553 lines

src/Layers/W1/BaseApp/Sales/History/SalesInvoiceLine.Table.allines 43 to 58 of 1,553, Copyright (c) Microsoft Corporation. MIT

table 113 "Sales Invoice Line"{    Caption = 'Sales Invoice Line';    DrillDownPageID = "Posted Sales Invoice Lines";    LookupPageID = "Posted Sales Invoice Lines";    Permissions = TableData "Item Ledger Entry" = r,                  TableData "Value Entry" = r;    DataClassification = CustomerContent;    fields    {        /// <summary>        /// Specifies the customer number who received the shipped items.        /// </summary>        field(2; "Sell-to Customer No."; Code[20])        {

All 1,553 lines

Fields 100 in 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
11DescriptionText[100]17-29

All 105 fields in 17-29

Events 9 in 29

[IntegrationEvent] OnAfterInitFromSalesLine(var SalesInvLine: Record "Sales Invoice Line"; SalesInvHeader: Record "Sales Invoice Header"; SalesLine: Record "Sales Line")17-29
[IntegrationEvent] OnBeforeGetItemLedgEntries(var SalesInvLine: Record "Sales Invoice Line"; var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean; var IsHandled: Boolean)17-29
[IntegrationEvent] OnBeforeCalcVATAmountLines(SalesInvLine: Record "Sales Invoice Line"; SalesInvHeader: Record "Sales Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary; var IsHandled: Boolean)17-29
[IntegrationEvent] OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean)17-29
[IntegrationEvent] OnAfterCalcQty(var SalesInvoiceLine: Record "Sales Invoice Line"; QtyBase: Decimal; var Result: Decimal)new in 21
[IntegrationEvent] OnBeforeShowDeferrals(SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean)new in 21
[IntegrationEvent] OnBeforeSetSecurityFilterOnRespCenter(var SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean)new in 21

All 9 events

Public procedures 25 in 29

GetCurrencyCode(): Code[10]17-29
ShowDimensions()17-29
ShowItemTrackingLines()17-29
CalcVATAmountLines(SalesInvHeader: Record "Sales Invoice Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)17-29
GetLineAmountExclVAT(): Decimal17-29
GetLineAmountInclVAT(): Decimal17-29

All 26 procedures in 17-29

Extended in Microsoft's apps by 3

tableextension 6239 "Sust. Sales Invoice Line"Sustainabilitynew in 26
tableextension 8056 "Sales Invoice Line"Subscription Billingnew in 26
tableextension 30103 "Shpfy Sales Invoice Line"Shopify Connectornew in 20

Trigger events 10

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

Changes 1 in 27

List17181920212223242526272829
Fields4161
Keys131
Procedures1112
Events32
field(2679; "Alloc. Sales Line SystemId"; Guid)new in 27
added

All 27 changes in 17-29