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

Contents 1 C_AcctSchema_Default 1.1 Other Info 1.1.1 Check constraints 1.1.2 Indexes 1.1.2.1 Unique 1.2 Columns 1.2.1 Accounting Schema 1.2.2 Client 1.2.3 Organization 1.2.4 Active 1.2.5 Creation Date 1.2.6 Created By 1.2.7 Updated 1.2.8 Updated By 1.2.9 Warehouse Inventory 1.2.10 Inventory Adjustment 1.2.11 Warehouse Differences 1.2.12 Inventory Revaluation 1.2.13 Product Revenue 1.2.14 Product Expense 1.2.15 Fixed Asset 1.2.16 Purchase Price Variance 1.2.17 Invoice Price Variance 1.2.18 Trade Discount Received 1.2.19 Trade Discount Granted 1.2.20 Product COGS 1.2.21 Customer Receivables No. 1.2.22 Customer Prepayment 1.2.23 Vendor Liability 1.2.24 Vendor Service Liability 1.2.25 Vendor Prepayment 1.2.26 Payment Discount Expense 1.2.27 Write-off 1.2.28 Payment Discount Revenue 1.2.29 Unrealized GainsAcct. 1.2.30 Unrealized Losses Acct. 1.2.31 Realized Gain Acct 1.2.32 Realized Loss Acct 1.2.33 Withholding Account 1.2.34 Employee Prepayments 1.2.35 Employee Expenses 1.2.36 Project Asset 1.2.37 Work In Progress 1.2.38 Tax Expense 1.2.39 Tax Liability 1.2.40 Tax Receivables 1.2.41 Tax Due 1.2.42 Tax Credit 1.2.43 Bank In Transit 1.2.44 Bank Asset 1.2.45 Bank Expense 1.2.46 Bank Interest Revenue 1.2.47 Bank Interest Expense 1.2.48 Bank Unidentified Receipts 1.2.49 Unallocated Cash 1.2.50 Payment Selection 1.2.51 Bank Settlement Gain 1.2.52 Bank Settlement Loss 1.2.53 Bank Revaluation Gain 1.2.54 Bank Revaluation Loss 1.2.55 Charge Expense 1.2.56 Charge Revenue 1.2.57 Unearned Revenue 1.2.58 Non-Invoiced Receivables 1.2.59 Non-Invoiced Revenues 1.2.60 Non-Invoiced Receipts 1.2.61 Cash Book Asset 1.2.62 Cash Transfer 1.2.63 Cash Book Differences 1.2.64 Cash Book Expense 1.2.65 Cash Book Receipt 1.2.66 Process Now 1.2.67 Accumulated Depreciation 1.2.68 Depreciation 1.2.69 Disposal Gain 1.2.70 Disposal Loss 1.2.71 C_Acctschema_Default_ID

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.

• Name:FinancialMgmtAcctSchemaDefault
• Classname:AcctSchemaDefault

This table contains the following columns:

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

Other Info

Check constraints

These are the check constraints for this table:

• C_ACCTSCHEMA_DE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')

top

Indexes

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

Unique

• C_ACCTSCHEMA_DEFAULT_KEY
  • C_Acctschema_Default_ID
• C_ACCTSCHEMA_DE_UN_C_ACCTSCH
  • C_AcctSchema_ID

top

Columns

Accounting Schema

• Physical column name: C_AcctSchema_ID
• Property Name: accountingSchema
• Reference: TableDir
• This column is part of the table's identifier
• This column is a child for a buisiness object (is Parent)

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

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir
• Default value: @AD_CLIENT_ID@

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

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir
• Default value: @AD_Org_ID@

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.

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo

top

Creation Date

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

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime

top

Created By

• Physical column name: CreatedBy
• Property Name: createdBy
• Reference: Search

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

top

Updated

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

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime

top

Updated By

• Physical column name: UpdatedBy
• Property Name: updatedBy
• Reference: Search

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

top

Warehouse Inventory

• Physical column name: W_Inventory_Acct
• Property Name: warehouseInventory
• Reference: Search

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

top

Inventory Adjustment

• Physical column name: W_InvActualAdjust_Acct
• Property Name: inventoryAdjustment
• Reference: Search

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

top

