Product and Product Master Tables in Ax2012.

 Here The following Tables are used while creating and relaesing of a product and product master  in ax 2012.


  1. Ecoresproduct -------> contains all products details
  2. EcoResDistinctProduct ----> abstract table which support inheretance for EcoresproductTable
  3. EcoResProductIdentifier ----> containes identification numbers for the products
  4. ecoResProductTranslation-----> global Languge details for product 
  5. EcoResProductMaster --->stores product masters details
  6. EcoResStorageDimensionGroup---> containes storgae dimensions LIke site,Sitewh
  7. EcoResProductDimensionGroupProduct ---> stores the association recids of produts and its storage dimensions.
  8. ecoResStorageDimensionGroupProduct ---> stores product storge dimension
  9. ecoResTrackingDimensionGroupProduct---> stroes tracking dimensions of products
  10. inventTable ---> stores all relaesed products as items.
  11. inventModelGroupItem ----> stores item model group in association with item id
  12. inventItemGroupItem ----> stores group of the item like audio,parts,electronics etc...
  13. inventTableModule----> which stores the items for different modules like purch,sales,inventory.
  14. InventItemLocation ---> information about the location setup for an item...like warehouse.
  15. InventItemSetupSupplyType --> information about supply type wheather it is purchased or production type and stores the company of the item.
  16. ecoResTrackingDimensionGroupItem ---> after relasing the products the tracking dimension of the item stored based on the inventtable.
  17. ecoResStorageDimensionGroupItem --->storge dimennsion details for item.

No comments:

Post a Comment