Table "Purch. Inv. Line"

ID 123

Namespace: Microsoft.Purchases.History

Properties

Name	Value
Caption	Purch. Inv. Line
DrillDownPageID	Page Microsoft.Purchases.History."Posted Purchase Invoice Lines"
LookupPageID	Page Microsoft.Purchases.History."Posted Purchase Invoice Lines"
Permissions	TableData "Item Ledger Entry" = r, TableData "Value Entry" = r
DataClassification	CustomerContent

Fields

Name	Type	Description
"Buy-from Vendor No."	Code[20]	Specifies the name of the vendor who delivered the items.
"Document No."	Code[20]	Specifies the document number.
"Line No."	Integer
Type	Enum Microsoft.Purchases.Document."Purchase Line Type"	Specifies the line type.
"No."	Code[20]	Specifies the number of the involved entry or record, according to the specified number series.
"Location Code"	Code[10]	Specifies the code for the location where the invoice line is registered.
"Posting Group"	Code[20]
"Expected Receipt Date"	Date	Specifies the date when the items were expected.
Description	Text[100]	Specifies either the name of, or a description of, the item or general ledger account.
"Description 2"	Text[50]	Specifies information in addition to the description.
"Unit of Measure"	Text[50]	Specifies the name of the item or resource's unit of measure, such as piece or hour.
Quantity	Decimal	Specifies the quantity posted from the line.
"Direct Unit Cost"	Decimal	Specifies the cost of one unit of the selected item or resource.
"Unit Cost (LCY)"	Decimal
"VAT %"	Decimal	Specifies the VAT %.
"Line Discount %"	Decimal	Specifies the discount percentage that is granted for the item on the line.
"Line Discount Amount"	Decimal	Specifies the discount amount that is granted for the item on the line.
Amount	Decimal	Specifies the line's net amount.
"Amount Including VAT"	Decimal	Specifies the net amount, including VAT, for this line.
"Unit Price (LCY)"	Decimal
"Allow Invoice Disc."	Boolean	Specifies if the invoice line is included when the invoice discount is calculated.
"Gross Weight"	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.
"Net Weight"	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.
"Units per Parcel"	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.
"Unit Volume"	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.
"Appl.-to Item Entry"	Integer	Specifies the number of the item ledger entry that the document or journal line is applied to.
"Shortcut Dimension 1 Code"	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.
"Shortcut Dimension 2 Code"	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.
"Job No."	Code[20]	Specifies the number of the related project.
"Indirect Cost %"	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.
"Receipt No."	Code[20]
"Receipt Line No."	Integer
"Order No."	Code[20]	Specifies the order number this line is associated with.
"Order Line No."	Integer
"Pay-to Vendor No."	Code[20]
"Inv. Discount Amount"	Decimal	Specifies the total calculated invoice discount amount for the line.
"Vendor Item No."	Text[50]
"Gen. Bus. Posting Group"	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.
"Gen. Prod. Posting Group"	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.
"VAT Calculation Type"	Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"Transaction Type"	Code[10]
"Transport Method"	Code[10]
"Attached to Line No."	Integer
"Entry Point"	Code[10]
"Area"	Code[10]
"Transaction Specification"	Code[10]
"Tax Area Code"	Code[20]	Specifies the tax area that is used to calculate and post sales tax.
"Tax Liable"	Boolean	Specifies if the customer or vendor is liable for sales tax.
"Tax Group Code"	Code[20]	Specifies the tax group that is used to calculate and post sales tax.
"Use Tax"	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.
"VAT Bus. Posting Group"	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.
"VAT Prod. Posting Group"	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.
"Blanket Order No."	Code[20]	Specifies the number of the blanket order that the record originates from.
"Blanket Order Line No."	Integer	Specifies the number of the blanket order line that the record originates from.
"VAT Base Amount"	Decimal
"Unit Cost"	Decimal
"System-Created Entry"	Boolean
"Line Amount"	Decimal	Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line.
"VAT Difference"	Decimal
"VAT Identifier"	Code[20]
"IC Partner Ref. Type"	Enum Microsoft.Intercompany.Partner."IC Partner Reference Type"
"IC Partner Reference"	Code[20]
"Prepayment Line"	Boolean
"IC Partner Code"	Code[20]	Specifies the code of the intercompany partner that the transaction is related to if the entry was created from an intercompany transaction.
"Posting Date"	Date
"IC Cross-Reference No."	Code[50]
"Pmt. Discount Amount"	Decimal
"Dimension Set ID"	Integer
"Job Task No."	Code[20]	Specifies the number of the related project task.
"Job Line Type"	Enum Microsoft.Projects.Project.Job."Job Line Type"
"Job Unit Price"	Decimal
"Job Total Price"	Decimal
"Job Line Amount"	Decimal
"Job Line Discount Amount"	Decimal
"Job Line Discount %"	Decimal
"Job Unit Price (LCY)"	Decimal
"Job Total Price (LCY)"	Decimal
"Job Line Amount (LCY)"	Decimal
"Job Line Disc. Amount (LCY)"	Decimal
"Job Currency Factor"	Decimal
"Job Currency Code"	Code[20]
"Job Planning Line No."	Integer
"Deferral Code"	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.
"Allocation Account No."	Code[20]
"Alloc. Purch. Line SystemId"	Guid
"Matched Order Lines"	Integer
"Variant Code"	Code[10]	Specifies the variant of the item on the line.
"Bin Code"	Code[20]	Specifies the bin where the items are picked or put away.
"Qty. per Unit of Measure"	Decimal
"Unit of Measure Code"	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.
"Quantity (Base)"	Decimal
"FA Posting Date"	Date
"FA Posting Type"	Enum Microsoft.FixedAssets.Posting."Purchase FA Posting Type"	Specifies the posting type, if Account Type field contains Fixed Asset.
"Depreciation Book Code"	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.
"Salvage Value"	Decimal
"Depr. until FA Posting Date"	Boolean	Specifies if depreciation was calculated until the FA posting date of the line.
"Depr. Acquisition Cost"	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.
"Maintenance Code"	Code[10]
"Insurance No."	Code[20]	Specifies the insurance number on the purchase invoice line.
"Budgeted FA No."	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.
"Duplicate in Depreciation Book"	Code[10]
"Use Duplication List"	Boolean
"Responsibility Center"	Code[10]
"Item Category Code"	Code[20]
Nonstock	Boolean	Specifies that this item is a catalog item.
"Purchasing Code"	Code[10]
"Item Reference No."	Code[50]	Specifies the referenced item number.
"Item Reference Unit of Measure"	Code[10]
"Item Reference Type"	Enum Microsoft.Inventory.Item.Catalog."Item Reference Type"
"Item Reference Type No."	Code[30]
"Non-Deductible VAT %"	Decimal
"Non-Deductible VAT Base"	Decimal	Specifies the amount of VAT that is not deducted due to the type of goods or services purchased.
"Non-Deductible VAT Amount"	Decimal	Specifies the amount of the transaction for which VAT is not applied, due to the type of goods or services purchased.
"Non-Deductible VAT Diff."	Decimal
"Return Reason Code"	Code[10]	Specifies the code explaining why the item was returned.
"Price Calculation Method"	Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"Buy-from Vendor Name"	Text[100]	Specifies the name of the vendor who delivered the items.
"No. of Fixed Asset Cards"	Integer	Specifies the number of fixed assets that is being purchased.
"Overhead Rate"	Decimal
"Spend Request No."	Code[20]	Specifies the spend request that this purchase document relates to.
"Spend Request Close"	Boolean	Specifies that the spend request will be closed when the purchase document is posted.
SystemId	Guid
SystemCreatedAt	DateTime
SystemCreatedBy	Guid
SystemModifiedAt	DateTime
SystemModifiedBy	Guid
SystemCreatedByUserName	Text[50]
SystemCreatedByFullName	Text[80]
SystemModifiedByUserName	Text[50]
SystemModifiedByFullName	Text[80]
SystemRowVersion	BigInteger

