biuan SAP® BUSINESS ONE SDK
API SARI
SARI - add-ons table Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AddOnIdAddOn IDInt
11
-1
NameSpace KEY UNIQUEPartner Name SpacenVarChar
20
PRIMARYYes
PNamePartner NamenVarChar
40
ANameAddOn NamenVarChar
40
ENameAddOn Exe namenVarChar
127
CDataPartner Contact DatanVarChar
80
AddOnChkAddOn Exe Check SumnVarChar
32
InstNameAddOn Installer NamenVarChar
127
InstChkSumAddOn Installer Check SumnVarChar
32
ABinaryAddOn Installer BinaryText
16
InstTimeInstallation estimation timeInt
11
AddOnVerAddOn VersionnVarChar
13
ForceFlagAddOn Install force flagVarChar
Y) Yes
N) No
1
Y
UnInstNameAddOn Uninstaller NamenVarChar
127
UnInstChkAddOn UnInstaller Check SumnVarChar
32
UnInstParUnInstaller paramsnVarChar
127
InstIsUnIs Installer is UnInstallerVarChar
1
AGroupAddOn GroupVarChar
1
IParamsInstaller ParamsnVarChar
127
UnInstTimeUninstallation estimation timeInt
11
0
AutoAssignAutomatic Company AssignmentVarChar
1
N
VisibleAddOn is visible in AddOnAdminVarChar
Y) Yes, visible
N)
1
Y
SelfUpgrdDon`t install/uninstalVarChar
Y) Yes, don`t install/uninstall
N) No, perform install/uninstall
1
N
InstSilUse silent mode in installVarChar
Y) Silent mode supported
N) Silent mode not supported
1
N
UnInstSilUse silent mode in uninstallVarChar
Y) Silent mode supported
N) Silent mode not supported
1
N
UpgSilUse silent mode in upgradeVarChar
Y) Silent mode supported
N) Silent mode not supported
1
N
InstParFParameter files in installText
16
UnInstParFParameter files in uninstallText
16
UpgParFParameter files in upgradeText
16
InstPFChkChecksum of install param filenVarChar
32
UnInstPFChChecksum of uninstall par filenVarChar
32
UpgPFChkChecksum of upgrade param filenVarChar
32
UpgNameAddon upgrader namenVarChar
127
UpgTimeEstimated upgrade timeInt
11
0
UpgParamsUpgrader paramsnVarChar
127
AUpgraderAddon upgrader binaryText
16
UpgChkSumAddon upgrader checksumnVarChar
32
ABinary64AddOn Installer Binary (64bit)Text
16
IsAdd64Is Addon Installer 64bitVarChar
1
N
AddPlatPlatform of addon installerVarChar
N) x86
X) x64
1
N
ClientTypeClient type supported by the addonVarChar
W) Windows desktop
B) Browser access
A) All
1
W

SELECT statement

SELECT SARI.AddOnId AS 'AddOn ID', SARI.NameSpace AS 'Partner Name Space', SARI.PName AS 'Partner Name', SARI.AName AS 'AddOn Name', SARI.EName AS 'AddOn Exe name', SARI.CData AS 'Partner Contact Data', SARI.AddOnChk AS 'AddOn Exe Check Sum', SARI.InstName AS 'AddOn Installer Name', SARI.InstChkSum AS 'AddOn Installer Check Sum', SARI.ABinary AS 'AddOn Installer Binary', SARI.InstTime AS 'Installation estimation time', SARI.AddOnVer AS 'AddOn Version', SARI.ForceFlag AS 'AddOn Install force flag', SARI.UnInstName AS 'AddOn Uninstaller Name', SARI.UnInstChk AS 'AddOn UnInstaller Check Sum', SARI.UnInstPar AS 'UnInstaller params', SARI.InstIsUn AS 'Is Installer is UnInstaller', SARI.AGroup AS 'AddOn Group', SARI.IParams AS 'Installer Params', SARI.UnInstTime AS 'Uninstallation estimation time', SARI.AutoAssign AS 'Automatic Company Assignment', SARI.Visible AS 'AddOn is visible in AddOnAdmin', SARI.SelfUpgrd AS 'Don`t install/uninstal', SARI.InstSil AS 'Use silent mode in install', SARI.UnInstSil AS 'Use silent mode in uninstall', SARI.UpgSil AS 'Use silent mode in upgrade', SARI.InstParF AS 'Parameter files in install', SARI.UnInstParF AS 'Parameter files in uninstall', SARI.UpgParF AS 'Parameter files in upgrade', SARI.InstPFChk AS 'Checksum of install param file', SARI.UnInstPFCh AS 'Checksum of uninstall par file', SARI.UpgPFChk AS 'Checksum of upgrade param file', SARI.UpgName AS 'Addon upgrader name', SARI.UpgTime AS 'Estimated upgrade time', SARI.UpgParams AS 'Upgrader params', SARI.AUpgrader AS 'Addon upgrader binary', SARI.UpgChkSum AS 'Addon upgrader checksum', SARI.ABinary64 AS 'AddOn Installer Binary (64bit)', SARI.IsAdd64 AS 'Is Addon Installer 64bit', SARI.AddPlat AS 'Platform of addon installer', SARI.ClientType AS 'Client type supported by the addon' FROM SARI AS SARI

Related information




SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates