biuan SAP® BUSINESS ONE SDK
SQL Reports / Scheduled Report Actions
API OSRA
OSRA - Scheduled Report Actions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ActionCode KEY UNIQUEAction CodeInt
11
PRIMARYYes
TitleTitlenVarChar
100
NotesRemarksText
16
UserKeyUserInt
11OUSR
Users
PasswordPasswordnVarChar
127
RunDateNext Run DateDate
8
RunTimeNext Run TimeInt
11
RunCounterNext Run CounterInt
11
0
ReportTypeReport TypeInt
0
115) User Query
857) Sales/Purchase Analysis
6000) Inventory Valuation
11
0
ActiveSchedule Active StatusVarChar
N) No
Y) Yes
1
Y
StartDateRecurrence Start DateDate
8
EndTypeRecurrence End TypeVarChar
N) No End
C) By Counter
D) By Date
1
N
EndDateRecurrence End DateDate
8
EndCounterRecurrence End CounterInt
11
1
MissBehavBehavior of Missed RunVarChar
S) Skip
R) Run as Soon as Possible
1
S
RcrTypeRecurrence TypeVarChar
N) None
D) Daily
W) Weekly
M) Monthly
Y) Annually
1
N
RcrIntervlRecurrence IntervalInt
11
1
RcrSubTypeRecurrence SubtypeInt
11
RcrData2Recurrence: Additional Data 2Int
11
RcrData1Recurrence: Additional Data 1Int
11
ErrActAction on ErrorVarChar
D) Deactivate Immediately
C) Continue
1) Deactivate on Second Failure
2) Deactivate on Third Failure
3) Deactivate on Fourth Failure
1
1
TransfXsltXSLT TransformationText
16
TimeOutRpt Creation Time-Out in Min.Int
11
5
MsgTitleMessage TitlenVarChar
127
MsgBodyMessage BodynVarChar
127
LicSrvrLicense ServernVarChar
127
LanguageLanguageInt
11
3
LstRunStatLast Run StatusVarChar
0
S) Success
T) SAP Business One client stopped due to time-out
U) The next run date was not updated
D) Unable to distribute result
X) Unspecified failure
F) Successfully finished
1
0
ErrorCountNumber of Failed RunsInt
11
0
PrntLayoutPrint LayoutnVarChar
20RDOC
Document
DistLstCodDistribution List CodeInt
11OMLS
Distribution List
FinishedSchedule Finished StatusVarChar
1
N

Table relationship map

SELECT statement

SELECT OSRA.ActionCode AS 'Action Code', OSRA.Title AS 'Title', OSRA.Notes AS 'Remarks', OSRA.UserKey AS 'User', OSRA.Password AS 'Password', OSRA.RunDate AS 'Next Run Date', OSRA.RunTime AS 'Next Run Time', OSRA.RunCounter AS 'Next Run Counter', OSRA.ReportType AS 'Report Type', OSRA.Active AS 'Schedule Active Status', OSRA.StartDate AS 'Recurrence Start Date', OSRA.EndType AS 'Recurrence End Type', OSRA.EndDate AS 'Recurrence End Date', OSRA.EndCounter AS 'Recurrence End Counter', OSRA.MissBehav AS 'Behavior of Missed Run', OSRA.RcrType AS 'Recurrence Type', OSRA.RcrIntervl AS 'Recurrence Interval', OSRA.RcrSubType AS 'Recurrence Subtype', OSRA.RcrData2 AS 'Recurrence: Additional Data 2', OSRA.RcrData1 AS 'Recurrence: Additional Data 1', OSRA.ErrAct AS 'Action on Error', OSRA.TransfXslt AS 'XSLT Transformation', OSRA.TimeOut AS 'Rpt Creation Time-Out in Min.', OSRA.MsgTitle AS 'Message Title', OSRA.MsgBody AS 'Message Body', OSRA.LicSrvr AS 'License Server', OSRA.Language AS 'Language', OSRA.LstRunStat AS 'Last Run Status', OSRA.ErrorCount AS 'Number of Failed Runs', OSRA.PrntLayout AS 'Print Layout', OSRA.DistLstCod AS 'Distribution List Code', OSRA.Finished AS 'Schedule Finished Status' FROM OSRA AS OSRA

Related information


OSRA SQL Table

Distribution List OMLS SQL Table

Document RDOC SQL Table

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. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates