Table 7136 Item Budget BufferSetup BC Server URL to get a link to the data

Fields

#	Name ・Caption	Type
1 PK	Item No.	Code20	TableRelation Item Refers To Item CaptionML ENU=Item No.
2 PK	Source Type	Option	CaptionML ENU=Source Type OptionCaptionML ENU=" ,Customer,Vendor,Item" OptionString [ ,Customer,Vendor,Item]
3 PK	Source No.	Code20	TableRelation IF (Source Type=CONST(Customer)) Customer ELSE IF (Source Type=CONST(Vendor)) Vendor ELSE IF (Source Type=CONST(Item)) Item; Refers To Customer Vendor Item CaptionML ENU=Source No.
4 PK	Location Code	Code10	TableRelation Location Refers To Location CaptionML ENU=Location Code
5 PK	Global Dimension 1 Code	Code20	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1)) Refers To Dimension Value CaptionClass '1,1,1' CaptionML ENU=Global Dimension 1 Code
6 PK	Global Dimension 2 Code	Code20	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2)) Refers To Dimension Value CaptionClass '1,1,2' CaptionML ENU=Global Dimension 2 Code
7 PK	Budget Dimension 1 Code	Code20	CaptionML ENU=Budget Dimension 1 Code
8 PK	Budget Dimension 2 Code	Code20	CaptionML ENU=Budget Dimension 2 Code
9 PK	Budget Dimension 3 Code	Code20	CaptionML ENU=Budget Dimension 3 Code
10 PK	Date	Date	CaptionML ENU=Date
11	Quantity	Decimal	CaptionML ENU=Quantity DecimalPlaces 0:5
12	Sales Amount	Decimal	CaptionML ENU=Sales Amount AutoFormatType 1
13	Cost Amount	Decimal	CaptionML ENU=Cost Amount AutoFormatType 1
480	Dimension Set ID	Integer	NotEditable TableRelation "Dimension Set Entry" Refers To CaptionML ENU=Dimension Set ID

Name	Fields
0	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

From Field	To Table	To Field
Source No.	Customer	No.	TableRelation IF (Source Type=CONST(Customer)) Customer ELSE IF (Source Type=CONST(Vendor)) Vendor ELSE IF (Source Type=CONST(Item)) Item; n:1
Global Dimension 1 Code	Dimension Value	Code	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(1)) 1:1
Global Dimension 2 Code	Dimension Value	Code	TableRelation "Dimension Value".Code WHERE (Global Dimension No.=CONST(2)) 1:1
Item No.	Item	No.	TableRelation Item n:1
Source No.	Item	No.	TableRelation IF (Source Type=CONST(Customer)) Customer ELSE IF (Source Type=CONST(Vendor)) Vendor ELSE IF (Source Type=CONST(Item)) Item; n:1
Location Code	Location	Code	TableRelation Location n:1
Source No.	Vendor	No.	TableRelation IF (Source Type=CONST(Customer)) Customer ELSE IF (Source Type=CONST(Vendor)) Vendor ELSE IF (Source Type=CONST(Item)) Item; n:1