send items with quantities to another database

Hello @abdallaahmed61 

In order to achieve an integration between two databases to automatically transmit item and quantity information, you would typically be interfacing with tables that contain item master data and inventory quantity data.

In most systems, this data is commonly stored in the following types of tables:

1. Item Master Table: This table contains the master data for all items/products in the system. The table name can vary widely depending on the system, but common names could be "Items", "Products", "InventoryItems", "MaterialMaster" and so forth.

2. Inventory/Stock Level Table: This table usually holds the quantity of each item available in the inventory. Again, the exact table name can differ based on the system, but could be something like "Inventory", "Stock", "InventoryLevels", "MaterialStock", etc.

For an ERP system like SAP, these tables would be MARA (Material Master) and MARD (Material Stock).

In Acumatica ERP, the corresponding tables would be InventoryItem (for item master data) and INItemSite (for stock quantities at each site).

However, I must caution you that directly interfacing with the database tables can be risky, as it bypasses any business rules enforced by the application layer of the ERP system. Also, if the database schema changes with a system upgrade, your integration could break.

A safer and more robust approach would be to use APIs provided by the system, such as web services (like SOAP or REST), or even file-based interfaces if the system provides them. For Acumatica, there are robust REST and SOAP web services that you could use for this purpose, which will ensure that all business rules are adhered to when updating the data.

In addition to the above, an integration like this could have other complexities. For example, if there are differences in the item coding/naming schemes between the two systems, or if the UOM (Units of Measure) are not the same, you may need to develop a mechanism to map these values between the two systems.