Inventory Management

Inventory Management

Retail ERP Point of Sale manages all types of inventory. You can track sales and stock on hand for a particular item. Advanced functionality includes the ability to track items by batches, group items e.g., sell as a kit, or purchase and sell in different units of measurements e.g. buy a case or sell as a 6 pack, handle weighing scale products. Or perhaps you need to track sales by units of measure* such as kilograms, metres or litres. Adjust stocks and transfer stock between warehouses.

Stock Take can be quickly and efficiently done using the HHT device based application. This reduces enormous amount of time and manual labor.

Product Management

Manage Products – The Product Window defines all products used by an organization. These products include those sold to customers, used in the manufacture of products sold to customers and products purchased by an organization. The Product Tab defines each product and identifies it for use in other transactions. The product screen is used for managing the product’s barcode, mapping vendors to the product, product’s batches.
We can configure different kinds of products like weighing scale products, and normal products.

Business Rules

  • Users should be able to map products with Brand, Department, Category, Sub-Category, Item Type, Merchandise, Manufacturer, Price, UOM and other product specific information.
  • User should also be able to map product’s barcode, product’s batch.
  • User should also be able to create bill of material products or package products by combining 2 products to produce a new product.
  • System should provide option to users to create batches based on the product MRP.
  • System should be able to manage the GKM of the product during GRN process.
    User should be able to create the Departments, Category, Sub-Category, Item Type, Merchandise, Manufacturer, and Classification for the products.

UI/Layout

TenthPlanet_Compiere_Retails_Manage_Product

 

TenthPlanet_Compiere_Retails_Manage_Products 2

TenthPlanet_Compiere_Retails_Manage_Products 3

Manage Department, Category, Sub-Category

The Product Department allows you to define different groups of products, their category and sub-category. These groups, categories and sub-categories can be used in generating different reports and for easily identifying the sales or purchase value.

Business Rules

  • Users should be able to create any number of Departments.
  • Under each department they should be able to configure multiple categories and under each category there should be multiple sub-categories.

UI/Layout

TenthPlanet_Compiere_Retails_Manage_Manage_Department_Category_Sub-Category

TenthPlanet_Compiere_Retails_Manage_Manage_Department_Category_Sub-Category 2

TenthPlanet_Compiere_Retails_Manage_Manage_Department_Category_Sub-Category 3

Manage Brand

The Product Brand allows you to define multiple product brands. These brands can be mapped to multiple products. Once the brand is mapped, brand based sales or purchase of products can be easy fetched for business users/owners.

Business Rules

  • Users should be able to create any number of Brands.
  • User should also be able map one brand against one product.
  • User should be able to use brand as parameter in reports for generating reports.

UI/Layout

TenthPlanet_Compiere_Retails_Manage_Brand

Multiple units of measurements; buy in Cases and Pieces

It allows users to configure or create multiple units of measure. The default UOMs like kgs, grams, each, etc. are available by default.
Users can configure the UOM conversion for products between 2 units of measure. Once that is done users can buy using one UOM and sell using another UOM. But finally the system will calculate the product stock based on the product’s base UOM.

Business Rules

  • Users should be able to configure different UOMs using the Unit of Measure master.
  • User should be able to select the base UOM for a product in the product master.
  • User should be able to configure the conversion between 1 UOM to another UOM using the product master.

UI/Layout

TenthPlanet_Compiere_Retails_Multiple_units_of_measurements_buy_in_Cases_and_Pieces

TenthPlanet_Compiere_Retails_Multiple_units_of_measurements_buy_in_Cases_and_Pieces 2

SET/Product Barcode Print

Users can use the barcode screen to print any number of products with any number of label counts. They can also store the list of products as a group for future printing if the same set of product is going to be printed repeatedly. The users can also choose the different list of parameters that need to be printed as part of the sticker.

Business Rules

  • User should be able to create and save a group of products for barcode printing.
  • User should be able to select the type of sticker that needs to be printed.
  • User should be able to select the products in the “Barcode Line” tab and configure required parameters that need to be printed.
  • User can also select the label count that needs to be printed.
  • Once these labels are printed, the users can recall the same set of products using this screen and print the same number of labels as they are already saved.

UI/Layout

TenthPlanet_Compiere_Retails_SET_Product Barcode_Print

TenthPlanet_Compiere_Retails_SET_Product Barcode_Print 2

Batch Update Processes

Using Retail ERP users can do several different batch processes for managing their master data. These different batch update processes help the users to reduce their operations time and concentrate on their business process.

Business Rules

  • Deactivate products in bulk (The system allows users to deactivate either a batch or a product in batches instead of one-by-one. Only when there is no stock available the users can either deactivate the product or a batch)
  • Update Product Attributes in bulk (The system allows users to update the product attributes like Brand, Department, Category, Sub-Category,  Merchandise, Classification, etc in batches. Users can filter a set of products based on different attributes and select the specific attribute/value that needs to be updated for those selected products. This process does the rest and updates the attributes for the selected products)
  • Update Product GKM % in bulk (The system allows users to update the GKM for all products or a set of products selected based on different attribute filters.Users can set the mark down percentage that needs to be set for the selected products and update the same in product master)
  • Update Product MRPs in bulk – Users can update the MRP of a product (non-batched products) based the current selling and a fixed margin.

UI/Layout

TenthPlanet_Compiere_Retails_Batch_Update_Processes

TenthPlanet_Compiere_Retails_Batch_Update_Processes 2

TenthPlanet_Compiere_Retails_Batch_Update_Processes 3

Produce packaged products

Users can produce packaged products which is a combination of different other products (for e.g., 3 biscuits packets combined together as a single products or rice bought from vendors in 100 kg bags converted into 1 kg packets of 100 qty). Packaging helps to convert one product into another.

Business Rules
System should allow users to configure bill of material products for loose staples, weighing scale products.
User can configure the different products that form another product in the product package tab and the qty that it requires to convert into that BOM product.F

UI/Layout

TenthPlanet_Compiere_Retails_Produce_Packaged_Products

TenthPlanet_Compiere_Retails_Produce_Packaged_Products 2

TenthPlanet_Compiere_Retails_Produce_Packaged_Products 3

Real Time Inventory Management

Retail ERP Point of Sale manages all types of inventory. You can track sales and stock on hand for a particular item. Advanced functionality includes the ability to track items by batches, group items e.g., sell as a kit, or purchase and sell in different units of measurements e.g. buy a case or sell as a 6 pack, handle weighing scale products. Or perhaps you need to track sales by units of measure* such as kilograms, metres or litres. Do cycle counting, adjust stocks and transfer stock between warehouses.

Opening Stock Update – As part of the inventory management module Retail ERP ERP & POS provides options for customers to update their stock. This could be their opening balance from a previous year or the stock from a different legacy application.

Business Rules

  • Users will be able to update the opening stock using the physical inventory screen warehouse-wise, locator-wise quickly and easily
  • The existing stock will be wiped-off completely and the new stock given via CSV, Excel will be updated into the system
  • Setting the opening stock this way helps users to complete the process quickly and easily

UI/Layout

TenthPlanet_Compiere_Retails_Opening_Stock_Update

TenthPlanet_Compiere_Retails_Opening_Stock_Update 2

TenthPlanet_Compiere_Retails_Opening_Stock_Update 3

TenthPlanet_Compiere_Retails_Opening_Stock_Update 4

Cycle Counting and Product/Batch Stock Adjustment

The cycle counting process helps the users to do match physical stock vs system stock periodically for a specific department, category, sub-category, etc. and adjust the stock according to the physical. This helps the users to keep the stock accuracy level to a maximum.

Business Rules

  • The Physical Inventory screen allows users to do cycle counting based on multiple product attributes.
  • Based on the filter, system creates the different products and its batches with their existing book qty.
  • Users can adjust increase stock in one batch and decrease stock in another batch using the batch adjustment process.

UI/Layout

TenthPlanet_Compiere_Retails_Cycle_Counting_and_Product_Batch_Stock_Adjustment

