---
id: object/table/5110
type: object
title: Table 5110 "Purchase Line Archive"
summary: Table 5110 "Purchase Line Archive" in Base Application (Microsoft.Purchases.Archive). 182 fields, 6 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26-29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: f689f8763f262ff08e101c2c853398b7a075290c948d4b1d6c023dcf210b21c2
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Purchases/Archive/PurchaseLineArchive.Table.al
    title: src/Layers/W1/BaseApp/Purchases/Archive/PurchaseLineArchive.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations:
    - localization/at
    - localization/ca
    - localization/ch
    - localization/de
    - localization/es
    - localization/it
    - localization/mx
    - localization/ru
    - localization/us
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/8959
object_type: table
object_id: 5110
name: Purchase Line Archive
namespace: Microsoft.Purchases.Archive
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "27"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries:
  - at
  - ca
  - ch
  - de
  - es
  - it
  - mx
  - ru
  - us
ms_search_form_ids: []
counts:
  fields: 182
  procedures: 8
  events: 1
  subscribers: 0
relations:
  out: 54
  referenced_by: 4
  pages: 9
  extended_by: 2
  event_subscribers: 0
  calls: 2
  called_by: 0
  implements: 0
---

# Table 5110 "Purchase Line Archive"

> Table 5110 "Purchase Line Archive" in Base Application (Microsoft.Purchases.Archive). 182 fields, 6 public procedures, 1 events. Present since at least BC23, still in BC30, changed in BC24, BC26-29.

Base Application · Microsoft.Purchases.Archive · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Purchases/Archive/PurchaseLineArchive.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Purchase Line Archive |
| DataClassification | CustomerContent |

