How to buildvolume test orders and items
code to generate test order headers and order items:
1. order_build.sql
- generated SQL file that has 300 orders (1001-1300) with 10 identical line items each
- it deletes all records in ORDHEAD and ORDITEM first
2. order_template.sql - template SQL file used to build above file (replacing order number only)
3. gen_orders.php
- script that builds order_build.sql from order_template.sql
- you can modify template/build pathnames and number of orders in variable definitions
- for your possible future use (run from cmd line or ".bat" file)
4. jsi_functions.php - include file used by gen_orders.php
1. order_build.sql
- generated SQL file that has 300 orders (1001-1300) with 10 identical line items each
- it deletes all records in ORDHEAD and ORDITEM first
2. order_template.sql - template SQL file used to build above file (replacing order number only)
3. gen_orders.php
- script that builds order_build.sql from order_template.sql
- you can modify template/build pathnames and number of orders in variable definitions
- for your possible future use (run from cmd line or ".bat" file)
4. jsi_functions.php - include file used by gen_orders.php