View source | Discuss this page | Page history | Printable version   
Main Page
Upload file
What links here
Recent changes

PDF Books
Add page
Show collection (0 pages)
Collections help


ERP/3.0/Developers Guide/Reference/Entity Model/MaterialMgmtMaterialTransaction

This article is protected against manual editing because it is automatically generated from Openbravo meta-data. Learn more about writing and translating such documents.
Back button.png   Back to ERP/3.0/Developers_Guide/Reference/Entity_Model#MaterialMgmtMaterialTransaction


Contains all the material transactions for products that are defined as an item and stocked

To the database table (M_Transaction) of this entity.



Property Column Constraints Type Description
id* M_Transaction_ID Mandatory
Max Length: 32
java.lang.String The ID identifies a unique record
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.
movementType# MovementType Mandatory
Max Length: 60
java.lang.String The Movement Type indicates the type of movement (in, out, to production, etc)
storageBin M_Locator_ID Mandatory
Locator The Locator ID indicates where in a Warehouse a product is located.
product# M_Product_ID Mandatory
Product Identifies an item which is either purchased or sold in this organization.
movementDate# MovementDate Mandatory
java.util.Date The Movement Date indicates the date that a product moved in or out of inventory. This is the result of a shipment, receipt or inventory movement.
movementQuantity# MovementQty Mandatory
java.math.BigDecimal The Movement Quantity indicates the quantity of a product that has been moved.
physicalInventoryLine M_InventoryLine_ID MaterialMgmtInventoryCountLine The Physical Inventory Line indicates the inventory document line (if applicable) for this transaction
movementLine M_MovementLine_ID MaterialMgmtInternalMovementLine The Movement Line indicates the inventory movement document line (if applicable) for this transaction
goodsShipmentLine M_InOutLine_ID MaterialMgmtShipmentInOutLine The Goods Shipment Line indicates a unique line in a Shipment document
productionLine M_ProductionLine_ID ManufacturingProductionLine The Production Line indicates the production document line (if applicable) for this transaction
projectIssue C_ProjectIssue_ID ProjectIssue Issues to the project initiated by the "Issue to Project" process. You can issue Receipts, Time and Expenses, or Stock.
attributeSetValue M_AttributeSetInstance_ID Mandatory
AttributeSetInstance The values of the actual Product Attributes
orderUOM M_Product_Uom_Id ProductUOM Alternative order UOM for the product.
orderQuantity QuantityOrder java.math.BigDecimal

Product quantity in the order uom.

