ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C AcctSchema
C_AcctSchema
The Accounting Schema Tab defines the controls used for accounting. Each Organization will select an Accounting Schema to use.
- Name:FinancialMgmtAcctSchema
- Classname:AcctSchema
This table contains the following columns:
| Name | Nullable | Data Type | Description |
| C_AcctSchema_ID | N | VARCHAR2(32) | The structure used in accounting including costing methods, currencies, and the calendar. |
| 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 |
| Name | N | NVARCHAR2(60) | A non-unique identifier for a record/document often used as a search tool. |
| Description | Y | NVARCHAR2(255) | A space to write additional related information. |
| GAAP | N | VARCHAR2(60) | Generally Accepted Accounting Principles |
| IsAccrual | Y | CHAR(1) | Indicates if Accrual or Cash Based accounting will be used |
| CostingMethod | Y | VARCHAR2(60) | Indicates how costs will be calculated |
| C_Currency_ID | N | VARCHAR2(32) | An accepted medium of monetary exchange that may vary across countries. |
| AutoPeriodControl | Y | CHAR(1) | If selected, the periods are automatically opened and closed |
| C_Period_ID | Y | VARCHAR2(32) | A specified time period. |
| Period_OpenHistory | Y | NUMBER(10, 0) | Number of days to be able to post in the past (based on system date) |
| Period_OpenFuture | Y | NUMBER(10, 0) | Number of days to be able to post to a future date (based on system date) |
| Separator | N | CHAR(1) | Element Separator |
| HasAlias | Y | CHAR(1) | Ability to select (partial) account combinations by an Alias |
| HasCombination | Y | CHAR(1) | Combination of account elements are checked |
| IsTradeDiscountPosted | Y | CHAR(1) | Generate postings for trade discounts |
| IsDiscountCorrectsTax | Y | CHAR(1) | Correct the tax for payment discount and charges |
| Allownegative | Y | CHAR(1) | Allow negative entries in credit and debit |
Other Info
Check constraints
These are the check constraints for this table:
- C_ACCTSCHEMA_AUTOPERIODCON_CHK: AUTOPERIODCONTROL IN ('Y', 'N')
- C_ACCTSCHEMA_HASALIAS_CHK: HASALIAS IN ('Y', 'N')
- C_ACCTSCHEMA_HASCOMBINATIO_CHK: HASCOMBINATION IN ('Y', 'N')
- C_ACCTSCHEMA_ISACCRUAL_CHK: ISACCRUAL IN ('Y', 'N')
- C_ACCTSCHEMA_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
- C_ACCTSCHEMA_ISDISCOUNTCOR_CHK: ISDISCOUNTCORRECTSTAX IN ('Y', 'N')
- C_ACCTSCHEMA_ISTRADEDISCOU_CHK: ISTRADEDISCOUNTPOSTED IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Unique
- C_ACCTSCHEMA_KEY
- C_ACCTSCHEMA_NAME
Columns
Accounting Schema
An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar
- Physical column name: C_AcctSchema_ID
- Property Name: id
- Reference: ID
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 Security validation: Clients with user access rights. With the following code:
AD_Client.AD_Client_ID IN (@#User_Client@)
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)
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
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
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
Description
A description is limited to 255 characters.
- Physical column name: Description
- Property Name: description
- Reference: String
GAAP
The GAAP identifies the account principles that this accounting schema will adhere to.
- Physical column name: GAAP
- Property Name: gAAP
- Reference: List
List values: C_AcctSchema GAAP
The allowed values for this list are:
- DE (German HGB): German HGB
- FR (French Accounting Standard)
- UN (International GAAP): International GAAP
- US (US GAAP): United States GAAP
- XX (Custom Accounting Rules)
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.
- Physical column name: IsAccrual
- Property Name: accrual
- Reference: YesNo
- Default value: Y
Costing Method
Indicates how costs will be calculated (Standard, Average) for valuation and accounting purposes.
- Physical column name: CostingMethod
- Property Name: costingMethod
- Reference: List
List values: C_AcctSchema Costing Method
The allowed values for this list are:
- A (Average): Weighted Average Purchase Order Price Costing
- F (Fifo): First In First Out Costing
- L (Lifo): Last In First Out Costing
- P (Last PO Price): Based on last PO price
- S (Standard Costing): Standard Purchase Order Price Costing
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
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.
- Physical column name: AutoPeriodControl
- Property Name: automaticPeriodControl
- Reference: YesNo
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: TableDir
Foreign key column to C_Period table, (column: C_Period_ID)
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
- Physical column name: Period_OpenHistory
- Property Name: historyDays
- Reference: Integer
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
- Physical column name: Period_OpenFuture
- Property Name: futureDays
- Reference: Integer
Storage Bin Separator
The Element Separator defines the delimiter printed between elements of the structure
- Physical column name: Separator
- Property Name: storageBinSeparator
- Reference: String
- Default value: -
Use Account Alias
The Alias checkbox indicates that account combination can be selected using a user defined alias or short key.
- Physical column name: HasAlias
- Property Name: useAccountAlias
- Reference: YesNo
Use Account Combination Control
The Combination Control checkbox indicates if the combination of account elements will be verified against the defined acceptable combination.
- Physical column name: HasCombination
- Property Name: useAccountCombinationControl
- Reference: YesNo
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
- Physical column name: IsTradeDiscountPosted
- Property Name: postTradeDiscount
- Reference: YesNo
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.
- Physical column name: IsDiscountCorrectsTax
- Property Name: correctTaxForDiscountsCharges
- Reference: YesNo
Allow negative
Allow negative entries in credit and debit
- Physical column name: Allownegative
- Property Name: allowNegative
- Reference: YesNo
- Default value: Y
Related tables
Tables that link this table:
- BankAccountAccounts.Accounting Schema
- BusinessPartnerCategoryAccount.Accounting Schema
- ClientInformation.Primary Accounting Schema
- ClientInformation.Second Accounting Schema
- ClientInformation.Third Accounting Schema
- CustomerAccounts.Accounting Schema
- DataImportBudgetLine.Accounting Schema
- DataImportGLJournal.Accounting Schema
- EmployeeAccounts.Accounting Schema
- FIN_Financial_Account_Acct.Accounting Schema
- FinancialMgmtAccountingCombination.Accounting Schema
- FinancialMgmtAccountingFact.Accounting Schema
- FinancialMgmtAccountingReport.Accounting Schema
- FinancialMgmtAccountingRptElement.Accounting Schema
- FinancialMgmtAcctSchemaDefault.Accounting Schema
- FinancialMgmtAcctSchemaElement.Accounting Schema
- FinancialMgmtAcctSchemaGL.Accounting Schema
- FinancialMgmtAcctSchemaTable.Accounting Schema
- FinancialMgmtAssetAccounts.Accounting Schema
- FinancialMgmtAssetGroupAcct.Accounting Schema
- FinancialMgmtBudgetLine.Accounting Schema
- FinancialMgmtCashBookAccounts.Accounting Schema
- FinancialMgmtGLChargeAccounts.Accounting Schema
- FinancialMgmtGLItemAccounts.Accounting Schema
- FinancialMgmtGLJournal.Accounting Schema
- FinancialMgmtInterOrgAccounts.Accounting Schema
- FinancialMgmtTaxPayment.Accounting Schema
- FinancialMgmtTaxRateAccounts.Accounting Schema
- FinancialMgmtWithholdingAccounts.Accounting Schema
- OrganizationAcctSchema.Accounting Schema
- ProductAccounts.Accounting Schema
- ProductCategoryAccounts.Accounting Schema
- ProjectAccounts.Accounting Schema
- ResourcePlanCost.Accounting Schema
- RevenueRecognitionPlan.Accounting Schema
- VendorAccounts.Accounting Schema
- WarehouseAccounts.Accounting Schema