## 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 |
|---|---|---|---|---|
| 1 | Document Type | Enum "Purchase Document Type" | Specifies the type of purchase document. | enum [Enum 38 "Purchase Document Type"](../enum/38.md) |
| 2 | Buy-from Vendor No. | Code[20] | Specifies the name of the vendor who delivered the items. | TableRelation [Table 23 "Vendor"](../table/23.md) |
| 3 | Document No. | Code[20] | Specifies the document number. | TableRelation [Table 5109 "Purchase Header Archive"](../table/5109.md) ("Purchase Header Archive"."No." where("Document Type" = field("Document Type"), "Version No." = field("Version No."))) |
| 4 | Line No. | Integer | Specifies the number of the line. |  |
| 5 | Type | Enum "Purchase Line Type" | Specifies the line type. | enum [Enum 39 "Purchase Line Type"](../enum/39.md) |
| 6 | No. | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 27 "Item"](../table/27.md), [Table 5600 "Fixed Asset"](../table/5600.md) (if (Type = const(" ")) "Standard Text" else 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") |
| 7 | Location Code | Code[10] | Specifies a code for the location where you want the items to be placed when they are received. | TableRelation [Table 14 "Location"](../table/14.md) (Location where("Use As In-Transit" = const(false))) |
| 8 | Posting Group | Code[20] | — | TableRelation [Table 5606 "FA Posting Group"](../table/5606.md), [Table 94 "Inventory Posting Group"](../table/94.md) (if (Type = const(Item)) "Inventory Posting Group" else if (Type = const("Fixed Asset")) "FA Posting Group") |
| 10 | Expected Receipt Date | Date | Specifies the date you expect the items to be available in your warehouse. If you leave the field blank, it will be calculated as follows: Planned Receipt Date + Safety Lead Time + Inbound Warehouse Handling Time = Expected Receipt Date. |  |
| 11 | Description | Text[100] | Specifies a description of the record. |  |
| 12 | Description 2 | Text[50] | Specifies information in addition to the description. |  |
| 13 | Unit of Measure | Text[50] | Specifies the name of the item or resource's unit of measure, such as piece or hour. |  |
| 15 | Quantity | Decimal | Specifies the quantity of the record. |  |
| 16 | Outstanding Quantity | Decimal | — |  |
| 17 | Qty. to Invoice | Decimal | Specifies the quantity that remains to be invoiced. It is calculated as Quantity - Qty. Invoiced. |  |
| 18 | Qty. to Receive | Decimal | Specifies the quantity of items that remains to be received. |  |
| 22 | Direct Unit Cost | Decimal | Specifies the cost of one unit of the selected item or resource. |  |
| 23 | Unit Cost (LCY) | Decimal | Specifies the cost, in LCY, of one unit of the item or resource on the line. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 25 | VAT % | Decimal | — |  |
| 26 | Quantity Disc. % | Decimal | — |  |
| 27 | Line Discount % | Decimal | Specifies the discount percentage that is granted for the item on the line. |  |
| 28 | Line Discount Amount | Decimal | Specifies the discount amount that is granted for the item on the line. |  |
| 29 | Amount | Decimal | Specifies the sum of amounts in the Line Amount field on the purchase lines. |  |
| 30 | Amount Including VAT | Decimal | Specifies the net amount, including VAT, for this line. |  |
| 31 | Unit Price (LCY) | 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. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 32 | Allow Invoice Disc. | Boolean | Specifies if the invoice line is included when the invoice discount is calculated. |  |
| 34 | 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. |  |
| 35 | 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. |  |
| 36 | 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. |  |
| 37 | 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. |  |
| 38 | Appl.-to Item Entry | Integer | Specifies the number of the item ledger entry that the document or journal line is applied to. |  |
| 40 | 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. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 41 | 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. | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 45 | Job No. | Code[20] | Specifies the project number that the archived document was linked to. | TableRelation [Table 167 "Job"](../table/167.md) |
| 54 | 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. |  |
| 57 | Outstanding Amount | Decimal | — |  |
| 58 | Qty. Rcd. Not Invoiced | Decimal | — |  |
| 59 | Amt. Rcd. Not Invoiced | Decimal | — |  |
| 60 | Quantity Received | Decimal | Specifies how many units of the item on the line have been posted as received. |  |
| 61 | Quantity Invoiced | Decimal | Specifies how many units of the item on the line have been posted as invoiced. |  |
| 63 | Receipt No. | Code[20] | — |  |
| 64 | Receipt Line No. | Integer | — |  |
| 67 | Profit % | Decimal | — |  |
| 68 | Pay-to Vendor No. | Code[20] | — | TableRelation [Table 23 "Vendor"](../table/23.md) |
| 69 | Inv. Discount Amount | Decimal | Specifies the total calculated invoice discount amount for the line. |  |
| 70 | Vendor Item No. | Text[50] | — |  |
| 71 | Sales Order No. | Code[20] | — | TableRelation [Table 36 "Sales Header"](../table/36.md) (if ("Drop Shipment" = const(true)) "Sales Header"."No." where("Document Type" = const(Order))) |
| 72 | Sales Order Line No. | Integer | — | TableRelation [Table 37 "Sales Line"](../table/37.md) (if ("Drop Shipment" = const(true)) "Sales Line"."Line No." where("Document Type" = const(Order), "Document No." = field("Sales Order No."))) |
| 73 | Drop Shipment | Boolean | Specifies if your vendor ships the items directly to your customer. |  |
| 74 | 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. | TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md) (Gen. Business Posting Group) |
| 75 | 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. | TableRelation [Table 251 "Gen. Product Posting Group"](../table/251.md) (Gen. Product Posting Group) |
| 77 | VAT Calculation Type | Enum "Tax Calculation Type" | — | enum [Enum 254 "Tax Calculation Type"](../enum/254.md) |
| 78 | Transaction Type | Code[10] | — | TableRelation [Table 258 "Transaction Type"](../table/258.md) (Transaction Type) |
| 79 | Transport Method | Code[10] | — | TableRelation [Table 259 "Transport Method"](../table/259.md) (Transport Method) |
| 80 | Attached to Line No. | Integer | — | TableRelation [Table 5110 "Purchase Line Archive"](../table/5110.md) ("Purchase Line Archive"."Line No." where("Document Type" = field("Document Type"), "Document No." = field("Document No."), "Doc. No. Occurrence" = field("Doc. No. Occurrence"), "Version No." = field("Version No."))); not editable |
| 81 | Entry Point | Code[10] | — | TableRelation [Table 282 "Entry/Exit Point"](../table/282.md) (Entry/Exit Point) |
| 82 | Area | Code[10] | — | TableRelation [Table 284 "Area"](../table/284.md) |
| 83 | Transaction Specification | Code[10] | — | TableRelation [Table 285 "Transaction Specification"](../table/285.md) (Transaction Specification) |
| 85 | Tax Area Code | Code[20] | Specifies the tax area that is used to calculate and post sales tax. | TableRelation [Table 318 "Tax Area"](../table/318.md) (Tax Area) |
| 86 | Tax Liable | Boolean | Specifies if this vendor charges you sales tax for purchases. |  |
| 87 | Tax Group Code | Code[20] | Specifies the tax group that is used to calculate and post sales tax. | TableRelation [Table 321 "Tax Group"](../table/321.md) (Tax Group) |
| 88 | Use Tax | Boolean | Specifies a U.S. sales tax that is paid on items purchased by a company that are used by the company, instead of being sold to a customer. |  |
| 89 | 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. | TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md) (VAT Business Posting Group) |
| 90 | 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. | TableRelation [Table 324 "VAT Product Posting Group"](../table/324.md) (VAT Product Posting Group) |
| 91 | Currency Code | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md) |
| 92 | Outstanding Amount (LCY) | Decimal | — |  |
| 93 | Amt. Rcd. Not Invoiced (LCY) | Decimal | — |  |
| 97 | Blanket Order No. | Code[20] | Specifies the number of the blanket order that the record originates from. | TableRelation [Table 38 "Purchase Header"](../table/38.md) ("Purchase Header"."No." where("Document Type" = const("Blanket Order"))) |
| 98 | Blanket Order Line No. | Integer | Specifies the number of the blanket order line that the record originates from. | TableRelation [Table 39 "Purchase Line"](../table/39.md) ("Purchase Line"."Line No." where("Document Type" = const("Blanket Order"), "Document No." = field("Blanket Order No."))) |
| 99 | VAT Base Amount | Decimal | — |  |
| 100 | Unit Cost | Decimal | — |  |
| 101 | System-Created Entry | Boolean | — |  |
| 103 | Line Amount | Decimal | Specifies the net amount, excluding any invoice discount amount, that must be paid for products on the line. |  |
| 104 | VAT Difference | Decimal | — |  |
| 105 | Inv. Disc. Amount to Invoice | Decimal | — |  |
| 106 | VAT Identifier | Code[20] | — |  |
| 107 | IC Partner Ref. Type | Enum "IC Partner Reference Type" | — | enum [Enum 107 "IC Partner Reference Type"](../enum/107.md) |
| 108 | IC Partner Reference | Code[20] | — |  |
| 109 | Prepayment % | Decimal | — |  |
| 110 | Prepmt. Line Amount | Decimal | — |  |
| 111 | Prepmt. Amt. Inv. | Decimal | — | not editable |
| 112 | Prepmt. Amt. Incl. VAT | Decimal | — | not editable |
| 113 | Prepayment Amount | Decimal | — | not editable |
| 114 | Prepmt. VAT Base Amt. | Decimal | — | not editable |
| 115 | Prepayment VAT % | Decimal | — | not editable |
| 116 | Prepmt. VAT Calc. Type | Enum "Tax Calculation Type" | — | enum [Enum 254 "Tax Calculation Type"](../enum/254.md); not editable |
| 117 | Prepayment VAT Identifier | Code[20] | — | not editable |
| 118 | Prepayment Tax Area Code | Code[20] | — | TableRelation [Table 318 "Tax Area"](../table/318.md) (Tax Area) |
| 119 | Prepayment Tax Liable | Boolean | — |  |
| 120 | Prepayment Tax Group Code | Code[20] | — | TableRelation [Table 321 "Tax Group"](../table/321.md) (Tax Group) |
| 121 | Prepmt Amt to Deduct | Decimal | — |  |
| 122 | Prepmt Amt Deducted | Decimal | — | not editable |
| 123 | Prepayment Line | Boolean | — | not editable |
| 124 | Prepmt. Amount Inv. Incl. VAT | Decimal | — | not editable |
| 130 | IC Partner Code | Code[20] | — | TableRelation [Table 413 "IC Partner"](../table/413.md) (IC Partner) |
| 138 | IC Item Reference No. | Code[50] | — |  |
| 145 | Pmt. Discount Amount | Decimal | — |  |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 1001 | Job Task No. | Code[20] | Specifies the number of the related project task. | TableRelation [Table 1001 "Job Task"](../table/1001.md) ("Job Task"."Job Task No." where("Job No." = field("Job No."))); not editable |
| 1002 | Job Line Type | Enum "Job Line Type" | Specifies the type of planning line that was created when the project ledger entry is posted from the purchase line. If the field is empty, no planning lines were created for this entry. | enum [Enum 1002 "Job Line Type"](../enum/1002.md) |
| 1003 | Job Unit Price | Decimal | Specifies the sales price per unit that applies to the item or general ledger expense that will be posted. |  |
| 1004 | Job Total Price | Decimal | Specifies the gross amount of the line that the purchase line applies to. |  |
| 1005 | Job Line Amount | Decimal | Specifies the line amount of the project ledger entry that is related to the purchase line. |  |
| 1006 | Job Line Discount Amount | Decimal | Specifies the line discount amount of the project ledger entry that is related to the purchase line. |  |
| 1007 | Job Line Discount % | Decimal | Specifies the line discount percentage of the project ledger entry that is related to the purchase line. |  |
| 1008 | Job Unit Price (LCY) | Decimal | Specifies the sales price per unit that applies to the item or general ledger expense that will be posted. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 1009 | Job Total Price (LCY) | Decimal | Specifies the gross amount of the line, in the local currency. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 1010 | Job Line Amount (LCY) | Decimal | Specifies the line amount of the project ledger entry that is related to the purchase line. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 1011 | Job Line Disc. Amount (LCY) | Decimal | Specifies the line discount amount of the project ledger entry that is related to the purchase line. <small>via [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md)</small> |  |
| 1012 | Job Currency Factor | Decimal | Project Currency Factor <small>caption</small> |  |
| 1013 | Job Currency Code | Code[20] | Project Currency Code <small>caption</small> |  |
| 1019 | Job Planning Line No. | Integer | Specifies the project planning line number to which the usage should be linked when the Project Journal is posted. You can only link to Project Planning Lines that have the Apply Usage Link option enabled. |  |
| 1030 | Job Remaining Qty. | Decimal | Project Remaining Qty. <small>caption</small> |  |
| 1031 | Job Remaining Qty. (Base) | Decimal | Project Remaining Qty. (Base) <small>caption</small> |  |
| 1700 | 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. | TableRelation [Table 1700 "Deferral Template"](../table/1700.md) ("Deferral Template"."Deferral Code") |
| 1702 | Returns Deferral Start Date | Date | Specifies the starting date of the returns deferral period. |  |
| 5047 | Version No. | Integer | — |  |
| 5048 | Doc. No. Occurrence | Integer | — |  |
| 5402 | Variant Code | Code[10] | Specifies the variant of the item on the line. | TableRelation [Table 5401 "Item Variant"](../table/5401.md) (if (Type = const(Item)) "Item Variant".Code where("Item No." = field("No."))) |
| 5403 | Bin Code | Code[20] | — | TableRelation [Table 7354 "Bin"](../table/7354.md) (Bin.Code where("Location Code" = field("Location Code"))) |
| 5404 | Qty. per Unit of Measure | Decimal | — |  |
| 5407 | 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. | TableRelation [Table 204 "Unit of Measure"](../table/204.md), [Table 5404 "Item Unit of Measure"](../table/5404.md) (if (Type = const(Item)) "Item Unit of Measure".Code where("Item No." = field("No.")) else "Unit of Measure") |
| 5415 | Quantity (Base) | Decimal | — |  |
| 5416 | Outstanding Qty. (Base) | Decimal | — |  |
| 5417 | Qty. to Invoice (Base) | Decimal | — |  |
| 5418 | Qty. to Receive (Base) | Decimal | — |  |
| 5458 | Qty. Rcd. Not Invoiced (Base) | Decimal | — |  |
| 5460 | Qty. Received (Base) | Decimal | — |  |
| 5461 | Qty. Invoiced (Base) | Decimal | — |  |
| 5600 | FA Posting Date | Date | — |  |
| 5601 | FA Posting Type | Enum "Purchase FA Posting Type" | — | enum [Enum 5607 "Purchase FA Posting Type"](../enum/5607.md) |
| 5602 | Depreciation Book Code | Code[10] | — | TableRelation [Table 5611 "Depreciation Book"](../table/5611.md) (Depreciation Book) |
| 5603 | Salvage Value | Decimal | — |  |
| 5605 | Depr. until FA Posting Date | Boolean | — |  |
| 5606 | Depr. Acquisition Cost | Boolean | — |  |
| 5609 | Maintenance Code | Code[10] | — | TableRelation [Table 5626 "Maintenance"](../table/5626.md) |
| 5610 | Insurance No. | Code[20] | — | TableRelation [Table 5628 "Insurance"](../table/5628.md) |
| 5611 | Budgeted FA No. | Code[20] | — | TableRelation [Table 5600 "Fixed Asset"](../table/5600.md) (Fixed Asset) |
| 5612 | Duplicate in Depreciation Book | Code[10] | — | TableRelation [Table 5611 "Depreciation Book"](../table/5611.md) (Depreciation Book) |
| 5613 | Use Duplication List | Boolean | — |  |
| 5700 | Responsibility Center | Code[10] | — | TableRelation [Table 5714 "Responsibility Center"](../table/5714.md) (Responsibility Center) |
| 5709 | Item Category Code | Code[20] | — | TableRelation [Table 5722 "Item Category"](../table/5722.md) (Item Category) |
| 5710 | Nonstock | Boolean | Specifies that this item is a catalog item. |  |
| 5711 | Purchasing Code | Code[10] | — | TableRelation [Table 5721 "Purchasing"](../table/5721.md) |
| 5713 | Special Order | Boolean | — |  |
| 5714 | Special Order Sales No. | Code[20] | — | TableRelation [Table 36 "Sales Header"](../table/36.md) (if ("Special Order" = const(true)) "Sales Header"."No." where("Document Type" = const(Order))) |
| 5715 | Special Order Sales Line No. | Integer | — | TableRelation [Table 37 "Sales Line"](../table/37.md) (if ("Special Order" = const(true)) "Sales Line"."Line No." where("Document Type" = const(Order), "Document No." = field("Special Order Sales No."))) |
| 5725 | Item Reference No. | Code[50] | Specifies the referenced item number. |  |
| 5726 | Item Reference Unit of Measure | Code[10] | Reference Unit of Measure <small>caption</small> | TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) (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"](../enum/5726.md) |
| 5728 | Item Reference Type No. | Code[30] | — |  |
| 5752 | Completely Received | Boolean | — |  |
| 5790 | Requested Receipt Date | Date | Specifies the requested date of receipt for the purchase return order. |  |
| 5791 | Promised Receipt Date | Date | Specifies the date that the vendor has promised to deliver the order. |  |
| 5792 | Lead Time Calculation | DateFormula | Specifies a date formula for the amount of time it takes to replenish the item. |  |
| 5793 | Inbound Whse. Handling Time | DateFormula | Specifies the time it takes to make items part of available inventory, after the items have been posted as received. |  |
| 5794 | Planned Receipt Date | Date | Specifies the date when the item is planned to arrive in inventory. Forward calculation: planned receipt date = order date + vendor lead time (per the vendor calendar and rounded to the next working day in first the vendor calendar and then the location calendar). If no vendor calendar exists, then:... |  |
| 5795 | Order Date | Date | Specifies the date when the order was created. |  |
| 5800 | Allow Item Charge Assignment | Boolean | Specifies that you can assign item charges to this line. |  |
| 5803 | Return Qty. to Ship | Decimal | Specifies the quantity of items that remains to be shipped. |  |
| 5804 | Return Qty. to Ship (Base) | Decimal | — |  |
| 5805 | Return Qty. Shipped Not Invd. | Decimal | — |  |
| 5806 | Ret. Qty. Shpd Not Invd.(Base) | Decimal | — |  |
| 5807 | Return Shpd. Not Invd. | Decimal | — |  |
| 5808 | Return Shpd. Not Invd. (LCY) | Decimal | — |  |
| 5809 | Return Qty. Shipped | Decimal | Specifies how many units of the item on the line have been posted as shipped. |  |
| 5810 | Return Qty. Shipped (Base) | Decimal | — |  |
| 6200 | Non-Deductible VAT % | Decimal | — |  |
| 6201 | Non-Deductible VAT Base | Decimal | — |  |
| 6202 | Non-Deductible VAT Amount | Decimal | — |  |
| 6203 | Non-Deductible VAT Diff. | Decimal | Non-Deductible VAT Difference <small>caption</small> |  |
| 6600 | Return Shipment No. | Code[20] | — |  |
| 6601 | Return Shipment Line No. | Integer | — | not editable |
| 6608 | Return Reason Code | Code[10] | Specifies the code explaining why the item was returned. | TableRelation [Table 6635 "Return Reason"](../table/6635.md) (Return Reason) |
| 7000 | Price Calculation Method | Enum "Price Calculation Method" | — | enum [Enum 7000 "Price Calculation Method"](../enum/7000.md) |
| 12100 | No. of Fixed Asset Cards | Integer | Specifies the number of fixed assets that is being purchased. |  |
| 99000755 | Overhead Rate | Decimal | — |  |
| 99000756 | MPS Order | Boolean | — |  |
| 99000757 | Planning Flexibility | Enum "Reservation Planning Flexibility" | Specifies whether the supply represented by this line is considered by the planning system when calculating action messages. | enum [Enum 340 "Reservation Planning Flexibility"](../enum/340.md) |
| 99000758 | Safety Lead Time | DateFormula | — |  |
| 147 | Spend Request No. | Code[20] | Specifies the spend request that this purchase document relates to. | TableRelation [Table 6840 "Spend Request"](../table/6840.md) (Spend Request) |
| 148 | Spend Request Close | Boolean | Specifies that the spend request will be closed when the purchase document is posted. |  |

## Keys

- Key1: Document Type, Document No., Doc. No. Occurrence, Version No., Line No. (clustered)
- Key2: Document Type, Document No., Line No., Doc. No. Occurrence, Version No.
- Key3: Buy-from Vendor No.
- Key4: Pay-to Vendor No.
- Key5: Document No., Document Type, Doc. No. Occurrence, Version No.

## Events published

- `OnBeforeShowDeferrals(PurchaseLineArchive: Record "Purchase Line Archive"; var IsHandled: Boolean)` (integration)

## Procedures

- `GetCaptionClass(FieldNumber: Integer): Text[80]`
- `IsExtendedText(): Boolean`
- `ShowDimensions()`
- `ShowLineComments()`
- `ShowDeferrals()`
- `CopyTempLines(PurchaseHeaderArchive: Record "Purchase Header Archive"; var TempPurchaseLine: Record "Purchase Line" temporary)`

Plus 1 local procedures.

## Triggers

OnDelete

## Relations

- Job Task No.: TableRelation [Table 1001 "Job Task"](../table/1001.md)
- Location Code: TableRelation [Table 14 "Location"](../table/14.md)
- No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Job No.: TableRelation [Table 167 "Job"](../table/167.md)
- Deferral Code: TableRelation [Table 1700 "Deferral Template"](../table/1700.md)
- Unit of Measure Code: TableRelation [Table 204 "Unit of Measure"](../table/204.md) (conditional)
- Buy-from Vendor No.: TableRelation [Table 23 "Vendor"](../table/23.md)
- Pay-to Vendor No.: TableRelation [Table 23 "Vendor"](../table/23.md)
- Gen. Bus. Posting Group: TableRelation [Table 250 "Gen. Business Posting Group"](../table/250.md)
- Gen. Prod. Posting Group: TableRelation [Table 251 "Gen. Product Posting Group"](../table/251.md)
- Transaction Type: TableRelation [Table 258 "Transaction Type"](../table/258.md)
- Transport Method: TableRelation [Table 259 "Transport Method"](../table/259.md)
- No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Entry Point: TableRelation [Table 282 "Entry/Exit Point"](../table/282.md)
- Area: TableRelation [Table 284 "Area"](../table/284.md)
- Transaction Specification: TableRelation [Table 285 "Transaction Specification"](../table/285.md)
- Prepayment Tax Area Code: TableRelation [Table 318 "Tax Area"](../table/318.md)
- Tax Area Code: TableRelation [Table 318 "Tax Area"](../table/318.md)
- Prepayment Tax Group Code: TableRelation [Table 321 "Tax Group"](../table/321.md)
- Tax Group Code: TableRelation [Table 321 "Tax Group"](../table/321.md)
- VAT Bus. Posting Group: TableRelation [Table 323 "VAT Business Posting Group"](../table/323.md)
- VAT Prod. Posting Group: TableRelation [Table 324 "VAT Product Posting Group"](../table/324.md)
- Shortcut Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Sales Order No.: TableRelation [Table 36 "Sales Header"](../table/36.md)
- Special Order Sales No.: TableRelation [Table 36 "Sales Header"](../table/36.md)
- Sales Order Line No.: TableRelation [Table 37 "Sales Line"](../table/37.md)
- Special Order Sales Line No.: TableRelation [Table 37 "Sales Line"](../table/37.md)
- Blanket Order No.: TableRelation [Table 38 "Purchase Header"](../table/38.md)
- Blanket Order Line No.: TableRelation [Table 39 "Purchase Line"](../table/39.md)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- IC Partner Code: TableRelation [Table 413 "IC Partner"](../table/413.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Document No.: TableRelation [Table 5109 "Purchase Header Archive"](../table/5109.md)
- Attached to Line No.: TableRelation [Table 5110 "Purchase Line Archive"](../table/5110.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Item Reference Unit of Measure: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md)
- Unit of Measure Code: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) (conditional)
- Budgeted FA No.: TableRelation [Table 5600 "Fixed Asset"](../table/5600.md)
- No.: TableRelation [Table 5600 "Fixed Asset"](../table/5600.md) (conditional)
- Posting Group: TableRelation [Table 5606 "FA Posting Group"](../table/5606.md) (conditional)
- Depreciation Book Code: TableRelation [Table 5611 "Depreciation Book"](../table/5611.md)
- Duplicate in Depreciation Book: TableRelation [Table 5611 "Depreciation Book"](../table/5611.md)
- Maintenance Code: TableRelation [Table 5626 "Maintenance"](../table/5626.md)
- Insurance No.: TableRelation [Table 5628 "Insurance"](../table/5628.md)
- Responsibility Center: TableRelation [Table 5714 "Responsibility Center"](../table/5714.md)
- Purchasing Code: TableRelation [Table 5721 "Purchasing"](../table/5721.md)
- Item Category Code: TableRelation [Table 5722 "Item Category"](../table/5722.md)
- No.: TableRelation [Table 5800 "Item Charge"](../table/5800.md) (conditional)
- Return Reason Code: TableRelation [Table 6635 "Return Reason"](../table/6635.md)
- Spend Request No.: TableRelation [Table 6840 "Spend Request"](../table/6840.md)
- No.: TableRelation [Table 7 "Standard Text"](../table/7.md) (conditional)
- Bin Code: TableRelation [Table 7354 "Bin"](../table/7354.md)
- Posting Group: TableRelation [Table 94 "Inventory Posting Group"](../table/94.md) (conditional)

## Referenced by

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

- [Table 5109 "Purchase Header Archive"](../table/5109.md): Amount, Amount Including VAT, Completely Received
- [Table 5110 "Purchase Line Archive"](../table/5110.md): Attached to Line No.

## Pages and codeunits on this table

- [Page 30217 "APIV2 - P. Qt. Arch. Lines"](../page/30217.md) (source table)
- [Page 30219 "APIV2 - P. Ord. Arch. Lines"](../page/30219.md) (source table)
- [Page 30223 "APIV2 - P. Ret. Ord. A. Lines"](../page/30223.md) (source table)
- [Page 30231 "APIV2 - P. Bl. O. Arch. Lines"](../page/30231.md) (source table)
- [Page 5165 "Purchase Quote Archive Subform"](../page/5165.md) (source table)
- [Page 5168 "Purchase Order Archive Subform"](../page/5168.md) (source table)
- [Page 6624 "Blanket Purch. Order Arch.Sub."](../page/6624.md) (source table)
- [Page 6626 "Purchase Line Archive List"](../page/6626.md) (source table)
- [Page 6645 "Purch Return Order Arc Subform"](../page/6645.md) (source table)

## Extended by

- [Table extension 20516 "Subc. Purchase Line Archive"](../tableextension/20516.md)
- [Table extension 99000752 "Mfg. Purchase Line Archive"](../tableextension/99000752.md)

## 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 1720 "Deferral Utilities"](../codeunit/1720.md) (1 call: `ShowDeferrals → OpenLineScheduleArchive`)
- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (1 call: `ShowDimensions → ShowDimensionSet`)

## Recent changes

- 2026-07-31 [#8959 Deliverable 638799: Spend Requests in Base App](../../changes/bcapps/8959.md) (main, BC30, feature)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26-29

## Countries that replace it

[AT](../../localizations/at.md), [CA](../../localizations/ca.md), [CH](../../localizations/ch.md), [DE](../../localizations/de.md), [ES](../../localizations/es.md), [IT](../../localizations/it.md), [MX](../../localizations/mx.md), [RU](../../localizations/ru.md), [US](../../localizations/us.md)

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: "Purchase Line Archive")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.