biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Legal Data
API OLGL
OLGL - Legal Data Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
SrcObjType KEY UNIQUESource Object TypenVarChar
-1)
13) A/R Invoice
14) A/R Credit Memo
20
-1SRC_DOCYes
SrcObjAbsSource Object Internal IDInt
11
-1
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History		540000073
UserSignUser SignatureInt
6OUSR
Users
PrintDateDate of PrintingDate
8
PrintTimeTime of PrintingInt
6
PrBrandPrinter BrandnVarChar
30
PrTypePrinter TypenVarChar
30
PrModelPrinter ModelnVarChar
30
PrFwVerPrinter Firmware VersionnVarChar
30
PrDllVerPrinter DLL VersionnVarChar
30
FisSeriesFiscal SeriesnVarChar
30
FisNumberFiscal NumbernVarChar
30
DocNumberDocument NumbernVarChar
30
FisUserFiscal User IDInt
6OUSR
Users

Table relationship map

SELECT statement

SELECT OLGL.AbsEntry AS 'Internal Number', OLGL.SrcObjType AS 'Source Object Type', OLGL.SrcObjAbs AS 'Source Object Internal ID', OLGL.ObjType AS 'Object Type', OLGL.UserSign AS 'User Signature', OLGL.PrintDate AS 'Date of Printing', OLGL.PrintTime AS 'Time of Printing', OLGL.PrBrand AS 'Printer Brand', OLGL.PrType AS 'Printer Type', OLGL.PrModel AS 'Printer Model', OLGL.PrFwVer AS 'Printer Firmware Version', OLGL.PrDllVer AS 'Printer DLL Version', OLGL.FisSeries AS 'Fiscal Series', OLGL.FisNumber AS 'Fiscal Number', OLGL.DocNumber AS 'Document Number', OLGL.FisUser AS 'Fiscal User ID' FROM OLGL AS OLGL

Related information


OLGL SQL Table

Users OUSR SQL Table

Object Settings - History ADP1 SQL Table
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