Table "Purchase Line Archive"

ID 5110
Namespace: Microsoft.Purchases.Archive

Properties

Name Value
Caption Purchase Line Archive
PasteIsValid False
DataClassification CustomerContent

Fields

Name Type Description
"Document Type" Enum Microsoft.Purchases.Document."Purchase Document Type"
"Buy-from Vendor No." Code[20]
"Document No." Code[20]
"Line No." Integer
Type Enum Microsoft.Purchases.Document."Purchase Line Type"
"No." Code[20]
"Location Code" Code[10]
"Posting Group" Code[20]
"Expected Receipt Date" Date
Description Text[100]
"Description 2" Text[50]
"Unit of Measure" Text[50]
Quantity Decimal
"Outstanding Quantity" Decimal
"Qty. to Invoice" Decimal
"Qty. to Receive" Decimal
"Direct Unit Cost" Decimal
"Unit Cost (LCY)" Decimal
"VAT %" Decimal
"Quantity Disc. %" Decimal
"Line Discount %" Decimal
"Line Discount Amount" Decimal
Amount Decimal
"Amount Including VAT" Decimal
"Unit Price (LCY)" Decimal
"Allow Invoice Disc." Boolean
"Gross Weight" Decimal
"Net Weight" Decimal
"Units per Parcel" Decimal
"Unit Volume" Decimal
"Appl.-to Item Entry" Integer
"Shortcut Dimension 1 Code" Code[20]
"Shortcut Dimension 2 Code" Code[20]
"Job No." Code[20]
"Indirect Cost %" Decimal
"Outstanding Amount" Decimal
"Qty. Rcd. Not Invoiced" Decimal
"Amt. Rcd. Not Invoiced" Decimal
"Quantity Received" Decimal
"Quantity Invoiced" Decimal
"Receipt No." Code[20]
"Receipt Line No." Integer
"Profit %" Decimal
"Pay-to Vendor No." Code[20]
"Inv. Discount Amount" Decimal
"Vendor Item No." Text[50]
"Sales Order No." Code[20]
"Sales Order Line No." Integer
"Drop Shipment" Boolean
"Gen. Bus. Posting Group" Code[20]
"Gen. Prod. Posting Group" Code[20]
"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]
"Tax Liable" Boolean
"Tax Group Code" Code[20]
"Use Tax" Boolean
"VAT Bus. Posting Group" Code[20]
"VAT Prod. Posting Group" Code[20]
"Currency Code" Code[10]
"Outstanding Amount (LCY)" Decimal
"Amt. Rcd. Not Invoiced (LCY)" Decimal
"Blanket Order No." Code[20]
"Blanket Order Line No." Integer
"VAT Base Amount" Decimal
"Unit Cost" Decimal
"System-Created Entry" Boolean
"Line Amount" Decimal
"VAT Difference" Decimal
"Inv. Disc. Amount to Invoice" Decimal
"VAT Identifier" Code[20]
"IC Partner Ref. Type" Enum Microsoft.Intercompany.Partner."IC Partner Reference Type"
"IC Partner Reference" Code[20]
"Prepayment %" Decimal
"Prepmt. Line Amount" Decimal
"Prepmt. Amt. Inv." Decimal
"Prepmt. Amt. Incl. VAT" Decimal
"Prepayment Amount" Decimal
"Prepmt. VAT Base Amt." Decimal
"Prepayment VAT %" Decimal
"Prepmt. VAT Calc. Type" Enum Microsoft.Foundation.Enums."Tax Calculation Type"
"Prepayment VAT Identifier" Code[20]
"Prepayment Tax Area Code" Code[20]
"Prepayment Tax Liable" Boolean
"Prepayment Tax Group Code" Code[20]
"Prepmt Amt to Deduct" Decimal
"Prepmt Amt Deducted" Decimal
"Prepayment Line" Boolean
"Prepmt. Amount Inv. Incl. VAT" Decimal
"IC Partner Code" Code[20]
"IC Item Reference No." Code[50]
"Pmt. Discount Amount" Decimal
"Dimension Set ID" Integer
"Job Task No." Code[20]
"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
"Job Remaining Qty." Decimal
"Job Remaining Qty. (Base)" Decimal
"Deferral Code" Code[10]
"Returns Deferral Start Date" Date
"Version No." Integer
"Doc. No. Occurrence" Integer
"Variant Code" Code[10]
"Bin Code" Code[20]
"Qty. per Unit of Measure" Decimal
"Unit of Measure Code" Code[10]
"Quantity (Base)" Decimal
"Outstanding Qty. (Base)" Decimal
"Qty. to Invoice (Base)" Decimal
"Qty. to Receive (Base)" Decimal
"Qty. Rcd. Not Invoiced (Base)" Decimal
"Qty. Received (Base)" Decimal
"Qty. Invoiced (Base)" Decimal
"FA Posting Date" Date
"FA Posting Type" Enum Microsoft.FixedAssets.Posting."Purchase FA Posting Type"
"Depreciation Book Code" Code[10]
"Salvage Value" Decimal
"Depr. until FA Posting Date" Boolean
"Depr. Acquisition Cost" Boolean
"Maintenance Code" Code[10]
"Insurance No." Code[20]
"Budgeted FA No." Code[20]
"Duplicate in Depreciation Book" Code[10]
"Use Duplication List" Boolean
"Responsibility Center" Code[10]
"Item Category Code" Code[20]
Nonstock Boolean
"Purchasing Code" Code[10]
"Special Order" Boolean
"Special Order Sales No." Code[20]
"Special Order Sales Line No." Integer
"Item Reference No." Code[50]
"Item Reference Unit of Measure" Code[10]
"Item Reference Type" Enum Microsoft.Inventory.Item.Catalog."Item Reference Type"
"Item Reference Type No." Code[30]
"Completely Received" Boolean
"Requested Receipt Date" Date
"Promised Receipt Date" Date
"Lead Time Calculation" DateFormula
"Inbound Whse. Handling Time" DateFormula
"Planned Receipt Date" Date
"Order Date" Date
"Allow Item Charge Assignment" Boolean
"Return Qty. to Ship" Decimal
"Return Qty. to Ship (Base)" Decimal
"Return Qty. Shipped Not Invd." Decimal
"Ret. Qty. Shpd Not Invd.(Base)" Decimal
"Return Shpd. Not Invd." Decimal
"Return Shpd. Not Invd. (LCY)" Decimal
"Return Qty. Shipped" Decimal
"Return Qty. Shipped (Base)" Decimal
"Non-Deductible VAT %" Decimal
"Non-Deductible VAT Base" Decimal
"Non-Deductible VAT Amount" Decimal
"Non-Deductible VAT Diff." Decimal
"Return Shipment No." Code[20]
"Return Shipment Line No." Integer
"Return Reason Code" Code[10]
"Price Calculation Method" Enum Microsoft.Pricing.Calculation."Price Calculation Method"
"No. of Fixed Asset Cards" Integer

