Table 123 "Purch. Inv. Line"

Base Application · Microsoft.Purchases.History · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Purch. Inv. Line
DataClassification	CustomerContent
Permissions	TableData “Item Ledger Entry” = r, TableData “Value Entry” = r

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
2	Buy-from Vendor No. Δ BC28	Code[20]	Specifies the name of the vendor who delivered the items.	TableRelation Table 23 “Vendor”; not editable
3	Document No. Δ BC28	Code[20]	Specifies the document number.	TableRelation Table 122 “Purch. Inv. Header” (Purch. Inv. Header)
4	Line No.	Integer	—
5	Type Δ BC28	Enum “Purchase Line Type”	Specifies the line type.	enum Enum 39 “Purchase Line Type”
6	No. Δ BC28	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.	TableRelation Table 15 “G/L Account”, Table 156 “Resource”, Table 27 “Item” (if (Type = const(“G/L Account”)) “G/L Account” else if (Type = const(Item)) Item else if (Type = const(“Fixed Asset”)) “Fixed Asset” else if (Type = const(“Charge (Item)”)) “Item Charge” else if (Type = const(Resource)) Resource)
7	Location Code Δ BC28	Code[10]	Specifies the code for the location where the invoice line is registered.	TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
8	Posting Group	Code[20]	—	TableRelation Table 5606 “FA Posting Group”, Table 94 “Inventory Posting Group” (if (Type = const(Item)) “Inventory Posting Group” else if (Type = const(“Fixed Asset”)) “FA Posting Group”); not editable
10	Expected Receipt Date Δ BC28	Date	Specifies the date when the items were expected.
11	Description Δ BC28	Text[100]	Specifies either the name of, or a description of, the item or general ledger account.
12	Description 2 Δ BC28	Text[50]	Specifies information in addition to the description.
13	Unit of Measure Δ BC28	Text[50]	Specifies the name of the item or resource’s unit of measure, such as piece or hour.
15	Quantity Δ BC28	Decimal	Specifies the quantity posted from the line.
22	Direct Unit Cost Δ BC28	Decimal	Specifies the cost of one unit of the selected item or resource.
23	Unit Cost (LCY) Δ BC28	Decimal	Specifies the cost, in LCY, of one unit of the item or resource on the line. via Page 529 “Posted Purchase Invoice Lines”
25	VAT % Δ BC28	Decimal	Specifies the VAT %.	not editable
27	Line Discount % Δ BC28	Decimal	Specifies the discount percentage that is granted for the item on the line.
28	Line Discount Amount Δ BC28	Decimal	Specifies the discount amount that is granted for the item on the line.
29	Amount Δ BC28	Decimal	Specifies the line’s net amount.
30	Amount Including VAT Δ BC28	Decimal	Specifies the net amount, including VAT, for this line.
31	Unit Price (LCY) Δ BC28	Decimal	Specifies the price, in LCY, of one unit of the item or resource. You can enter a price manually or have it entered according to the Price/Profit Calculation field on the related card. via Page 529 “Posted Purchase Invoice Lines”
32	Allow Invoice Disc. Δ BC28	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
34	Gross Weight Δ BC28	Decimal	Specifies the gross weight of one unit of the item. In the purchase statistics window, the gross weight on the line is included in the total gross weight of all the lines for the particular purchase document.
35	Net Weight Δ BC28	Decimal	Specifies the net weight of one unit of the item. In the purchase statistics window, the net weight on the line is included in the total net weight of all the lines for the particular purchase document.
36	Units per Parcel Δ BC28	Decimal	Specifies the number of units per parcel of the item. In the purchase statistics window, the number of units per parcel on the line helps to determine the total number of units for all the lines for the particular purchase document.
37	Unit Volume Δ BC28	Decimal	Specifies the volume of one unit of the item. In the purchase statistics window, the volume of one unit of the item on the line is included in the total volume of all the lines for the particular purchase document.
38	Appl.-to Item Entry Δ BC28	Integer	Specifies the number of the item ledger entry that the document or journal line is applied to.
40	Shortcut Dimension 1 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1)))
41	Shortcut Dimension 2 Code Δ BC28	Code[20]	Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window.	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2)))
45	Job No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project.	TableRelation Table 167 “Job”
54	Indirect Cost % Δ BC28	Decimal	Specifies the percentage of the item’s last purchase cost that includes indirect costs, such as freight that is associated with the purchase of the item.
63	Receipt No.	Code[20]	—	not editable
64	Receipt Line No.	Integer	—	not editable
65	Order No. Δ BC28	Code[20]	Specifies the order number this line is associated with.
66	Order Line No.	Integer	—
68	Pay-to Vendor No.	Code[20]	—	TableRelation Table 23 “Vendor”; not editable
69	Inv. Discount Amount Δ BC28	Decimal	Specifies the total calculated invoice discount amount for the line.
70	Vendor Item No.	Text[50]	—
74	Gen. Bus. Posting Group Δ BC28	Code[20]	Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup.	TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
75	Gen. Prod. Posting Group Δ BC28	Code[20]	Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup.	TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
77	VAT Calculation Type	Enum “Tax Calculation Type”	—	enum Enum 254 “Tax Calculation Type”
78	Transaction Type	Code[10]	—	TableRelation Table 258 “Transaction Type” (Transaction Type)
79	Transport Method	Code[10]	—	TableRelation Table 259 “Transport Method” (Transport Method)
80	Attached to Line No.	Integer	—	TableRelation Table 123 “Purch. Inv. Line” (“Purch. Inv. Line”.“Line No.” where(“Document No.” = field(“Document No.”)))
81	Entry Point	Code[10]	—	TableRelation Table 282 “Entry/Exit Point” (Entry/Exit Point)
82	Area	Code[10]	—	TableRelation Table 284 “Area”
83	Transaction Specification	Code[10]	—	TableRelation Table 285 “Transaction Specification” (Transaction Specification)
85	Tax Area Code Δ BC28	Code[20]	Specifies the tax area that is used to calculate and post sales tax.	TableRelation Table 318 “Tax Area” (Tax Area)
86	Tax Liable Δ BC28	Boolean	Specifies if the customer or vendor is liable for sales tax.
87	Tax Group Code Δ BC28	Code[20]	Specifies the tax group that is used to calculate and post sales tax.	TableRelation Table 321 “Tax Group” (Tax Group)
88	Use Tax Δ BC28	Boolean	Specifies that the purchase is subject to use tax. Use tax is a sales tax that is paid on items that are purchased by a company and are used by that company instead of being sold to a customer.
89	VAT Bus. Posting Group Δ BC28	Code[20]	Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
90	VAT Prod. Posting Group Δ BC28	Code[20]	Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup.	TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
97	Blanket Order No. Δ BC28	Code[20]	Specifies the number of the blanket order that the record originates from.	TableRelation Table 38 “Purchase Header” (“Purchase Header”.“No.” where(“Document Type” = const(“Blanket Order”)))
98	Blanket Order Line No. Δ BC28	Integer	Specifies the number of the blanket order line that the record originates from.	TableRelation Table 39 “Purchase Line” (“Purchase Line”.“Line No.” where(“Document Type” = const(“Blanket Order”), “Document No.” = field(“Blanket Order No.”)))
99	VAT Base Amount	Decimal	—	not editable
100	Unit Cost	Decimal	—	not editable
101	System-Created Entry	Boolean	—	not editable
103	Line Amount Δ BC28	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
104	VAT Difference	Decimal	—
106	VAT Identifier	Code[20]	—	not editable
107	IC Partner Ref. Type	Enum “IC Partner Reference Type”	—	enum Enum 107 “IC Partner Reference Type”
108	IC Partner Reference	Code[20]	—
123	Prepayment Line	Boolean	—	not editable
130	IC Partner Code Δ BC28	Code[20]	Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction.	TableRelation Table 413 “IC Partner” (IC Partner)
131	Posting Date	Date	Specifies the posting date of the historical purchase invoice. via Page 6186 “E-Doc. Historical Lines List”
138	IC Cross-Reference No.	Code[50]	IC Item Reference No. caption
145	Pmt. Discount Amount	Decimal	—
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable
1001	Job Task No. Δ BC24 Δ BC28	Code[20]	Specifies the number of the related project task.	TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”)))
1002	Job Line Type Δ BC24	Enum “Job Line Type”	Project Line Type caption	enum Enum 1002 “Job Line Type”
1003	Job Unit Price Δ BC24 Δ BC28	Decimal	Project Unit Price caption
1004	Job Total Price Δ BC24 Δ BC28	Decimal	Project Total Price caption
1005	Job Line Amount Δ BC24	Decimal	Project Line Amount caption
1006	Job Line Discount Amount Δ BC24	Decimal	Project Line Discount Amount caption
1007	Job Line Discount % Δ BC24 Δ BC28	Decimal	Project Line Discount % caption
1008	Job Unit Price (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Project Unit Price (LCY) caption
1009	Job Total Price (LCY) Δ BC24 Δ BC27 Δ BC28	Decimal	Project Total Price (LCY) caption
1010	Job Line Amount (LCY) Δ BC24 Δ BC28	Decimal	Project Line Amount (LCY) caption
1011	Job Line Disc. Amount (LCY) Δ BC24 Δ BC28	Decimal	Project Line Disc. Amount (LCY) caption
1012	Job Currency Factor Δ BC24 Δ BC28	Decimal	Project Currency Factor caption
1013	Job Currency Code Δ BC24	Code[20]	Project Currency Code caption
1019	Job Planning Line No. + BC26	Integer	Project Planning Line No. caption
1700	Deferral Code Δ BC28	Code[10]	Specifies the deferral template that governs how expenses paid with this purchase document are deferred to the different accounting periods when the expenses were incurred.	TableRelation Table 1700 “Deferral Template” (“Deferral Template”.“Deferral Code”)
2678	Allocation Account No.	Code[20]	Specifies the allocation account number used for distributing the cost. via Page 6186 “E-Doc. Historical Lines List”
2679	Alloc. Purch. Line SystemId + BC27	Guid	Allocation Purchase Line SystemId caption	DataClassification SystemMetadata
2701	Matched Order Lines + BC28	Integer	Specifies the number of purchase order lines to which this posted purchase invoice line is matched. via Page 139 “Posted Purch. Invoice Subform”	FlowField: count(“Posted Matched Order Line” where(“Document Line SystemId” = field(SystemId), “Matched Rcpt./Shpt. Line SysId” = const(‘00000000-0000-0000-0000-000000000000’))); not editable
5402	Variant Code Δ BC28	Code[10]	Specifies the variant of the item on the line.	TableRelation Table 5401 “Item Variant” (if (Type = const(Item)) “Item Variant”.Code where(“Item No.” = field(“No.”)))
5403	Bin Code Δ BC28	Code[20]	Specifies the bin where the items are picked or put away.	TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(“Location Code”), “Item Filter” = field(“No.”), “Variant Filter” = field(“Variant Code”)))
5404	Qty. per Unit of Measure Δ BC28	Decimal	—	not editable
5407	Unit of Measure Code Δ BC28	Code[10]	Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the item or resource card is inserted.	TableRelation Table 204 “Unit of Measure”, Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)) else “Unit of Measure”)
5415	Quantity (Base) Δ BC28	Decimal	—
5600	FA Posting Date	Date	—
5601	FA Posting Type Δ BC28	Enum “Purchase FA Posting Type”	Specifies the posting type, if Account Type field contains Fixed Asset.	enum Enum 5607 “Purchase FA Posting Type”
5602	Depreciation Book Code Δ BC28	Code[10]	Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line.	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5603	Salvage Value Δ BC28	Decimal	—
5605	Depr. until FA Posting Date Δ BC28	Boolean	Specifies if depreciation was calculated until the FA posting date of the line.
5606	Depr. Acquisition Cost Δ BC28	Boolean	Specifies if, when this line was posted, the additional acquisition cost posted on the line was depreciated in proportion to the amount by which the fixed asset had already been depreciated.
5609	Maintenance Code	Code[10]	—	TableRelation Table 5626 “Maintenance”
5610	Insurance No. Δ BC28	Code[20]	Specifies the insurance number on the purchase invoice line.	TableRelation Table 5628 “Insurance”
5611	Budgeted FA No. Δ BC28	Code[20]	Specifies the number of a fixed asset with the Budgeted Asset check box selected. When you post the journal or document line, an additional entry is created for the budgeted fixed asset where the amount has the opposite sign.	TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
5612	Duplicate in Depreciation Book	Code[10]	—	TableRelation Table 5611 “Depreciation Book” (Depreciation Book)
5613	Use Duplication List	Boolean	—
5700	Responsibility Center	Code[10]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
5709	Item Category Code	Code[20]	—	TableRelation Table 5722 “Item Category” (if (Type = const(Item)) “Item Category”)
5710	Nonstock Δ BC28	Boolean	Specifies that this item is a catalog item.
5711	Purchasing Code	Code[10]	—	TableRelation Table 5721 “Purchasing”
5725	Item Reference No. Δ BC28	Code[50]	Specifies the referenced item number.
5726	Item Reference Unit of Measure	Code[10]	Unit of Measure (Item Ref.) caption	TableRelation Table 5404 “Item Unit of Measure” (if (Type = const(Item)) “Item Unit of Measure”.Code where(“Item No.” = field(“No.”)))
5727	Item Reference Type	Enum “Item Reference Type”	—	enum Enum 5726 “Item Reference Type”
5728	Item Reference Type No.	Code[30]	—
6200	Non-Deductible VAT % Δ BC28	Decimal	—
6201	Non-Deductible VAT Base Δ BC28	Decimal	Specifies the amount of VAT that is not deducted due to the type of goods or services purchased.
6202	Non-Deductible VAT Amount Δ BC28	Decimal	Specifies the amount of the transaction for which VAT is not applied, due to the type of goods or services purchased.
6203	Non-Deductible VAT Diff. Δ BC28	Decimal	Non-Deductible VAT Difference caption	not editable
6608	Return Reason Code Δ BC28	Code[10]	Specifies the code explaining why the item was returned.	TableRelation Table 6635 “Return Reason” (Return Reason)
7000	Price Calculation Method	Enum “Price Calculation Method”	—	enum Enum 7000 “Price Calculation Method”
8512	Buy-from Vendor Name + BC26 Δ BC28	Text[100]	Specifies the name of the vendor who delivered the items.	FlowField: lookup(Vendor.Name where(“No.” = field(“Buy-from Vendor No.”))); not editable
12100	No. of Fixed Asset Cards + BC27	Integer	Specifies the number of fixed assets that is being purchased.
99000755	Overhead Rate Δ BC28	Decimal	—
147	Spend Request No. + BC29	Code[20]	Specifies the spend request that this purchase document relates to.	TableRelation Table 6840 “Spend Request” (Spend Request)
148	Spend Request Close + BC29	Boolean	Specifies that the spend request will be closed when the purchase document is posted.

