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.