TenthPlanet_Compiere_Retails_Cycle_Counting_and_Product_Batch_Stock_Adjustment 2

TenthPlanet_Compiere_Retails_Cycle_Counting_and_Product_Batch_Stock_Adjustment 3

Stock Transfers

Stock transfer process in Retail ERP helps users to transfer stock from one location to another systematically and receive the stock accurately. As part of the stock transfer process the users have to perform 2 steps. Step 1 is to process a stock transfer document from the source warehouse and transfer the stock to in-transit warehouse. Step 2 is to process another stock transfer document at the destination warehouse to receive the stock from the in-transit warehouse.

Business Rules

  • There are 2 different screens that can be used for stock transfer and stock receive.
  • Stock receive is used by the source warehouse users and stock receive is used by the destination warehouse users.
  • Once a set of products are created as part of the stock transfer and processed, the same stock transfer document can be selected and used for receiving purposes in the stock receive screen.
  • Printing the details of the stock transfer document helps the users to manually verify and complete the whole process from source to destination.

UI/Layout

TenthPlanet_Compiere_Retails_Stock_Transfers

TenthPlanet_Compiere_Retails_Stock_Transfers 2

TenthPlanet_Compiere_Retails_Stock_Transfers

TenthPlanet_Compiere_Retails_Stock_Transfers_4

Inventory Movement Package

The inventory movement package option helps the users to move stock from one location to another based on a particular GRN document or Pick List document. For e.g., you do a Material Receipt from a vendor and process a GRN document. This stock needs to be moved from Warehouse to the Selling Floor. You can use the stock transfer screen and call upon the GRN document to move all the stock from that GRN to the Selling Floor via stock transfer.
In the same way you do a Pick List for a set of products. Based on the Pick List document, you can move this stock from one location to another location using the Stock Transfer.

Business Rules

  • Inventory Movement Package is a utility by which users can move stock from one location to another quickly and easily when there is just a transfer of document based stock
  • Manual product scanning work for users will be reduced when doing stock transfer.

UI/Layout

TenthPlanet_Compiere_Retails_Inventory_Movement_Package

TenthPlanet_Compiere_Retails_Inventory_Movement_Package 2

Integrated HHT based Stock Management

Retail ERP Hand Held App based Stock Management system helps users to receive stock from vendor, do stock transfer on the go and also do stock take quickly and easily.
This App based stock management process is easy to use and makes all the stock related processes quicker and efficient.
Manual labor involving carrying product boxes to the desktop based barcode scanner is not required anymore. It’s all wireless based app.

HHT based Stock Take

The HHT based stock take app helps users to go each across Bay, Shelf, and Bin, scan the products and do the counting using the HHT and complete the stock take process within 50% of the time taken while doing a manual counting.

Business Rules

  • System should allow users to create a stock take document and scan all their products quickly.
  • System should allow users to input the current physical stock batch-wise locator-wise into the stock take document.
  • Users can convert the stock take documents to physical inventory documents for updating the stock to match the physical stock.

UI/Layout

TenthPlanet_Compiere_Retails_HHT_based_Stock_Take

TenthPlanet_Compiere_Retails_HHT_based_Stock_Take 2

HHT based Barcode scanning/printing

HHT app in Retail ERP provides for barcode scanning/printing. Users can take their scanning device with them in the selling floor or warehouse. They can scan the products or shelves where additional stickers need to be printed. Retail ERP app captures this information. Using this information in Retail ERP users can print the barcodes using the desktop app and stick it either in the product or in the shelves.

Business Rules

  • Users can open the Barcode Scan screen for scanning the products
  • Users should be able to scan the product either based on batch barcode or vendor/manufacturer barcode
  • Users should be able to store these set of scanned barcodes/products for printing at a later time also

UI/Layout

TenthPlanet_Compiere_Retails_HHT_based_Barcode_scanning_printing

TenthPlanet_Compiere_Retails_HHT_based_Barcode_scanning_printing 2

TenthPlanet_Compiere_Retails_HHT_based_Barcode_scanning_printing 3

TenthPlanet_Compiere_Retails_HHT_based_Barcode_scanning_printing 4

Pick List Management

The pick list management process helps warehouse users to lookup products based on different parameters and identify the products that need to be picked.
The stock for a specific product may be short compared to what is required in that warehouse. In this case users can select that product for picking from another warehouse where stock is available.
This process helps users to do stock transfer easily and quickly reducing product scanning time.

Create Pick List for generating stock transfers

The pick list screen allows users to identify list of products for stock transfer from one warehouse to another based on current available quantity.
This pick list can be reused in stock transfer process for transferring product stock quickly without reentering the same set of products in the stock transfer screen manually.

Business Rules

  • User should be able to open the stock transfer screen and use the “Pick Products” option to find out products that have less stock in specific warehouses
  • User should be able to select the products based on different parameters associated with products
  • The pick products should show the products along with its stock information for different warehouses
  • The system should also suggest the product qty that needs to be picked based on different ordering type

UI/Layout

TenthPlanet_Compiere_Retails_Pick_List_Management

TenthPlanet_Compiere_Retails_Pick_List_Management 2

TenthPlanet_Compiere_Retails_Pick_List_Management 3

Copy products from pick list

The stock transfer screen in Retail ERP allows users to copy a set of products from pick list document for easy stock transfers.

Business Rules

  • Users should be able to create a stock transfer document from either godown or selling floor
  • Users should be able to select a specific pick list and copy all its lines into the current stock transfer document
  • System should copy all the product lines from the pick list selected into the stock transfer screen

UI/Layout

TenthPlanet_Compiere_Retails_Copy_Products_from_Pick_List

TenthPlanet_Compiere_Retails_Copy_Products_from_Pick_List 2

TenthPlanet_Compiere_Retails_Copy_Products_from_Pick_List 3

Comparison Table

Brand

Master screen to create/delete/edit Brand Information. This Brand can be mapped to specific products for Brand Wise reporting.

Table Name DB Field Name Super Store Work Edition
UM_Brand AD_Client_ID DEFAULT Adempiere 3.7
UM_Brand AD_Org_ID DEFAULT Adempiere 3.7
UM_Brand Created HIDDEN Adempiere 3.7
UM_Brand CreatedBy HIDDEN Adempiere 3.7
UM_Brand Description DEFAULT Adempiere 3.7
UM_Brand IsActive DEFAULT Adempiere 3.7
UM_Brand Name DEFAULT Adempiere 3.7
UM_Brand UM_BrandCode ADDED Adempiere 3.7
UM_Brand UM_Brand_ID HIDDEN Adempiere 3.7
UM_Brand UM_Manufacturer_ID HIDDEN Adempiere 3.7
UM_Brand UM_Merchandise_ID HIDDEN Adempiere 3.7
UM_Brand UM_Product_Subcategory_ID HIDDEN Adempiere 3.7
UM_Brand Updated HIDDEN Adempiere 3.7
UM_Brand UpdatedBy HIDDEN Adempiere 3.7

Classification

Master screen to manage product classifications like weighing scale or normal products.

Table Name DB Field Name Super Store Work Edition
UM_Classification AD_Client_ID HIDDEN Adempiere 3.7
UM_Classification AD_Org_ID HIDDEN Adempiere 3.7
UM_Classification Created HIDDEN Adempiere 3.7
UM_Classification CreatedBy HIDDEN Adempiere 3.7
UM_Classification Description DEFAULT Adempiere 3.7
UM_Classification IsActive DEFAULT Adempiere 3.7
UM_Classification Name HIDDEN Adempiere 3.7
UM_Classification UM_ClassificationCode ADDED Adempiere 3.7
UM_Classification UM_Classification_ID HIDDEN Adempiere 3.7
UM_Classification UM_ClassificationName ADDED Adempiere 3.7
UM_Classification Updated HIDDEN Adempiere 3.7
UM_Classification UpdatedBy HIDDEN Adempiere 3.7
UM_Classification Value HIDDEN Adempiere 3.7

