---
id: object/table/171
type: object
title: Table 171 "Standard Sales Line"
summary: Table 171 "Standard Sales Line" in Base Application (Microsoft.Sales.Document). 12 fields, 8 public procedures, 5 events. Present since at least BC23, still in BC30, changed in BC24, BC28-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: 6279b57df5f49bd322c3517bad2f634d49e8c428dc830bdce9e44dcf39ff8dc4
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Sales/Document/StandardSalesLine.Table.al
    title: src/Layers/W1/BaseApp/Sales/Document/StandardSalesLine.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/9947
object_type: table
object_id: 171
name: Standard Sales Line
namespace: Microsoft.Sales.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"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 12
  procedures: 14
  events: 5
  subscribers: 0
relations:
  out: 13
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 171 "Standard Sales Line"

> Table 171 "Standard Sales Line" in Base Application (Microsoft.Sales.Document). 12 fields, 8 public procedures, 5 events. Present since at least BC23, still in BC30, changed in BC24, BC28-29.

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

## Properties

| Property | Value |
|---|---|
| Caption | Standard Sales 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 Sales Code | Code[10] | — | TableRelation [Table 170 "Standard Sales Code"](../table/170.md) (Standard Sales Code); not editable |
| 2 | Line No. | Integer | — | not editable |
| 3 | Type | Enum "Sales Line Type" | Specifies whether the line is for a general ledger account, item, resource, fixed asset or item charge. | enum [Enum 37 "Sales Line Type"](../enum/37.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 156 "Resource"](../table/156.md), [Table 27 "Item"](../table/27.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(Resource)) Resource else if (Type = const("Fixed Asset")) "Fixed Asset" else if (Type = const("Allocation Account")) "Alloc...) |
| 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 sales 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 Sales Code, Line No. (clustered)

## Events published

- `OnBeforeLookupShortcutDimCode(var StandardSalesLine: Record "Standard Sales Line"; var xStandardSalesLine: Record "Standard Sales Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean)` (integration)
- `OnAfterValidateShortcutDimCode(var StandardSalesLine: Record "Standard Sales Line"; xStandardSalesLine: Record "Standard Sales Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])` (integration)
- `OnAfterValidateNo(var StandardSalesLine: Record "Standard Sales Line"; GLAccount: Record "G/L Account")` (integration)
- `OnAfterShowDimensions(var StandardSalesLine: Record "Standard Sales Line"; var DimMgt: Codeunit DimensionManagement)` (integration)
- `OnBeforeValidateShortcutDimCode(var StandardSalesLine: Record "Standard Sales Line"; xStandardSalesLine: Record "Standard Sales Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])` (integration)

## Procedures

- `EmptyLine(): Boolean`: Checks if the line is empty (no item number and zero quantity).
- `InsertLine(): Boolean`: Determines if the line should be inserted into a sales document.
- `ShowDimensions()`: Opens the dimension set editing page for this standard sales line.
- `ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])`: Validates a shortcut dimension code for this standard sales line.
- `LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])`: Opens a lookup for a shortcut dimension code and validates the selection.
- `ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])`: Retrieves all eight shortcut dimension codes for this standard sales line.
- `FormatType(): Text[20]` (obsolete 29.0: Use FormatTypeAsText() instead.): Formats the line type for display, returning 'Comment' for blank types.
- `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)
- No.: TableRelation [Table 156 "Resource"](../table/156.md) (conditional)
- Standard Sales Code: TableRelation [Table 170 "Standard Sales Code"](../table/170.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 7 "Standard Text"](../table/7.md) (conditional)

## Pages and codeunits on this table

- [Page 171 "Standard Sales Code Subform"](../page/171.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, BC28-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 Sales Line")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.