Report Cube (Venster ID-53078)

Uit iDempiere nl
Ga naar:navigatie, zoeken



Venster: Report Cube

Beschrijving: Define reporting cube for pre-calculation of summary accounting data.

Help: Summary data will be generated for each period of the selected calendar, grouped by the selected dimensions..



TAB: Report Cube

Beschrijving: null


Help null


Bestand:Report Cube - Report Cube - Venster (iDempiere 1.0.0).png




Naam Naam Beschrijving Help Specificaties
Client Client Client/Tenant for this installation. A Client is a company or a legal entity. You cannot share data between Clients. Tenant is a synonym for Client. AD_Client_ID
numeric(10) NOT NULL
Table Direct
Organization Organization Organizational entity within client An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. AD_Org_ID
numeric(10) NOT NULL
Table Direct
Name Name Alphanumeric identifier of the entity The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length. Name
character varying(60) NOT NULL
String
Description Beschrijving Optional short description of the record A description is limited to 255 characters. Description
character varying(255)
Text
Calendar Agenda Accounting Calendar Name The Calendar uniquely identifies an accounting calendar. Multiple calendars can be used. For example you may need a standard calendar that runs from Jan 1 to Dec 31 and a fiscal calendar that runs from July 1 to June 30. C_Calendar_ID
numeric(10) NOT NULL
Table Direct
Active Actief The record is active in the system There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reports.

There are two reasons for de-activating and not deleting records: (1) The system requires the record for audit purposes. (2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are invoices for this partner record existing. You de-activate the Business Partner and prevent that this record is used for future entries.

IsActive
character(1)
Yes-No
Product Dimension Product Dimension Include Product as a cube dimension null IsProductDim
character(1)
Yes-No
Business Partner Dimension Business Partner Dimension Include Business Partner as a cube dimension null IsBPartnerDim
character(1)
Yes-No
Sales Region Dimension Sales Region Dimension Include Sales Region as a cube dimension null IsSalesRegionDim
character(1)
Yes-No
OrgTrx Dimension OrgTrx Dimension Include OrgTrx as a cube dimension null IsOrgTrxDim
character(1)
Yes-No
Activity Dimension Activity Dimension Include Activity as a cube dimension null IsActivityDim
character(1)
Yes-No
Campaign Dimension Campaign Dimension Include Campaign as a cube dimension null IsCampaignDim
character(1)
Yes-No
Project Dimension Project Dimension Include Project as a cube dimension null IsProjectDim
character(1)
Yes-No
Project Phase Dimension Project Phase Dimension Include Project Phase as a cube dimension null IsProjectPhaseDim
character(1)
Yes-No
Project Task Dimension Project Task Dimension Include Project Task as a cube dimension null IsProjectTaskDim
character(1)
Yes-No
GL Budget Dimension GL Budget Dimension Include GL Budget as a cube dimension null IsGLBudgetDim
character(1)
Yes-No
Location From Dimension Location From Dimension Include Location From as a cube dimension null IsLocFromDim
character(1)
Yes-No
Location To Dimension Location To Dimension Include Location To as a cube dimension null IsLocToDim
character(1)
Yes-No
Sub Acct Dimension Sub Acct Dimension Include Sub Acct as a cube dimension null IsSubAcctDim
character(1)
Yes-No
User 1 Dimension User 1 Dimension Include User 1 as a cube dimension null IsUser1Dim
character(1)
Yes-No
User 2 Dimension User 2 Dimension Include User 2 as a cube dimension null IsUser2Dim
character(1)
Yes-No
User Element 1 Dimension User Element 1 Dimension Include User Element 1 as a cube dimension null IsUserElement1Dim
character(1)
Yes-No
User Element 2 Dimension User Element 2 Dimension Include User Element 2 as a cube dimension null IsUserElement2Dim
character(1)
Yes-No
Last Recalculated Last Recalculated The time last recalculated. null LastRecalculated
timestamp without time zone
Date+Time
Process Now Process Now null null Processing
character(1) NOT NULL
Yes-No


Contributions / Posts

Cookies helpen ons onze services aan te bieden. Door onze services te gebruiken stemt u in met het gebruik van onze cookies.