Commodity Code

Screen to Manage Retail Commodity Code information which can be mapped against product for Tax purposes. (This screen was used prior to GST implementation in India. This configuration is no longer required).

Table Name DB Field Name Super Store Work Edition
UM_CommodityCode AD_Client_ID DEFAULT Adempiere 3.7
UM_CommodityCode AD_Org_ID DEFAULT Adempiere 3.7
UM_CommodityCode CommodityCode ADDED Adempiere 3.7
UM_CommodityCode Created HIDDEN Adempiere 3.7
UM_CommodityCode CreatedBy HIDDEN Adempiere 3.7
UM_CommodityCode C_TaxCategory_ID DEFAULT Adempiere 3.7
UM_CommodityCode Description DEFAULT Adempiere 3.7
UM_CommodityCode IsActive DEFAULT Adempiere 3.7
UM_CommodityCode Name HIDDEN Adempiere 3.7
UM_CommodityCode UM_CommodityCode_ID HIDDEN Adempiere 3.7
UM_CommodityCode UM_ItemNo ADDED Adempiere 3.7
UM_CommodityCode UM_PartNo ADDED Adempiere 3.7
UM_CommodityCode UM_Schedule ADDED Adempiere 3.7
UM_CommodityCode UM_SubItemNo ADDED Adempiere 3.7
UM_CommodityCode Updated HIDDEN Adempiere 3.7
UM_CommodityCode UpdatedBy HIDDEN Adempiere 3.7
UM_CommodityCode Value DEFAULT Adempiere 3.7

Item Type

Screen to manage the product’s type like REGULAR, SEASONAL, etc. This can be mapped to specific products and later used for reporting purposes.

Table Name DB Field Name Super Store Work Edition
UM_ITemType AD_Client_ID DEFAULT Adempiere 3.7
UM_ITemType AD_Org_ID DEFAULT Adempiere 3.7
UM_ITemType Created HIDDEN Adempiere 3.7
UM_ITemType CreatedBy HIDDEN Adempiere 3.7
UM_ITemType Description DEFAULT Adempiere 3.7
UM_ITemType IsActive DEFAULT Adempiere 3.7
UM_ITemType Name DEFAULT Adempiere 3.7
UM_ITemType UM_ItemTypeCode ADDED Adempiere 3.7
UM_ITemType UM_ITemType_ID HIDDEN Adempiere 3.7
UM_ITemType Updated HIDDEN Adempiere 3.7
UM_ITemType UpdatedBy HIDDEN Adempiere 3.7
UM_ITemType Value DEFAULT Adempiere 3.7

Margin

This screen is used for managing Vendor Margin Ranges and is used for calculating the Selling Price based on MRP.

Table Name DB Field Name Super Store Work Edition
UM_Margin AD_Client_ID HIDDEN Adempiere 3.7
UM_Margin AD_Org_ID HIDDEN Adempiere 3.7
UM_Margin Created HIDDEN Adempiere 3.7
UM_Margin CreatedBy HIDDEN Adempiere 3.7
UM_Margin Discount ADDED Adempiere 3.7
UM_Margin IsActive DEFAULT Adempiere 3.7
UM_Margin UM_FromRange ADDED Adempiere 3.7
UM_Margin UM_Margin_ID HIDDEN Adempiere 3.7
UM_Margin UM_ToRange ADDED Adempiere 3.7
UM_Margin UM_UpdateProductPrice ADDED Adempiere 3.7
UM_Margin Updated HIDDEN Adempiere 3.7
UM_Margin UpdatedBy HIDDEN Adempiere 3.7

HSN Code

HSN Code screen is used for managing the HSN Code Details that are required to be assigned to products for GST Tax Purposes.

Table Name DB Field Name Super Store Work Edition
UM_HSNCode AD_Client_ID DEFAULT Adempiere 3.7
UM_HSNCode AD_Org_ID DEFAULT Adempiere 3.7
UM_HSNCode Created HIDDEN Adempiere 3.7
UM_HSNCode CreatedBy HIDDEN Adempiere 3.7
UM_HSNCode C_TaxCategory_ID DEFAULT Adempiere 3.7
UM_HSNCode Description DEFAULT Adempiere 3.7
UM_HSNCode IsActive DEFAULT Adempiere 3.7
UM_HSNCode UM_HSNCode ADDED Adempiere 3.7
UM_HSNCode UM_HSNCode_ID HIDDEN Adempiere 3.7
UM_HSNCode Updated HIDDEN Adempiere 3.7
UM_HSNCode UpdatedBy HIDDEN Adempiere 3.7
UM_HSNCode Value DEFAULT Adempiere 3.7

Product Price

Product Price screen is used for managing the product’s Selling Price information. It is just for viewing purpose only.

Table Name DB Field Name Super Store Work Edition
M_ProductPrice AD_Client_ID HIDDEN Adempiere 3.7
M_ProductPrice AD_Org_ID HIDDEN Adempiere 3.7
M_ProductPrice BaseBillingPrice ADDED Adempiere 3.7
M_ProductPrice Created HIDDEN Adempiere 3.7
M_ProductPrice CreatedBy HIDDEN Adempiere 3.7
M_ProductPrice IsActive DEFAULT Adempiere 3.7
M_ProductPrice M_AttributeSetInstance_ID HIDDEN Adempiere 3.7
M_ProductPrice M_PriceList_Version_ID HIDDEN Adempiere 3.7
M_ProductPrice M_Product_ID DEFAULT Adempiere 3.7
M_ProductPrice PriceLimit DEFAULT Adempiere 3.7
M_ProductPrice PriceList DEFAULT Adempiere 3.7
M_ProductPrice PriceStd DEFAULT Adempiere 3.7
M_ProductPrice Rate DEFAULT Adempiere 3.7
M_ProductPrice UM_BatchPrice_ID HIDDEN Adempiere 3.7
M_ProductPrice UM_LandingCost ADDED Adempiere 3.7
M_ProductPrice UM_ProductMargin ADDED Adempiere 3.7
M_ProductPrice UPC ADDED Adempiere 3.7
M_ProductPrice Updated HIDDEN Adempiere 3.7
M_ProductPrice UpdatedBy HIDDEN Adempiere 3.7

Form Configuration

Form Configuration is the screen that can be used for configuration a pre-defined template of Form based screen with Search Parameters, Columns to be shown with the search and the process that can be executed against these records.

