PO database configuration

A Batch Class can have more than one data table and each data table can have a corresponding separate Properties file. The administrator can make changes in each Properties file for different configurations as needed.

There is a default PO data table po_configuration already configured in the Transact database with the following columns.

  • po_line

  • po_number

  • part_number

  • vendor_id

  • vendor_name

  • quantity

  • available_quantity

  • unit_price

  • item_description

The administrator can also configure an external PO data source as follows:

  • On the Tomcat server, add a resource tag in server.xml file for the external data source and the corresponding resource link in the context.xml file.

  • Update the Data Source and PO_Table name in the property file.