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

Contents 1 C_AcctSchema_Default 1.1 Columns 1.1.1 Accounting Schema 1.1.2 Accumulated Depreciation 1.1.3 Active 1.1.4 Allowance For Doubtful Debt Account 1.1.5 Bad Debt Expense Account 1.1.6 Bad Debt Revenue Account 1.1.7 Bank Asset 1.1.8 Bank Expense 1.1.9 Bank In Transit 1.1.10 Bank Interest Expense 1.1.11 Bank Interest Revenue 1.1.12 Bank Revaluation Gain 1.1.13 Bank Revaluation Loss 1.1.14 Bank Settlement Gain 1.1.15 Bank Settlement Loss 1.1.16 Bank Unidentified Receipts 1.1.17 C_Acctschema_Default_ID 1.1.18 Cash Book Asset 1.1.19 Cash Book Differences 1.1.20 Cash Book Expense 1.1.21 Cash Book Receipt 1.1.22 Cash Transfer 1.1.23 Charge Expense 1.1.24 Charge Revenue 1.1.25 Client 1.1.26 Created By 1.1.27 Creation Date 1.1.28 Customer Prepayment 1.1.29 Customer Receivables No. 1.1.30 Depreciation 1.1.31 Disposal Gain 1.1.32 Disposal Loss 1.1.33 Doubtful Debt Account 1.1.34 Employee Expenses 1.1.35 Employee Prepayments 1.1.36 Fixed Asset 1.1.37 Inventory Adjustment 1.1.38 Inventory Revaluation 1.1.39 Invoice Price Variance 1.1.40 Non-Invoiced Receipts 1.1.41 Non-Invoiced Receivables 1.1.42 Non-Invoiced Revenues 1.1.43 Organization 1.1.44 Payment Discount Expense 1.1.45 Payment Discount Revenue 1.1.46 Payment Selection 1.1.47 Process Now 1.1.48 Product COGS 1.1.49 Product COGS Return 1.1.50 Product Deferred Expense 1.1.51 Product Deferred Revenue 1.1.52 Product Expense 1.1.53 Product Revenue 1.1.54 Product Revenue Return 1.1.55 Project Asset 1.1.56 Purchase Price Variance 1.1.57 Realized Gain Acct 1.1.58 Realized Loss Acct 1.1.59 T_Credit_Trans_Acct 1.1.60 T_Due_Trans_Acct 1.1.61 Tax Credit 1.1.62 Tax Due 1.1.63 Tax Expense 1.1.64 Tax Liability 1.1.65 Tax Receivables 1.1.66 Trade Discount Granted 1.1.67 Trade Discount Received 1.1.68 Unallocated Cash 1.1.69 Unearned Revenue 1.1.70 Unrealized GainsAcct. 1.1.71 Unrealized Losses Acct. 1.1.72 Updated 1.1.73 Updated By 1.1.74 Vendor Liability 1.1.75 Vendor Prepayment 1.1.76 Vendor Service Liability 1.1.77 Warehouse Differences 1.1.78 Warehouse Inventory 1.1.79 Withholding Account 1.1.80 Work In Progress 1.1.81 Write-off 1.1.82 Write-off Revenue 1.2 Other Info 1.2.1 Check Constraints

C_AcctSchema_Default

• Name:C_AcctSchema_Default
• Classname:FinancialMgmtAcctSchemaDefault

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

• 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 business object (is Parent)

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

top

Accumulated Depreciation

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

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

top

Active

• Physical column name: IsActive
• Property Name: active
• Reference: YesNo
• Default value: Y

top

Allowance For Doubtful Debt Account

• Physical column name: Allowancefordoubtful_Acct
• Property Name: allowanceForDoubtfulDebtAccount
• Reference: OBUISEL_Selector Reference

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

top

Bad Debt Expense Account

• Physical column name: Baddebtexpense_Acct
• Property Name: badDebtExpenseAccount
• Reference: OBUISEL_Selector Reference

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

top

Bad Debt Revenue Account

• Physical column name: BadDebtRevenue_Acct
• Property Name: badDebtRevenueAccount
• Reference: OBUISEL_Selector Reference

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

top

Bank Asset

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

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

top

Bank Expense

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

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

top

Bank In Transit

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

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

top

Bank Interest Expense

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

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