Keys

Key1: Document No., Line No. (clustered)
Key2: Blanket Order No., Blanket Order Line No.
Key3: Type, No., Variant Code
Key4: Buy-from Vendor No.
Key5: Order No., Order Line No., Posting Date
Key6: Document No., Location Code

Events published

OnAfterCalcQty(var PurchInvLine: Record "Purch. Inv. Line"; QtyBase: Decimal; var Result: Decimal) (integration)
OnAfterInitFromPurchLine(PurchInvHeader: Record "Purch. Inv. Header"; PurchLine: Record "Purchase Line"; var PurchInvLine: Record "Purch. Inv. Line") (integration)
- subscribers: Codeunit 8066 “Purchase Documents” PurchInvLineCopyContractNoOnAfterInitFromPurchLine
OnBeforeShowDeferrals(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean) (integration)
OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean) (integration)
OnBeforeSetSecurityFilterOnRespCenter(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean) (integration)
OnGetItemLedgEntryOnShouldExit(var PurchInvLine: Record "Purch. Inv. Line"; var ShouldExit: Boolean) + BC26 (integration)
- subscribers: Codeunit 99000789 “Mfg. Purchase Document Mgt.” OnGetItemLedgEntryOnShouldExit
OnAfterGetVATPct(var PurchInvLine: Record "Purch. Inv. Line"; var VATPct: Decimal) + BC26 (integration)
OnAfterCalcReceivedPurchNotReturned(var PurchInvLine: Record "Purch. Inv. Line"; var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean) + BC26 (integration)
OnIsProdOrder(var PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean) + BC27 (integration)
- subscribers: Codeunit 99000789 “Mfg. Purchase Document Mgt.” PurchInvLineOnIsProdOrder
OnAfterIsCancellationSupported(PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean) + BC27 (integration)