uOM C_UOM_ID Mandatory
UOM The UOM defines a unique non monetary unit of measure
internalConsumptionLine M_Internal_Consumptionline_ID MaterialMgmtInternalConsumptionLine The ID identifies a unique record
transactionCost TransactionCost java.math.BigDecimal Total amount of the transaction based on product cost.
transactionProcessDate TrxProcessDate Mandatory
java.util.Date Indicates the date and time when the transaction was processed.
costingAlgorithm M_Costing_Algorithm_ID CostingAlgorithm Identifies a Costing Algorithm. Core distribution includes Average and Standard costing methods. Additional methods can be added using Extension Modules.
isCostCalculated IsCostCalculated Mandatory
java.lang.Boolean Determines that the cost amount has been calculated
currency C_Currency_ID Currency Indicates the currency to be used when processing this document.
costingStatus Costing_Status Mandatory
Max Length: 60
java.lang.String Costing Calculation Status
checkReservedQuantity Checkreservedqty java.lang.Boolean This field is use to check reserved stock quantity during Initial costing Rule validation.
isProcessed Isprocessed Mandatory
checkpricedifference Checkpricedifference Mandatory
java.lang.Boolean This flag will be enabled when the transaction has price differences
manualcostadjustment Manualcostadjustment java.lang.Boolean Process to manually set a new cost to this transaction.
isCostPermanent IsCostPermanent Mandatory
java.lang.Boolean Determines whether the cost is permanently adjusted or not.
totalCost TotalCost java.math.BigDecimal Represents the total Cost of the Transaction including all the Cost Adjustments
unitCost UnitCost java.math.BigDecimal
costAdjustmentLineList CostAdjustmentLine
materialMgmtCostingList MaterialMgmtCosting
transactionCostList TransactionCost

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
  * 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-2019 Openbravo SLU
  * All Rights Reserved.
  * Contributor(s):  ______________________________________.
 package org.openbravo.model.materialmgmt.transaction;
 import java.math.BigDecimal;
 import java.util.ArrayList;
 import java.util.Date;
 import java.util.List;
 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.common.currency.Currency;
 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 org.openbravo.model.common.uom.UOM;
 import org.openbravo.model.materialmgmt.cost.CostAdjustmentLine;
 import org.openbravo.model.materialmgmt.cost.Costing;
 import org.openbravo.model.materialmgmt.cost.CostingAlgorithm;
 import org.openbravo.model.materialmgmt.cost.TransactionCost;
 import org.openbravo.model.project.ProjectIssue;
  * Entity class for entity MaterialMgmtMaterialTransaction (stored in table M_Transaction).
  * NOTE: This class should not be instantiated directly. To instantiate this
  * class the {@link org.openbravo.base.provider.OBProvider} should be used.
 public class MaterialTransaction extends BaseOBObject implements Traceable, ClientEnabled, OrganizationEnabled, ActiveEnabled {
     private static final long serialVersionUID = 1L;
     public static final String TABLE_NAME = "M_Transaction";
     public static final String ENTITY_NAME = "MaterialMgmtMaterialTransaction";
     public static final String PROPERTY_ID = "id";
     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_MOVEMENTTYPE = "movementType";
     public static final String PROPERTY_STORAGEBIN = "storageBin";
     public static final String PROPERTY_PRODUCT = "product";
     public static final String PROPERTY_MOVEMENTDATE = "movementDate";
     public static final String PROPERTY_MOVEMENTQUANTITY = "movementQuantity";
     public static final String PROPERTY_PHYSICALINVENTORYLINE = "physicalInventoryLine";
     public static final String PROPERTY_MOVEMENTLINE = "movementLine";
     public static final String PROPERTY_GOODSSHIPMENTLINE = "goodsShipmentLine";
     public static final String PROPERTY_PRODUCTIONLINE = "productionLine";
     public static final String PROPERTY_PROJECTISSUE = "projectIssue";
     public static final String PROPERTY_ATTRIBUTESETVALUE = "attributeSetValue";
     public static final String PROPERTY_ORDERUOM = "orderUOM";
     public static final String PROPERTY_ORDERQUANTITY = "orderQuantity";
     public static final String PROPERTY_UOM = "uOM";
     public static final String PROPERTY_INTERNALCONSUMPTIONLINE = "internalConsumptionLine";
     public static final String PROPERTY_TRANSACTIONCOST = "transactionCost";
     public static final String PROPERTY_TRANSACTIONPROCESSDATE = "transactionProcessDate";
     public static final String PROPERTY_COSTINGALGORITHM = "costingAlgorithm";
     public static final String PROPERTY_ISCOSTCALCULATED = "isCostCalculated";
     public static final String PROPERTY_CURRENCY = "currency";
     public static final String PROPERTY_COSTINGSTATUS = "costingStatus";
     public static final String PROPERTY_CHECKRESERVEDQUANTITY = "checkReservedQuantity";
     public static final String PROPERTY_ISPROCESSED = "isProcessed";
     public static final String PROPERTY_CHECKPRICEDIFFERENCE = "checkpricedifference";
     public static final String PROPERTY_MANUALCOSTADJUSTMENT = "manualcostadjustment";
     public static final String PROPERTY_ISCOSTPERMANENT = "isCostPermanent";
     public static final String PROPERTY__COMPUTEDCOLUMNS = "_computedColumns";
     public static final String PROPERTY_COSTADJUSTMENTLINELIST = "costAdjustmentLineList";
     public static final String PROPERTY_MATERIALMGMTCOSTINGLIST = "materialMgmtCostingList";
     public static final String PROPERTY_TRANSACTIONCOSTLIST = "transactionCostList";
     // Computed columns properties, these properties cannot be directly accessed, they need
     // to be read through _commputedColumns proxy. They cannot be directly used in HQL, OBQuery
     // nor OBCriteria. 
     public static final String COMPUTED_COLUMN_TOTALCOST = "totalCost";
     public static final String COMPUTED_COLUMN_UNITCOST = "unitCost";
     public MaterialTransaction() {
         setDefaultValue(PROPERTY_ACTIVE, true);
         setDefaultValue(PROPERTY_TRANSACTIONPROCESSDATE, new Date());
         setDefaultValue(PROPERTY_ISCOSTCALCULATED, false);
         setDefaultValue(PROPERTY_COSTINGSTATUS, "NC");
         setDefaultValue(PROPERTY_CHECKRESERVEDQUANTITY, true);
         setDefaultValue(PROPERTY_ISPROCESSED, false);
         setDefaultValue(PROPERTY_CHECKPRICEDIFFERENCE, false);
         setDefaultValue(PROPERTY_MANUALCOSTADJUSTMENT, false);
         setDefaultValue(PROPERTY_ISCOSTPERMANENT, false);
         setDefaultValue(PROPERTY_COSTADJUSTMENTLINELIST, new ArrayList<Object>());
         setDefaultValue(PROPERTY_MATERIALMGMTCOSTINGLIST, new ArrayList<Object>());
         setDefaultValue(PROPERTY_TRANSACTIONCOSTLIST, new ArrayList<Object>());
     public String getEntityName() {
         return ENTITY_NAME;
     public String getId() {
         return (String) get(PROPERTY_ID);
     public void setId(String id) {
         set(PROPERTY_ID, id);
     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 getMovementType() {
         return (String) get(PROPERTY_MOVEMENTTYPE);
     public void setMovementType(String movementType) {
         set(PROPERTY_MOVEMENTTYPE, movementType);
     public Locator getStorageBin() {
         return (Locator) get(PROPERTY_STORAGEBIN);
     public void setStorageBin(Locator storageBin) {
         set(PROPERTY_STORAGEBIN, storageBin);
     public Product getProduct() {
         return (Product) get(PROPERTY_PRODUCT);
     public void setProduct(Product product) {
         set(PROPERTY_PRODUCT, product);
     public Date getMovementDate() {
         return (Date) get(PROPERTY_MOVEMENTDATE);
     public void setMovementDate(Date movementDate) {
         set(PROPERTY_MOVEMENTDATE, movementDate);
     public BigDecimal getMovementQuantity() {
         return (BigDecimal) get(PROPERTY_MOVEMENTQUANTITY);
     public void setMovementQuantity(BigDecimal movementQuantity) {
         set(PROPERTY_MOVEMENTQUANTITY, movementQuantity);
     public InventoryCountLine getPhysicalInventoryLine() {
         return (InventoryCountLine) get(PROPERTY_PHYSICALINVENTORYLINE);
     public void setPhysicalInventoryLine(InventoryCountLine physicalInventoryLine) {
         set(PROPERTY_PHYSICALINVENTORYLINE, physicalInventoryLine);
     public InternalMovementLine getMovementLine() {
         return (InternalMovementLine) get(PROPERTY_MOVEMENTLINE);
     public void setMovementLine(InternalMovementLine movementLine) {
         set(PROPERTY_MOVEMENTLINE, movementLine);
     public ShipmentInOutLine getGoodsShipmentLine() {
         return (ShipmentInOutLine) get(PROPERTY_GOODSSHIPMENTLINE);
     public void setGoodsShipmentLine(ShipmentInOutLine goodsShipmentLine) {
         set(PROPERTY_GOODSSHIPMENTLINE, goodsShipmentLine);
     public ProductionLine getProductionLine() {
         return (ProductionLine) get(PROPERTY_PRODUCTIONLINE);
     public void setProductionLine(ProductionLine productionLine) {
         set(PROPERTY_PRODUCTIONLINE, productionLine);
     public ProjectIssue getProjectIssue() {
         return (ProjectIssue) get(PROPERTY_PROJECTISSUE);
     public void setProjectIssue(ProjectIssue projectIssue) {
         set(PROPERTY_PROJECTISSUE, projectIssue);
     public AttributeSetInstance getAttributeSetValue() {
         return (AttributeSetInstance) get(PROPERTY_ATTRIBUTESETVALUE);
     public void setAttributeSetValue(AttributeSetInstance attributeSetValue) {
         set(PROPERTY_ATTRIBUTESETVALUE, attributeSetValue);
     public ProductUOM getOrderUOM() {
         return (ProductUOM) get(PROPERTY_ORDERUOM);
     public void setOrderUOM(ProductUOM orderUOM) {
         set(PROPERTY_ORDERUOM, orderUOM);
     public BigDecimal getOrderQuantity() {
         return (BigDecimal) get(PROPERTY_ORDERQUANTITY);
     public void setOrderQuantity(BigDecimal orderQuantity) {
         set(PROPERTY_ORDERQUANTITY, orderQuantity);
     public UOM getUOM() {
         return (UOM) get(PROPERTY_UOM);
     public void setUOM(UOM uOM) {
         set(PROPERTY_UOM, uOM);
     public InternalConsumptionLine getInternalConsumptionLine() {
         return (InternalConsumptionLine) get(PROPERTY_INTERNALCONSUMPTIONLINE);
     public void setInternalConsumptionLine(InternalConsumptionLine internalConsumptionLine) {
         set(PROPERTY_INTERNALCONSUMPTIONLINE, internalConsumptionLine);
     public BigDecimal getTransactionCost() {
         return (BigDecimal) get(PROPERTY_TRANSACTIONCOST);
     public void setTransactionCost(BigDecimal transactionCost) {
         set(PROPERTY_TRANSACTIONCOST, transactionCost);
     public Date getTransactionProcessDate() {
     public void setTransactionProcessDate(Date transactionProcessDate) {
         set(PROPERTY_TRANSACTIONPROCESSDATE, transactionProcessDate);
     public CostingAlgorithm getCostingAlgorithm() {
         return (CostingAlgorithm) get(PROPERTY_COSTINGALGORITHM);
     public void setCostingAlgorithm(CostingAlgorithm costingAlgorithm) {
         set(PROPERTY_COSTINGALGORITHM, costingAlgorithm);
     public Boolean isCostCalculated() {
         return (Boolean) get(PROPERTY_ISCOSTCALCULATED);
     public void setCostCalculated(Boolean isCostCalculated) {
         set(PROPERTY_ISCOSTCALCULATED, isCostCalculated);
     public Currency getCurrency() {
         return (Currency) get(PROPERTY_CURRENCY);
     public void setCurrency(Currency currency) {
         set(PROPERTY_CURRENCY, currency);
     public String getCostingStatus() {
         return (String) get(PROPERTY_COSTINGSTATUS);
     public void setCostingStatus(String costingStatus) {
         set(PROPERTY_COSTINGSTATUS, costingStatus);
     public Boolean isCheckReservedQuantity() {
         return (Boolean) get(PROPERTY_CHECKRESERVEDQUANTITY);
     public void setCheckReservedQuantity(Boolean checkReservedQuantity) {
         set(PROPERTY_CHECKRESERVEDQUANTITY, checkReservedQuantity);
     public Boolean isProcessed() {
         return (Boolean) get(PROPERTY_ISPROCESSED);
     public void setProcessed(Boolean isProcessed) {
         set(PROPERTY_ISPROCESSED, isProcessed);
     public Boolean isCheckpricedifference() {
         return (Boolean) get(PROPERTY_CHECKPRICEDIFFERENCE);
     public void setCheckpricedifference(Boolean checkpricedifference) {
         set(PROPERTY_CHECKPRICEDIFFERENCE, checkpricedifference);
     public Boolean isManualcostadjustment() {
         return (Boolean) get(PROPERTY_MANUALCOSTADJUSTMENT);
     public void setManualcostadjustment(Boolean manualcostadjustment) {
         set(PROPERTY_MANUALCOSTADJUSTMENT, manualcostadjustment);
     public Boolean isCostPermanent() {
         return (Boolean) get(PROPERTY_ISCOSTPERMANENT);
     public void setCostPermanent(Boolean isCostPermanent) {
         set(PROPERTY_ISCOSTPERMANENT, isCostPermanent);
     public BigDecimal getTotalCost() {
         return (BigDecimal) get(COMPUTED_COLUMN_TOTALCOST);
     public void setTotalCost(BigDecimal totalCost) {
         set(COMPUTED_COLUMN_TOTALCOST, totalCost);
     public BigDecimal getUnitCost() {
         return (BigDecimal) get(COMPUTED_COLUMN_UNITCOST);
     public void setUnitCost(BigDecimal unitCost) {
         set(COMPUTED_COLUMN_UNITCOST, unitCost);
     public MaterialTransaction_ComputedColumns get_computedColumns() {
         return (MaterialTransaction_ComputedColumns) get(PROPERTY__COMPUTEDCOLUMNS);
     public void set_computedColumns(MaterialTransaction_ComputedColumns _computedColumns) {
         set(PROPERTY__COMPUTEDCOLUMNS, _computedColumns);
     public List<CostAdjustmentLine> getCostAdjustmentLineList() {
       return (List<CostAdjustmentLine>) get(PROPERTY_COSTADJUSTMENTLINELIST);
     public void setCostAdjustmentLineList(List<CostAdjustmentLine> costAdjustmentLineList) {
         set(PROPERTY_COSTADJUSTMENTLINELIST, costAdjustmentLineList);
     public List<Costing> getMaterialMgmtCostingList() {
       return (List<Costing>) get(PROPERTY_MATERIALMGMTCOSTINGLIST);
     public void setMaterialMgmtCostingList(List<Costing> materialMgmtCostingList) {
         set(PROPERTY_MATERIALMGMTCOSTINGLIST, materialMgmtCostingList);
     public List<TransactionCost> getTransactionCostList() {
       return (List<TransactionCost>) get(PROPERTY_TRANSACTIONCOSTLIST);
     public void setTransactionCostList(List<TransactionCost> transactionCostList) {
         set(PROPERTY_TRANSACTIONCOSTLIST, transactionCostList);
     public Object get(String propName) {
       if (COMPUTED_COLUMN_TOTALCOST.equals(propName)) {
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getTotalCost();
       if (COMPUTED_COLUMN_UNITCOST.equals(propName)) {
         if (get_computedColumns() == null) {
           return null;
         return get_computedColumns().getUnitCost();
       return super.get(propName);

Retrieved from ""

This page has been accessed 1,540 times. This page was last modified on 8 July 2019, at 01:49. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.