ERP/3.0/Developers Guide/Database Model/org.openbravo.model.financialmgmt.accounting.coa/C AcctSchema Default
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)
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)
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
C_Acctschema_Default_ID
- Physical column name: C_Acctschema_Default_ID
- Property Name: id
- Reference: ID
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)
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)
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)
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)
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)
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)
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)
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
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)
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)
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)
Process Now
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
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)
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)
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)
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)
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)
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)
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)
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)
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)
Other Info
Check Constraints
These are the check constraints for this table:
- C_ACCTSCHEMA_DE_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')