biuan SAP® BUSINESS ONE SDK
SQL Administration / B1i DI Configuration
DTW Administration / Setup / Financials / Fixed Assets / Asset Groups
API OBDC
OBDC - B1i DI Configuration Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUECodeInt
11
PRIMARYYes
ServerServernVarChar
127
LicenseLicense ServernVarChar
127
CompanyCompanynVarChar
127
DBTypeDB TypeInt
11
DBUserDB UsernVarChar
127
DBPasswordDB PasswordnVarChar
127
UsernameUser NamenVarChar
127
UPasswordUser PasswordnVarChar
127
DBTrustedDB TrustedVarChar
1
JCOPathJava Connector PathnVarChar
127
LanguageLanguageInt
11
AddOnIFAdd-On IdentifiernVarChar
127
StateFderBank Statement FoldernVarChar
127
FormatFderBank Format FoldernVarChar
127
FileFolderBank File FoldernVarChar
127

SELECT statement

SELECT OBDC.Code AS 'Code', OBDC.Server AS 'Server', OBDC.License AS 'License Server', OBDC.Company AS 'Company', OBDC.DBType AS 'DB Type', OBDC.DBUser AS 'DB User', OBDC.DBPassword AS 'DB Password', OBDC.Username AS 'User Name', OBDC.UPassword AS 'User Password', OBDC.DBTrusted AS 'DB Trusted', OBDC.JCOPath AS 'Java Connector Path', OBDC.Language AS 'Language', OBDC.AddOnIF AS 'Add-On Identifier', OBDC.StateFder AS 'Bank Statement Folder', OBDC.FormatFder AS 'Bank Format Folder', OBDC.FileFolder AS 'Bank File Folder' FROM OBDC AS OBDC

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