Accounting Schema
C_AcctSchema
Rules for accounting
Overview
| Table Name | C_AcctSchema |
|---|---|
| Access Level | Client + Organization |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | C_TaxSchema |
| Wiki | View on iDempiere Wiki |
Columns (39)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
CostingPrecision |
Integer(22) | No | - | Rounding used costing calculations |
C_TaxSchema_ID |
Table Direct(10) | No | - | Tax Schema let you group the Tax Rates |
InventoryMethod |
List(1) | Yes | P | The Inventory Method indicates how Costing and Accounting Facts will be maintained by Accounting Procesor. |
IsAllowNegativePosting |
Yes-No(1) | No | Y | Allow to post negative accounting values |
IsDiscountCorrectsTax |
Yes-No(1) | Yes | - | Correct the tax for payment discount and charges |
IsPostIfClearingEqual |
Yes-No(1) | No | Y | This flag controls if system must post when clearing (transit) and final accounts are the same |
IsTradeDiscountPosted |
Yes-No(1) | Yes | - | Generate postings for trade discounts |
StdPrecision |
Integer(22) | No | - | Rule for rounding calculated amounts |
Name |
String(60) | Yes | - | Alphanumeric identifier of the entity |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
AD_OrgOnly_ID |
Table(10) | No | - | Create posting entries only for this organization |
AutoPeriodControl |
Yes-No(1) | Yes | - | If selected, the periods are automatically opened and closed |
C_AcctSchema_ID |
ID(22) | Yes | - | Rules for accounting |
C_AcctSchema_UU |
String(36) | No | - | - |
C_Currency_ID |
Table Direct(22) | Yes | - | The Currency for this record |
CommitmentType |
List(1) | Yes | N | Create Commitment and/or Reservations for Budget Control |
CostingLevel |
List(1) | Yes | C | The lowest level to accumulate Costing Information |
CostingMethod |
List(1) | Yes | S | Indicates how Costs will be calculated |
C_Period_ID |
Table Direct(22) | No | - | Period of the Calendar |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
Description |
String(255) | No | - | Optional short description of the record |
GAAP |
List(2) | Yes | - | Generally Accepted Accounting Principles |
HasAlias |
Yes-No(1) | Yes | - | Ability to select (partial) account combinations by an Alias |
HasCombination |
Yes-No(1) | Yes | - | Combination of account elements are checked |
IsAccrual |
Yes-No(1) | Yes | Y | Indicates if Accrual or Cash Based accounting will be used |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsAdjustCOGS |
Yes-No(1) | Yes | - | Adjust Cost of Good Sold |
IsExplicitCostAdjustment |
Yes-No(1) | Yes | N | Post the cost adjustment explicitly |
IsPostServices |
Yes-No(1) | Yes | N | Differentiate between Services and Product Receivable/Payables |
M_CostType_ID |
Table Direct(10) | Yes | - | Type of Cost (e.g. Current, Plan, Future) |
Period_OpenFuture |
Integer(22) | No | - | Number of days to be able to post to a future date (based on system date) |
Period_OpenHistory |
Integer(22) | No | - | Number of days to be able to post in the past (based on system date) |
Processing |
Button(1) | No | - | - |
Separator |
String(1) | Yes | - | Element Separator |
TaxCorrectionType |
List(1) | Yes | - | Type of Tax Correction |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Foreign Keys
| Column | References | Description |
|---|---|---|
C_TaxSchema_ID |
C_TaxSchema.C_TaxSchema_ID | Tax Schema let you group the Tax Rates |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_OrgOnly_ID |
AD_OrgOnly.AD_OrgOnly_ID | Create posting entries only for this organization |
C_Currency_ID |
C_Currency.C_Currency_ID | The Currency for this record |
C_Period_ID |
C_Period.C_Period_ID | Period of the Calendar |
M_CostType_ID |
M_CostType.M_CostType_ID | Type of Cost (e.g. Current, Plan, Future) |
Generated on 2026-05-03T16:39:32.457999176Z