Warehouse Differences

• Physical column name: W_Differences_Acct
• Property Name: warehouseDifferences
• Reference: Search

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

top

Inventory Revaluation

• Physical column name: W_Revaluation_Acct
• Property Name: inventoryRevaluation
• Reference: Search

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

top

Product Revenue

• Physical column name: P_Revenue_Acct
• Property Name: productRevenue
• Reference: Search

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

top

Product Expense

• Physical column name: P_Expense_Acct
• Property Name: productExpense
• Reference: Search

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

top

Fixed Asset

• Physical column name: P_Asset_Acct
• Property Name: fixedAsset
• Reference: Search

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

top

Purchase Price Variance

• Physical column name: P_PurchasePriceVariance_Acct
• Property Name: purchasePriceVariance
• Reference: Search

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

top

Invoice Price Variance

• Physical column name: P_InvoicePriceVariance_Acct
• Property Name: invoicePriceVariance
• Reference: Search

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

top

Trade Discount Received

• Physical column name: P_TradeDiscountRec_Acct
• Property Name: tradeDiscountReceived
• Reference: Search

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

top

Trade Discount Granted

• Physical column name: P_TradeDiscountGrant_Acct
• Property Name: tradeDiscountGranted
• Reference: Search

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

top

Product COGS

• Physical column name: P_Cogs_Acct
• Property Name: productCOGS
• Reference: Search

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

top

Customer Receivables No.

• Physical column name: C_Receivable_Acct
• Property Name: customerReceivablesNo
• Reference: Search

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

top

Customer Prepayment

• Physical column name: C_Prepayment_Acct
• Property Name: customerPrepayment
• Reference: Search

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

top

Vendor Liability

• Physical column name: V_Liability_Acct
• Property Name: vendorLiability
• Reference: Search

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

top

Vendor Service Liability

• Physical column name: V_Liability_Services_Acct
• Property Name: vendorServiceLiability
• Reference: Search

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

top

Vendor Prepayment

• Physical column name: V_Prepayment_Acct
• Property Name: vendorPrepayment
• Reference: Search

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

top

Payment Discount Expense

• Physical column name: PayDiscount_Exp_Acct
• Property Name: paymentDiscountExpense
• Reference: Search

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

top

Write-off

• Physical column name: WriteOff_Acct
• Property Name: writeoff
• Reference: Search

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

top

Payment Discount Revenue

• Physical column name: PayDiscount_Rev_Acct
• Property Name: paymentDiscountRevenue
• Reference: Search

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

top

Unrealized GainsAcct.

• Physical column name: UnrealizedGain_Acct
• Property Name: unrealizedGainsAcct
• Reference: Search

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

top

Unrealized Losses Acct.

• Physical column name: UnrealizedLoss_Acct
• Property Name: unrealizedLossesAcct
• Reference: Search

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

top

Realized Gain Acct

• Physical column name: RealizedGain_Acct
• Property Name: realizedGainAcct
• Reference: Search

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

top

Realized Loss Acct

• Physical column name: RealizedLoss_Acct
• Property Name: realizedLossAcct
• Reference: Search

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

top

Withholding Account

• Physical column name: Withholding_Acct
• Property Name: withholdingAccount
• Reference: Search

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

top

Employee Prepayments

• Physical column name: E_Prepayment_Acct
• Property Name: employeePrepayments
• Reference: Search

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

top

Employee Expenses

• Physical column name: E_Expense_Acct
• Property Name: employeeExpenses
• Reference: Search

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

top

Project Asset

• Physical column name: PJ_Asset_Acct
• Property Name: projectAsset
• Reference: Search

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

top

Work In Progress

• Physical column name: PJ_WIP_Acct
• Property Name: workInProgress
• Reference: Search

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

top

Tax Expense

• Physical column name: T_Expense_Acct
• Property Name: taxExpense
• Reference: Search

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

top

Tax Liability

• Physical column name: T_Liability_Acct
• Property Name: taxLiability
• Reference: Search

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

top

Tax Receivables

• Physical column name: T_Receivables_Acct
• Property Name: taxReceivables
• Reference: Search

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

top

Tax Due

• Physical column name: T_Due_Acct
• Property Name: taxDue
• Reference: Search

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

