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.coa/C ValidCombination

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

Index

Contents

C_ValidCombination

The Account Combination Tab defines and displays valid account combination. An Alias can be defined to facilitate document entry.

This table contains the following columns:

Name Nullable Data Type Description
C_ValidCombination_ID NVARCHAR2(32)An identification code comprised of an individual account number and additional dimensions such organization, product, and business partner.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
Alias YNVARCHAR2(40)Defines an alternate method of indicating an account combination.
Combination YNVARCHAR2(120)Unique combination of account elements
Description YNVARCHAR2(255)A space to write additional related information.
IsFullyQualified NCHAR(1)This account is fully qualified
C_AcctSchema_ID NVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
Account_ID NVARCHAR2(32)The identification code used for accounting.
M_Product_ID YVARCHAR2(32)An item produced by a process.
C_BPartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
AD_OrgTrx_ID YVARCHAR2(32)The organization which performs or initiates the transaction.
C_LocFrom_ID YVARCHAR2(32)The location where items are sent from.
C_LocTo_ID YVARCHAR2(32)The location where items are sent to.
C_SalesRegion_ID YVARCHAR2(32)A defined section of the world where sales efforts will be focused.
C_Project_ID YVARCHAR2(32)Identifier of a project defined within the Project & Service Management module.
C_Campaign_ID YVARCHAR2(32)An advertising effort aimed at increasing sales.
C_Activity_ID YVARCHAR2(32)A distinct activity defined and used in activity based management.
User1_ID YVARCHAR2(32)A display of optional elements that are previously defined for this account combination.
User2_ID YVARCHAR2(32)A display of optional elements that are previously defined for this account combination.

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

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

Non Unique

Unique

top

Columns

Accounting Combination

The Combination identifies a valid combination of element which represent a GL account.

top

Client

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


Validation Rule AD_Client Trx Security validation: null. With the following code:

 
AD_Client.AD_Client_ID<>'0'

top

Organization

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


Reference Table AD_Org (all)

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

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

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

Alias

The Alias field allows you to define a alternate method for referring to a full account combination. For example, the Account Receivable Account for Garden World may be aliased as GW_AR.

top

Combination

The Combination field defines the unique combination of element values which comprise this account.

top

Description

A description is limited to 255 characters.

top

Fully Qualified

The Fully Qualified check box indicates that all required elements for an account combination are present.

top

Accounting Schema

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

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 C_Accounts: based on C_AcctSchema_ID. With the following code:

 
EXISTS (SELECT * FROM C_AcctSchema_Element ae WHERE C_ElementValue.C_Element_ID=ae.C_Element_ID AND ae.ElementType='AC' AND ae.C_AcctSchema_ID=@C_AcctSchema_ID@)

top

Product

Foreign key column to M_Product table, (column: M_Product_ID)

top

Business Partner

Foreign key column to C_BPartner table, (column: C_BPartner_ID)

top

Trx Organization

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


Reference Table AD_Org (Trx) With the following where clause:

 
AD_Org.IsSummary='N' AND AD_Org_ID <> '0'


top

Location from Address

Foreign key column to C_Location table, (column: C_Location_ID)


Reference Table C_Location

top

Location to Address

Foreign key column to C_Location table, (column: C_Location_ID)


Reference Table C_Location

top

Sales Region

Foreign key column to C_SalesRegion table, (column: C_SalesRegion_ID)


Reference Table C_Sales Region With the following where clause:

 
C_SalesRegion.IsSummary='N'


top

Project

Foreign key column to C_Project table, (column: C_Project_ID)


Reference Table C_Project With the following where clause:

 
C_Project.IsSummary='N'


top

Sales Campaign

Foreign key column to C_Campaign table, (column: C_Campaign_ID)


Reference Table C_Campaign

top

Activity

Foreign key column to C_Activity table, (column: C_Activity_ID)


Reference Table C_Activity

top

1st Dimension

The user defined element displays the optional elements that have been defined for this account combination.

Validation Rule C_Accounts User1: based on C_AcctSchema_ID. With the following code:

 
EXISTS (SELECT * FROM C_AcctSchema_Element ae WHERE C_ElementValue.C_Element_ID=ae.C_Element_ID AND ae.ElementType='U1' AND ae.C_AcctSchema_ID=@C_AcctSchema_ID@)

top

2nd Dimension

The user defined element displays the optional elements that have been defined for this account combination.

Validation Rule C_Accounts User2: based on C_AcctSchema_ID. With the following code:

 
EXISTS (SELECT * FROM C_AcctSchema_Element ae WHERE C_ElementValue.C_Element_ID=ae.C_Element_ID AND ae.ElementType='U2' AND ae.C_AcctSchema_ID=@C_AcctSchema_ID@)

top

Related tables

Tables that link this table:

top

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

This page has been accessed 1,440 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.