ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BP Group Acct
C_BP_Group_Acct
- Name:C_BP_Group_Acct
- Classname:BusinessPartnerCategoryAccount
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. |
| 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 |
| C_BP_Group_ID | No | VARCHAR (32) | A way of grouping business partners together for classification and reporting purposes. Provides a method of defining certain defaults to be used when opening new business partners. |
| C_Bp_Group_Acct_ID | No | VARCHAR (32) | Defines the default accounts for any business partner that references this group. |
| 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. |
| Doubtfuldebt_Acct | Yes | VARCHAR (32) | Account used to reclassify an account receivable once this has been recognized as a doubtful debt |
| 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. |
| Processing | Yes | CHAR (1) | When this field is set as 'Y' a process is being performed on this record. |
| 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. |
| Status | Yes | VARCHAR (60) | Status for the debt payment |
| 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 |
| 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 a child for a business object (is Parent)
Foreign key column to C_AcctSchema table, (column: C_AcctSchema_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)
Business Partner Category
- Physical column name: C_BP_Group_ID
- Property Name: businessPartnerCategory
- 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_BP_Group table, (column: C_BP_Group_ID)
C_Bp_Group_Acct_ID
- Physical column name: C_Bp_Group_Acct_ID
- Property Name: id
- Reference: 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)
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)
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)
Process Now
- Physical column name: Processing
- Property Name: processNow
- Reference: Button
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)
Status
- Physical column name: Status
- Property Name: status
- Reference: List
List values: C_DP_Management_Status
The allowed values for this list are:
- DE (--)
- RE (Returned)
- RT (In Remittance)
- RC (Received)
- SE (Sent)
- AN (Advance)
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)
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)
Writeoff_Rev_Acct
- Physical column name: Writeoff_Rev_Acct
- Property Name: writeoffRevAcct
- 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_BP_GROUP_ACCT_ISACTIVE_CHECK: ISACTIVE IN ('Y', 'N')