Methods

GetCurrencyCode

procedure GetCurrencyCode(): Code[10]

Returns

Type	Description
Code[10]

ShowDimensions

procedure ShowDimensions()

ShowItemTrackingLines

procedure ShowItemTrackingLines()

CalcVATAmountLines

procedure CalcVATAmountLines(PurchInvHeader: Record "Purch. Inv. Header"; var TempVATAmountLine: Record "VAT Amount Line" temporary)

Parameters

Name	Type	Description
PurchInvHeader	Table Microsoft.Purchases.History."Purch. Inv. Header"
TempVATAmountLine	Table Microsoft.Finance.VAT.Calculation."VAT Amount Line"

GetCaptionClass

procedure GetCaptionClass(FieldNumber: Integer): Text[80]

Parameters

Name	Type	Description
FieldNumber	Integer

Returns

Type	Description
Text[80]

RowID1

procedure RowID1(): Text[250]

Returns

Type	Description
Text[250]

GetPurchRcptLines

procedure GetPurchRcptLines(var TempPurchRcptLine: Record "Purch. Rcpt. Line" temporary)

Parameters

Name	Type	Description
TempPurchRcptLine	Table Microsoft.Purchases.History."Purch. Rcpt. Line"

CalcReceivedPurchNotReturned

procedure CalcReceivedPurchNotReturned(var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)

Parameters

Name	Type	Description
RemainingQty	Decimal
RevUnitCostLCY	Decimal
ExactCostReverse	Boolean

GetItemLedgEntries

procedure GetItemLedgEntries(var TempItemLedgEntry: Record "Item Ledger Entry" temporary; SetQuantity: Boolean)

