View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Show collection (0 pages)
Collections help

Search

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.report/AD AccountingRpt Element

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.report

Index

Contents

AD_AccountingRpt_Element

Elements that will compose an accounting report. Allows user to configure his own accounting report.

This table contains the following columns:

Name Nullable Data Type Description
AD_Accountingrpt_Element_ID NVARCHAR2(32)Accounting report element
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
IsActive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
Name YVARCHAR2(510)A non-unique identifier for a record/document often used as a search tool.
Description YVARCHAR2(510)A space to write additional related information.
IsSummary NCHAR(1)A means of grouping fields in order to view or hide additional information.
Isshown NCHAR(1)Shown.
Filteredbyorganization YCHAR(1)null
TemporaryFilterType YVARCHAR2(60)null
Account_ID YVARCHAR2(32)The identification code used for accounting.
C_AcctSchema_ID YVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
IsReport YCHAR(1)An indication whether something is a document, or a report which summarizes information.
Report_Type YVARCHAR2(60)Report Type
Isinitialbalance YCHAR(1)If checked the system will automatically calculate the opening balance for the fiscal year (regardless of whether the period is monthly or quarterly).

Other Info

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

AD_Accountingrpt_Element_ID

Element that will be part of an accounting report.

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Active

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 reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)

top

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

top

Description

A description is limited to 255 characters.

top

Summary Level

A summary entity represents a branch in a tree rather than an end-node. Summary entities are used for reporting and do not have own values.

top

Shown

Element will be displayed.

top

Filtered by Organization

top

Reporting Interval

List values: Accounting period

The allowed values for this list are:

top

Account

Foreign key column to C_ElementValue table, (column: C_ElementValue_ID)


Reference Table C_ElementValue (Accounts) With the following where clause:

 
C_ElementValue.IsSummary='N'


Validation Rule Current acctschema: For current acctschema. With the following code:

 
EXISTS (SELECT 1 FROM C_ACCTSCHEMA_ELEMENT WHERE C_ACCTSCHEMA_ELEMENT.ELEMENTTYPE='AC' AND C_ACCTSCHEMA_ELEMENT.C_ELEMENT_ID=C_ELEMENTVALUE.C_ELEMENT_ID AND C_ACCTSCHEMA_ELEMENT.C_Acctschema_ID=@C_Acctschema_ID@)

top

Accounting Schema

Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top

Report

The Report checkbox indicates that this record is a report as opposed to a process

top

Report Type

Refers to the way that this report is gong to calculate the amount for this entry.

List values: Accounting report type

The allowed values for this list are:

top

Year Initial Balance

If checked the system will automatically calculate the opening balance for the fiscal year (regardless of whether the period is monthly or quarterly).

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.accounting.report/AD_AccountingRpt_Element"

This page has been accessed 2,146 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.