Table 7134 "Item Budget Entry"
Base Application · Microsoft.Inventory.Analysis
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC2817 fields changed
- BC29-30unchanged
Neighbourhood 12 connected objects and pages
Base Application · Microsoft.Inventory.Analysis · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 7133 “Item Budget Entries” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Item Budget Entry |
| 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 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 2 | Analysis Area | Enum “Analysis Area Type” | — | enum Enum 7130 “Analysis Area Type”; NotBlank |
| 3 | Budget Name Δ BC28 | Code[10] | Specifies the name of the item budget that the entry belongs to. | TableRelation Table 7132 “Item Budget Name” (“Item Budget Name”.Name where(“Analysis Area” = field(“Analysis Area”))) |
| 4 | Date Δ BC28 | Date | Specifies the date of this item budget entry. | |
| 5 | Item No. Δ BC28 | Code[20] | Specifies the number of the item that this budget entry applies to. | TableRelation Table 27 “Item” |
| 6 | Source Type Δ BC28 | Enum “Analysis Source Type” | Specifies the source type of this budget entry. | enum Enum 7131 “Analysis Source Type” |
| 7 | Source No. Δ BC28 | Code[20] | Specifies the number of the source document that the entry originates from. | TableRelation Table 18 “Customer”, Table 23 “Vendor”, Table 27 “Item” (if (“Source Type” = const(Customer)) Customer else if (“Source Type” = const(Vendor)) Vendor else if (“Source Type” = const(Item)) Item) |
| 8 | Description Δ BC28 | Text[100] | Specifies a description of the budget figure. | |
| 9 | Quantity Δ BC28 | Decimal | Specifies the quantity of this item budget entry. | |
| 10 | Cost Amount Δ BC28 | Decimal | Specifies the cost amount of this item budget entry. | |
| 11 | Sales Amount Δ BC28 | Decimal | Specifies the sales amount of this item budget line entry. | |
| 13 | User ID | Code[50] | — | TableRelation User.“User Name”; not editable; DataClassification EndUserIdentifiableInformation |
| 14 | Location Code Δ BC28 | Code[10] | Specifies the code for the location that this item budget entry is linked to. | TableRelation Table 14 “Location” |
| 15 | Global Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 16 | Global Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 17 | Budget Dimension 1 Code Δ BC28 | Code[20] | Specifies the dimension value code for the Budget Dimension 1 code that this item budget entry is linked to. | |
| 18 | Budget Dimension 2 Code Δ BC28 | Code[20] | Specifies the dimension value code for the Budget Dimension 2 code that this item budget entry is linked to. | |
| 19 | Budget Dimension 3 Code Δ BC28 | Code[20] | Specifies the dimension value code for the Budget Dimension 3 Code that this item budget entry is linked to. | |
| 480 | Dimension Set ID Δ BC28 | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: Analysis Area, Budget Name, Item No., Source Type, Source No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code
- Key3: Analysis Area, Budget Name, Source Type, Source No., Item No., Date, Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code
- Key4: Analysis Area, Budget Name, Item No., Date
Events published
OnInsertOnBeforeCheckGroupDimFilled(var ItemBudgetEntry: Record "Item Budget Entry"; var IsHandled: Boolean)(integration)
Procedures
GetLastEntryNo(): IntegerGetCaptionClass(BudgetDimType: Integer): Text[250]GetCaption(): Text[1024]ShowDimensions()
Plus 9 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- drill-down page Page 7133 “Item Budget Entries”
- lookup page Page 7133 “Item Budget Entries”
- Location Code: TableRelation Table 14 “Location”
- Source No.: TableRelation Table 18 “Customer” (conditional)
- Source No.: TableRelation Table 23 “Vendor” (conditional)
- Item No.: TableRelation Table 27 “Item”
- Source No.: TableRelation Table 27 “Item” (conditional)
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Budget Name: TableRelation Table 7132 “Item Budget Name”
Referenced by
3 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 5821 “Item Statistics Buffer”: Budgeted Cost Amount, Budgeted Quantity, Budgeted Sales Amount
Pages and codeunits on this table
- Page 7133 “Item Budget Entries” (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” (7 calls:
OnInsert → GetDimensionSet,OnInsert → GetDimensionSetID,OnModify → GetDimensionSet, …) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
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: "Item Budget Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.