top

Tax Credit

• Physical column name: T_Credit_Acct
• Property Name: taxCredit
• Reference: Search

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

top

Bank In Transit

• Physical column name: B_InTransit_Acct
• Property Name: bankInTransit
• Reference: Search

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

top

Bank Asset

• Physical column name: B_Asset_Acct
• Property Name: bankAsset
• Reference: Search

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

top

Bank Expense

• Physical column name: B_Expense_Acct
• Property Name: bankExpense
• Reference: Search

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

top

Bank Interest Revenue

• Physical column name: B_InterestRev_Acct
• Property Name: bankInterestRevenue
• Reference: Search

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

top

Bank Interest Expense

• Physical column name: B_InterestExp_Acct
• Property Name: bankInterestExpense
• Reference: Search

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

top

Bank Unidentified Receipts

• Physical column name: B_Unidentified_Acct
• Property Name: bankUnidentifiedReceipts
• Reference: Search

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

top

Unallocated Cash

• Physical column name: B_UnallocatedCash_Acct
• Property Name: unallocatedCash
• Reference: Search

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

top

Payment Selection

• Physical column name: B_PaymentSelect_Acct
• Property Name: paymentSelection
• Reference: Search

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

top

Bank Settlement Gain

• Physical column name: B_SettlementGain_Acct
• Property Name: bankSettlementGain
• Reference: Search

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

top

Bank Settlement Loss

• Physical column name: B_SettlementLoss_Acct
• Property Name: bankSettlementLoss
• Reference: Search

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

top

Bank Revaluation Gain

• Physical column name: B_RevaluationGain_Acct
• Property Name: bankRevaluationGain
• Reference: Search

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

top

Bank Revaluation Loss

• Physical column name: B_RevaluationLoss_Acct
• Property Name: bankRevaluationLoss
• Reference: Search

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

top

Charge Expense

• Physical column name: Ch_Expense_Acct
• Property Name: chargeExpense
• Reference: Search

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

top

Charge Revenue

• Physical column name: Ch_Revenue_Acct
• Property Name: chargeRevenue
• Reference: Search

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

top

Unearned Revenue

• Physical column name: UnEarnedRevenue_Acct
• Property Name: unearnedRevenue
• Reference: Search

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

top

Non-Invoiced Receivables

• Physical column name: NotInvoicedReceivables_Acct
• Property Name: nonInvoicedReceivables
• Reference: Search

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

top

Non-Invoiced Revenues

• Physical column name: NotInvoicedRevenue_Acct
• Property Name: nonInvoicedRevenues
• Reference: Search

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

top

Non-Invoiced Receipts

• Physical column name: NotInvoicedReceipts_Acct
• Property Name: nonInvoicedReceipts
• Reference: Search

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

top

Cash Book Asset

• Physical column name: CB_Asset_Acct
• Property Name: cashBookAsset
• Reference: Search

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

top

Cash Transfer

• Physical column name: CB_CashTransfer_Acct
• Property Name: cashTransfer
• Reference: Search

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

top

Cash Book Differences

• Physical column name: CB_Differences_Acct
• Property Name: cashBookDifferences
• Reference: Search

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

top

Cash Book Expense

• Physical column name: CB_Expense_Acct
• Property Name: cashBookExpense
• Reference: Search

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

top

Cash Book Receipt

• Physical column name: CB_Receipt_Acct
• Property Name: cashBookReceipt
• Reference: Search

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.

• Physical column name: Processing
• Property Name: processNow
• Reference: Button

top

Accumulated Depreciation

• Physical column name: A_Accumdepreciation_Acct
• Property Name: accumulatedDepreciation
• Reference: Search

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

top

Depreciation

• Physical column name: A_Depreciation_Acct
• Property Name: depreciation
• Reference: Search

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

top

Disposal Gain

• Physical column name: A_Disposal_Gain
• Property Name: disposalGain
• Reference: Search

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

top

Disposal Loss

• Physical column name: A_Disposal_Loss
• Property Name: disposalLoss
• Reference: Search

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

top

C_Acctschema_Default_ID

Default accounts for an Accounting Schema.

• Physical column name: C_Acctschema_Default_ID
• Property Name: id
• Reference: ID

top