Acc. Sched. KPI Web Srv. Setup

Diagrams

Table

Acc. Sched. KPI Web Srv. Setup

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

#	Name	Type
1	Primary Key (Primary Key)	Code10
2	Forecasted Values Start (Forecasted Values Start)	Option	[After Latest Closed Period,After Current Date]
3	G/L Budget Name (G/L Budget Name)	Code10	TableRelation: "G/L Budget Name"
4	Period (Period)	Option	[Fiscal Year - Last Locked Period,Current Fiscal Year,Current Calendar Year,Current Calendar Quarter,Current Month,Today,Current Period,Last Locked Period,Current Fiscal Year + 3 Previous Years]
5	View By (View By)	Option	[Day,Week,Month,Quarter,Year,Period]
6	Web Service Name (Web Service Name)	Text240
7	Published (Published)	Boolean	CalcFormula: Exist("Web Service" WHERE (Object Type=CONST(Page), Object ID=CONST(197), Published=CONST(Yes)));	Editable: No FlowField

Keys

#	Fields
0	Primary Key (Primary Key)		Clustered: Yes

Table Relations To Other Tables

Field	Related Table	Related Field
G/L Budget Name (G/L Budget Name)	G/L Budget Name	Name (Name)	TableRelation: "G/L Budget Name"	1..n

Table Relations From Other Tables

From Table	From Field