Default Accounts Usage
From ADempiere
This Wiki is read-only for reference purposes to avoid broken links.
Contributed by:
Quality Systems & Solutions - QSS Ltda.
Carlos Ruiz
Also see Default accounts,Default accounts 360lts.
Prefixes in Default Columns
Most of default accounts are prefixed this way:
| Prefix | Table |
|---|---|
| B | C_BankAccount_Acct |
| C | C_BP_Customer_Acct |
| V | C_BP_Vendor_Acct |
| CB | C_CashBook_Acct |
| CH | C_Charge_Acct |
| PJ | C_Project_Acct |
| T | C_Tax_Acct |
| P | M_Product_Acct |
| W | M_Warehouse_Acct |
M_Product_Acct default accounts are inherited from M_Product_Category_Acct (but can be modified)
Some C_BP_Customer_Acct and C_BP_Vendor_Acct are inherited from C_BP_Group_Acct (but can be modified)
Usage
| Window, Tab | Table | Column | Used in |
|---|---|---|---|
| Not Available | A_ASSET_ACCT | A_ACCUMDEPRECIATION_ACCT | Not Used |
| A_ASSET_ACCT | A_ASSET_ACCT | Not Used | |
| A_ASSET_ACCT | A_DEPRECIATION_ACCT | Not Used | |
| Not Available | A_ASSET_GROUP_ACCT | A_ACCUMDEPRECIATION_ACCT | Not Used |
| A_ASSET_GROUP_ACCT | A_ASSET_ACCT | Not Used | |
| A_ASSET_GROUP_ACCT | A_DEPRECIATION_ACCT | Not Used | |
| Accounting Schema -> Defaults | C_ACCTSCHEMA_DEFAULT | B_ASSET_ACCT | Default Level 1 -> Bank |
| C_ACCTSCHEMA_DEFAULT | B_EXPENSE_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_INTERESTEXP_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_INTERESTREV_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_INTRANSIT_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_PAYMENTSELECT_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_REVALUATIONGAIN_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_REVALUATIONLOSS_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_SETTLEMENTGAIN_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_SETTLEMENTLOSS_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_UNALLOCATEDCASH_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | B_UNIDENTIFIED_ACCT | Default Level 1 -> Bank | |
| C_ACCTSCHEMA_DEFAULT | C_PREPAYMENT_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | C_RECEIVABLE_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | C_RECEIVABLE_SERVICES_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | CB_ASSET_ACCT | Default Level 1 -> CashBook | |
| C_ACCTSCHEMA_DEFAULT | CB_CASHTRANSFER_ACCT | Default Level 1 -> CashBook | |
| C_ACCTSCHEMA_DEFAULT | CB_DIFFERENCES_ACCT | Default Level 1 -> CashBook | |
| C_ACCTSCHEMA_DEFAULT | CB_EXPENSE_ACCT | Default Level 1 -> CashBook | |
| C_ACCTSCHEMA_DEFAULT | CB_RECEIPT_ACCT | Default Level 1 -> CashBook | |
| C_ACCTSCHEMA_DEFAULT | CH_EXPENSE_ACCT | Default Level 1 -> Charge | |
| C_ACCTSCHEMA_DEFAULT | CH_REVENUE_ACCT | Default Level 1 -> Charge | |
| C_ACCTSCHEMA_DEFAULT | E_EXPENSE_ACCT | Default Level 1 -> BP_Employee | |
| C_ACCTSCHEMA_DEFAULT | E_PREPAYMENT_ACCT | Default Level 1 -> BP_Employee | |
| C_ACCTSCHEMA_DEFAULT | NOTINVOICEDRECEIPTS_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | NOTINVOICEDRECEIVABLES_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | NOTINVOICEDREVENUE_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | P_ASSET_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_COGS_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_COSTADJUSTMENT_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_EXPENSE_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_INVENTORYCLEARING_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_INVOICEPRICEVARIANCE_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_PURCHASEPRICEVARIANCE_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_REVENUE_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_TRADEDISCOUNTGRANT_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | P_TRADEDISCOUNTREC_ACCT | Default Level 2 -> Product_Category | |
| C_ACCTSCHEMA_DEFAULT | PAYDISCOUNT_EXP_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | PAYDISCOUNT_REV_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | PJ_ASSET_ACCT | Default Level 1 -> Project | |
| C_ACCTSCHEMA_DEFAULT | PJ_WIP_ACCT | Default Level 1 -> Project | |
| C_ACCTSCHEMA_DEFAULT | REALIZEDGAIN_ACCT | Allocation | |
| C_ACCTSCHEMA_DEFAULT | REALIZEDLOSS_ACCT | Allocation | |
| C_ACCTSCHEMA_DEFAULT | T_CREDIT_ACCT | Default Level 1 -> Tax | |
| C_ACCTSCHEMA_DEFAULT | T_DUE_ACCT | Default Level 1 -> Tax | |
| C_ACCTSCHEMA_DEFAULT | T_EXPENSE_ACCT | Default Level 1 -> Tax | |
| C_ACCTSCHEMA_DEFAULT | T_LIABILITY_ACCT | Default Level 1 -> Tax | |
| C_ACCTSCHEMA_DEFAULT | T_RECEIVABLES_ACCT | Default Level 1 -> Tax | |
| C_ACCTSCHEMA_DEFAULT | UNEARNEDREVENUE_ACCT | Default Level 1 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | UNREALIZEDGAIN_ACCT | Default Level 1 -> BP_Group Invoice Not Realized Gain/Loss | |
| C_ACCTSCHEMA_DEFAULT | UNREALIZEDLOSS_ACCT | Default Level 1 -> BP_Group Invoice Not Realized Gain/Loss | |
| C_ACCTSCHEMA_DEFAULT | V_LIABILITY_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | V_LIABILITY_SERVICES_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | V_PREPAYMENT_ACCT | Default Level 2 -> BP_Group | |
| C_ACCTSCHEMA_DEFAULT | W_DIFFERENCES_ACCT | Default Level 1 -> Warehouse | |
| C_ACCTSCHEMA_DEFAULT | W_INVACTUALADJUST_ACCT | Default Level 1 -> Warehouse | |
| C_ACCTSCHEMA_DEFAULT | W_INVENTORY_ACCT | Default Level 1 -> Warehouse | |
| C_ACCTSCHEMA_DEFAULT | W_REVALUATION_ACCT | Default Level 1 -> Warehouse | |
| C_ACCTSCHEMA_DEFAULT | WITHHOLDING_ACCT | Default Level 1 -> Withholding | |
| C_ACCTSCHEMA_DEFAULT | WRITEOFF_ACCT | Default Level 1 -> BP_Group | |
| Accounting Schema -> General Ledger | C_ACCTSCHEMA_GL | COMMITMENTOFFSET_ACCT | MatchInv Order (PO) |
| C_ACCTSCHEMA_GL | CURRENCYBALANCING_ACCT | General Fact | |
| C_ACCTSCHEMA_GL | INCOMESUMMARY_ACCT | Not Used | |
| C_ACCTSCHEMA_GL | INTERCOMPANYDUEFROM_ACCT | General Fact | |
| C_ACCTSCHEMA_GL | INTERCOMPANYDUETO_ACCT | General Fact | |
| C_ACCTSCHEMA_GL | PPVOFFSET_ACCT | MatchPO | |
| C_ACCTSCHEMA_GL | RETAINEDEARNING_ACCT | Not Used | |
| C_ACCTSCHEMA_GL | SUSPENSEBALANCING_ACCT | General Fact | |
| C_ACCTSCHEMA_GL | SUSPENSEERROR_ACCT | Not Used | |
| Bank -> Account -> Accounting | C_BANKACCOUNT_ACCT | B_ASSET_ACCT | Bank |
| C_BANKACCOUNT_ACCT | B_EXPENSE_ACCT | Not Used | |
| C_BANKACCOUNT_ACCT | B_INTERESTEXP_ACCT | Bank | |
| C_BANKACCOUNT_ACCT | B_INTERESTREV_ACCT | Bank | |
| C_BANKACCOUNT_ACCT | B_INTRANSIT_ACCT | Bank Cash | |
| C_BANKACCOUNT_ACCT | B_PAYMENTSELECT_ACCT | Allocation Payment (PO) | |
| C_BANKACCOUNT_ACCT | B_REVALUATIONGAIN_ACCT | Not Used | |
| C_BANKACCOUNT_ACCT | B_REVALUATIONLOSS_ACCT | Not Used | |
| C_BANKACCOUNT_ACCT | B_SETTLEMENTGAIN_ACCT | Not Used | |
| C_BANKACCOUNT_ACCT | B_SETTLEMENTLOSS_ACCT | Not Used | |
| C_BANKACCOUNT_ACCT | B_UNALLOCATEDCASH_ACCT | Allocation Payment (SO) | |
| C_BANKACCOUNT_ACCT | B_UNIDENTIFIED_ACCT | Not Used | |
| Business Partner -> Customer -> Customer Accounting | C_BP_CUSTOMER_ACCT | C_PREPAYMENT_ACCT | Allocation Payment |
| C_BP_CUSTOMER_ACCT | C_RECEIVABLE_ACCT | Allocation Invoice (SO) | |
| C_BP_CUSTOMER_ACCT | C_RECEIVABLE_SERVICES_ACCT | Invoice (SO) | |
| Business Partner -> Employee -> Employee Accounting | C_BP_EMPLOYEE_ACCT | E_EXPENSE_ACCT | Not Used |
| C_BP_EMPLOYEE_ACCT | E_PREPAYMENT_ACCT | Not Used | |
| Business Partner Group -> Accounting | C_BP_GROUP_ACCT | C_PREPAYMENT_ACCT | Default Level 1 -> BP_Customer |
| C_BP_GROUP_ACCT | C_RECEIVABLE_ACCT | Default Level 1 -> BP_Customer | |
| C_BP_GROUP_ACCT | C_RECEIVABLE_SERVICES_ACCT | Default Level 1 -> BP_Customer | |
| C_BP_GROUP_ACCT | NOTINVOICEDRECEIPTS_ACCT | InOut MatchInv | |
| C_BP_GROUP_ACCT | NOTINVOICEDRECEIVABLES_ACCT | Not Used | |
| C_BP_GROUP_ACCT | NOTINVOICEDREVENUE_ACCT | Not Used | |
| C_BP_GROUP_ACCT | PAYDISCOUNT_EXP_ACCT | Allocation | |
| C_BP_GROUP_ACCT | PAYDISCOUNT_REV_ACCT | Allocation | |
| C_BP_GROUP_ACCT | UNEARNEDREVENUE_ACCT | Invoice (SO) | |
| C_BP_GROUP_ACCT | V_LIABILITY_ACCT | Default Level 1 -> BP_Vendor | |
| C_BP_GROUP_ACCT | V_LIABILITY_SERVICES_ACCT | Default Level 1 -> BP_Vendor | |
| C_BP_GROUP_ACCT | V_PREPAYMENT_ACCT | Default Level 1 -> BP_Vendor | |
| C_BP_GROUP_ACCT | WRITEOFF_ACCT | Allocation | |
| Business Partner -> Vendor -> Vendor Accounting | C_BP_VENDOR_ACCT | V_LIABILITY_ACCT | Allocation Invoice (PO) |
| C_BP_VENDOR_ACCT | V_LIABILITY_SERVICES_ACCT | Invoice (PO) | |
| C_BP_VENDOR_ACCT | V_PREPAYMENT_ACCT | Allocation Payment | |
| Cashbook -> Accounting | C_CASHBOOK_ACCT | CB_ASSET_ACCT | Cash |
| C_CASHBOOK_ACCT | CB_CASHTRANSFER_ACCT | Allocation Cash | |
| C_CASHBOOK_ACCT | CB_DIFFERENCES_ACCT | Cash | |
| C_CASHBOOK_ACCT | CB_EXPENSE_ACCT | Cash | |
| C_CASHBOOK_ACCT | CB_RECEIPT_ACCT | Cash | |
| Charge -> Accounting | C_CHARGE_ACCT | CH_EXPENSE_ACCT | Bank Cash |
| C_CHARGE_ACCT | CH_REVENUE_ACCT | Bank Cash | |
| Currency -> Accounting | C_CURRENCY_ACCT | REALIZEDGAIN_ACCT | Not Used |
| C_CURRENCY_ACCT | REALIZEDLOSS_ACCT | Not Used | |
| C_CURRENCY_ACCT | UNREALIZEDGAIN_ACCT | Not Used | |
| C_CURRENCY_ACCT | UNREALIZEDLOSS_ACCT | Not Used | |
| Not Available | C_INTERORG_ACCT | INTERCOMPANYDUEFROM_ACCT | Not Used |
| C_INTERORG_ACCT | INTERCOMPANYDUETO_ACCT | Not Used | |
| Project -> Accounting | C_PROJECT_ACCT | PJ_ASSET_ACCT | ProjectIssue |
| C_PROJECT_ACCT | PJ_WIP_ACCT | ProjectIssue | |
| Revenue Recognition -> Revenue Recognition Plan | C_REVENUERECOGNITION_PLAN | P_REVENUE_ACCT | Created |
| C_REVENUERECOGNITION_PLAN | UNEARNEDREVENUE_ACCT | Created | |
| Tax Rate -> Accounting | C_TAX_ACCT | T_CREDIT_ACCT | Invoice (PO) |
| C_TAX_ACCT | T_DUE_ACCT | Invoice (SO) | |
| C_TAX_ACCT | T_EXPENSE_ACCT | Invoice (PO) | |
| C_TAX_ACCT | T_LIABILITY_ACCT | Not Used | |
| C_TAX_ACCT | T_RECEIVABLES_ACCT | Not Used | |
| Withholding -> Accounting | C_WITHHOLDING_ACCT | WITHHOLDING_ACCT | Not Used |
| Product -> Accounting | M_PRODUCT_ACCT | P_ASSET_ACCT | InOut Inventory |
| M_PRODUCT_ACCT | P_COGS_ACCT | InOut | |
| M_PRODUCT_ACCT | P_COSTADJUSTMENT_ACCT | Invoice | |
| M_PRODUCT_ACCT | P_EXPENSE_ACCT | InOut Invoice (PO) | |
| M_PRODUCT_ACCT | P_INVENTORYCLEARING_ACCT | Invoice (PO) MatchInv | |
| M_PRODUCT_ACCT | P_INVOICEPRICEVARIANCE_ACCT | MatchInv | |
| M_PRODUCT_ACCT | P_PURCHASEPRICEVARIANCE_ACCT | MatchPO | |
| M_PRODUCT_ACCT | P_REVENUE_ACCT | Invoice (SO) | |
| M_PRODUCT_ACCT | P_TRADEDISCOUNTGRANT_ACCT | Invoice (SO) | |
| M_PRODUCT_ACCT | P_TRADEDISCOUNTREC_ACCT | Invoice (PO) | |
| Product Category -> Accounting | M_PRODUCT_CATEGORY_ACCT | P_ASSET_ACCT | Default Level 1 -> Product |
| M_PRODUCT_CATEGORY_ACCT | P_COGS_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_COSTADJUSTMENT_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_EXPENSE_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_INVENTORYCLEARING_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_INVOICEPRICEVARIANCE_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_PURCHASEPRICEVARIANCE_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_REVENUE_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_TRADEDISCOUNTGRANT_ACCT | Default Level 1 -> Product | |
| M_PRODUCT_CATEGORY_ACCT | P_TRADEDISCOUNTREC_ACCT | Default Level 1 -> Product | |
| Warehouse & Locators -> Accounting | M_WAREHOUSE_ACCT | W_DIFFERENCES_ACCT | Inventory |
| M_WAREHOUSE_ACCT | W_INVACTUALADJUST_ACCT | Not Used | |
| M_WAREHOUSE_ACCT | W_INVENTORY_ACCT | Not Used | |
| M_WAREHOUSE_ACCT | W_REVALUATION_ACCT | Not Used |
