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

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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa

Index

Contents

C_AcctSchema_Default

Defines default accounts for an Accounting Schema. These values will display when a new document is opened. The user can override these defaults within the document.

This table contains the following columns:

Name Nullable Data Type Description
C_AcctSchema_ID NVARCHAR2(32)The structure used in accounting including costing methods, currencies, and the calendar.
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
Created NDATEThe date that this record is completed.
CreatedBy NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
UpdatedBy NVARCHAR2(32)User who updated this records
W_Inventory_Acct YVARCHAR2(32)Warehouse Inventory Asset Account
W_InvActualAdjust_Acct YVARCHAR2(32)Account for Inventory value adjustments for Actual Costing
W_Differences_Acct NVARCHAR2(32)Warehouse Differences Account
W_Revaluation_Acct YVARCHAR2(32)Account for Inventory Revaluation
P_Revenue_Acct NVARCHAR2(32)An account number in the general ledger to mark transactions with this product.
P_Expense_Acct NVARCHAR2(32)An account number in the general ledger to mark transactions with this item.
P_Asset_Acct NVARCHAR2(32)A tangible asset used for business without expectation of sale in the coming fiscal year.
P_PurchasePriceVariance_Acct YVARCHAR2(32)The amount by which product prices fluctuate when purchased.
P_InvoicePriceVariance_Acct YVARCHAR2(32)The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price.
P_TradeDiscountRec_Acct YVARCHAR2(32)x not implemented
P_TradeDiscountGrant_Acct YVARCHAR2(32)x not implemented
P_Cogs_Acct NVARCHAR2(32)The cost of goods sold for a specified product.
C_Receivable_Acct NVARCHAR2(32)An account number in the general ledger to mark transactions with a business partner.
C_Prepayment_Acct YVARCHAR2(32)x not implemented
V_Liability_Acct NVARCHAR2(32)An account number in the general ledger used to mark transactions with this business partner.
V_Liability_Services_Acct YVARCHAR2(32)An account number in the general ledger to mark transactions with this business partner.
V_Prepayment_Acct YVARCHAR2(32)An account number in the general ledger used to mark transactions with this business partner.
PayDiscount_Exp_Acct YVARCHAR2(32)Payment Discount Expense Account
WriteOff_Acct NVARCHAR2(32)Account for Receivables write-off
PayDiscount_Rev_Acct YVARCHAR2(32)Payment Discount Revenue Account
UnrealizedGain_Acct YVARCHAR2(32)Unrealized Gain Account for currency revaluation
UnrealizedLoss_Acct YVARCHAR2(32)Unrealized Loss Account for currency revaluation
RealizedGain_Acct YVARCHAR2(32)Realized Gain Account
RealizedLoss_Acct YVARCHAR2(32)Realized Loss Account
Withholding_Acct YVARCHAR2(32)not part of task
E_Prepayment_Acct YVARCHAR2(32)Account for Employee Expense Prepayments
E_Expense_Acct YVARCHAR2(32)Account for Employee Expenses
PJ_Asset_Acct YVARCHAR2(32)x not implemented
PJ_WIP_Acct YVARCHAR2(32)An account used in production projects until it becomes defined as a finished good.
T_Expense_Acct YVARCHAR2(32)Account for paid tax you cannot reclaim
T_Liability_Acct YVARCHAR2(32)Account for Tax declaration liability
T_Receivables_Acct YVARCHAR2(32)Account for Tax credit after tax declaration
T_Due_Acct NVARCHAR2(32)Account for Tax you have to pay
T_Credit_Acct NVARCHAR2(32)Account for Tax you can reclaim
B_InTransit_Acct NVARCHAR2(32)Bank In Transit Account
B_Asset_Acct NVARCHAR2(32)Bank Asset Account
B_Expense_Acct NVARCHAR2(32)Bank Expense Account
B_InterestRev_Acct YVARCHAR2(32)Bank Interest Revenue Account
B_InterestExp_Acct YVARCHAR2(32)Bank Interest Expense Account
B_Unidentified_Acct YVARCHAR2(32)Bank Unidentified Receipts Account
B_UnallocatedCash_Acct YVARCHAR2(32)Unallocated Cash Clearing Account
B_PaymentSelect_Acct YVARCHAR2(32)AP Payment Selection Clearing Account
B_SettlementGain_Acct YVARCHAR2(32)Bank Settlement Gain Account
B_SettlementLoss_Acct YVARCHAR2(32)Bank Settlement Loss Account
B_RevaluationGain_Acct NVARCHAR2(32)Bank Revaluation Gain Account
B_RevaluationLoss_Acct NVARCHAR2(32)Bank Revaluation Loss Account
Ch_Expense_Acct NVARCHAR2(32)Charge Expense Account
Ch_Revenue_Acct YVARCHAR2(32)Charge Revenue Account
UnEarnedRevenue_Acct YVARCHAR2(32)x not implemented
NotInvoicedReceivables_Acct YVARCHAR2(32)Account for not invoiced Receivables
NotInvoicedRevenue_Acct YVARCHAR2(32)Account for not invoiced Revenue
NotInvoicedReceipts_Acct YVARCHAR2(32)Account for not-invoiced Material Receipts
CB_Asset_Acct NVARCHAR2(32)Cash Book Asset Account
CB_CashTransfer_Acct NVARCHAR2(32)Cash Transfer Clearing Account
CB_Differences_Acct NVARCHAR2(32)Cash Book Differences Account
CB_Expense_Acct NVARCHAR2(32)Cash Book Expense Account
CB_Receipt_Acct NVARCHAR2(32)Cash Book Receipts Account
Processing YCHAR(1)A request to process the respective document or task.
A_Accumdepreciation_Acct NVARCHAR2(32)Accumulated Depreciation
A_Depreciation_Acct NVARCHAR2(32)Depreciation account
A_Disposal_Gain YVARCHAR2(32)Disposal Gain
A_Disposal_Loss YVARCHAR2(32)Disposal Loss
C_Acctschema_Default_ID NVARCHAR2(32)Acctschema default

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Accounting Schema

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

