商务咨询
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实施服务。
