biuan SAP® BUSINESS ONE SDK
API ODAB
ODAB - Dashboard Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
PackEntry KEY UNIQUEPackage EntryInt
11OWPK
Dashboard Packages
CODEYes
DashbdCodeDashboard CodenVarChar
32
DashbdNameDashboard NamenVarChar
100
DashbdPathDashboard PathnVarChar
127
NoteDashboard DescriptionText
16
StatusDashboard StatusVarChar
I) Inactive
A) Active
1
A
JobFlagUse Schedule Job FlagVarChar
Y) Yes
N) No
1
N
JobTypeSchedule Job TypeVarChar
R) Real Time
P) Periodic
1
R
JobSettingSchedule Job Time SettingnVarChar
100
RenewDateLatest Renew DateDate
8
RenewTimeLatest Renew TimeInt
6
ProcNameProcedure NamenVarChar
100
JobNameSchedule Job NamenVarChar
100

Table relationship map

SELECT statement

SELECT ODAB.AbsEntry AS 'Internal Key', ODAB.PackEntry AS 'Package Entry', ODAB.DashbdCode AS 'Dashboard Code', ODAB.DashbdName AS 'Dashboard Name', ODAB.DashbdPath AS 'Dashboard Path', ODAB.Note AS 'Dashboard Description', ODAB.Status AS 'Dashboard Status', ODAB.JobFlag AS 'Use Schedule Job Flag', ODAB.JobType AS 'Schedule Job Type', ODAB.JobSetting AS 'Schedule Job Time Setting', ODAB.RenewDate AS 'Latest Renew Date', ODAB.RenewTime AS 'Latest Renew Time', ODAB.ProcName AS 'Procedure Name', ODAB.JobName AS 'Schedule Job Name' FROM ODAB AS ODAB

Related information


ODAB SQL Table

Dashboard Packages OWPK 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