Table Name DB Field Name Super Store Work Edition
UM_TableSearch AD_Client_ID HIDDEN Adempiere 3.7
UM_TableSearch AD_Org_ID HIDDEN Adempiere 3.7
UM_TableSearch AD_Tab_ID DEFAULT Adempiere 3.7
UM_TableSearch AD_Table_ID DEFAULT Adempiere 3.7
UM_TableSearch Created HIDDEN Adempiere 3.7
UM_TableSearch CreatedBy HIDDEN Adempiere 3.7
UM_TableSearch IsActive DEFAULT Adempiere 3.7
UM_TableSearch IsForm HIDDEN Adempiere 3.7
UM_TableSearch SearchType HIDDEN Adempiere 3.7
UM_TableSearch UM_BatchPrice_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_CouponCol_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_FormType ADDED Adempiere 3.7
UM_TableSearch UM_FreeItemBatchCol_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_FreeItemCol_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_GSTTax HIDDEN Adempiere 3.7
UM_TableSearch UM_GSTTax_Purchase HIDDEN Adempiere 3.7
UM_TableSearch UM_InventoryType HIDDEN Adempiere 3.7
UM_TableSearch UM_ITColumn_ID ADDED Adempiere 3.7
UM_TableSearch UM_OMColumn_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_OrderingMethod HIDDEN Adempiere 3.7
UM_TableSearch UM_PMColumn_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_TableSearch_ID HIDDEN Adempiere 3.7
UM_TableSearch UM_TaxType ADDED Adempiere 3.7
UM_TableSearch Updated HIDDEN Adempiere 3.7
UM_TableSearch UpdatedBy HIDDEN Adempiere 3.7
UM_FilterFields AD_Client_ID HIDDEN Adempiere 3.7
UM_FilterFields AD_Column_ID DEFAULT Adempiere 3.7
UM_FilterFields AD_Org_ID HIDDEN Adempiere 3.7
UM_FilterFields Created HIDDEN Adempiere 3.7
UM_FilterFields CreatedBy HIDDEN Adempiere 3.7
UM_FilterFields IsActive DEFAULT Adempiere 3.7
UM_FilterFields Sequence DEFAULT Adempiere 3.7
UM_FilterFields UM_FilterFields_ID HIDDEN Adempiere 3.7
UM_FilterFields UM_GSTTax HIDDEN Adempiere 3.7
UM_FilterFields UM_InventoryType HIDDEN Adempiere 3.7
UM_FilterFields UM_TableSearch_ID ADDED Adempiere 3.7
UM_FilterFields Updated HIDDEN Adempiere 3.7
UM_FilterFields UpdatedBy HIDDEN Adempiere 3.7
UM_DisplayFields AD_Client_ID HIDDEN Adempiere 3.7
UM_DisplayFields AD_Column_ID DEFAULT Adempiere 3.7
UM_DisplayFields AD_Org_ID HIDDEN Adempiere 3.7
UM_DisplayFields Created HIDDEN Adempiere 3.7
UM_DisplayFields CreatedBy HIDDEN Adempiere 3.7
UM_DisplayFields IsActive DEFAULT Adempiere 3.7
UM_DisplayFields Sequence DEFAULT Adempiere 3.7
UM_DisplayFields UM_DataType ADDED Adempiere 3.7
UM_DisplayFields UM_DisplayFields_ID HIDDEN Adempiere 3.7
UM_DisplayFields UM_IsEditable ADDED Adempiere 3.7
UM_DisplayFields UM_TableSearch_ID ADDED Adempiere 3.7
UM_DisplayFields Updated HIDDEN Adempiere 3.7
UM_DisplayFields UpdatedBy HIDDEN Adempiere 3.7

Unit of Measure

The Unit of Measure Window is used to define non monetary units of measure. It also defines if conversion between units of measure are allowed and how they are to be performed. The system provides some automatic conversions between units of measures (e.g. minute, hour, day, working day, etc.) if they are not explicitly defined here. Conversions need to be direct (i.e. if you have only a conversion between A-B and B-C, the system cannot convert A-C, you need to define it explicitly).

Table Name DB Field Name Super Store Work Edition
C_UOM AD_Client_ID DEFAULT Adempiere 3.7
C_UOM AD_Org_ID DEFAULT Adempiere 3.7
C_UOM CostingPrecision DEFAULT Adempiere 3.7
C_UOM Created HIDDEN Adempiere 3.7
C_UOM CreatedBy HIDDEN Adempiere 3.7
C_UOM C_UOM_ID HIDDEN Adempiere 3.7
C_UOM Description DEFAULT Adempiere 3.7
C_UOM IsActive DEFAULT Adempiere 3.7
C_UOM IsDefault DEFAULT Adempiere 3.7
C_UOM Name DEFAULT Adempiere 3.7
C_UOM StdPrecision DEFAULT Adempiere 3.7
C_UOM UOMSymbol DEFAULT Adempiere 3.7
C_UOM UOMType DEFAULT Adempiere 3.7
C_UOM Updated HIDDEN Adempiere 3.7
C_UOM UpdatedBy HIDDEN Adempiere 3.7
C_UOM X12DE355 DEFAULT Adempiere 3.7
C_UOM_Trl AD_Client_ID DEFAULT Adempiere 3.7
C_UOM_Trl AD_Language DEFAULT Adempiere 3.7
C_UOM_Trl AD_Org_ID DEFAULT Adempiere 3.7
C_UOM_Trl Created HIDDEN Adempiere 3.7
C_UOM_Trl CreatedBy HIDDEN Adempiere 3.7
C_UOM_Trl C_UOM_ID DEFAULT Adempiere 3.7
C_UOM_Trl Description DEFAULT Adempiere 3.7
C_UOM_Trl IsActive DEFAULT Adempiere 3.7
C_UOM_Trl IsTranslated DEFAULT Adempiere 3.7
C_UOM_Trl Name DEFAULT Adempiere 3.7
C_UOM_Trl UOMSymbol DEFAULT Adempiere 3.7
C_UOM_Trl Updated HIDDEN Adempiere 3.7
C_UOM_Trl UpdatedBy HIDDEN Adempiere 3.7
C_UOM_Conversion AD_Client_ID DEFAULT Adempiere 3.7
C_UOM_Conversion AD_Org_ID DEFAULT Adempiere 3.7
C_UOM_Conversion Created HIDDEN Adempiere 3.7
C_UOM_Conversion CreatedBy HIDDEN Adempiere 3.7
C_UOM_Conversion C_UOM_Conversion_ID HIDDEN Adempiere 3.7
C_UOM_Conversion C_UOM_ID DEFAULT Adempiere 3.7
C_UOM_Conversion C_UOM_To_ID DEFAULT Adempiere 3.7
C_UOM_Conversion DivideRate DEFAULT Adempiere 3.7
C_UOM_Conversion IsActive DEFAULT Adempiere 3.7
C_UOM_Conversion M_Product_ID DEFAULT Adempiere 3.7
C_UOM_Conversion MultiplyRate DEFAULT Adempiere 3.7
C_UOM_Conversion Updated HIDDEN Adempiere 3.7
C_UOM_Conversion UpdatedBy HIDDEN Adempiere 3.7

Product

Maintain Products
The Product Window defines all products used by an organization. These products include those sold to customers, used in the manufacture of products sold to customers and products purchased by an organization.

