Računica merenja performansi (prozor ID-213)

prozor: Računica merenja performansi

opis: Definisanje kako izračunavate merenje performansi

pomoć: The Performance Measure Calculation defines how performance measures will be calculated. The sql needs to return a single value. Please check examples.
The date trestriction is defined in the Goal. Any restrictions for Organizations, Business Partners, Products, etc. are as Performance Goal Restrictions.

TAB: Računica merenja performansi

opis: Maintain your Performance Measure Calculation

pomoć The Performance Measure Calculation defines how performance measures will be calculated. See examples.
The SELECT definition must contain the SELECT and FROM keywords in upper case, the WHERE definition must contain the WHERE keyword in upper case. The main table must not have an alias! The WHERE clause can only contain values of the main table (e.g. when selecting from Header and lines, only header variables can be used in the where clause) and be fully qualified if there is more then one table.

Datoteka:Računica merenja performansi - Računica merenja performansi - prozor (iDempiere 1.0.0).png

ime	ime	opis	pomoć	Specifikacije
Client	Klijent	Klijent/zakupac za ovu instalaciju.	Klijent je firma ili pravno lice Ne možete da delite podatke između klijenata. Zakupac je sinonim za klijenta	AD_Client_ID numeric(10) NOT NULL Table Direct
Organization	Organizacija	Organizacioni entitet unutar klijenta	Organizacija je organizaciona jedinica klijenta ili pravni entitit - npr. prodavnica, odeljenje Podaci između organizacija su zajednički.	AD_Org_ID numeric(10) NOT NULL Table Direct
Name	Naziv	Alfanumerički identifikator entiteta.	Naziv entiteta (sloga) se koristi prilikom osnovne pretrage kao dodatna opcija uz ključnu reč - id broj. Naziv može biti dužine do 60 karaktera.	Name character varying(60) NOT NULL String
Description	Opis	Optional short description of the record	Opis je ograničen na 255 karaktera.	Description character varying(255) String
Active	Aktivan	Slog je aktivan u sistemu.	Postoje dva glavna metoda da se slog učini nedostupnim unutar sistema: jedan je da se obriše slog, a drugi je da se slog de-aktivira. Deaktiviran slog nije dostupan za izbor, ali je dostupan za izveštaje. Postoje dva razloga za de-aktiviranje sloga, a ne brisanje: (1) Sistemu je potreban slog za potrebe kontrole/provere. (2) Ovaj slog je povezan sa drugim slogom. Npr., ne možete obrisati poslovnog partnera, ako postoje fakture u kojima se pojavljuje isti. Vi deaktivirate poslovnog partnera i na taj način sprečavate da se on koristi prilikom budućeg unosa nekog dokumenta.	IsActive character(1) NOT NULL Yes-No
Entity Type	Vrsta entiteta	Dictionary Entity Type; Determines ownership and synchronization	The Entity Types "Dictionary", "Adempiere" and "Application" might be automatically synchronized and customizations deleted or overwritten. For customizations, copy the entity and select "User"!	EntityType character varying(40) NOT NULL Table
Sql SELECT	Sql SELECT	SQL SELECT clause	The Select Clause indicates the SQL SELECT clause to use for selecting the record for a measure calculation. Do not include the SELECT itself.	SelectClause character varying(2000) NOT NULL Text
Sql WHERE	Sql WHERE	Fully qualified SQL WHERE clause	The Where Clause indicates the SQL WHERE clause to use for record selection. The WHERE clause is added to the query. Fully qualified means "tablename.columnname".	WhereClause character varying(2000) NOT NULL Text
Date Column	Kolona datum	Fully qualified date column	The Date Column indicates the date to be used when calculating this measurement	DateColumn character varying(60) NOT NULL String
Org Column	Org Column	Fully qualified Organization column (AD_Org_ID)	The Organization Column indicates the organization to be used in calculating this measurement.	OrgColumn character varying(60) String
B.Partner Column	B.Partner Column	Fully qualified Business Partner key column (C_BPartner_ID)	The Business Partner Column indicates the Business Partner to use when calculating this measurement	BPartnerColumn character varying(60) String
Product Column	Proizvod kolona	Fully qualified Product column (M_Product_ID)	The Product Column indicates the product to use to use when calculating this measurement.	ProductColumn character varying(60) String
Table	Tabela	Database Table information	The Database Table provides the information of the table definition	AD_Table_ID numeric(10) NOT NULL Table Direct
Key Column	Ključ kolona	Ključ kolona za tabelu	null	KeyColumn character varying(60) NOT NULL String