---
id: object/table/172
type: object
title: Table 172 "Standard Customer Sales Code"
summary: Table 172 "Standard Customer Sales Code" in Base Application (Microsoft.Sales.Document). 14 fields, 9 public procedures, 18 events. Present since at least BC23, still in BC30, changed in BC24, BC27-28.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "28"
  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: 619b2239f6680bb3b35684fdd5a4285eb58178f136f93250a69a1a549b77a8da
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Sales/Document/StandardCustomerSalesCode.Table.al
    title: src/Layers/W1/BaseApp/Sales/Document/StandardCustomerSalesCode.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 172
name: Standard Customer Sales Code
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"
  - "27"
  - "28"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 14
  procedures: 28
  events: 18
  subscribers: 0
relations:
  out: 6
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 3
  called_by: 0
  implements: 0
---

# Table 172 "Standard Customer Sales Code"

> Table 172 "Standard Customer Sales Code" in Base Application (Microsoft.Sales.Document). 14 fields, 9 public procedures, 18 events. Present since at least BC23, still in BC30, changed in BC24, BC27-28.

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

## Properties

| Property | Value |
|---|---|
| Caption | Standard Customer Sales Code |
| 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 | Customer No. | Code[20] | Specifies the customer number of the customer to which the standard sales code is assigned. | TableRelation [Table 18 "Customer"](../table/18.md); NotBlank |
| 2 | Code | Code[10] | Specifies a standard sales code from the Standard Sales Code table. | TableRelation [Table 170 "Standard Sales Code"](../table/170.md) (Standard Sales Code); NotBlank |
| 3 | Description | Text[100] | Specifies a description of the standard sales code. |  |
| 4 | Valid From Date | Date | Specifies the first day when the Create Recurring Sales Inv. batch job can be used to create sales invoices. |  |
| 5 | Valid To date | Date | Specifies the last day when the Create Recurring Sales Inv. batch job can be used to create sales invoices. |  |
| 6 | Payment Method Code | Code[10] | Specifies how to make payment, such as with bank transfer, cash, or check. | TableRelation [Table 289 "Payment Method"](../table/289.md) (Payment Method) |
| 7 | Payment Terms Code | Code[10] | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. | TableRelation [Table 3 "Payment Terms"](../table/3.md) (Payment Terms) |
| 8 | Direct Debit Mandate ID | Code[35] | Specifies the ID of the direct-debit mandate that this standard customer sales code uses to create sales invoices for direct debit collection. | TableRelation [Table 1230 "SEPA Direct Debit Mandate"](../table/1230.md) ("SEPA Direct Debit Mandate" where("Customer No." = field("Customer No."), Blocked = const(false), Closed = const(false))) |
| 9 | Blocked | Boolean | Specifies that the related record is blocked from being posted in transactions, for example a customer that is declared insolvent or an item that is placed in quarantine. |  |
| 13 | Currency Code | Code[10] | — | TableRelation [Table 4 "Currency"](../table/4.md); not editable |
| 15 | Insert Rec. Lines On Quotes | Option | Specifies how you want to use standard sales codes on sales quotes. | OptionCaption: Manual,Automatic,Always Ask; DataClassification SystemMetadata |
| 16 | Insert Rec. Lines On Orders | Option | Specifies how you want to use standard sales codes on sales orders. | OptionCaption: Manual,Automatic,Always Ask; DataClassification SystemMetadata |
| 17 | Insert Rec. Lines On Invoices | Option | Specifies how you want to use standard sales codes on sales invoices. | OptionCaption: Manual,Automatic,Always Ask; DataClassification SystemMetadata |
| 18 | Insert Rec. Lines On Cr. Memos | Option | Specifies how you want to use standard sales codes on sales credit memos. | OptionCaption: Manual,Automatic,Always Ask; DataClassification SystemMetadata |

## Keys

- Key1: Customer No., Code (clustered)
- Key2: Code, Currency Code

## Events published