Table Name DB Field Name Super Store Work Edition
M_Product AD_Client_ID HIDDEN Adempiere 3.7
M_Product AD_Org_ID HIDDEN Adempiere 3.7
M_Product C_BPartner_ID HIDDEN Adempiere 3.7
M_Product C_Country_ID HIDDEN Adempiere 3.7
M_Product Classification HIDDEN Adempiere 3.7
M_Product CopyFrom HIDDEN Adempiere 3.7
M_Product CountryName HIDDEN Adempiere 3.7
M_Product Created HIDDEN Adempiere 3.7
M_Product CreatedBy HIDDEN Adempiere 3.7
M_Product C_RevenueRecognition_ID HIDDEN Adempiere 3.7
M_Product C_SubscriptionType_ID HIDDEN Adempiere 3.7
M_Product C_TaxCategory_ID DEFAULT Adempiere 3.7
M_Product C_UOM_ID DEFAULT Adempiere 3.7
M_Product Deactivate ADDED Adempiere 3.7
M_Product Description HIDDEN Adempiere 3.7
M_Product DescriptionURL HIDDEN Adempiere 3.7
M_Product Discontinued DEFAULT Adempiere 3.7
M_Product DiscontinuedAt HIDDEN Adempiere 3.7
M_Product DiscontinuedBy HIDDEN Adempiere 3.7
M_Product DocumentNote HIDDEN Adempiere 3.7
M_Product DownloadURL HIDDEN Adempiere 3.7
M_Product Group1 HIDDEN Adempiere 3.7
M_Product Group2 HIDDEN Adempiere 3.7
M_Product GuaranteeDays HIDDEN Adempiere 3.7
M_Product GuaranteeDaysMin HIDDEN Adempiere 3.7
M_Product Help HIDDEN Adempiere 3.7
M_Product ImageURL HIDDEN Adempiere 3.7
M_Product IsActive HIDDEN Adempiere 3.7
M_Product IsBOM DEFAULT Adempiere 3.7
M_Product IsDropShip HIDDEN Adempiere 3.7
M_Product IsExcludeAutoDelivery HIDDEN Adempiere 3.7
M_Product IsInvoicePrintDetails HIDDEN Adempiere 3.7
M_Product IsPickListPrintDetails HIDDEN Adempiere 3.7
M_Product IsPurchased HIDDEN Adempiere 3.7
M_Product IsSelfService HIDDEN Adempiere 3.7
M_Product IsSold HIDDEN Adempiere 3.7
M_Product IsStocked HIDDEN Adempiere 3.7
M_Product IsSummary HIDDEN Adempiere 3.7
M_Product istoformule HIDDEN Adempiere 3.7
M_Product IsVerified HIDDEN Adempiere 3.7
M_Product IsWebStoreFeatured DEFAULT Adempiere 3.7
M_Product LowLevel HIDDEN Adempiere 3.7
M_Product M_AttributeSet_ID DEFAULT Adempiere 3.7
M_Product M_AttributeSetInstance_ID HIDDEN Adempiere 3.7
M_Product M_FreightCategory_ID HIDDEN Adempiere 3.7
M_Product M_Locator_ID HIDDEN Adempiere 3.7
M_Product M_Product_Category_ID DEFAULT Adempiere 3.7
M_Product M_Product_ID HIDDEN Adempiere 3.7
M_Product Name DEFAULT Adempiere 3.7
M_Product Processing ADDED Adempiere 3.7
M_Product ProductType HIDDEN Adempiere 3.7
M_Product R_MailText_ID HIDDEN Adempiere 3.7
M_Product SalesRep_ID HIDDEN Adempiere 3.7
M_Product S_ExpenseType_ID HIDDEN Adempiere 3.7
M_Product ShelfDepth HIDDEN Adempiere 3.7
M_Product ShelfHeight HIDDEN Adempiere 3.7
M_Product ShelfWidth HIDDEN Adempiere 3.7
M_Product SKU HIDDEN Adempiere 3.7
M_Product S_Resource_ID HIDDEN Adempiere 3.7
M_Product UM_ApprovedBy HIDDEN Adempiere 3.7
M_Product UM_ApprovedDate HIDDEN Adempiere 3.7
M_Product UM_BasicCost ADDED Adempiere 3.7
M_Product UM_BefLandCost ADDED Adempiere 3.7
M_Product UM_Brand_ID ADDED Adempiere 3.7
M_Product UM_CashDisPer ADDED Adempiere 3.7
M_Product UM_CashDisValue ADDED Adempiere 3.7
M_Product UM_CessAmt ADDED Adempiere 3.7
M_Product UM_CessTaxCategory_ID ADDED Adempiere 3.7
M_Product UM_Classification_ID HIDDEN Adempiere 3.7
M_Product UM_CommodityCode_ID ADDED Adempiere 3.7
M_Product UM_CreateNewBatch ADDED Adempiere 3.7
M_Product UM_Discount ADDED Adempiere 3.7
M_Product UM_DiscountAmt ADDED Adempiere 3.7
M_Product UM_FirstMovementDate HIDDEN Adempiere 3.7
M_Product UM_FreightCharges ADDED Adempiere 3.7
M_Product UM_GKM ADDED Adempiere 3.7
M_Product UM_GrossCost1 ADDED Adempiere 3.7
M_Product UM_GrossCost2 ADDED Adempiere 3.7
M_Product UM_HSNCode_ID ADDED Adempiere 3.7
M_Product UM_IsApproved ADDED Adempiere 3.7
M_Product UM_IsBatch ADDED Adempiere 3.7
M_Product UM_IsExpiry HIDDEN Adempiere 3.7
M_Product UM_IsLoyalty HIDDEN Adempiere 3.7
M_Product UM_isMRPAutoUpdate ADDED Adempiere 3.7
M_Product UM_IsRestrictMRPcalculation ADDED Adempiere 3.7
M_Product UM_IsService HIDDEN Adempiere 3.7
M_Product UM_ITemType_ID ADDED Adempiere 3.7
M_Product UM_LastMRDate ADDED Adempiere 3.7
M_Product UM_LastPODate ADDED Adempiere 3.7
M_Product UM_Manufacturer_ID ADDED Adempiere 3.7
M_Product UM_MarkDown ADDED Adempiere 3.7
M_Product UM_MarkUp ADDED Adempiere 3.7
M_Product UM_Merchandise_ID ADDED Adempiere 3.7
M_Product UM_MRP ADDED Adempiere 3.7
M_Product UM_Name ADDED Adempiere 3.7
M_Product UM_NetCost ADDED Adempiere 3.7
M_Product UM_Product_Department_ID ADDED Adempiere 3.7
M_Product UM_Product_Subcategory_ID ADDED Adempiere 3.7
M_Product UM_PurchaseTaxCategory_ID ADDED Adempiere 3.7
M_Product UM_PurchaseVATAmt ADDED Adempiere 3.7
M_Product UM_QtyLastMR ADDED Adempiere 3.7
M_Product UM_QtyLastPO ADDED Adempiere 3.7
M_Product UM_QtyLimit ADDED Adempiere 3.7
M_Product UM_SchemeDiscount ADDED Adempiere 3.7
M_Product UM_SchemeDiscountAmt ADDED Adempiere 3.7
M_Product UM_SellingMargin HIDDEN Adempiere 3.7
M_Product UM_SellingMarginMRP ADDED Adempiere 3.7
M_Product UM_SellingMarginNC ADDED Adempiere 3.7
M_Product UM_SellingMarginType ADDED Adempiere 3.7
M_Product UM_SellingPrice ADDED Adempiere 3.7
M_Product UM_WSP1 ADDED Adempiere 3.7
M_Product UM_WSP1Margin ADDED Adempiere 3.7
M_Product UM_WSP1MarginLC ADDED Adempiere 3.7
M_Product UM_WSP2 ADDED Adempiere 3.7
M_Product UM_WSP2Margin ADDED Adempiere 3.7
M_Product UM_WSP2MarginLC ADDED Adempiere 3.7
M_Product UM_WSP3 ADDED Adempiere 3.7
M_Product UM_WSP3Margin ADDED Adempiere 3.7
M_Product UM_WSP3MarginLC ADDED Adempiere 3.7
M_Product UnitsPerPack HIDDEN Adempiere 3.7
M_Product UnitsPerPallet HIDDEN Adempiere 3.7
M_Product UPC HIDDEN Adempiere 3.7
M_Product Updated HIDDEN Adempiere 3.7
M_Product UpdatedBy HIDDEN Adempiere 3.7
M_Product Value DEFAULT Adempiere 3.7
M_Product VersionNo HIDDEN Adempiere 3.7
M_Product Volume HIDDEN Adempiere 3.7
M_Product Weight HIDDEN Adempiere 3.7
UM_Product_BarCode AD_Client_ID HIDDEN Adempiere 3.7
UM_Product_BarCode AD_Org_ID HIDDEN Adempiere 3.7
UM_Product_BarCode Created HIDDEN Adempiere 3.7
UM_Product_BarCode CreatedBy HIDDEN Adempiere 3.7
UM_Product_BarCode Description DEFAULT Adempiere 3.7
UM_Product_BarCode IsActive DEFAULT Adempiere 3.7
UM_Product_BarCode M_Product_ID DEFAULT Adempiere 3.7
UM_Product_BarCode UM_BarCode ADDED Adempiere 3.7
UM_Product_BarCode UM_Product_BarCode_ID HIDDEN Adempiere 3.7
UM_Product_BarCode Updated HIDDEN Adempiere 3.7
UM_Product_BarCode UpdatedBy HIDDEN Adempiere 3.7
M_Product_PO AD_Client_ID HIDDEN Adempiere 3.7
M_Product_PO AD_Org_ID HIDDEN Adempiere 3.7
M_Product_PO C_BPartner_ID DEFAULT Adempiere 3.7
M_Product_PO C_Currency_ID DEFAULT Adempiere 3.7
M_Product_PO CostPerOrder HIDDEN Adempiere 3.7
M_Product_PO Created HIDDEN Adempiere 3.7
M_Product_PO CreatedBy HIDDEN Adempiere 3.7
M_Product_PO C_UOM_ID HIDDEN Adempiere 3.7
M_Product_PO DeliveryTime_Actual HIDDEN Adempiere 3.7
M_Product_PO DeliveryTime_Promised HIDDEN Adempiere 3.7
M_Product_PO Discontinued HIDDEN Adempiere 3.7
M_Product_PO DiscontinuedAt HIDDEN Adempiere 3.7
M_Product_PO IsActive HIDDEN Adempiere 3.7
M_Product_PO IsCurrentVendor DEFAULT Adempiere 3.7
M_Product_PO Manufacturer HIDDEN Adempiere 3.7
M_Product_PO M_Product_ID DEFAULT Adempiere 3.7
M_Product_PO Order_Min HIDDEN Adempiere 3.7
M_Product_PO Order_Pack HIDDEN Adempiere 3.7
M_Product_PO PriceEffective HIDDEN Adempiere 3.7
M_Product_PO PriceLastInv HIDDEN Adempiere 3.7
M_Product_PO PriceLastPO DEFAULT Adempiere 3.7
M_Product_PO PriceList HIDDEN Adempiere 3.7
M_Product_PO PricePO DEFAULT Adempiere 3.7
M_Product_PO QualityRating HIDDEN Adempiere 3.7
M_Product_PO RoyaltyAmt HIDDEN Adempiere 3.7
M_Product_PO UM_VendorQtyLastMR HIDDEN Adempiere 3.7
M_Product_PO UM_VendorQtyLastPO HIDDEN Adempiere 3.7
M_Product_PO UM_VendorQtyLastPODate HIDDEN Adempiere 3.7
M_Product_PO UPC HIDDEN Adempiere 3.7
M_Product_PO Updated HIDDEN Adempiere 3.7
M_Product_PO UpdatedBy HIDDEN Adempiere 3.7
M_Product_PO VendorCategory HIDDEN Adempiere 3.7
M_Product_PO VendorProductNo HIDDEN Adempiere 3.7
M_Replenish AD_Client_ID HIDDEN Adempiere 3.7
M_Replenish AD_Org_ID HIDDEN Adempiere 3.7
M_Replenish Created HIDDEN Adempiere 3.7
M_Replenish CreatedBy HIDDEN Adempiere 3.7
M_Replenish IsActive DEFAULT Adempiere 3.7
M_Replenish Level_Max DEFAULT Adempiere 3.7
M_Replenish Level_Min DEFAULT Adempiere 3.7
M_Replenish M_Locator_ID DEFAULT Adempiere 3.7
M_Replenish M_Product_ID DEFAULT Adempiere 3.7
M_Replenish M_Warehouse_ID DEFAULT Adempiere 3.7
M_Replenish M_WarehouseSource_ID HIDDEN Adempiere 3.7
M_Replenish ReplenishType DEFAULT Adempiere 3.7
M_Replenish UM_ReOrderLevel HIDDEN Adempiere 3.7
M_Replenish Updated HIDDEN Adempiere 3.7
M_Replenish UpdatedBy HIDDEN Adempiere 3.7
M_Product_BOM AD_Client_ID DEFAULT Adempiere 3.7
M_Product_BOM AD_Org_ID DEFAULT Adempiere 3.7
M_Product_BOM BOMQty DEFAULT Adempiere 3.7
M_Product_BOM BOMType HIDDEN Adempiere 3.7
M_Product_BOM Created HIDDEN Adempiere 3.7
M_Product_BOM CreatedBy HIDDEN Adempiere 3.7
M_Product_BOM Description DEFAULT Adempiere 3.7
M_Product_BOM IsActive DEFAULT Adempiere 3.7
M_Product_BOM Line DEFAULT Adempiere 3.7
M_Product_BOM M_Product_BOM_ID HIDDEN Adempiere 3.7
M_Product_BOM M_ProductBOM_ID DEFAULT Adempiere 3.7
M_Product_BOM M_Product_ID DEFAULT Adempiere 3.7
M_Product_BOM Updated HIDDEN Adempiere 3.7
M_Product_BOM UpdatedBy HIDDEN Adempiere 3.7
UM_Transaction AD_Client_ID DEFAULT Adempiere 3.7
UM_Transaction AD_Org_ID DEFAULT Adempiere 3.7
UM_Transaction C_ProjectIssue_ID DEFAULT Adempiere 3.7
UM_Transaction Created HIDDEN Adempiere 3.7
UM_Transaction CreatedBy HIDDEN Adempiere 3.7
UM_Transaction IsActive DEFAULT Adempiere 3.7
UM_Transaction M_AttributeSetInstance_ID ADDED Adempiere 3.7
UM_Transaction M_InOutLine_ID ADDED Adempiere 3.7
UM_Transaction M_InventoryLine_ID ADDED Adempiere 3.7
UM_Transaction M_Locator_ID ADDED Adempiere 3.7
UM_Transaction M_MovementLine_ID ADDED Adempiere 3.7
UM_Transaction MovementDate ADDED Adempiere 3.7
UM_Transaction MovementQty ADDED Adempiere 3.7
UM_Transaction MovementType ADDED Adempiere 3.7
UM_Transaction M_Product_ID ADDED Adempiere 3.7
UM_Transaction M_ProductionLine_ID ADDED Adempiere 3.7
UM_Transaction M_Transaction_ID HIDDEN Adempiere 3.7
UM_Transaction PP_Cost_Collector_ID ADDED Adempiere 3.7
UM_Transaction UM_BasicCost ADDED Adempiere 3.7
UM_Transaction UM_BefLandCost ADDED Adempiere 3.7
UM_Transaction UM_CashDisPer ADDED Adempiere 3.7
UM_Transaction UM_CashDisValue ADDED Adempiere 3.7
UM_Transaction UM_Discount ADDED Adempiere 3.7
UM_Transaction UM_DiscountAmt ADDED Adempiere 3.7
UM_Transaction UM_GrossCost1 ADDED Adempiere 3.7
UM_Transaction UM_GrossCost2 ADDED Adempiere 3.7
UM_Transaction UM_MRP ADDED Adempiere 3.7
UM_Transaction UM_NetCost ADDED Adempiere 3.7
UM_Transaction UM_PurchaseTaxCategory_ID ADDED Adempiere 3.7
UM_Transaction UM_PurchaseVATAmt ADDED Adempiere 3.7
UM_Transaction UM_SchemeDiscount ADDED Adempiere 3.7
UM_Transaction UM_SchemeDiscountAmt ADDED Adempiere 3.7
UM_Transaction UM_SellingPrice ADDED Adempiere 3.7
UM_Transaction Updated HIDDEN Adempiere 3.7
UM_Transaction UpdatedBy HIDDEN Adempiere 3.7
UM_BatchPrice AD_Client_ID HIDDEN Adempiere 3.7
UM_BatchPrice AD_Org_ID HIDDEN Adempiere 3.7
UM_BatchPrice Created HIDDEN Adempiere 3.7
UM_BatchPrice CreatedBy HIDDEN Adempiere 3.7
UM_BatchPrice IsActive DEFAULT Adempiere 3.7
UM_BatchPrice M_AttributeSetInstance_ID ADDED Adempiere 3.7
UM_BatchPrice M_Product_ID ADDED Adempiere 3.7
UM_BatchPrice UM_BasicCost ADDED Adempiere 3.7
UM_BatchPrice UM_BatchNo ADDED Adempiere 3.7
UM_BatchPrice UM_BatchPrice_ID HIDDEN Adempiere 3.7
UM_BatchPrice UM_BefLandCost ADDED Adempiere 3.7
UM_BatchPrice UM_CashDisPer ADDED Adempiere 3.7
UM_BatchPrice UM_CashDisValue ADDED Adempiere 3.7
UM_BatchPrice UM_CessAmt ADDED Adempiere 3.7
UM_BatchPrice UM_CessTaxCategory_ID ADDED Adempiere 3.7
UM_BatchPrice UM_CGST ADDED Adempiere 3.7
UM_BatchPrice UM_Discount ADDED Adempiere 3.7
UM_BatchPrice UM_DiscountAmt ADDED Adempiere 3.7
UM_BatchPrice UM_GrossCost1 ADDED Adempiere 3.7
UM_BatchPrice UM_GrossCost2 ADDED Adempiere 3.7
UM_BatchPrice UM_IGST ADDED Adempiere 3.7
UM_BatchPrice UM_MarkDown ADDED Adempiere 3.7
UM_BatchPrice UM_MarkUp ADDED Adempiere 3.7
UM_BatchPrice UM_MRP ADDED Adempiere 3.7
UM_BatchPrice UM_NetCost ADDED Adempiere 3.7
UM_BatchPrice UM_PurchaseTaxCategory_ID ADDED Adempiere 3.7
UM_BatchPrice UM_PurchaseVat HIDDEN Adempiere 3.7
UM_BatchPrice UM_PurchaseVATAmt ADDED Adempiere 3.7
UM_BatchPrice UM_SchemeDiscount ADDED Adempiere 3.7
UM_BatchPrice UM_SchemeDiscountAmt ADDED Adempiere 3.7
UM_BatchPrice UM_SellingMargin HIDDEN Adempiere 3.7
UM_BatchPrice UM_SellingMarginMRP ADDED Adempiere 3.7
UM_BatchPrice UM_SellingMarginNC ADDED Adempiere 3.7
UM_BatchPrice UM_SellingMarginType ADDED Adempiere 3.7
UM_BatchPrice UM_SellingPrice ADDED Adempiere 3.7
UM_BatchPrice UM_SGST ADDED Adempiere 3.7
UM_BatchPrice UM_WSP1 ADDED Adempiere 3.7
UM_BatchPrice UM_WSP1Margin ADDED Adempiere 3.7
UM_BatchPrice UM_WSP1MarginLC ADDED Adempiere 3.7
UM_BatchPrice UM_WSP2 ADDED Adempiere 3.7
UM_BatchPrice UM_WSP2Margin ADDED Adempiere 3.7
UM_BatchPrice UM_WSP2MarginLC ADDED Adempiere 3.7
UM_BatchPrice UM_WSP3 ADDED Adempiere 3.7
UM_BatchPrice UM_WSP3Margin ADDED Adempiere 3.7
UM_BatchPrice UM_WSP3MarginLC ADDED Adempiere 3.7
UM_BatchPrice Updated HIDDEN Adempiere 3.7
UM_BatchPrice UpdatedBy HIDDEN Adempiere 3.7
UM_Transaction AD_Client_ID HIDDEN Adempiere 3.7
UM_Transaction AD_Org_ID HIDDEN Adempiere 3.7
UM_Transaction C_ProjectIssue_ID HIDDEN Adempiere 3.7
UM_Transaction Created HIDDEN Adempiere 3.7
UM_Transaction CreatedBy HIDDEN Adempiere 3.7
UM_Transaction IsActive DEFAULT Adempiere 3.7
UM_Transaction M_AttributeSetInstance_ID ADDED Adempiere 3.7
UM_Transaction M_InOutLine_ID ADDED Adempiere 3.7
UM_Transaction M_InventoryLine_ID ADDED Adempiere 3.7
UM_Transaction M_Locator_ID ADDED Adempiere 3.7
UM_Transaction M_MovementLine_ID ADDED Adempiere 3.7
UM_Transaction MovementDate ADDED Adempiere 3.7
UM_Transaction MovementQty ADDED Adempiere 3.7
UM_Transaction MovementType ADDED Adempiere 3.7
UM_Transaction M_Product_ID ADDED Adempiere 3.7
UM_Transaction M_ProductionLine_ID ADDED Adempiere 3.7
UM_Transaction M_Transaction_ID HIDDEN Adempiere 3.7
UM_Transaction PP_Cost_Collector_ID HIDDEN Adempiere 3.7
UM_Transaction UM_BasicCost HIDDEN Adempiere 3.7
UM_Transaction UM_BefLandCost HIDDEN Adempiere 3.7
UM_Transaction UM_CashDisPer HIDDEN Adempiere 3.7
UM_Transaction UM_CashDisValue HIDDEN Adempiere 3.7
UM_Transaction UM_Discount HIDDEN Adempiere 3.7
UM_Transaction UM_DiscountAmt HIDDEN Adempiere 3.7
UM_Transaction UM_GrossCost1 HIDDEN Adempiere 3.7
UM_Transaction UM_GrossCost2 HIDDEN Adempiere 3.7
UM_Transaction UM_MRP HIDDEN Adempiere 3.7
UM_Transaction UM_NetCost HIDDEN Adempiere 3.7
UM_Transaction UM_PurchaseTaxCategory_ID HIDDEN Adempiere 3.7
UM_Transaction UM_PurchaseVATAmt HIDDEN Adempiere 3.7
UM_Transaction UM_SchemeDiscount HIDDEN Adempiere 3.7
UM_Transaction UM_SchemeDiscountAmt HIDDEN Adempiere 3.7
UM_Transaction UM_SellingPrice HIDDEN Adempiere 3.7
UM_Transaction Updated HIDDEN Adempiere 3.7
UM_Transaction UpdatedBy HIDDEN Adempiere 3.7
M_ProductPrice AD_Client_ID HIDDEN Adempiere 3.7
M_ProductPrice AD_Org_ID HIDDEN Adempiere 3.7
M_ProductPrice BaseBillingPrice HIDDEN Adempiere 3.7
M_ProductPrice Created HIDDEN Adempiere 3.7
M_ProductPrice CreatedBy HIDDEN Adempiere 3.7
M_ProductPrice IsActive HIDDEN Adempiere 3.7
M_ProductPrice M_AttributeSetInstance_ID ADDED Adempiere 3.7
M_ProductPrice M_PriceList_Version_ID DEFAULT Adempiere 3.7
M_ProductPrice M_Product_ID DEFAULT Adempiere 3.7
M_ProductPrice PriceLimit HIDDEN Adempiere 3.7
M_ProductPrice PriceList HIDDEN Adempiere 3.7
M_ProductPrice PriceStd DEFAULT Adempiere 3.7
M_ProductPrice Rate HIDDEN Adempiere 3.7
M_ProductPrice UM_BatchPrice_ID ADDED Adempiere 3.7
M_ProductPrice UM_LandingCost HIDDEN Adempiere 3.7
M_ProductPrice UM_ProductMargin HIDDEN Adempiere 3.7
M_ProductPrice UPC HIDDEN Adempiere 3.7
M_ProductPrice Updated HIDDEN Adempiere 3.7
M_ProductPrice UpdatedBy HIDDEN Adempiere 3.7
C_UOM_Conversion AD_Client_ID DEFAULT Adempiere 3.7
C_UOM_Conversion AD_Org_ID DEFAULT Adempiere 3.7
C_UOM_Conversion Created HIDDEN Adempiere 3.7
C_UOM_Conversion CreatedBy HIDDEN Adempiere 3.7
C_UOM_Conversion C_UOM_Conversion_ID HIDDEN Adempiere 3.7
C_UOM_Conversion C_UOM_ID DEFAULT Adempiere 3.7
C_UOM_Conversion C_UOM_To_ID DEFAULT Adempiere 3.7
C_UOM_Conversion DivideRate DEFAULT Adempiere 3.7
C_UOM_Conversion IsActive DEFAULT Adempiere 3.7
C_UOM_Conversion M_Product_ID DEFAULT Adempiere 3.7
C_UOM_Conversion MultiplyRate DEFAULT Adempiere 3.7
C_UOM_Conversion Updated HIDDEN Adempiere 3.7
C_UOM_Conversion UpdatedBy HIDDEN Adempiere 3.7