Parameters

Name	Type	Description
TempItemLedgEntry	Table Microsoft.Inventory.Ledger."Item Ledger Entry"
SetQuantity	Boolean

FilterPstdDocLineValueEntries

procedure FilterPstdDocLineValueEntries(var ValueEntry: Record "Value Entry")

Parameters

Name	Type	Description
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"

ShowItemReceiptLines

procedure ShowItemReceiptLines()

ShowLineComments

procedure ShowLineComments()

ShowShortcutDimCode

procedure ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])

Parameters

Name	Type	Description
ShortcutDimCode	array[8] of Code[20]

InitFromPurchLine

procedure InitFromPurchLine(PurchInvHeader: Record "Purch. Inv. Header"; PurchLine: Record "Purchase Line")

Parameters

Name	Type	Description
PurchInvHeader	Table Microsoft.Purchases.History."Purch. Inv. Header"
PurchLine	Table Microsoft.Purchases.Document."Purchase Line"

ShowDeferrals

procedure ShowDeferrals()

GetDocumentType

procedure GetDocumentType(): Integer

Returns

Type	Description
Integer

HasTypeToFillMandatoryFields

procedure HasTypeToFillMandatoryFields(): Boolean

Returns

Type	Description
Boolean

FormatType

procedure FormatType(): Text

Returns

Type	Description
Text

IsCancellationSupported

procedure IsCancellationSupported(): Boolean

Returns

Type	Description
Boolean

SetSecurityFilterOnRespCenter

procedure SetSecurityFilterOnRespCenter()

IsProdOrder

procedure IsProdOrder(): Boolean

Returns

Type	Description
Boolean

Events

OnAfterCalcQty

[IntegrationEvent(False,False)]
local procedure OnAfterCalcQty(var PurchInvLine: Record "Purch. Inv. Line"; QtyBase: Decimal; var Result: Decimal)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
QtyBase	Decimal
Result	Decimal

OnAfterInitFromPurchLine

[IntegrationEvent(False,False)]
local procedure OnAfterInitFromPurchLine(PurchInvHeader: Record "Purch. Inv. Header"; PurchLine: Record "Purchase Line"; var PurchInvLine: Record "Purch. Inv. Line")

Parameters

Name	Type	Description
PurchInvHeader	Table Microsoft.Purchases.History."Purch. Inv. Header"
PurchLine	Table Microsoft.Purchases.Document."Purchase Line"
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"

OnBeforeShowDeferrals

[IntegrationEvent(False,False)]
local procedure OnBeforeShowDeferrals(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
IsHandled	Boolean

OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert

[IntegrationEvent(False,False)]
local procedure OnGetItemLedgEntriesOnBeforeTempItemLedgEntryInsert(var TempItemLedgerEntry: Record "Item Ledger Entry" temporary; ValueEntry: Record "Value Entry"; SetQuantity: Boolean)

Parameters

Name	Type	Description
TempItemLedgerEntry	Table Microsoft.Inventory.Ledger."Item Ledger Entry"
ValueEntry	Table Microsoft.Inventory.Ledger."Value Entry"
SetQuantity	Boolean

OnBeforeSetSecurityFilterOnRespCenter

[IntegrationEvent(False,False)]
local procedure OnBeforeSetSecurityFilterOnRespCenter(var PurchInvLine: Record "Purch. Inv. Line"; var IsHandled: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
IsHandled	Boolean

OnGetItemLedgEntryOnShouldExit

[IntegrationEvent(False,False)]
local procedure OnGetItemLedgEntryOnShouldExit(var PurchInvLine: Record "Purch. Inv. Line"; var ShouldExit: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
ShouldExit	Boolean

OnAfterGetVATPct

[IntegrationEvent(False,False)]
local procedure OnAfterGetVATPct(var PurchInvLine: Record "Purch. Inv. Line"; var VATPct: Decimal)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
VATPct	Decimal

OnAfterCalcReceivedPurchNotReturned

[IntegrationEvent(False,False)]
local procedure OnAfterCalcReceivedPurchNotReturned(var PurchInvLine: Record "Purch. Inv. Line"; var RemainingQty: Decimal; var RevUnitCostLCY: Decimal; ExactCostReverse: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
RemainingQty	Decimal
RevUnitCostLCY	Decimal
ExactCostReverse	Boolean

OnIsProdOrder

[IntegrationEvent(False,False)]
local procedure OnIsProdOrder(var PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
Result	Boolean

OnAfterIsCancellationSupported

[IntegrationEvent(False,False)]
local procedure OnAfterIsCancellationSupported(PurchInvLine: Record "Purch. Inv. Line"; var Result: Boolean)

Parameters

Name	Type	Description
PurchInvLine	Table Microsoft.Purchases.History."Purch. Inv. Line"
Result	Boolean

See also

• Table