ERP/2.50/Developers Guide/Reference/Entity Model/ProductAccounts
ProductAccounts
Defines the defaults to use when generating accounting transactions for documents which contain this product.
To the database table (M_Product_Acct) of this entity.
Properties
Note:
- Properties marked with a * are part of the Id of the Entity.
- Properties marked with a # are part of the Identifier of the Entity.
Property | Column | Constraints | Type | Description |
id* | M_Product_Acct_ID | Mandatory Max Length: 32 | java.lang.String | |
product# | M_Product_ID | Mandatory | Product | Identifies an item which is either purchased or sold in this organization. |
accountingSchema# | C_AcctSchema_ID | Mandatory | FinancialMgmtAcctSchema | An Accounting Schema defines the rules used in accounting such as costing method, currency and calendar |
client | AD_Client_ID | Mandatory | ADClient | A Client is a company or a legal entity. You cannot share data between Clients. |
organization | AD_Org_ID | Mandatory | Organization | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
active | IsActive | Mandatory | java.lang.Boolean | 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. |
creationDate | Created | Mandatory | java.util.Date | The Created field indicates the date that this record was created. |
createdBy | CreatedBy | Mandatory | ADUser | The Created By field indicates the user who created this record. |
updated | Updated | Mandatory | java.util.Date | The Updated field indicates the date that this record was updated. |
updatedBy | UpdatedBy | Mandatory | ADUser | The Updated By field indicates the user who updated this record. |
productRevenue | P_Revenue_Acct | Mandatory | FinancialMgmtAccountingCombination | The Product Revenue Account indicates the account used for recording sales revenue for this product. |
productExpense | P_Expense_Acct | Mandatory | FinancialMgmtAccountingCombination | The Product Expense Account indicates the account used to record expenses associated with this product. |
fixedAsset | P_Asset_Acct | FinancialMgmtAccountingCombination | The Product Asset Account indicates the account used for valuing this a product in inventory. | |
purchasePriceVariance | P_PurchasePriceVariance_Acct | FinancialMgmtAccountingCombination | The Purchase Price Variance is used in Standard Costing. It reflects the difference between the Standard Cost and the Purchase Order Price. | |
invoicePriceVariance | P_InvoicePriceVariance_Acct | FinancialMgmtAccountingCombination | The Invoice Price Variance is used reflects the difference between the current Costs and the Invoice Price. | |
productCOGS | P_Cogs_Acct | FinancialMgmtAccountingCombination | The Product COGS Account indicates the account used when recording costs associated with this product. | |
tradeDiscountReceived | P_TradeDiscountRec_Acct | FinancialMgmtAccountingCombination | The Trade Discount Receivables Account indicates the account for received trade discounts in vendor invoices | |
tradeDiscountGranted | P_TradeDiscountGrant_Acct | FinancialMgmtAccountingCombination | The Trade Discount Granted Account indicates the account for granted trade discount in sales invoices |
Java Entity Class
/* ************************************************************************* * The contents of this file are subject to the Openbravo Public License * Version 1.1 (the "License"), being the Mozilla Public License * Version 1.1 with a permitted attribution clause; you may not use this * file except in compliance with the License. You may obtain a copy of * the License at http://www.openbravo.com/legal/license.html * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * The Original Code is Openbravo ERP. * The Initial Developer of the Original Code is Openbravo SLU * All portions are Copyright (C) 2008-2010 Openbravo SLU * All Rights Reserved. * Contributor(s): ______________________________________. ************************************************************************ */ package org.openbravo.model.common.plm; import org.openbravo.base.structure.ActiveEnabled; import org.openbravo.base.structure.BaseOBObject; import org.openbravo.base.structure.ClientEnabled; import org.openbravo.base.structure.OrganizationEnabled; import org.openbravo.base.structure.Traceable; import org.openbravo.model.ad.access.User; import org.openbravo.model.ad.system.Client; import org.openbravo.model.common.enterprise.Organization; import org.openbravo.model.financialmgmt.accounting.coa.AccountingCombination; import org.openbravo.model.financialmgmt.accounting.coa.AcctSchema; import java.lang.Boolean; import java.lang.String; import java.util.Date; /** * Entity class for entity ProductAccounts (stored in table M_Product_Acct). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class ProductAccounts extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "M_Product_Acct"; public static final String ProductAccounts = "ProductAccounts"; public static final String PROPERTY_ID = "id"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_ACCOUNTINGSCHEMA = "accountingSchema"; public static final String PROPERTY_CLIENT = "client"; public static final String PROPERTY_ORGANIZATION = "organization"; public static final String PROPERTY_ACTIVE = "active"; public static final String PROPERTY_CREATIONDATE = "creationDate"; public static final String PROPERTY_CREATEDBY = "createdBy"; public static final String PROPERTY_UPDATED = "updated"; public static final String PROPERTY_UPDATEDBY = "updatedBy"; public static final String PROPERTY_PRODUCTREVENUE = "productRevenue"; public static final String PROPERTY_PRODUCTEXPENSE = "productExpense"; public static final String PROPERTY_FIXEDASSET = "fixedAsset"; public static final String PROPERTY_PURCHASEPRICEVARIANCE = "purchasePriceVariance"; public static final String PROPERTY_INVOICEPRICEVARIANCE = "invoicePriceVariance"; public static final String PROPERTY_PRODUCTCOGS = "productCOGS"; public static final String PROPERTY_TRADEDISCOUNTRECEIVED = "tradeDiscountReceived"; public static final String PROPERTY_TRADEDISCOUNTGRANTED = "tradeDiscountGranted"; public ProductAccounts() { setDefaultValue(PROPERTY_ACTIVE, true); } @Override public String getEntityName() { return ProductAccounts; } public String getId() { return (String) get(PROPERTY_ID); } public void setId(String id) { set(PROPERTY_ID, id); } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public AcctSchema getAccountingSchema() { return (AcctSchema) get(PROPERTY_ACCOUNTINGSCHEMA); } public void setAccountingSchema(AcctSchema accountingSchema) { set(PROPERTY_ACCOUNTINGSCHEMA, accountingSchema); } public Client getClient() { return (Client) get(PROPERTY_CLIENT); } public void setClient(Client client) { set(PROPERTY_CLIENT, client); } public Organization getOrganization() { return (Organization) get(PROPERTY_ORGANIZATION); } public void setOrganization(Organization organization) { set(PROPERTY_ORGANIZATION, organization); } public Boolean isActive() { return (Boolean) get(PROPERTY_ACTIVE); } public void setActive(Boolean active) { set(PROPERTY_ACTIVE, active); } public Date getCreationDate() { return (Date) get(PROPERTY_CREATIONDATE); } public void setCreationDate(Date creationDate) { set(PROPERTY_CREATIONDATE, creationDate); } public User getCreatedBy() { return (User) get(PROPERTY_CREATEDBY); } public void setCreatedBy(User createdBy) { set(PROPERTY_CREATEDBY, createdBy); } public Date getUpdated() { return (Date) get(PROPERTY_UPDATED); } public void setUpdated(Date updated) { set(PROPERTY_UPDATED, updated); } public User getUpdatedBy() { return (User) get(PROPERTY_UPDATEDBY); } public void setUpdatedBy(User updatedBy) { set(PROPERTY_UPDATEDBY, updatedBy); } public AccountingCombination getProductRevenue() { return (AccountingCombination) get(PROPERTY_PRODUCTREVENUE); } public void setProductRevenue(AccountingCombination productRevenue) { set(PROPERTY_PRODUCTREVENUE, productRevenue); } public AccountingCombination getProductExpense() { return (AccountingCombination) get(PROPERTY_PRODUCTEXPENSE); } public void setProductExpense(AccountingCombination productExpense) { set(PROPERTY_PRODUCTEXPENSE, productExpense); } public AccountingCombination getFixedAsset() { return (AccountingCombination) get(PROPERTY_FIXEDASSET); } public void setFixedAsset(AccountingCombination fixedAsset) { set(PROPERTY_FIXEDASSET, fixedAsset); } public AccountingCombination getPurchasePriceVariance() { return (AccountingCombination) get(PROPERTY_PURCHASEPRICEVARIANCE); } public void setPurchasePriceVariance( AccountingCombination purchasePriceVariance) { set(PROPERTY_PURCHASEPRICEVARIANCE, purchasePriceVariance); } public AccountingCombination getInvoicePriceVariance() { return (AccountingCombination) get(PROPERTY_INVOICEPRICEVARIANCE); } public void setInvoicePriceVariance( AccountingCombination invoicePriceVariance) { set(PROPERTY_INVOICEPRICEVARIANCE, invoicePriceVariance); } public AccountingCombination getProductCOGS() { return (AccountingCombination) get(PROPERTY_PRODUCTCOGS); } public void setProductCOGS(AccountingCombination productCOGS) { set(PROPERTY_PRODUCTCOGS, productCOGS); } public AccountingCombination getTradeDiscountReceived() { return (AccountingCombination) get(PROPERTY_TRADEDISCOUNTRECEIVED); } public void setTradeDiscountReceived( AccountingCombination tradeDiscountReceived) { set(PROPERTY_TRADEDISCOUNTRECEIVED, tradeDiscountReceived); } public AccountingCombination getTradeDiscountGranted() { return (AccountingCombination) get(PROPERTY_TRADEDISCOUNTGRANTED); } public void setTradeDiscountGranted( AccountingCombination tradeDiscountGranted) { set(PROPERTY_TRADEDISCOUNTGRANTED, tradeDiscountGranted); } }