- `OnAfterCreateSalesInvoice(var SalesHeader: Record "Sales Header"; StandardCustomerSalesCode: Record "Standard Customer Sales Code")` (integration)
- `OnAfterCombineDimensions(var SalesLine: Record "Sales Line"; StdSalesLine: Record "Standard Sales Line")` (integration)
- `OnAfterApplyStdCodesToSalesLinesLoop(var StdSalesLine: Record "Standard Sales Line"; var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header"; StdSalesCode: Record "Standard Sales Code")` (integration)
- `OnBeforeApplyStdCodesToSalesLines(var SalesLine: Record "Sales Line"; StdSalesLine: Record "Standard Sales Line")` (integration)
- `OnBeforeApplyStdCodesToSalesLinesLoop(var StdSalesLine: Record "Standard Sales Line"; var SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header"; StdSalesCode: Record "Standard Sales Code")` (integration)
- `OnBeforeCreateSalesInvoice(var StandardCustomerSalesCode: Record "Standard Customer Sales Code"; OrderDate: Date; PostingDate: Date; var IsHandled: Boolean)` (integration)
- `OnBeforeStdCustSalesCodesSetTableView(var StandardCustomerSalesCode: Record "Standard Customer Sales Code"; var SalesHeader: Record "Sales Header")` (integration)
- `OnCreateSalesInvoiceOnBeforeSalesHeaderInsert(var SalesHeader: Record "Sales Header"; StandardCustomerSalesCode: Record "Standard Customer Sales Code")` (integration)
- `OnCreateSalesInvoiceOnBeforeSalesHeaderModify(var SalesHeader: Record "Sales Header"; StandardCustomerSalesCode: Record "Standard Customer Sales Code")` (integration)
- `OnAfterSalesLineInsert(var StdSalesLine: Record "Standard Sales Line"; var SalesLine: Record "Sales Line")` (integration)
- `OnBeforeApplyStdCodesToSalesLinesProcedure(var SalesHeader: Record "Sales Header"; StandardCustomerSalesCode: Record "Standard Customer Sales Code"; var IsHandled: Boolean)` (integration)
- `OnInsertSalesLineOnBeforeApplyStdCodesToSalesLines(StdCustSalesCode: Record "Standard Customer Sales Code")` (integration)
- `OnApplyStdCodesToSalesLinesOnAfterValidateSalesLineNo(StdCustSalesCode: Record "Standard Customer Sales Code"; var SalesLine: Record "Sales Line")` (integration)
- `OnApplyStdCodesToSalesLinesOnAfterSetSalesLineLineNo(var StdCustSalesCode: Record "Standard Customer Sales Code"; var SalesLine: Record "Sales Line"; var IsHandled: Boolean)` (integration)
- `OnApplyStdCodesToSalesLinesOnAfterInsertExtendedText(var StdCustSalesCode: Record "Standard Customer Sales Code"; var StdSalesLine: Record "Standard Sales Line"; var SalesLine: Record "Sales Line")` (integration)
- `OnApplyStdCodesToSalesLinesOnBeforeRoundUnitPrice(var SalesLine: Record "Sales Line"; StandardSalesLine: Record "Standard Sales Line"; var IsHandled: Boolean)` (integration)
- `OnApplyStdCodesToSalesLinesOnAfterValidateType(var SalesLine: Record "Sales Line"; var StandardSalesLine: Record "Standard Sales Line")` (integration)
- `OnAfterSetFilterByAutomaticAndAlwaysAskCodes(var StandardCustomerSalesCode: Record "Standard Customer Sales Code"; SalesHeader: Record "Sales Header")` (integration)

## Procedures

- `CreateSalesInvoice(OrderDate: Date; PostingDate: Date)`: Creates a sales invoice using the standard sales code for the customer.
- `InsertSalesLines(var SalesHeader: Record "Sales Header")`: Opens a page to select standard customer sales codes and inserts the selected lines into the sales header.
- `ApplyStdCodesToSalesLines(var SalesHeader: Record "Sales Header"; StdCustSalesCode: Record "Standard Customer Sales Code")`: Applies the standard sales code lines to the sales document.
- `InsertExtendedText(SalesLine: Record "Sales Line")`: Inserts extended text for a sales line if applicable.
- `InsertExtendedText(SalesLine: Record "Sales Line"; SalesHeader: Record "Sales Header")`: Inserts extended text for a sales line using the sales header context.
- `GetNextLineNo(SalesLine: Record "Sales Line"): Integer`: Gets the next available line number for a sales document.
- `SetFilterByAutomaticAndAlwaysAskCodes(SalesHeader: Record "Sales Header")`: Sets filters on the record to find standard sales codes that should be automatically or always-ask inserted.
- `IsInsertRecurringLinesOnDocumentAutomatic(SalesHeader: Record "Sales Header"): Boolean`: Checks if recurring lines should be automatically inserted for the document type.
- `ShouldAutoInsertRecurringLinesOnDocument(SalesHeader: Record "Sales Header"): Boolean`: Checks if recurring lines should be auto-inserted (automatic or always-ask) for the document type.

Plus 1 local procedures.

## Triggers

OnRename

## Relations

- Direct Debit Mandate ID: TableRelation [Table 1230 "SEPA Direct Debit Mandate"](../table/1230.md)
- Code: TableRelation [Table 170 "Standard Sales Code"](../table/170.md)
- Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- Payment Method Code: TableRelation [Table 289 "Payment Method"](../table/289.md)
- Payment Terms Code: TableRelation [Table 3 "Payment Terms"](../table/3.md)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)

## Pages and codeunits on this table

- [Page 173 "Standard Customer Sales Codes"](../page/173.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 378 "Transfer Extended Text"](../codeunit/378.md) (2 calls: `InsertExtendedText → InsertSalesExtText`, `InsertExtendedText → SalesCheckIfAnyExtText`)
- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (1 call: `CombineDimensions → GetCombinedDimensionSetID`)
- [Codeunit 5720 "Item Reference Management"](../codeunit/5720.md) (1 call: `ApplyStdCodesToSalesLines → EnterSalesItemReference`)

## Across versions

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

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 Customer Sales Code")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.