Toolbox

Main Page

Upload file

What links here

Recent changes

Help

Search

Participate

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

C_ValidCombination

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

Name:FinancialMgmtAccountingCombination
Classname:AccountingCombination

This table contains the following columns:

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

C_VALIDCOMBINATION_ISACTIV_CHK: ISACTIVE IN ('Y', 'N')
C_VALIDCOMBINATION_ISFULLY_CHK: ISFULLYQUALIFIED IN ('Y', 'N')

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

C_VALIDCOMBINATION_ALIAS
- AD_Client_ID
- Alias
C_VALIDCOMBINATION_MAIN

Unique

C_VALIDCOMBINATION_KEY
- C_ValidCombination_ID

top

Columns

Accounting Combination

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

Physical column name: C_ValidCombination_ID
Property Name: id
Reference: ID

top

Client

Physical column name: AD_Client_ID
Property Name: client
Reference: TableDir
Default value: @AD_CLIENT_ID@

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

Physical column name: AD_Org_ID
Property Name: organization
Reference: Table
Default value: @AD_Org_ID@

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.

Physical column name: IsActive
Property Name: active
Reference: YesNo
Default value: Y

top

Creation Date

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

Physical column name: Created
Property Name: creationDate
Reference: DateTime

top

Created By

Physical column name: CreatedBy
Property Name: createdBy
Reference: Search

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

top

Updated

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

Physical column name: Updated
Property Name: updated
Reference: DateTime

top

Updated By

Physical column name: UpdatedBy
Property Name: updatedBy
Reference: Search

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.

Physical column name: Alias
Property Name: alias
Reference: String

top

Combination

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

Physical column name: Combination
Property Name: combination
Reference: String
This column is part of the table's identifier

top

Description

A description is limited to 255 characters.

Physical column name: Description
Property Name: description
Reference: String

top

Fully Qualified

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

Physical column name: IsFullyQualified
Property Name: fullyQualified
Reference: YesNo

top

Accounting Schema

Physical column name: C_AcctSchema_ID
Property Name: accountingSchema
Reference: TableDir

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

top

Account

Physical column name: Account_ID
Property Name: account
Reference: Table

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

Physical column name: M_Product_ID
Property Name: product
Reference: Search

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

top

Business Partner

Physical column name: C_BPartner_ID
Property Name: businessPartner
Reference: Search

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

top

Trx Organization

Physical column name: AD_OrgTrx_ID
Property Name: trxOrganization
Reference: Table

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

Physical column name: C_LocFrom_ID
Property Name: locationFromAddress
Reference: Table

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

Reference Table C_Location

top

Location to Address

Physical column name: C_LocTo_ID
Property Name: locationToAddress
Reference: Table

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

Reference Table C_Location

top

Sales Region

Physical column name: C_SalesRegion_ID
Property Name: salesRegion
Reference: Table

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

Physical column name: C_Project_ID
Property Name: project
Reference: Table

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

Physical column name: C_Campaign_ID
Property Name: salesCampaign
Reference: Table

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

Reference Table C_Campaign

top

Activity

Physical column name: C_Activity_ID
Property Name: activity
Reference: Table

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.

Physical column name: User1_ID
Property Name: stDimension
Reference: String

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