top

Bank Interest Revenue

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

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

top

Bank Revaluation Gain

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

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

top

Bank Revaluation Loss

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

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

top

Bank Settlement Gain

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

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

top

Bank Settlement Loss

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

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

top

Bank Unidentified Receipts

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

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

top

C_Acctschema_Default_ID

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

top

Cash Book Asset

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

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

top

Cash Book Differences

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

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

top

Cash Book Expense

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

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

top

Cash Book Receipt

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

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

top

Cash Transfer

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

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

top

Charge Expense

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

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

top

Charge Revenue

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

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

top

Client

• Physical column name: AD_Client_ID
• Property Name: client
• Reference: TableDir

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

top

Created By

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

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

top

Creation Date

• Physical column name: Created
• Property Name: creationDate
• Reference: DateTime
• Default value: SYSDATE

top

Customer Prepayment

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

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

top

Customer Receivables No.

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

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

top

Depreciation

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

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

top

Disposal Gain

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

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

top

Disposal Loss

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

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

top

Doubtful Debt Account

• Physical column name: DoubtfulDebt_Acct
• Property Name: doubtfulDebtAccount
• Reference: OBUISEL_Selector Reference

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

top

Employee Expenses

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

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

top

Employee Prepayments

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

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

top

Fixed Asset

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

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

top

Inventory Adjustment

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

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

top

Inventory Revaluation

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

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

top

Invoice Price Variance

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

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

top

Non-Invoiced Receipts

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

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

top

Non-Invoiced Receivables

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

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

top

Non-Invoiced Revenues

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

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

top

Organization

• Physical column name: AD_Org_ID
• Property Name: organization
• Reference: TableDir

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

top

Payment Discount Expense

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

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

top

Payment Discount Revenue

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

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

top

Payment Selection

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

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

top

Process Now

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

top

Product COGS

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

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

top

Product COGS Return

• Physical column name: P_Cogs_Return_Acct
• Property Name: productCOGSReturn
• Reference: OBUISEL_Selector Reference

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

top

Product Deferred Expense

• Physical column name: P_Def_Expense_Acct
• Property Name: productDeferredExpense
• Reference: OBUISEL_Selector Reference

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

top

Product Deferred Revenue

• Physical column name: P_Def_Revenue_Acct
• Property Name: productDeferredRevenue
• Reference: OBUISEL_Selector Reference

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

top

Product Expense

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

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

top

Product Revenue

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

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

top

Product Revenue Return

• Physical column name: P_Revenue_Return_Acct
• Property Name: productRevenueReturn
• Reference: OBUISEL_Selector Reference

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

top

Project Asset

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

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

top

Purchase Price Variance

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

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

top

Realized Gain Acct

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

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

top

Realized Loss Acct

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

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

top

T_Credit_Trans_Acct

• Physical column name: T_Credit_Trans_Acct
• Property Name: creditTransAcct
• Reference: OBUISEL_Selector Reference

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

top

T_Due_Trans_Acct

• Physical column name: T_Due_Trans_Acct
• Property Name: dueTransAcct
• Reference: OBUISEL_Selector Reference

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

top

Tax Credit

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

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

top

Tax Due

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

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

top

Tax Expense

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

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

top

Tax Liability

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

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

top

Tax Receivables

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

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

top

Trade Discount Granted

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

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

top

Trade Discount Received

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

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

top

Unallocated Cash

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

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

top

Unearned Revenue

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

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

top

Unrealized GainsAcct.

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

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

top

Unrealized Losses Acct.

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

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

top

Updated

• Physical column name: Updated
• Property Name: updated
• Reference: DateTime
• Default value: SYSDATE

top

Updated By

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

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

top

Vendor Liability

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

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

top

Vendor Prepayment

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

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

top

Vendor Service Liability

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

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

top

Warehouse Differences

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

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

top

Warehouse Inventory

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

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

top

Withholding Account

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

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

top

Work In Progress

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

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

top

Write-off

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

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

top

Write-off Revenue

• Physical column name: Writeoff_Rev_Acct
• Property Name: writeoffRevenue
• Reference: OBUISEL_Selector Reference

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

top

Other Info

Check Constraints

These are the check constraints for this table:

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

top

Categories: Database Entity Model | Generated Doc