商務咨詢
SAP Business One數據庫存儲過程
下面列出所有在SAP Business One 應用程序中使用的存儲過程.第一個表是用于SBO-COMMON 數據庫,第二個表用于公司數據庫.
注意
你不能重命名或刪除列表中的任何項目;否則,運行SAP Business One 時可能會發生錯誤.
SBO-COMMON 數據庫過程
|
SBO- COMMON 過程 |
|
ClearEnumValues |
|
DeleteAllEnumsAndClasses |
|
DeleteAllObjects |
|
DeleteAllPropertyDefs |
|
DeleteClassDef |
|
DeleteDependentProperties |
|
DeleteEnumType |
|
DeleteMetaObject |
|
DeleteMetaProperty |
|
DeleteMetaRelation |
|
DeletePropertyDef |
|
InsertClassDef |
|
InsertClassDefId |
|
InsertEnumType |
|
InsertEnumTypeId |
|
InsertEnumValue |
|
InsertMetaObject |
|
InsertMetaProperty |
|
InsertMetaRelation |
|
InsertPropertyDef |
|
InsertPropertyDefId |
|
NumberPropertyDefs |
|
NumberRelations |
|
OBSSp_GetNextExecFromSchedule |
|
OBSSp_GetServiceRecord |
|
OBSSp_UpdateScheduleRecord |
|
OBSSp_UpdateServiceExec |
|
RGSp_UpdateInstance |
|
RGSp_UpdateLicense |
|
TmSp_AliasUpdate |
|
TmSP_CheckDiskSpace |
|
TmSp_CopyCompany |
|
TmSp_GetCompList |
|
TmSP_GetDbSizeByDrives |
|
TmSp_GetServerTime |
|
TmSp_GetUsers |
|
TmSp_Installer_CreateTmSp |
|
TmSp_Installer_SetFieldValue |
|
TmSp_RefreshCompList |
|
TmSp_RestoreCompany |
|
UpdateClassDef |
|
UpdateEnumType |
|
UpdateMetaObject |
|
UpdateMetaProperty |
|
UpdateMetaRelationSeqNo |
|
UpdatePropertyDef |
|
UpdatePropertyDefSeqNo |
|
ClearEnumValues |
|
DeleteAllEnumsAndClasses |
|
DeleteAllObjects |
|
DeleteAllPropertyDefs |
|
DeleteClassDef |
|
DeleteDependentProperties |
|
DeleteEnumType |
|
DeleteMetaObject |
|
DeleteMetaProperty |
|
DeleteMetaRelation |
|
DeletePropertyDef |
|
InsertClassDef |
公司數據庫過程
|
公司數據庫過程 |
|
_TmSp_AliasUpdate_OUSR |
|
_TmSp_AliasUpdateAfter |
|
_TmSp_AliasUpdateBefore |
|
_TmSp_ControlAccountUpgrade_OCRD |
|
_TmSp_ConvertGrpLine_OACT |
|
_TmSp_ExpnsUpdateOnDocs |
|
_TmSp_FormattedSearchUpdate |
|
_TmSp_MthDate_Update_JDT1 |
|
_TmSp_RestoreIsCommited_OIBT |
|
_TmSp_SetCategoryAtOFPR |
|
_TmSp_SetLineNumAtADO3 |
|
_TmSp_SetLineNumAtDOC3 |
|
_TmSp_SetLineNumAtDOC5 |
|
_TmSp_SetLineSeqAtDOC4 |
|
_TmSp_SetLineSeqAtPMN5 |
|
_TmSp_SetUniqueDocEntryAtOCRD |
|
_TmSp_ShekelUpdate |
|
_TmSp_UpdateCreateDateOnOINM |
|
_TmSp_UpdateDoubleName |
|
_TmSp_VariableUpdate_OUQR |
|
_TmSp_VatSumCalc |
|
SBO_SP_PostTransactionNotice |
|
SBO_SP_PostTransactionSupport |
|
SBO_SP_TransactionNotification |
|
SBO_SP_TransactionSupport |
|
TmSp_adding_To_OITW |
|
TmSp_AddSqlUser |
|
TmSp_ChooseCIN4Correction |
|
TmSp_ChooseINV4Correction |
|
TmSp_ConGrpLine_OACT_recurs |
|
TmSp_ConvertGrpLine_OACT |
|
TmSp_CorrActReport |
|
TmSp_CorrActReport_BP |
|
TmSp_CorrActReport_BP_Split |
|
TmSp_CorrActReport_Split |
|
TmSp_DragOn |
|
TmSp_DragOnPk |
|
TmSp_FifoGetINM_Records |
|
TmSp_GetDocVatTotals |
|
TmSp_GetMaxRange |
|
TmSp_GetOpenRCTs |
|
TmSp_GetOpenRINs |
|
TmSp_GetUsers |
|
TmSp_GetWDD |
|
TmSp_Installer_SetFieldValue |
|
TmSp_OpportAnalysis |
|
TmSp_OpportAnalysis_CRD |
|
TmSp_OpportAnalysis_ITM |
|
TmSp_OpportAnalysis_SLP |
|
TmSp_OutboxSync |
|
TmSp_PicknPackCreateTempTable |
|
TmSp_Purch_An_Crd_Det_Y |
|
TmSp_Purch_An_Crd_Grp_M |
|
TmSp_Purch_An_Crd_Grp_Y |
|
TmSp_Purch_An_Crd_Sng_M |
|
TmSp_Purch_An_Crd_Sng_Y |
|
TmSp_Purch_An_Itm_Det_Y |
|
TmSp_Purch_An_Itm_Grp_M |
|
TmSp_Purch_An_Itm_Grp_Y |
|
TmSp_Purch_An_Itm_Sng_M |
|
TmSp_Purch_An_Itm_Sng_Y |
|
TmSp_Purch_An_Slp_Sng_M |
|
TmSp_Purch_An_Slp_Sng_Y |
|
TmSp_RebuildAcctMatch |
|
TmSp_RebuildMatchHistory |
|
TmSp_Replace_Table |
|
TmSp_Sales_An_Crd_Det_Y |
|
TmSp_Sales_An_Crd_Grp_M |
|
TmSp_Sales_An_Crd_Grp_Y |
|
TmSp_Sales_An_Crd_Sng_M |
|
TmSp_Sales_An_Crd_Sng_Y |
|
TmSp_Sales_An_Itm_Det_Y |
|
TmSp_Sales_An_Itm_Grp_M |
|
TmSp_Sales_An_Itm_Grp_Y |
|
TmSp_Sales_An_Itm_Sng_M |
|
TmSp_Sales_An_Itm_Sng_Y |
|
TmSp_Sales_An_Slp_Sng_M |
|
TmSp_Sales_An_Slp_Sng_Y |
|
TmSp_SetBalanceByJdt |
|
TmSp_SetBgtAccumulators_ByJdt |
|
TmSp_SetGlStamp |
|
TmSp_SetVendorDeductPercent |
|
_TmSp_AliasUpdate_OUSR |
|
_TmSp_AliasUpdateAfter |
|
_TmSp_AliasUpdateBefore |
|
_TmSp_ControlAccountUpgrade_OCRD |
|
_TmSp_ConvertGrpLine_OACT |
|
_TmSp_ExpnsUpdateOnDocs |
|
_TmSp_FormattedSearchUpdate |
|
_TmSp_MthDate_Update_JDT1 |
|
_TmSp_RestoreIsCommited_OIBT |
|
_TmSp_SetCategoryAtOFPR |
|
_TmSp_SetLineNumAtADO3 |
|
_TmSp_SetLineNumAtDOC3 |
|
_TmSp_SetLineNumAtDOC5 |
|
_TmSp_SetLineSeqAtDOC4 |
|
_TmSp_SetLineSeqAtPMN5 |
|
_TmSp_SetUniqueDocEntryAtOCRD |
|
_TmSp_ShekelUpdate |
|
_TmSp_UpdateCreateDateOnOINM |
|
_TmSp_UpdateDoubleName |
|
_TmSp_VariableUpdate_OUQR |
|
_TmSp_VatSumCalc |
|
SBO_SP_PostTransactionNotice |
|
SBO_SP_PostTransactionSupport |
|
SBO_SP_TransactionNotification |
|
SBO_SP_TransactionSupport |
|
TmSp_adding_To_OITW |
|
TmSp_AddSqlUser |
|
TmSp_ChooseCIN4Correction |
|
TmSp_ChooseINV4Correction |
|
TmSp_ConGrpLine_OACT_recurs |
|
TmSp_ConvertGrpLine_OACT |
|
TmSp_CorrActReport |
|
TmSp_CorrActReport_BP |
|
TmSp_CorrActReport_BP_Split |
|
TmSp_CorrActReport_Split |
|
TmSp_DragOn |
|
TmSp_DragOnPk |
|
TmSp_FifoGetINM_Records |
|
TmSp_GetDocVatTotals |
|
TmSp_GetMaxRange |
|
TmSp_GetOpenRCTs |
|
TmSp_GetOpenRINs |
|
TmSp_GetUsers |
|
TmSp_GetWDD |
|
TmSp_Installer_SetFieldValue |
|
TmSp_OpportAnalysis |
|
TmSp_OpportAnalysis_CRD |
|
TmSp_OpportAnalysis_ITM |
|
TmSp_OpportAnalysis_SLP |
|
TmSp_OutboxSync |
|
TmSp_PicknPackCreateTempTable |
|
TmSp_Purch_An_Crd_Det_Y |
|
TmSp_Purch_An_Crd_Grp_M |
|
TmSp_Purch_An_Crd_Grp_Y |
|
TmSp_Purch_An_Crd_Sng_M |
|
TmSp_Purch_An_Crd_Sng_Y |
|
TmSp_Purch_An_Itm_Det_Y |
|
TmSp_Purch_An_Itm_Grp_M |
|
TmSp_Purch_An_Itm_Grp_Y |
|
TmSp_Purch_An_Itm_Sng_M |
|
TmSp_Purch_An_Itm_Sng_Y |
|
TmSp_Purch_An_Slp_Sng_M |
|
TmSp_Purch_An_Slp_Sng_Y |
|
TmSp_RebuildAcctMatch |
|
TmSp_RebuildMatchHistory |
|
TmSp_Replace_Table |
|
TmSp_Sales_An_Crd_Det_Y |
|
TmSp_Sales_An_Crd_Grp_M |
|
TmSp_Sales_An_Crd_Grp_Y |
|
TmSp_Sales_An_Crd_Sng_M |
|
TmSp_Sales_An_Crd_Sng_Y |
|
TmSp_Sales_An_Itm_Det_Y |
|
TmSp_Sales_An_Itm_Grp_M |
|
TmSp_Sales_An_Itm_Grp_Y |
|
TmSp_Sales_An_Itm_Sng_M |
|
TmSp_Sales_An_Itm_Sng_Y |
|
TmSp_Sales_An_Slp_Sng_M |
|
TmSp_Sales_An_Slp_Sng_Y |
|
TmSp_SetBalanceByJdt |
|
TmSp_SetBgtAccumulators_ByJdt |
|
TmSp_SetGlStamp |
|
TmSp_SetVendorDeductPercent |
|
TmSp_UpdatingOIT |
TransInfo斯凱普斯是SAP制造業解決方案核心合作伙伴，SAP金牌實施商，專注上海/無錫/蘇州/廣州/深圳/東莞/成都等地SAP ERP軟件SAP制造業ERP軟件、 電子制造ERP、醫藥行業ERP、精細化工ERP、機械制造設備行業ERP實施服務。
