biuan SAP® BUSINESS ONE SDK
SQL Administration / EULA
DTW Financials / Budget Setup / Budget Scenarios
API OULA
OULA - EULA Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SerialNum KEY UNIQUESerial NumberInt
11
PRIMARYYes
SignedSignedVarChar
Y) Yes
N) No
1
N
CheckedCheckedVarChar
Y) Yes
N) No
1
N
EULATypeEULA TypeVarChar
E) Evaluation
P) Productive
1
P
LicensorLicensornVarChar
100
LicenseeLicenseenVarChar
100
InstallNoInstallation NumbernVarChar
30
SignerSignernVarChar
127
UFunctionSigner FunctionnVarChar
100
UsernameB1 User NamenVarChar
127
SignDateSigning DateDate
8
DocVerEULA Document VersionnVarChar
50
EULADocEULA DocumentText
16
EULAFormatEULA FormatnVarChar
PDF) PDF
TXT) TXT
50
TXT
ChecksumEULA Record ChecksumnVarChar
127

SELECT statement

SELECT OULA.SerialNum AS 'Serial Number', OULA.Signed AS 'Signed', OULA.Checked AS 'Checked', OULA.EULAType AS 'EULA Type', OULA.Licensor AS 'Licensor', OULA.Licensee AS 'Licensee', OULA.InstallNo AS 'Installation Number', OULA.Signer AS 'Signer', OULA.UFunction AS 'Signer Function', OULA.Username AS 'B1 User Name', OULA.SignDate AS 'Signing Date', OULA.DocVer AS 'EULA Document Version', OULA.EULADoc AS 'EULA Document', OULA.EULAFormat AS 'EULA Format', OULA.Checksum AS 'EULA Record Checksum' FROM OULA AS OULA

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