Trigger event subscribers

OnAfterDeleteEvent: Codeunit 1173 “Document Attachment Mgmt” DeleteAttachedDocumentsOnAfterDeletePurchInvLine, Codeunit 8059 “Sub. Contracts General Mgt.” PurchaseInvoiceLineDeleteArchivedBillingLines

Procedures

GetCurrencyCode(): Code[10]
ShowDimensions()
ShowItemTrackingLines()
CalcVATAmountLines(PurchInvHeader: Record "Purch. Inv. Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)
GetCaptionClass(FieldNumber: Integer): Text[80]
RowID1(): Text[250]
GetPurchRcptLines(var TempPurchRcptLine: Record "Purch. Rcpt. Line" temporary)
CalcReceivedPurchNotReturned(var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)
GetItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean)
FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")
ShowItemReceiptLines()
ShowLineComments()
ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])
InitFromPurchLine(PurchInvHeader: Record "Purch. Inv. Header"; PurchLine: Record "Purchase Line")
ShowDeferrals()
GetDocumentType(): Integer
HasTypeToFillMandatoryFields(): Boolean
FormatType(): Text
IsCancellationSupported(): Boolean
SetSecurityFilterOnRespCenter()
GetVATPct(): Decimal + BC26 (internal)
IsProdOrder(): Boolean + BC27