Product Department

The Product Department window is used for configuring the different departments of the products, its related category and sub-category

Table Name DB Field Name Super Store Work Edition
UM_Product_Department AD_Client_ID DEFAULT Adempiere 3.7
UM_Product_Department AD_Org_ID DEFAULT Adempiere 3.7
UM_Product_Department Created HIDDEN Adempiere 3.7
UM_Product_Department CreatedBy HIDDEN Adempiere 3.7
UM_Product_Department Description DEFAULT Adempiere 3.7
UM_Product_Department IsActive DEFAULT Adempiere 3.7
UM_Product_Department Name DEFAULT Adempiere 3.7
UM_Product_Department UM_DepartmentCode ADDED Adempiere 3.7
UM_Product_Department UM_Product_Department_ID HIDDEN Adempiere 3.7
UM_Product_Department Updated HIDDEN Adempiere 3.7
UM_Product_Department UpdatedBy HIDDEN Adempiere 3.7
UM_Product_Department Value DEFAULT Adempiere 3.7
M_Product_Category A_Asset_Group_ID HIDDEN Adempiere 3.7
M_Product_Category AD_Client_ID HIDDEN Adempiere 3.7
M_Product_Category AD_Org_ID HIDDEN Adempiere 3.7
M_Product_Category AD_PrintColor_ID HIDDEN Adempiere 3.7
M_Product_Category Created HIDDEN Adempiere 3.7
M_Product_Category CreatedBy HIDDEN Adempiere 3.7
M_Product_Category Description DEFAULT Adempiere 3.7
M_Product_Category IsActive DEFAULT Adempiere 3.7
M_Product_Category IsDefault HIDDEN Adempiere 3.7
M_Product_Category IsSelfService HIDDEN Adempiere 3.7
M_Product_Category MMPolicy HIDDEN Adempiere 3.7
M_Product_Category M_Product_Category_ID HIDDEN Adempiere 3.7
M_Product_Category M_Product_Category_Parent_ID HIDDEN Adempiere 3.7
M_Product_Category Name DEFAULT Adempiere 3.7
M_Product_Category PlannedMargin HIDDEN Adempiere 3.7
M_Product_Category UM_CategoryCode ADDED Adempiere 3.7
M_Product_Category UM_Product_Department_ID ADDED Adempiere 3.7
M_Product_Category Updated HIDDEN Adempiere 3.7
M_Product_Category UpdatedBy HIDDEN Adempiere 3.7
M_Product_Category Value DEFAULT Adempiere 3.7
UM_Product_Subcategory AD_Client_ID HIDDEN Adempiere 3.7
UM_Product_Subcategory AD_Org_ID HIDDEN Adempiere 3.7
UM_Product_Subcategory Created HIDDEN Adempiere 3.7
UM_Product_Subcategory CreatedBy HIDDEN Adempiere 3.7
UM_Product_Subcategory Description DEFAULT Adempiere 3.7
UM_Product_Subcategory IsActive DEFAULT Adempiere 3.7
UM_Product_Subcategory M_Product_Category_ID ADDED Adempiere 3.7
UM_Product_Subcategory Name ADDED Adempiere 3.7
UM_Product_Subcategory UM_Product_Department_ID ADDED Adempiere 3.7
UM_Product_Subcategory UM_Product_Subcategory_ID HIDDEN Adempiere 3.7
UM_Product_Subcategory Updated HIDDEN Adempiere 3.7
UM_Product_Subcategory UpdatedBy HIDDEN Adempiere 3.7
UM_Product_Subcategory Value DEFAULT Adempiere 3.7

