Hi everyone,
If I were to extract supplier master data for active suppliers including addresses etc. which tables should I export the data from?
We use Sage X3 v7.
Thanks,
Matt K
You should be able to get all this making a query using the BPSUPPLIER (BPS) table.
Please note the online help center provides information regarding the data model for suppliers as well:
http://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/MCD/Commondata.htm
The current data model is applicable to Version 6 but for supplier in V7 this will be very similar.
*Community Hub is the new name for Sage City