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

ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C AcctSchema Default

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa


Contents

C_AcctSchema_Default

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.
A_Accumdepreciation_Acct No VARCHAR (32) Accumulated Depreciation Account
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.

Allowancefordoubtful_Acct Yes VARCHAR (32) Account used to provision bad debts. This amount will reduce accounts receivable amount in balance sheet.
Baddebtexpense_Acct Yes VARCHAR (32) Account used to book the expense related to a recover of a bad debt
BadDebtRevenue_Acct Yes VARCHAR (32) Account used to book the revenue related to a recover of a bad debt
B_Asset_Acct No VARCHAR (32) The Bank Asset Account identifies the account to be used for booking changes to the balance in this bank account
B_Expense_Acct No VARCHAR (32) The Bank Expense Account identifies the account to be used for recording charges or fees incurred from this Bank.
B_InTransit_Acct No VARCHAR (32) The Bank in Transit Account identifies the account to be used for funds which are in transit.
B_InterestExp_Acct Yes VARCHAR (32) The Bank Interest Expense Account identifies the account to be used for recording interest expenses.
B_InterestRev_Acct Yes VARCHAR (32) The Bank Interest Revenue Account identifies the account to be used for recording interest revenue from this Bank.
B_RevaluationGain_Acct No VARCHAR (32) The Bank Revaluation Gain Account identifies the account to be used for recording gains that are recognized when converting currencies.
B_RevaluationLoss_Acct No VARCHAR (32) The Bank Revaluation Loss Account identifies the account to be used for recording losses that are recognized when converting currencies.
B_SettlementGain_Acct Yes VARCHAR (32) The Bank Settlement Gain account identifies the account to be used when recording a currency gain when the settlement and receipt currency are not the same.
B_SettlementLoss_Acct Yes VARCHAR (32) The Bank Settlement loss account identifies the account to be used when recording a currency loss when the settlement and receipt currency are not the same.
B_Unidentified_Acct Yes VARCHAR (32) The Bank Unidentified Receipts Account identifies the account to be used when recording receipts that can not be reconciled at the present time.
C_Acctschema_Default_ID No VARCHAR (32) Defaults accounts are taken from COA after initial client setup or initial organization setup. Then they are populated in this tab. This configuration can be modified at any point in time and will just apply to new master data registered.
CB_Asset_Acct No VARCHAR (32) The Cash Book Asset Account identifies the account to be used for recording payments into and disbursements from this cash book.
CB_Differences_Acct No VARCHAR (32) The Cash Book Differences Account identifies the account to be used for recording any differences that affect this cash book
CB_Expense_Acct No VARCHAR (32) The Cash Book Expense Account identifies the account to be used for general, non itemized expenses.
CB_Receipt_Acct No VARCHAR (32) The Cash Book Receipt Account identifies the account to be used for general, non itemized cash book receipts.
CB_CashTransfer_Acct No VARCHAR (32) Account for Invoices paid by cash
Ch_Expense_Acct No VARCHAR (32) The Charge Expense Account identifies the account to use when recording charges paid to vendors.
Ch_Revenue_Acct Yes VARCHAR (32) The Charge Revenue Account identifies the account to use when recording charges paid by customers.
AD_Client_ID No VARCHAR (32) A Client is a company or a legal entity. You cannot share data between Clients.
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_Prepayment_Acct Yes VARCHAR (32) The Customer Prepayment account indicates the account to be used for recording prepayments from a customer.
C_Receivable_Acct No VARCHAR (32) The Customer Receivables Accounts indicates the account to be used for recording transaction for customers receivables.
A_Depreciation_Acct No VARCHAR (32) Depreciation account
A_Disposal_Gain Yes VARCHAR (32) Disposal Gain account
A_Disposal_Loss Yes VARCHAR (32) Disposal Loss account
DoubtfulDebt_Acct Yes VARCHAR (32) Account used to reclassify an account receivable once this has been recognized as a doubtful debt
E_Expense_Acct Yes VARCHAR (32) The Employee Expense Account identifies the account to use for recording expenses for this employee.
E_Prepayment_Acct Yes VARCHAR (32) The Employee Prepayment Account identifies the account to use for recording expense advances made to this employee.
P_Asset_Acct No VARCHAR (32) The Product Asset Account indicates the account used for valuing this a product in inventory.
W_InvActualAdjust_Acct Yes VARCHAR (32) In actual costing systems, this account is used to post Inventory value adjustments. You could set it to the standard Inventory Asset account.
W_Revaluation_Acct Yes VARCHAR (32) The Inventory Revaluation Account identifies the account used to records changes in inventory value due to currency revaluation.
P_InvoicePriceVariance_Acct Yes VARCHAR (32) The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price.
NotInvoicedReceipts_Acct Yes VARCHAR (32) The Not Invoiced Receipts account indicates the account used for recording receipts for materials that have not yet been invoiced.
NotInvoicedReceivables_Acct Yes VARCHAR (32) The Not Invoiced Receivables account indicates the account used for recording receivables that have not yet been invoiced.
NotInvoicedRevenue_Acct Yes VARCHAR (32) The Not Invoiced Revenue account indicates the account used for recording revenue that has not yet been invoiced.
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.
PayDiscount_Exp_Acct Yes VARCHAR (32) Indicates the account to be charged for payment discount expenses.
PayDiscount_Rev_Acct Yes VARCHAR (32) Indicates the account to be charged for payment discount revenues.
B_PaymentSelect_Acct Yes VARCHAR (32) AP Payment Selection Clearing Account
Processing Yes CHAR (1) When this field is set as 'Y' a process is being performed on this record.
P_Cogs_Acct No VARCHAR (32) The Product COGS Account indicates the account used when recording costs associated with this product.
P_Cogs_Return_Acct Yes VARCHAR (32) The Product COGS Account indicates the account used when recording returns associated with this product.
P_Def_Expense_Acct Yes VARCHAR (32) Used when expense is deferred from a purchased product.
P_Def_Revenue_Acct Yes VARCHAR (32) Used when revenue is deferred fro a sold product.
P_Expense_Acct No VARCHAR (32) The Product Expense Account indicates the account used to record expenses associated with this product.
P_Revenue_Acct No VARCHAR (32) The Product Revenue Account indicates the account used for recording sales revenue for this product.
P_Revenue_Return_Acct Yes VARCHAR (32) The Product Revenue Return Account indicates the account used for recording returns of this product.
PJ_Asset_Acct Yes VARCHAR (32) The Project Asset account is the account used as the final asset account in capital projects
P_PurchasePriceVariance_Acct Yes VARCHAR (32) The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price.
RealizedGain_Acct Yes VARCHAR (32) The Realized Gain Account indicates the account to be used when recording gains achieved from currency revaluation that have been realized.
RealizedLoss_Acct Yes VARCHAR (32) The Realized Loss Account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized.
T_Credit_Trans_Acct Yes VARCHAR (32) The Tax Credit Transitory Account indicates the account used to record taxes for Cash VAT regime
T_Due_Trans_Acct Yes VARCHAR (32) The Tax Due Transitory Account indicates the account used to record taxes that you are liable to pay for Cash VAT regime
T_Credit_Acct No VARCHAR (32) The Tax Credit Account indicates the account used to record taxes that can be reclaimed
T_Due_Acct No VARCHAR (32) The Tax Due Account indicates the account used to record taxes that you are liable to pay.
T_Expense_Acct Yes VARCHAR (32) The Tax Expense Account indicates the account used to record the taxes that have been paid that cannot be reclaimed.
T_Liability_Acct Yes VARCHAR (32) The Tax Liability Account indicates the account used to record your tax liability declaration.
T_Receivables_Acct Yes VARCHAR (32) The Tax Receivables Account indicates the account used to record the tax credit amount after your tax declaration.
P_TradeDiscountGrant_Acct Yes VARCHAR (32) The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices
P_TradeDiscountRec_Acct Yes VARCHAR (32) The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices
B_UnallocatedCash_Acct Yes VARCHAR (32) Receipts not allocated to Invoices
UnEarnedRevenue_Acct Yes VARCHAR (32) The Unearned Revenue indicates the account used for recording invoices sent for products or services not yet delivered. It is used in revenue recognition
UnrealizedGain_Acct Yes VARCHAR (32) The Unrealized Gain Account indicates the account to be used when recording gains achieved from currency revaluation that have yet to be realized.
UnrealizedLoss_Acct Yes VARCHAR (32) The Unrealized Loss Account indicates the account to be used when recording losses incurred from currency revaluation that have yet to be realized.
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.
V_Liability_Acct No VARCHAR (32) The Vendor Liability account indicates the account used for recording transactions for vendor liabilities
V_Prepayment_Acct Yes VARCHAR (32) The Vendor Prepayment Account indicates the account used to record prepayments from a vendor.
V_Liability_Services_Acct Yes VARCHAR (32) The Vendor Service Liability account indicates the account to use for recording service liabilities. It is used if you need to distinguish between Liability for products and services
W_Differences_Acct No VARCHAR (32) The Warehouse Differences Account indicates the account used recording differences identified during inventory counts.
W_Inventory_Acct Yes VARCHAR (32) The Warehouse Inventory Asset Account identifies the account used for recording the value of your inventory.
Withholding_Acct Yes VARCHAR (32) The Withholding Account indicates the account used to record withholdings.
PJ_WIP_Acct Yes VARCHAR (32) The Work in Process account is the account used in capital projects until the project is completed
WriteOff_Acct No VARCHAR (32) The Write Off Account identifies the account to book write off transactions to.
Writeoff_Rev_Acct Yes VARCHAR (32) The Write Off Account identifies the account to book write off transactions to.

