ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C AcctSchema
C_AcctSchema
- Name:C_AcctSchema
- Classname:FinancialMgmtAcctSchema
This table contains the following columns:
Name | Nullable | Data Type | Description
|
C_AcctSchema_ID | No | VARCHAR (32) | The book containing all financial transactions recorded for the legal entity. |
IsAccrual | Yes | CHAR (1) | 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. |
IsActive | No | CHAR (1) | 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. |
Allownegative | No | CHAR (1) | Allow negative entries in credit and debit |
IsAssetPositive | No | CHAR (1) | Display assets as positive amounts |
AutoPeriodControl | Yes | CHAR (1) | 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. |
Iscentrallymaintained | No | CHAR (1) | The Centrally Maintained checkbox indicates if the Name, Description and Help maintained in 'System Element' table or 'Window' table. |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
IsDiscountCorrectsTax | Yes | CHAR (1) | 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. |
CostingMethod | Yes | VARCHAR (60) | Indicates how costs will be calculated (Standard, Average) for valuation and accounting purposes. |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
C_Currency_ID | No | VARCHAR (32) | Indicates the currency to be used when processing this document. |
Description | Yes | NVARCHAR (255) | A description is limited to 255 characters. |
IsEquityPositive | No | CHAR (1) | Display owner's equity as positive amounts. |
IsExpensePositive | No | CHAR (1) | Display expenses as positive amounts. |
Period_OpenFuture | Yes | DECIMAL (10,0) | 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 |
GAAP | No | VARCHAR (60) | The Accounting Standard identifies the account principles that this accounting schema will adhere to. |
Period_OpenHistory | Yes | DECIMAL (10,0) | 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 |
IsLiabilityPositive | No | CHAR (1) | Display liabilities as positive amounts. |
Name | No | NVARCHAR (60) | 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. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
C_Period_ID | Yes | VARCHAR (32) | The Period indicates an exclusive range of dates for a calendar. |
IsTradeDiscountPosted | Yes | CHAR (1) | 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 |
IsRevenuePositive | No | CHAR (1) | Display revenues as positive amounts. |
Separator | No | CHAR (1) | The Element Separator defines the delimiter printed between elements of the structure |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
HasAlias | Yes | CHAR (1) | The Alias checkbox indicates that account combination can be selected using a user defined alias or short key. |
HasCombination | Yes | CHAR (1) | The Combination Control checkbox indicates if the combination of account elements will be verified against the defined acceptable combination. |
Columns
Accounting Schema
- Physical column name: C_AcctSchema_ID
- Property Name: id
- Reference: ID
Accrual
- Physical column name: IsAccrual
- Property Name: accrual
- Reference: YesNo
- Default value: Y
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Allow negative
- Physical column name: Allownegative
- Property Name: allowNegative
- Reference: YesNo
- Default value: Y
Asset Positive
- Physical column name: IsAssetPositive
- Property Name: assetPositive
- Reference: YesNo
- Default value: Y
Automatic Period Control
- Physical column name: AutoPeriodControl
- Property Name: automaticPeriodControl
- Reference: YesNo
- Default value: N
Central Maintenance
- Physical column name: Iscentrallymaintained
- Property Name: centralMaintenance
- Reference: YesNo
- Default value: Y
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
It has a validation "AD_Client Security validation", with the following code
AD_Client.AD_Client_ID in (@#User_Client@)
Correct tax for Discounts/Charges
- Physical column name: IsDiscountCorrectsTax
- Property Name: correctTaxForDiscountsCharges
- Reference: YesNo
- Default value: N
Costing Method
- Physical column name: CostingMethod
- Property Name: costingMethod
- Reference: List
List values: C_AcctSchema Costing Method
The allowed values for this list are:
- S (Standard Costing): Standard Purchase Order Price Costing
- A (Average): Weighted Average Purchase Order Price Costing
- L (Lifo): Last In First Out Costing
- F (Fifo): First In First Out Costing
- P (Last PO Price): Based on last PO price
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Currency
- Physical column name: C_Currency_ID
- Property Name: currency
- Reference: TableDir
Foreign key column to C_Currency table, (column: C_Currency_ID)
Description
- Physical column name: Description
- Property Name: description
- Reference: String
Equity Positive
- Physical column name: IsEquityPositive
- Property Name: equityPositive
- Reference: YesNo
- Default value: Y
Expense Positive
- Physical column name: IsExpensePositive
- Property Name: expensePositive
- Reference: YesNo
- Default value: Y
Future Days
- Physical column name: Period_OpenFuture
- Property Name: futureDays
- Reference: Integer
GAAP
- Physical column name: GAAP
- Property Name: gAAP
- Reference: List
List values: C_AcctSchema GAAP
The allowed values for this list are:
- FR (French Accounting Standard)
- DE (German HGB): German HGB
- IF (IFRS): IFRS
- SA (Spanish Accounting Standard): Spanish Accounting Standard
- US (US GAAP): United States GAAP
- XX (Custom)
- OT (Other): Other
- UN (International GAAP): International GAAP
History Days
- Physical column name: Period_OpenHistory
- Property Name: historyDays
- Reference: Integer
Liability Positive
- Physical column name: IsLiabilityPositive
- Property Name: liabilityPositive
- Reference: YesNo
- Default value: Y
Name
- Physical column name: Name
- Property Name: name
- Reference: String
- This column is part of the table's identifier
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Period
- Physical column name: C_Period_ID
- Property Name: period
- Reference: TableDir
Foreign key column to C_Period table, (column: C_Period_ID)
Post Trade Discount
- Physical column name: IsTradeDiscountPosted
- Property Name: postTradeDiscount
- Reference: YesNo
- Default value: N
Revenue Positive
- Physical column name: IsRevenuePositive
- Property Name: revenuePositive
- Reference: YesNo
- Default value: Y
Storage Bin Separator
- Physical column name: Separator
- Property Name: storageBinSeparator
- Reference: String
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Use Account Alias
- Physical column name: HasAlias
- Property Name: useAccountAlias
- Reference: YesNo
- Default value: Y
Use Account Combination Control
- Physical column name: HasCombination
- Property Name: useAccountCombinationControl
- Reference: YesNo
- Default value: Y
Other Info
Check Constraints
These are the check constraints for this table:
- C_ACCTSCH_ASSETPOSITIVE_CHK: ISASSETPOSITIVE IN ('Y', 'N')
- C_ACCTSCH_CENTRMAINTAINED_CHK: ISCENTRALLYMAINTAINED IN ('Y', 'N')
- C_ACCTSCH_EQUITYPOSITIVE_CHK: ISEQUITYPOSITIVE IN ('Y', 'N')
- C_ACCTSCH_EXPENSEPOSITIVE_CHK: ISEXPENSEPOSITIVE IN ('Y', 'N')
- C_ACCTSCH_LIABPOSITIVE_CHK: ISLIABILITYPOSITIVE IN ('Y', 'N')
- C_ACCTSCH_REVENPOSITIVE_CHK: ISREVENUEPOSITIVE IN ('Y', 'N')
- 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')