---
id: object/table/174
type: object
title: Table 174 "Standard Purchase Line"
summary: Table 174 "Standard Purchase Line" in Base Application (Microsoft.Purchases.Document). 12 fields, 8 public procedures, 11 events. Present since at least BC23, still in BC30, changed in BC24, BC27-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: a94a4cddee2cdca39e2cdfc2443434c588153f308c75513619209b8e67789454
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Purchases/Document/StandardPurchaseLine.Table.al
    title: src/Layers/W1/BaseApp/Purchases/Document/StandardPurchaseLine.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/purchasing-setup-purchasing
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/set-up-business-central/set-up-purchase
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/9947
object_type: table
object_id: 174
name: Standard Purchase Line
namespace: Microsoft.Purchases.Document
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "27"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 12
  procedures: 20
  events: 11
  subscribers: 0
relations:
  out: 13
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 174 "Standard Purchase Line"

> Table 174 "Standard Purchase Line" in Base Application (Microsoft.Purchases.Document). 12 fields, 8 public procedures, 11 events. Present since at least BC23, still in BC30, changed in BC24, BC27-29.

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

Learn documents this table through its pages: [Page 176 "Standard Purchase Code Subform"](../page/176.md) (1 Learn page).

## Properties

| Property | Value |
|---|---|
| Caption | Standard Purchase Line |
| 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 | Standard Purchase Code | Code[10] | — | TableRelation [Table 173 "Standard Purchase Code"](../table/173.md) (Standard Purchase Code); not editable |
| 2 | Line No. | Integer | — | not editable |
| 3 | Type | Enum "Purchase Line Type" | Specifies whether the line is for a general ledger account, item, fixed asset or item charge. | enum [Enum 39 "Purchase Line Type"](../enum/39.md) |
| 4 | No. | Code[20] | Specifies the number of a general ledger account, item, resource, additional cost, or fixed asset, depending on the contents of the Type field. | 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 where(Blocked = const(false)) else if (Type = const("Fixed Asset")) "Fixed Asset" else if (Type = const("Charge (Item)")) "Item Charge" else if (Type = const("Allocation Accou...) |
| 5 | Description | Text[100] | Specifies a description of the entry, which is based on the contents of the Type and No. fields. |  |
| 6 | Quantity | Decimal | Specifies the number of units of the item on the line. |  |
| 7 | Amount Excl. VAT | Decimal | Specifies the net amount for the standard purchase line. This field only applies to lines of type G/L Account and Charge (Item). |  |
| 8 | 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 205 "Resource Unit of Measure"](../table/205.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 if (Type = const(Resource)) "Resource Unit of Measure".Code where("Resource No." = field("No.")) else "Unit of Measure") |
| 9 | 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), Blocked = const(false))) |
| 10 | 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), Blocked = const(false))) |
| 11 | 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."), Blocked = const(false))) |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |

## Keys

- Key1: Standard Purchase Code, Line No. (clustered)

## Events published

- `OnBeforeLookupShortcutDimCode(var StandardPurchaseLine: Record "Standard Purchase Line"; var xStandardPurchaseLine: Record "Standard Purchase Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean)` (integration)
- `OnAfterShowDimensions(var StandardPurchaseLine: Record "Standard Purchase Line"; var DimMgt: Codeunit DimensionManagement)` (integration)
- `OnAfterValidateGLAccountNo(var StandardPurchaseLine: Record "Standard Purchase Line"; GLAccount: Record "G/L Account")` (integration)
- `OnAfterValidateItemNo(var StandardPurchaseLine: Record "Standard Purchase Line"; Item: Record "Item")` (integration)
- `OnAfterValidateResourceNo(var StandardPurchaseLine: Record "Standard Purchase Line"; Resource: Record "Resource")` (integration)
- `OnAfterValidateFANo(var StandardPurchaseLine: Record "Standard Purchase Line"; FixedAsset: Record "Fixed Asset")` (integration)
- `OnAfterValidateItemChargeNo(var StandardPurchaseLine: Record "Standard Purchase Line"; ItemCharge: Record "Item Charge")` (integration)
- `OnAfterValidateShortcutDimCode(var StandardPurchaseLine: Record "Standard Purchase Line"; xStandardPurchaseLine: Record "Standard Purchase Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])` (integration)
- `OnBeforeValidateShortcutDimCode(var StandardPurchaseLine: Record "Standard Purchase Line"; xStandardPurchaseLine: Record "Standard Purchase Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])` (integration)
- `OnBeforeValidateAmountExclVAT(var StandardPurchaseLine: Record "Standard Purchase Line"; var IsHandled: Boolean)` (integration)
- `OnBeforeValidateUnitOfMeasureCode(var StandardPurchaseLine: Record "Standard Purchase Line"; var IsHandled: Boolean)` (integration)

## Procedures

- `EmptyLine(): Boolean`
- `InsertLine(): Boolean`
- `ShowDimensions()`
- `ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])`
- `LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])`
- `ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])`
- `FormatType(): Text[20]` (obsolete 29.0: Use FormatTypeAsText() instead.)
- `FormatTypeAsText(): Text[30]`: Formats the line type for display, returning 'Comment' for blank types.

Plus 1 local procedures.

## Triggers

OnInsert, OnRename

## Relations

- No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Standard Purchase Code: TableRelation [Table 173 "Standard Purchase Code"](../table/173.md)
- Unit of Measure Code: TableRelation [Table 204 "Unit of Measure"](../table/204.md) (conditional)
- Unit of Measure Code: TableRelation [Table 205 "Resource Unit of Measure"](../table/205.md) (conditional)
- No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Shortcut Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Variant Code: TableRelation [Table 5401 "Item Variant"](../table/5401.md)
- Unit of Measure Code: TableRelation [Table 5404 "Item Unit of Measure"](../table/5404.md) (conditional)
- No.: TableRelation [Table 5600 "Fixed Asset"](../table/5600.md) (conditional)
- No.: TableRelation [Table 5800 "Item Charge"](../table/5800.md) (conditional)
- No.: TableRelation [Table 7 "Standard Text"](../table/7.md) (conditional)

## Pages and codeunits on this table

- [Page 176 "Standard Purchase Code Subform"](../page/176.md) (source table)

## 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"](../codeunit/408.md) (6 calls: `LookupShortcutDimCode → LookupDimValueCode`, `LookupShortcutDimCode → ValidateShortcutDimValues`, `ShowDimensions → EditDimensionSet`, …)

## Recent changes

- 2026-08-13 [#9947 Allow long localized sales and purchase line type captions](../../changes/bcapps/9947.md) (main, BC30, fix)

## Across versions

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

## Deprecations

- procedure FormatType: Pending 29.0 (#if not CLEAN29), "Use FormatTypeAsText() instead."

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