Report Cube (Janela ID-53078)
Fonte: iDempiere pt
Janela: Report Cube
Descrição: Define reporting cube for pre-calculation of summary accounting data.
Ajudar: Summary data will be generated for each period of the selected calendar, grouped by the selected dimensions..
TAB: Report Cube
Descrição: null
Ajudar null
Ficheiro:Report Cube - Report Cube - Janela (iDempiere 1.0.0).png
Nome | Nome | Descrição | Ajudar | Especificações |
---|---|---|---|---|
Client | Empresa | A Empresa instalada neste sistema. | A Empresa é a sociedade, grupo empresarial ou qualquer outra entidade legal instalada neste sistema. Não é possivel partilhar dados entre Empresas. | AD_Client_ID numeric(10) NOT NULL Table Direct |
Organization | Organismo | Unidade organizacional componente da Empresa | A estrutura é uma das unidades organizacionais que constituem a Empresa, estas entidades podem ter figura juridica ou serem meras abstracções de um modelo de organização empresarial. Como exemplos podemos citar o sector, departamento, armazem, loja ou empresa associada. É possivél e normal partilhar dados entre estruturas. | AD_Org_ID numeric(10) NOT NULL Table Direct |
Name | Nome | 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 | Descrição | Optional short description of the record | A description is limited to 255 characters. | Description character varying(255) Text |
Calendar | Calendário | 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 | Activo | 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 | A Processar | null | null | Processing character(1) NOT NULL Yes-No |