Navigation:  Inventory > Technical References >   Inventory tables

Product

Each Product and Service has a record in this table.

 

ProductGroup

Each Product Group has a record in this table. A Product belongs to a Product Group.

 

ProductUnit

Each Unit of Measure has a record in this table.

 

ProductUnitConversion

Each Unit of Measure combination within the same Class has a record in this table that specifies the conversion Factor.

 

Warehouse

Each Warehouse has a record in this table.

 

ProductGroupWarehouse

Each Product Group by Warehouse combination has a record in this table. It maintains Warehouse-specific information for each Product Group.

 

ProductWarehouse

Each Product by Warehouse combination has a record in this table. It maintains Warehouse-specific information for each Product.

 

IcTrans

Master records for Inventory transactions. Each transaction has one record in this table.

 

IcTransDetail

Detail records for Inventory transactions. Each transaction has one or more records here.

 

IcEntry, IcEntryDetail

Transaction entry tables.

 

IcImport, IcImportDetail

Transaction import tables.