| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | ActionCode | Action Code | int | 11 | 0 | | | | Allow NULL? |
| 2 | Title | Title | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | Notes | Remarks | text | 16 | 0 | | | | |
| 4 | UserKey | User | int | 11 | 0 | OUSR | | | Allow NULL? |
| 5 | Password | Password | nvarchar | 254 | 0 | | | | Allow NULL? |
| 6 | RunDate | Next Run Date | date | 8 | 0 | | | | |
| 7 | RunTime | Next Run Time | int | 11 | 0 | | | | Allow NULL? |
| 8 | RunCounter | Next Run Counter | int | 11 | 0 | | 0 | | Allow NULL? |
| 9 | ReportType | Report Type | int | 11 | 0 | | 0 | 0=Invalid, 115=User Query, 6000=Inventory Valuation, 857=Sales/Purchase Analysis | Allow NULL? |
| 10 | Active | Schedule Active Status | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 11 | StartDate | Recurrence Start Date | date | 8 | 0 | | | | |
| 12 | EndType | Recurrence End Type | char | 1 | 0 | | N | C=By Counter, D=By Date, N=No End | Allow NULL? |
| 13 | EndDate | Recurrence End Date | date | 8 | 0 | | | | |
| 14 | EndCounter | Recurrence End Counter | int | 11 | 0 | | 1 | | Allow NULL? |
| 15 | MissBehav | Behavior of Missed Run | char | 1 | 0 | | S | R=Run as Soon as Possible, S=Skip | Allow NULL? |
| 16 | RcrType | Recurrence Type | char | 1 | 0 | | N | D=Daily, M=Monthly, N=None, W=Weekly, Y=Annually | Allow NULL? |
| 17 | RcrIntervl | Recurrence Interval | int | 11 | 0 | | 1 | | Allow NULL? |
| 18 | RcrSubType | Recurrence Subtype | int | 11 | 0 | | | | Allow NULL? |
| 19 | RcrData2 | Recurrence: Additional Data 2 | int | 11 | 0 | | | | Allow NULL? |
| 20 | RcrData1 | Recurrence: Additional Data 1 | int | 11 | 0 | | | | Allow NULL? |
| 21 | ErrAct | Action on Error | char | 1 | 0 | | 1 | 1=Deactivate on Second Failure, 2=Deactivate on Third Failure, 3=Deactivate on Fourth Failure, C=Continue, D=Deactivate Immediately | Allow NULL? |
| 22 | TransfXslt | XSLT Transformation | text | 16 | 0 | | | | |
| 23 | TimeOut | Rpt Creation Time-Out in Min. | int | 11 | 0 | | 5 | | Allow NULL? |
| 24 | MsgTitle | Message Title | nvarchar | 254 | 0 | | | | Allow NULL? |
| 25 | MsgBody | Message Body | nvarchar | 254 | 0 | | | | Allow NULL? |
| 26 | LicSrvr | License Server | nvarchar | 254 | 0 | | | | Allow NULL? |
| 27 | Language | Language | int | 11 | 0 | | 3 | | Allow NULL? |
| 28 | LstRunStat | Last Run Status | char | 1 | 0 | | 0 | 0=Not yet executed, D=Unable to distribute result, F=Successfully finished, S=Success, T=SAP Business One client stopped due to time-out, U=The next run date was not updated, X=Unspecified failure | Allow NULL? |
| 29 | ErrorCount | Number of Failed Runs | int | 11 | 0 | | 0 | | Allow NULL? |
| 30 | PrntLayout | Print Layout | nvarchar | 20 | 0 | RDOC | | | Allow NULL? |
| 31 | DistLstCod | Distribution List Code | int | 11 | 0 | OMLS | | | Allow NULL? |
| 32 | Finished | Schedule Finished Status | char | 1 | 0 | | N | | Allow NULL? |
| 33 | SLDAddr | SLD Address | nvarchar | 254 | 0 | | | | Allow NULL? |
| 34 | ObjType | Object Type | nvarchar | 20 | 0 | | | | Allow NULL? |
| 35 | ObjAbsEnt | Object Abs Entry | int | 11 | 0 | | | | Allow NULL? |
| 36 | OnceAt | Once At | int | 11 | 0 | | | | Allow NULL? |
| 37 | Every | Every | int | 11 | 0 | | | | Allow NULL? |
| 38 | StartAt | Starting At | int | 11 | 0 | | | | Allow NULL? |
| 39 | EndAt | Ending At | int | 11 | 0 | | | | Allow NULL? |
| 40 | DFType | Daily Frequency Type | char | 1 | 0 | | O | D=By Date, E=Every, O=Once | Allow NULL? |
