Inventory Management

Inventory Management

Compiere ERP POS 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.

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