Columns

Accounting Schema

Foreign key column to C_AcctSchema table, (column: C_AcctSchema_ID)

top


Accumulated Depreciation


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Active



top


Allowance For Doubtful Debt Account


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bad Debt Expense Account


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bad Debt Revenue Account


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Asset


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank In Transit


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Interest Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Interest Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Revaluation Gain


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Revaluation Loss


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Settlement Gain


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Settlement Loss


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Bank Unidentified Receipts


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


C_Acctschema_Default_ID



top


Cash Book Asset


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Cash Book Differences


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Cash Book Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Cash Book Receipt


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Cash Transfer


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Charge Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Charge Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Client


Foreign key column to AD_Client table, (column: AD_Client_ID)

top


Created By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Creation Date



top


Customer Prepayment


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Customer Receivables No.


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Depreciation


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Disposal Gain


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Disposal Loss


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Doubtful Debt Account


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Employee Expenses


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Employee Prepayments


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Fixed Asset


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Inventory Adjustment


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Inventory Revaluation


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Invoice Price Variance


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Non-Invoiced Receipts


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Non-Invoiced Receivables


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Non-Invoiced Revenues


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Organization


Foreign key column to AD_Org table, (column: AD_Org_ID)

top


Payment Discount Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Payment Discount Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Payment Selection


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Process Now



top


Product COGS


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product COGS Return


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product Deferred Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product Deferred Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Product Revenue Return


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Project Asset


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Purchase Price Variance


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Realized Gain Acct


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Realized Loss Acct


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


T_Credit_Trans_Acct


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


T_Due_Trans_Acct


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Tax Credit


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Tax Due


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Tax Expense


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Tax Liability


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Tax Receivables


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Trade Discount Granted


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Trade Discount Received


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Unallocated Cash


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Unearned Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Unrealized GainsAcct.


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Unrealized Losses Acct.


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Updated



top


Updated By


Foreign key column to AD_User table, (column: AD_User_ID)

top


Vendor Liability


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Vendor Prepayment


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Vendor Service Liability


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Warehouse Differences


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Warehouse Inventory


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Withholding Account


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Work In Progress


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Write-off


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Write-off Revenue


Foreign key column to C_ValidCombination table, (column: C_ValidCombination_ID)

top


Other Info

Check Constraints

These are the check constraints for this table:

top

Back button.png   Back to org.openbravo.model.financialmgmt.accounting.coa

Retrieved from "http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.accounting.coa/C_AcctSchema_Default"

This page has been accessed 6,861 times. This page was last modified on 7 September 2020, at 01:57. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.