top

Client

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

top

Organization

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

top

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.

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

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

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

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

top

Warehouse Inventory

Foreign key column to W_Inventory_A table, (column: null)

top

Inventory Adjustment

Foreign key column to W_InvActualAdjust_A table, (column: null)

top

Warehouse Differences

Foreign key column to W_Differences_A table, (column: null)

top

Inventory Revaluation

Foreign key column to W_Revaluation_A table, (column: null)

top

Product Revenue

Foreign key column to P_Revenue_A table, (column: null)

top

Product Expense

Foreign key column to P_Expense_A table, (column: null)

top

Fixed Asset

Foreign key column to P_Asset_A table, (column: null)

top

Purchase Price Variance

Foreign key column to P_PurchasePriceVariance_A table, (column: null)

top

Invoice Price Variance

Foreign key column to P_InvoicePriceVariance_A table, (column: null)

top

Trade Discount Received

Foreign key column to P_TradeDiscountRec_A table, (column: null)

top

Trade Discount Granted

Foreign key column to P_TradeDiscountGrant_A table, (column: null)

top

Product COGS

Foreign key column to P_Cogs_A table, (column: null)

top

Customer Receivables No.

Foreign key column to C_Receivable_A table, (column: null)

top

Customer Prepayment

Foreign key column to C_Prepayment_A table, (column: null)

top

Vendor Liability

Foreign key column to V_Liability_A table, (column: null)

top

Vendor Service Liability

Foreign key column to V_Liability_Services_A table, (column: null)

top

Vendor Prepayment

Foreign key column to V_Prepayment_A table, (column: null)

top

Payment Discount Expense

Foreign key column to PayDiscount_Exp_A table, (column: null)

top

Write-off

Foreign key column to WriteOff_A table, (column: null)

top

