User defined tables and procedures in SAP Business One for Build, Produce and Inspect

In the process of setting up the SAP Business One company database, the Cloud Apps Installer add-on creates the following user-defined tables:

• BOY_SBO_...: These tables are required for all Boyum add-ons, and they are not specific to Cloud Apps.
• BOY_CLOUD_CONFIG: The table is used to track the installation status and version.
• BOY_CLOUD_NOTI_TYPE: The table stores the transaction types that should be synchronized to Cloud Apps.
• BOY_CLOUD_NOTICE: The table stores the transactions, except inventory transactions, waiting for synchronization to Cloud Apps. Records are deleted automatically after synchronization.
• BOY_CLOUD_WAREHOUSE: The table stores the inventory transactions waiting for synchronization to Cloud Apps. Records are deleted automatically after synchronization.

As part of the installation process of Cloud Apps, four user defined tables are added to SAP Business One to store the inspection result data exported from Inspect / Manager. These tables, however, are not created by the Cloud Apps Installer add-on. For the details of these tables, see Representation of inspection order results in SAP Business One.

The Cloud Apps Installer add-on also creates the procedure BOY_SP_CLOUD_POSTTRANSACTIONNOTICE, which copies data to be synchronized into the BOY_CLOUD_NOTICE and BOY_CLOUD_WAREHOUSE tables.

In addition, it updates the SBO_SP_POSTTRANSACTIONNOTICE stored procedure, so it calls BOY_SP_CLOUD_POSTTRANSACTIONNOTICE.