ManPageW ReportingHierarchy
Enjoy it, and help to fill it! But please, always respecting copyright.
Please write your contributions under the Contributions Section
Window: Reporting Hierarchy
Description : Define Reporting Hierarchy
Help : Reporting Hierarchy allows you to select different Hierarchies/Trees for the report. Accounting Segments like Organization, Account, Product may have several hierarchies to accomodate different views on the business
Tab: Reporting Hierarchy
Description : Reporting Hierarchy
Help : Reporting Hierarchy allows you to select different Hierarchies/Trees for the report. Accounting Segments like Organization, Account, Product may have several hierarchies to accomodate different views on the business
Table Name : PA_Hierarchy
Fields
Name | Description | Help | Technical Data |
---|---|---|---|
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
NUMBER(10) TableDir |
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
NUMBER(10) TableDir |
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
NVARCHAR2(60) String |
Description | Optional short description of the record | A description is limited to 255 characters. | Description
NVARCHAR2(255) String |
Comment/Help | Comment or Hint | The Help field contains a hint, comment or help about the use of this item. | Help
NVARCHAR2(2000) Text |
Active | 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
CHAR(1) YesNo |
Organization Tree | Tree to determine organizational hierarchy | Trees are used for (finanial) reporting and security access (via role) | AD_Tree_Org_ID
NUMBER(10) Table |
Account Tree | Tree for Natural Account Tree | AD_Tree_Account_ID
NUMBER(10) Table | |
Activity Tree | Tree to determine activity hierarchy | Trees are used for (finanial) reporting | AD_Tree_Activity_ID
NUMBER(10) Table |
BPartner Tree | Tree to determine business partner hierarchy | Trees are used for (finanial) reporting | AD_Tree_BPartner_ID
NUMBER(10) Table |
Product Tree | Tree to determine product hierarchy | Trees are used for (finanial) reporting | AD_Tree_Product_ID
NUMBER(10) Table |
Project Tree | Tree to determine project hierarchy | Trees are used for (finanial) reporting | AD_Tree_Project_ID
NUMBER(10) Table |
Campaign Tree | Tree to determine marketing campaign hierarchy | Trees are used for (finanial) reporting | AD_Tree_Campaign_ID
NUMBER(10) Table |
Sales Region Tree | Tree to determine sales regional hierarchy | Trees are used for (finanial) reporting | AD_Tree_SalesRegion_ID
NUMBER(10) Table |