Payment Discount Revenue

Foreign key column to PayDiscount_Rev_A table, (column: null)

top

Unrealized GainsAcct.

Foreign key column to UnrealizedGain_A table, (column: null)

top

Unrealized Losses Acct.

Foreign key column to UnrealizedLoss_A table, (column: null)

top

Realized Gain Acct

Foreign key column to RealizedGain_A table, (column: null)

top

Realized Loss Acct

Foreign key column to RealizedLoss_A table, (column: null)

top

Withholding Account

Foreign key column to Withholding_A table, (column: null)

top

Employee Prepayments

Foreign key column to E_Prepayment_A table, (column: null)

top

Employee Expenses

Foreign key column to E_Expense_A table, (column: null)

top

Project Asset

Foreign key column to PJ_Asset_A table, (column: null)

top

Work In Progress

Foreign key column to PJ_WIP_A table, (column: null)

top

Tax Expense

Foreign key column to T_Expense_A table, (column: null)

top

Tax Liability

Foreign key column to T_Liability_A table, (column: null)

top

Tax Receivables

Foreign key column to T_Receivables_A table, (column: null)

top

Tax Due

Foreign key column to T_Due_A table, (column: null)

top

Tax Credit

Foreign key column to T_Credit_A table, (column: null)

top

Bank In Transit

Foreign key column to B_InTransit_A table, (column: null)

top

Bank Asset

Foreign key column to B_Asset_A table, (column: null)

top

Bank Expense

Foreign key column to B_Expense_A table, (column: null)

top

Bank Interest Revenue

Foreign key column to B_InterestRev_A table, (column: null)

top

Bank Interest Expense

Foreign key column to B_InterestExp_A table, (column: null)

top

Bank Unidentified Receipts

Foreign key column to B_Unidentified_A table, (column: null)

top

Unallocated Cash

Foreign key column to B_UnallocatedCash_A table, (column: null)

top

Payment Selection

Foreign key column to B_PaymentSelect_A table, (column: null)

top

Bank Settlement Gain

Foreign key column to B_SettlementGain_A table, (column: null)

top

Bank Settlement Loss

Foreign key column to B_SettlementLoss_A table, (column: null)

top

Bank Revaluation Gain

Foreign key column to B_RevaluationGain_A table, (column: null)

top

Bank Revaluation Loss

Foreign key column to B_RevaluationLoss_A table, (column: null)

top

Charge Expense

Foreign key column to Ch_Expense_A table, (column: null)

top

Charge Revenue

Foreign key column to Ch_Revenue_A table, (column: null)

top

Unearned Revenue

Foreign key column to UnEarnedRevenue_A table, (column: null)

top

Non-Invoiced Receivables

Foreign key column to NotInvoicedReceivables_A table, (column: null)

top

Non-Invoiced Revenues

Foreign key column to NotInvoicedRevenue_A table, (column: null)

top

Non-Invoiced Receipts

Foreign key column to NotInvoicedReceipts_A table, (column: null)

top

Cash Book Asset

Foreign key column to CB_Asset_A table, (column: null)

top

Cash Transfer

Foreign key column to CB_CashTransfer_A table, (column: null)

top

Cash Book Differences

Foreign key column to CB_Differences_A table, (column: null)

top

Cash Book Expense

Foreign key column to CB_Expense_A table, (column: null)

top

Cash Book Receipt

Foreign key column to CB_Receipt_A table, (column: null)

top

Process Now

When this field is set as 'Y' a process is being performed on this record.

top

Accumulated Depreciation

Foreign key column to A_Accumdepreciation_A table, (column: null)

top

Depreciation

Foreign key column to A_Depreciation_A table, (column: null)

top

Disposal Gain

Foreign key column to A_Disposal_G table, (column: null)

top

Disposal Loss

Foreign key column to A_Disposal_L table, (column: null)

top

C_Acctschema_Default_ID

Default accounts for an Accounting Schema.

top

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

This page has been accessed 5,011 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.