Table 113 Sales Invoice Line

Base Application, Microsoft.Sales.History
List17181920212223242526272829
Fields4161
Keys131
Procedures1112
Events32

In 27 1 added

field(2679; "Alloc. Sales Line SystemId"; Guid)new in 27
added

In 26 5 gone, 4 added, 2 changed

field(5705; "Cross-Reference No."; Code[20])gone after 25
gone
field(5706; "Unit of Measure (Cross Ref.)"; Code[10])gone after 25
gone
field(5707; "Cross-Reference Type"; Option)gone after 25
gone
field(5708; "Cross-Reference Type No."; Code[30])gone after 25
gone
field(5712; "Product Group Code"; Code[10])gone after 25
gone
field(7012; "Sell-to Customer Name"; Text[100])new in 26
added
key(Key9; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }17-29changed in 19, 26
changed, was key(Key9; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }
GetSalesShptLines(var TempSalesShipmentLine: Record "Sales Shipment Line" temporary)17-29changed in 26
changed, was GetSalesShptLines(var TempSalesShptLine: Record "Sales Shipment Line" temporary)
internal GetVATPct(): Decimalnew in 26
added
[IntegrationEvent] OnAfterGetVATPct(var SalesInvoiceLine: Record "Sales Invoice Line"; var VATPct: Decimal)new in 26
added
[IntegrationEvent] OnAfterCalcShippedSaleNotReturned(var SalesInvoiceLine: Record "Sales Invoice Line"; var ShippedQtyNotReturned: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)new in 26
added

In 23 4 added, 1 gone

field(2678; "Allocation Account No."; Code[20])new in 23
added
key(Key4; "Sell-to Customer No.", Type, "Document No.") { Enabled = false; }gone after 22
gone
key(Key10; Type, "No.") { IncludedFields = "Quantity (Base)"; }new in 23
added
key(Key11; "Job No.", "Job Task No.")new in 23
added
GetDateForCalculations(): Datenew in 23
added

In 22 4 state changed, 1 added

field(5705; "Cross-Reference No."; Code[20])gone after 25
Pending to Removed, tag 22.0: Cross-Reference replaced by Item Reference feature.
field(5706; "Unit of Measure (Cross Ref.)"; Code[10])gone after 25
Pending to Removed, tag 22.0: Cross-Reference replaced by Item Reference feature.
field(5707; "Cross-Reference Type"; Option)gone after 25
Pending to Removed, tag 22.0: Cross-Reference replaced by Item Reference feature.
field(5708; "Cross-Reference Type No."; Code[30])gone after 25
Pending to Removed, tag 22.0: Cross-Reference replaced by Item Reference feature.
GetInvoiceHeader(): Record "Sales Invoice Header"new in 22
added

In 21 4 added

SetSecurityFilterOnRespCenter()new in 21
added
[IntegrationEvent] OnAfterCalcQty(var SalesInvoiceLine: Record "Sales Invoice Line"; QtyBase: Decimal; var Result: Decimal)new in 21
added
[IntegrationEvent] OnBeforeShowDeferrals(SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean)new in 21
added
[IntegrationEvent] OnBeforeSetSecurityFilterOnRespCenter(var SalesInvoiceLine: Record "Sales Invoice Line"; var IsHandled: Boolean)new in 21
added

In 19 1 changed

key(Key9; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }17-29changed in 19, 26
changed, was key(Key9; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT"; }