Specifies the number of fixed assets that is being purchased.
"Overhead Rate" Decimal
"MPS Order" Boolean
"Planning Flexibility" Enum Microsoft.Inventory.Tracking."Reservation Planning Flexibility"
"Safety Lead Time" DateFormula
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

GetCaptionClass

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

Parameters

Name Type Description
FieldNumber Integer

Returns

Type Description
Text[80]

IsExtendedText

procedure IsExtendedText(): Boolean

Returns

Type Description
Boolean

ShowDimensions

procedure ShowDimensions()

ShowLineComments

procedure ShowLineComments()

ShowDeferrals

procedure ShowDeferrals()

CopyTempLines

procedure CopyTempLines(PurchaseHeaderArchive: Record "Purchase Header Archive", var TempPurchaseLine: Record "Purchase Line" temporary)

Parameters

Name Type Description
PurchaseHeaderArchive Table Microsoft.Purchases.Archive."Purchase Header Archive"
TempPurchaseLine Table Microsoft.Purchases.Document."Purchase Line"

Events

OnBeforeShowDeferrals

[IntegrationEvent(False,False)]
local procedure OnBeforeShowDeferrals(PurchaseLineArchive: Record "Purchase Line Archive", var IsHandled: Boolean)

Parameters

Name Type Description
PurchaseLineArchive Table Microsoft.Purchases.Archive."Purchase Line Archive"
IsHandled Boolean

See also