Warehouse & Location

The Warehouse and Locators Window defines each Warehouse, any Locators for that Warehouse and the Accounting parameters to be used for inventory in that Warehouse.

Table Name DB Field Name Super Store Work Edition
M_Warehouse AD_Client_ID DEFAULT Adempiere 3.7
M_Warehouse AD_Org_ID DEFAULT Adempiere 3.7
M_Warehouse C_Location_ID DEFAULT Adempiere 3.7
M_Warehouse Created HIDDEN Adempiere 3.7
M_Warehouse CreatedBy HIDDEN Adempiere 3.7
M_Warehouse Description DEFAULT Adempiere 3.7
M_Warehouse IsActive DEFAULT Adempiere 3.7
M_Warehouse IsInTransit ADDED Adempiere 3.7
M_Warehouse M_Warehouse_ID HIDDEN Adempiere 3.7
M_Warehouse M_WarehouseSource_ID DEFAULT Adempiere 3.7
M_Warehouse Name DEFAULT Adempiere 3.7
M_Warehouse ReplenishmentClass DEFAULT Adempiere 3.7
M_Warehouse Separator DEFAULT Adempiere 3.7
M_Warehouse UM_WHType ADDED Adempiere 3.7
M_Warehouse Updated HIDDEN Adempiere 3.7
M_Warehouse UpdatedBy HIDDEN Adempiere 3.7
M_Warehouse Value DEFAULT Adempiere 3.7
M_Locator AD_Client_ID DEFAULT Adempiere 3.7
M_Locator AD_Org_ID DEFAULT Adempiere 3.7
M_Locator Created HIDDEN Adempiere 3.7
M_Locator CreatedBy HIDDEN Adempiere 3.7
M_Locator IsActive DEFAULT Adempiere 3.7
M_Locator IsDefault DEFAULT Adempiere 3.7
M_Locator M_Locator_ID HIDDEN Adempiere 3.7
M_Locator M_Warehouse_ID DEFAULT Adempiere 3.7
M_Locator PriorityNo DEFAULT Adempiere 3.7
M_Locator Updated HIDDEN Adempiere 3.7
M_Locator UpdatedBy HIDDEN Adempiere 3.7
M_Locator Value DEFAULT Adempiere 3.7
M_Locator X DEFAULT Adempiere 3.7
M_Locator Y DEFAULT Adempiere 3.7
M_Locator Z DEFAULT Adempiere 3.7
M_Storage AD_Client_ID DEFAULT Adempiere 3.7
M_Storage AD_Org_ID DEFAULT Adempiere 3.7
M_Storage Created HIDDEN Adempiere 3.7
M_Storage CreatedBy HIDDEN Adempiere 3.7
M_Storage DateLastInventory DEFAULT Adempiere 3.7
M_Storage IsActive DEFAULT Adempiere 3.7
M_Storage M_AttributeSetInstance_ID DEFAULT Adempiere 3.7
M_Storage M_Locator_ID DEFAULT Adempiere 3.7
M_Storage M_Product_ID DEFAULT Adempiere 3.7
M_Storage QtyOnHand DEFAULT Adempiere 3.7
M_Storage QtyOrdered DEFAULT Adempiere 3.7
M_Storage QtyReserved DEFAULT Adempiere 3.7
M_Storage Updated HIDDEN Adempiere 3.7
M_Storage UpdatedBy HIDDEN Adempiere 3.7
M_Warehouse_Acct AD_Client_ID DEFAULT Adempiere 3.7
M_Warehouse_Acct AD_Org_ID DEFAULT Adempiere 3.7
M_Warehouse_Acct C_AcctSchema_ID DEFAULT Adempiere 3.7
M_Warehouse_Acct Created HIDDEN Adempiere 3.7
M_Warehouse_Acct CreatedBy HIDDEN Adempiere 3.7
M_Warehouse_Acct IsActive DEFAULT Adempiere 3.7
M_Warehouse_Acct M_Warehouse_ID DEFAULT Adempiere 3.7
M_Warehouse_Acct Updated HIDDEN Adempiere 3.7
M_Warehouse_Acct UpdatedBy HIDDEN Adempiere 3.7
M_Warehouse_Acct W_Differences_Acct DEFAULT Adempiere 3.7
M_Warehouse_Acct W_InvActualAdjust_Acct DEFAULT Adempiere 3.7
M_Warehouse_Acct W_Inventory_Acct DEFAULT Adempiere 3.7
M_Warehouse_Acct W_Revaluation_Acct DEFAULT Adempiere 3.7