Plus 2 local procedures.

Triggers

OnDelete

Relations

drill-down page Page 529 “Posted Purchase Invoice Lines”
lookup page Page 529 “Posted Purchase Invoice Lines”
Job Task No.: TableRelation Table 1001 “Job Task”
Document No.: TableRelation Table 122 “Purch. Inv. Header”
Attached to Line No.: TableRelation Table 123 “Purch. Inv. Line”
Location Code: TableRelation Table 14 “Location”
No.: TableRelation Table 15 “G/L Account” (conditional)
No.: TableRelation Table 156 “Resource” (conditional)
Job No.: TableRelation Table 167 “Job”
Deferral Code: TableRelation Table 1700 “Deferral Template”
Unit of Measure Code: TableRelation Table 204 “Unit of Measure” (conditional)
Buy-from Vendor Name: CalcFormula Table 23 “Vendor”
Buy-from Vendor No.: TableRelation Table 23 “Vendor”
Pay-to Vendor No.: TableRelation Table 23 “Vendor”
Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
Transaction Type: TableRelation Table 258 “Transaction Type”
Transport Method: TableRelation Table 259 “Transport Method”
No.: TableRelation Table 27 “Item” (conditional)
Entry Point: TableRelation Table 282 “Entry/Exit Point”
Area: TableRelation Table 284 “Area”
Transaction Specification: TableRelation Table 285 “Transaction Specification”
Tax Area Code: TableRelation Table 318 “Tax Area”
Tax Group Code: TableRelation Table 321 “Tax Group”
VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Blanket Order No.: TableRelation Table 38 “Purchase Header”
Blanket Order Line No.: TableRelation Table 39 “Purchase Line”
IC Partner Code: TableRelation Table 413 “IC Partner”
Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Variant Code: TableRelation Table 5401 “Item Variant”
Item Reference Unit of Measure: TableRelation Table 5404 “Item Unit of Measure”
Unit of Measure Code: TableRelation Table 5404 “Item Unit of Measure” (conditional)
Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
No.: TableRelation Table 5600 “Fixed Asset” (conditional)
Posting Group: TableRelation Table 5606 “FA Posting Group” (conditional)
Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
Maintenance Code: TableRelation Table 5626 “Maintenance”
Insurance No.: TableRelation Table 5628 “Insurance”
Responsibility Center: TableRelation Table 5714 “Responsibility Center”
Purchasing Code: TableRelation Table 5721 “Purchasing”
Item Category Code: TableRelation Table 5722 “Item Category”
No.: TableRelation Table 5800 “Item Charge” (conditional)
Matched Order Lines: CalcFormula Table 5819 “Posted Matched Order Line”
Return Reason Code: TableRelation Table 6635 “Return Reason”
Spend Request No.: TableRelation Table 6840 “Spend Request”
Bin Code: TableRelation Table 7354 “Bin”
Posting Group: TableRelation Table 94 “Inventory Posting Group” (conditional)

