Page History

...

Port: The port used to connect to database server

Script

Following is the database script that should be run in MySQL as a part of setting up staging database Once connected to MySQL, use the following database script in Query tab and execute .

/*
SQLyog Ultimate v8.71
MySQL - 5.6.27-log : Database - skuvault_quickbooks
*********************************************************************
*/

...

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Tables

Once the above script is executed, a database named skuvault_quickbooks is created with sku_to_qb_relation Table with the following columns

1. sno: Serial Number of a record
2. type: Signifies whether the transcation is Sales Order or a Purchase Order
3. vendor_customer: stores name of the Customers and Vendors
4. sku_id: stores Sales Order number or Purchase Order number for the corresponding transaction
5. qb_id: stores unique id generated by QuickBooks