| ... |
... |
@@ -42,72 +42,23 @@ |
| 42 |
42 |
* Depending on the state of the database, there might be tables, procedures, views and even data that need to be added. Is a list of some of some these objects, that need to be present in the database for the CRM to work correctly (//Please feel free to added on//): |
| 43 |
43 |
|
| 44 |
44 |
|=Object Type|=Name|=Dependencies |
| 45 |
|
-|Procedure|api.sp_AddSupplier_Se| |
| 46 |
|
-|Procedure|api.sp_BankAccountTypes_SelectV2| |
| 47 |
|
-|Procedure|api.sp_Communication_Add| |
| 48 |
|
-|Procedure|api.sp_Communication_AddProperty| |
| 49 |
|
-|Procedure|api.sp_Content_Add| |
| 50 |
|
-|Procedure|api.sp_Content_AddProperty| |
| 51 |
|
-|Procedure|api.sp_CreateSupplier| |
| 52 |
|
-|Procedure|api.sp_CRM_RegisterUser| |
| 53 |
|
-|Procedure|api.sp_CRM_ResetPassword| |
| 54 |
|
-|Procedure|api.sp_DocumentCategories_SelectV2| |
| 55 |
|
-|Procedure|api.sp_Documents_SelectV2| |
| 56 |
|
-|Procedure|api.sp_GetBBBEE_Levels| |
| 57 |
|
-|Procedure|api.sp_GetPersonDetailsV2| |
| 58 |
|
-|Procedure|api.sp_GetSupplierTypes| |
| 59 |
|
-|Procedure|api.sp_GetUniversalBankBranch| |
| 60 |
|
-|Procedure|api.sp_MemberBankDetails_SelectV2| |
| 61 |
|
-|Procedure|api.sp_MemberBeneficiaries_SelectV2| |
| 62 |
|
-|Procedure|api.sp_MemberClaimStatus_SelectV2| |
| 63 |
|
-|Procedure|api.sp_MemberCouncilRates_SelectV2| |
| 64 |
|
-|Procedure|api.sp_MemberNotes_InsertV2| |
| 65 |
|
-|Procedure|api.sp_MemberNotes_SelectV2| |
| 66 |
|
-|Procedure|api.sp_MemberNoteVariableGroups_SelectV2| |
| 67 |
|
-|Procedure|api.sp_MemberNoteVariables_SelectV2| |
| 68 |
|
-|Procedure|api.sp_MemberPayments_SelectV2| |
| 69 |
|
-|Procedure|api.sp_MemberPaypoints_SelectV2| |
| 70 |
|
-|Procedure|api.sp_MemberSalaries_SelectV2| |
| 71 |
|
-|Procedure|api.sp_MemberSinglePremiums_SelectV2| |
| 72 |
|
-|Procedure|api.sp_MemberTaxApplications_SelectV2| |
| 73 |
|
-|Procedure|api.sp_People_SelectV2| |
| 74 |
|
-|Procedure|api.sp_Scheduler_AddNote| |
| 75 |
|
-|Procedure|api.sp_Scheduler_AddProperty| |
| 76 |
|
-|Procedure|api.sp_Scheduler_CompleteActivity| |
| 77 |
|
-|Procedure|api.sp_Scheduler_CreateProcess| |
| 78 |
|
-|Procedure|api.sp_Scheduler_CurrentActivities| |
| 79 |
|
-|Procedure|api.sp_Scheduler_GetActivityActions| |
| 80 |
|
-|Procedure|api.sp_Scheduler_GetNotes| |
| 81 |
|
-|Procedure|api.sp_Scheduler_GetProcessProperties| |
| 82 |
|
-|Procedure|api.sp_SearchPersonDetails| |
| 83 |
|
-|Procedure|api.sp_SearchPersonMembershipV2| |
| 84 |
|
-|Procedure|api.sp_Workflow_AddNote| |
| 85 |
|
-|Procedure|api.sp_Workflow_AddProperty| |
| 86 |
|
-|Procedure|api.sp_Workflow_CompleteActivity| |
| 87 |
|
-|Procedure|api.sp_Workflow_CreateProcess| |
| 88 |
|
-|Procedure|api.sp_Workflow_GetActivityActions| |
| 89 |
|
-|Procedure|api.sp_Workflow_GetLinkedContent| |
| 90 |
|
-|Procedure|api.sp_Workflow_GetNotes| |
| 91 |
|
-|Procedure|api.sp_Workflow_GetProcessProperties| |
| 92 |
|
-|Procedure|api.sp_Workflow_LinkContent| |
| 93 |
|
-|Procedure|api.sp_Workflow_Reallocate| |
| 94 |
|
-|Procedure|api.sp_Workflow_SearchActivities| |
| 95 |
|
-|Procedure|api.sp_Workflow_SearchProcess| |
| 96 |
|
-|Procedure|api.sp_Workflow_SearchStreamResources| |
| 97 |
|
-|Procedure|api.sp_Workflow_SearchStreams| |
| 98 |
|
-|Procedure|api.sp_Workflow_UpdateProperty| |
| 99 |
|
-|Procedure|dbo.sp_InsertImageToDocDatabase| |
| 100 |
|
-|Procedure|dbo.sp_MaritalStatus| |
| 101 |
|
-|Procedure|dbo.sp_SchedulerAddNote| |
| 102 |
|
-|Procedure|dbo.sp_Update_frmPeople| |
| 103 |
|
-|Procedure|dbo.sp_UserLevels| |
| 104 |
|
-|Procedure|dbo.sp_WorkflowAddNote| |
| 105 |
|
-|Procedure|prg.sp_ProviderParameters_select| |
| 106 |
|
-|Procedure|scr.sp_BankBranches_Member| |
| 107 |
|
-|Procedure|scr.sp_MFGMemberCFLO| |
| 108 |
|
-|Procedure|scr.sp_MFGMemberPaypoints| |
| 109 |
|
-|Procedure|scr.sp_Paypoints| |
| 110 |
|
-|Procedure|web.sp_UserWebLogin| |
|
45 |
+| |api.sp_AddSupplier_Se| |
|
46 |
+| |api.sp_BankAccountTypes_SelectV2| |
|
47 |
+| |api.sp_Communication_Add| |
|
48 |
+| |api.sp_Communication_AddProperty| |
|
49 |
+| |api.sp_Content_Add| |
|
50 |
+| |api.sp_Content_AddProperty| |
|
51 |
+| |api.sp_CreateSupplier| |
|
52 |
+| |api.sp_CRM_RegisterUser| |
|
53 |
+| |api.sp_CRM_ResetPassword| |
|
54 |
+| |api.sp_DocumentCategories_SelectV2| |
|
55 |
+| |api.sp_Documents_SelectV2| |
|
56 |
+| |api.sp_GetBBBEE_Levels| |
|
57 |
+| |api.sp_GetPersonDetailsV2| |
|
58 |
+| |api.sp_GetSupplierTypes| |
|
59 |
+| |api.sp_GetUniversalBankBranch| |
|
60 |
+| |api.sp_MemberBankDetails_SelectV2| |
|
61 |
+| |api.sp_MemberBeneficiaries_SelectV2| |
| 111 |
111 |
|
| 112 |
112 |
|
| 113 |
113 |
|