Referenced by

6 fields in 4 objects relate to this table (TableRelation or CalcFormula).

Table 122 “Purch. Inv. Header”: Amount, Amount Including VAT, Invoice Discount Amount
Table 123 “Purch. Inv. Line”: Attached to Line No.
Table 6140 “E-Doc. Purchase Line History”: Purch. Inv. Line SystemId
Table extension 6217 “Sust. Purch. Inv. Header”: Sustainability Lines Exist

Pages and codeunits on this table

Page 139 “Posted Purch. Invoice Subform” (source table)
Page 529 “Posted Purchase Invoice Lines” (source table)
Page 5857 “Get Post.Doc - P.InvLn Subform” (source table)
Page 6186 “E-Doc. Historical Lines List” (source table)

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 408 “DimensionManagement” (2 calls: ShowDimensions → ShowDimensionSet, ShowShortcutDimCode → GetShortcutDimensions)
Codeunit 1720 “Deferral Utilities” (1 call: ShowDeferrals → OpenLineScheduleView)
Codeunit 5402 “Unit of Measure Management” (1 call: CalcQty → QtyRndPrecision)
Codeunit 5700 “User Setup Management” (1 call: SetSecurityFilterOnRespCenter → GetPurchasesFilter)
Codeunit 5826 “Matched Order Line Mgmt.” (1 call: OnDelete → DeleteMatchedLinesFromPostedPurchaseInvoice)
Codeunit 6500 “Item Tracking Management” (1 call: RowID1 → ComposeRowID)
Codeunit 6503 “Item Tracking Doc. Management” (1 call: ShowItemTrackingLines → ShowItemTrackingForInvoiceLine)

Recent changes

2026-08-13 #9947 Allow long localized sales and purchase line type captions (main, BC30, fix)
2026-07-31 #8959 Deliverable 638799: Spend Requests in Base App (main, BC30, feature)

Countries that replace it

AU, BE, CA, ES, FI, GB, IT, MX, NO, NZ, RU, SE, US

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Purch. Inv. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.