Table 123 Purch. Inv. Line

Base Application, Microsoft.Purchases.History
List17181920212223242526272829
Fields118113212
Keys21
Procedures111
Events332

In 29 2 added

field(147; "Spend Request No."; Code[20])new in 29
added
field(148; "Spend Request Close"; Boolean)new in 29
added

In 28 1 added, 1 changed

field(2701; "Matched Order Lines"; Integer)new in 28
added
key(Key6; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }17-29changed in 22, 28
changed, was key(Key6; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }

In 27 5 added

field(2679; "Alloc. Purch. Line SystemId"; Guid)new in 27
added
field(12100; "No. of Fixed Asset Cards"; Integer)new in 27
added
IsProdOrder(): Booleannew in 27
added
[IntegrationEvent] OnIsProdOrder(var PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean)new in 27
added
[IntegrationEvent] OnAfterIsCancellationSupported(PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean)new in 27
added

In 26 6 added, 11 gone

field(1019; "Job Planning Line No."; Integer)new in 26
added
field(5401; "Prod. Order No."; Code[20])gone after 25
gone
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(8512; "Buy-from Vendor Name"; Text[100])new in 26
added
field(99000750; "Routing No."; Code[20])gone after 25
gone
field(99000751; "Operation No."; Code[10])gone after 25
gone
field(99000752; "Work Center No."; Code[20])gone after 25
gone
field(99000754; "Prod. Order Line No."; Integer)gone after 25
gone
field(99000759; "Routing Reference No."; Integer)gone after 25
gone
internal GetVATPct(): Decimalnew in 26
added
[IntegrationEvent] OnGetItemLedgEntryOnShouldExit(var PurchInvLine: Record "Purch. Inv. Line"; var ShouldExit: Boolean)new in 26
added
[IntegrationEvent] OnAfterGetVATPct(var PurchInvLine: Record "Purch. Inv. Line"; var VATPct: Decimal)new in 26
added
[IntegrationEvent] OnAfterCalcReceivedPurchNotReturned(var PurchInvLine: Record "Purch. Inv. Line"; var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)new in 26
added

In 23 1 added

field(2678; "Allocation Account No."; Code[20])new in 23
added

In 22 4 state changed, 4 added, 2 changed

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.
field(6200; "Non-Deductible VAT %"; Decimal)new in 22
added
field(6201; "Non-Deductible VAT Base"; Decimal)new in 22
added
field(6202; "Non-Deductible VAT Amount"; Decimal)new in 22
added
field(6203; "Non-Deductible VAT Diff."; Decimal)new in 22
added
key(Key3; Type, "No.", "Variant Code") { IncludedFields = "Quantity (Base)"; }17-29changed in 22
changed, was key(Key3; Type, "No.", "Variant Code") { IncludedFields = "Quantity (Base)"; }
key(Key6; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; }17-29changed in 22, 28
changed, was key(Key6; "Document No.", "Location Code") { IncludedFields = Amount, "Amount Including VAT", "Inv. Discount Amount"; SumIndexFields = Amount, "Amount Including VAT"; }

In 21 1 changed, 4 added

field(5601; "FA Posting Type"; Enum "Purchase FA Posting Type")17-29changed in 21
changed, was field(5601; "FA Posting Type"; Option)
SetSecurityFilterOnRespCenter()new in 21
added
[IntegrationEvent] OnAfterCalcQty(var PurchInvLine: Record "Purch. Inv. Line"; QtyBase: Decimal; var Result: Decimal)new in 21
added
[IntegrationEvent] OnBeforeShowDeferrals(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean)new in 21
added
[IntegrationEvent] OnBeforeSetSecurityFilterOnRespCenter(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean)new in 21
added

In 18 1 changed

field(1002; "Job Line Type"; Enum "Job Line Type")17-29changed in 18
changed, was field(1002; "Job Line Type"; Option)