Table 4405 "EXR Top Customer Report Buffer"
ExcelReports · Microsoft.Sales.ExcelReports
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 5 connected objects and pages
ExcelReports · Microsoft.Sales.ExcelReports · captioned “Top Customer Data” · BC29-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Top Customer Data |
| Access | Internal |
| TableType | Temporary |
| 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] | — | TableRelation Table 18 “Customer” |
| 2 | Customer Name | Text[200] | Name caption | |
| 10 | Amount (LCY) | Decimal | — | |
| 12 | Amount 2 (LCY) | Decimal | — | |
| 13 | Ranking Based On | Option | — | OptionCaption: Sales (LCY), Balance (LCY) |
| 44 | Customer Posting Group | Code[20] | — | TableRelation Table 92 “Customer Posting Group” (Customer Posting Group); FlowFilter |
| 45 | Currency Code | Code[10] | — | TableRelation Table 4 “Currency”; FlowFilter |
| 46 | Period Start Date | Date | — | |
| 100 | Date Filter | Date | — | FlowFilter |
| 101 | Global Dimension 1 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter |
| 102 | Global Dimension 2 Filter | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter |
Keys
- PK: Customer No., Period Start Date, Amount (LCY) (clustered)
Events published
OnGetAmount1Caption(var Handled: Boolean; var NewCaption: Text)(integration)- subscribers: Codeunit 4405 “EXT Top Cust. Caption Handler” GetAmount1Caption
OnGetAmount2Caption(var Handled: Boolean; var NewCaption: Text)(integration)- subscribers: Codeunit 4405 “EXT Top Cust. Caption Handler” GetAmount2Caption
Procedures
2 local procedures, no public ones.
Relations
- Customer No.: TableRelation Table 18 “Customer”
- Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
- Currency Code: TableRelation Table 4 “Currency”
- Customer Posting Group: TableRelation Table 92 “Customer Posting Group”
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: "EXR Top Customer Report Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.