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

Contents 1 C_AcctSchema_Element 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Non Unique 1.1.2.2 Unique 1.2 Columns 1.2.1 Acct.Schema Element 1.2.2 Active 1.2.3 Creation Date 1.2.4 Created By 1.2.5 Updated 1.2.6 Organization 1.2.7 Updated By 1.2.8 Accounting Schema 1.2.9 Type 1.2.9.1 List values: C_AcctSchema ElementType 1.2.10 Name 1.2.11 Sequence Number 1.2.12 Accounting Element 1.2.13 Client 1.2.14 Mandatory 1.2.15 Balanced 1.2.16 Trx Organization 1.2.17 Account Element 1.2.18 Product 1.2.19 Business Partner 1.2.20 Location / Address 1.2.21 Sales Region 1.2.22 Project 1.2.23 Sales Campaign 1.2.24 Activity

C_AcctSchema_Element

The Account Schema Element defines the elements that comprise the account key. A name is defined which will display in documents. Also the order of the elements and if they are balanced and mandatory are indicated.

• Name:FinancialMgmtAcctSchemaElement
• Classname:AcctSchemaElement

This table contains the following columns:

Name	Nullable	Data Type	Description
C_AcctSchema_Element_ID	N	VARCHAR2(32)	Acct.Schema Element
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
AD_Org_ID	N	VARCHAR2(32)	Organizational entity within client
UpdatedBy	N	VARCHAR2(32)	User who updated this records
C_AcctSchema_ID	N	VARCHAR2(32)	The structure used in accounting including costing methods, currencies, and the calendar.
ElementType	N	VARCHAR2(60)	A distinct item characteristic used for processes and sometimes grouped within a category.
Name	N	NVARCHAR2(60)	A non-unique identifier for a record/document often used as a search tool.
SeqNo	N	NUMBER(10, 0)	The order of records in a specified document.
C_Element_ID	Y	VARCHAR2(32)	A unique identifier for an account type.
AD_Client_ID	N	VARCHAR2(32)	Client for this installation.
IsMandatory	N	CHAR(1)	An indication noting that completing in a field is required to proceed.
IsBalanced	N	CHAR(1)	Balanced
Org_ID	Y	VARCHAR2(32)	Organizational entity within client
C_ElementValue_ID	Y	VARCHAR2(32)	A identification code for an account type.
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.
C_Location_ID	Y	VARCHAR2(32)	A specific place or residence.
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.

Other Info

Check constraints

These are the check constraints for this table:

• C_ACCTSCHEMA_ELEMENT_ISACT_CHK: ISACTIVE IN ('Y', 'N')
• C_ACCTSCHEMA_ELEMENT_ISBAL_CHK: ISBALANCED IN ('Y', 'N')
• C_ACCTSCHEMA_ELEMENT_ISMAN_CHK: ISMANDATORY 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_ACCTSCHEMA_ELEMENT_SCHEMA
  • C_AcctSchema_ID

Unique

• C_ACCTSCHEMA_ELEMENT_KEY
  • C_AcctSchema_Element_ID

top

Columns

Acct.Schema Element

The Account Schema Element defines each element that comprise the account key.

• Physical column name: C_AcctSchema_Element_ID
• Property Name: id
• Reference: 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.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo

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

Organization

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

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

top

Updated By

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

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

top

Accounting Schema

• Physical column name: C_AcctSchema_ID
• Property Name: accountingSchema
• Reference: TableDir
• This column is a child for a buisiness object (is Parent)

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

top

Type

The Element Type indicates if this element is the Account element or is a User Defined element.

• Physical column name: ElementType
• Property Name: type
• Reference: List

List values: C_AcctSchema ElementType

The allowed values for this list are:

• AC (Account): Natural Account
• AY (Activity)
• BP (Bus.Partner): Business Partner
• LF (Location From): Location From
• LT (Location To): Location To
• MC (Campaign): Marketing Campaign
• OO (Organization): Owning Organization
• OT (Trx. Org): Transaction Organization
• PJ (Project): Project
• PR (Product): Product
• SR (Sales Region): Sales Region
• U1 (User 1): User 1
• U2 (User 2): User 2

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.

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

top

Sequence Number

The Sequence indicates the order of records

• Physical column name: SeqNo
• Property Name: sequenceNumber
• Reference: Integer
• Default value: @SQL=SELECT COALESCE(MAX(SeqNo),0)+10 AS DefaultValue FROM C_AcctSchema_Element WHERE C_AcctSchema_ID=@C_AcctSchema_ID@

top

Accounting Element

• Physical column name: C_Element_ID
• Property Name: accountingElement
• Reference: TableDir

Foreign key column to C_Element table, (column: C_Element_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)

top

Mandatory

The Mandatory checkbox indicates if the field is required for a record to be save to the database.

• Physical column name: IsMandatory
• Property Name: mandatory
• Reference: YesNo

top

Balanced

Needs to be balanced.

• Physical column name: IsBalanced
• Property Name: balanced
• Reference: YesNo

top

Trx Organization

• Physical column name: Org_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

Account Element

• Physical column name: C_ElementValue_ID
• Property Name: accountElement
• Reference: TableDir

Foreign key column to C_ElementValue table, (column: C_ElementValue_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

Location / Address

• Physical column name: C_Location_ID
• Property Name: locationAddress
• Reference: Search

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

top

Sales Region

• Physical column name: C_SalesRegion_ID
• Property Name: salesRegion
• Reference: TableDir

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

top

Project

• Physical column name: C_Project_ID
• Property Name: project
• Reference: TableDir

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

top

Sales Campaign

• Physical column name: C_Campaign_ID
• Property Name: salesCampaign
• Reference: TableDir

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

top

Activity

• Physical column name: C_Activity_ID
• Property Name: activity
• Reference: TableDir

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

top