Table 9150 "My Customer"
Base Application · Microsoft.Sales.Customer
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC264 fields changed
- BC27unchanged
- BC281 fields changed
- BC291 fields changed
- BC30unchanged
Neighbourhood 3 connected objects and pages
Base Application · Microsoft.Sales.Customer · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | My Customer |
| 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 | User ID | Code[50] | — | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 2 | Customer No. Δ BC26 | Code[20] | Specifies the customer numbers that are displayed in the My Customer Cue on the Role Center. | TableRelation Table 18 “Customer”; NotBlank |
| 3 | Name Δ BC26 | Text[100] | Specifies the name of the customer. | not editable |
| 4 | Phone No. Δ BC26 | Text[30] | Specifies the customer’s phone number. | not editable |
| 5 | Balance (LCY) Δ BC26 Δ BC28 Δ BC29 | Decimal | Specifies the payment amount that the customer owes for completed sales. | FlowField: sum(“Detailed Cust. Ledg. Entry”.“Amount (LCY)” where(“Customer No.” = field(“Customer No.”), “Excluded from calculation” = const(false))); not editable |
Keys
- Key1: User ID, Customer No. (clustered)
- Key2: Name
- Key3: Phone No.
Procedures
SetCustomerFields(): Populates the Name and Phone No. fields from the related Customer record.
Relations
- Customer No.: TableRelation Table 18 “Customer”
- Balance (LCY): CalcFormula Table 379 “Detailed Cust. Ledg. Entry”
Pages and codeunits on this table
- Page 9150 “My Customers” (source table)
Recent changes
- 2026-07-20 #9089 Merge-ES-Excluded-from-Calculation-to-W1 (main, BC30, feature)
Ask your agent
Procedure bodies are not stored here (D10). 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: "My Customer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.