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


Contributions / Posts

Os cookies ajudam-nos a fornecer os nossos serviços. Ao navegar no sítio, está a consentir o uso de cookies.