biuan SAP® BUSINESS ONE SDK
DTW Banking / Bank Statements and External Reconciliations
API ODOX
ODOX - Data Ownership - Exceptions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
QueryId KEY UNIQUEQuery IDnVarChar
20
PRIMARYYes
ObjectThe Object NumbernVarChar
20
SubObjectArray OffsetInt
6
0
UserSignUser SignatureInt
6OUSR
Users
UpdateUserUpdating UserInt
6OUSR
Users
CreateDateCreation DateDate
8
UpdateDateDate of UpdateDate
8
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Upgrade
M) Import
O) DI API
A) Auto Summary
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
ACCache Access CounterInt
11
0

SELECT statement

SELECT ODOX.QueryId AS 'Query ID', ODOX.Object AS 'The Object Number', ODOX.SubObject AS 'Array Offset', ODOX.UserSign AS 'User Signature', ODOX.UpdateUser AS 'Updating User', ODOX.CreateDate AS 'Creation Date', ODOX.UpdateDate AS 'Date of Update', ODOX.DataSource AS 'Data Source', ODOX.AC AS 'Cache Access Counter' FROM ODOX AS ODOX

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