We load onto the DV, all fields in the following tables:

  • store_tb, sales_tax_tb, rental_default_tb, payment_type_tb, department_tb, category_tb, termyear_tb, college_tb, college_department_tb, college_course_tb, section_tb, item_tb, item_adoption_tb, inventory_tb.


Some basic data about orders is also sent to the website (only for orders originating on the website and not completed in Booklog), from tables:

  • mailord_header_tb, mailord_item_tb.


The customer_tb table is mirrored on the DV as well, but this is used only to get instructor names for college course sections.

Importing orders into Booklog is done via the afn_addweborder stored procedure provided by Booklog.