biuan SAP® BUSINESS ONE SDK
API OTHL
OTHL - Thresholds Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
RecTypeReport TypeVarChar
A) Annual Invoice Declaration
B) Blacklist Country
1
A
EffecFromEffective FromDate
8
CompanyCompanynVarChar
20
PrivInvPrivate - InvoicenVarChar
20
PrivJEPrivate - Journal EntrynVarChar
20
LogInstancLog InstanceInt
11
UserSignUser SignatureInt
6OUSR
Users
CreateDateCreation DateDate
8
UserSign2Updating UserInt
6OUSR
Users
UpdateDateDate of UpdateDate
8
TourismTourismnVarChar
20

SELECT statement

SELECT OTHL.AbsEntry AS 'Internal Number', OTHL.RecType AS 'Report Type', OTHL.EffecFrom AS 'Effective From', OTHL.Company AS 'Company', OTHL.PrivInv AS 'Private - Invoice', OTHL.PrivJE AS 'Private - Journal Entry', OTHL.LogInstanc AS 'Log Instance', OTHL.UserSign AS 'User Signature', OTHL.CreateDate AS 'Creation Date', OTHL.UserSign2 AS 'Updating User', OTHL.UpdateDate AS 'Date of Update', OTHL.Tourism AS 'Tourism' FROM OTHL AS OTHL

Related information


Users OUSR SQL Table



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