Stored Procedures - Subcontractor Online Payments

Top Previous Next

The Company Stored Procedure Library has been updated with two new stored procedures which will be used during the implementation process of the SOP Module. These procedures are documented below:

•sop_BuildBaseSecurity - This procedure will create the initial security records for the following company tables:

•SOP_MEMBER_TYPE

•SOP_PERMISSION_TYPE

•SOP_PERMISSIONS

•SOP_SETTINGS

•SOP_MEMBER_TYPE

•SOP_USERS

•SOP_GROUPS

•SOP_GROUPUSERS_PERMISSIONS

•SOP_GROUP_MEMBERS

Technical Note: This procedure will only be used by an AccuBuild Technician during the implementation process for the SOP Module: BASECOMP.sop_BuildBaseSecurity (Class 7773000 - Seq No 155).

•sop_UpdateCompanyForVer10_2 - This procedure will update the company database with the new tables and structure changes required by the SOP Module for AccuBuild Version 10.2. Several new SOP tables will be added to the company database as detailed below:

•SOP_CHART_USER

•SOP_CHARTS

•SOP_COMMENTS

•SOP_QUERIES

•SOP_SERIES_CHART

In addition to the above new tables, two existing SOP tables will be updated:

•SOP_PERMISSION_TYPE - PRIMARY Index will be updated

•SOP_USERS - New Field ProfilePictureURL will be added

Technical Note: This procedure will only be used by an AccuBuild Technician during the implementation process for the SOP Module: BASECOMP.sop_UpdateCompanyForVer10_2 (Class 7773000 - Seq No 160).