View source | Discuss this page | Page history | Printable version   

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

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

Index

Contents

C_AcctSchema

The Accounting Schema Tab defines the controls used for accounting. Each Organization will select an Accounting Schema to use.

This table contains the following columns:

Name Nullable Data Type Description
C_AcctSchema_ID NVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
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
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
GAAP NVARCHAR2(60)Generally Accepted Accounting Principles
IsAccrual YCHAR(1)Indicates if Accrual or Cash Based accounting will be used
CostingMethod YVARCHAR2(60)Indicates how costs will be calculated
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
AutoPeriodControl YCHAR(1)If selected, the periods are automatically opened and closed
C_Period_ID YVARCHAR2(32)A specified time period.
Period_OpenHistory YNUMBER(10, 0)Number of days to be able to post in the past (based on system date)
Period_OpenFuture YNUMBER(10, 0)Number of days to be able to post to a future date (based on system date)
Separator NCHAR(1)Element Separator
HasAlias YCHAR(1)Ability to select (partial) account combinations by an Alias
HasCombination YCHAR(1)Combination of account elements are checked
IsTradeDiscountPosted YCHAR(1)Generate postings for trade discounts
IsDiscountCorrectsTax YCHAR(1)Correct the tax for payment discount and charges
Allownegative YCHAR(1)Allow negative entries in credit and debit

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):

Unique

top

Columns

Accounting Schema

An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar

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

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

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

GAAP

The GAAP identifies the account principles that this accounting schema will adhere to.

List values: C_AcctSchema GAAP

The allowed values for this list are:

top

Accrual

The Accrual checkbox indicates if this accounting schema will use accrual based account or cash based accounting. The Accrual method recognizes revenue when the product or service is delivered. Cash based method recognizes income when then payment is received.

top

Costing Method

Indicates how costs will be calculated (Standard, Average) for valuation and accounting purposes.

List values: C_AcctSchema Costing Method

The allowed values for this list are:

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Automatic Period Control

In the Automatic Period Control, periods are opened and closed based on the current date. If the Manual alternative is activated, you have to open and close periods explicitly.

top

Period

Foreign key column to C_Period table, (column: C_Period_ID)

top

History Days

If Automatic Period Control is enabled, the current period is calculated based on the system date and you can always post to all days in the current period. History Days enable to post to previous periods. E.g. today is May 15th and History Days is set to 30, you can post back to April 15th

top

Future Days

If Automatic Period Control is enabled, the current period is calculated based on the system date and you can always post to all days in the current period. Future Days enable to post to future periods. E.g. today is Apr 15th and Future Days is set to 30, you can post up to May 15th

top

Storage Bin Separator

The Element Separator defines the delimiter printed between elements of the structure

top

Use Account Alias

The Alias checkbox indicates that account combination can be selected using a user defined alias or short key.

top

Use Account Combination Control

The Combination Control checkbox indicates if the combination of account elements will be verified against the defined acceptable combination.

top

Post Trade Discount

If the invoice is based on an item with a list price, the amount based on the list price and the discount is posted instead of the net amount.Example: Quantity 10 - List Price: 20 - Actual Price: 17If selected for a sales invoice 200 is posted to Produc

top

Correct tax for Discounts/Charges

Payment discounts may require to correct the tax. This primarily applicable in VAT systems. If the original invoice had tax records, the payment discount, write-off, etc. is corrected by the tax. The calculation of the tax is prorated based on the invoice.

top

Allow negative

Allow negative entries in credit and debit

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_AcctSchema"

This page has been accessed 2,820 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.