Table 7136 "Item Budget Buffer"

Base Application · Microsoft.Inventory.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Item Budget Buffer
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	Item No.	Code[20]	—	TableRelation Table 27 “Item”; DataClassification SystemMetadata
2	Source Type	Enum “Analysis Source Type”	—	enum Enum 7131 “Analysis Source Type”; DataClassification SystemMetadata
3	Source No.	Code[20]	—	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); DataClassification SystemMetadata
4	Location Code	Code[10]	—	TableRelation Table 14 “Location”; DataClassification SystemMetadata
5	Global Dimension 1 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); DataClassification SystemMetadata
6	Global Dimension 2 Code	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); DataClassification SystemMetadata
7	Budget Dimension 1 Code	Code[20]	—	DataClassification SystemMetadata
8	Budget Dimension 2 Code	Code[20]	—	DataClassification SystemMetadata
9	Budget Dimension 3 Code	Code[20]	—	DataClassification SystemMetadata
10	Date	Date	—	DataClassification SystemMetadata
11	Quantity Δ BC28	Decimal	—	DataClassification SystemMetadata
12	Sales Amount Δ BC28	Decimal	—	DataClassification SystemMetadata
13	Cost Amount Δ BC28	Decimal	—	DataClassification SystemMetadata
480	Dimension Set ID	Integer	—	TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable; DataClassification SystemMetadata

Keys

Key1: Item No., Source Type, Source No., Location Code, Global Dimension 1 Code, Global Dimension 2 Code, Budget Dimension 1 Code, Budget Dimension 2 Code, Budget Dimension 3 Code, Date (clustered)

Relations

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”

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: "Item Budget Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.