📚 SAP Business One SDK Help

Table Name: OSRA

Table Description: Scheduled Report Actions

Field Description Type Size Related Default Value Constraints
ActionCode Action Code Int 11 -      
Title Title nVarChar 100 -      
Notes Remarks Text 16 -      
UserKey User Int 11 OUSR      
Password Password nVarChar 254 -      
RunDate Next Run Date Date 8 -      
RunTime Next Run Time Int 11 -      
RunCounter Next Run Counter Int 11 - 0    
ReportType Report Type Int 11 - 0 0 Invalid
            115 User Query
            857 Sales/Purchase Analysis
            6000 Inventory Valuation
Active Schedule Active Status VarChar 1 - Y N No
            Y Yes
StartDate Recurrence Start Date Date 8 -      
EndType Recurrence End Type VarChar 1 - N N No End
            C By Counter
            D By Date
EndDate Recurrence End Date Date 8 -      
EndCounter Recurrence End Counter Int 11 - 1    
MissBehav Behavior of Missed Run VarChar 1 - S S Skip
            R Run as Soon as Possible
RcrType Recurrence Type VarChar 1 - N N None
            D Daily
            W Weekly
            M Monthly
            Y Annually
RcrIntervl Recurrence Interval Int 11 - 1    
RcrSubType Recurrence Subtype Int 11 -      
RcrData2 Recurrence: Additional Data 2 Int 11 -      
RcrData1 Recurrence: Additional Data 1 Int 11 -      
ErrAct Action on Error VarChar 1 - 1 D Deactivate Immediately
            C Continue
            1 Deactivate on Second Failure
            2 Deactivate on Third Failure
            3 Deactivate on Fourth Failure
TransfXslt XSLT Transformation Text 16 -      
TimeOut Rpt Creation Time-Out in Min. Int 11 - 5    
MsgTitle Message Title nVarChar 254 -      
MsgBody Message Body nVarChar 254 -      
LicSrvr License Server nVarChar 254 -      
Language Language Int 11 - 3    
LstRunStat Last Run Status VarChar 1 - 0 0 Not yet executed
            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
ErrorCount Number of Failed Runs Int 11 - 0    
PrntLayout Print Layout nVarChar 20 RDOC     Do Not Print
DistLstCod Distribution List Code Int 11 OMLS      
Finished Schedule Finished Status VarChar 1 - N    
SLDAddr SLD Address nVarChar 254 -      
ObjType Object Type nVarChar 20 -      
ObjAbsEnt Object Abs Entry Int 11 -      
OnceAt Once At Int 11 -      
Every Every Int 11 -      
StartAt Starting At Int 11 -      
EndAt Ending At Int 11 -      
DFType Daily Frequency Type VarChar 1 - O O Once
            E Every
            D By Date
Key Unique Field
PRIMARY Yes ActionCode