ERP/2.50/Developers Guide/Reference/Entity Model/MaterialMgmtStorageDetail
MaterialMgmtStorageDetail
Containts the current stock for every product
To the database table (M_Storage_Detail) 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 |
product# | M_Product_ID | Mandatory | Product | Identifies an item which is either purchased or sold in this organization. |
storageBin# | M_Locator_ID | Mandatory | Locator | The Locator ID indicates where in a Warehouse a product is located. |
attributeSetValue | M_AttributeSetInstance_ID | AttributeSetInstance | The values of the actual Product Attributes | |
uOM | C_UOM_ID | Mandatory | UOM | The UOM defines a unique non monetary unit of measure |
orderUOM | M_Product_Uom_Id | ProductUOM | Alternative order UOM for the product. | |
quantityOnHand | QtyOnHand | Mandatory | java.math.BigDecimal | The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse. |
onHandOrderQuanity | QtyOrderOnHand | java.math.BigDecimal | The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse in the second uom | |
lastInventoryCountDate | DateLastInventory | java.util.Date | The Date Last Inventory Count indicates the last time an Inventory count was done. | |
quantityInDraftTransactions | PreQtyOnHand | java.math.BigDecimal | The quantity that we have already purchased but are not still in the warehouse | |
quantityOrderInDraftTransactions | PreQtyOrderOnHand | java.math.BigDecimal | The quantity that we have already purchased but are not still in the warehouse in the second uom | |
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. |
id* | M_Storage_Detail_ID | Mandatory Max Length: 32 | java.lang.String | The ID identifies a unique record |
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.materialmgmt.onhandquantity; 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.Locator; import org.openbravo.model.common.enterprise.Organization; import org.openbravo.model.common.plm.AttributeSetInstance; import org.openbravo.model.common.plm.Product; import org.openbravo.model.common.plm.ProductUOM; import java.lang.Boolean; import java.lang.String; import java.math.BigDecimal; import java.util.Date; /** * Entity class for entity MaterialMgmtStorageDetail (stored in table M_Storage_Detail). * * NOTE: This class should not be instantiated directly. To instantiate this * class the {@link org.openbravo.base.provider.OBProvider} should be used. */ public class StorageDetail extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled { private static final long serialVersionUID = 1L; public static final String TABLE_NAME = "M_Storage_Detail"; public static final String MaterialMgmtStorageDetail = "MaterialMgmtStorageDetail"; public static final String PROPERTY_PRODUCT = "product"; public static final String PROPERTY_STORAGEBIN = "storageBin"; public static final String PROPERTY_ATTRIBUTESETVALUE = "attributeSetValue"; public static final String PROPERTY_UOM = "uOM"; public static final String PROPERTY_ORDERUOM = "orderUOM"; public static final String PROPERTY_QUANTITYONHAND = "quantityOnHand"; public static final String PROPERTY_ONHANDORDERQUANITY = "onHandOrderQuanity"; public static final String PROPERTY_LASTINVENTORYCOUNTDATE = "lastInventoryCountDate"; public static final String PROPERTY_QUANTITYINDRAFTTRANSACTIONS = "quantityInDraftTransactions"; public static final String PROPERTY_QUANTITYORDERINDRAFTTRANSACTIONS = "quantityOrderInDraftTransactions"; 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_ID = "id"; public StorageDetail() { setDefaultValue(PROPERTY_ACTIVE, true); } @Override public String getEntityName() { return MaterialMgmtStorageDetail; } public Product getProduct() { return (Product) get(PROPERTY_PRODUCT); } public void setProduct(Product product) { set(PROPERTY_PRODUCT, product); } public Locator getStorageBin() { return (Locator) get(PROPERTY_STORAGEBIN); } public void setStorageBin(Locator storageBin) { set(PROPERTY_STORAGEBIN, storageBin); } public AttributeSetInstance getAttributeSetValue() { return (AttributeSetInstance) get(PROPERTY_ATTRIBUTESETVALUE); } public void setAttributeSetValue(AttributeSetInstance attributeSetValue) { set(PROPERTY_ATTRIBUTESETVALUE, attributeSetValue); } public org.openbravo.model.common.uom.UOM getUOM() { return (org.openbravo.model.common.uom.UOM) get(PROPERTY_UOM); } public void setUOM(org.openbravo.model.common.uom.UOM uOM) { set(PROPERTY_UOM, uOM); } public ProductUOM getOrderUOM() { return (ProductUOM) get(PROPERTY_ORDERUOM); } public void setOrderUOM(ProductUOM orderUOM) { set(PROPERTY_ORDERUOM, orderUOM); } public BigDecimal getQuantityOnHand() { return (BigDecimal) get(PROPERTY_QUANTITYONHAND); } public void setQuantityOnHand(BigDecimal quantityOnHand) { set(PROPERTY_QUANTITYONHAND, quantityOnHand); } public BigDecimal getOnHandOrderQuanity() { return (BigDecimal) get(PROPERTY_ONHANDORDERQUANITY); } public void setOnHandOrderQuanity(BigDecimal onHandOrderQuanity) { set(PROPERTY_ONHANDORDERQUANITY, onHandOrderQuanity); } public Date getLastInventoryCountDate() { return (Date) get(PROPERTY_LASTINVENTORYCOUNTDATE); } public void setLastInventoryCountDate(Date lastInventoryCountDate) { set(PROPERTY_LASTINVENTORYCOUNTDATE, lastInventoryCountDate); } public BigDecimal getQuantityInDraftTransactions() { return (BigDecimal) get(PROPERTY_QUANTITYINDRAFTTRANSACTIONS); } public void setQuantityInDraftTransactions( BigDecimal quantityInDraftTransactions) { set(PROPERTY_QUANTITYINDRAFTTRANSACTIONS, quantityInDraftTransactions); } public BigDecimal getQuantityOrderInDraftTransactions() { return (BigDecimal) get(PROPERTY_QUANTITYORDERINDRAFTTRANSACTIONS); } public void setQuantityOrderInDraftTransactions( BigDecimal quantityOrderInDraftTransactions) { set(PROPERTY_QUANTITYORDERINDRAFTTRANSACTIONS, quantityOrderInDraftTransactions); } 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 String getId() { return (String) get(PROPERTY_ID); } public void setId(String id) { set(PROPERTY_ID, id); } }